Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (revision 37182) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (revision 37182) @@ -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: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (revision 37182) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (revision 37182) @@ -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: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (revision 37182) @@ -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: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt (revision 37182) @@ -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: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 37182) @@ -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 Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 37182) @@ -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 object ID generated by IPP -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 @@ -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 below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp (revision 37182) @@ -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 object ID generated by IPP -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 @@ -10,7 +7,5 @@ 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) +------------------------------------------------------- replicate below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier @@ -31,3 +26,2 @@ gExpCf dimensionless REAL 4 -999 Exponential fit coverage factor gExpLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor - Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlx =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlx (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlx (revision 37182) @@ -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 object ID generated by IPP -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 @@ -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 below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1 =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1 (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1 (revision 37182) @@ -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 object ID generated by IPP -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 @@ -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 below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2 =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2 (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2 (revision 37182) @@ -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 object ID generated by IPP -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 @@ -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 below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitPet =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitPet (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitPet (revision 37182) @@ -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 +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 @@ -9,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 below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 37182) @@ -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 object ID generated by IPP -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 @@ -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 below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitThin =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitThin (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitThin (revision 37182) @@ -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 object ID generated by IPP -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 @@ -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 below for all filters (grizy) gippDetectID dimensionless BIGINT 8 NA ipp detect identifier Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra (revision 37182) @@ -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 object ID generated by IPP -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 @@ -10,9 +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 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) ------------------------------------------------------------------------------------------ gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin (revision 37182) @@ -1,38 +1,39 @@ -objID dimensionless BIGINT 8 NA ODM object identifier -gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates 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 -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) ------------------------------------------------------------------------------------------ -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?) -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 +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: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (revision 37182) @@ -1,8 +1,9 @@ objID = dvo = average.extID [calculated in addstar] -gcObjID = dvo = average.extIDgc *** NOT SET [DROP?] ippObjID = dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] surveyID = ipptopsps : internal, from survey name -skyCellID = *** we need to decide how we should store this +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 = PSPS ? @@ -10,5 +11,5 @@ bestDetection = dvo *** THIS CANNOT BE SET UNTIL LATER = -dvoRegionID = dvo = average.catID *** NOT YET CARRIED IN FROM dvopsps +dvoRegionID = dvo = measure.catID dataRelease = ippToPsps : user input (skychunk.dataRelease) -- @@ -33,4 +34,4 @@ gskyErr = smf : SKY_SIGMA / exptime ginfoFlag = smf : FLAGS -ginfoFlag2 = smf + dvo : FLAGS2 | secfilt.flags << 13 *** CHECK THIS +ginfoFlag2 = smf + dvo : FLAGS2 | measure.flags << 13 *** CHECK THIS gnFrames = smf : N_FRAMES Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta (revision 37182) @@ -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 -analysisVer dimensionless SMALLINT 2 -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 +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 +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: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt (revision 37181) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt (revision 37182) @@ -4,5 +4,7 @@ filterID | ipptopsps : internal, lookup from filter (griz) stackTypeID | ipptopsps : internal, *** hard-wired name *** -skyCellID | *** we need to decide how we should store this. +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