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') ;