Index: branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull =================================================================== --- branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull (revision 37185) +++ branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull (revision 37185) @@ -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 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: branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 =================================================================== --- branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 (revision 37185) +++ branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 (revision 37185) @@ -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 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: branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 =================================================================== --- branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 (revision 37185) +++ branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 (revision 37185) @@ -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 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: branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra =================================================================== --- branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra (revision 37185) +++ branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra (revision 37185) @@ -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: 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 37184) +++ (revision ) @@ -1,53 +1,0 @@ - -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 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: 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 37184) +++ (revision ) @@ -1,55 +1,0 @@ - -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 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: 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 37184) +++ (revision ) @@ -1,55 +1,0 @@ - -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 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: 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 37184) +++ (revision ) @@ -1,23 +1,0 @@ - -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 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: 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 37184) +++ (revision ) @@ -1,21 +1,0 @@ - -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: 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 37184) +++ (revision ) @@ -1,40 +1,0 @@ - -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 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 -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 Index: branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw =================================================================== --- branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw (revision 37185) +++ branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw (revision 37185) @@ -0,0 +1,40 @@ + +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 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 +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 Index: branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian =================================================================== --- branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian (revision 37185) +++ branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian (revision 37185) @@ -0,0 +1,23 @@ + +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 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 +