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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx (revision 37189) @@ -12,41 +12,41 @@ gstackMetaID dimensionless BIGINT 8 NA stack identifier --------------------------------------------------------unconvolved -gflxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gflxR3Err adu/seconds REAL 4 -999 estimated error is flxR3 -gflxR3Std adu/seconds REAL 4 -999 estimated standard deviation in flxR3 +gflxR3 Jy REAL 4 -999 Flux inside r = 3 +gflxR3Err Jy REAL 4 -999 estimated error is flxR3 +gflxR3Std Jy REAL 4 -999 estimated standard deviation in flxR3 gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gflxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gflxR4Err adu/seconds REAL 4 -999 estimated error is flxR4 -gflxR4Std adu/seconds REAL 4 -999 estimated standard deviation in flxR4 +gflxR4 Jy REAL 4 -999 Flux inside r = 4 +gflxR4Err Jy REAL 4 -999 estimated error is flxR4 +gflxR4Std Jy REAL 4 -999 estimated standard deviation in flxR4 gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gflxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gflxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 -gflxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 +gflxR5 Jy REAL 4 -999 Flux inside r = 5 +gflxR5Err Jy REAL 4 -999 estimated error is flxR5 +gflxR5Std Jy REAL 4 -999 estimated standard deviation in flxR5 gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 ---------------------------------------------------- convolved across all bands to 6 or 8 pixels -gc1flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc1flxR3Err adu/seconds REAL 4 -999 estimated error is c1flxR3 -gc1flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR3 +gc1flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc1flxR3Err Jy REAL 4 -999 estimated error is c1flxR3 +gc1flxR3Std Jy REAL 4 -999 estimated standard deviation in c1flxR3 gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc1flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc1flxR4Err adu/seconds REAL 4 -999 estimated error is c1flxR4 -gc1flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR4 +gc1flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc1flxR4Err Jy REAL 4 -999 estimated error is c1flxR4 +gc1flxR4Std Jy REAL 4 -999 estimated standard deviation in c1flxR4 gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc1flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc1flxR5Err adu/seconds REAL 4 -999 estimated error is c1flxR5 -gc1flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR5 +gc1flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc1flxR5Err Jy REAL 4 -999 estimated error is c1flxR5 +gc1flxR5Std Jy REAL 4 -999 estimated standard deviation in c1flxR5 gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 ---------------------------------------------------- convolved across all bands to 6 or 8 pixels -gc2flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc2flxR3Err adu/seconds REAL 4 -999 estimated error in c2flxR3 -gc2flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR3 +gc2flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc2flxR3Err Jy REAL 4 -999 estimated error in c2flxR3 +gc2flxR3Std Jy REAL 4 -999 estimated standard deviation in c2flxR3 gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc2flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc2flxR4Err adu/seconds REAL 4 -999 estimated error in c2flxR4 -gc2flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR4 +gc2flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc2flxR4Err Jy REAL 4 -999 estimated error in c2flxR4 +gc2flxR4Std Jy REAL 4 -999 estimated standard deviation in c2flxR4 gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc2flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc2flxR5Err adu/seconds REAL 4 -999 estimated error in c2flxR5 -gc2flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c2flxR5 +gc2flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc2flxR5Err Jy REAL 4 -999 estimated error in c2flxR5 +gc2flxR5Std Jy REAL 4 -999 estimated standard deviation in c2flxR5 gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt (revision 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt (revision 37189) @@ -1,56 +1,51 @@ -objID = dvo/addstar -gcObjID = dvo/addstar -ippObjID = dvo/addstar average.objID + (average.catID << 32) -surveyID = ipptopsps -skyCellID = smf header -randomStackObjID = ipptopsps -stackDetectRowID = PSPS ? -primaryDetection = dvo -bestDetection = dvo --- = -dvoRegionID = dvo / catID -dataRelease = ipptopsps ----------------- = -gippDetectID = dvo/addstar -gstackDetectID = dvopsps (see StackObject.txt) -gstackMetaID = dvopsps (see StackObject.txt) ----------------- = -gflxR3 = smf -gflxR3Err = smf -gflxR3Std = smf -gflxR3Fill = smf -gflxR4 = smf -gflxR4Err = smf -gflxR4Std = smf -gflxR4Fill = smf -gflxR5 = smf -gflxR5Err = smf -gflxR5Std = smf -gflxR5Fill = smf ----------------- = -gc1flxR3 = smf -gc1flxR3Err = smf -gc1flxR3Std = smf -gc1flxR3Fill = smf -gc1flxR4 = smf -gc1flxR4Err = smf -gc1flxR4Std = smf -gc1flxR4Fill = smf -gc1flxR5 = smf -gc1flxR5Err = smf -gc1flxR5Std = smf -gc1flxR5Fill = smf ----------------- = -gc2flxR3 = smf -gc2flxR3Err = smf -gc2flxR3Std = smf -gc2flxR3Fill = smf -gc2flxR4 = smf -gc2flxR4Err = smf -gc2flxR4Std = smf -gc2flxR4Fill = smf -gc2flxR5 = smf -gc2flxR5Err = smf -gc2flxR5Std = smf -gc2flxR5Fill = smf +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gflxR3 + cmf : APER_FLUX_3 +gflxR3Err + cmf : APER_FLUX_ERR_3 +gflxR3Std - cmf : APER_FLUX_STDEV_3 +gflxR3Fill + cmf : APER_FILL_3 +gflxR4 + cmf : APER_FLUX_4 +gflxR4Err + cmf : APER_FLUX_ERR_4 +gflxR4Std - cmf : APER_FLUX_STDEV_4 +gflxR4Fill + cmf : APER_FILL_4 +gflxR5 + cmf : APER_FLUX_5 +gflxR5Err + cmf : APER_FLUX_ERR_5 +gflxR5Std - cmf : APER_FLUX_STDEV_5 +gflxR5Fill + cmf : APER_FILL_5 +---------------- +gc1flxR3 + cmf : APER_FLUX_3 +gc1flxR3Err + cmf : APER_FLUX_ERR_3 +gc1flxR3Std - cmf : APER_FLUX_STDEV_3 +gc1flxR3Fill + cmf : APER_FILL_3 +gc1flxR4 + cmf : APER_FLUX_4 +gc1flxR4Err + cmf : APER_FLUX_ERR_4 +gc1flxR4Std - cmf : APER_FLUX_STDEV_4 +gc1flxR4Fill + cmf : APER_FILL_4 +gc1flxR5 + cmf : APER_FLUX_5 +gc1flxR5Err + cmf : APER_FLUX_ERR_5 +gc1flxR5Std - cmf : APER_FLUX_STDEV_5 +gc1flxR5Fill + cmf : APER_FILL_5 +---------------- +gc2flxR3 + cmf : APER_FLUX_3 +gc2flxR3Err + cmf : APER_FLUX_ERR_3 +gc2flxR3Std - cmf : APER_FLUX_STDEV_3 +gc2flxR3Fill + cmf : APER_FILL_3 +gc2flxR4 + cmf : APER_FLUX_4 +gc2flxR4Err + cmf : APER_FLUX_ERR_4 +gc2flxR4Std - cmf : APER_FLUX_STDEV_4 +gc2flxR4Fill + cmf : APER_FILL_4 +gc2flxR5 + cmf : APER_FLUX_5 +gc2flxR5Err + cmf : APER_FLUX_ERR_5 +gc2flxR5Std - cmf : APER_FLUX_STDEV_5 +gc2flxR5Fill + cmf : APER_FILL_5 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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull (revision 37189) @@ -12,42 +12,42 @@ 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 +gflxR1 Jy REAL 4 -999 Flux inside r = 1 +gflxR1Err Jy REAL 4 -999 estimated error is flxR1 +gflxR1Std Jy REAL 4 -999 estimated standard deviation in flxR1 gflxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gflxR2 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 +gflxR2 Jy REAL 4 -999 Flux inside r = 2 +gflxR2Err Jy REAL 4 -999 estimated error is flxR2 +gflxR2Std Jy REAL 4 -999 estimated standard deviation in flxR2 gflxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gflxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gflxR3Err adu/seconds REAL 4 -999 estimated error is flxR3 -gflxR3Std adu/seconds REAL 4 -999 estimated standard deviation in flxR3 +gflxR3 Jy REAL 4 -999 Flux inside r = 3 +gflxR3Err Jy REAL 4 -999 estimated error is flxR3 +gflxR3Std Jy REAL 4 -999 estimated standard deviation in flxR3 gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gflxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gflxR4Err adu/seconds REAL 4 -999 estimated error is flxR4 -gflxR4Std adu/seconds REAL 4 -999 estimated standard deviation in flxR4 +gflxR4 Jy REAL 4 -999 Flux inside r = 4 +gflxR4Err Jy REAL 4 -999 estimated error is flxR4 +gflxR4Std Jy REAL 4 -999 estimated standard deviation in flxR4 gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gflxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gflxR5Err adu/seconds REAL 4 -999 estimated error is flxR5 -gflxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR5 +gflxR5 Jy REAL 4 -999 Flux inside r = 5 +gflxR5Err Jy REAL 4 -999 estimated error is flxR5 +gflxR5Std Jy REAL 4 -999 estimated standard deviation in flxR5 gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -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 +gflxR6 Jy REAL 4 -999 Flux inside r = 6 +gflxR6Err Jy REAL 4 -999 estimated error is flxR6 +gflxR6Std Jy REAL 4 -999 estimated standard deviation in flxR6 gflxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gflxR7 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 +gflxR7 Jy REAL 4 -999 Flux inside r = 7 +gflxR7Err Jy REAL 4 -999 estimated error is flxR7 +gflxR7Std Jy REAL 4 -999 estimated standard deviation in flxR7 gflxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gflxR8 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 +gflxR8 Jy REAL 4 -999 Flux inside r = 8 +gflxR8Err Jy REAL 4 -999 estimated error is flxR8 +gflxR8Std Jy REAL 4 -999 estimated standard deviation in flxR8 gflxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gflxR9 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 +gflxR9 Jy REAL 4 -999 Flux inside r = 9 +gflxR9Err Jy REAL 4 -999 estimated error is flxR9 +gflxR9Std Jy REAL 4 -999 estimated standard deviation in flxR9 gflxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gflxR10 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 +gflxR10 Jy REAL 4 -999 Flux inside r = 10 +gflxR10Err Jy REAL 4 -999 estimated error is flxR10 +gflxR10Std Jy REAL 4 -999 estimated standard deviation in flxR10 gflxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt (revision 37189) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt (revision 37189) @@ -0,0 +1,56 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gflxR1 + cmf : APER_FLUX_1 +gflxR1Err + cmf : APER_FLUX_ERR_1 +gflxR1Std - cmf : APER_FLUX_STDEV_1 +gflxR1Fill + cmf : APER_FILL_1 +gflxR2 + cmf : APER_FLUX_2 +gflxR2Err + cmf : APER_FLUX_ERR_2 +gflxR2Std - cmf : APER_FLUX_STDEV_2 +gflxR2Fill + cmf : APER_FILL_2 +gflxR3 + cmf : APER_FLUX_3 +gflxR3Err + cmf : APER_FLUX_ERR_3 +gflxR3Std - cmf : APER_FLUX_STDEV_3 +gflxR3Fill + cmf : APER_FILL_3 +gflxR4 + cmf : APER_FLUX_4 +gflxR4Err + cmf : APER_FLUX_ERR_4 +gflxR4Std - cmf : APER_FLUX_STDEV_4 +gflxR4Fill + cmf : APER_FILL_4 +gflxR5 + cmf : APER_FLUX_5 +gflxR5Err + cmf : APER_FLUX_ERR_5 +gflxR5Std - cmf : APER_FLUX_STDEV_5 +gflxR5Fill + cmf : APER_FILL_5 +gflxR6 + cmf : APER_FLUX_6 +gflxR6Err + cmf : APER_FLUX_ERR_6 +gflxR6Std - cmf : APER_FLUX_STDEV_6 +gflxR6Fill + cmf : APER_FILL_6 +gflxR7 + cmf : APER_FLUX_7 +gflxR7Err + cmf : APER_FLUX_ERR_7 +gflxR7Std - cmf : APER_FLUX_STDEV_7 +gflxR7Fill + cmf : APER_FILL_7 +gflxR8 + cmf : APER_FLUX_8 +gflxR8Err + cmf : APER_FLUX_ERR_8 +gflxR8Std - cmf : APER_FLUX_STDEV_8 +gflxR8Fill + cmf : APER_FILL_8 +gflxR9 + cmf : APER_FLUX_9 +gflxR9Err + cmf : APER_FLUX_ERR_9 +gflxR9Std - cmf : APER_FLUX_STDEV_9 +gflxR9Fill + cmf : APER_FILL_9 +gflxR10 - cmf : APER_FLUX_10 ** does not exist in cmf +gflxR10Err - cmf : APER_FLUX_ERR_10 ** does not exist in cmf +gflxR10Std - cmf : APER_FLUX_STDEV_10 ** does not exist in cmf +gflxR10Fill - cmf : APER_FILL_10 ** does not exist in cmf + +**** NOTE : these are in instrumental flux units not Jy so far... + 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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 (revision 37189) @@ -12,43 +12,43 @@ 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 +gc1flxR1 Jy REAL 4 -999 Flux inside r = 1 +gc1flxR1Err Jy REAL 4 -999 estimated error is c1flxR1 +gc1flxR1Std Jy REAL 4 -999 estimated standard deviation in c1flxR1 gc1flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc1flxR2 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 +gc1flxR2 Jy REAL 4 -999 Flux inside r = 2 +gc1flxR2Err Jy REAL 4 -999 estimated error is c1flxR2 +gc1flxR2Std Jy REAL 4 -999 estimated standard deviation in c1flxR2 gc1flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc1flxR3 adu/seconds REAL 4 -999 Flux inside r = 3 -gc1flxR3Err adu/seconds REAL 4 -999 estimated error is c1flxR3 -gc1flxR3Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR3 +gc1flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc1flxR3Err Jy REAL 4 -999 estimated error is c1flxR3 +gc1flxR3Std Jy REAL 4 -999 estimated standard deviation in c1flxR3 gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc1flxR4 adu/seconds REAL 4 -999 Flux inside r = 4 -gc1flxR4Err adu/seconds REAL 4 -999 estimated error is c1flxR4 -gc1flxR4Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR4 +gc1flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc1flxR4Err Jy REAL 4 -999 estimated error is c1flxR4 +gc1flxR4Std Jy REAL 4 -999 estimated standard deviation in c1flxR4 gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc1flxR5 adu/seconds REAL 4 -999 Flux inside r = 5 -gc1flxR5Err adu/seconds REAL 4 -999 estimated error is c1flxR5 -gc1flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in c1flxR5 +gc1flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc1flxR5Err Jy REAL 4 -999 estimated error is c1flxR5 +gc1flxR5Std Jy REAL 4 -999 estimated standard deviation in c1flxR5 gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -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 +gc1flxR6 Jy REAL 4 -999 Flux inside r = 6 +gc1flxR6Err Jy REAL 4 -999 estimated error is c1flxR6 +gc1flxR6Std Jy REAL 4 -999 estimated standard deviation in c1flxR6 gc1flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gc1flxR7 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 +gc1flxR7 Jy REAL 4 -999 Flux inside r = 7 +gc1flxR7Err Jy REAL 4 -999 estimated error is c1flxR7 +gc1flxR7Std Jy REAL 4 -999 estimated standard deviation in c1flxR7 gc1flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gc1flxR8 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 +gc1flxR8 Jy REAL 4 -999 Flux inside r = 8 +gc1flxR8Err Jy REAL 4 -999 estimated error is c1flxR8 +gc1flxR8Std Jy REAL 4 -999 estimated standard deviation in c1flxR8 gc1flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gc1flxR9 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 +gc1flxR9 Jy REAL 4 -999 Flux inside r = 9 +gc1flxR9Err Jy REAL 4 -999 estimated error is c1flxR9 +gc1flxR9Std Jy REAL 4 -999 estimated standard deviation in c1flxR9 gc1flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gc1flxR10 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 +gc1flxR10 Jy REAL 4 -999 Flux inside r = 10 +gc1flxR10Err Jy REAL 4 -999 estimated error is c1flxR10 +gc1flxR10Std Jy REAL 4 -999 estimated standard deviation in c1flxR10 gc1flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt (revision 37189) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt (revision 37189) @@ -0,0 +1,56 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gc1flxR1 + cmf : APER_FLUX_1 +gc1flxR1Err + cmf : APER_FLUX_ERR_1 +gc1flxR1Std - cmf : APER_FLUX_STDEV_1 +gc1flxR1Fill + cmf : APER_FILL_1 +gc1flxR2 + cmf : APER_FLUX_2 +gc1flxR2Err + cmf : APER_FLUX_ERR_2 +gc1flxR2Std - cmf : APER_FLUX_STDEV_2 +gc1flxR2Fill + cmf : APER_FILL_2 +gc1flxR3 + cmf : APER_FLUX_3 +gc1flxR3Err + cmf : APER_FLUX_ERR_3 +gc1flxR3Std - cmf : APER_FLUX_STDEV_3 +gc1flxR3Fill + cmf : APER_FILL_3 +gc1flxR4 + cmf : APER_FLUX_4 +gc1flxR4Err + cmf : APER_FLUX_ERR_4 +gc1flxR4Std - cmf : APER_FLUX_STDEV_4 +gc1flxR4Fill + cmf : APER_FILL_4 +gc1flxR5 + cmf : APER_FLUX_5 +gc1flxR5Err + cmf : APER_FLUX_ERR_5 +gc1flxR5Std - cmf : APER_FLUX_STDEV_5 +gc1flxR5Fill + cmf : APER_FILL_5 +gc1flxR6 + cmf : APER_FLUX_6 +gc1flxR6Err + cmf : APER_FLUX_ERR_6 +gc1flxR6Std - cmf : APER_FLUX_STDEV_6 +gc1flxR6Fill + cmf : APER_FILL_6 +gc1flxR7 + cmf : APER_FLUX_7 +gc1flxR7Err + cmf : APER_FLUX_ERR_7 +gc1flxR7Std - cmf : APER_FLUX_STDEV_7 +gc1flxR7Fill + cmf : APER_FILL_7 +gc1flxR8 + cmf : APER_FLUX_8 +gc1flxR8Err + cmf : APER_FLUX_ERR_8 +gc1flxR8Std - cmf : APER_FLUX_STDEV_8 +gc1flxR8Fill + cmf : APER_FILL_8 +gc1flxR9 + cmf : APER_FLUX_9 +gc1flxR9Err + cmf : APER_FLUX_ERR_9 +gc1flxR9Std - cmf : APER_FLUX_STDEV_9 +gc1flxR9Fill + cmf : APER_FILL_9 +gc1flxR10 - cmf : APER_FLUX_10 ** does not exist in cmf +gc1flxR10Err - cmf : APER_FLUX_ERR_10 ** does not exist in cmf +gc1flxR10Std - cmf : APER_FLUX_STDEV_10 ** does not exist in cmf +gc1flxR10Fill - cmf : APER_FILL_10 ** does not exist in cmf + +**** NOTE : these are in instrumental flux units not Jy so far... + 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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 (revision 37189) @@ -12,43 +12,43 @@ 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 +gc2flxR1 Jy REAL 4 -999 Flux inside r = 1 +gc2flxR1Err Jy REAL 4 -999 estimated error is c2flxR1 +gc2flxR1Std Jy REAL 4 -999 estimated standard deviation in c2flxR1 gc2flxR1Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc2flxR2 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 +gc2flxR2 Jy REAL 4 -999 Flux inside r = 2 +gc2flxR2Err Jy REAL 4 -999 estimated error is c2flxR2 +gc2flxR2Std Jy REAL 4 -999 estimated standard deviation in c2flxR2 gc2flxR2Fill dimensionless REAL 4 -999 estimated filling factor at R1 -gc2flxR3 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 +gc2flxR3 Jy REAL 4 -999 Flux inside r = 3 +gc2flxR3Err Jy REAL 4 -999 estimated error is c2flxR3 +gc2flxR3Std Jy REAL 4 -999 estimated standard deviation in c2flxR3 gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 -gc2flxR4 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 +gc2flxR4 Jy REAL 4 -999 Flux inside r = 4 +gc2flxR4Err Jy REAL 4 -999 estimated error is c2flxR4 +gc2flxR4Std Jy REAL 4 -999 estimated standard deviation in c2flxR4 gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 -gc2flxR5 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 +gc2flxR5 Jy REAL 4 -999 Flux inside r = 5 +gc2flxR5Err Jy REAL 4 -999 estimated error is c2flxR5 +gc2flxR5Std Jy REAL 4 -999 estimated standard deviation in c2flxR5 gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 -gc2flxR6 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 +gc2flxR6 Jy REAL 4 -999 Flux inside r = 6 +gc2flxR6Err Jy REAL 4 -999 estimated error is c2flxR6 +gc2flxR6Std Jy REAL 4 -999 estimated standard deviation in c2flxR6 gc2flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R6 -gc2flxR7 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 +gc2flxR7 Jy REAL 4 -999 Flux inside r = 7 +gc2flxR7Err Jy REAL 4 -999 estimated error is c2flxR7 +gc2flxR7Std Jy REAL 4 -999 estimated standard deviation in c2flxR7 gc2flxR7Fill dimensionless REAL 4 -999 estimated filling factor at R7 -gc2flxR8 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 +gc2flxR8 Jy REAL 4 -999 Flux inside r = 8 +gc2flxR8Err Jy REAL 4 -999 estimated error is c2flxR8 +gc2flxR8Std Jy REAL 4 -999 estimated standard deviation in c2flxR8 gc2flxR8Fill dimensionless REAL 4 -999 estimated filling factor at R8 -gc2flxR9 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 +gc2flxR9 Jy REAL 4 -999 Flux inside r = 9 +gc2flxR9Err Jy REAL 4 -999 estimated error is c2flxR9 +gc2flxR9Std Jy REAL 4 -999 estimated standard deviation in c2flxR9 gc2flxR9Fill dimensionless REAL 4 -999 estimated filling factor at R9 -gc2flxR10 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 +gc2flxR10 Jy REAL 4 -999 Flux inside r = 10 +gc2flxR10Err Jy REAL 4 -999 estimated error is c2flxR10 +gc2flxR10Std Jy REAL 4 -999 estimated standard deviation in c2flxR10 gc2flxR10Fill dimensionless REAL 4 -999 estimated filling factor at R10 Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt (revision 37189) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt (revision 37189) @@ -0,0 +1,56 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gc2flxR1 + cmf : APER_FLUX_1 +gc2flxR1Err + cmf : APER_FLUX_ERR_1 +gc2flxR1Std - cmf : APER_FLUX_STDEV_1 +gc2flxR1Fill + cmf : APER_FILL_1 +gc2flxR2 + cmf : APER_FLUX_2 +gc2flxR2Err + cmf : APER_FLUX_ERR_2 +gc2flxR2Std - cmf : APER_FLUX_STDEV_2 +gc2flxR2Fill + cmf : APER_FILL_2 +gc2flxR3 + cmf : APER_FLUX_3 +gc2flxR3Err + cmf : APER_FLUX_ERR_3 +gc2flxR3Std - cmf : APER_FLUX_STDEV_3 +gc2flxR3Fill + cmf : APER_FILL_3 +gc2flxR4 + cmf : APER_FLUX_4 +gc2flxR4Err + cmf : APER_FLUX_ERR_4 +gc2flxR4Std - cmf : APER_FLUX_STDEV_4 +gc2flxR4Fill + cmf : APER_FILL_4 +gc2flxR5 + cmf : APER_FLUX_5 +gc2flxR5Err + cmf : APER_FLUX_ERR_5 +gc2flxR5Std - cmf : APER_FLUX_STDEV_5 +gc2flxR5Fill + cmf : APER_FILL_5 +gc2flxR6 + cmf : APER_FLUX_6 +gc2flxR6Err + cmf : APER_FLUX_ERR_6 +gc2flxR6Std - cmf : APER_FLUX_STDEV_6 +gc2flxR6Fill + cmf : APER_FILL_6 +gc2flxR7 + cmf : APER_FLUX_7 +gc2flxR7Err + cmf : APER_FLUX_ERR_7 +gc2flxR7Std - cmf : APER_FLUX_STDEV_7 +gc2flxR7Fill + cmf : APER_FILL_7 +gc2flxR8 + cmf : APER_FLUX_8 +gc2flxR8Err + cmf : APER_FLUX_ERR_8 +gc2flxR8Std - cmf : APER_FLUX_STDEV_8 +gc2flxR8Fill + cmf : APER_FILL_8 +gc2flxR9 + cmf : APER_FLUX_9 +gc2flxR9Err + cmf : APER_FLUX_ERR_9 +gc2flxR9Std - cmf : APER_FLUX_STDEV_9 +gc2flxR9Fill + cmf : APER_FILL_9 +gc2flxR10 - cmf : APER_FLUX_10 ** does not exist in cmf +gc2flxR10Err - cmf : APER_FLUX_ERR_10 ** does not exist in cmf +gc2flxR10Std - cmf : APER_FLUX_STDEV_10 ** does not exist in cmf +gc2flxR10Fill - cmf : APER_FILL_10 ** does not exist in cmf + +**** NOTE : these are in instrumental flux units not Jy so far... + 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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (revision 37189) @@ -12,16 +12,16 @@ gstackMetaID dimensionless BIGINT 8 NA stack identifier ---------------------------------------------------------------------------------------- -gdeVRadius arcsec REAL 4 -999 deVaucouleurs radius -gdeVRadiusErr arcsec REAL 4 -999 estimated error in deVaucouleurs radius -gdeVFlux adu/seconds REAL 4 -999 deVaucouleurs flux -gdeVFluxErr adu/seconds REAL 4 -999 estimated error in deVaucouleurs flux -gdeVAb dimensionless REAL 4 -999 deVaucoulerus axis ratio -gdeVAbErr dimensionless REAL 4 -999 estimated error in deVaucoulerus axis ratio -gdeVPhi degrees REAL 4 -999 estmated phi of deVaucouleurs axis. Degrees East of North. -gdeVPhiErr degrees REAL 4 -999 estmated error of phi of deVaucouleurs axis -graDeVOff arcsec REAL 4 -999 Offset in RA of deVaucouleurs fit from PSF RA -gdecDeVOff arcsec REAL 4 -999 Offset in DEC of deVaucouleurs fit from PSF DEC +gDeVRadius arcsec REAL 4 -999 DeVaucouleurs radius +gDeVRadiusErr arcsec REAL 4 -999 estimated error in DeVaucouleurs radius +gDeVMag AB_mag REAL 4 -999 DeVaucouleurs flux +gDeVMagErr AB_mag REAL 4 -999 estimated error in DeVaucouleurs flux +gDeVAb dimensionless REAL 4 -999 DeVaucoulerus axis ratio +gDeVAbErr dimensionless REAL 4 -999 estimated error in DeVaucoulerus axis ratio +gDeVPhi degrees REAL 4 -999 estmated phi of DeVaucouleurs axis. Degrees East of North. +gDeVPhiErr degrees REAL 4 -999 estmated error of phi of DeVaucouleurs axis +graDeVOff arcsec REAL 4 -999 Offset in RA of DeVaucouleurs fit from PSF RA +gdecDeVOff arcsec REAL 4 -999 Offset in DEC of DeVaucouleurs fit from PSF DEC graDeVOffErr arcsec REAL 4 -999 estimated error in ra offset gdecDeVOffErr arcsec REAL 4 -999 estimated error in dec offset -gdeVCf dimensionless REAL 4 -999 deVaucouleurs fit coverage factor -gdeVLikelihood dimensionless REAL 4 -999 deVaucouleurs fit likelihood factor +gDeVCf dimensionless REAL 4 -999 DeVaucouleurs fit coverage factor +gDeVLikelihood dimensionless REAL 4 -999 DeVaucouleurs fit likelihood factor Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt (revision 37189) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt (revision 37189) @@ -0,0 +1,27 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gDeVRadius + cmf : EXT_WIDTH_MAJ +gDeVRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gDeVMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gDeVMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gDeVAb - cmf : EXT_WIDTH_MAJ/EXT_WIDTH_MIN ** should this be Minor / Major? +gDeVAbErr - cmf : EXT_WIDTH_MIN_ERR +gDeVPhi - cmf : EXT_THETA ** in radians, not degrees +gDeVPhiErr - cmf : EXT_THETA_ERR +gDeVRa - x +gDeVDec - x +gDeVRaErr - x +gDeVDecErr - x +gDeVCf - ** I do not have a source for this in the CMF +gDeVLikelihood - ** replace with chisq? 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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp (revision 37189) @@ -14,6 +14,6 @@ gExpRadius arcsec REAL 4 -999 Exponential fit radius gExpRadiusErr arcsec REAL 4 -999 estimated error in Exponential fit radius -gExpFlux adu/seconds REAL 4 -999 Exponential fit flux -gExpFluxErr adu/seconds REAL 4 -999 estimated error in expFlux +gExpMag AB_mag REAL 4 -999 Exponential fit flux +gExpMagErr AB_mag REAL 4 -999 estimated error in expFlux gExpAb dimensionless REAL 4 -999 Exponential fit axis ratio gExpAbErr dimensionless REAL 4 -999 estimated error in Exponential fit axis ratio Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt (revision 37189) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt (revision 37189) @@ -0,0 +1,27 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gExpRadius + cmf : EXT_WIDTH_MAJ +gExpRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gExpMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gExpMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gExpAb - cmf : EXT_WIDTH_MAJ/EXT_WIDTH_MIN ** should this be Minor / Major? +gExpAbErr - cmf : EXT_WIDTH_MIN_ERR +gExpPhi - cmf : EXT_THETA ** in radians, not degrees +gExpPhiErr - cmf : EXT_THETA_ERR +gExpRa - x +gExpDec - x +gExpRaErr - x +gExpDecErr - x +gExpCf - ** I do not have a source for this in the CMF +gExpLikelihood - ** replace with chisq? 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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer (revision 37189) @@ -12,14 +12,14 @@ gstackMetaID dimensionless BIGINT 8 NA stack identifier ---------------------------------------------------------------------------------------- -gserRadius arcsec REAL 4 -999 Sersic radius -gserRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius -gserFlux adu/seconds REAL 4 -999 Sersic Flux -gserFluxErr adu/seconds REAL 4 -999 estimated error in serFlux -gserAb dimensionless REAL 4 -999 Sersic axis ratio -gserAbErr dimensionlessn REAL 4 -999 estimated error in Sersic axis ratio -gserNu dimensionlessn REAL 4 -999 Sersic index -gserNuErr diemensionless REAL 4 -999 estimated error in Sersic index -gserPhi degrees REAL 4 -999 estmated phi of Sersic axis -gserPhiErr degrees REAL 4 -999 estmated error of phi of Sersic axis +gSerRadius arcsec REAL 4 -999 Sersic radius +gSerRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius +gSerMag AB_mag REAL 4 -999 Sersic Flux +gSerMagErr AB_mag REAL 4 -999 estimated error in serFlux +gSerAb dimensionless REAL 4 -999 Sersic axis ratio +gSerAbErr dimensionlessn REAL 4 -999 estimated error in Sersic axis ratio +gSerNu dimensionlessn REAL 4 -999 Sersic index +gSerNuErr diemensionless REAL 4 -999 estimated error in Sersic index +gSerPhi degrees REAL 4 -999 estmated phi of Sersic axis +gSerPhiErr degrees REAL 4 -999 estmated error of phi of Sersic axis graSerOff dimensionless REAL 4 -999 Offset in RA of Sersic fit from PSF RA gdecSerOff dimensionless REAL 4 -999 Offset in DEC of Sersic fit from PSF DEC Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt (revision 37189) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt (revision 37189) @@ -0,0 +1,29 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gSerRadius + cmf : EXT_WIDTH_MAJ +gSerRadiusErr - cmf : EXT_WIDTH_MAJ_SIG ** NULL in cmf +gSerMag + cmf : EXT_INST_MAG + 2.5log(exptime) + dvo.zp +gSerMagErr + cmf : EXT_INST_MAG_SIG ** seems kind of small in CMF +gSerAb - cmf : EXT_WIDTH_MAJ/EXT_WIDTH_MIN ** should this be Minor / Major? +gSerAbErr - cmf : EXT_WIDTH_MIN_ERR +gSerNu + cmf : EXT_PAR_07 +gSerPhiErr + cmf : 0.1 ** NOTE this is hard-wired +gSerPhi - cmf : EXT_THETA ** in radians, not degrees +gSerPhiErr - cmf : EXT_THETA_ERR +gSerRa - x +gSerDec - x +gSerRaErr - x +gSerDecErr - x +gSerCf - ** I do not have a source for this in the CMF +gSerLikelihood - ** replace with chisq? 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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw (revision 37189) @@ -12,8 +12,8 @@ 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 +gxPos pixels REAL 4 -999 measured x in sky Cell from PSF fit +gyPos pixels REAL 4 -999 measured y in sky Cell from PSF fit +gxPosErr pixels REAL 4 -999 estimated error in x +gyPosErr pixels REAL 4 -999 estimated error in y gpsfMajorFWHM arcsec REAL 4 -999 PSF width in major axis gpsfMinorFWHM arcsec REAL 4 -999 PSF width in minor axis Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw.txt (revision 37189) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw.txt (revision 37189) @@ -0,0 +1,41 @@ + +objID + from StackObjectThin +ippObjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 + +------------------ +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +------------------ +gxPos + cmf : X_PSF +gyPos + cmf : Y_PSF +gxPosErr + cmf : X_PSF_SIG +gyPosErr + cmf : Y_PSF_SIG +gpsfMajorFWHM + cmf : PSF_FWHM_MAJ +gpsfMinorFWHM + cmf : PSF_FWHM_MIN +gpsfTheta + cmf : PSF_THETA +gpsfCore + cmf : PSF_CORE +gpsfLikelihood - cmf : psfLikelihood(EXT_NSIGMA) ** problem with calculation? plot +gpsfQf + cmf : PSF_QF +gpsfQfPerfect + cmf : PSF_QF_PERFECT +gpsfChiSq + cmf : PSF_CHISQ / PSF_NDOF +gmomentXX + cmf : MOMENTS_XX +gmomentXY + cmf : MOMENTS_XY +gmomentYY + cmf : MOMENTS_YY +gmomentR1 + cmf : MOMENTS_R1 +gmomentRH + cmf : MOMENTS_RH +gPSFFlux + cmf : PSF_INST_FLUX / exptime +gPSFFluxErr + cmf : PSF_INST_FLUX_SIG / exptime +gApFlux + cmf : AP_FLUX / exptime +gApFluxErr + cmf : AP_FLUX_SIG / exptime +gApFillFac - cmf : AP_NPIX / (3.14159265359 * POW(b.AP_MAG_RADIUS - 0.5, 2)) ** adjusted formula, re-check +gApRadius + cmf : AP_MAG_RADIUS +gKronFlux + cmf : KRON_FLUX / exptime +gKronFluxErr + cmf : KRON_FLUX_ERR / exptime +gKronRad + cmf : MOMENTS_R1 * 2.5 +gexpTime + cmf : header EXPTIME +gzp + dvo : zp ** clarify in dvopsps 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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (revision 37189) @@ -1,37 +1,39 @@ -objID = dvo = average.extID [calculated in addstar] -ippObjID = dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] -surveyID = ipptopsps : internal, from survey name -tessID = smf : TESS_ID (table mapping) -projectionID = smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) -skycellID = smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) -randomStackObjID = ipptopsps (RANDOM on sql into mysql) -stackDetectRowID = PSPS ? -primaryDetection = dvo *** NOT YET DONE CORRECTLY -bestDetection = dvo *** THIS CANNOT BE SET UNTIL LATER - = -dvoRegionID = dvo = measure.catID -dataRelease = ippToPsps : user input (skychunk.dataRelease) +-- fields marked with + below have been verified by EAM in the ippToPsps output mysql tables + +objID + dvo = average.extID [calculated in addstar] +ippObjID + dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] +surveyID + ipptopsps : internal, from survey name +tessID + smf : TESS_ID (table mapping) +projectionID + smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +skycellID + smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) +randomStackObjID + ipptopsps (RANDOM on sql into mysql) +stackDetectRowID * set by PSPS +primaryDetection - dvo * NOT YET TESTED +bestDetection - dvo * THIS CANNOT BE SET UNTIL LATER (after PV3 initial ingest to psps) + +dvoRegionID + dvo = measure.catID +dataRelease + ippToPsps : user input (skychunk.dataRelease) -- -- -- -- -gippDetectID = dvopsps.ippDetectID = dvo:measure.detID = smf / IPP_IDET -gstackDetectID = dvopsps.detectID = dvo:measure.extID [calculated in addstar: psps stack detect ID] -gstackMetaID = ipptopsps : gpc1 db, matches cmf IMAGEID +gippDetectID + dvopsps.ippDetectID = dvo:measure.detID = smf / IPP_IDET +gstackDetectID + dvopsps.detectID = dvo:measure.extID [calculated in addstar: psps stack detect ID] +gstackMetaID + ipptopsps : gpc1 db, matches cmf IMAGEID -- -gra = dvo = measure.ra -gdec = dvo = average.dec -graErr = dvo = measure.dX * pltscale -gdecErr = dvo = measure.dY * pltscale (circularly sym) -gPSFMag = dvo = measure.Mpsf -gPSFMagErr = dvo = measure.dMpsf -gApMag = dvo = measure.Map -gApMagErr = dvo = measure.dMap -gKronMag = dvo = measure.Mkron -gKronMagErr = dvo = measure.dMkron -gsky = smf : SKY / exptime -gskyErr = smf : SKY_SIGMA / exptime -ginfoFlag = smf : FLAGS -ginfoFlag2 = smf + dvo : FLAGS2 | measure.flags << 13 *** CHECK THIS -gnFrames = smf : N_FRAMES +gra + dvo = measure.ra +gdec + dvo = measure.dec +graErr - dvo = X_PSF_SIG * PLTSCALE +gdecErr - dvo = X_PSF_SIG * PLTSCALE +gPSFMag + dvo = measure.Mpsf +gPSFMagErr + dvo = measure.dMpsf +gApMag + dvo = measure.Map +gApMagErr + dvo = measure.dMap +gKronMag + dvo = measure.Mkron +gKronMagErr + dvo = measure.dMkron +gsky + smf : SKY / exptime +gskyErr + smf : SKY_SIGMA / exptime +ginfoFlag + smf : FLAGS +ginfoFlag2 - smf + dvo : FLAGS2 | measure.flags << 13 *** we only include measure.dbflags, not secfilt.flags +gnFrames + smf : N_FRAMES Index: /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 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian (revision 37189) @@ -12,12 +12,11 @@ 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 +gpetRadius arcsec REAL 4 -999 Petrosian radius +gpetRadiusErr arcsec REAL 4 -999 estimated error inPetrosian radius +gpetMag AB_mag REAL 4 -999 Petrosian Flux +gpetMagErr AB_mag REAL 4 -999 estimated error in petFlux +gpetR50 arcsec REAL 4 -999 Petrosian radius at 50% light +gpetR50Err arcsec REAL 4 -999 estimated error inPetrosian radius at 50% light +gpetR90 arcsec REAL 4 -999 Petrosian radius at 90% light +gpetR90Err arcsec REAL 4 -999 estimated error in Petrosian radius at 90% light gpetCf dimensionless REAL 4 -999 Petrosian fit coverage factor - Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt (revision 37189) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt (revision 37189) @@ -0,0 +1,22 @@ + +objID + from StackObjectThin +ippbjID + from StackObjectThin +randomStackObjID + from StackObjectThin +stackDetectRowID - PSPS +primaryDetection - from StackObjectThin NOT YET TESTED +bestDetection - from StackObjectThin CANNOT BE SET until after PV3 +-- +---------------- +gippDetectID + from StackObjectThin +gstackDetectID + from StackObjectThin +gstackMetaID + from StackObjectThin +---------------- +gpetRadius + cmf : PETRO_RADIUS +gpetRadiusErr + cmf : PETRO_RADIUS_ERR +gpetMag + cmf : PETRO_MAG - header:FPA.ZP + dvo.zp +gpetMagErr + cmf : PETRO_MAG_ERR +gpetR50 + cmf : PETRO_RADIUS_50 +gpetR50Err + cmf : PETRO_RADIUS_50_ERR +gpetR90 + cmf : PETRO_RADIUS_90 +gpetR90Err + cmf : PETRO_RADIUS_90_ERR +gpetCf - cmf : PETRO_FILL ** consistently > 1.0?? [problem in cmf] Index: /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt =================================================================== --- /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt (revision 37188) +++ /branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt (revision 37189) @@ -10,13 +10,13 @@ stackbatch.py: - StackObjectThin - populated for all stack detections * - StackObjectExtra - populated for all stack detections * + StackObjectThin - populated for all stack detections * checked + StackObjectRaw - populated for all stack detections * checked + StackModelFitThin - populated for Galactic Cap regions + StackModelFitDeV - populated for Galactic Cap regions * checked + StackModelFitExp - populated for Galactic Cap regions * checked + StackModelFitSer - populated for Galactic Cap regions * checked StackApFlx - populated for all stack detections - StackModelFitThin - populated for Galactic Cap regions - StackModelFitDeV - populated for Galactic Cap regions * - StackModelFitExp - populated for Galactic Cap regions * - StackModelFitSer - populated for Galactic Cap regions * - StackModelFitFlx - populated for Galactic Cap regions * - StackModelFitFlxC1 - populated for Galactic Cap regions * - StackModelFitFlxC2 - populated for Galactic Cap regions * - StackModelFitPet - populated for Galactic Cap regions * + StackApFlxFull - populated for Galactic Cap regions * checked + StackApFlxFullC1 - populated for Galactic Cap regions * checked + StackApFlxFullC2 - populated for Galactic Cap regions * checked + StackPetrosian - populated for Galactic Cap regions * checked