TABLE  MeanObject

Contains the mean photometric information for objects based on the single epoch data.

Calculated as described in Magnier et al (2013). To be included in this
table, an object must be bright enough to have been detected at least once in
an individual exposure. PSF, Kron (1980), and aperture magnitudes and
statistics are listed for all filters.

Required constraints:
  • Primary key is (objID,uniquePspsOBid)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
objIDbigint8 Unique object identifier.  
uniquePspsOBidbigint8 Unique internal PSPS object identifier.  
gQfPerfectreal4 Maximum PSF weighted fraction of pixels totally unmasked from g filter detections.-999 
gMeanPSFMagreal4AB magnitudesMean PSF magnitude from g filter detections.-999 
gMeanPSFMagErrreal4AB magnitudesError in mean PSF magnitude from g filter detections.-999 
gMeanPSFMagStdreal4AB magnitudesStandard deviation of PSF magnitudes from g filter detections.-999 
gMeanPSFMagNptsmallint2 Number of measurements included in mean PSF magnitude from g filter detections.-999 
gMeanPSFMagMinreal4AB magnitudesMinimum PSF magnitude from g filter detections.-999 
gMeanPSFMagMaxreal4AB magnitudesMaximum PSF magnitude from g filter detections.-999 
gMeanKronMagreal4AB magnitudesMean Kron (1980) magnitude from g filter detections.-999 
gMeanKronMagErrreal4AB magnitudesError in mean Kron (1980) magnitude from g filter detections.-999 
gMeanKronMagStdreal4AB magnitudesStandard deviation of Kron (1980) magnitudes from g filter detections.-999 
gMeanKronMagNptsmallint2 Number of measurements included in mean Kron (1980) magnitude from g filter detections.-999 
gMeanApMagreal4AB magnitudesMean aperture magnitude from g filter detections.-999 
gMeanApMagErrreal4AB magnitudesError in mean aperture magnitude from g filter detections.-999 
gMeanApMagStdreal4AB magnitudesStandard deviation of aperture magnitudes from g filter detections.-999 
gMeanApMagNptsmallint2 Number of measurements included in mean aperture magnitude from g filter detections.-999 
gFlagsint4 Information flag bitmask for mean object from g filter detections. Values listed in ObjectFilterFlags.0 
rQfPerfectreal4 Maximum PSF weighted fraction of pixels totally unmasked from r filter detections.-999 
rMeanPSFMagreal4AB magnitudesMean PSF magnitude from r filter detections.-999 
rMeanPSFMagErrreal4AB magnitudesError in mean PSF magnitude from r filter detections.-999 
rMeanPSFMagStdreal4AB magnitudesStandard deviation of PSF magnitudes from r filter detections.-999 
rMeanPSFMagNptsmallint2 Number of measurements included in mean PSF magnitude from r filter detections.-999 
rMeanPSFMagMinreal4AB magnitudesMinimum PSF magnitude from r filter detections.-999 
rMeanPSFMagMaxreal4AB magnitudesMaximum PSF magnitude from r filter detections.-999 
rMeanKronMagreal4AB magnitudesMean Kron (1980) magnitude from r filter detections.-999 
rMeanKronMagErrreal4AB magnitudesError in mean Kron (1980) magnitude from r filter detections.-999 
rMeanKronMagStdreal4AB magnitudesStandard deviation of Kron (1980) magnitudes from r filter detections.-999 
rMeanKronMagNptsmallint2 Number of measurements included in mean Kron (1980) magnitude from r filter detections.-999 
rMeanApMagreal4AB magnitudesMean aperture magnitude from r filter detections.-999 
rMeanApMagErrreal4AB magnitudesError in mean aperture magnitude from r filter detections.-999 
rMeanApMagStdreal4AB magnitudesStandard deviation of aperture magnitudes from r filter detections.-999 
rMeanApMagNptsmallint2 Number of measurements included in mean aperture magnitude from r filter detections.-999 
rFlagsint4 Information flag bitmask for mean object from r filter detections. Values listed in ObjectFilterFlags.0 
iQfPerfectreal4 Maximum PSF weighted fraction of pixels totally unmasked from i filter detections.-999 
iMeanPSFMagreal4AB magnitudesMean PSF magnitude from i filter detections.-999 
iMeanPSFMagErrreal4AB magnitudesError in mean PSF magnitude from i filter detections.-999 
iMeanPSFMagStdreal4AB magnitudesStandard deviation of PSF magnitudes from i filter detections.-999 
iMeanPSFMagNptsmallint2 Number of measurements included in mean PSF magnitude from i filter detections.-999 
iMeanPSFMagMinreal4AB magnitudesMinimum PSF magnitude from i filter detections.-999 
iMeanPSFMagMaxreal4AB magnitudesMaximum PSF magnitude from i filter detections.-999 
iMeanKronMagreal4AB magnitudesMean Kron (1980) magnitude from i filter detections.-999 
iMeanKronMagErrreal4AB magnitudesError in mean Kron (1980) magnitude from i filter detections.-999 
iMeanKronMagStdreal4AB magnitudesStandard deviation of Kron (1980) magnitudes from i filter detections.-999 
iMeanKronMagNptsmallint2 Number of measurements included in mean Kron (1980) magnitude from i filter detections.-999 
iMeanApMagreal4AB magnitudesMean aperture magnitude from i filter detections.-999 
iMeanApMagErrreal4AB magnitudesError in mean aperture magnitude from i filter detections.-999 
iMeanApMagStdreal4AB magnitudesStandard deviation of aperture magnitudes from i filter detections.-999 
iMeanApMagNptsmallint2 Number of measurements included in mean aperture magnitude from i filter detections.-999 
iFlagsint4 Information flag bitmask for mean object from i filter detections. Values listed in ObjectFilterFlags.0 
zQfPerfectreal4 Maximum PSF weighted fraction of pixels totally unmasked from z filter detections.-999 
zMeanPSFMagreal4AB magnitudesMean PSF magnitude from z filter detections.-999 
zMeanPSFMagErrreal4AB magnitudesError in mean PSF magnitude from z filter detections.-999 
zMeanPSFMagStdreal4AB magnitudesStandard deviation of PSF magnitudes from z filter detections.-999 
zMeanPSFMagNptsmallint2 Number of measurements included in mean PSF magnitude from z filter detections.-999 
zMeanPSFMagMinreal4AB magnitudesMinimum PSF magnitude from z filter detections.-999 
zMeanPSFMagMaxreal4AB magnitudesMaximum PSF magnitude from z filter detections.-999 
zMeanKronMagreal4AB magnitudesMean Kron (1980) magnitude from z filter detections.-999 
zMeanKronMagErrreal4AB magnitudesError in mean Kron (1980) magnitude from z filter detections.-999 
zMeanKronMagStdreal4AB magnitudesStandard deviation of Kron (1980) magnitudes from z filter detections.-999 
zMeanKronMagNptsmallint2 Number of measurements included in mean Kron (1980) magnitude from z filter detections.-999 
zMeanApMagreal4AB magnitudesMean aperture magnitude from z filter detections.-999 
zMeanApMagErrreal4AB magnitudesError in mean aperture magnitude from z filter detections.-999 
zMeanApMagStdreal4AB magnitudesStandard deviation of aperture magnitudes from z filter detections.-999 
zMeanApMagNptsmallint2 Number of measurements included in mean aperture magnitude from z filter detections.-999 
zFlagsint4 Information flag bitmask for mean object from z filter detections. Values listed in ObjectFilterFlags.0 
yQfPerfectreal4 Maximum PSF weighted fraction of pixels totally unmasked from y filter detections.-999 
yMeanPSFMagreal4AB magnitudesMean PSF magnitude from y filter detections.-999 
yMeanPSFMagErrreal4AB magnitudesError in mean PSF magnitude from y filter detections.-999 
yMeanPSFMagStdreal4AB magnitudesStandard deviation of PSF magnitudes from y filter detections.-999 
yMeanPSFMagNptsmallint2 Number of measurements included in mean PSF magnitude from y filter detections.-999 
yMeanPSFMagMinreal4AB magnitudesMinimum PSF magnitude from y filter detections.-999 
yMeanPSFMagMaxreal4AB magnitudesMaximum PSF magnitude from y filter detections.-999 
yMeanKronMagreal4AB magnitudesMean Kron (1980) magnitude from y filter detections.-999 
yMeanKronMagErrreal4AB magnitudesError in mean Kron (1980) magnitude from y filter detections.-999 
yMeanKronMagStdreal4AB magnitudesStandard deviation of Kron (1980) magnitudes from y filter detections.-999 
yMeanKronMagNptsmallint2 Number of measurements included in mean Kron (1980) magnitude from y filter detections.-999 
yMeanApMagreal4AB magnitudesMean aperture magnitude from y filter detections.-999 
yMeanApMagErrreal4AB magnitudesError in mean aperture magnitude from y filter detections.-999 
yMeanApMagStdreal4AB magnitudesStandard deviation of aperture magnitudes from y filter detections.-999 
yMeanApMagNptsmallint2 Number of measurements included in mean aperture magnitude from y filter detections.-999 
yFlagsint4 Information flag bitmask for mean object from y filter detections. Values listed in ObjectFilterFlags.0 
Total length306