Changes between Version 9 and Version 10 of SA9ndetections

Timestamp:

Oct 4, 2012, 4:58:17 PM (14 years ago)

Author:

heather

Comment:

--

SA9ndetections

@@ -141 +141 @@
 === ndetections = very large number ===
 
-example:
+this is done on a subset of sas (ra between 333 and 335 and dec  between -1 and 1) to avoid edges. I named this sas9objects2.  Here is a query to find the 10 worst offenders:
 
+{{{
+select top 10 ippobjid, ndetections, ng, nr, ni, nz, ny, ndetections -ng -nr -ni -nz -ny from sas9objects2 order by ndetections desc
+}}}
 
+Here is the result: 
+
+{{{
+[ippobjid]      [ndet]  [ng]    [nr]    [ni]    [nz]    [ny]    [diff]
+93275000002053  123     19      32      33      22      17      0
+18914000000761  122     21      31      24      27      19      0
+18920000002724  118     26      28      24      22      18      0
+93279000002817  116     23      24      22      25      22      0
+18914000001122  115     18      26      25      28      18      0
+93277000000012  107     17      26      20      23      21      0
+18913000000215  107     17      25      19      26      20      0
+18916000003621  106     22      24      15      24      21      0
+18916000003381  105     21      26      18      22      18      0
+18918000000040  105     24      24      17      16      24      0
+}}}
+
+123 detections!?!?! what?!
 === ndetections != ng + nr + ni + nz + ny ===