TABLE  StackObjectThin

Contains the positional and photometric information for point-source photometry of stack detections.

The information for all filters are joined into
a single row, with metadata indicating if this stack object represents the
primary detection. Due to overlaps in the stack tessellations, an object
may appear in multiple stack images. The primary detection is the unique
detection from the stack image that provides the best coverage with minimal
projection stretching. All other detections of the object in that filter are
secondary, regardless of their properties. The detection flagged as best is the
primary detection if that detection has a psfQf value greater than 0.98; if
that is not met, then any of the primary or secondary detections with the
highest psfQf value is flagged as best.

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
objIDbigint8 Unique object identifier.  
uniquePspsSTidbigint8 Unique internal PSPS stack identifier.  
ippObjIDbigint8 IPP internal object identifier.  
surveyIDtinyint1 Survey identifier. Details in the Survey table.  
tessIDtinyint1 Tessellation identifier. Details in the TessellationType table.0 
projectionIDsmallint2 Projection cell identifier.-1 
skyCellIDtinyint1 Skycell region identifier.255 
randomStackObjIDfloat8 Random value drawn from the interval between zero and one.  
primaryDetectiontinyint1 Identifies if this row is the primary stack detection.255 
bestDetectiontinyint1 Identifies if this row is the best detection.255 
dvoRegionIDint4 Internal DVO region identifier.-1 
processingVersiontinyint1 Data release version.  
gippDetectIDbigint8 IPP internal detection identifier.  
gstackDetectIDbigint8 Unique stack detection identifier.  
gstackImageIDbigint8 Unique stack identifier for g filter detection.  
grafloat8degreesRight ascension from g filter stack detection.-999 
gdecfloat8degreesDeclination from g filter stack detection.-999 
graErrreal4arcsecRight ascension error from g filter stack detection.-999 
gdecErrreal4arcsecDeclination error from g filter stack detection.-999 
gEpochfloat8daysModified Julian Date of the mean epoch of images contributing to the the g-band stack (equinox J2000).-999 
gPSFMagreal4AB magnitudesPSF magnitude from g filter stack detection.-999 
gPSFMagErrreal4AB magnitudesError in PSF magnitude from g filter stack detection.-999 
gApMagreal4AB magnitudesAperture magnitude from g filter stack detection.-999 
gApMagErrreal4AB magnitudesError in aperture magnitude from g filter stack detection.-999 
gKronMagreal4AB magnitudesKron (1980) magnitude from g filter stack detection.-999 
gKronMagErrreal4AB magnitudesError in Kron (1980) magnitude from g filter stack detection.-999 
ginfoFlagbigint8 Information flag bitmask indicating details of the g filter stack photometry. Values listed in DetectionFlags.0 
ginfoFlag2int4 Information flag bitmask indicating details of the g filter stack photometry. Values listed in DetectionFlags2.0 
ginfoFlag3int4 Information flag bitmask indicating details of the g filter stack photometry. Values listed in DetectionFlags3.0 
gnFramesint4 Number of input frames/exposures contributing to the g filter stack detection.-999 
rippDetectIDbigint8 IPP internal detection identifier.  
rstackDetectIDbigint8 Unique stack detection identifier.  
rstackImageIDbigint8 Unique stack identifier for r filter detection.  
rrafloat8degreesRight ascension from r filter stack detection.-999 
rdecfloat8degreesDeclination from r filter stack detection.-999 
rraErrreal4arcsecRight ascension error from r filter stack detection.-999 
rdecErrreal4arcsecDeclination error from r filter stack detection.-999 
rEpochfloat8daysModified Julian Date of the mean epoch of images contributing to the the r-band stack (equinox J2000).-999 
rPSFMagreal4AB magnitudesPSF magnitude from r filter stack detection.-999 
rPSFMagErrreal4AB magnitudesError in PSF magnitude from r filter stack detection.-999 
rApMagreal4AB magnitudesAperture magnitude from r filter stack detection.-999 
rApMagErrreal4AB magnitudesError in aperture magnitude from r filter stack detection.-999 
rKronMagreal4AB magnitudesKron (1980) magnitude from r filter stack detection.-999 
rKronMagErrreal4AB magnitudesError in Kron (1980) magnitude from r filter stack detection.-999 
rinfoFlagbigint8 Information flag bitmask indicating details of the r filter stack photometry. Values listed in DetectionFlags.0 
rinfoFlag2int4 Information flag bitmask indicating details of the r filter stack photometry. Values listed in DetectionFlags2.0 
rinfoFlag3int4 Information flag bitmask indicating details of the r filter stack photometry. Values listed in DetectionFlags3.0 
rnFramesint4 Number of input frames/exposures contributing to the r filter stack detection.-999 
iippDetectIDbigint8 IPP internal detection identifier.  
istackDetectIDbigint8 Unique stack detection identifier.  
istackImageIDbigint8 Unique stack identifier for i filter detection.  
irafloat8degreesRight ascension from i filter stack detection.-999 
idecfloat8degreesDeclination from i filter stack detection.-999 
iraErrreal4arcsecRight ascension error from i filter stack detection.-999 
idecErrreal4arcsecDeclination error from i filter stack detection.-999 
iEpochfloat8daysModified Julian Date of the mean epoch of images contributing to the the i-band stack (equinox J2000).-999 
iPSFMagreal4AB magnitudesPSF magnitude from i filter stack detection.-999 
iPSFMagErrreal4AB magnitudesError in PSF magnitude from i filter stack detection.-999 
iApMagreal4AB magnitudesAperture magnitude from i filter stack detection.-999 
iApMagErrreal4AB magnitudesError in aperture magnitude from i filter stack detection.-999 
iKronMagreal4AB magnitudesKron (1980) magnitude from i filter stack detection.-999 
iKronMagErrreal4AB magnitudesError in Kron (1980) magnitude from i filter stack detection.-999 
iinfoFlagbigint8 Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags.0 
iinfoFlag2int4 Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags2.0 
iinfoFlag3int4 Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags3.0 
inFramesint4 Number of input frames/exposures contributing to the i filter stack detection.-999 
zippDetectIDbigint8 IPP internal detection identifier.  
zstackDetectIDbigint8 Unique stack detection identifier.  
zstackImageIDbigint8 Unique stack identifier for z filter detection.  
zrafloat8degreesRight ascension from z filter stack detection.-999 
zdecfloat8degreesDeclination from z filter stack detection.-999 
zraErrreal4arcsecRight ascension error from z filter stack detection.-999 
zdecErrreal4arcsecDeclination error from z filter stack detection.-999 
zEpochfloat8daysModified Julian Date of the mean epoch of images contributing to the the z-band stack (equinox J2000).-999 
zPSFMagreal4AB magnitudesPSF magnitude from z filter stack detection.-999 
zPSFMagErrreal4AB magnitudesError in PSF magnitude from z filter stack detection.-999 
zApMagreal4AB magnitudesAperture magnitude from z filter stack detection.-999 
zApMagErrreal4AB magnitudesError in aperture magnitude from z filter stack detection.-999 
zKronMagreal4AB magnitudesKron (1980) magnitude from z filter stack detection.-999 
zKronMagErrreal4AB magnitudesError in Kron (1980) magnitude from z filter stack detection.-999 
zinfoFlagbigint8 Information flag bitmask indicating details of the z filter stack photometry. Values listed in DetectionFlags.0 
zinfoFlag2int4 Information flag bitmask indicating details of the z filter stack photometry. Values listed in DetectionFlags2.0 
zinfoFlag3int4 Information flag bitmask indicating details of the z filter stack photometry. Values listed in DetectionFlags3.0 
znFramesint4 Number of input frames/exposures contributing to the z filter stack detection.-999 
yippDetectIDbigint8 IPP internal detection identifier.  
ystackDetectIDbigint8 Unique stack detection identifier.  
ystackImageIDbigint8 Unique stack identifier for y filter detection.  
yrafloat8degreesRight ascension from y filter stack detection.-999 
ydecfloat8degreesDeclination from y filter stack detection.-999 
yraErrreal4arcsecRight ascension error from y filter stack detection.-999 
ydecErrreal4arcsecDeclination error from y filter stack detection.-999 
yEpochfloat8daysModified Julian Date of the mean epoch of images contributing to the the y-band stack (equinox J2000).-999 
yPSFMagreal4AB magnitudesPSF magnitude from y filter stack detection.-999 
yPSFMagErrreal4AB magnitudesError in PSF magnitude from y filter stack detection.-999 
yApMagreal4AB magnitudesAperture magnitude from y filter stack detection.-999 
yApMagErrreal4AB magnitudesError in aperture magnitude from y filter stack detection.-999 
yKronMagreal4AB magnitudesKron (1980) magnitude from y filter stack detection.-999 
yKronMagErrreal4AB magnitudesError in Kron (1980) magnitude from y filter stack detection.-999 
yinfoFlagbigint8 Information flag bitmask indicating details of the y filter stack photometry. Values listed in DetectionFlags.0 
yinfoFlag2int4 Information flag bitmask indicating details of the y filter stack photometry. Values listed in DetectionFlags2.0 
yinfoFlag3int4 Information flag bitmask indicating details of the y filter stack photometry. Values listed in DetectionFlags3.0 
ynFramesint4 Number of input frames/exposures contributing to the y filter stack detection.-999 
Total length544