Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection (revision 37246) @@ -1,4 +1,3 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier detectID dimensionless BIGINT 8 NA ODM detection identifier ippObjID dimensionless BIGINT 8 NA detection id generated by IPP @@ -48,8 +47,8 @@ apFluxErr adu/seconds REAL 4 -999 Aperture flux error apFillF dimensionless REAL 4 -999 Aperture fill factor +apRadius arcsec REAL 4 -999 Aperture radius kronFlux adu/seconds REAL 4 -999 Kron flux kronFluxErr adu/seconds REAL 4 -999 Kron flux error kronRad arcsec REAL 4 -999 Kron radius -kronRadErr arcsec REAL 4 -999 Kron radius error (DROP) sky adu/sec/pixel REAL 4 -999 PSF sky level at source skyErr adu/sec/pixel REAL 4 -999 estimated error in sky @@ -59,2 +58,6 @@ -- -- [231 bytes/det] + +### do we want apRadius? +### relevant code spots: +### config/tables.P2.vot, detectionbatch.py:315 Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt (revision 37246) @@ -1,58 +1,56 @@ -objID = dvo / addstar -gcObjID = dvo / addstar [EAM: add to addstar] -detectID = dvo / addstar -ippObjID = dvo / addstar -ippDetectID = dvo / addstar -filterID = smf / ipptopsps -surveyID = ipptopsps -imageID = smf header -randomDetID = ipptopsps -dvoRegionID = dvo / catID [EAM: add to dvopsps] -obsTime = smf -xPos = smf -yPos = smf -xPosErr = smf [EAM: modify errors to match relastro?] -yPosErr = smf -pltScale = smf -posAngle = smf -----------------= -ra = dvo / relastro -dec = dvo / relastro -raErr = dvo / relastro -decErr = dvo / relastro -zp = dvo / relphot -telluricExt = zp - zpNominal (dvopsps) [EAM: add to dvopsps] -expTime = smf -airMass = smf -----------------= -psfFlux = smf [OK: ipptopsps uses PSF_FLUX] -psfFluxErr = smf -psfMajorFWHM = smf [PSF_MAJOR is Sxx parameter, NOT FWHM] [EAM: add PSF_FWHM_MAJ to smf, keep PSF_MAJOR] -psfMinorFWHM = smf [PSF_MINOR is Sxx parameter, NOT FWHM] [EAM: add PSF_FWHM_MIN to smf, keep PSF_MINOR] -psfTheta = smf -psfCore = smf [EAM: add PSF_CORE to smf] -psfQf = smf -psfQfPerfect = smf -psfChiSq = smf -psfLikelihood = ipptopsps -momentXX = smf -momentXY = smf -momentYY = smf -momentR1 = smf -momentRH = smf [XXX : MOMENTS_RH is NOT half-light radius : keep as MOMENTS_RH or calculate?] -momentM3C = smf -momentM3S = smf -momentM4C = smf -momentM4S = smf -apFlux = smf [requires PS1_V4] -apFluxErr = smf [requires PS1_V4] -apFillF = smf [EAM: add to pmSource and smf] -kronFlux = smf -kronFluxErr = smf -kronRad = (2.5*R1) : Ken : drop this or MOMENTS_R1? -kronRadErr = [not calculated] : drop this -sky = smf -skyErr = smf -infoFlag = smf -infoFlag2 = smf -dataRelease = ippToPsps +objID + dvo = average.extID [calculated in addstar] +detectID + dvo = measure.extID [calculated in addstar] +ippObjID + dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] +ippDetectID + smf:IPP_IDET +filterID + ipptopsps : internal, lookup from filter (grizy) +surveyID + ipptopsps : internal, from survey name +imageID - ipptopsps : expID x y (*** is this right???) (smf:IMAGEID / gpc1.chipRun.chip_image_id)_ +randomDetID + ipptopsps : RANDOM from sql +dvoRegionID + dvo:average.catID +obsTime + smf:MJD-OBS + 0.5 EXPTIME / 84600 +xPos + smf:X_PSF +yPos + smf:Y_PSF +xPosErr + smf:X_PSF_SIG +yPosErr + smf:Y_PSF_SIG +pltScale + smf:PLTSCALE (negative -> sky parity) +posAngle + smf:POSANGLE +--------------- +ra + dvo:measure.ra +dec + dvo:measure.dec +raErr + smf:X_PSF_SIG * abs(PLTSCALE) +decErr + smf:Y_PSF_SIG * abs(PLTSCALE) +zp + dvo / dvopsps : zp +telluricExt + dvo / dvopsps : zp - zpNominal (dvopsps) +expTime + dvo:measure.dt [converted to seconds] +airMass + dvo:measure.airmass +--------------- +psfFlux + smf:PSF_INST_FLUX / EXPTIME +psfFluxErr + smf:PSF_INST_FLUX_SIG / EXPTIME +psfMajorFWHM + smf:PSF_FWHM_MAJ +psfMinorFWHM + smf:PSF_FWHM_MIN +psfTheta + smf:PSF_THETA +psfCore + smf:PSF_CORE +psfQf + smf:PSF_QF +psfQfPerfect + smf:PSF_QF_PERFECT +psfChiSq + smf:PSF_CHISQ +psfLikelihood + smf:psfLikelihood(EXT_NSIGMA) +momentXX + smf:MOMENTS_XX +momentXY + smf:MOMENTS_XY +momentYY + smf:MOMENTS_YY +momentR1 + smf:MOMENTS_R1 +momentRH + smf:MOMENTS_RH +momentM3C + smf:MOMENTS_M3C +momentM3S + smf:MOMENTS_M3S +momentM4C + smf:MOMENTS_M4C +momentM4S + smf:MOMENTS_M4S +apFlux + smf:AP_FLUX +apFluxErr + smf:AP_FLUX_SIG +apFillF + smf:AP_NPIX / (pi * (AP_MAG_RADIUS - 0.5)^2) +kronFlux + smf:KRON_FLUX +kronFluxErr + smf:KRON_FLUX_ERR +kronRad + smf:2.5*MOMENTS_R1 +sky + smf:SKY / exptime +skyErr + smf:SKY_SIGMA / exptime +infoFlag + smf:FLAGS +infoFlag2 + smf:FLAGS2 | (dvo.measure.flags << 13) +dataRelease + ippToPsps : user input (skychunk.dataRelease) Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (revision 37246) @@ -0,0 +1,47 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier +detectID dimensionless BIGINT 8 NA ODM detection identifier +ippObjID dimensionless BIGINT 8 NA ippobject id generated by IPP +ippDetectID dimensionless BIGINT 8 NA detection id generated by IPP +filterID dimensionless TINYINT 1 NA filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ... +surveyID dimensionless TINYINT 1 NA survey flag identifier +forcedWarpID dimensionless BIGINT 8 NA IPP warp_id +randomWarpID dimensionless BIGINT 8 NA Random warp_id +skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region +obsTime MeanJulianDays FLOAT 8 -999 Time of mid observation in Mean Julian Days +------------------------------------------------------ +lensObjSmearX11 arcsec^-2 REAL 4 -999 per-object smear polarizability X11 term +lensObjSmearX12 arcsec^-2 REAL 4 -999 per-object smear polarizability X12 term +lensObjSmearX22 arcsec^-2 REAL 4 -999 per-object smear polarizability X22 term +lensObjSmearE1 arcsec^-2 REAL 4 -999 per-object smear polarizability E1 term +lensObjSmearE2 arcsec^-2 REAL 4 -999 per-object smear polarizability E2 term +lensObjShearX11 dimensionless REAL 4 -999 per-object shear polarizability X11 term +lensObjShearX12 dimensionless REAL 4 -999 per-object shear polarizability X12 term +lensObjShearX22 dimensionless REAL 4 -999 per-object shear polarizability X22 term +lensObjShearE1 dimensionless REAL 4 -999 per-object shear polarizability E1 term +lensObjShearE2 dimensionless REAL 4 -999 per-object shear polarizability E2 term +lensPSFSmearX11 arcsec^-2 REAL 4 -999 psf model smear polarizability X11 term +lensPSFSmearX12 arcsec^-2 REAL 4 -999 psf model smear polarizability X12 term +lensPSFSmearX22 arcsec^-2 REAL 4 -999 psf model smear polarizability X22 term +lensPSFSmearE1 arcsec^-2 REAL 4 -999 psf model smear polarizability E1 term +lensPSFSmearE2 arcsec^-2 REAL 4 -999 psf model smear polarizability E2 term +lensPSFShearX11 dimensionless REAL 4 -999 psf model shear polarizability X11 term +lensPSFShearX12 dimensionless REAL 4 -999 psf model shear polarizability X12 term +lensPSFShearX22 dimensionless REAL 4 -999 psf model shear polarizability X22 term +lensPSFShearE1 dimensionless REAL 4 -999 psf model shear polarizability E1 term +lensPSFShearE2 dimensionless REAL 4 -999 psf model shear polarizability E2 term +------------------------------------------------------ +flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 +flxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 +flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 +flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 +flxR6Err adu/seconds REAL 4 -999 estimated error is flxR6 +flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in flxR6 +flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +------------------------------------------------------ + +-- [295 byte/det] +-- this table is only for non-Galatic-plane data Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (revision 37246) @@ -0,0 +1,44 @@ + +objID = dvo/addstar +gcObjID = dvo/addstar +detectID = dvo/addstar +ippObjID = dvo/addstar +ippDetectID = dvo/addstar +filterID = +surveyID = +forcedWarpID = +randomWarpID = +skyCellID = +dvoRegionID = +obsTime = smf +---------------- = +lensObjSmearX11 = smf [PS1_V5] +lensObjSmearX12 = smf [PS1_V5] +lensObjSmearX22 = smf [PS1_V5] +lensObjSmearE1 = smf [PS1_V5] +lensObjSmearE2 = smf [PS1_V5] +lensObjShearX11 = smf [PS1_V5] +lensObjShearX12 = smf [PS1_V5] +lensObjShearX22 = smf [PS1_V5] +lensObjShearE1 = smf [PS1_V5] +lensObjShearE2 = smf [PS1_V5] +lensPSFSmearX11 = smf [PS1_V5] +lensPSFSmearX12 = smf [PS1_V5] +lensPSFSmearX22 = smf [PS1_V5] +lensPSFSmearE1 = smf [PS1_V5] +lensPSFSmearE2 = smf [PS1_V5] +lensPSFShearX11 = smf [PS1_V5] +lensPSFShearX12 = smf [PS1_V5] +lensPSFShearX22 = smf [PS1_V5] +lensPSFShearE1 = smf [PS1_V5] +lensPSFShearE2 = smf [PS1_V5] +---------------- = +flxR5 = smf [?? calculated?] +flxR5Err = smf [?? calculated?] +flxR5Std = smf [?? calculated?] +flxR5Fill = smf [?? calculated?] +flxR6 = smf [?? calculated?] +flxR6Err = smf [?? calculated?] +flxR6Std = smf [?? calculated?] +flxR6Fill = smf [?? calculated?] +---------------- = Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 37246) @@ -1,2 +1,3 @@ + objID dimensionless BIGINT 8 NA ODM object identifier gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier @@ -37,25 +38,4 @@ momentM4S arcsec^4 REAL 4 -999 4th moment cos(theta) -lensObjSmearX11 arcsec^-2 REAL 4 -999 per-object smear polarizability X11 term -lensObjSmearX12 arcsec^-2 REAL 4 -999 per-object smear polarizability X12 term -lensObjSmearX22 arcsec^-2 REAL 4 -999 per-object smear polarizability X22 term -lensObjSmearE1 arcsec^-2 REAL 4 -999 per-object smear polarizability E1 term -lensObjSmearE2 arcsec^-2 REAL 4 -999 per-object smear polarizability E2 term -lensObjShearX11 dimensionless REAL 4 -999 per-object shear polarizability X11 term -lensObjShearX12 dimensionless REAL 4 -999 per-object shear polarizability X12 term -lensObjShearX22 dimensionless REAL 4 -999 per-object shear polarizability X22 term -lensObjShearE1 dimensionless REAL 4 -999 per-object shear polarizability E1 term -lensObjShearE2 dimensionless REAL 4 -999 per-object shear polarizability E2 term -lensPSFSmearX11 arcsec^-2 REAL 4 -999 psf model smear polarizability X11 term -lensPSFSmearX12 arcsec^-2 REAL 4 -999 psf model smear polarizability X12 term -lensPSFSmearX22 arcsec^-2 REAL 4 -999 psf model smear polarizability X22 term -lensPSFSmearE1 arcsec^-2 REAL 4 -999 psf model smear polarizability E1 term -lensPSFSmearE2 arcsec^-2 REAL 4 -999 psf model smear polarizability E2 term -lensPSFShearX11 dimensionless REAL 4 -999 psf model shear polarizability X11 term -lensPSFShearX12 dimensionless REAL 4 -999 psf model shear polarizability X12 term -lensPSFShearX22 dimensionless REAL 4 -999 psf model shear polarizability X22 term -lensPSFShearE1 dimensionless REAL 4 -999 psf model shear polarizability E1 term -lensPSFShearE2 dimensionless REAL 4 -999 psf model shear polarizability E2 term - apFlux adu/seconds REAL 4 -999 Aperture flux apFluxErr adu/seconds REAL 4 -999 Aperture flux error @@ -66,13 +46,4 @@ kronRadErr arcsed REAL 4 -999 Kron radius error ------------------------------------------------------ -flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -flxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 -flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 -flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 -flxR6Err adu/seconds REAL 4 -999 estimated error is flxR6 -flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in flxR6 -flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 ------------------------------------------------------- sky adu/sec/pixel REAL 4 -999 PSF sky level at source skyErr adu/sec/pixel REAL 4 -999 estimated error in sky Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt (revision 37246) @@ -38,25 +38,4 @@ momentM4S = smf = -lensObjSmearX11 = smf [PS1_V5] -lensObjSmearX12 = smf [PS1_V5] -lensObjSmearX22 = smf [PS1_V5] -lensObjSmearE1 = smf [PS1_V5] -lensObjSmearE2 = smf [PS1_V5] -lensObjShearX11 = smf [PS1_V5] -lensObjShearX12 = smf [PS1_V5] -lensObjShearX22 = smf [PS1_V5] -lensObjShearE1 = smf [PS1_V5] -lensObjShearE2 = smf [PS1_V5] -lensPSFSmearX11 = smf [PS1_V5] -lensPSFSmearX12 = smf [PS1_V5] -lensPSFSmearX22 = smf [PS1_V5] -lensPSFSmearE1 = smf [PS1_V5] -lensPSFSmearE2 = smf [PS1_V5] -lensPSFShearX11 = smf [PS1_V5] -lensPSFShearX12 = smf [PS1_V5] -lensPSFShearX22 = smf [PS1_V5] -lensPSFShearE1 = smf [PS1_V5] -lensPSFShearE2 = smf [PS1_V5] - = apFlux = smf [PS1_V4] apFluxErr = smf [PS1_V4] @@ -67,13 +46,4 @@ kronRadErr = [drop : not currently calculated] ---------------- = -flxR5 = smf [?? calculated?] -flxR5Err = smf [?? calculated?] -flxR5Std = smf [?? calculated?] -flxR5Fill = smf [?? calculated?] -flxR6 = smf [?? calculated?] -flxR6Err = smf [?? calculated?] -flxR6Std = smf [?? calculated?] -flxR6Fill = smf [?? calculated?] ----------------- = sky = smf skyErr = smf Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject (revision 37246) @@ -4,23 +4,23 @@ objID dimensionless BIGINT 8 NA ODM object identifier index -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier gQfPerfect dimensionless REAL 4 -999 maximum psf qfPerfect from best available g band detections gMeanPSFMag AB_magnitude REAL 4 -999 mean g psf AB magnitude from best available measurements (best available as current defined by ipp "waterfall logic" gMeanPSFMagErr AB_magnitude REAL 4 -999 estimated error of best availalbe g-band psf AB magnitudes (individual errors added in quadrature) -gnIncPSFMag dimensionless SMALLINT 2 -999 number of best available detections included in mean psfMag gMeanPSFMagStd dimensioless REAL 4 -999 standard deviation of best available measurements - compared with MeanErr this is one measure of true variability -gMinPSFMag AB_magnitude REAL 4 -999 minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability. -gMaxPSFMag AB_magnitude REAL 4 -999 maximum best available PSFMag +gMeanPSFMagMin AB_magnitude REAL 4 -999 minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability. +gMeanPSFMagMax AB_magnitude REAL 4 -999 maximum best available PSFMag +gMeanPSFMagNpt dimensionless SMALLINT 2 -999 number of best available detections included in mean psfMag gMeanKronMag AB_magnitude REAL 4 -999 mean g kron AB magnitude from best available measurements gMeanKronMagErr AB_magnitude REAL 4 -999 estimated error of mean g kron AB magnitude -gnIncKronMag dimensionless SMALLINT 2 -999 number of best available detections included mean Kron mag -gMeanKronMagStd dimensioless REAL 4 -999 standard deviation of best available measurements +gMeanKronMagStd dimensionless REAL 4 -999 standard deviation of best available measurements +gMeanKronMagNpt dimensionless SMALLINT 2 -999 number of best available detections included mean Kron mag gMeanApMag AB_magnitude REAL 4 -999 mean g kron AB magnitude from best available measurements gMeanApMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude mean -gnIncApMag dimensionless SMALLINT 2 -999 number of detections included in best available mean of Kron mag in g filter gMeanApMagStd dimensioless REAL 4 -999 standard deviation of best available measurements -gFlags dimensionless BIGINT 8 NA flags for g mean +gMeanApMagNpt dimensionless SMALLINT 2 -999 number of detections included in best available mean of Kron mag in g filter + +gFlags dimensionless INT 4 0 flags for g mean [XXX secfilt.flags is 4byte] -- duplicate for other filters Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt (revision 37246) @@ -1,25 +1,23 @@ +*** I've checked that these are plausible, not exact +objID + dvo / addstar +gQfPerfect + dvo / relphot / secfilt.psfQfMax +gMeanPSFMag + dvo / relphot / secfilt.M +gMeanPSFMagErr + dvo / relphot / secfilt.dM +gMeanPSFMagStd + dvo / relphot / secfilt.Mstdev +gMeanPSFMagMin + dvo / relphot / secfilt.Min +gMeanPSFMagMax + dvo / relphot / secfilt.Max +gMeanPSFMagNpt + dvo / relphot / secfilt.Nused +gMeanKronMag + dvo / relphot / secfilt.Mkron +gMeanKronMagErr + dvo / relphot / secfilt.dMkron +gMeanKronMagStd + dvo / relphot / secfilt.sMkron +gMeanKronMagNpt + dvo / relphot / secfilt.NusedKron -objID = dvo / addstar -gcObjID = dvo / addstar -gQfPerfect = dvo / relphot / secfilt. [XXX Not calculated] -gMeanPSFMag = dvo / relphot / secfilt.M -gMeanPSFMagErr = dvo / relphot / secfilt.dM -gnIncPSFMag = dvo / relphot / secfilt.Nused [XXX : ensure .Nused matches .M] -gMeanPSFMagStd = dvo / relphot / secfilt.Mstdev -gMinPSFMag = dvo / relphot / secfilt.Min [XXX: replace M_20, M_80 with Min, Max] -gMaxPSFMag = dvo / relphot / secfilt.Max [XXX: replace M_20, M_80 with Min, Max] - = -gMeanKronMag = dvo / relphot / secfilt.Mkron -gMeanKronMagErr = dvo / relphot / secfilt.dMkron -gnIncKronMag = dvo / relphot / secfilt.nMkron [XXX : not calculated] -gMeanKronMagStd = dvo / relphot / secfilt.MstdevKron [XXX : not calculated] - = -gMeanApMag = dvo / relphot / secfilt.Map -gMeanApMagErr = dvo / relphot / secfilt.? [XXX : not calculated] -gnIncApMag = dvo / relphot / secfilt.? [XXX : not calculated] -gMeanApMagStd = dvo / relphot / secfilt.? [XXX : not calculated] +gMeanApMag + dvo / relphot / secfilt.Map +gMeanApMagErr + dvo / relphot / secfilt.dMap +gMeanApMagStd + dvo / relphot / secfilt.sMap +gMeanApMagNpt + dvo / relphot / secfilt.NusedAp -gFlags = dvo / relphot / secfilt.flags +gFlags + dvo / relphot / secfilt.flags Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin (revision 37246) @@ -2,10 +2,11 @@ objName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version objID dimensionless BIGINT 8 NA ODM object identifier index -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier ippObjID dimensionless BIGINT 8 NA IPP object number surveyID dimensionless TINYINT 1 255 Survey ID -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier htmID dimensionless BIGINT 8 NA HTM index zoneID dimensionless INT 4 NA Zone index +tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) +projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 +skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) randomID dimensionless BIGINT 8 0 Random integer between 0 and 2^32 = 4,394,967,296 remaining ramdom integer 0 batchID dimensionless BIGINT 8 -999 batch id @@ -23,6 +24,5 @@ raMeanErr arcsec REAL 4 -999 Combination of the measurement Errors in the Right Ascension from the mean detections if they exist decMeanErr arcsec REAL 4 -999 Combination of the measurement Errors in the Declination measurements if they exist -raMeanStd arcsec Real 4 -999 standard deviation of Right Ascension measurements in detections if they exist -decMeanStd arcsec REAL 4 -999 standard deviation of the Declination measurements if they exist +posMeanChisq dimensionless REAL 4 -999 chisq of mean position -------------------------------------------------------------------------------------------------------- -- Note: the following three sets of coordinate systems are based on stack if it exists, and mean if it does not. Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt (revision 37246) @@ -1,49 +1,49 @@ -objName = ipptopsps -objID = dvo / addstar -gcobjID = dvo / addstar -ippObjID = dvo / addstar -surveyID = ipptopsps -skyCellID = smf header -htmID = PSPS -zoneID = PSPS -randomID = ipptopsps -batchID = ipptopsps -dvoRegionID = dvo / catID -dataRelease = ipptopsps -objInfoFlag = dvo / relastro,relphot [define] -qualityFlag = dvo / relastro,relphot [define] -consistencyFlag = ipptopsps? -raStack = dvo / allow recalibration? [ADD to average.d] -decStack = dvo / allow recalibration? -raStackErr = dvo / allow recalibration? -decStackErr = dvo / allow recalibration? -raMean = dvo / relastro -decMean = dvo / relastro -raMeanErr = dvo / relastro -decMeanErr = dvo / relastro -raMeanStd = dvo / relastro -decMeanStd = dvo / relastro ------------------ = --- = --- = --- = --- = --- = -cx = PSPS -cy = PSPS -cz = PSPS -lambda = PSPS -beta = PSPS -l = PSPS -b = PSPS ------------------ = -nStackObjectRows = dvo [ADD to average.d] --- = -nStackDetections = dvo / relphot [Sum of not-forced stack detections] -nDetections = dvo / relphot [Sum of ng+nr, etc?] -ng = dvo / relphot [Sum of GPC1.g.XY?? measure.d] -nr = dvo / relphot [ditto] -ni = dvo / relphot -nz = dvo / relphot -ny = dvo / relphot +objName - ipptopsps : move to dvopsps? +objID + dvo:average.extID +ippObjID + dvo:(average.objID | average.catID << 32) +surveyID + ipptopsps : internal, from survey name +htmID - PSPS +zoneID - PSPS +tessID + average.tessID +projectionID + average.projectionID +skycellID + average.skycellID +randomID + ipptopsps : RANDOM from sql +batchID + ipptopsps : internal +dvoRegionID + dvo:average.catID +dataRelease + ipptopsps : user input (skychunk.dataRelease) +objInfoFlag + dvo:average.flags +qualityFlag - (dvo:average.flags >> 24) & 0xFF *** correct?? +consistencyFlag - *** hard-wired in ipptopsps to 0 +raStack + dvo:average.Rstk *** not calculated? +decStack + dvo:average.Dstk *** not calculated? +raStackErr + dvo:average.dRstk *** not calculated? +decStackErr + dvo:average.dDstk *** not calculated? +raMean + dvo:average.R +decMean + dvo:average.D +raMeanErr + dvo:average.dR +decMeanErr + dvo:average.dD +posMeanChisq + dvo:average.ChiSqAve +----------------- +-- +-- +-- +-- +-- +cx - PSPS +cy - PSPS +cz - PSPS +lambda - PSPS +beta - PSPS +l - PSPS +b - PSPS +----------------- +nStackObjectRows - do in dvopsps +-- +nStackDetections - sum of secfilt.NstackDet (sum in sql) +nDetections + ipptopsps:Sum of ng+nr in sql +ng + dvo:secfilt.ncode ** check that this is right +nr + dvo:secfilt.ncode ** check that this is right +ni + dvo:secfilt.ncode ** check that this is right +nz + dvo:secfilt.ncode ** check that this is right +ny + dvo:secfilt.ncode ** check that this is right Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 37246) @@ -1,8 +1,5 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier ippObjID dimensionless BIGINT 8 NA ipp object identifier -surveyID dimensionless TINYINT 1 0 stack type identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier randomStackObjID dimensionless BIGINT 8 NA random stack id stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best @@ -10,6 +7,4 @@ bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded. ------------------------------------------------------- replicate to end for each filter g,r,i,z,y gippDetectID dimensionless BIGINT 8 NA stack identifier @@ -17,41 +12,41 @@ gstackMetaID dimensionless BIGINT 8 NA stack identifier --------------------------------------------------------unconvolved -gflxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gflxR3Err adu/seconds REAL 4 -999 estimated error is flxR3 -gflxR3Std adu/seconds REAL 4 -999 estimated standard deviation in flxR3 +gflxR3 Jy REAL 4 -999 Flux inside r = 3 +gflxR3Err Jy REAL 4 -999 estimated error is flxR3 +gflxR3Std Jy REAL 4 -999 estimated standard deviation in flxR3 gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gflxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gflxR4Err adu/seconds REAL 4 -999 estimated error is flxR4 -gflxR4Std adu/seconds REAL 4 -999 estimated standard deviation in flxR4 +gflxR4 Jy REAL 4 -999 Flux inside r = 4 +gflxR4Err Jy REAL 4 -999 estimated error is flxR4 +gflxR4Std Jy REAL 4 -999 estimated standard deviation in flxR4 gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gflxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gflxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 -gflxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 +gflxR5 Jy REAL 4 -999 Flux inside r = 5 +gflxR5Err Jy REAL 4 -999 estimated error is flxR5 +gflxR5Std Jy REAL 4 -999 estimated standard deviation in flxR5 gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 ---------------------------------------------------- convolved across all bands to 6 or 8 pixels -gc1flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc1flxR3Err adu/seconds REAL 4 -999 estimated error is c1flxR3 -gc1flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR3 +gc1flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc1flxR3Err Jy REAL 4 -999 estimated error is c1flxR3 +gc1flxR3Std Jy REAL 4 -999 estimated standard deviation in c1flxR3 gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc1flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc1flxR4Err adu/seconds REAL 4 -999 estimated error is c1flxR4 -gc1flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR4 +gc1flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc1flxR4Err Jy REAL 4 -999 estimated error is c1flxR4 +gc1flxR4Std Jy REAL 4 -999 estimated standard deviation in c1flxR4 gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc1flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc1flxR5Err adu/seconds REAL 4 -999 estimated error is c1flxR5 -gc1flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR5 +gc1flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc1flxR5Err Jy REAL 4 -999 estimated error is c1flxR5 +gc1flxR5Std Jy REAL 4 -999 estimated standard deviation in c1flxR5 gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 ---------------------------------------------------- convolved across all bands to 6 or 8 pixels -gc2flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc2flxR3Err adu/seconds REAL 4 -999 estimated error in c2flxR3 -gc2flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR3 +gc2flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc2flxR3Err Jy REAL 4 -999 estimated error in c2flxR3 +gc2flxR3Std Jy REAL 4 -999 estimated standard deviation in c2flxR3 gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc2flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc2flxR4Err adu/seconds REAL 4 -999 estimated error in c2flxR4 -gc2flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR4 +gc2flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc2flxR4Err Jy REAL 4 -999 estimated error in c2flxR4 +gc2flxR4Std Jy REAL 4 -999 estimated standard deviation in c2flxR4 gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc2flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc2flxR5Err adu/seconds REAL 4 -999 estimated error in c2flxR5 -gc2flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR5 +gc2flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc2flxR5Err Jy REAL 4 -999 estimated error in c2flxR5 +gc2flxR5Std Jy REAL 4 -999 estimated standard deviation in c2flxR5 gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt (revision 37246) @@ -1,56 +1,51 @@ -objID = dvo/addstar -gcObjID = dvo/addstar -ippObjID = dvo/addstar average.objID + (average.catID << 32) -surveyID = ipptopsps -skyCellID = smf header -randomStackObjID = ipptopsps -stackDetectRowID = PSPS ? -primaryDetection = dvo -bestDetection = dvo --- = -dvoRegionID = dvo / catID -dataRelease = ipptopsps ----------------- = -gippDetectID = dvo/addstar -gstackDetectID = dvopsps (see StackObject.txt) -gstackMetaID = dvopsps (see StackObject.txt) ----------------- = -gflxR3 = smf -gflxR3Err = smf -gflxR3Std = smf -gflxR3Fill = smf -gflxR4 = smf -gflxR4Err = smf -gflxR4Std = smf -gflxR4Fill = smf -gflxR5 = smf -gflxR5Err = smf -gflxR5Std = smf -gflxR5Fill = smf ----------------- = -gc1flxR3 = smf -gc1flxR3Err = smf -gc1flxR3Std = smf -gc1flxR3Fill = smf -gc1flxR4 = smf -gc1flxR4Err = smf -gc1flxR4Std = smf -gc1flxR4Fill = smf -gc1flxR5 = smf -gc1flxR5Err = smf -gc1flxR5Std = smf -gc1flxR5Fill = smf ----------------- = -gc2flxR3 = smf -gc2flxR3Err = smf -gc2flxR3Std = smf -gc2flxR3Fill = smf -gc2flxR4 = smf -gc2flxR4Err = smf -gc2flxR4Std = smf -gc2flxR4Fill = smf -gc2flxR5 = smf -gc2flxR5Err = smf -gc2flxR5Std = smf -gc2flxR5Fill = smf +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gflxR3 + cmf : APER_FLUX_3 +gflxR3Err + cmf : APER_FLUX_ERR_3 +gflxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gflxR3Fill + cmf : APER_FILL_3 +gflxR4 + cmf : APER_FLUX_4 +gflxR4Err + cmf : APER_FLUX_ERR_4 +gflxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gflxR4Fill + cmf : APER_FILL_4 +gflxR5 + cmf : APER_FLUX_5 +gflxR5Err + cmf : APER_FLUX_ERR_5 +gflxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gflxR5Fill + cmf : APER_FILL_5 +---------------- +gc1flxR3 + cmf : APER_FLUX_3 +gc1flxR3Err + cmf : APER_FLUX_ERR_3 +gc1flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gc1flxR3Fill + cmf : APER_FILL_3 +gc1flxR4 + cmf : APER_FLUX_4 +gc1flxR4Err + cmf : APER_FLUX_ERR_4 +gc1flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gc1flxR4Fill + cmf : APER_FILL_4 +gc1flxR5 + cmf : APER_FLUX_5 +gc1flxR5Err + cmf : APER_FLUX_ERR_5 +gc1flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gc1flxR5Fill + cmf : APER_FILL_5 +---------------- +gc2flxR3 + cmf : APER_FLUX_3 +gc2flxR3Err + cmf : APER_FLUX_ERR_3 +gc2flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gc2flxR3Fill + cmf : APER_FILL_3 +gc2flxR4 + cmf : APER_FLUX_4 +gc2flxR4Err + cmf : APER_FLUX_ERR_4 +gc2flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gc2flxR4Fill + cmf : APER_FILL_4 +gc2flxR5 + cmf : APER_FLUX_5 +gc2flxR5Err + cmf : APER_FLUX_ERR_5 +gc2flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gc2flxR5Fill + cmf : APER_FILL_5 Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull (revision 37246) @@ -0,0 +1,53 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. +-- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gflxR1 Jy REAL 4 -999 Flux inside r = 1 +gflxR1Err Jy REAL 4 -999 estimated error is flxR1 +gflxR1Std Jy REAL 4 -999 estimated standard deviation in flxR1 +gflxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gflxR2 Jy REAL 4 -999 Flux inside r = 2 +gflxR2Err Jy REAL 4 -999 estimated error is flxR2 +gflxR2Std Jy REAL 4 -999 estimated standard deviation in flxR2 +gflxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gflxR3 Jy REAL 4 -999 Flux inside r = 3 +gflxR3Err Jy REAL 4 -999 estimated error is flxR3 +gflxR3Std Jy REAL 4 -999 estimated standard deviation in flxR3 +gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gflxR4 Jy REAL 4 -999 Flux inside r = 4 +gflxR4Err Jy REAL 4 -999 estimated error is flxR4 +gflxR4Std Jy REAL 4 -999 estimated standard deviation in flxR4 +gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gflxR5 Jy REAL 4 -999 Flux inside r = 5 +gflxR5Err Jy REAL 4 -999 estimated error is flxR5 +gflxR5Std Jy REAL 4 -999 estimated standard deviation in flxR5 +gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gflxR6 Jy REAL 4 -999 Flux inside r = 6 +gflxR6Err Jy REAL 4 -999 estimated error is flxR6 +gflxR6Std Jy REAL 4 -999 estimated standard deviation in flxR6 +gflxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gflxR7 Jy REAL 4 -999 Flux inside r = 7 +gflxR7Err Jy REAL 4 -999 estimated error is flxR7 +gflxR7Std Jy REAL 4 -999 estimated standard deviation in flxR7 +gflxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gflxR8 Jy REAL 4 -999 Flux inside r = 8 +gflxR8Err Jy REAL 4 -999 estimated error is flxR8 +gflxR8Std Jy REAL 4 -999 estimated standard deviation in flxR8 +gflxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gflxR9 Jy REAL 4 -999 Flux inside r = 9 +gflxR9Err Jy REAL 4 -999 estimated error is flxR9 +gflxR9Std Jy REAL 4 -999 estimated standard deviation in flxR9 +gflxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 +gflxR10 Jy REAL 4 -999 Flux inside r = 10 +gflxR10Err Jy REAL 4 -999 estimated error is flxR10 +gflxR10Std Jy REAL 4 -999 estimated standard deviation in flxR10 +gflxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt (revision 37246) @@ -0,0 +1,53 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gflxR1 + cmf : APER_FLUX_1 +gflxR1Err + cmf : APER_FLUX_ERR_1 +gflxR1Std - cmf : APER_FLUX_STDEV_1 : ** badly defined in cmf +gflxR1Fill + cmf : APER_FILL_1 +gflxR2 + cmf : APER_FLUX_2 +gflxR2Err + cmf : APER_FLUX_ERR_2 +gflxR2Std - cmf : APER_FLUX_STDEV_2 : ** badly defined in cmf +gflxR2Fill + cmf : APER_FILL_2 +gflxR3 + cmf : APER_FLUX_3 +gflxR3Err + cmf : APER_FLUX_ERR_3 +gflxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gflxR3Fill + cmf : APER_FILL_3 +gflxR4 + cmf : APER_FLUX_4 +gflxR4Err + cmf : APER_FLUX_ERR_4 +gflxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gflxR4Fill + cmf : APER_FILL_4 +gflxR5 + cmf : APER_FLUX_5 +gflxR5Err + cmf : APER_FLUX_ERR_5 +gflxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gflxR5Fill + cmf : APER_FILL_5 +gflxR6 + cmf : APER_FLUX_6 +gflxR6Err + cmf : APER_FLUX_ERR_6 +gflxR6Std - cmf : APER_FLUX_STDEV_6 : ** badly defined in cmf +gflxR6Fill + cmf : APER_FILL_6 +gflxR7 + cmf : APER_FLUX_7 +gflxR7Err + cmf : APER_FLUX_ERR_7 +gflxR7Std - cmf : APER_FLUX_STDEV_7 : ** badly defined in cmf +gflxR7Fill + cmf : APER_FILL_7 +gflxR8 + cmf : APER_FLUX_8 +gflxR8Err + cmf : APER_FLUX_ERR_8 +gflxR8Std - cmf : APER_FLUX_STDEV_8 : ** badly defined in cmf +gflxR8Fill + cmf : APER_FILL_8 +gflxR9 + cmf : APER_FLUX_9 +gflxR9Err + cmf : APER_FLUX_ERR_9 +gflxR9Std - cmf : APER_FLUX_STDEV_9 : ** badly defined in cmf +gflxR9Fill + cmf : APER_FILL_9 +gflxR10 - cmf : APER_FLUX_10 ** does not exist in cmf +gflxR10Err - cmf : APER_FLUX_ERR_10 ** does not exist in cmf +gflxR10Std - cmf : APER_FLUX_STDEV_10 ** does not exist in cmf +gflxR10Fill - cmf : APER_FILL_10 ** does not exist in cmf Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 (revision 37246) @@ -0,0 +1,55 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. +-- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gc1flxR1 Jy REAL 4 -999 Flux inside r = 1 +gc1flxR1Err Jy REAL 4 -999 estimated error is c1flxR1 +gc1flxR1Std Jy REAL 4 -999 estimated standard deviation in c1flxR1 +gc1flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc1flxR2 Jy REAL 4 -999 Flux inside r = 2 +gc1flxR2Err Jy REAL 4 -999 estimated error is c1flxR2 +gc1flxR2Std Jy REAL 4 -999 estimated standard deviation in c1flxR2 +gc1flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc1flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc1flxR3Err Jy REAL 4 -999 estimated error is c1flxR3 +gc1flxR3Std Jy REAL 4 -999 estimated standard deviation in c1flxR3 +gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc1flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc1flxR4Err Jy REAL 4 -999 estimated error is c1flxR4 +gc1flxR4Std Jy REAL 4 -999 estimated standard deviation in c1flxR4 +gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc1flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc1flxR5Err Jy REAL 4 -999 estimated error is c1flxR5 +gc1flxR5Std Jy REAL 4 -999 estimated standard deviation in c1flxR5 +gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gc1flxR6 Jy REAL 4 -999 Flux inside r = 6 +gc1flxR6Err Jy REAL 4 -999 estimated error is c1flxR6 +gc1flxR6Std Jy REAL 4 -999 estimated standard deviation in c1flxR6 +gc1flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gc1flxR7 Jy REAL 4 -999 Flux inside r = 7 +gc1flxR7Err Jy REAL 4 -999 estimated error is c1flxR7 +gc1flxR7Std Jy REAL 4 -999 estimated standard deviation in c1flxR7 +gc1flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gc1flxR8 Jy REAL 4 -999 Flux inside r = 8 +gc1flxR8Err Jy REAL 4 -999 estimated error is c1flxR8 +gc1flxR8Std Jy REAL 4 -999 estimated standard deviation in c1flxR8 +gc1flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gc1flxR9 Jy REAL 4 -999 Flux inside r = 9 +gc1flxR9Err Jy REAL 4 -999 estimated error is c1flxR9 +gc1flxR9Std Jy REAL 4 -999 estimated standard deviation in c1flxR9 +gc1flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 +gc1flxR10 Jy REAL 4 -999 Flux inside r = 10 +gc1flxR10Err Jy REAL 4 -999 estimated error is c1flxR10 +gc1flxR10Std Jy REAL 4 -999 estimated standard deviation in c1flxR10 +gc1flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 + + Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt (revision 37246) @@ -0,0 +1,53 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gc1flxR1 + cmf : APER_FLUX_1 +gc1flxR1Err + cmf : APER_FLUX_ERR_1 +gc1flxR1Std - cmf : APER_FLUX_STDEV_1 : ** badly defined in cmf +gc1flxR1Fill + cmf : APER_FILL_1 +gc1flxR2 + cmf : APER_FLUX_2 +gc1flxR2Err + cmf : APER_FLUX_ERR_2 +gc1flxR2Std - cmf : APER_FLUX_STDEV_2 : ** badly defined in cmf +gc1flxR2Fill + cmf : APER_FILL_2 +gc1flxR3 + cmf : APER_FLUX_3 +gc1flxR3Err + cmf : APER_FLUX_ERR_3 +gc1flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gc1flxR3Fill + cmf : APER_FILL_3 +gc1flxR4 + cmf : APER_FLUX_4 +gc1flxR4Err + cmf : APER_FLUX_ERR_4 +gc1flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gc1flxR4Fill + cmf : APER_FILL_4 +gc1flxR5 + cmf : APER_FLUX_5 +gc1flxR5Err + cmf : APER_FLUX_ERR_5 +gc1flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gc1flxR5Fill + cmf : APER_FILL_5 +gc1flxR6 + cmf : APER_FLUX_6 +gc1flxR6Err + cmf : APER_FLUX_ERR_6 +gc1flxR6Std - cmf : APER_FLUX_STDEV_6 : ** badly defined in cmf +gc1flxR6Fill + cmf : APER_FILL_6 +gc1flxR7 + cmf : APER_FLUX_7 +gc1flxR7Err + cmf : APER_FLUX_ERR_7 +gc1flxR7Std - cmf : APER_FLUX_STDEV_7 : ** badly defined in cmf +gc1flxR7Fill + cmf : APER_FILL_7 +gc1flxR8 + cmf : APER_FLUX_8 +gc1flxR8Err + cmf : APER_FLUX_ERR_8 +gc1flxR8Std - cmf : APER_FLUX_STDEV_8 : ** badly defined in cmf +gc1flxR8Fill + cmf : APER_FILL_8 +gc1flxR9 + cmf : APER_FLUX_9 +gc1flxR9Err + cmf : APER_FLUX_ERR_9 +gc1flxR9Std - cmf : APER_FLUX_STDEV_9 : ** badly defined in cmf +gc1flxR9Fill + cmf : APER_FILL_9 +gc1flxR10 - cmf : APER_FLUX_10 ** does not exist in cmf +gc1flxR10Err - cmf : APER_FLUX_ERR_10 ** does not exist in cmf +gc1flxR10Std - cmf : APER_FLUX_STDEV_10 ** does not exist in cmf +gc1flxR10Fill - cmf : APER_FILL_10 ** does not exist in cmf Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 (revision 37246) @@ -0,0 +1,55 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. +-- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gc2flxR1 Jy REAL 4 -999 Flux inside r = 1 +gc2flxR1Err Jy REAL 4 -999 estimated error is c2flxR1 +gc2flxR1Std Jy REAL 4 -999 estimated standard deviation in c2flxR1 +gc2flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc2flxR2 Jy REAL 4 -999 Flux inside r = 2 +gc2flxR2Err Jy REAL 4 -999 estimated error is c2flxR2 +gc2flxR2Std Jy REAL 4 -999 estimated standard deviation in c2flxR2 +gc2flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 +gc2flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc2flxR3Err Jy REAL 4 -999 estimated error is c2flxR3 +gc2flxR3Std Jy REAL 4 -999 estimated standard deviation in c2flxR3 +gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 +gc2flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc2flxR4Err Jy REAL 4 -999 estimated error is c2flxR4 +gc2flxR4Std Jy REAL 4 -999 estimated standard deviation in c2flxR4 +gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 +gc2flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc2flxR5Err Jy REAL 4 -999 estimated error is c2flxR5 +gc2flxR5Std Jy REAL 4 -999 estimated standard deviation in c2flxR5 +gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 +gc2flxR6 Jy REAL 4 -999 Flux inside r = 6 +gc2flxR6Err Jy REAL 4 -999 estimated error is c2flxR6 +gc2flxR6Std Jy REAL 4 -999 estimated standard deviation in c2flxR6 +gc2flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 +gc2flxR7 Jy REAL 4 -999 Flux inside r = 7 +gc2flxR7Err Jy REAL 4 -999 estimated error is c2flxR7 +gc2flxR7Std Jy REAL 4 -999 estimated standard deviation in c2flxR7 +gc2flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 +gc2flxR8 Jy REAL 4 -999 Flux inside r = 8 +gc2flxR8Err Jy REAL 4 -999 estimated error is c2flxR8 +gc2flxR8Std Jy REAL 4 -999 estimated standard deviation in c2flxR8 +gc2flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 +gc2flxR9 Jy REAL 4 -999 Flux inside r = 9 +gc2flxR9Err Jy REAL 4 -999 estimated error is c2flxR9 +gc2flxR9Std Jy REAL 4 -999 estimated standard deviation in c2flxR9 +gc2flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 +gc2flxR10 Jy REAL 4 -999 Flux inside r = 10 +gc2flxR10Err Jy REAL 4 -999 estimated error is c2flxR10 +gc2flxR10Std Jy REAL 4 -999 estimated standard deviation in c2flxR10 +gc2flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 + +-- repeat for other filters with appropriate leading prefex. Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt (revision 37246) @@ -0,0 +1,53 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gc2flxR1 + cmf : APER_FLUX_1 +gc2flxR1Err + cmf : APER_FLUX_ERR_1 +gc2flxR1Std - cmf : APER_FLUX_STDEV_1 : ** badly defined in cmf +gc2flxR1Fill + cmf : APER_FILL_1 +gc2flxR2 + cmf : APER_FLUX_2 +gc2flxR2Err + cmf : APER_FLUX_ERR_2 +gc2flxR2Std - cmf : APER_FLUX_STDEV_2 : ** badly defined in cmf +gc2flxR2Fill + cmf : APER_FILL_2 +gc2flxR3 + cmf : APER_FLUX_3 +gc2flxR3Err + cmf : APER_FLUX_ERR_3 +gc2flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf +gc2flxR3Fill + cmf : APER_FILL_3 +gc2flxR4 + cmf : APER_FLUX_4 +gc2flxR4Err + cmf : APER_FLUX_ERR_4 +gc2flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf +gc2flxR4Fill + cmf : APER_FILL_4 +gc2flxR5 + cmf : APER_FLUX_5 +gc2flxR5Err + cmf : APER_FLUX_ERR_5 +gc2flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf +gc2flxR5Fill + cmf : APER_FILL_5 +gc2flxR6 + cmf : APER_FLUX_6 +gc2flxR6Err + cmf : APER_FLUX_ERR_6 +gc2flxR6Std - cmf : APER_FLUX_STDEV_6 : ** badly defined in cmf +gc2flxR6Fill + cmf : APER_FILL_6 +gc2flxR7 + cmf : APER_FLUX_7 +gc2flxR7Err + cmf : APER_FLUX_ERR_7 +gc2flxR7Std - cmf : APER_FLUX_STDEV_7 : ** badly defined in cmf +gc2flxR7Fill + cmf : APER_FILL_7 +gc2flxR8 + cmf : APER_FLUX_8 +gc2flxR8Err + cmf : APER_FLUX_ERR_8 +gc2flxR8Std - cmf : APER_FLUX_STDEV_8 : ** badly defined in cmf +gc2flxR8Fill + cmf : APER_FILL_8 +gc2flxR9 + cmf : APER_FLUX_9 +gc2flxR9Err + cmf : APER_FLUX_ERR_9 +gc2flxR9Std - cmf : APER_FLUX_STDEV_9 : ** badly defined in cmf +gc2flxR9Fill + cmf : APER_FILL_9 +gc2flxR10 - cmf : APER_FLUX_10 ** does not exist in cmf +gc2flxR10Err - cmf : APER_FLUX_ERR_10 ** does not exist in cmf +gc2flxR10Std - cmf : APER_FLUX_STDEV_10 ** does not exist in cmf +gc2flxR10Fill - cmf : APER_FILL_10 ** does not exist in cmf Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFit =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFit (revision 37000) +++ (revision ) @@ -1,209 +1,0 @@ - -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -ippObjID dimensionless BIGINT 8 NA ipp object identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier -randomStackObjID dimensionless BIGINT 8 NA random stack id -stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best -primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. -bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. --- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded --------------------------------------------------------- replicate below for all filters (grizy) -gS2 dimensionless REAL 4 -999 (un)smoothness (Cheng 2012, Simard 2002) -glogRT dimensionless REAL 4 -999 total residual (from ellipcally symmetric model) -glogRA dimensionless REAL 4 -999 asymmetric residual (from ellipcally symmetric model) -glogC dimensionless REAL 4 -999 concentration index (Petrosian R_50 / R_90) -glogA dimensionless REAL 4 -999 log of asymmetry index (Gyory & Bell 2010) -gbumpy dimensionless REAL 4 -999 Blakeslee bumpiness -ghalfLightRad arcsec REAL 4 -999 half-light radius --------------------------------------------------------- replicate below for all filters (grizy) -gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier -gstackMetaID dimensionless BIGINT 8 NA stack identifier ----------------------------------------------------------------------------------------- -gdeVRadius arcsec REAL 4 -999 deVaucouleurs radius -gdeVRadiusErr arcsec REAL 4 -999 estimated error in deVaucouleurs radius -gdeVFlux adu/seconds REAL 4 -999 deVaucouleurs flux -gdeVFluxErr adu/seconds REAL 4 -999 estimated error in deVaucouleurs flux -gdeVAb dimensionless REAL 4 -999 deVaucoulerus axis ratio -gdeVAbErr dimensionless REAL 4 -999 estimated error in deVaucoulerus axis ratio -gdeVPhi degrees REAL 4 -999 estmated phi of deVaucouleurs axis. Degrees East of North. -gdeVPhiErr degrees REAL 4 -999 estmated error of phi of deVaucouleurs axis -graDeVOff arcsec REAL 4 -999 Offset in RA of deVaucouleurs fit from PSF RA -gdecDeVOff arcsec REAL 4 -999 Offset in DEC of deVaucouleurs fit from PSF DEC -graDeVOffErr arcsec REAL 4 -999 estimated error in ra offset -gdecDeVOffErr arcsec REAL 4 -999 estimated error in dec offset -gdeVCf dimensionless REAL 4 -999 deVaucouleurs fit coverage factor -gdeVLikelihood dimensionless REAL 4 -999 deVaucouleurs fit likelihood factor ----------------------------------------------------------------------------------------- -gexpRadius arcsec REAL 4 -999 Exponential fit radius -gexpRadiusErr arcsec REAL 4 -999 estimated error in Exponential fit radius -gexpFlux adu/seconds REAL 4 -999 Exponential fit flux -gexpFluxErr adu/seconds REAL 4 -999 estimated error in expFlux -gexpAb dimensionless REAL 4 -999 Exponential fit axis ratio -gexpAbErr dimensionless REAL 4 -999 estimated error in Exponential fit axis ratio -gexpPhi degrees REAL 4 -999 estmated phi of Exponential axis -gexpPhiErr degrees REAL 4 -999 estmated error of phi of Exponential axis -graExpOff dimensionless REAL 4 -999 Offset in RA of Exponential fit from PSF RA -gdecExpOff dimensionless REAL 4 -999 Offset in DEC of Exponential fit from PSF DEC -graExpOffErr dimensionless REAL 4 -999 estimated error in raExpOff -gdecExpOffErr dimensionless REAL 4 -999 estimated error in decExpOff -gexpCf dimensionless REAL 4 -999 Exponential fit coverage factor -gexpLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor ---------------------------------------------------------------------------------------- -gserRadius arcsec REAL 4 -999 Sersic radius -gserRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius -gserFlux adu/seconds REAL 4 -999 Sersic Flux -gserFluxErr adu/seconds REAL 4 -999 estimated error in serFlux -gserAb dimensionless REAL 4 -999 Sersic axis ratio -gserAbErr dimensionlessn REAL 4 -999 estimated error in Sersic axis ratio -gserNu dimensionlessn REAL 4 -999 Sersic index -gserNuErr diemensionless REAL 4 -999 estimated error in Sersic index -gserPhi degrees REAL 4 -999 estmated phi of Sersic axis -gserPhiErr degrees REAL 4 -999 estmated error of phi of Sersic axis -graSerOff dimensionless REAL 4 -999 Offset in RA of Sersic fit from PSF RA -gdecSerOff dimensionless REAL 4 -999 Offset in DEC of Sersic fit from PSF DEC -graSerOffErr dimensionless REAL 4 -999 estimated error in raSerOff -gdecSerOffErr dimensionless REAL 4 -999 estimated error in decSerOff -gserCf dimensionless REAL 4 -999 Sersic fit coverage factor -gserLikelihood dimensionless REAL 4 -999 Sersic fit likelihood factor ---------------------------------------------------------------------------------------- -gpetRadius pixels REAL 4 -999 Petrosian radius -gpetRadiusErr pixels REAL 4 -999 estimated error inPetrosian radius -gpetFlux adu/sec REAL 4 -999 Petrosian Flux -gpetFluxErr adu/sec REAL 4 -999 estimated error in petFlux -gpetR50 pixels REAL 4 -999 Petrosian radius at 50% light -gpetR50Err pixels REAL 4 -999 estimated error inPetrosian radius at 50% light -gpetR90 pixels REAL 4 -999 Petrosian radius at 90% light -gpetR90Err pixels REAL 4 -999 estimated error in Petrosian radius at 90% light -gpetCf dimensionless REAL 4 -999 Petrosian fit coverage factor ---------------------------------------------------------unconvolved -gflxR1 adu/seconds REAL 4 -999 Flux inside r = 1 -gflxR1Err adu/seconds REAL 4 -999 estimated error is flxR1 -gflxR1Std adu/seconds REAL 4 -999 estimated standard deviation in flxR1 -gflxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gflxR2 adu/seconds REAL 4 -999 Flux inside r = 2 -gflxR2Err adu/seconds REAL 4 -999 estimated error is flxR2 -gflxR2Std adu/seconds REAL 4 -999 estimated standard deviation in flxR2 -gflxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gflxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gflxR3Err adu/seconds REAL 4 -999 estimated error is flxR3 -gflxR3Std adu/seconds REAL 4 -999 estimated standard deviation in flxR3 -gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gflxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gflxR4Err adu/seconds REAL 4 -999 estimated error is flxR4 -gflxR4Std adu/seconds REAL 4 -999 estimated standard deviation in flxR4 -gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gflxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gflxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 -gflxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 -gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -gflxR6 adu/seconds REAL 4 -999 Flux inside r = 6 -gflxR6Err adu/seconds REAL 4 -999 estimated error is flxR6 -gflxR6Std adu/seconds REAL 4 -999 estimated standard deviation in flxR6 -gflxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gflxR7 adu/seconds REAL 4 -999 Flux inside r = 7 -gflxR7Err adu/seconds REAL 4 -999 estimated error is flxR7 -gflxR7Std adu/seconds REAL 4 -999 estimated standard deviation in flxR7 -gflxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gflxR8 adu/seconds REAL 4 -999 Flux inside r = 8 -gflxR8Err adu/seconds REAL 4 -999 estimated error is flxR8 -gflxR8Std adu/seconds REAL 4 -999 estimated standard deviation in flxR8 -gflxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gflxR9 adu/seconds REAL 4 -999 Flux inside r = 9 -gflxR9Err adu/seconds REAL 4 -999 estimated error is flxR9 -gflxR9Std adu/seconds REAL 4 -999 estimated standard deviation in flxR9 -gflxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gflxR10 adu/seconds REAL 4 -999 Flux inside r = 10 -gflxR10Err adu/seconds REAL 4 -999 estimated error is flxR10 -gflxR10Std adu/seconds REAL 4 -999 estimated standard deviation in flxR10 -gflxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 ----------------------------------------------------- convolved across all bands to 6 or 8 pixels -gc1flxR1 adu/seconds REAL 4 -999 Flux inside r = 1 -gc1flxR1Err adu/seconds REAL 4 -999 estimated error is c1flxR1 -gc1flxR1Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR1 -gc1flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc1flxR2 adu/seconds REAL 4 -999 Flux inside r = 2 -gc1flxR2Err adu/seconds REAL 4 -999 estimated error is c1flxR2 -gc1flxR2Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR2 -gc1flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc1flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc1flxR3Err adu/seconds REAL 4 -999 estimated error is c1flxR3 -gc1flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR3 -gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc1flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc1flxR4Err adu/seconds REAL 4 -999 estimated error is c1flxR4 -gc1flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR4 -gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc1flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc1flxR5Err adu/seconds REAL 4 -999 estimated error is c1flxR5 -gc1flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR5 -gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -gc1flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 -gc1flxR6Err adu/seconds REAL 4 -999 estimated error is c1flxR6 -gc1flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR6 -gc1flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gc1flxR7 adu/seconds REAL 4 -999 Flux inside r = 7 -gc1flxR7Err adu/seconds REAL 4 -999 estimated error is c1flxR7 -gc1flxR7Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR7 -gc1flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gc1flxR8 adu/seconds REAL 4 -999 Flux inside r = 8 -gc1flxR8Err adu/seconds REAL 4 -999 estimated error is c1flxR8 -gc1flxR8Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR8 -gc1flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gc1flxR9 adu/seconds REAL 4 -999 Flux inside r = 9 -gc1flxR9Err adu/seconds REAL 4 -999 estimated error is c1flxR9 -gc1flxR9Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR9 -gc1flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gc1flxR10 adu/seconds REAL 4 -999 Flux inside r = 10 -gc1flxR10Err adu/seconds REAL 4 -999 estimated error is c1flxR10 -gc1flxR10Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR10 -gc1flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 -gc2flxR1 adu/seconds REAL 4 -999 Flux inside r = 1 -gc2flxR1Err adu/seconds REAL 4 -999 estimated error is c2flxR1 -gc2flxR1Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR1 -gc2flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc2flxR2 adu/seconds REAL 4 -999 Flux inside r = 2 -gc2flxR2Err adu/seconds REAL 4 -999 estimated error is c2flxR2 -gc2flxR2Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR2 -gc2flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc2flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc2flxR3Err adu/seconds REAL 4 -999 estimated error is c2flxR3 -gc2flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR3 -gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc2flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc2flxR4Err adu/seconds REAL 4 -999 estimated error is c2flxR4 -gc2flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR4 -gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc2flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc2flxR5Err adu/seconds REAL 4 -999 estimated error is c2flxR5 -gc2flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR5 -gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -gc2flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 -gc2flxR6Err adu/seconds REAL 4 -999 estimated error is c2flxR6 -gc2flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR6 -gc2flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gc2flxR7 adu/seconds REAL 4 -999 Flux inside r = 7 -gc2flxR7Err adu/seconds REAL 4 -999 estimated error is c2flxR7 -gc2flxR7Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR7 -gc2flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gc2flxR8 adu/seconds REAL 4 -999 Flux inside r = 8 -gc2flxR8Err adu/seconds REAL 4 -999 estimated error is c2flxR8 -gc2flxR8Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR8 -gc2flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gc2flxR9 adu/seconds REAL 4 -999 Flux inside r = 9 -gc2flxR9Err adu/seconds REAL 4 -999 estimated error is c2flxR9 -gc2flxR9Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR9 -gc2flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gc2flxR10 adu/seconds REAL 4 -999 Flux inside r = 10 -gc2flxR10Err adu/seconds REAL 4 -999 estimated error is c2flxR10 -gc2flxR10Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR10 -gc2flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 - --- repeat for other filters with appropriate leading prefex. - --- [728 byte/filter/obj + 44 byte/obj] - Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 37246) @@ -1,7 +1,5 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP randomStackObjID dimensionless BIGINT 8 NA random stack id stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best @@ -9,24 +7,21 @@ bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded -------------------------------------------------------- replicate below for all filters (grizy) -ippObjID dimensionless BIGINT 8 NA ipp object identifier gippDetectID dimensionless BIGINT 8 NA ipp detect identifier gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier gstackMetaID dimensionless BIGINT 8 NA stack identifier ---------------------------------------------------------------------------------------- -gdeVRadius arcsec REAL 4 -999 deVaucouleurs radius -gdeVRadiusErr arcsec REAL 4 -999 estimated error in deVaucouleurs radius -gdeVFlux adu/seconds REAL 4 -999 deVaucouleurs flux -gdeVFluxErr adu/seconds REAL 4 -999 estimated error in deVaucouleurs flux -gdeVAb dimensionless REAL 4 -999 deVaucoulerus axis ratio -gdeVAbErr dimensionless REAL 4 -999 estimated error in deVaucoulerus axis ratio -gdeVPhi degrees REAL 4 -999 estmated phi of deVaucouleurs axis. Degrees East of North. -gdeVPhiErr degrees REAL 4 -999 estmated error of phi of deVaucouleurs axis -graDeVOff arcsec REAL 4 -999 Offset in RA of deVaucouleurs fit from PSF RA -gdecDeVOff arcsec REAL 4 -999 Offset in DEC of deVaucouleurs fit from PSF DEC +gDeVRadius arcsec REAL 4 -999 DeVaucouleurs radius +gDeVRadiusErr arcsec REAL 4 -999 estimated error in DeVaucouleurs radius +gDeVMag AB_mag REAL 4 -999 DeVaucouleurs flux +gDeVMagErr AB_mag REAL 4 -999 estimated error in DeVaucouleurs flux +gDeVAb dimensionless REAL 4 -999 DeVaucoulerus axis ratio +gDeVAbErr dimensionless REAL 4 -999 estimated error in DeVaucoulerus axis ratio +gDeVPhi degrees REAL 4 -999 estmated phi of DeVaucouleurs axis. Degrees East of North. +gDeVPhiErr degrees REAL 4 -999 estmated error of phi of DeVaucouleurs axis +graDeVOff arcsec REAL 4 -999 Offset in RA of DeVaucouleurs fit from PSF RA +gdecDeVOff arcsec REAL 4 -999 Offset in DEC of DeVaucouleurs fit from PSF DEC graDeVOffErr arcsec REAL 4 -999 estimated error in ra offset gdecDeVOffErr arcsec REAL 4 -999 estimated error in dec offset -gdeVCf dimensionless REAL 4 -999 deVaucouleurs fit coverage factor -gdeVLikelihood dimensionless REAL 4 -999 deVaucouleurs fit likelihood factor +gDeVCf dimensionless REAL 4 -999 DeVaucouleurs fit coverage factor +gDeVLikelihood dimensionless REAL 4 -999 DeVaucouleurs fit likelihood factor Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt (revision 37246) @@ -0,0 +1,28 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gDeVRadius + cmf : EXT_WIDTH_MAJ +gDeVRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gDeVMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gDeVMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gDeVAb + cmf : EXT_WIDTH_MAJ/EXT_WIDTH_MIN ** should this be Minor / Major? +gDeVAbErr - cmf : EXT_WIDTH_MIN_ERR +gDeVPhi + cmf : EXT_THETA +gDeVPhiErr - cmf : EXT_THETA_ERR +gDeVRa + cmf : use X_EXT and X_PSF, PLTSCALE to offset StackObjectThin.gra +gDeVDec + cmf : use Y_EXT and Y_PSF, PLTSCALE to offset StackObjectThin.gdec +gDeVRaErr + cmf : X_EXT_SIG * PLTSCALE +gDeVDecErr + cmf : Y_EXT_SIG * PLTSCALE +gDeVCf - ** I do not have a source for this in the CMF +gDeVChisq - cmf : EXT_CHISQ / EXT_NDOF +-- gDeVLikelihood - ** replace with chisq? Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp (revision 37246) @@ -1,7 +1,5 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP randomStackObjID dimensionless BIGINT 8 NA random stack id stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best @@ -9,25 +7,22 @@ bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded --------------------------------------------------------- replicate below for all filters (grizy) -gippObjID dimensionless BIGINT 8 NA ipp object identifier +------------------------------------------------------- replicate below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier gstackMetaID dimensionless BIGINT 8 NA stack identifier ---------------------------------------------------------------------------------------- -gexpRadius arcsec REAL 4 -999 Exponential fit radius -gexpRadiusErr arcsec REAL 4 -999 estimated error in Exponential fit radius -gexpFlux adu/seconds REAL 4 -999 Exponential fit flux -gexpFluxErr adu/seconds REAL 4 -999 estimated error in expFlux -gexpAb dimensionless REAL 4 -999 Exponential fit axis ratio -gexpAbErr dimensionless REAL 4 -999 estimated error in Exponential fit axis ratio -gexpPhi degrees REAL 4 -999 estmated phi of Exponential axis -gexpPhiErr degrees REAL 4 -999 estmated error of phi of Exponential axis -graExpOff dimensionless REAL 4 -999 Offset in RA of Exponential fit from PSF RA -gdecExpOff dimensionless REAL 4 -999 Offset in DEC of Exponential fit from PSF DEC -graExpOffErr dimensionless REAL 4 -999 estimated error in raExpOff -gdecExpOffErr dimensionless REAL 4 -999 estimated error in decExpOff -gexpCf dimensionless REAL 4 -999 Exponential fit coverage factor -gexpLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor - +gExpRadius arcsec REAL 4 -999 Exponential fit radius +gExpRadiusErr arcsec REAL 4 -999 estimated error in Exponential fit radius +gExpMag AB_mag REAL 4 -999 Exponential fit flux +gExpMagErr AB_mag REAL 4 -999 estimated error in expFlux +gExpAb dimensionless REAL 4 -999 Exponential fit axis ratio (minor / major) +gExpAbErr dimensionless REAL 4 -999 estimated error in Exponential fit axis ratio +gExpPhi degrees REAL 4 -999 estmated phi of Exponential axis +gExpPhiErr degrees REAL 4 -999 estmated error of phi of Exponential axis +gExpRa degrees DOUBLE 8 -999 RA of Exponential fit +gExpDec degrees DOUBLE 8 -999 DEC of Exponential fit +gExpRaErr arcsec REAL 4 -999 estimated error in RA +gExpDecErr arcsec REAL 4 -999 estimated error in DEC +gExpCf dimensionless REAL 4 -999 Exponential fit coverage factor +gExpChisq dimensionless REAL 4 -999 Exponential fit chi square +-- gExpLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt (revision 37246) @@ -0,0 +1,27 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gExpRadius + cmf : EXT_WIDTH_MAJ +gExpRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gExpMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gExpMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gExpAb + cmf : EXT_WIDTH_MIN/EXT_WIDTH_MAJ +gExpAbErr - cmf : EXT_WIDTH_MIN_ERR +gExpPhi + cmf : EXT_THETA ** in radians, not degrees (fixed, check) +gExpPhiErr - cmf : EXT_THETA_ERR +gExpRa + cmf : use X_EXT and X_PSF, PLTSCALE to offset StackObjectThin.gra +gExpDec + cmf : use Y_EXT and Y_PSF, PLTSCALE to offset StackObjectThin.gdec +gExpRaErr + cmf : X_EXT_SIG * PLTSCALE +gExpDecErr + cmf : Y_EXT_SIG * PLTSCALE +gExpCf - ** I do not have a source for this in the CMF +gExpChisq - cmf : EXT_CHISQ / EXT_NDOF Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra (revision 37246) @@ -0,0 +1,21 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. +-- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +-------------------------------------------------------- +gS2 dimensionless REAL 4 -999 (un)smoothness (Cheng 2012, Simard 2002) +glogRT dimensionless REAL 4 -999 total residual (from ellipcally symmetric model) +glogRA dimensionless REAL 4 -999 asymmetric residual (from ellipcally symmetric model) +glogC dimensionless REAL 4 -999 concentration index (Petrosian R_50 / R_90) +glogA dimensionless REAL 4 -999 log of asymmetry index (Gyory & Bell 2010) +gbumpy dimensionless REAL 4 -999 Blakeslee bumpiness +ghalfLightRad arcsec REAL 4 -999 half-light radius +-------------------------------------------------------- replicate below for all filters (grizy) Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlx =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlx (revision 37000) +++ (revision ) @@ -1,58 +1,0 @@ - -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier -randomStackObjID dimensionless BIGINT 8 NA random stack id -stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best -primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. -bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. --- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded --------------------------------------------------------- replicate below for all filters (grizy) -gippObjID dimensionless BIGINT 8 NA ipp object identifier -gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier -gstackMetaID dimensionless BIGINT 8 NA stack identifier ----------------------------------------------------------------------------------------- -gflxR1 adu/seconds REAL 4 -999 Flux inside r = 1 -gflxR1Err adu/seconds REAL 4 -999 estimated error is flxR1 -gflxR1Std adu/seconds REAL 4 -999 estimated standard deviation in flxR1 -gflxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gflxR2 adu/seconds REAL 4 -999 Flux inside r = 2 -gflxR2Err adu/seconds REAL 4 -999 estimated error is flxR2 -gflxR2Std adu/seconds REAL 4 -999 estimated standard deviation in flxR2 -gflxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gflxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gflxR3Err adu/seconds REAL 4 -999 estimated error is flxR3 -gflxR3Std adu/seconds REAL 4 -999 estimated standard deviation in flxR3 -gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gflxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gflxR4Err adu/seconds REAL 4 -999 estimated error is flxR4 -gflxR4Std adu/seconds REAL 4 -999 estimated standard deviation in flxR4 -gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gflxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gflxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 -gflxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 -gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -gflxR6 adu/seconds REAL 4 -999 Flux inside r = 6 -gflxR6Err adu/seconds REAL 4 -999 estimated error is flxR6 -gflxR6Std adu/seconds REAL 4 -999 estimated standard deviation in flxR6 -gflxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gflxR7 adu/seconds REAL 4 -999 Flux inside r = 7 -gflxR7Err adu/seconds REAL 4 -999 estimated error is flxR7 -gflxR7Std adu/seconds REAL 4 -999 estimated standard deviation in flxR7 -gflxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gflxR8 adu/seconds REAL 4 -999 Flux inside r = 8 -gflxR8Err adu/seconds REAL 4 -999 estimated error is flxR8 -gflxR8Std adu/seconds REAL 4 -999 estimated standard deviation in flxR8 -gflxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gflxR9 adu/seconds REAL 4 -999 Flux inside r = 9 -gflxR9Err adu/seconds REAL 4 -999 estimated error is flxR9 -gflxR9Std adu/seconds REAL 4 -999 estimated standard deviation in flxR9 -gflxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gflxR10 adu/seconds REAL 4 -999 Flux inside r = 10 -gflxR10Err adu/seconds REAL 4 -999 estimated error is flxR10 -gflxR10Std adu/seconds REAL 4 -999 estimated standard deviation in flxR10 -gflxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1 =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1 (revision 37000) +++ (revision ) @@ -1,60 +1,0 @@ - -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier -randomStackObjID dimensionless BIGINT 8 NA random stack id -stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best -primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. -bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. --- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded --------------------------------------------------------- replicate below for all filters (grizy) -gippObjID dimensionless BIGINT 8 NA ipp object identifier -gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier -gstackMetaID dimensionless BIGINT 8 NA stack identifier ----------------------------------------------------------------------------------------- -gc1flxR1 adu/seconds REAL 4 -999 Flux inside r = 1 -gc1flxR1Err adu/seconds REAL 4 -999 estimated error is c1flxR1 -gc1flxR1Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR1 -gc1flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc1flxR2 adu/seconds REAL 4 -999 Flux inside r = 2 -gc1flxR2Err adu/seconds REAL 4 -999 estimated error is c1flxR2 -gc1flxR2Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR2 -gc1flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc1flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc1flxR3Err adu/seconds REAL 4 -999 estimated error is c1flxR3 -gc1flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR3 -gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc1flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc1flxR4Err adu/seconds REAL 4 -999 estimated error is c1flxR4 -gc1flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR4 -gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc1flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc1flxR5Err adu/seconds REAL 4 -999 estimated error is c1flxR5 -gc1flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR5 -gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -gc1flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 -gc1flxR6Err adu/seconds REAL 4 -999 estimated error is c1flxR6 -gc1flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR6 -gc1flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gc1flxR7 adu/seconds REAL 4 -999 Flux inside r = 7 -gc1flxR7Err adu/seconds REAL 4 -999 estimated error is c1flxR7 -gc1flxR7Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR7 -gc1flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gc1flxR8 adu/seconds REAL 4 -999 Flux inside r = 8 -gc1flxR8Err adu/seconds REAL 4 -999 estimated error is c1flxR8 -gc1flxR8Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR8 -gc1flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gc1flxR9 adu/seconds REAL 4 -999 Flux inside r = 9 -gc1flxR9Err adu/seconds REAL 4 -999 estimated error is c1flxR9 -gc1flxR9Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR9 -gc1flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gc1flxR10 adu/seconds REAL 4 -999 Flux inside r = 10 -gc1flxR10Err adu/seconds REAL 4 -999 estimated error is c1flxR10 -gc1flxR10Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR10 -gc1flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 - - Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2 =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2 (revision 37000) +++ (revision ) @@ -1,60 +1,0 @@ - -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier -randomStackObjID dimensionless BIGINT 8 NA random stack id -stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best -primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. -bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. --- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded --------------------------------------------------------- replicate below for all filters (grizy) -gippObjID dimensionless BIGINT 8 NA ipp object identifier -gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier -gstackMetaID dimensionless BIGINT 8 NA stack identifier ----------------------------------------------------------------------------------------- -gc2flxR1 adu/seconds REAL 4 -999 Flux inside r = 1 -gc2flxR1Err adu/seconds REAL 4 -999 estimated error is c2flxR1 -gc2flxR1Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR1 -gc2flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc2flxR2 adu/seconds REAL 4 -999 Flux inside r = 2 -gc2flxR2Err adu/seconds REAL 4 -999 estimated error is c2flxR2 -gc2flxR2Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR2 -gc2flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc2flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc2flxR3Err adu/seconds REAL 4 -999 estimated error is c2flxR3 -gc2flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR3 -gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc2flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc2flxR4Err adu/seconds REAL 4 -999 estimated error is c2flxR4 -gc2flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR4 -gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc2flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc2flxR5Err adu/seconds REAL 4 -999 estimated error is c2flxR5 -gc2flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR5 -gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -gc2flxR6 adu/seconds REAL 4 -999 Flux inside r = 6 -gc2flxR6Err adu/seconds REAL 4 -999 estimated error is c2flxR6 -gc2flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR6 -gc2flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gc2flxR7 adu/seconds REAL 4 -999 Flux inside r = 7 -gc2flxR7Err adu/seconds REAL 4 -999 estimated error is c2flxR7 -gc2flxR7Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR7 -gc2flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gc2flxR8 adu/seconds REAL 4 -999 Flux inside r = 8 -gc2flxR8Err adu/seconds REAL 4 -999 estimated error is c2flxR8 -gc2flxR8Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR8 -gc2flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gc2flxR9 adu/seconds REAL 4 -999 Flux inside r = 9 -gc2flxR9Err adu/seconds REAL 4 -999 estimated error is c2flxR9 -gc2flxR9Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR9 -gc2flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gc2flxR10 adu/seconds REAL 4 -999 Flux inside r = 10 -gc2flxR10Err adu/seconds REAL 4 -999 estimated error is c2flxR10 -gc2flxR10Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR10 -gc2flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 - --- repeat for other filters with appropriate leading prefex. Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitPet =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitPet (revision 37000) +++ (revision ) @@ -1,28 +1,0 @@ - -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier -randomStackObjID dimensionless BIGINT 8 NA random stack id -stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best -primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. -bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. --- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded --------------------------------------------------------- replicate below for all filters (grizy) -gippObjID dimensionless BIGINT 8 NA ipp object identifier -gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier -gstackMetaID dimensionless BIGINT 8 NA stack identifier ----------------------------------------------------------------------------------------- -gpetRadius pixels REAL 4 -999 Petrosian radius -gpetRadiusErr pixels REAL 4 -999 estimated error inPetrosian radius -gpetFlux adu/sec REAL 4 -999 Petrosian Flux -gpetFluxErr adu/sec REAL 4 -999 estimated error in petFlux -gpetR50 pixels REAL 4 -999 Petrosian radius at 50% light -gpetR50Err pixels REAL 4 -999 estimated error inPetrosian radius at 50% light -gpetR90 pixels REAL 4 -999 Petrosian radius at 90% light -gpetR90Err pixels REAL 4 -999 estimated error in Petrosian radius at 90% light -gpetCf dimensionless REAL 4 -999 Petrosian fit coverage factor - Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 37246) @@ -1,7 +1,5 @@ objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP randomStackObjID dimensionless BIGINT 8 NA random stack id stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best @@ -9,22 +7,19 @@ bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded -------------------------------------------------------- replicate below for all filters (grizy) -gippObjID dimensionless BIGINT 8 NA ipp object identifier gippDetectID dimensionless BIGINT 8 NA ipp detect identifier gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier gstackMetaID dimensionless BIGINT 8 NA stack identifier ---------------------------------------------------------------------------------------- -gserRadius arcsec REAL 4 -999 Sersic radius -gserRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius -gserFlux adu/seconds REAL 4 -999 Sersic Flux -gserFluxErr adu/seconds REAL 4 -999 estimated error in serFlux -gserAb dimensionless REAL 4 -999 Sersic axis ratio -gserAbErr dimensionlessn REAL 4 -999 estimated error in Sersic axis ratio -gserNu dimensionlessn REAL 4 -999 Sersic index -gserNuErr diemensionless REAL 4 -999 estimated error in Sersic index -gserPhi degrees REAL 4 -999 estmated phi of Sersic axis -gserPhiErr degrees REAL 4 -999 estmated error of phi of Sersic axis +gSerRadius arcsec REAL 4 -999 Sersic radius +gSerRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius +gSerMag AB_mag REAL 4 -999 Sersic Flux +gSerMagErr AB_mag REAL 4 -999 estimated error in serFlux +gSerAb dimensionless REAL 4 -999 Sersic axis ratio +gSerAbErr dimensionlessn REAL 4 -999 estimated error in Sersic axis ratio +gSerNu dimensionlessn REAL 4 -999 Sersic index +gSerNuErr diemensionless REAL 4 -999 estimated error in Sersic index +gSerPhi degrees REAL 4 -999 estmated phi of Sersic axis +gSerPhiErr degrees REAL 4 -999 estmated error of phi of Sersic axis graSerOff dimensionless REAL 4 -999 Offset in RA of Sersic fit from PSF RA gdecSerOff dimensionless REAL 4 -999 Offset in DEC of Sersic fit from PSF DEC Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt (revision 37246) @@ -0,0 +1,30 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gSerRadius + cmf : EXT_WIDTH_MAJ +gSerRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gSerMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gSerMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gSerAb - cmf : EXT_WIDTH_MAJ/EXT_WIDTH_MIN ** should this be Minor / Major? +gSerAbErr - cmf : EXT_WIDTH_MIN_ERR +gSerNu + cmf : EXT_PAR_07 +gSerNuErr - cmf : 0.1 ** NOTE this is hard-wired +gSerPhi - cmf : EXT_THETA ** in radians, not degrees +gSerPhiErr - cmf : EXT_THETA_ERR +gSerRa + cmf : use X_EXT and X_PSF, PLTSCALE to offset StackObjectThin.gra +gSerDec + cmf : use Y_EXT and Y_PSF, PLTSCALE to offset StackObjectThin.gdec +gSerRaErr + cmf : X_EXT_SIG * PLTSCALE +gSerDecErr + cmf : Y_EXT_SIG * PLTSCALE +gSerCf - ** I do not have a source for this in the CMF +gSerChisq - cmf : EXT_CHISQ / EXT_NDOF +--gSerLikelihood - ** replace with chisq? Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitThin =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitThin (revision 37000) +++ (revision ) @@ -1,25 +1,0 @@ - -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier -randomStackObjID dimensionless BIGINT 8 NA random stack id -stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best -primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. -bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. --- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded --------------------------------------------------------- replicate below for all filters (grizy) -gS2 dimensionless REAL 4 -999 (un)smoothness (Cheng 2012, Simard 2002) -glogRT dimensionless REAL 4 -999 total residual (from ellipcally symmetric model) -glogRA dimensionless REAL 4 -999 asymmetric residual (from ellipcally symmetric model) -glogC dimensionless REAL 4 -999 concentration index (Petrosian R_50 / R_90) -glogA dimensionless REAL 4 -999 log of asymmetry index (Gyory & Bell 2010) -gbumpy dimensionless REAL 4 -999 Blakeslee bumpiness -ghalfLightRad arcsec REAL 4 -999 half-light radius --------------------------------------------------------- replicate below for all filters (grizy) -gippObjID dimensionless BIGINT 8 NA ipp object identifier -gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier -gstackMetaID dimensionless BIGINT 8 NA stack identifier Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra (revision 37000) +++ (revision ) @@ -1,47 +1,0 @@ - -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier -randomStackObjID dimensionless BIGINT 8 NA random stack id -stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best -primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. -bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. - the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. ------------------------------------------------------------------------------------------- --- attributes for all stack detections in all filters (these are currently forced anyway) --- Replicate the section below for each filter, changing the prefex ("g" in this example) ------------------------------------------------------------------------------------------- -gippObjID dimensionless BIGINT 8 NA object ID generated by IPP -gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP -gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier -gstackMetaID dimensionless BIGINT 8 NA stack identifier ------------------------------------------------------------------------------------------- -gxPos arcsec REAL 4 -999 measured x in sky Cell from PSF fit -gyPos arcsec REAL 4 -999 measured y in sky Cell from PSF fit -gxPosErr arcsec REAL 4 -999 estimated error in x -gyPosErr arcsec REAL 4 -999 estimated error in y -gexpTime seconds REAL 4 -999 total exposure time (informational) -gpsfMajorFWHM arcsec REAL 4 -999 PSF width in major axis -gpsfMinorFWHM arcsec REAL 4 -999 PSF width in minor axis -gpsfTheta degrees REAL 4 -999 PSF orientation angle. Degrees East of North. -gpsfCore dimensionless REAL 4 -999 PSF core parameter [k in (1 + kz + z^1.66)] -gpsfLikelihood dimensionless REAL 4 -999 PSF likelihood -gpsfQf dimensionless REAL 4 -999 PSF coverage factor -gpsfQfPerfect dimensionless REAL 4 -999 PSF-weighted fraction of arcsec totally unmasked -gpsfChiSq dimensionless REAL 4 -999 PSF-weighted fraction of arcsec to. -gmomentXX arcsec^2 REAL 4 -999 moment XX -gmomentXY arcsec^2 REAL 4 -999 moment XY -gmomentYY arcsec^2 REAL 4 -999 moment YY -gmomentR1 arcsec REAL 4 -999 moment R1 -gmomentRH arcsec REAL 4 -999 moment RH - or half light radius (REMOVE) -gPSFFlux adu/sec REAL 4 -999 g psf flux from stack -gPSFFluxErr adu/sec REAL 4 -999 estimated error of g psf flux from stack -gApFlux adu/seconds REAL 4 -999 Aperture magnitude -gApFluxErr adu/seconds REAL 4 -999 Aperture magnitude error -gApFillFac dimensionless REAL 4 -999 Aperture fill factor - ~ redundant with psfQF, keep? -gKronFlux adu/seconds REAL 4 -999 Kron flux -gKronFluxErr adu/seconds REAL 4 -999 Kron flux error -gKronRad arcsec REAL 4 -999 Kron radius Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra.txt (revision 37246) @@ -0,0 +1,49 @@ + +objID | from StackObjectThin +gcObjID | ** DROP +ippObjID | from StackObjectThin +surveyID | from StackObjectThin +skyCellID | from StackObjectThin +randomStackObjID | from StackObjectThin +stackDetectRowID | from StackObjectThin +primaryDetection | +bestDetection | + | +dvoRegionID | from StackObjectThin +dataRelease | from StackObjectThin +------------------| +-- | +-- | +------------------| +gippDetectID | from StackObjectThin +gstackDetectID | from StackObjectThin +gstackMetaID | from StackObjectThin +------------------| +gxPos | cmf X_PSF +gyPos | cmf Y_PSF +gxPosErr | cmf X_PSF_SIG +gyPosErr | cmf Y_PSF_SIG +gpsfMajorFWHM | cmf +gpsfMinorFWHM | cmf +gpsfTheta | cmf +gpsfCore | cmf +gpsfLikelihood | cmf +gpsfQf | cmf +gpsfQfPerfect | cmf +gpsfChiSq | cmf +gmomentXX | cmf +gmomentXY | cmf +gmomentYY | cmf +gmomentR1 | cmf +gmomentRH | cmf +gPSFFlux | cmf +gPSFFluxErr | cmf +gApFlux | cmf +gApFluxErr | cmf +gApFillFac | cmf +gKronFlux | cmf +gKronFluxErr | cmf +gKronRad | cmf +gexpTime | dvopsps +gzp | dvopsps + Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw (revision 37246) @@ -0,0 +1,41 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. + the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +------------------------------------------------------------------------------------------ +gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +------------------------------------------------------------------------------------------ +gxPos pixels REAL 4 -999 measured x in sky Cell from PSF fit +gyPos pixels REAL 4 -999 measured y in sky Cell from PSF fit +gxPosErr pixels REAL 4 -999 estimated error in x +gyPosErr pixels REAL 4 -999 estimated error in y +gpsfMajorFWHM arcsec REAL 4 -999 PSF width in major axis +gpsfMinorFWHM arcsec REAL 4 -999 PSF width in minor axis +gpsfTheta degrees REAL 4 -999 PSF orientation angle. Degrees East of North. +gpsfCore dimensionless REAL 4 -999 PSF core parameter [k in (1 + kz + z^1.66)] +gpsfLikelihood dimensionless REAL 4 -999 PSF likelihood +gpsfQf dimensionless REAL 4 -999 PSF coverage factor +gpsfQfPerfect dimensionless REAL 4 -999 PSF-weighted fraction of arcsec totally unmasked +gpsfChiSq dimensionless REAL 4 -999 PSF-weighted fraction of arcsec to. +gmomentXX arcsec^2 REAL 4 -999 moment XX +gmomentXY arcsec^2 REAL 4 -999 moment XY +gmomentYY arcsec^2 REAL 4 -999 moment YY +gmomentR1 arcsec REAL 4 -999 moment R1 +gmomentRH arcsec REAL 4 -999 moment RH - or half light radius (REMOVE) +gPSFFlux adu/sec REAL 4 -999 g psf flux from stack +gPSFFluxErr adu/sec REAL 4 -999 estimated error of g psf flux from stack +gApFlux adu/seconds REAL 4 -999 Aperture magnitude +gApFluxErr adu/seconds REAL 4 -999 Aperture magnitude error +gApFillFac dimensionless REAL 4 -999 Aperture fill factor - ~ redundant with psfQF, keep? +gKronFlux adu/seconds REAL 4 -999 Kron flux +gKronFluxErr adu/seconds REAL 4 -999 Kron flux error +gKronRad arcsec REAL 4 -999 Kron radius +gexpTime seconds REAL 4 -999 total exposure time (informational) +gzp magnitude REAL 4 0 zeropoint , no error given +gPlateScale arcsec/pixel REAL 4 0 plate scale Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw.txt (revision 37246) @@ -0,0 +1,42 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 + +------------------ +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +------------------ +gxPos + cmf : X_PSF +gyPos + cmf : Y_PSF +gxPosErr + cmf : X_PSF_SIG +gyPosErr + cmf : Y_PSF_SIG +gpsfMajorFWHM + cmf : PSF_FWHM_MAJ +gpsfMinorFWHM + cmf : PSF_FWHM_MIN +gpsfTheta + cmf : PSF_THETA +gpsfCore + cmf : PSF_CORE +gpsfLikelihood - cmf : psfLikelihood(EXT_NSIGMA) ** problem with calculation? plot +gpsfQf + cmf : PSF_QF +gpsfQfPerfect + cmf : PSF_QF_PERFECT +gpsfChiSq + cmf : PSF_CHISQ / PSF_NDOF +gmomentXX + cmf : MOMENTS_XX +gmomentXY + cmf : MOMENTS_XY +gmomentYY + cmf : MOMENTS_YY +gmomentR1 + cmf : MOMENTS_R1 +gmomentRH + cmf : MOMENTS_RH +gPSFFlux + cmf : PSF_INST_FLUX / exptime +gPSFFluxErr + cmf : PSF_INST_FLUX_SIG / exptime +gApFlux + cmf : AP_FLUX / exptime +gApFluxErr + cmf : AP_FLUX_SIG / exptime +gApFillFac + cmf : AP_NPIX / (3.14159265359 * POW(b.AP_MAG_RADIUS - 0.5, 2)) ** adjusted formula, re-check +gApRadius + cmf : AP_MAG_RADIUS +gKronFlux + cmf : KRON_FLUX / exptime +gKronFluxErr + cmf : KRON_FLUX_ERR / exptime +gKronRad + cmf : MOMENTS_R1 * 2.5 +gexpTime + cmf : header EXPTIME +gzp + dvo : zp ** clarify in dvopsps +gPlateScale + cmf : PLTSCALE Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin (revision 37246) @@ -1,39 +1,39 @@ -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier -randomStackObjID dimensionless BIGINT 8 NA random stack id -stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best -primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. -bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. - the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. -dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region -dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. +objID dimensionless BIGINT 8 NA ODM object identifier +ippObjID dimensionless BIGINT 8 NA object ID generated by IPP [this is a per-object, not per-filter value] +surveyID dimensionless TINYINT 1 NA survey flag identifier +tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) +projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 +skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. +-- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region +dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. ------------------------------------------------------------------------------------------ -- attributes for all stack detections in all filters (these are currently forced anyway) -- Replicate the section below for each filter, changing the prefex ("g" in this example) ------------------------------------------------------------------------------------------ -gippObjID dimensionless BIGINT 8 NA object ID generated by IPP -gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP -gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier -gstackMetaID dimensionless BIGINT 8 NA stack identifier +gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier ------------------------------------------------------------------------------------------ -gra degrees FLOAT 8 NA Right Ascension -gdec degrees FLOAT 8 NA Declination -graErr arcsec REAL 4 NA Right Ascension error -gdecErr arcsec REAL 4 NA Declination error (same as RA error - need?) -gzp magnitude REAL 4 0 zeropoint , no error given -gPSFMag AB_magnitude REAL 4 -999 g psf AB magnitude from stack -gPSFMagErr AB_magnitude REAL 4 -999 estimated error of g psf AB magnitude from stack -gApMag AB_magnitude REAL 4 -999 g Aperture AB magnitude from stack -gApMagErr AB_magnitude REAL 4 -999 estimated error of g Ap Mag AB magnitude from stack -gKronMag AB_magnitude REAL 4 -999 g kron AB magnitude from stack -gKronMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude from stack -gsky adu/secs/arcsec REAL 4 -999 PSF sky level at source (adu) -gskyErr adu/secs/arcsec REAL 4 -999 estimated error in sky -ginfoFlag dimensionless INT 4 -999 indicator of strange propeties -ginfoFlag2 dimensionless INT 4 -999 indicator of strange propeties -gnFrames dimensionless INT 4 -999 Number of frames contributing to source +gra degrees FLOAT 8 NA Right Ascension +gdec degrees FLOAT 8 NA Declination +graErr arcsec REAL 4 NA Right Ascension error +gdecErr arcsec REAL 4 NA Declination error (same as RA error - need?) +gPSFMag AB_magnitude REAL 4 -999 g psf AB magnitude from stack +gPSFMagErr AB_magnitude REAL 4 -999 estimated error of g psf AB magnitude from stack +gApMag AB_magnitude REAL 4 -999 g Aperture AB magnitude from stack +gApMagErr AB_magnitude REAL 4 -999 estimated error of g Ap Mag AB magnitude from stack +gKronMag AB_magnitude REAL 4 -999 g kron AB magnitude from stack +gKronMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude from stack +gsky adu/secs/arcsec REAL 4 -999 PSF sky level at source (adu) +gskyErr adu/secs/arcsec REAL 4 -999 estimated error in sky +ginfoFlag dimensionless INT 4 0 informational bits +ginfoFlag2 dimensionless INT 4 0 informational bits +gnFrames dimensionless INT 4 -999 Number of frames contributing to source -- [220 byte/filter/obj + 44 byte/obj] Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (revision 37246) @@ -0,0 +1,39 @@ + +-- fields marked with + below have been verified by EAM in the ippToPsps output mysql tables + +objID + dvo = average.extID [calculated in addstar] +ippObjID + dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] +surveyID + ipptopsps : internal, from survey name +tessID + smf : TESS_ID (table mapping) +projectionID + smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +skycellID + smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +randomStackObjID + ipptopsps (RANDOM on sql into mysql) +stackDetectRowID - set by PSPS +primaryDetection + (dvo:measure.dbFlags >> 16) +bestDetection - dvo * THIS CANNOT BE SET UNTIL LATER (after PV3 initial ingest to psps) + +dvoRegionID + dvo = measure.catID +dataRelease + ippToPsps : user input (skychunk.dataRelease) +-- +-- +-- +-- +gippDetectID + dvopsps.ippDetectID = dvo:measure.detID = smf / IPP_IDET +gstackDetectID + dvopsps.detectID = dvo:measure.extID [calculated in addstar: psps stack detect ID] +gstackMetaID + ipptopsps : gpc1 db, matches cmf IMAGEID +-- +gra + dvo = measure.ra +gdec + dvo = measure.dec +graErr + dvo = X_PSF_SIG * PLTSCALE +gdecErr + dvo = X_PSF_SIG * PLTSCALE +gPSFMag + dvo = measure.Mpsf +gPSFMagErr + dvo = measure.dMpsf +gApMag + dvo = measure.Map +gApMagErr + dvo = measure.dMap +gKronMag + dvo = measure.Mkron +gKronMagErr + dvo = measure.dMkron +gsky + smf : SKY / exptime +gskyErr + smf : SKY_SIGMA / exptime +ginfoFlag + smf : FLAGS +ginfoFlag2 - smf + dvo : FLAGS2 | measure.flags << 13 *** we only include measure.dbflags, not secfilt.flags +gnFrames + smf : N_FRAMES Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian (revision 37246) @@ -0,0 +1,22 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +ippbjID dimensionless BIGINT 8 NA object ID generated by IPP +randomStackObjID dimensionless BIGINT 8 NA random stack id +stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best +primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. +bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. +-- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. +-------------------------------------------------------- replicate below for all filters (grizy) +gippDetectID dimensionless BIGINT 8 NA ipp detect identifier +gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier +gstackMetaID dimensionless BIGINT 8 NA stack identifier +---------------------------------------------------------------------------------------- +gpetRadius arcsec REAL 4 -999 Petrosian radius +gpetRadiusErr arcsec REAL 4 -999 estimated error inPetrosian radius +gpetMag AB_mag REAL 4 -999 Petrosian Flux +gpetMagErr AB_mag REAL 4 -999 estimated error in petFlux +gpetR50 arcsec REAL 4 -999 Petrosian radius at 50% light +gpetR50Err arcsec REAL 4 -999 estimated error inPetrosian radius at 50% light +gpetR90 arcsec REAL 4 -999 Petrosian radius at 90% light +gpetR90Err arcsec REAL 4 -999 estimated error in Petrosian radius at 90% light +gpetCf dimensionless REAL 4 -999 Petrosian fit coverage factor Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt (revision 37246) @@ -0,0 +1,22 @@ + +objID + from StackObjectThin +ippbjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gpetRadius + cmf : PETRO_RADIUS +gpetRadiusErr + cmf : PETRO_RADIUS_ERR +gpetMag + cmf : PETRO_MAG - header:FPA.ZP + dvo.zp +gpetMagErr + cmf : PETRO_MAG_ERR +gpetR50 + cmf : PETRO_RADIUS_50 +gpetR50Err + cmf : PETRO_RADIUS_50_ERR +gpetR90 + cmf : PETRO_RADIUS_90 +gpetR90Err + cmf : PETRO_RADIUS_90_ERR +gpetCf - cmf : PETRO_FILL ** consistently > 1.0?? [problem in cmf] Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt (revision 37246) @@ -0,0 +1,22 @@ + +tables processed by the different batch types: + +objectbatch.py: + ObjectThin + MeanObject + +detectionbatch.py: + Detection + +stackbatch.py: + StackObjectThin - populated for all stack detections * checked + StackObjectRaw - populated for all stack detections * checked + StackModelFitThin - populated for Galactic Cap regions + StackModelFitDeV - populated for Galactic Cap regions * checked + StackModelFitExp - populated for Galactic Cap regions * checked + StackModelFitSer - populated for Galactic Cap regions * checked + StackApFlx - populated for all stack detections + StackApFlxFull - populated for Galactic Cap regions * checked + StackApFlxFullC1 - populated for Galactic Cap regions * checked + StackApFlxFullC2 - populated for Galactic Cap regions * checked + StackPetrosian - populated for Galactic Cap regions * checked Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/schema18.notes.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/schema18.notes.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/schema18.notes.txt (revision 37246) @@ -0,0 +1,159 @@ + +This document describes the new PSPS schema (18.0) and identifies existing problems. + +ObjectThin + + Changes since Schema 16.0: + + * DROPPED gcObjID (concept rejected by DRAVG) + * replaced skycellID (REAL) with combination of tessID, projectionID, skycellID (1,2,1 byte INTs) + * replaced raMeanStd, decMeanStd (not calculated) with posMeanChisq + + Concerns: + + * objName is generated by SQL in ippToPsps and is probably fragile: move to dvopsps? + * fields calculated by PSPS and not tested (htmID, zoneID, cx,cy,cz, lambda,beta, l,b) + * nStackObjectRows is not calculated + * should nStackDetections be split per filter? + * quality flag is currently the upper byte of dvo:average.flags, is this reasonable? + * consistency flag is hard-wired as 0 + * raStack, etc are not yet calculated by relastro (set to match raMean, etc) + +MeanObject + + Changes since Schema 16.0: + + * DROPPED gcObjID (concept rejected by DRAVG) + * CHANGED gFlags to be 4 byte not 8 byte (secfilt.flags is 4 byte) + * renamed fields to have consistent naming structure: + * gMeanTYPEMagVALUE, where TYPE = (PSF, Kron, Ap) and VALUE = (Err, Std, Min Max, Npt) + + Concerns: + + * NONE + +Detections + + Changes since Schema 16.0: + + * ADDED apRadius + * DROPPED gcObjID (concept rejected by DRAVG) + * DROPPED kronRadErr (not measured by psphot, probably not needed?) + + Concerns: + + * imageID : this is currently generated from expID + ccd X,Y. + shouldn't we use gpc1.chipImfile.chip_imfile_id? (IMAGE_ID in + header) + * double-check reported value for zero point (needs to include airmass term, etc) + + Implementation Changes: + + * raErr,decErr are now taken from the SMF file not from dvo (x,y errors truncated in dvo) + * dvoRegion now uses CAT_ID from dvopsps + * psfMajor,MinorFWHM use PSF_FWHM_MJA,MIN + * added PSF_CORE to smf + * apFlux, kronFlux use FLUX values directly from smf + +Stacks + + Measurements related to the stacks are now split into 11 separate + tables depending on the measurements and, in some cases, the Galactic + latitude. The granularity of the split is partly mandated by the + inability of PSPS or its ingest system to handle excessively wide + tables. Note that in all of the tables below, a single row represents + the set of measurements from all 5 filters (grizy) for the aparition + of an astronomical object in a single skycell. The primaryDetection + flag is set to identify the row which comes from the primary skycell + for that location on the sky. + + Several of the tables are meant to be filled only for the Galactic cap + regions. As of 2014.08.09, ippToPsps is not setting this limit. + These tables are: + + StackModelFitDeV + StackModelFitExp + StackModelFitSer + StackModelFitExtra + StackApFlxFull + StackApFlxFullC1 + StackApFlxFullC2 + StackPetrosian + + Other general concerns: + + * various size-related fields are reported in pixels not arcseconds. + + * I need to double-check the reported zero point and telluric + extinction values. + + * are we defining too many radial apertures? + + The tables are divided as follows: + + StackObjectThin : basic properties of the stack object detection. + * stackDetectRowID : this field will be set by PSPS and cannot be + tested in the ippToPsps code + + * bestDetection : this field cannot be set until the entire PSPS is + populated. this will be deferred until the end of + the ingest. + + * primaryDetection : NOT YET TESTED + * xinfoFlag2 : currently only includes bits from + dvo:measure.dbflags but not dvo:secfilt.flags + + * NOTE : stackDetectRowID, bestDetection, primaryDetection are + inherited by the following tables from StackObjectThin, so the issue + above are present in all Stack tables + + StackObjectRaw : raw measurement values from the PSF fits + * xpsfLikelihood : some values seem to be negative, which should + not be allowed + + StackModelFitExtra : extra properties derived from extended source + fits. NOTE: this table is not being generated + + StackModelFitExp : Exponential model fit parameters + * xExpRadiusErr : EXT_WIDTH_MAJ_SIG is not being set in the CMF file + * xExpAbErr : EXT_WIDTH_MIN_SIG is not being set in the CMF file + * xExpPhiErr : not set in CMF + * xExpRa,Dec : this position is currently an approximation based on + X_EXT, X_PSF and the plate scale + * xExpRa,DecErr : circularly symmetric approximation based on S/N + * xExpCf : not calculated in psphot + * xExpChisq : the fit chisq is provided, not the likelihood + + StackModelFitDeV : DeVaucouleur model fit parameters + * NOTE same issues as for Exp + + StackModelFitSer : Sersic model fit parameters + * NOTE same issues as for Exp, also: + * xSerNuErr : value is hard-wired at 0.1, and not well-measured + in CMF + + StackApFlx : flux measured in radial apertures (only 3 radii; raw and + both convolutions) + + * standard deviation fields (eg, gflxR3Std) are measured in psphot as + the standard deviation across the full object. Should this perhaps + be a measurement of the standard deviation after the radial profile + is subtracted? + + StackApFlxFull : flux measured in radial apertures (raw, all radii) + + * see note above on Standard Deviation + * radius 10 is not measured or reported in the CMF + + StackApFlxFullC1 : flux measured in radial apertures (first convolution, all radii) + + * see note above on Standard Deviation + * radius 10 is not measured or reported in the CMF + + StackApFlxFullC2 : flux measured in radial apertures (second convolution, all radii) + + * see note above on Standard Deviation + * radius 10 is not measured or reported in the CMF + + StackPetrosian : petrosian analysis data + * xpetCf : fill factor is mis-calculated in psphot (consistently > 1.0) Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/FrameMeta =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/FrameMeta (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/FrameMeta (revision 37246) @@ -1,49 +1,49 @@ -frameID dimensionless INT 4 NA unique exposure/frame identifier. -frameName dimensionless VARCHAR(32) 32 NA frame name provided by camera software -surveyID dimensionless TINYINT 1 NA survey flag identifier -filterID dimensionless TINYINT 1 NA filter identifier -cameraID dimensionless SMALLINT 2 NA camera identifier -cameraConfigID dimensionless SMALLINT 2 NA camera configuration identifier -telescopeID dimensionless SMALLINT 2 NA telescope identifier -analysisVer alphanumeric VARCHAR(MAX) 8000 IPP software analysis release -p1Recip alphanumeric VARCHAR(MAX) 8000 IPP phase 1 MD5 Checksum -p2Recip alphanumeric VARCHAR(MAX) 8000 IPP phase 2 MD5 Checksum -p3Recip alphanumeric VARCHAR(MAX) 8000 IPP phase 3 MD5 Checksum -nOTA alphanumeric SMALLINT 2 -999 number of valid OTA/CCD images in this exposure -photoScat magnitude REAL 4 -999 global photometric scatter -numPhotoRef dimensionless INT 4 -999 number of photometric reference sources -expStart days FLOAT 8 -999 exposure start time in MJD -expTime seconds REAL 4 -999 exposure time -airmass dimensionless REAL 4 -999 airmass at mid-exposure -raBore degrees FLOAT 8 -999 RA of telescope boresight -decBore degrees FLOAT 8 -999 DEC of telescope boresight -ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA -ctype2 VARCHAR(MAX) 8000 name of astrometric projection in DEC -crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel -crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel -crpix1 pc001001 FLOAT 8 -999 reference pixel value for RA -crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC -cdelt1 degrees/pixel FLOAT 8 -999 scale factor for RA -cdelt2 degrees/pixel FLOAT 8 -999 scale factor for DEC -pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix -pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix -pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix -pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix -polyOrder dimensionless TINYINT 1 255 polynomial order of astrometry fit -pca1x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca1x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca1x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca1x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca1x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca1x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca1x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca2x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca2x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca2x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca2x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca2x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca2x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -pca2x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit -calibModNum dimensionless SMALLINT 2 NA calibration modification number -batchID dimensionless BIGINT 8 NA batch ID -dataRelease dimensionless TINYINT 1 NA Data release Version of this table +frameID dimensionless INT 4 NA unique exposure/frame identifier. +frameName dimensionless VARCHAR(32) 32 NA frame name provided by camera software +surveyID dimensionless TINYINT 1 NA survey flag identifier +filterID dimensionless TINYINT 1 NA filter identifier +cameraID dimensionless SMALLINT 2 NA camera identifier +cameraConfigID dimensionless SMALLINT 2 NA camera configuration identifier +telescopeID dimensionless SMALLINT 2 NA telescope identifier +analysisVer alphanumeric VARCHAR(MAX) 8000 NA IPP software analysis release +p1Recip alphanumeric VARCHAR(MAX) 8000 NA IPP phase 1 MD5 Checksum +p2Recip alphanumeric VARCHAR(MAX) 8000 NA IPP phase 2 MD5 Checksum +p3Recip alphanumeric VARCHAR(MAX) 8000 NA IPP phase 3 MD5 Checksum +nOTA alphanumeric SMALLINT 2 -999 number of valid OTA/CCD images in this exposure +photoScat magnitude REAL 4 -999 global photometric scatter +numPhotoRef dimensionless INT 4 -999 number of photometric reference sources +expStart days FLOAT 8 -999 exposure start time in MJD +expTime seconds REAL 4 -999 exposure time +airmass dimensionless REAL 4 -999 airmass at mid-exposure +raBore degrees FLOAT 8 -999 RA of telescope boresight +decBore degrees FLOAT 8 -999 DEC of telescope boresight +ctype1 alphanumeric VARCHAR(MAX) 8000 NA name of astrometric projection in RA +ctype2 alphanumeric VARCHAR(MAX) 8000 NA name of astrometric projection in DEC +crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel +crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel +crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA +crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC +cdelt1 degrees/pixel FLOAT 8 -999 scale factor for RA +cdelt2 degrees/pixel FLOAT 8 -999 scale factor for DEC +pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +polyOrder dimensionless TINYINT 1 255 polynomial order of astrometry fit +pca1x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca1x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +pca2x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit +calibModNum dimensionless SMALLINT 2 NA calibration modification number +batchID dimensionless BIGINT 8 NA batch ID +dataRelease dimensionless TINYINT 1 NA Data release Version of this table Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/FrameMeta.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/FrameMeta.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/FrameMeta.txt (revision 37246) @@ -0,0 +1,50 @@ +frameID | ipptopsps : gpc1.rawExp.exp_id +frameName | ipptopsps : gpc1.rawExp.exp_name +surveyID | ipptopsps : internal, from survey name +filterID | ipptopsps : internal, lookup from filter (grizy) +cameraID | ipptopsps : hardwired to 1 *** +cameraConfigID | ipptopsps : hardwired to 1 *** +telescopeID | ipptopsps : hardwired to 1 *** +analysisVer | ipptopsps : gpc1.camRun.software_ver +p1Recip | * NOT SET +p2Recip | * NOT SET +p3Recip | * NOT SET +nOTA | ipptopsps : count of OTAs +photoScat | cmf: ZPT_ERR +numPhotoRef | sum(cmf:NASTRO) +expStart | cmf:MJD-OBS +expTime | cmf:EXPREQ +airmass | cmf:AIRMASS +raBore | cmf:RA +decBore | cmf:DEC +ctype1 | cmf:CTYPE1 +ctype2 | cmf:CTYPE2 +crval1 | cmf:CRVAL1 +crval2 | cmf:CRVAL2 +crpix1 | cmf:CRPIX1 +crpix2 | cmf:CRPIX2 +cdelt1 | cmf:CDELT1 +cdelt2 | cmf:CDELT2 +pc001001 | cmf:PC001001 +pc001002 | cmf:PC001002 +pc002001 | cmf:PC002001 +pc002002 | cmf:PC002002 +polyOrder | cmf:NPLYTERM +pca1x3y0 | cmf:PCA1X3Y0 +pca1x2y1 | cmf:PCA1X2Y1 +pca1x1y2 | cmf:PCA1X1Y2 +pca1x0y3 | cmf:PCA1X0Y3 +pca1x2y0 | cmf:PCA1X2Y0 +pca1x1y1 | cmf:PCA1X1Y1 +pca1x0y2 | cmf:PCA1X0Y2 +pca2x3y0 | cmf:PCA2X3Y0 +pca2x2y1 | cmf:PCA2X2Y1 +pca2x1y2 | cmf:PCA2X1Y2 +pca2x0y3 | cmf:PCA2X0Y3 +pca2x2y0 | cmf:PCA2X2Y0 +pca2x1y1 | cmf:PCA2X1Y1 +pca2x0y2 | cmf:PCA2X0Y2 +calibModNum | ipptopsps: hardwired to 0 *** +batchID | ipptopsps: internal +dataRelease | ipptopsps: user input (skychunk.dataRelease) + Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/ImageMeta =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/ImageMeta (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/ImageMeta (revision 37246) @@ -22,15 +22,12 @@ psfWidMinor arcsec REAL 4 -999 model PSF parameters at chip center psfTheta degrees REAL 4 -999 model PSF parameters at chip center -momentXX pixels REAL 4 -999 moment XX -momentXY pixels REAL 4 -999 moment XY -momentYY pixels REAL 4 -999 moment YY -momentM3C pixels squared REAL 4 -999 moment M3C -momentM3S pixels squared REAL 4 -999 moment M3S -momentM4C pixels squared REAL 4 -999 moment M4C -momentM4S pixels squared REAL 4 -999 moment M4S -momentR1 pixels REAL 4 -999 moment R1 -momentRH sqrt pixels REAL 4 -999 moment RH -apResid magnitide REAL 4 -999 corrected aperture residual -dapResid magnitide REAL 4 -999 scatter of aperture corrections +momentMajor pixels REAL 4 -999 momentMajor +momentMinor pixels REAL 4 -999 momentMinor +momentM2C pixels squared REAL 4 -999 momentM2C +momentM2S pixels squared REAL 4 -999 momentM2S +momentM3 pixels squared REAL 4 -999 momentM3 +momentM4 pixels squared REAL 4 -999 momentM4 +apResid magnitude REAL 4 -999 corrected aperture residual +dapResid magnitude REAL 4 -999 scatter of aperture corrections detectorID alphanumeric VARCHAR(32) 32 identifier for actual CCD chip qaFlags dimensionless BIGINT 8 -999 Q/A flags for this OTA Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/ImageMeta.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/ImageMeta.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/ImageMeta.txt (revision 37246) @@ -0,0 +1,71 @@ +imageID | ipptopsps : expID x y (*** is this right???) (smf:IMAGEID / gpc1.chipRun.chip_image_id)_ +frameID | ipptopsps : gpc1.rawExp.exp_id +ccdID | ipptopsps : from XYnn +photoCalID | dvo:photcode (from photcode table) +filterID | ipptopsps : internal, lookup from filter (grizy) +bias | gpc1.rawExp.bg *** WRONG! +biasScat | gpc1.rawExp.bg_stdev *** WRONG! +sky | MSKY_MN +skyScat | MSKY_SIG +nDetect | ipptopsps : rows(Detection table) +magSat | FSATUR +completMag | FLIMIT +astroScat | CERROR +photoScat | ZPT_OBS ** wrong +numAstroRef | NASTRO +numPhotoRef | NASTRO +nx | CNAXIS1 +ny | CNAXIS2 +psfModelID | ** NOT SET +psfFwhm | 0.5*(FWHM_MAJ + FWHM_MIN) +psfWidMajor | FWHM_MAJ +psfWidMinor | FWHM_MIN +psfTheta | ANGLE +momentMajor | IQ_FW1 +momentMinor | IQ_FW1 +momentM2C | IQ_M2C +momentM2S | IQ_M2S +momentM3 | IQ_M3 +momentM4 | IQ_M4 +apResid | APMIFIT +dapResid | DAPMIFIT +detectorID | DETECTOR +qaFlags | dvo:image.flags +detrend1 | DETREND.MASK +detrend2 | DETREND.DARK +detrend3 | DETREND.FLAT +detrend4 | ** NOT SET +detrend5 | ** NOT SET +detrend6 | ** NOT SET +detrend7 | ** NOT SET +detrend8 | ** NOT SET +photoZero | ZPT_OBS +ctype1 | CTYPE1 +ctype2 | CTYPE2 +crval1 | CRVAL1') +crval2 | CRVAL2') +crpix1 | CRPIX1') +crpix2 | CRPIX2') +cdelt1 | CDELT1') +cdelt2 | CDELT2') +pc001001 | PC001001 +pc001002 | PC001002 +pc002001 | PC002001 +pc002002 | PC002002 +polyOrder | NPLYTERM +pca1x2y0 | PCA1X2Y0 +pca1x1y1 | PCA1X1Y1 +pca1x0y2 | PCA1X0Y2 +pca2x2y0 | PCA2X2Y0 +pca2x1y1 | PCA2X1Y1 +pca2x0y2 | PCA2X0Y2 +pca1x3y0 | PCA1X3Y0 +pca1x2y1 | PCA1X2Y1 +pca1x1y2 | PCA1X1Y2 +pca1x0y3 | PCA1X0Y3 +pca2x3y0 | PCA2X3Y0 +pca2x2y1 | PCA2X2Y1 +pca2x1y2 | PCA2X1Y2 +pca2x0y3 | PCA2X0Y3 +calibModNum | ipptopsps: hardwired to 0 *** +dataRelease | ipptopsps: user input (skychunk.dataRelease) Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta (revision 37000) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta (revision 37246) @@ -1,35 +1,37 @@ -stackMetaID dimensionless BIGINT 8 NA stack identifier -batchID dimensionless BIGINT 8 NA batch identifier -surveyID dimensionless TINYINT 1 NA survey flag identifier -filterID dimensionless TINYINT 1 NA fnilutemr eidriecnatl ifidier -stackTypeID dimensionless TINYINT 1 0 stack type identifier -skyCellID dimensionless REAL 4 NA skycell region identifier -photoCalID dimensionless INT 4 NA photometry code -magSat dimensionless REAL 4 -999 saturation magnitude level -analVer dimensionless SMALLINT 2 -999 analysis version index -expTime seconds REAL 4 -999 exposure time -nP2Images dimensionless SMALLINT 2 -999 number of P2 images contributing to this cell -completMag magnitudes REAL 4 -999 95% completion level in mag -astroScat dimensionless REAL 4 -999 astrometric scatter for chip -photoScat dimensionless REAL 4 -999 photometric scatter for chip -nAstroRef dimensionless INT 4 -999 number of astrometric reference sources -nPhoRef dimensionless INT 4 -999 number of photometric reference sources -psfModelID dimensionless VARCHAR(MAX) 8000 PSF model identifier -psfFwhm_mean arcsec FLOAT 8 -999 mean PSF FWHM in the stack -psfFwhm_max arcsec FLOAT 8 -999 maximum PSF FWHM in the stack -photoZero magnitudes REAL 4 -999 local derived photometric zero point -photoColor magnitudes REAL 4 -999 local derived photometric color term -ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA -ctype2 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in DEC -crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel -crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel -crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA -crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC -cdelt1 deg/pixel FLOAT 8 -999 scale factor for RA -cdelt2 deg/pixel FLOAT 8 -999 scale factor for DEC -pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix -pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix -pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix -pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix -calibModNum dimensionless SMALLINT 2 NA calibration modification number -dataRelease dimensionless TINYINT 1 NA Data release +stackMetaID dimensionless BIGINT 8 NA stack identifier +batchID dimensionless BIGINT 8 NA batch identifier +surveyID dimensionless TINYINT 1 NA survey flag identifier +filterID dimensionless TINYINT 1 NA filter number identifier +stackTypeID dimensionless TINYINT 1 0 stack type identifier +tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) +projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 +skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) +photoCalID dimensionless INT 4 NA photometry code +magSat dimensionless REAL 4 -999 saturation magnitude level +analysisVer dimensionless INT 4 -999 analysis version index x +expTime seconds REAL 4 -999 exposure time +nP2Images dimensionless SMALLINT 2 -999 number of P2 images contributing to this cell +completMag magnitudes REAL 4 -999 95% completion level in mag +astroScat dimensionless REAL 4 -999 astrometric scatter for chip +photoScat dimensionless REAL 4 -999 photometric scatter for chip +nAstroRef dimensionless INT 4 -999 number of astrometric reference sources +nPhotomRef dimensionless INT 4 -999 number of photometric reference sources +psfModelID dimensionless VARCHAR(MAX) 8000 PSF model identifier +psfFwhm_mean arcsec FLOAT 8 -999 mean PSF FWHM in the stack +psfFwhm_max arcsec FLOAT 8 -999 maximum PSF FWHM in the stack +photoZero magnitudes REAL 4 -999 local derived photometric zero point +photoColor magnitudes REAL 4 -999 local derived photometric color term +ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA +ctype2 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in DEC +crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel +crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel +crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA +crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC +cdelt1 deg/pixel FLOAT 8 -999 scale factor for RA +cdelt2 deg/pixel FLOAT 8 -999 scale factor for DEC +pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix +calibModNum dimensionless SMALLINT 2 NA calibration modification number +dataRelease dimensionless TINYINT 1 NA Data release Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt (revision 37246) @@ -0,0 +1,37 @@ +stackMetaID | ipptopsps : gpc1 db, matches cmf IMAGEID +batchID | ipptopsps : internal +surveyID | ipptopsps : internal, from survey name +filterID | ipptopsps : internal, lookup from filter (grizy) +stackTypeID | ipptopsps : internal, *** hard-wired name *** +tessID | smf : TESS_ID (table mapping) +projectionID | smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +skycellID | smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +photoCalID | dvo.images : photcode +magSat | * NOT SET +analysisVer | gpc1.stackRun.software_ver [EAM: changed this name] +expTime | cmf header EXPTIME +nP2Images | [populateStackToImage] : counts inputs NOTE is this set reasonable? +completMag | * NOT SET +astroScat | * NOT SET +photoScat | * NOT SET +nAstroRef | * NOT SET +nPhotomRef | * NOT SET +psfModelID | cmf header PSFMODEL +psfFwhm_mean | cmf header FWHM_MAJ *** probably wrong value +psfFwhm_max | cmf header FW_MJ_UW *** name and definition are inconsistent +photoZero | cmf header FPA.ZP *** this is not dvo corrected) +photoColor | * NOT SET +ctype1 | cmf header +ctype2 | cmf header +crval1 | cmf header +crval2 | cmf header +crpix1 | cmf header +crpix2 | cmf header +cdelt1 | cmf header +cdelt2 | cmf header +pc001001 | cmf header +pc001002 | cmf header +pc002001 | cmf header +pc002002 | cmf header +calibModNum | * NOT SET +dataRelease | ipptopsps : user input (skychunk.dataRelease) Index: trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/TessellationType =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/TessellationType (revision 37246) +++ trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/TessellationType (revision 37246) @@ -0,0 +1,3 @@ +tessID TINYINT 1 -999 stack type identifier +name VARCHAR(20) 20 NULL stack type name +description VARCHAR(MAX) 8000 NULL stack type description