IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 1 and Version 2 of ZoologyInvestigations


Ignore:
Timestamp:
Aug 23, 2011, 10:53:10 PM (15 years ago)
Author:
heather
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ZoologyInvestigations

    v1 v2  
    66
    77mysql> select count(*), flags, flags2 from DetectionFeatures group by flags;
     8
     9{{{
    810+----------+-----------+--------+
    911| count(*) | flags     | flags2 |
     
    5658+----------+-----------+--------+
    575945 rows in set (1.40 sec)
     60}}}
    5861
    5962Most lump into only a handful of flags.
     
    6871Here's what we have left:
    6972mysql> 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;
     73
     74{{{
    7075+----------+-----------+--------+
    7176| count(*) | flags     | flags2 |
     
    8893+----------+-----------+--------+
    899415 rows in set (0.24 sec)
     95}}}
    9096
    9197for a total of 56558 false detections.
     
    97103The numbers represent the flag setting, and the circles are the remaining false detections.
    98104
     105This is AFTER I did the flag cuts.  Prior to that there were 8x as many detections, often landing on burntools and edges.
    99106 
    100107