Changes between Version 14 and Version 15 of SA9ndetections

Timestamp:

Oct 10, 2012, 10:55:42 AM (14 years ago)

Author:

heather

Comment:

--

SA9ndetections

@@ -221 +221 @@
 
 how do these get put into psps? ipptopsps grabs n[x] from NCODE in dvo, and ndetections from NMEASURE. This is something to ask Gene about (why NMEASURE sometimes is not equal to sum(NCODE))
+
+Some more investigations:
+
+{{{
+select (ndetections - ng - nr -ni -nz -ny), count(*) from object where ndetections> -999 group by ((ndetections - ng - nr -ni -nz -ny) )
+order by ((ndetections - ng - nr -ni -nz -ny) )
+}}}
+
+This gives a table like this: 
+
+{{{
+diff    count(diff)
+0       14332649
+1       436944
+2       113206
+3       31720
+4       12837
+5       729
+6       1337
+7       78
+8       299
+9       37
+10      5
+11      6
+12      15
+13      2
+22      1
+}}}
+
+lets investigate in my subset of objects. Lets look at where the difference = 8
+
+{{{
+select * from sas9objects2 where ((ndetections - ng - nr -ni -nz -ny) ) = 8 
+}}}
+{{{
+ippobjid        ra                      dec                    ndet    ng      nr      ni       nz      ny
+18915000068213  334.003331264054        0.173672694705413       10      0       0       0       0       2
+18914000071139  333.565131996048        0.0149163575293166      10      0       0       0       0       2
+93274000064190  333.210589389621        -0.823610922500866      10      0       0       0       0       2
+93274000064238  333.213851183943        -0.820473251004263      10      0       0       0       0       2
+93278000058694  333.610383900768        -0.178547334031098      11      0       0       0       0       3
+18916000069421  334.402330333111        0.388832517325818       19      0       0       4       4       3
+93275000078069  333.805282911705        -0.811373935148214      10      0       0       0       0       2
+93274000064493  333.229893419105        -0.807992283581902      10      0       0       0       0       2
+93273000067099  333.017920578856        -0.798191607076108      10      0       0       0       0       2
+18916000071745  334.794921756804        0.621440169464687       10      0       0       0       0       2
+18920000067165  334.698473145177        0.799924706194001       10      0       0       0       0       2
+18920000068631  334.80890851311         0.808805008767286       20      4       0       0       4       4
+93279000050876  333.919744618416        -0.0100643274020041     11      0       0       0       0       3
+}}}
+
+ok. I'm going to grab a couple of them (18915000068213 and 18920000068631) and see what they look like in stackdetectionfull and detectionfull:
+
+
+for 18915000068213:
+
+{{{
+select ippobjid, filterid, instflux, instfluxerr from stackdetectionfull where ippobjid = 18915000068213  order by filterid
+}}}
+
+{{{
+ippobjid       filterid instflux        instfluxerr
+18915000068213  1       1.28959         -999
+18915000068213  1       1.31326         -999
+18915000068213  2       1.42652         -999
+18915000068213  2       1.42781         -999
+18915000068213  3       1.56402         -999
+18915000068213  3       1.66755         -999
+18915000068213  4       3.29652         -999
+18915000068213  4       3.29929         -999
+18915000068213  5       22.7659         4.12512
+18915000068213  5       23.4272         4.06752
+}}}
+
+for 18920000068631
+
+{{{
+select ippobjid, filterid, instflux, instfluxerr from stackdetectionfull where ippobjid = 18920000068631  order by filterid
+}}}
+
+{{{
+ippobjid       filterid instflux         instfluxerr
+18920000068631  1       0.44921         0.729298
+18920000068631  1       0.857526        0.686621
+18920000068631  1       0.905281        0.692741
+18920000068631  1       1.10313         0.753273
+18920000068631  2       1.43996         -999
+18920000068631  2       1.50241         -999
+18920000068631  2       1.50626         -999
+18920000068631  2       1.759           -999
+18920000068631  3       1.56143         -999
+18920000068631  3       1.60222         -999
+18920000068631  3       1.61214         -999
+18920000068631  3       1.66739         -999
+18920000068631  4       2.88612         1.94558
+18920000068631  4       3.2843          1.95199
+18920000068631  4       3.54056         1.91966
+18920000068631  4       3.92929         1.96794
+18920000068631  5       28.1172         4.92211
+18920000068631  5       28.1232         4.99574
+18920000068631  5       28.8979         5.30701
+18920000068631  5       30.4016         5.37306
+}}}
+
+checking detectionfull returns nothing for both of these objects, here are the queries to check: 
+
+{{{
+select ippobjid, filterid, instflux, instfluxerr from detectionfull where ippobjid = 18915000068213  order by filterid
+select ippobjid, filterid, instflux, instfluxerr from detectionfull where ippobjid = 18920000068631  order by filterid
+
+}}}
+
+But, it appears that the missing detections do exist in stackdetectionfull as limiting magnitudes...