Changes between Version 24 and Version 25 of ZoologyInvestigations

Timestamp:

Aug 26, 2011, 3:54:06 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

ZoologyInvestigations

@@ -230 +230 @@
 = Answers to A-014 =
 
-
+== Counting the detection with "exclusion" flags ==
+
+|| count(*) || 1315247 || 917726 || 397521 || ||
+|| From flags ||
+|| Flag || DetectionFeatures || TruePositives || FalsePositives || MySQL Statement ||
+|| DEFECT || 3204 || 1183 || 2021 || WHERE (flags & 0x800) ||
+|| SATURATED || 0 || 0 || 0 ||  WHERE (flags & 0x1000) ||
+|| MOMENTS_FAILURE || 38398 || 11386 || 27012 || WHERE (flags & 0x8000) ||
+|| BIG_RADIUS || 0 || 0 || 0 ||  WHERE (flags & 0x80000) ||
+|| AP_MAGS || 806 || 736 || 70 || WHERE (flags & 0x100000) ||
+|| SIZE_SKIPPED || 1312043 || 916543 || 395500 || WHERE (flags & 0x8000000) || '''?!'''
+|| ON_SPIKE || 39125 || 11491 || 27634 || WHERE (flags & 0x10000000) ||
+|| ON_GHOST || 0 || 0 || 0 || WHERE (flags & 0x20000000) ||
+|| OFF_CHIP || 0 || 0 || 0 || WHERE (flags & 0x40000000) ||
+|| From flags2 ||
+|| ON_SPIKE || 699 || 130 || 569 || WHERE (flags2 & 0x8) ||
+|| ON_BURNTOOL || 2293 || 812 || 1481 || WHERE (flags2 & 0x10) ||
+
+== Are there any detection where FITFAIL (0x8) is set and FITTED (0x4) is not? ==
+{{{
+SELECT count(*) FROM <Table> WHERE (flags & 0x8) AND NOT (flags & 0x4);
+}}}
+
+|| DetectionFeatures || TruePositives || FalsePositives ||
+|| 1755 || 1621 || 134 ||
+
+== EXTERNALPOS, CR_LIMIT, SKY_FAILURE, SKYVAR_FAILURE, MOMENTS_SN should always be 0 ==
+
+|| Flag || DetectionFeatures || TruePositives || FalsePositives || MySQL Statement ||
+|| EXTERNALPOS || 0 || 0 || 0 || WHERE (flags & 0x200) ||
+|| CR_LIMIT || 750 || 168 || 582 || WHERE (flags & 0x2000) ||
+|| SKY_FAILURE || 0 || 0 || 0 || WHERE (flags & 0x10000) ||
+|| SKYVAR_FAILURE || 0 || 0 || 0 || WHERE (flags & 0x20000) ||
+|| MOMENTS_SN || 0 || 0 || 0 || WHERE (flags & 0x40000) ||
 = Conclusions =