clearwing

changeset 204:fee8851842a3

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