Changes between Version 5 and Version 6 of SA9ndetections

Timestamp:

Sep 28, 2012, 4:30:56 PM (14 years ago)

Author:

heather

Comment:

--

SA9ndetections

@@ -81 +81 @@
 
 so it's looking (potentially) like the bulk of the stuff is on the edges... hmmm...
+
+range of -999 detections
+
+327.674428      339.401002      -5.56900272534  6.29028233733
+
+range of non -999 detections
+
+328.125006286168        339.785531622512        -5.56905205605347       6.24998288116431
+
+ooookay... lets see how many items are out of range and what they are
+
+{{{
+select  ndetections, count(*) from object where ( ra < 328.125006286168  or ra > 339.785531622512 ) group by ndetections
+}}}
+
+which gives me 
+[ndetections]:Int16     [Column1]:Int32
+-999    60649
+
+ok, so most of those guys are ugh...  out of range...
+
+lets get the batch like thing:
+
+{{{
+select  ippobjid/1000000000 , ndetections, count(*) as n from object where 
+( ra < 328.125006286168  or ra > 339.785531622512  
+or dec > 6.24998288116431 or dec < -5.56905205605347) group by ndetections,ippobjid/1000000000  
+order by n desc
+}}}
+
+
+ippobjid/thing || ndetections || count (*) ||
+||93096 ||      -999 || 7398||
+||18740 ||      -999    ||6601||
+||93092 ||      -999 || 6577||
+||18744 ||      -999    ||6351||
+||93116 ||      -999    ||5752||
+||93120 ||      -999    ||5657||
+||93088 ||      -999    ||3902||
+||93100 ||      -999    ||3866||
+||18768 ||      -999    ||3552||
+||18748 ||      -999    ||3463||
+||93112 ||      -999    ||3323||
+||18756 ||      -999    ||3205||
+||18764 ||      -999    ||231||
+||18986 ||      -999    ||213||
+||93084 ||      -999    ||173||
+||93104 ||      -999    ||121||
+||93108 ||      -999    ||114||
+||18985 ||      -999    ||77||
+||18760 ||      -999    ||38||
+||18752 ||      -999    ||35||
+
+these are the exact same numbers as above - so - '''The -999s almost entirely come from 2 sources.  12300 come from the failed batch, 60649 come from being outside of some range that heather doesn't understand ''' This is a psps problem..
 === ndetections = very large number ===