Changes between Initial Version and Version 1 of LAP.ThreePi.20110621

Timestamp:

Jul 11, 2011, 2:53:33 PM (15 years ago)

Author:

heather

Comment:

--

LAP.ThreePi.20110621

@@ +1 @@
+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') ;
+