Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing (revision 37840) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing (revision 37840) @@ -0,0 +1,32 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier index +uniquePspsFOid dimensionless BIGINT 8 NA unique id supplied by ipptopsps +ippObjID dimensionless BIGINT 8 NA IPP object identifier +nDetections dimensionless SMALLINT 2 -999 total number of detection measurements in all filters +batchID dimensionless BIGINT 8 NA batch id +----------------------------------------------------- replicate to bottom for each filter +gStackID dimensionless INT 4 stack image id (how to carry through IPP + DVO) +gLensObjSmearX11 arcsec^-2 REAL 4 -999 per-object smear polarizability X11 term +gLensObjSmearX12 arcsec^-2 REAL 4 -999 per-object smear polarizability X12 term +gLensObjSmearX22 arcsec^-2 REAL 4 -999 per-object smear polarizability X22 term +gLensObjSmearE1 arcsec^-2 REAL 4 -999 per-object smear polarizability E1 term +gLensObjSmearE2 arcsec^-2 REAL 4 -999 per-object smear polarizability E2 term +gLensObjShearX11 dimensionless REAL 4 -999 per-object shear polarizability X11 term +gLensObjShearX12 dimensionless REAL 4 -999 per-object shear polarizability X12 term +gLensObjShearX22 dimensionless REAL 4 -999 per-object shear polarizability X22 term +gLensObjShearE1 dimensionless REAL 4 -999 per-object shear polarizability E1 term +gLensObjShearE2 dimensionless REAL 4 -999 per-object shear polarizability E2 term +gLensPSFSmearX11 arcsec^-2 REAL 4 -999 psf model smear polarizability X11 term +gLensPSFSmearX12 arcsec^-2 REAL 4 -999 psf model smear polarizability X12 term +gLensPSFSmearX22 arcsec^-2 REAL 4 -999 psf model smear polarizability X22 term +gLensPSFSmearE1 arcsec^-2 REAL 4 -999 psf model smear polarizability E1 term +gLensPSFSmearE2 arcsec^-2 REAL 4 -999 psf model smear polarizability E2 term +gLensPSFShearX11 dimensionless REAL 4 -999 psf model shear polarizability X11 term +gLensPSFShearX12 dimensionless REAL 4 -999 psf model shear polarizability X12 term +gLensPSFShearX22 dimensionless REAL 4 -999 psf model shear polarizability X22 term +gLensPSFShearE1 dimensionless REAL 4 -999 psf model shear polarizability E1 term +gLensPSFShearE2 dimensionless REAL 4 -999 psf model shear polarizability E2 term + +-- duplicated for other filters +-- [184 byte/obj/filter + 22 byte/obj] + Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing.txt (revision 37840) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanLensing.txt (revision 37840) @@ -0,0 +1,37 @@ + +objID = cpt.extID +uniquePspsFOid = ipptopsps +ippObjID = cpt.objID | cpt.catID << 32 +nDetections = sql sum of cps.NCODE (xnTotal) +batchID = ipptopsps +---------------- = +gStackID = ipptopsps / gpc1 db +gLensObjSmearX11 = cpy.X11_SM_OBJ +gLensObjSmearX12 = cpy.X12_SM_OBJ +gLensObjSmearX22 = cpy.X22_SM_OBJ +gLensObjSmearE1 = cpy.E1_SM_OBJ +gLensObjSmearE2 = cpy.E2_SM_OBJ +gLensObjShearX11 = cpy.X11_SH_OBJ +gLensObjShearX12 = cpy.X12_SH_OBJ +gLensObjShearX22 = cpy.X22_SH_OBJ +gLensObjShearE1 = cpy.E1_SH_OBJ +gLensObjShearE2 = cpy.E2_SH_OBJ +gLensPSFSmearX11 = cpy.X11_SM_PSF +gLensPSFSmearX12 = cpy.X12_SM_PSF +gLensPSFSmearX22 = cpy.X22_SM_PSF +gLensPSFSmearE1 = cpy.E1_SM_PSF +gLensPSFSmearE2 = cpy.E2_SM_PSF +gLensPSFShearX11 = cpy.X11_SH_PSF +gLensPSFShearX12 = cpy.X12_SH_PSF +gLensPSFShearX22 = cpy.X22_SH_PSF +gLensPSFShearE1 = cpy.E1_SH_PSF +gLensPSFShearE2 = cpy.E2_SH_PSF + +[NOTES: + + * PSF Flux, Kron Flux, Ap Flux stats are all + calculated from values in the existing Measure table + + * R5 & R6 ap flux values & lensing parameters need + a new table + Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject (revision 37763) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject (revision 37840) @@ -34,25 +34,4 @@ gFlags dimensionless BIGINT 8 NA flags for g forced ------------------------------------------------------ -gLensObjSmearX11 arcsec^-2 REAL 4 -999 per-object smear polarizability X11 term -gLensObjSmearX12 arcsec^-2 REAL 4 -999 per-object smear polarizability X12 term -gLensObjSmearX22 arcsec^-2 REAL 4 -999 per-object smear polarizability X22 term -gLensObjSmearE1 arcsec^-2 REAL 4 -999 per-object smear polarizability E1 term -gLensObjSmearE2 arcsec^-2 REAL 4 -999 per-object smear polarizability E2 term -gLensObjShearX11 dimensionless REAL 4 -999 per-object shear polarizability X11 term -gLensObjShearX12 dimensionless REAL 4 -999 per-object shear polarizability X12 term -gLensObjShearX22 dimensionless REAL 4 -999 per-object shear polarizability X22 term -gLensObjShearE1 dimensionless REAL 4 -999 per-object shear polarizability E1 term -gLensObjShearE2 dimensionless REAL 4 -999 per-object shear polarizability E2 term -gLensPSFSmearX11 arcsec^-2 REAL 4 -999 psf model smear polarizability X11 term -gLensPSFSmearX12 arcsec^-2 REAL 4 -999 psf model smear polarizability X12 term -gLensPSFSmearX22 arcsec^-2 REAL 4 -999 psf model smear polarizability X22 term -gLensPSFSmearE1 arcsec^-2 REAL 4 -999 psf model smear polarizability E1 term -gLensPSFSmearE2 arcsec^-2 REAL 4 -999 psf model smear polarizability E2 term -gLensPSFShearX11 dimensionless REAL 4 -999 psf model shear polarizability X11 term -gLensPSFShearX12 dimensionless REAL 4 -999 psf model shear polarizability X12 term -gLensPSFShearX22 dimensionless REAL 4 -999 psf model shear polarizability X22 term -gLensPSFShearE1 dimensionless REAL 4 -999 psf model shear polarizability E1 term -gLensPSFShearE2 dimensionless REAL 4 -999 psf model shear polarizability E2 term ------------------------------------------------------- gGamma arcsec^2 REAL 4 -999 second moment (Mxx + Myy) gE1 dimensionless REAL 4 -999 polarization, KSB-corrected (Mxx - Myy) / (Mxx + Myy) Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject.txt (revision 37763) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject.txt (revision 37840) @@ -34,25 +34,4 @@ gFlags = cps.FLAGS ---------------- = -gLensObjSmearX11 = cpy.X11_SM_OBJ -gLensObjSmearX12 = cpy.X12_SM_OBJ -gLensObjSmearX22 = cpy.X22_SM_OBJ -gLensObjSmearE1 = cpy.E1_SM_OBJ -gLensObjSmearE2 = cpy.E2_SM_OBJ -gLensObjShearX11 = cpy.X11_SH_OBJ -gLensObjShearX12 = cpy.X12_SH_OBJ -gLensObjShearX22 = cpy.X22_SH_OBJ -gLensObjShearE1 = cpy.E1_SH_OBJ -gLensObjShearE2 = cpy.E2_SH_OBJ -gLensPSFSmearX11 = cpy.X11_SM_PSF -gLensPSFSmearX12 = cpy.X12_SM_PSF -gLensPSFSmearX22 = cpy.X22_SM_PSF -gLensPSFSmearE1 = cpy.E1_SM_PSF -gLensPSFSmearE2 = cpy.E2_SM_PSF -gLensPSFShearX11 = cpy.X11_SH_PSF -gLensPSFShearX12 = cpy.X12_SH_PSF -gLensPSFShearX22 = cpy.X22_SH_PSF -gLensPSFShearE1 = cpy.E1_SH_PSF -gLensPSFShearE2 = cpy.E2_SH_PSF ----------------- = gGamma = cpy.GAMMA gE1 = cpy.E1 Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (revision 37763) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (revision 37840) @@ -13,25 +13,4 @@ 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 Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (revision 37763) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (revision 37840) @@ -13,25 +13,4 @@ obsTime = cmf ---------------- = -lensObjSmearX11 = cmf.X11_SM_OBJ -lensObjSmearX12 = cmf.X12_SM_OBJ -lensObjSmearX22 = cmf.X22_SM_OBJ -lensObjSmearE1 = cmf.E1_SM_OBJ -lensObjSmearE2 = cmf.E2_SM_OBJ -lensObjShearX11 = cmf.X11_SH_OBJ -lensObjShearX12 = cmf.X12_SH_OBJ -lensObjShearX22 = cmf.X22_SH_OBJ -lensObjShearE1 = cmf.E1_SH_OBJ -lensObjShearE2 = cmf.E2_SH_OBJ -lensPSFSmearX11 = cmf.X11_SM_PSF -lensPSFSmearX12 = cmf.X12_SM_PSF -lensPSFSmearX22 = cmf.X22_SM_PSF -lensPSFSmearE1 = cmf.E1_SM_PSF -lensPSFSmearE2 = cmf.E2_SM_PSF -lensPSFShearX11 = cmf.X11_SH_PSF -lensPSFShearX12 = cmf.X12_SH_PSF -lensPSFShearX22 = cmf.X22_SH_PSF -lensPSFShearE1 = cmf.E1_SH_PSF -lensPSFShearE2 = cmf.E2_SH_PSF ----------------- = flxR5 = cmf.FLX_AP_R5 flxR5Err = cmf.FLX_ERR_AP_R5 Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing (revision 37840) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing (revision 37840) @@ -0,0 +1,38 @@ + +objID dimensionless BIGINT 8 NA ODM object identifier +uniquePspsFWid dimentionless BIGINT 8 NA unique id supplied by ipptopsps +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 +------------------------------------------------------ + +-- [295 byte/det] +-- this table is only for non-Galatic-plane data Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing.txt =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing.txt (revision 37840) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpLensing.txt (revision 37840) @@ -0,0 +1,35 @@ + +objID = cpt.extID +uniquePspsFWid = ipptopsps +detectID = cpm.extID (???) +ippObjID = cpt.obj_ID | cpx.cat_ID << 32 +ippDetectID = cmf.IPP_IDET +filterID = ipptopsps / gpc1 +surveyID = ipptopsps +forcedWarpID = ipptopsps / gpc1 +randomWarpID = ipptopsps +skyCellID = ipptopsps / gpc1 +dvoRegionID = ipptopsps / gpc1 +obsTime = cmf +---------------- = +lensObjSmearX11 = cmf.X11_SM_OBJ +lensObjSmearX12 = cmf.X12_SM_OBJ +lensObjSmearX22 = cmf.X22_SM_OBJ +lensObjSmearE1 = cmf.E1_SM_OBJ +lensObjSmearE2 = cmf.E2_SM_OBJ +lensObjShearX11 = cmf.X11_SH_OBJ +lensObjShearX12 = cmf.X12_SH_OBJ +lensObjShearX22 = cmf.X22_SH_OBJ +lensObjShearE1 = cmf.E1_SH_OBJ +lensObjShearE2 = cmf.E2_SH_OBJ +lensPSFSmearX11 = cmf.X11_SM_PSF +lensPSFSmearX12 = cmf.X12_SM_PSF +lensPSFSmearX22 = cmf.X22_SM_PSF +lensPSFSmearE1 = cmf.E1_SM_PSF +lensPSFSmearE2 = cmf.E2_SM_PSF +lensPSFShearX11 = cmf.X11_SH_PSF +lensPSFShearX12 = cmf.X12_SH_PSF +lensPSFShearX22 = cmf.X22_SH_PSF +lensPSFShearE1 = cmf.E1_SH_PSF +lensPSFShearE2 = cmf.E2_SH_PSF +---------------- = Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 37763) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 37840) @@ -44,5 +44,4 @@ kronFluxErr adu/seconds REAL 4 -999 Kron flux error kronRad arcsec REAL 4 -999 Kron radius -kronRadErr arcsed REAL 4 -999 Kron radius error ------------------------------------------------------ sky adu/sec/pixel REAL 4 -999 PSF sky level at source Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 37763) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 37840) @@ -26,3 +26,3 @@ gdecDeVOffErr arcsec REAL 4 -999 estimated error in dec offset gDeVCf dimensionless REAL 4 -999 DeVaucouleurs fit coverage factor - +gDevChisq Index: trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer =================================================================== --- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 37763) +++ trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 37840) @@ -28,4 +28,4 @@ gSerDecErr dimensionless REAL 4 -999 estimated error in decSerOff gserCf dimensionless REAL 4 -999 Sersic fit coverage factor +gserChisq -