Changes between Initial Version and Version 1 of Psps_MD_PV2_112814

Timestamp:

Nov 28, 2014, 5:55:56 PM (12 years ago)

Author:

heather

Comment:

--

Psps_MD_PV2_112814

@@ +1 @@
+== This is the current status of MDs on PSPS on 11-28-2014 ==
+
+== Plots of coverage ==
+
+I did a selection of random 100,000 ras and decs from detectionFull, stackDetectionFull, and Object for each field. The results are plotted below, you can click on the image to make it bigger.
+
+the queries I used for each MD (on production cluster):
+{{{
+select top 100000 ra, dec, batchid from detectionFull order by newid() 
+select top 100000 ra, dec from stackDetectionFull order by newid() 
+select top 100000 ra, dec from Object order by newid() 
+
+}}}
+
+The results (see images below):
+
+
+|| md field || detectionFull || stackDetectionFull ||object (all) || object (bad batchid) ||
+|| md01 || [[Image(md01det.png,200px)]] || [[Image(md01stk.png,200px)]] ||[[Image(md01ob20141128.png,200px)]]  || [[Image(md01ob20141128bad.png,200px)]]  ||  
+|| md02 || [[Image(md02det.png,200px)]] || [[Image(md02stk.png,200px)]] ||[[Image(md02ob20141128.png,200px)]]  ||[[Image(md02ob20141128bad.png,200px)]]  || 
+|| md03 || [[Image(md03det.png,200px)]] || [[Image(md03stk.png,200px)]] ||[[Image(md03ob20141128.png,200px)]]  ||[[Image(md03ob20141128bad.png,200px)]]  || 
+|| md04 || [[Image(md04det.png,200px)]] || [[Image(md04stk.png,200px)]] ||[[Image(md04ob20141128.png,200px)]]  ||[[Image(md04ob20141128bad.png,200px)]]  || 
+|| md05 || [[Image(md05det.png,200px)]] || [[Image(md05stk.png,200px)]] ||[[Image(md05ob20141128.png,200px)]]  ||[[Image(md05ob20141128bad.png,200px)]]  || 
+|| md06 || [[Image(md06det.png,200px)]] || [[Image(md06stk.png,200px)]] ||[[Image(md06ob20141128.png,200px)]]  ||[[Image(md06ob20141128bad.png,200px)]]  || 
+|| md07 || [[Image(md07det.png,200px)]]|| [[Image(md07stk.png,200px)]] ||[[Image(md07ob20141128.png,200px)]]  ||[[Image(md07ob20141128bad.png,200px)]]  || 
+|| md08 || [[Image(md08det.png,200px)]]|| [[Image(md08stk.png,200px)]] ||[[Image(md08ob20141128.png,200px)]]  ||[[Image(md08ob20141128bad.png,200px)]]  || 
+|| md09 ||[[Image(md09det.png,200px)]]  || [[Image(md09stk.png,200px)]] ||[[Image(md09ob20141128.png,200px)]]  ||[[Image(md09ob20141128bad.png,200px)]]  || 
+|| md10 || [[Image(md10det.png,200px)]] || [[Image(md10stk.png,200px)]] ||[[Image(md10ob20141128.png,200px)]]  ||[[Image(md10ob20141128bad.png,200px)]]  || 
+