Changes between Version 13 and Version 14 of ZoologyDatabase

Timestamp:

Aug 25, 2011, 5:05:07 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

ZoologyDatabase

@@ -118 +118 @@
 AND !(flags&8192) AND !(flags&16384) AND !(flags&268435456)) AND (cal_psf_mag is not null);
 }}}
+
+== View {{{FalsePositives_AnalysisStage020}}} and {{{TruePositives_AnalysisStage020}}} ==
+ * Consist of "flagged as having a problem" detections (see http://svn.pan-starrs.ifa.hawaii.edu/trac/ipp/wiki/ZoologyInvestigations) '''without''' flag 16384 / EXT_LIMIT 
+ * Built from {{{FalsePositives}}} and TruePositives
+ * How they were built
+{{{
+CREATE VIEW FalsePositives_AnalysisStage020 AS SELECT * from FalsePositives 
+WHERE (!(flags2 & 64) AND !(flags2 & 32) AND !(flags2 & 16) AND !(flags2&8) AND !(flags & 2048) 
+AND !(flags & 4096) AND !(flags&8192) AND !(flags&268435456)) AND (cal_psf_mag is not null);
+
+CREATE VIEW TruePositives_AnalysisStage020 AS SELECT * from TruePositives 
+WHERE (!(flags2 & 64) AND !(flags2 & 32) AND !(flags2 & 16) AND !(flags2&8) AND !(flags & 2048) 
+AND !(flags & 4096) AND !(flags&8192) AND !(flags&268435456)) AND (cal_psf_mag is not null);
+}}}
 = View(s) =