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 232 - 4,394,967,296
batchID	dimensionless	BIGINT 8	-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