Index: /tags/ipp-20110218/ippconfig/recipes/dqStatsTool.config =================================================================== --- /tags/ipp-20110218/ippconfig/recipes/dqStatsTool.config (revision 31081) +++ /tags/ipp-20110218/ippconfig/recipes/dqStatsTool.config (revision 31082) @@ -10,33 +10,35 @@ RULETYPE STR STRICT END +# CZW: 2011-02-09 All deteff values in the database currently report values 1.85 mag less sensitive than reality. # CDF data generated from the data in camRun with non-NULL deteff values. # CZW: How I did this so I can remember next time. # echo "select zpt_obs,fwhm_major,deteff from camProcessedExp JOIN camRun USING (cam_id) JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.label LIKE '%.nightlyscience' AND quality = 0 AND filter = 'FILTER';" | sed 's/FILTER/g.00000/' | mysql -h ippdb01 -u ipp -pipp gpc1 | awk '{print($3)}' | grep -v deteff | grep -v NULL | mk_cdf.pl | awk '{print($2,$1)}' | spline - `echo 0.0 0.05 0.1 0.15 0.2 0.25 0.3 0.35 0.4 0.45 0.5 0.55 0.6 0.65 0.7 0.75 0.8 0.85 0.9 0.95 0.99 1.0` +# CZW: 2011-03-10 We've been off the sky too much to get much new science data. I've added the ThreePi.136 reprocessing to this to help gri RULE METADATA COLNAME STR DETEFF RULETYPE STR CDF FILTER STR g.00000 - CDF00 F32 13.0214 - CDF05 F32 18.4582 - CDF10 F32 18.8631 - CDF15 F32 19.1020 - CDF20 F32 19.3304 - CDF25 F32 19.4613 - CDF30 F32 19.5324 - CDF35 F32 19.6094 - CDF40 F32 19.6878 - CDF45 F32 19.7477 - CDF50 F32 19.8058 - CDF55 F32 19.8737 - CDF60 F32 19.9409 - CDF65 F32 20.0108 - CDF70 F32 20.0860 - CDF75 F32 20.1694 - CDF80 F32 20.2681 - CDF85 F32 20.3974 - CDF90 F32 20.5609 - CDF95 F32 20.7193 - CDF99 F32 20.9785 - CDF100 F32 21.6135 + CDF00 F32 20.199000 + CDF05 F32 21.471400 + CDF10 F32 21.725000 + CDF15 F32 21.857800 + CDF20 F32 21.918700 + CDF25 F32 21.976500 + CDF30 F32 22.020800 + CDF35 F32 22.062900 + CDF40 F32 22.104200 + CDF45 F32 22.136400 + CDF50 F32 22.173500 + CDF55 F32 22.210900 + CDF60 F32 22.243500 + CDF65 F32 22.280600 + CDF70 F32 22.317500 + CDF75 F32 22.360300 + CDF80 F32 22.405100 + CDF85 F32 22.453400 + CDF90 F32 22.508500 + CDF95 F32 22.575100 + CDF99 F32 22.715100 + CDF100 F32 22.992000 END RULE METADATA @@ -44,26 +46,26 @@ RULETYPE STR CDF FILTER STR r.00000 - CDF00 F32 13.0000 - CDF05 F32 17.9079 - CDF10 F32 18.4030 - CDF15 F32 18.7973 - CDF20 F32 19.0507 - CDF25 F32 19.2644 - CDF30 F32 19.4433 - CDF35 F32 19.5680 - CDF40 F32 19.6728 - CDF45 F32 19.7609 - CDF50 F32 19.8393 - CDF55 F32 19.9125 - CDF60 F32 19.9751 - CDF65 F32 20.0395 - CDF70 F32 20.0926 - CDF75 F32 20.1673 - CDF80 F32 20.2457 - CDF85 F32 20.3496 - CDF90 F32 20.4967 - CDF95 F32 20.7552 - CDF99 F32 21.2945 - CDF100 F32 21.6046 + CDF00 F32 16.424200 + CDF05 F32 20.942300 + CDF10 F32 21.219600 + CDF15 F32 21.432500 + CDF20 F32 21.605300 + CDF25 F32 21.731400 + CDF30 F32 21.803200 + CDF35 F32 21.890000 + CDF40 F32 21.954700 + CDF45 F32 22.006200 + CDF50 F32 22.052200 + CDF55 F32 22.098400 + CDF60 F32 22.132500 + CDF65 F32 22.163900 + CDF70 F32 22.198400 + CDF75 F32 22.229200 + CDF80 F32 22.267200 + CDF85 F32 22.307500 + CDF90 F32 22.356100 + CDF95 F32 22.419900 + CDF99 F32 22.555900 + CDF100 F32 22.870400 END RULE METADATA @@ -71,53 +73,54 @@ RULETYPE STR CDF FILTER STR i.00000 - CDF00 F32 16.4751 - CDF05 F32 18.3041 - CDF10 F32 18.5018 - CDF15 F32 18.6497 - CDF20 F32 18.7602 - CDF25 F32 18.8521 - CDF30 F32 18.9267 - CDF35 F32 19.0105 - CDF40 F32 19.0948 - CDF45 F32 19.1563 - CDF50 F32 19.2215 - CDF55 F32 19.296 - CDF60 F32 19.3689 - CDF65 F32 19.4438 - CDF70 F32 19.5261 - CDF75 F32 19.6127 - CDF80 F32 19.7071 - CDF85 F32 19.8518 - CDF90 F32 20.0447 - CDF95 F32 20.5386 - CDF99 F32 21.1344 - CDF100 F32 21.5592 - END + CDF00 F32 15.811400 + CDF05 F32 20.082600 + CDF10 F32 20.829900 + CDF15 F32 21.044500 + CDF20 F32 21.163700 + CDF25 F32 21.256500 + CDF30 F32 21.343700 + CDF35 F32 21.412300 + CDF40 F32 21.474900 + CDF45 F32 21.533000 + CDF50 F32 21.593000 + CDF55 F32 21.658700 + CDF60 F32 21.734000 + CDF65 F32 21.790500 + CDF70 F32 21.861200 + CDF75 F32 21.927400 + CDF80 F32 22.004800 + CDF85 F32 22.103500 + CDF90 F32 22.238100 + CDF95 F32 22.378100 + CDF99 F32 22.489700 + CDF100 F32 22.892300 + END +# Updated with somewhat questionable values due to low numbers of zy data. RULE METADATA COLNAME STR DETEFF RULETYPE STR CDF FILTER STR z.00000 - CDF00 F32 12.1771 - CDF05 F32 17.5262 - CDF10 F32 17.7958 - CDF15 F32 17.9979 - CDF20 F32 18.1753 - CDF25 F32 18.3201 - CDF30 F32 18.4335 - CDF35 F32 18.5478 - CDF40 F32 18.6470 - CDF45 F32 18.7494 - CDF50 F32 18.8370 - CDF55 F32 18.9166 - CDF60 F32 19.0028 - CDF65 F32 19.0912 - CDF70 F32 19.1886 - CDF75 F32 19.2912 - CDF80 F32 19.4137 - CDF85 F32 19.5244 - CDF90 F32 19.6437 - CDF95 F32 19.9135 - CDF99 F32 20.6482 - CDF100 F32 21.0925 + CDF00 F32 14.759100 + CDF05 F32 17.486900 + CDF10 F32 18.923700 + CDF15 F32 19.383900 + CDF20 F32 19.760100 + CDF25 F32 19.950600 + CDF30 F32 20.097300 + CDF35 F32 20.203800 + CDF40 F32 20.286700 + CDF45 F32 20.377800 + CDF50 F32 20.455000 + CDF55 F32 20.527300 + CDF60 F32 20.621800 + CDF65 F32 20.713000 + CDF70 F32 20.787700 + CDF75 F32 20.884300 + CDF80 F32 21.027100 + CDF85 F32 21.183500 + CDF90 F32 21.275500 + CDF95 F32 21.383300 + CDF99 F32 21.577900 + CDF100 F32 21.670700 END RULE METADATA @@ -125,27 +128,28 @@ RULETYPE STR CDF FILTER STR y.00000 - CDF00 F32 11.6109 - CDF05 F32 16.7278 - CDF10 F32 17.0561 - CDF15 F32 17.2778 - CDF20 F32 17.4367 - CDF25 F32 17.5495 - CDF30 F32 17.6469 - CDF35 F32 17.7392 - CDF40 F32 17.8160 - CDF45 F32 17.8927 - CDF50 F32 17.9779 - CDF55 F32 18.0514 - CDF60 F32 18.1292 - CDF65 F32 18.2153 - CDF70 F32 19.2903 - CDF75 F32 18.3627 - CDF80 F32 18.4325 - CDF85 F32 18.5321 - CDF90 F32 18.6403 - CDF95 F32 18.7523 - CDF99 F32 18.8892 - CDF100 F32 19.064 - END + CDF00 F32 14.606500 + CDF05 F32 17.436900 + CDF10 F32 18.090700 + CDF15 F32 18.350700 + CDF20 F32 18.549300 + CDF25 F32 18.727300 + CDF30 F32 18.934300 + CDF35 F32 19.140200 + CDF40 F32 19.294800 + CDF45 F32 19.400400 + CDF50 F32 19.493000 + CDF55 F32 19.564800 + CDF60 F32 19.665600 + CDF65 F32 19.744900 + CDF70 F32 19.821300 + CDF75 F32 19.900400 + CDF80 F32 20.005400 + CDF85 F32 20.087600 + CDF90 F32 20.148200 + CDF95 F32 20.220300 + CDF99 F32 20.365800 + CDF100 F32 20.594900 + END +# Not updated on 2011-03-28 due to insufficient w data. RULE METADATA COLNAME STR DETEFF @@ -235,4 +239,5 @@ TYPE VAL TABLE ENTRY DATATYPE COLNAME COLUMN VAL rawExp exp_name PS_DATA_STRING EXPNAME # Exposure name + COLUMN VAL rawExp camera PS_DATA_STRING CAMERA # The camera for this exposure COLUMN VAL rawExp dateobs PS_DATA_TIME DATEOBS # Date of observation COLUMN VAL rawExp filter PS_DATA_STRING FILTER # Filter used