Changes between Version 5 and Version 6 of ZoologyInvestigations

Timestamp:

Aug 24, 2011, 11:58:55 AM (15 years ago)

Author:

rhenders

Comment:

--

ZoologyInvestigations

@@ -77 +77 @@
 I did investigations of flag2 first, because there are fewer of those.  I did cuts to remove 64,32,16,8, since those all had to do with mask, cosmicray, burntool, starspikes (ON_SPIKE, ON_STARCORE, ON_BURNTOOL, ON_CONVPOOR), which are not necessary objects we want to count.
 
-I then cut on DEFECT, SATURATED, CR_LIMIT, EXT_LIMIT, and SIZE_SKIPPED on flag. These seemed like reasonable candidates for flags that maybe should be used to filter out bad detections.
+I then cut the following on the flag field
+
+ * DEFECT
+ * SATURATED
+ * CR_LIMIT
+ * EXT_LIMIT
+ * SIZE_SKIPPED
+
+These seemed like reasonable candidates for flags that maybe should be used to filter out bad detections.
 
 I also did cuts to remove NULL mags (is there any mag which should ALWAYS be calculated? I can cut on that instead of the mag I cut)
@@ -83 +91 @@
 
 Here's what we have left:
-mysql> select count(*), flags, flags2 from DetectionFeatures where (!(flags2 & 64) and !(flags2 & 32) and !(flags2 & 16) and !(flags2&8) and !(flags & 2048) and !(flags & 4096) and !(flags&8192) and !(flags&16384) and !(flags&268435456)) and !(cal_psf_mag is null) group by flags,flags2;
+
+{{{
+select count(*), flags, flags2 
+from DetectionFeatures 
+where (!(flags2 & 64) 
+and !(flags2 & 32) 
+and !(flags2 & 16) 
+and !(flags2&8) 
+and !(flags & 2048) 
+and !(flags & 4096) 
+and !(flags&8192) 
+and !(flags&16384) 
+and !(flags&268435456)) 
+and !(cal_psf_mag is null) 
+group by flags,flags2;
+}}}
+
+Which resulted in:
 
 {{{