Changeset 36947
- Timestamp:
- Jun 30, 2014, 9:41:43 PM (12 years ago)
- Location:
- branches/eam_branches/ipp-20140610/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables
- Files:
-
- 4 edited
-
ForcedMeanObject (modified) (2 diffs)
-
MeanObject (modified) (1 diff)
-
ObjectThin (modified) (2 diffs)
-
StackObject (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/eam_branches/ipp-20140610/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject
r36884 r36947 6 6 batchID dimensionless BIGINT 8 NA batch id 7 7 ----------------------------------------------------- replicate to bottom for each filter 8 gStackID 8 gStackID dimensionless INT 4 stack image id (how to carry through IPP + DVO) 9 9 gnTotal dimensionless SMALLINT 2 -999 number of detections in g filter 10 10 gnIncPSFMag dimensionless SMALLINT 2 -999 number of detections included in robust psf mean in g filter … … 14 14 gnIncR6 dimensionless SMALLINT 2 -999 number of detections included in robust mean of ApFlx 6 in g filter 15 15 ------------------------------------------------------- one of the above also corresponds to the moments 16 gPSFMag AB 17 gPSFMagErr AB 16 gPSFMag AB_magnitude REAL 4 -999 robust mean g psf AB magnitude (sigma clipping or MAP or go to 5 or 7 number sumary? 1/12 is ~9th percentile 17 gPSFMagErr AB_magnitude REAL 4 -999 estimated error of g psf AB magnitude mean (individual errors added in quadrature) 18 18 gPSFMagStd dimensionless REAL 4 -999 standard deviation of measurements included in the robust mean 19 gKronMag AB 20 gKronMagErr AB 19 gKronMag AB_magnitude REAL 4 -999 mean g kron AB magnitude 20 gKronMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude mean 21 21 gKronMagStd dimensionless REAL 4 -999 standard deviation of measurements included in the robust mean 22 gApMag AB 23 gApMagErr AB 22 gApMag AB_magnitude REAL 4 -999 mean g kron AB magnitude 23 gApMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude mean 24 24 gApMagStd dimensionless REAL 4 -999 standard deviation of measurements included in the robust mean 25 25 ------------------------------------------------------ -
branches/eam_branches/ipp-20140610/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject
r36884 r36947 3 3 -- but descends down a "waterfall logic" in ipp so that there exists a mean mag for less than ideal objects. The logic is given in Magnier etal 2013. 4 4 5 objID dimensionless BIGINT 8 NA ODM object identifier index6 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier7 gQfPerfect dimensionless REAL 4 -999 maximum psf qfPerfect from best available g band detections8 gMeanPSFMag AB magnitude REAL4 -999 mean g psf AB magnitude from best available measurements (best available as current defined by ipp "waterfall logic"9 gMeanPSFMagErr AB magnitude REAL4 -999 estimated error of best availalbe g-band psf AB magnitudes (individual errors added in quadrature)10 gnIncPSFMag dimensionless SMALLINT 2 -999 number of best available detections included in mean psfMag11 gMeanPSFMagStd dimensioless REAL 4 -999 standard deviation of best available measurements - compared with MeanErr this is one measure of true variability12 gMinPSFMag AB magnitude REAL4 -999 minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability.13 gMaxPSFMag AB magnitude REAL4 -999 maximum best available PSFMag14 15 gMeanKronMag AB magnitude REAL4 -999 mean g kron AB magnitude from best available measurements16 gMeanKronMagErr AB magnitude REAL4 -999 estimated error of mean g kron AB magnitude17 gnIncKronMag dimensionless SMALLINT 2 -999 number of best available detections included mean Kron mag18 gMeanKronMagStd dimensioless REAL 4 -999 standard deviation of best available measurements19 20 gMeanApMag AB magnitude REAL4 -999 mean g kron AB magnitude from best available measurements21 gMeanApMagErr AB magnitude REAL4 -999 estimated error of g kron AB magnitude mean22 gnIncApMag dimensionless SMALLINT 2 -999 number of detections included in best available mean of Kron mag in g filter23 gMeanApMagStd dimensioless REAL 4 -999 standard deviation of best available measurements24 gFlags dimensionless BIGINT 8 NA flags for g mean5 objID dimensionless BIGINT 8 NA ODM object identifier index 6 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier 7 gQfPerfect dimensionless REAL 4 -999 maximum psf qfPerfect from best available g band detections 8 gMeanPSFMag AB_magnitude REAL 4 -999 mean g psf AB magnitude from best available measurements (best available as current defined by ipp "waterfall logic" 9 gMeanPSFMagErr AB_magnitude REAL 4 -999 estimated error of best availalbe g-band psf AB magnitudes (individual errors added in quadrature) 10 gnIncPSFMag dimensionless SMALLINT 2 -999 number of best available detections included in mean psfMag 11 gMeanPSFMagStd dimensioless REAL 4 -999 standard deviation of best available measurements - compared with MeanErr this is one measure of true variability 12 gMinPSFMag AB_magnitude REAL 4 -999 minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability. 13 gMaxPSFMag AB_magnitude REAL 4 -999 maximum best available PSFMag 14 15 gMeanKronMag AB_magnitude REAL 4 -999 mean g kron AB magnitude from best available measurements 16 gMeanKronMagErr AB_magnitude REAL 4 -999 estimated error of mean g kron AB magnitude 17 gnIncKronMag dimensionless SMALLINT 2 -999 number of best available detections included mean Kron mag 18 gMeanKronMagStd dimensioless REAL 4 -999 standard deviation of best available measurements 19 20 gMeanApMag AB_magnitude REAL 4 -999 mean g kron AB magnitude from best available measurements 21 gMeanApMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude mean 22 gnIncApMag dimensionless SMALLINT 2 -999 number of detections included in best available mean of Kron mag in g filter 23 gMeanApMagStd dimensioless REAL 4 -999 standard deviation of best available measurements 24 gFlags dimensionless BIGINT 8 NA flags for g mean 25 25 -- duplicate for other filters 26 26 -
branches/eam_branches/ipp-20140610/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin
r36884 r36947 2 2 objName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version 3 3 objID dimensionless BIGINT 8 NA ODM object identifier index 4 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier4 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier 5 5 ippObjID dimensionless BIGINT 8 NA IPP object number 6 6 surveyID dimensionless TINYINT 1 255 Survey ID … … 49 49 ny dimensionless SMALLINT 2 -999 number of detections in individual y filter exposures 50 50 51 [197 byte/obj]51 -- [197 byte/obj] -
branches/eam_branches/ipp-20140610/ippToPsps/pspsschema/SchemaNew16.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObject
r36884 r36947 51 51 gKronFluxErr adu/seconds REAL 4 -999 Kron flux error 52 52 gKronRad arcsec REAL 4 -999 Kron radius 53 gPSFMag AB 54 gPSFMagErr AB 55 gApMag AB 56 gApMagErr AB 57 gKronMag AB 58 gKronMagErr AB 53 gPSFMag AB_magnitude REAL 4 -999 g psf AB magnitude from stack 54 gPSFMagErr AB_magnitude REAL 4 -999 estimated error of g psf AB magnitude from stack 55 gApMag AB_magnitude REAL 4 -999 g Aperture AB magnitude from stack 56 gApMagErr AB_magnitude REAL 4 -999 estimated error of g Ap Mag AB magnitude from stack 57 gKronMag AB_magnitude REAL 4 -999 g kron AB magnitude from stack 58 gKronMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude from stack 59 59 gsky adu/secs/arcsec REAL 4 -999 PSF sky level at source (adu) 60 60 gskyErr adu/secs/arcsec REAL 4 -999 estimated error in sky
Note:
See TracChangeset
for help on using the changeset viewer.
