The starting point for the PS1 data archive is at Pan-STARRS1 data archive home page.
This page describes a "View", which is a database table created by joining other tables.
| Description: -- View based on a combination of the tables MeanObject and ObjectThin joined by objID colummn. | |||||
|---|---|---|---|---|---|
| Name | Unit | Data Type | Size | Default Value | Description |
| objName | dimensionless | VARCHAR(32) | 32 | NA | IAU name for this object. |
| objAltName1 | dimensionless | VARCHAR(32) | 32 | NA | Alternate name for this object. |
| objAltName2 | dimensionless | VARCHAR(32) | 32 | Altername name for this object. | |
| objAltName3 | dimensionless | VARCHAR(32) | 32 | Altername name for this object. | |
| objID | dimensionless | BIGINT | 8 | NA | Unique object identifier. |
| uniquePspsOBid | dimensionless | BIGINT | 8 | NA | Unique internal PSPS object identifier. |
| ippObjID | dimensionless | BIGINT | 8 | NA | IPP internal object identifier. |
| surveyID | dimensionless | TINYINT | 1 | NA | Survey identifier. Details in the Survey table. |
| htmID | dimensionless | BIGINT | 8 | NA | Hierarchical triangular mesh (Szalay 2007) index. |
| zoneID | dimensionless | INT | 4 | NA | Local zone index, found by dividing the sky into bands of declination 1/2 arcminute in height: zoneID = floor((90 + declination)/0.0083333). |
| 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. |
| randomID | dimensionless | FLOAT | 8 | NA | Random value drawn from the interval between zero and one. |
| batchID | dimensionless | BIGINT | 8 | NA | Internal database batch identifier. |
| dvoRegionID | dimensionless | INT | 4 | -1 | Internal DVO region identifier. |
| processingVersion | dimensionless | TINYINT | 1 | NA | Data release version. |
| objInfoFlag | dimensionless | INT | 4 | 0 | Information flag bitmask indicating details of the photometry. Values listed in ObjectInfoFlags. |
| qualityFlag | dimensionless | TINYINT | 1 | 0 | Subset of objInfoFlag denoting whether this object is real or a likely false positive. Values listed in ObjectQualityFlags. |
| raStack | degrees | FLOAT | 8 | -999 | Right ascension from stack detections, weighted mean value across filters, in equinox J2000. See StackObjectThin for stack epoch information. |
| decStack | degrees | FLOAT | 8 | -999 | Declination from stack detections, weighted mean value across filters, in equinox J2000. See StackObjectThin for stack epoch information. |
| raStackErr | arcsec | REAL | 4 | -999 | Right ascension standard deviation from stack detections. |
| decStackErr | arcsec | REAL | 4 | -999 | Declination standard deviation from stack detections. |
| raMean | degrees | FLOAT | 8 | -999 | Right ascension from single epoch detections (weighted mean) in equinox J2000 at the mean epoch given by epochMean. |
| decMean | degrees | FLOAT | 8 | -999 | Declination from single epoch detections (weighted mean) in equinox J2000 at the mean epoch given by epochMean. |
| raMeanErr | arcsec | REAL | 4 | -999 | Right ascension standard deviation from single epoch detections. |
| decMeanErr | arcsec | REAL | 4 | -999 | Declination standard deviation from single epoch detections. |
| epochMean | days | FLOAT | 8 | -999 | Modified Julian Date of the mean epoch corresponding to raMean, decMean (equinox J2000). |
| posMeanChisq | dimensionless | REAL | 4 | -999 | Reduced chi squared value of mean position. |
| cx | dimensionless | FLOAT | 8 | NA | Cartesian x on a unit sphere. |
| cy | dimensionless | FLOAT | 8 | NA | Cartesian y on a unit sphere. |
| cz | dimensionless | FLOAT | 8 | NA | Cartesian z on a unit sphere. |
| lambda | degrees | FLOAT | 8 | -999 | Ecliptic longitude. |
| beta | degrees | FLOAT | 8 | -999 | Ecliptic latitude. |
| l | degrees | FLOAT | 8 | -999 | Galactic longitude. |
| b | degrees | FLOAT | 8 | -999 | Galactic latitude. |
| nStackObjectRows | dimensionless | SMALLINT | 2 | -999 | Number of independent StackObjectThin rows associated with this object. |
| nStackDetections | dimensionless | SMALLINT | 2 | -999 | Number of stack detections. |
| nDetections | dimensionless | SMALLINT | 2 | -999 | Number of single epoch detections in all filters. |
| ng | dimensionless | SMALLINT | 2 | -999 | Number of single epoch detections in g filter. |
| nr | dimensionless | SMALLINT | 2 | -999 | Number of single epoch detections in r filter. |
| ni | dimensionless | SMALLINT | 2 | -999 | Number of single epoch detections in i filter. |
| nz | dimensionless | SMALLINT | 2 | -999 | Number of single epoch detections in z filter. |
| ny | dimensionless | SMALLINT | 2 | -999 | Number of single epoch detections in y filter. |
| gQfPerfect | dimensionless | REAL | 4 | -999 | Maximum PSF weighted fraction of pixels totally unmasked from g filter detections. |
| gMeanPSFMag | AB magnitudes | REAL | 4 | -999 | Mean PSF magnitude from g filter detections. |
| gMeanPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean PSF magnitude from g filter detections. |
| gMeanPSFMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of PSF magnitudes from g filter detections. |
| gMeanPSFMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean PSF magnitude from g filter detections. |
| gMeanPSFMagMin | AB magnitudes | REAL | 4 | -999 | Minimum PSF magnitude from g filter detections. |
| gMeanPSFMagMax | AB magnitudes | REAL | 4 | -999 | Maximum PSF magnitude from g filter detections. |
| gMeanKronMag | AB magnitudes | REAL | 4 | -999 | Mean Kron (1980) magnitude from g filter detections. |
| gMeanKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean Kron (1980) magnitude from g filter detections. |
| gMeanKronMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of Kron (1980) magnitudes from g filter detections. |
| gMeanKronMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean Kron (1980) magnitude from g filter detections. |
| gMeanApMag | AB magnitudes | REAL | 4 | -999 | Mean aperture magnitude from g filter detections. |
| gMeanApMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean aperture magnitude from g filter detections. |
| gMeanApMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of aperture magnitudes from g filter detections. |
| gMeanApMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean aperture magnitude from g filter detections. |
| gFlags | dimensionless | INT | 4 | 0 | Information flag bitmask for mean object from g filter detections. Values listed in ObjectFilterFlags. |
| rQfPerfect | dimensionless | REAL | 4 | -999 | Maximum PSF weighted fraction of pixels totally unmasked from r filter detections. |
| rMeanPSFMag | AB magnitudes | REAL | 4 | -999 | Mean PSF magnitude from r filter detections. |
| rMeanPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean PSF magnitude from r filter detections. |
| rMeanPSFMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of PSF magnitudes from r filter detections. |
| rMeanPSFMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean PSF magnitude from r filter detections. |
| rMeanPSFMagMin | AB magnitudes | REAL | 4 | -999 | Minimum PSF magnitude from r filter detections. |
| rMeanPSFMagMax | AB magnitudes | REAL | 4 | -999 | Maximum PSF magnitude from r filter detections. |
| rMeanKronMag | AB magnitudes | REAL | 4 | -999 | Mean Kron (1980) magnitude from r filter detections. |
| rMeanKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean Kron (1980) magnitude from r filter detections. |
| rMeanKronMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of Kron (1980) magnitudes from r filter detections. |
| rMeanKronMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean Kron (1980) magnitude from r filter detections. |
| rMeanApMag | AB magnitudes | REAL | 4 | -999 | Mean aperture magnitude from r filter detections. |
| rMeanApMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean aperture magnitude from r filter detections. |
| rMeanApMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of aperture magnitudes from r filter detections. |
| rMeanApMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean aperture magnitude from r filter detections. |
| rFlags | dimensionless | INT | 4 | 0 | Information flag bitmask for mean object from r filter detections. Values listed in ObjectFilterFlags. |
| iQfPerfect | dimensionless | REAL | 4 | -999 | Maximum PSF weighted fraction of pixels totally unmasked from i filter detections. |
| iMeanPSFMag | AB magnitudes | REAL | 4 | -999 | Mean PSF magnitude from i filter detections. |
| iMeanPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean PSF magnitude from i filter detections. |
| iMeanPSFMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of PSF magnitudes from i filter detections. |
| iMeanPSFMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean PSF magnitude from i filter detections. |
| iMeanPSFMagMin | AB magnitudes | REAL | 4 | -999 | Minimum PSF magnitude from i filter detections. |
| iMeanPSFMagMax | AB magnitudes | REAL | 4 | -999 | Maximum PSF magnitude from i filter detections. |
| iMeanKronMag | AB magnitudes | REAL | 4 | -999 | Mean Kron (1980) magnitude from i filter detections. |
| iMeanKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean Kron (1980) magnitude from i filter detections. |
| iMeanKronMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of Kron (1980) magnitudes from i filter detections. |
| iMeanKronMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean Kron (1980) magnitude from i filter detections. |
| iMeanApMag | AB magnitudes | REAL | 4 | -999 | Mean aperture magnitude from i filter detections. |
| iMeanApMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean aperture magnitude from i filter detections. |
| iMeanApMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of aperture magnitudes from i filter detections. |
| iMeanApMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean aperture magnitude from i filter detections. |
| iFlags | dimensionless | INT | 4 | 0 | Information flag bitmask for mean object from i filter detections. Values listed in ObjectFilterFlags. |
| zQfPerfect | dimensionless | REAL | 4 | -999 | Maximum PSF weighted fraction of pixels totally unmasked from z filter detections. |
| zMeanPSFMag | AB magnitudes | REAL | 4 | -999 | Mean PSF magnitude from z filter detections. |
| zMeanPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean PSF magnitude from z filter detections. |
| zMeanPSFMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of PSF magnitudes from z filter detections. |
| zMeanPSFMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean PSF magnitude from z filter detections. |
| zMeanPSFMagMin | AB magnitudes | REAL | 4 | -999 | Minimum PSF magnitude from z filter detections. |
| zMeanPSFMagMax | AB magnitudes | REAL | 4 | -999 | Maximum PSF magnitude from z filter detections. |
| zMeanKronMag | AB magnitudes | REAL | 4 | -999 | Mean Kron (1980) magnitude from z filter detections. |
| zMeanKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean Kron (1980) magnitude from z filter detections. |
| zMeanKronMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of Kron (1980) magnitudes from z filter detections. |
| zMeanKronMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean Kron (1980) magnitude from z filter detections. |
| zMeanApMag | AB magnitudes | REAL | 4 | -999 | Mean aperture magnitude from z filter detections. |
| zMeanApMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean aperture magnitude from z filter detections. |
| zMeanApMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of aperture magnitudes from z filter detections. |
| zMeanApMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean aperture magnitude from z filter detections. |
| zFlags | dimensionless | INT | 4 | 0 | Information flag bitmask for mean object from z filter detections. Values listed in ObjectFilterFlags. |
| yQfPerfect | dimensionless | REAL | 4 | -999 | Maximum PSF weighted fraction of pixels totally unmasked from y filter detections. |
| yMeanPSFMag | AB magnitudes | REAL | 4 | -999 | Mean PSF magnitude from y filter detections. |
| yMeanPSFMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean PSF magnitude from y filter detections. |
| yMeanPSFMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of PSF magnitudes from y filter detections. |
| yMeanPSFMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean PSF magnitude from y filter detections. |
| yMeanPSFMagMin | AB magnitudes | REAL | 4 | -999 | Minimum PSF magnitude from y filter detections. |
| yMeanPSFMagMax | AB magnitudes | REAL | 4 | -999 | Maximum PSF magnitude from y filter detections. |
| yMeanKronMag | AB magnitudes | REAL | 4 | -999 | Mean Kron (1980) magnitude from y filter detections. |
| yMeanKronMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean Kron (1980) magnitude from y filter detections. |
| yMeanKronMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of Kron (1980) magnitudes from y filter detections. |
| yMeanKronMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean Kron (1980) magnitude from y filter detections. |
| yMeanApMag | AB magnitudes | REAL | 4 | -999 | Mean aperture magnitude from y filter detections. |
| yMeanApMagErr | AB magnitudes | REAL | 4 | -999 | Error in mean aperture magnitude from y filter detections. |
| yMeanApMagStd | AB magnitudes | REAL | 4 | -999 | Standard deviation of aperture magnitudes from y filter detections. |
| yMeanApMagNpt | dimensionless | SMALLINT | 2 | -999 | Number of measurements included in mean aperture magnitude from y filter detections. |
| yFlags | dimensionless | INT | 4 | 0 | Information flag bitmask for mean object from y filter detections. Values listed in ObjectFilterFlags. |
