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