## clearwing

### changeset 204:fee8851842a3

find changesets by author, revision,
files, or words in the commit message

Fixes to known issues

author | Nicholas Cross <njc@roe.ac.uk> |
---|---|

date | Tue May 23 09:58:10 2017 +0100 (2017-05-23) |

parents | 333881239204 |

children | 5d84a6bbe6cd |

files | src/templates/knownIssues.html |

line diff

1.1 --- a/src/templates/knownIssues.html Fri May 19 12:12:22 2017 +0100 1.2 +++ b/src/templates/knownIssues.html Tue May 23 09:58:10 2017 +0100 1.3 @@ -116,18 +116,13 @@ 1.4 1.5 1.6 </p> 1.7 - <a name="#obSelNotUsed"></a><em>r-band observations arranged by time rather than OB in vphasSource table</em> 1.8 - 1.9 - <h2>8. <a name="Contemporary colours">Selecting contemporary colours</a></h2> 1.10 - 1.11 + <a name="obSelNotUsed"></a><em>r-band observations arranged by time rather than OB in vphasSource table</em> 1.12 <p> 1.13 1.14 - 1.15 In current VPHAS+ releases, VPHASDR3 (VPHASv20170222) and earlier, a mistake in the processing meant 1.16 that band-merging was not done with the expected OB constraints. This means that r_1 is the earliest 1.17 r frame in a pointing, not the one associated with the ugr epoch and r_2 is the latest, not the one 1.18 - associated with the riHa epoch. To select data such that the contemporary bands and colours are as 1.19 - expected, use the following type of query: 1.20 + associated with the riHa epoch. To select data such that colours are from contemporaneous bands and the band order is as expected, use the following type of query: 1.21 1.22 1.23 1.24 @@ -139,9 +134,9 @@ 1.25 ELSE-9.99995E8 END AS rmhavphasPntErr,u.mjdObs as uMjd,g.mjdObs as 1.26 gMjd,r_1.mjdObs as r_1Mjd,r_2.mjdObs as r_2Mjd,i.mjdObs as iMjd,ha.mjdObs as havphasMjd, 1.27 uAperMag3,uAperMag3Err,gAperMag3,gAperMag3Err,r_1AperMag3,r_1AperMag3Err,r_2AperMag3, 1.28 - r_2AperMag3Err,iAperMag3,iAperMag3Err,havphasAperMag3,havphasAperMag3Err<br> 1.29 + r_2AperMag3Err,iAperMag3,iAperMag3Err,havphasAperMag3,havphasAperMag3Err 1.30 FROM vphasMergeLog as l,vphasSource as s,Multiframe as u,Multiframe as g, 1.31 - Multiframe as r_1,Multiframe as r_2,Multiframe as i,Multiframe as ha<br> 1.32 + Multiframe as r_1,Multiframe as r_2,Multiframe as i,Multiframe as ha 1.33 WHERE s.frameSetID=l.frameSetID and l.umfID=u.multiframeID and 1.34 l.gmfID=g.multiframeID and l.r_1mfID=r_1.multiframeID and 1.35 l.r_2mfID=r_2.multiframeID and l.imfID=i.multiframeID and 1.36 @@ -150,8 +145,8 @@ 1.37 ((u.mjdObs>0 and r_1.mjdObs>0 and abs(u.mjdObs-r_1.mjdObs)<0.3) or 1.38 (g.mjdObs>0 and r_1.mjdObs>0 and abs(g.mjdObs-r_1.mjdObs)<0.3) 1.39 or (i.mjdObs>0 and r_2.mjdObs>0 and abs(i.mjdObs-r_2.mjdObs)<0.3) 1.40 - or (ha.mjdObs>0 and r_2.mjdObs>0 and abs(ha.mjdObs-r_2.mjdObs)<0.3))<br> 1.41 - UNION<br> 1.42 + or (ha.mjdObs>0 and r_2.mjdObs>0 and abs(ha.mjdObs-r_2.mjdObs)<0.3)) 1.43 + UNION 1.44 SELECT s.sourceID,umgPnt,umgPntErr,gmr_2Pnt as gmrPnt,gmr_2PntErr as 1.45 gmrPntErr,r_1miPnt as rmiPnt,r_1miPntErr as rmiPntErr,CASE WHEN 1.46 r_1AperMag3>0. AND havphasAperMag3>0. THEN (r_1AperMag3-havphasAperMag3) 1.47 @@ -163,9 +158,9 @@ 1.48 as havphasMjd, uAperMag3,uAperMag3Err,gAperMag3,gAperMag3Err,r_2AperMag3 as 1.49 r_1AperMag3,r_2AperMag3Err as r_1AperMag3Err, r_1AperMag3 as 1.50 r_2AperMag3,r_1AperMag3Err as 1.51 - r_2AperMag3Err,iAperMag3,iAperMag3Err,havphasAperMag3,havphasAperMag3Err<br> 1.52 + r_2AperMag3Err,iAperMag3,iAperMag3Err,havphasAperMag3,havphasAperMag3Err 1.53 FROM vphasMergeLog as l,vphasSource as s,Multiframe as u,Multiframe as 1.54 - g,Multiframe as r_1,Multiframe as r_2,Multiframe as i,Multiframe as ha<br> 1.55 + g,Multiframe as r_1,Multiframe as r_2,Multiframe as i,Multiframe as ha< 1.56 WHERE s.frameSetID=l.frameSetID and l.umfID=u.multiframeID and 1.57 l.gmfID=g.multiframeID and l.r_1mfID=r_1.multiframeID and 1.58 l.r_2mfID=r_2.multiframeID and l.imfID=i.multiframeID and 1.59 @@ -174,8 +169,8 @@ 1.60 ((u.mjdObs>0 and r_2.mjdObs>0 and abs(u.mjdObs-r_2.mjdObs)<0.3) or 1.61 (g.mjdObs>0 and r_2.mjdObs>0 and abs(g.mjdObs-r_2.mjdObs)<0.3) 1.62 or (i.mjdObs>0 and r_1.mjdObs>0 and abs(i.mjdObs-r_1.mjdObs)<0.3) 1.63 - or (ha.mjdObs>0 and r_1.mjdObs>0 and abs(ha.mjdObs-r_1.mjdObs)<0.3))<br> 1.64 - UNION<br> 1.65 + or (ha.mjdObs>0 and r_1.mjdObs>0 and abs(ha.mjdObs-r_1.mjdObs)<0.3)) 1.66 + UNION 1.67 SELECT s.sourceID,umgPnt,umgPntErr,gmr_1Pnt as gmrPnt,gmr_1PntErr as 1.68 gmrPntErr,r_2miPnt as rmiPnt,r_2miPntErr as rmiPntErr,CASE WHEN 1.69 r_2AperMag3>0. AND havphasAperMag3>0. THEN (r_2AperMag3-havphasAperMag3) 1.70 @@ -186,9 +181,9 @@ 1.71 gMjd,r_1.mjdObs as r_1Mjd,r_2.mjdObs as r_2Mjd,i.mjdObs as iMjd,ha.mjdObs 1.72 as havphasMjd, 1.73 uAperMag3,uAperMag3Err,gAperMag3,gAperMag3Err,r_1AperMag3,r_1AperMag3Err,r_2 1.74 - AperMag3,r_2AperMag3Err,iAperMag3,iAperMag3Err,havphasAperMag3,havphasAperMag3Err<br> 1.75 + AperMag3,r_2AperMag3Err,iAperMag3,iAperMag3Err,havphasAperMag3,havphasAperMag3Err 1.76 FROM vphasMergeLog as l,vphasSource as s,Multiframe as u,Multiframe as 1.77 - g,Multiframe as r_1,Multiframe as r_2,Multiframe as i,Multiframe as ha<br> 1.78 + g,Multiframe as r_1,Multiframe as r_2,Multiframe as i,Multiframe as ha 1.79 WHERE s.frameSetID=l.frameSetID and l.umfID=u.multiframeID and 1.80 l.gmfID=g.multiframeID and l.r_1mfID=r_1.multiframeID and 1.81 l.r_2mfID=r_2.multiframeID and l.imfID=i.multiframeID and