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 from detectionFull order by newid() 
select top 100000 ra, dec from stackDetectionFull order by newid() 
select top 100000 ra, dec, batchid from Object order by newid() 

The results (see images below):

md field	det	stack	obj
md01	bad	bad
md02
md03
md04
md05	bad	bad	bad
md06
md07	bad	bad	bad
md08
md09			bad
md10

The images:

md field	detectionFull	stackDetectionFull	object (all)	object (bad batchid)
md01
md02
md03
md04
md05
md06
md07
md08
md09
md10