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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 37137) @@ -2,4 +2,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 @@ -12,5 +13,4 @@ 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 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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp (revision 37137) @@ -2,4 +2,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 @@ -12,5 +13,4 @@ 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 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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlx (revision 37137) @@ -2,4 +2,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 @@ -12,5 +13,4 @@ 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 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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1 (revision 37137) @@ -2,4 +2,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 @@ -12,5 +13,4 @@ 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 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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2 (revision 37137) @@ -2,4 +2,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 @@ -12,5 +13,4 @@ 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 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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 37137) @@ -2,4 +2,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 @@ -12,5 +13,4 @@ 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 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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitThin (revision 37137) @@ -2,4 +2,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 @@ -12,4 +13,8 @@ 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 +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) @@ -20,6 +25,2 @@ 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: /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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra (revision 37137) @@ -2,4 +2,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 @@ -15,5 +16,4 @@ -- 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 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 37136) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin (revision 37137) @@ -2,4 +2,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 [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 @@ -8,5 +9,5 @@ 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. +-- 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. @@ -15,5 +16,4 @@ -- Replicate the section below for each filter, changing the prefex ("g" in this example) ------------------------------------------------------------------------------------------ -gippObjID dimensionless BIGINT 8 NA object ID generated by IPP [XXX this is a per-object, not per-filter value] gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier @@ -33,6 +33,6 @@ 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 +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