| 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 | 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
|
| 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
|
