LAP.ThreePi.20110621 is a dvodb containing anything with the label of LAP.ThreePi.20110621 or LAP.ThreePi.test. addstar/minidvodbs are run and built on ipp005 using the ippdvo account.

The LAP dvodb is located here: /data/ipp005.0/gpc1/catdirs/LAP The LAP minidvodbs are located here: /data/ipp005.0/gpc1/catdirs/LAP.Mini

Currently, all the camera smfs are queued automatically, as are the staticsky cmfs. The staticsky stage, which creates the staticsky cmfs, is not yet a survey task (to be done). Heather queued up the available stacks -> staticskys 07-11-2011, and she will queue them up each day until she writes the survey task.

Status of what's can be queued, and what's in the dvodb:

camera stage

date	addRun (any state)	addRun (full)	camera (all/full)	camera (destreaked)
07-11-2011	1547	1460	4112	1547

staticsky stage

date	addRun (any state)	addRun (full)	stackRun (full/good quality)	stackRun (new state)	staticskyRun (any state)	staticskyRun (full)
07-11-2011	2388	702	2390	1616	2390	2388

• all the available cmfs/smfs have been queued into addRun, and they are getting addstar'd now.
• There are 1616 stacks that are in new state (not able to queue them yet)
• There are 2565 smfs that have not been destreaked (and can't be queued yet)

---

some queries to get these numbers

select count(*) from stackRun where label = 'LAP.ThreePi.20110621' and state = 'new';

select count(*), state from staticskyRun where label = 'LAP.ThreePi.20110621' group by state; select count(*), stage, state from addRun where dvodb = 'LAP.ThreePi.20110621' group by stage, state;

select count(*), state, filter from stackRun join stackSumSkyfile using (stack_id) where label = 'LAP.ThreePi.20110621' and stackSumSkyfile.fault = 0 and stackSumSkyfile.quality = 0 and data_group like '%final%' group by filter, stackRun.state, tess_id;

select count(*) from camRun join camProcessedExp using (cam_id) where (label = 'LAP.ThreePi.20110621' or label = 'LAP.ThreePi.test') and state = 'full';

select count(*) from camRun join camProcessedExp using (cam_id) where magicked > 0 and (label = 'LAP.ThreePi.20110621' or label = 'LAP.ThreePi.test') ;