Changes between Version 15 and Version 16 of DVO_Conrad_Worksheet

Timestamp:

Jun 21, 2012, 3:54:43 PM (14 years ago)

Author:

conradh

Comment:

--

DVO_Conrad_Worksheet

@@ -97 +97 @@
 == Background ==
    After doing some queries into PSPS, one particular query for data quality is to find instrumental flux values that are equal to zero.  This should not be possible but some small amount of entries were found.
+
+
+Step 0) Find the inaccurate data within PSPS.
+{{{
+SELECT objID,
+       stackDetectID,
+       ippObjID,
+       ippDetectID,
+       ra, dec
+       filterID,
+       instFlux,
+       calMag,
+       instFluxErr,
+       calMagErr
+  INTO mydb.weird_stacks FROM StackDetectionFull
+ WHERE (instFlux <> -999 AND instFlux <= 0 )
+}}}