| Version 1 (modified by , 17 years ago) ( diff ) |
|---|
#------------------------------------------------------------ # The sequence of steps for building a complete set # of ESSENCE detrend images #------------------------------------------------------------
# # WIPE AWAY AND RESTART 080310 # Use this mysql command to clean out the junk from all detrend tables 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;
# ------------------------------------------------------------ # ppImage.config : MASK FALSE # recipes/rejections.config : Rejections -> 0.0 # filerules-mef.mdc : compression OFF # ------------------------------------------------------------
# # NOTE: maybe using -reduction in the dettool command can relieve the # need for the rejections -> 0.0 step ? # certainly it would keep us from needing to switch MASK to FALSE each time # The compression problems should be resolved in a future release.
# 2003 : BIAS; 09-11; (8 images, hand-picked at random) 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;
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
# 2003 : BIAS; 11-03; (8 images, hand-picked at random) 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
# 2003 : BIAS; 03/10/07; (6 images, special BIAS b/c one cell is different than other times) 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
# 2004 : BIAS (10) 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;
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
# 2005 : BIAS (10) 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;
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
## ## (WAIT FOR BIAS FRAMES TO FINISH BEFORE PROCEEDING) ##
# # PRE-MASK : DARK #
# 2003 : DARK; 09-02; (hand-picked 8 images) 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;
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
# 2004 : PRE-MASK DARK (3) 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;
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
# 2005 : PRE-MASK DARK (6) 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;
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
# ## ## (WAIT FOR DARK FRAMES TO FINISH BEFORE PROCEEDING) ##
# # PRE-MASK : DOME FLAT VR, DOME FLAT R #
# 2003 : (DOME) FLAT VR; (10 images, hand-picked at random) 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;
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
# 2003 : (DOME) FLAT R; (10 images, hand-picked at random) 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;
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
# 2004/5 : PRE-MASK FLAT VR (6) 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;
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
# 2004/5 : PRE-MASK FLAT R 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;
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
# 2005 : NOT ENOUGH DATA FOR FLATS, SO WE USE 2004 DATA
# # ( WAIT FOR PRE-MASK DETRUNS TO FINISH ) #
# ------------------------------------------------------------ # PRE-MASK DETRENDS DONE ==> BUILD MASKS # recipes/rejections.config : Rejections ON # # ( ppImage.config : keep MASK FALSE ) # ( filerules-mef.mdc : keep compression OFF ) # ------------------------------------------------------------
## ## MASKS : DARKMASK, FLATMASK, COMBINED MASK ##
# 2003 : DARKMASK 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; # pick 8 with definebytag 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
# 2003 : FLATMASK VR 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;
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
# 2003 : FLATMASK R
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
# 2004/5 : DARKMASK 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;
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
# 2004/5 : FLATMASK VR 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;
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
# 2004/5 : FLATMASK R 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;
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
# # ( WAIT FOR DARKMASK AND FLATMASK DETRUNS TO FINISH ) #
#COMBINE THREE DETREND MASKS INTO ONE:
# 2003 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
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
# 2004/5 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
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
# # mysql> set the time_begin / end params for the 2003 and 2004/05 masks # set state='drop' for the other masks #
# ------------------------------------------------------------ # MASKS ARE BUILT ==> ACTIVATE MASKING AND COMPRESSION # # ppImage.config : MASK -> TRUE # filerules-mef.mdc : compression -> ON # # ( recipes/rejections.config : keep Rejections ON ) # ------------------------------------------------------------
## ## MAKE SOME FLATS WITH MASKING ACTIVATED ##
# 2003 : (DOME) FLAT VR; (15 images) 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;
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
# 2003 : FLAT R (12 images) 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;
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
# 2003 : FLAT I (12 images) 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;
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
# 2003 : FLAT V (10 images) 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;
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
# 2003 : FLAT U (no images available)
# 2003 : FLAT B (no images available)
# 2004/5 : FLAT VR (10 images) 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;
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
# 2004/5 : FLAT R (10 images) 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;
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
# 2004/5 : FLAT I (10 images) 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;
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
# 2004/5 : FLAT B (10 images) 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;
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
# 2004/5 : FLAT V (10 images) 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;
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
# 2004/5 : FLAT U (no images)
## ## FRINGE FRAMES ##
# 2003 : FRINGE FROM SKY FLATS VR (12 images) 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;
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
# 2003 : FRINGE FROM SKY FLATS R (16 images) 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;
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
# 2003 : FRINGE FROM SKY FLATS I (15 images) 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;
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
# 2003 : FRINGE FROM SKY FLATS V (8 images) 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;
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
