Name | Unit | Data Type | Size | Default Value | Description |
---|
objID | dimensionless | BIGINT | 8 | NA | Unique object identifier. |
uniquePspsSTid | dimensionless | BIGINT | 8 | NA | Unique internal PSPS stack identifier. |
ippObjID | dimensionless | BIGINT | 8 | NA | IPP internal object identifier. |
surveyID | dimensionless | TINYINT | 1 | NA | Survey identifier. Details in the Survey table. |
tessID | dimensionless | TINYINT | 1 | 0 | Tessellation identifier. Details in the TessellationType table. |
projectionID | dimensionless | SMALLINT | 2 | -1 | Projection cell identifier. |
skyCellID | dimensionless | TINYINT | 1 | 255 | Skycell region identifier. |
randomStackObjID | dimensionless | FLOAT | 8 | NA | Random value drawn from the interval between zero and one. |
primaryDetection | dimensionless | TINYINT | 1 | 255 | Identifies if this row is the primary stack detection. Note that in the DR1 database, about 0.5% of the objects have more than one entry with primaryDetection=1. This is expected to be fixed in the DR2 database. |
bestDetection | dimensionless | TINYINT | 1 | 255 | Identifies if this row is the best detection. The entries in this column are flawed in the DR1 database, which makes it not very useful for selecting objects from the table. We recommend using the primaryDetection flag instead (although it also has shortcomings). This is planned to be fixed in DR2. |
dvoRegionID | dimensionless | INT | 4 | -1 | Internal DVO region identifier. |
processingVersion | dimensionless | TINYINT | 1 | NA | Data release version. |
gippDetectID | dimensionless | BIGINT | 8 | NA | IPP internal detection identifier. |
gstackDetectID | dimensionless | BIGINT | 8 | NA | Unique stack detection identifier. |
gstackImageID | dimensionless | BIGINT | 8 | NA | Unique stack identifier for g filter detection. |
gra | degrees | FLOAT | 8 | -999 | Right ascension from g filter stack detection. |
gdec | degrees | FLOAT | 8 | -999 | Declination from g filter stack detection. |
graErr | arcsec | REAL | 4 | -999 | Right ascension error from g filter stack detection. |
gdecErr | arcsec | REAL | 4 | -999 | Declination error from g filter stack detection. |
gEpoch | days | FLOAT | 8 | -999 | Modified Julian Date of the mean epoch of images contributing to the the g-band stack (equinox J2000). |
gPSFMag | AB magnitudes | REAL | 4 | -999 | PSF magnitude from g filter stack detection. |
gPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in PSF magnitude from g filter stack detection. |
gApMag | AB magnitudes | REAL | 4 | -999 | Aperture magnitude from g filter stack detection. |
gApMagErr | AB magnitudes | REAL | 4 | -999 | Error in aperture magnitude from g filter stack detection. |
gKronMag | AB magnitudes | REAL | 4 | -999 | Kron (1980) magnitude from g filter stack detection. |
gKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in Kron (1980) magnitude from g filter stack detection. |
ginfoFlag | dimensionless | BIGINT | 8 | 0 | Information flag bitmask indicating details of the g filter stack photometry. Values listed in DetectionFlags. |
ginfoFlag2 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the g filter stack photometry. Values listed in DetectionFlags2. |
ginfoFlag3 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the g filter stack photometry. Values listed in DetectionFlags3. |
gnFrames | dimensionless | INT | 4 | -999 | Number of input frames/exposures contributing to the g filter stack detection. |
rippDetectID | dimensionless | BIGINT | 8 | NA | IPP internal detection identifier. |
rstackDetectID | dimensionless | BIGINT | 8 | NA | Unique stack detection identifier. |
rstackImageID | dimensionless | BIGINT | 8 | NA | Unique stack identifier for r filter detection. |
rra | degrees | FLOAT | 8 | -999 | Right ascension from r filter stack detection. |
rdec | degrees | FLOAT | 8 | -999 | Declination from r filter stack detection. |
rraErr | arcsec | REAL | 4 | -999 | Right ascension error from r filter stack detection. |
rdecErr | arcsec | REAL | 4 | -999 | Declination error from r filter stack detection. |
rEpoch | days | FLOAT | 8 | -999 | Modified Julian Date of the mean epoch of images contributing to the the r-band stack (equinox J2000). |
rPSFMag | AB magnitudes | REAL | 4 | -999 | PSF magnitude from r filter stack detection. |
rPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in PSF magnitude from r filter stack detection. |
rApMag | AB magnitudes | REAL | 4 | -999 | Aperture magnitude from r filter stack detection. |
rApMagErr | AB magnitudes | REAL | 4 | -999 | Error in aperture magnitude from r filter stack detection. |
rKronMag | AB magnitudes | REAL | 4 | -999 | Kron (1980) magnitude from r filter stack detection. |
rKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in Kron (1980) magnitude from r filter stack detection. |
rinfoFlag | dimensionless | BIGINT | 8 | 0 | Information flag bitmask indicating details of the r filter stack photometry. Values listed in DetectionFlags. |
rinfoFlag2 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the r filter stack photometry. Values listed in DetectionFlags2. |
rinfoFlag3 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the r filter stack photometry. Values listed in DetectionFlags3. |
rnFrames | dimensionless | INT | 4 | -999 | Number of input frames/exposures contributing to the r filter stack detection. |
iippDetectID | dimensionless | BIGINT | 8 | NA | IPP internal detection identifier. |
istackDetectID | dimensionless | BIGINT | 8 | NA | Unique stack detection identifier. |
istackImageID | dimensionless | BIGINT | 8 | NA | Unique stack identifier for i filter detection. |
ira | degrees | FLOAT | 8 | -999 | Right ascension from i filter stack detection. |
idec | degrees | FLOAT | 8 | -999 | Declination from i filter stack detection. |
iraErr | arcsec | REAL | 4 | -999 | Right ascension error from i filter stack detection. |
idecErr | arcsec | REAL | 4 | -999 | Declination error from i filter stack detection. |
iEpoch | days | FLOAT | 8 | -999 | Modified Julian Date of the mean epoch of images contributing to the the i-band stack (equinox J2000). |
iPSFMag | AB magnitudes | REAL | 4 | -999 | PSF magnitude from i filter stack detection. |
iPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in PSF magnitude from i filter stack detection. |
iApMag | AB magnitudes | REAL | 4 | -999 | Aperture magnitude from i filter stack detection. |
iApMagErr | AB magnitudes | REAL | 4 | -999 | Error in aperture magnitude from i filter stack detection. |
iKronMag | AB magnitudes | REAL | 4 | -999 | Kron (1980) magnitude from i filter stack detection. |
iKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in Kron (1980) magnitude from i filter stack detection. |
iinfoFlag | dimensionless | BIGINT | 8 | 0 | Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags. |
iinfoFlag2 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags2. |
iinfoFlag3 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags3. |
inFrames | dimensionless | INT | 4 | -999 | Number of input frames/exposures contributing to the i filter stack detection. |
zippDetectID | dimensionless | BIGINT | 8 | NA | IPP internal detection identifier. |
zstackDetectID | dimensionless | BIGINT | 8 | NA | Unique stack detection identifier. |
zstackImageID | dimensionless | BIGINT | 8 | NA | Unique stack identifier for z filter detection. |
zra | degrees | FLOAT | 8 | -999 | Right ascension from z filter stack detection. |
zdec | degrees | FLOAT | 8 | -999 | Declination from z filter stack detection. |
zraErr | arcsec | REAL | 4 | -999 | Right ascension error from z filter stack detection. |
zdecErr | arcsec | REAL | 4 | -999 | Declination error from z filter stack detection. |
zEpoch | days | FLOAT | 8 | -999 | Modified Julian Date of the mean epoch of images contributing to the the z-band stack (equinox J2000). |
zPSFMag | AB magnitudes | REAL | 4 | -999 | PSF magnitude from z filter stack detection. |
zPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in PSF magnitude from z filter stack detection. |
zApMag | AB magnitudes | REAL | 4 | -999 | Aperture magnitude from z filter stack detection. |
zApMagErr | AB magnitudes | REAL | 4 | -999 | Error in aperture magnitude from z filter stack detection. |
zKronMag | AB magnitudes | REAL | 4 | -999 | Kron (1980) magnitude from z filter stack detection. |
zKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in Kron (1980) magnitude from z filter stack detection. |
zinfoFlag | dimensionless | BIGINT | 8 | 0 | Information flag bitmask indicating details of the z filter stack photometry. Values listed in DetectionFlags. |
zinfoFlag2 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the z filter stack photometry. Values listed in DetectionFlags2. |
zinfoFlag3 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the z filter stack photometry. Values listed in DetectionFlags3. |
znFrames | dimensionless | INT | 4 | -999 | Number of input frames/exposures contributing to the z filter stack detection. |
yippDetectID | dimensionless | BIGINT | 8 | NA | IPP internal detection identifier. |
ystackDetectID | dimensionless | BIGINT | 8 | NA | Unique stack detection identifier. |
ystackImageID | dimensionless | BIGINT | 8 | NA | Unique stack identifier for y filter detection. |
yra | degrees | FLOAT | 8 | -999 | Right ascension from y filter stack detection. |
ydec | degrees | FLOAT | 8 | -999 | Declination from y filter stack detection. |
yraErr | arcsec | REAL | 4 | -999 | Right ascension error from y filter stack detection. |
ydecErr | arcsec | REAL | 4 | -999 | Declination error from y filter stack detection. |
yEpoch | days | FLOAT | 8 | -999 | Modified Julian Date of the mean epoch of images contributing to the the y-band stack (equinox J2000). |
yPSFMag | AB magnitudes | REAL | 4 | -999 | PSF magnitude from y filter stack detection. |
yPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in PSF magnitude from y filter stack detection. |
yApMag | AB magnitudes | REAL | 4 | -999 | Aperture magnitude from y filter stack detection. |
yApMagErr | AB magnitudes | REAL | 4 | -999 | Error in aperture magnitude from y filter stack detection. |
yKronMag | AB magnitudes | REAL | 4 | -999 | Kron (1980) magnitude from y filter stack detection. |
yKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in Kron (1980) magnitude from y filter stack detection. |
yinfoFlag | dimensionless | BIGINT | 8 | 0 | Information flag bitmask indicating details of the y filter stack photometry. Values listed in DetectionFlags. |
yinfoFlag2 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the y filter stack photometry. Values listed in DetectionFlags2. |
yinfoFlag3 | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the y filter stack photometry. Values listed in DetectionFlags3. |
ynFrames | dimensionless | INT | 4 | -999 | Number of input frames/exposures contributing to the y filter stack detection. |