== Object (OB) batches == object batches now consist of 2 tables * ObjectThin * MeanObject --------------------------- === ObjectThin VOTable description of PSPS table ObjectThin === --------------------------- ||objName || dimensionless || VARCHAR(32) || NA ||IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version|| ||objID || dimensionless || BIGINT 8 || NA ||ODM object identifier index|| ||gcobjID || dimensionless || BIGINT 8 || NA ||galactic coordinates ODM object identifier|| ||ippObjID || dimensionless || BIGINT 8 || NA ||IPP object number|| ||surveyID || dimensionless || TINYINT 1 || 255 ||Survey ID|| ||skyCellID || dimensionless || REAL 4 || -999 ||single float giving PrimaryCell.SkyCell identifier|| ||htmID || dimensionless || BIGINT 8 || NA ||HTM index|| ||zoneID || dimensionless || INT 4 || NA ||Zone index|| ||randomID || dimensionless || BIGINT 8 || 0 ||Random integer between 0 and 2^32 - 4,394,967,296|| ||batchID || dimensionless || INT 4 || -999 ||batch id|| ||dvoRegionID || dimensionless || REAL 4 || -999 ||identifier of dvo spatial region -dvo cat id|| ||dataRelease || dimensionless || TINYINT 1 || NA ||Data release version of this table|| ||objInfoFlag || dimensionless || BIGINT 8 || -999 ||flag indicating odd properties|| ||qualityFlag || dimensionless || TINYINT 1 || 0 ||subset of objInfoFlag - flags related to goodness of object|| ||consistencyFlag || dimensionless || SMALLINT 2 || 0 ||Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation|| ||raStack || degrees || FLOAT 8 || -999 ||Right Ascension - best weighted RA across filters from stack WHENEVER an object is detected in the stack|| ||decStack || degrees || FLOAT 8 || -999 ||Declination - best weighted DEC across filters from stack WHENEVER an object is detected in the stack|| ||raStackErr || arcsec || REAL 4 || -999 ||Error in stack Right Ascension, note will have a systematic floor, and is not necessarily the best ra,dec for all objects|| ||decStackErr || arcsec || REAL 4 || -999 ||Error in stack Declination, note will have a systematic floor, and is not necessarily the best ra,dec for all objects|| ||raMean || degrees || FLOAT 8 || -999 ||Right Ascension from the Mean of RA from individual detections if it exists. This is for information only|| ||decMean || degrees || FLOAT 8 || -999 ||Declination from the Mean of Dec from individual detections if it exists. This is for information only|| ||raMeanErr || arcsec || REAL 4 || -999 ||Combination of the measurement errors in the Right Ascension from the mean detections if they exist|| ||decMeanErr || arcsec || REAL 4 || -999 ||Combination of the measurement errors in the Declination measurements if they exist|| ||raMeanStd || arcsec || REAL 4 || -999 ||standard deviation of Right Ascension measuments in detections if they exist|| ||decMeanStd || arcsec || REAL 4 || -999 ||standard deviation of Declination measurements in detections if they exist|| ||cx || dimensionless || FLOAT 8 || NA ||Cartesian x from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't || ||cy || dimensionless || FLOAT 8 || NA ||Cartesian y from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't || ||cz || dimensionless || FLOAT 8 || NA ||Cartesian z from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't || ||lambda || degrees || FLOAT 8 || -999 || ecliptic longitude from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't|| ||beta || degrees || FLOAT 8 || -999 || ecliptic latitude from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't|| ||l || degrees || FLOAT 8 || -999 || galactic longitude from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't|| ||b || degrees || FLOAT 8 || -999 || galactic latitude from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't|| ||nStackObjectRows || dimensionless || SMALLINT 2 || -999 ||number of independent StackObjectRows this object has. 0 if not detected in the stack, 1 if there is a primary, 2 or more if it is in an overlap region|| ||nStackDetections || dimensionless || SMALLINT 2 || 255 ||which filter bands it is detected in (not forced) or if it was masked in a band.|| ||nDetections || dimensionless || SMALLINT 2 || -999 ||total number of detection measurements in all filters|| ||ng || dimensionless || SMALLINT 2 || -999 ||number of measures in g filter|| ||nr || dimensionless || SMALLINT 2 || -999 ||number of measures in r filter|| ||ni || dimensionless || SMALLINT 2 || -999 ||number of measures in i filter|| ||nz || dimensionless || SMALLINT 2 || -999 ||number of measures in z filter|| ||ny || dimensionless || SMALLINT 2 || -999 ||number of measures in y filter|| --------------------------- === MeanObject VOTable description of PSPS table MeanObject === --------------------------- ||objID || dimensionless || BIGINT 8 || NA ||ODM object identifier index|| ||gcobjID || dimensionless || BIGINT 8 || NA ||galactic coordinates ODM object identifier|| ||gQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available g band detections|| ||gMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean g psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| ||gMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available g-band psf AB magnitudes|| ||gnIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| ||gMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| ||gMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| ||gMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| ||gMeanKronMag || AB magnitude || REAL 4 || -999 ||mean g kron AB magnitude from best available measurements|| ||gMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean g kron AB magnitude|| ||gnIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| ||gMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||gMeanApMag || AB magnitude || REAL 4 || -999 ||mean g aperture AB magnitude from best available measurements|| ||gMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean g aperture AB magnitude|| ||gnIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| ||gMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||gFlags || dimensionless || BIGINT 8 || NA ||flags for g mean|| ||rQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available r band detections|| ||rMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean r psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| ||rMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available r-band psf AB magnitudes|| ||rnIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| ||rMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| ||rMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| ||rMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| ||rMeanKronMag || AB magnitude || REAL 4 || -999 ||mean r kron AB magnitude from best available measurements|| ||rMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean r kron AB magnitude|| ||rnIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| ||rMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||rMeanApMag || AB magnitude || REAL 4 || -999 ||mean r aperture AB magnitude from best available measurements|| ||rMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean r aperture AB magnitude|| ||rnIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| ||rMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||rFlags || dimensionless || BIGINT 8 || NA ||flags for r mean|| ||iQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available i band detections|| ||iMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean i psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| ||iMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available i-band psf AB magnitudes|| ||inIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| ||iMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| ||iMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| ||iMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| ||iMeanKronMag || AB magnitude || REAL 4 || -999 ||mean i kron AB magnitude from best available measurements|| ||iMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean i kron AB magnitude|| ||inIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| ||iMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||iMeanApMag || AB magnitude || REAL 4 || -999 ||mean i aperture AB magnitude from best available measurements|| ||iMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean i aperture AB magnitude|| ||inIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| ||iMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||iFlags || dimensionless || BIGINT 8 || NA ||flags for i mean|| ||zQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available z band detections|| ||zMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean z psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| ||zMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available z-band psf AB magnitudes|| ||znIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| ||zMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| ||zMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| ||zMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| ||zMeanKronMag || AB magnitude || REAL 4 || -999 ||mean z kron AB magnitude from best available measurements|| ||zMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean z kron AB magnitude|| ||znIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| ||zMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||zMeanApMag || AB magnitude || REAL 4 || -999 ||mean z aperture AB magnitude from best available measurements|| ||zMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean z aperture AB magnitude|| ||znIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| ||zMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||zFlags || dimensionless || BIGINT 8 || NA ||flags for z mean|| ||yQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available y band detections|| ||yMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean y psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| ||yMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available y-band psf AB magnitudes|| ||ynIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| ||yMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| ||yMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| ||yMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| ||yMeanKronMag || AB magnitude || REAL 4 || -999 ||mean y kron AB magnitude from best available measurements|| ||yMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean y kron AB magnitude|| ||ynIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| ||yMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||yMeanApMag || AB magnitude || REAL 4 || -999 ||mean y aperture AB magnitude from best available measurements|| ||yMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean y aperture AB magnitude|| ||ynIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| ||yMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| ||yFlags || dimensionless || BIGINT 8 || NA ||flags for y mean||