IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Initial Version and Version 1 of EssenceDetrendLog


Ignore:
Timestamp:
Feb 24, 2009, 4:23:55 PM (17 years ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • EssenceDetrendLog

    v1 v1  
     1 
     2 #------------------------------------------------------------
     3 #   The sequence of steps for building a complete set
     4 #   of ESSENCE detrend images
     5 #------------------------------------------------------------
     6 
     7 #
     8 #  WIPE AWAY AND RESTART    080310
     9 #  Use this mysql command to clean out the junk from all detrend tables
     10 mysql> truncate detRunSummary; truncate detProcessedExp; truncate detResidExp; truncate detResidImfile; truncate detNormalizedExp; truncate detNormalizedImfile; truncate detNormalizedStatImfile; truncate detStackedImfile; truncate detProcessedImfile; truncate detInputExp; truncate detRegisteredImfile; truncate detRun;
     11         
     12 # ------------------------------------------------------------
     13 #  ppImage.config :            MASK FALSE
     14 #  recipes/rejections.config : Rejections -> 0.0
     15 #  filerules-mef.mdc :         compression OFF
     16 # ------------------------------------------------------------
     17 
     18 #
     19 #  NOTE: maybe using -reduction in the dettool command can relieve the
     20 #        need for the rejections -> 0.0 step ?
     21 #   certainly it would keep us from needing to switch MASK to FALSE each time
     22 #   The compression problems should be resolved in a future release.
     23 
     24 # 2003 : BIAS; 09-11; (8 images, hand-picked at random)
     25 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='zero' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     26 
     27 dettool -definebytag -det_type BIAS -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET/ -telescope BLANCO -inst MOSAIC2 -exp_id 150  -exp_id 159 -exp_id 500  -exp_id 754 -exp_id 1082 -exp_id 1092 -exp_id 1240 -exp_id 1300 -time_begin 2003-08-01T12:00:00 -time_end 2003-11-15T12:00:00 -simple -label BIAS03A
     28 
     29 # 2003 : BIAS; 11-03; (8 images, hand-picked at random)
     30 dettool -definebytag -det_type BIAS -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -exp_id 1674 -exp_id 1815 -exp_id 2071 -exp_id 2217 -exp_id 2340 -exp_id 3130 -exp_id 3825 -exp_id 4071 -time_begin 2003-11-15T12:00:00 -time_end 2004-03-15T12:00:00 -simple -label BIAS03B
     31 
     32 
     33 # 2003 : BIAS; 03/10/07; (6 images, special BIAS b/c one cell is different than other times)
     34 dettool -definebytag -det_type BIAS -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -exp_id 246 -exp_id 247 -exp_id 248 -exp_id 249 -exp_id 250 -time_begin 2003-10-06T12:00:00 -time_end 2003-10-10T12:00:00 -simple -label BIAS03C -registered 2050-02-10T12:00:00
     35 
     36 
     37 # 2004 : BIAS (10)
     38 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='zero' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2005-03-15 00:00:00' ORDER BY dateobs;
     39 
     40 dettool -definebytag -det_type BIAS -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -exp_id 2834  -exp_id 3109 -exp_id 4840  -exp_id 5299 -exp_id 5308 -exp_id 5633 -exp_id 6624 -exp_id 8123 -exp_id 9727 -exp_id 12391 -time_begin 2004-08-01T12:00:00 -time_end 2005-03-15T12:00:00 -simple -label BIAS04
     41 
     42 # 2005 : BIAS (10)
     43 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='zero' AND dateobs>'2005-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     44 
     45 dettool -definebytag -det_type BIAS -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2005/DET -telescope BLANCO -inst MOSAIC2 -exp_id 5910  -exp_id 6255 -exp_id 7741  -exp_id 8629 -exp_id 9011 -exp_id 9017 -time_begin 2005-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label BIAS05
     46 
     47 
     48 ##
     49 ##  (WAIT FOR BIAS FRAMES TO FINISH BEFORE PROCEEDING)
     50 ##
     51 
     52 #
     53 #  PRE-MASK : DARK
     54 #
     55 
     56 
     57 # 2003 : DARK; 09-02; (hand-picked 8 images)
     58 mysql> SELECT exp_id,exp_name,exp_type,exp_time,filter,dateobs FROM rawExp WHERE exp_type='dark' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     59 
     60 dettool -simple -definebytag -det_type DARK -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -exp_id 758 -exp_id 770 -exp_id 767 -exp_id 765 -exp_id 763 -exp_id 761 -exp_id 759 -exp_id 772 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00
     61 
     62 # 2004 : PRE-MASK DARK (3)
     63 mysql> SELECT exp_id,exp_name,exp_type,exp_time,filter,dateobs FROM rawExp WHERE exp_type='dark' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2005-03-15 00:00:00' ORDER BY dateobs;
     64 
     65 dettool -simple -definebyquery -det_type DARK -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -select_exp_type 'dark' -select_dateobs_begin 2004-08-01T12:00:00 -select_dateobs_end 2005-03-15T12:00:00 -time_begin 2004-08-01T12:00:00 -time_end 2005-03-15T12:00:00 -pretend | wc -l
     66 
     67 # 2005 : PRE-MASK DARK (6)
     68 mysql> SELECT exp_id,exp_name,exp_type,exp_time,filter,dateobs FROM rawExp WHERE exp_type='dark' AND dateobs>'2005-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     69 
     70 dettool -simple -definebytag -det_type DARK -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2005/DET -telescope BLANCO -inst MOSAIC2 -exp_id 4852 -exp_id 4859 -exp_id 4863 -exp_id 4834 -exp_id 4839 -exp_id 4846 -time_begin 2005-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -label DARK05
     71 
     72 
     73 #
     74 ##
     75 ##  (WAIT FOR DARK FRAMES TO FINISH BEFORE PROCEEDING)
     76 ##
     77 
     78 #
     79 #  PRE-MASK : DOME FLAT VR, DOME FLAT R
     80 #
     81 
     82 # 2003 : (DOME) FLAT VR; (10 images, hand-picked at random)
     83 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'VR%' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     84 
     85 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -filter VR -exp_id 1 -exp_id 7 -exp_id 171 -exp_id 180 -exp_id 254 -exp_id 1679 -exp_id 1683 -exp_id 2227 -exp_id 2974 -exp_id 4322 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -simple -label PREFLAT03VR
     86 
     87 # 2003 : (DOME) FLAT R; (10 images, hand-picked at random)
     88 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'R%' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     89 
     90 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -filter R -exp_id 10 -exp_id 24 -exp_id 260 -exp_id 514 -exp_id 1685 -exp_id 1690 -exp_id 2229 -exp_id 2233 -exp_id 4328 -exp_id 4329 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -simple -label PREFLAT03R
     91 
     92 # 2004/5 : PRE-MASK FLAT VR (6)
     93 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'VR%' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2005-03-15 00:00:00' ORDER BY dateobs;
     94 
     95 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter VR -exp_id 2865  -exp_id 4643  -exp_id 5048  -exp_id 6200  -exp_id 8018 -exp_id 8023 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label PREFLAT04VR
     96 
     97 # 2004/5 : PRE-MASK FLAT R
     98 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'R%' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2005-03-15 00:00:00' ORDER BY dateobs;
     99 
     100 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter R -exp_id 2898  -exp_id 4623  -exp_id 7981  -exp_id 7991  -exp_id 12324 -exp_id 12329 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label PREFLAT04R
     101 
     102 # 2005 : NOT ENOUGH DATA FOR FLATS, SO WE USE 2004 DATA
     103 
     104 
     105 #
     106 # ( WAIT FOR PRE-MASK DETRUNS TO FINISH )
     107 #
     108 
     109 
     110 # ------------------------------------------------------------
     111 #  PRE-MASK DETRENDS DONE ==> BUILD MASKS
     112 #  recipes/rejections.config : Rejections ON
     113 #
     114 #  ( ppImage.config :            keep MASK FALSE )
     115 #  ( filerules-mef.mdc :         keep compression OFF )
     116 # ------------------------------------------------------------
     117 
     118 ##
     119 ##  MASKS : DARKMASK, FLATMASK, COMBINED MASK
     120 ##
     121 
     122 # 2003 : DARKMASK
     123 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='dark' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     124 # pick 8 with definebytag
     125 dettool -simple -definebytag -det_type DARKMASK -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -exp_id 758 -exp_id 770 -exp_id 767 -exp_id 765 -exp_id 763 -exp_id 761 -exp_id 759 -exp_id 772 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00
     126 
     127 # 2003 : FLATMASK VR
     128 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'VR%' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     129 
     130  dettool -definebytag -det_type FLATMASK -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -exp_id 171 -exp_id 251 -exp_id 1678 -exp_id 2224 -exp_id 4320 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -simple
     131 
     132 # 2003 : FLATMASK R
     133  dettool -definebytag -det_type FLATMASK -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -exp_id 252 -exp_id 513 -exp_id 1690 -exp_id 2233 -exp_id 4327 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -simple
     134 
     135 # 2004/5 : DARKMASK
     136 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='dark' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     137 
     138 dettool -simple -definebytag -det_type DARKMASK -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -exp_id 4870 -exp_id 4864 -exp_id 4859 -exp_id 4865 -exp_id 4850 -exp_id 4841 -exp_id 4846 -exp_id 4832 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00
     139 
     140 # 2004/5 : FLATMASK VR
     141 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'VR%' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     142 
     143 dettool -definebytag -det_type FLATMASK -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter VR -exp_id 2865  -exp_id 4643  -exp_id 5048  -exp_id 6200  -exp_id 8018 -exp_id 8023 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label FLATMASK04VR
     144 
     145 # 2004/5 : FLATMASK R
     146 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'R%' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2005-03-15 00:00:00' ORDER BY dateobs;
     147 
     148 dettool -definebytag -det_type FLATMASK -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter R -exp_id 2898  -exp_id 4623  -exp_id 7981  -exp_id 7991  -exp_id 12324 -exp_id 12329 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label FLATMASK04R
     149 
     150 #
     151 # ( WAIT FOR DARKMASK AND FLATMASK DETRUNS TO FINISH )
     152 #
     153 
     154 #COMBINE THREE DETREND MASKS INTO ONE:
     155 
     156 # 2003
     157 ipp_detrend_combine.pl --det_type MASK --filelevel FPA --inst MOSAIC2 --telescope BLANCO --det_id1 14 --iteration1 0 --det_id2 15 --iteration2 0 --workdir file://data/ipp003.0/rodney/sresswork/2003/DET --operation '|' --mask > /data/ipp003.0/rodney/sresswork/2003/DET/MOSAIC2.19.0.MASKCOMBINE.log
     158 
     159 ipp_detrend_combine.pl --det_type MASK --filelevel FPA --inst MOSAIC2 --telescope BLANCO --det_id1 13 --iteration1 0 --det_id2 19 --iteration2 0 --workdir file://data/ipp003.0/rodney/sresswork/2003/DET --operation '|' --mask > /data/ipp003.0/rodney/sresswork/2003/DET/MOSAIC2.20.0.MASKCOMBINE.log
     160 
     161 
     162 # 2004/5
     163 ipp_detrend_combine.pl --det_type MASK --filelevel FPA --inst MOSAIC2 --telescope BLANCO --det_id1 17 --iteration1 0 --det_id2 18 --iteration2 0 --workdir file://data/ipp003.0/rodney/sresswork/2004/DET --operation '|' --mask > /data/ipp003.0/rodney/sresswork/2004/DET/MOSAIC2.21.0.MASKCOMBINE.log
     164 
     165 ipp_detrend_combine.pl --det_type MASK --filelevel FPA --inst MOSAIC2 --telescope BLANCO --det_id1 16 --iteration1 0 --det_id2 21 --iteration2 0 --workdir file://data/ipp003.0/rodney/sresswork/2004/DET --operation '|' --mask > /data/ipp003.0/rodney/sresswork/2004/DET/MOSAIC2.22.0.MASKCOMBINE.log
     166 
     167 #
     168 #  mysql>   set the time_begin / end params for the 2003 and 2004/05 masks
     169 #           set state='drop' for the other masks
     170 #
     171 
     172 
     173 # ------------------------------------------------------------
     174 #  MASKS ARE BUILT  ==> ACTIVATE MASKING AND COMPRESSION
     175 #
     176 #  ppImage.config :            MASK -> TRUE
     177 #  filerules-mef.mdc :         compression -> ON
     178 #
     179 #  ( recipes/rejections.config : keep Rejections ON )
     180 # ------------------------------------------------------------
     181 
     182 
     183 ##
     184 ##  MAKE SOME FLATS WITH MASKING ACTIVATED
     185 ##
     186 
     187 # 2003 : (DOME) FLAT VR; (15 images)
     188 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'VR%' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     189 
     190  dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -filter VR -exp_id 2    -exp_id 6    -exp_id 8    -exp_id 173  -exp_id 180 -exp_id 251  -exp_id 256  -exp_id 1679 -exp_id 1681 -exp_id 2225 -exp_id 2227 -exp_id 2974 -exp_id 2977 -exp_id 4322 -exp_id 4324 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -simple -label FLAT03VR
     191 
     192 # 2003 : FLAT R (12 images)
     193 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'R%' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     194 
     195 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -filter R -exp_id 10   -exp_id 12   -exp_id 253  -exp_id 259  -exp_id 512 -exp_id 513  -exp_id 1686 -exp_id 1688 -exp_id 2229 -exp_id 2231 -exp_id 4326 -exp_id 4328 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -simple -label FLAT03R
     196 
     197 # 2003 : FLAT I (12 images)
     198 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'I%' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     199 
     200 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -filter I -exp_id 27   -exp_id 28   -exp_id 262  -exp_id 264  -exp_id 1693 -exp_id 1697 -exp_id 2235 -exp_id 2237 -exp_id 3728 -exp_id 3730 -exp_id 4330 -exp_id 4331 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -simple -label FLAT03I
     201 
     202 # 2003 : FLAT V (10 images)
     203 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'V %' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     204 
     205 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -filter V -exp_id 946  -exp_id 948   -exp_id 950  -exp_id 1701  -exp_id 1703 -exp_id 2109 -exp_id 2110 -exp_id 2739 -exp_id 2743 -exp_id 2747 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -simple -label FLAT03V
     206 
     207 # 2003 : FLAT U (no images available)
     208 
     209 # 2003 : FLAT B (no images available)
     210 
     211 
     212 # 2004/5 : FLAT VR  (10 images)
     213 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'VR%' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     214 
     215 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter VR -exp_id 2864  -exp_id 4643   -exp_id 4645  -exp_id 5050  -exp_id 5052 -exp_id 6200 -exp_id 8018 -exp_id 8023 -exp_id 8029 -exp_id 8031 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label FLAT04VR
     216 
     217 # 2004/5 : FLAT R (10 images)
     218 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'R%' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     219 
     220 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter R -exp_id 2896  -exp_id 2898   -exp_id 4620  -exp_id 4626  -exp_id 7981 -exp_id 7987 -exp_id 12325 -exp_id 12330 -exp_id 4629 -exp_id 5043 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label FLAT04R
     221 
     222 # 2004/5 : FLAT I (10 images)
     223 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'I%' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     224 
     225 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter I -exp_id 2886  -exp_id 2890   -exp_id 4632  -exp_id 4639  -exp_id 8000 -exp_id 8003 -exp_id 8014 -exp_id 12334 -exp_id 12337 -exp_id 12339 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label FLAT04I
     226 
     227 # 2004/5 : FLAT B (10 images)
     228 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'B%' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     229 
     230 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter B -exp_id 2882  -exp_id 3145   -exp_id 3147  -exp_id 3151  -exp_id 4603 -exp_id 4927 -exp_id 4950 -exp_id 7810 -exp_id 7816 -exp_id 12307 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label FLAT04B
     231 
     232 # 2004/5 : FLAT V (10 images)
     233 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='DOME FLAT' AND filter LIKE 'V %' AND dateobs>'2004-08-01 00:00:00' AND dateobs<'2006-03-15 00:00:00' ORDER BY dateobs;
     234 
     235 dettool -definebytag -det_type FLAT -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2004/DET -telescope BLANCO -inst MOSAIC2 -filter V -exp_id 4612  -exp_id 4616   -exp_id 7819  -exp_id 7964  -exp_id 12315 -exp_id 12318 -exp_id 12321 -exp_id 4638 -exp_id 4644 -exp_id 4646 -time_begin 2004-08-01T12:00:00 -time_end 2006-03-15T12:00:00 -simple -label FLAT04V
     236 
     237 
     238 # 2004/5 : FLAT U (no images)
     239 
     240 
     241 ##
     242 ##  FRINGE FRAMES
     243 ##
     244 
     245 # 2003 : FRINGE FROM SKY FLATS  VR (12 images)
     246 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='SKY FLAT' AND filter LIKE 'VR%' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     247 
     248 dettool -simple -definebyquery -det_type FRINGE -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -select_exp_type 'sky flat' -select_filter 'VR SuperMacho c6027' -filter VR -select_dateobs_begin 2003-08-01T12:00:00 -select_dateobs_end 2004-03-15T12:00:00 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -label FRINGE03VR -pretend | wc -l
     249 
     250 
     251 # 2003 : FRINGE FROM SKY FLATS  R (16 images)
     252 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='SKY FLAT' AND filter LIKE 'R%' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     253 
     254 dettool -simple -definebyquery -det_type FRINGE -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -select_exp_type 'sky flat' -select_filter 'R Harris c6004' -filter R -select_dateobs_begin 2003-08-01T12:00:00 -select_dateobs_end 2004-03-15T12:00:00 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -label FRINGE03R -pretend | wc -l
     255 
     256 
     257 # 2003 : FRINGE FROM SKY FLATS  I (15 images)
     258 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='SKY FLAT' AND filter LIKE 'I%' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     259 
     260 dettool -simple -definebyquery -det_type FRINGE -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -select_exp_type 'sky flat' -select_filter 'I c6028' -filter I -select_dateobs_begin 2003-08-01T12:00:00 -select_dateobs_end 2004-03-15T12:00:00 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -label FRINGE03I -pretend | wc -l
     261 
     262 # 2003 : FRINGE FROM SKY FLATS V (8 images)
     263 mysql> SELECT exp_id,exp_name,exp_type,filter,dateobs FROM rawExp WHERE exp_type='SKY FLAT' AND filter LIKE 'V %' AND dateobs>'2003-08-01 00:00:00' AND dateobs<'2004-03-15 00:00:00' ORDER BY dateobs;
     264 
     265 dettool -simple -definebyquery -det_type FRINGE -dbname sress  -filelevel FPA -workdir file://data/ipp003.0/rodney/sresswork/2003/DET -telescope BLANCO -inst MOSAIC2 -select_exp_type 'sky flat' -select_filter 'V Harris c6026' -filter V -select_dateobs_begin 2003-08-01T12:00:00 -select_dateobs_end 2004-03-15T12:00:00 -time_begin 2003-08-01T12:00:00 -time_end 2004-03-15T12:00:00 -label FRINGE03V -pretend | wc -l