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: -- ObjectThin join StackPetrosian joined by objID column. | |||||
|---|---|---|---|---|---|
| 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. |
| primaryDetection | dimensionless | TINYINT | 1 | 255 | Identifies if this row is the primary stack detection. |
| bestDetection | dimensionless | TINYINT | 1 | 255 | Identifies if this row is the best detection. |
| 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. |
| gpetRadius | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for g filter stack detection. |
| gpetRadiusErr | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for g filter stack detection. |
| gpetMag | AB magnitudes | REAL | 4 | -999 | Petrosian (1976) magnitude from g filter stack detection. |
| gpetMagErr | AB magnitudes | REAL | 4 | -999 | Error in Petrosian (1976) magnitude from g filter stack detection. |
| gpetR50 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for g filter stack detection. at 50% light |
| gpetR50Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for g filter stack detection. at 50% light |
| gpetR90 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for g filter stack detection. at 90% light |
| gpetR90Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for g filter stack detection. at 90% light |
| gpetCf | dimensionless | REAL | 4 | -999 | Petrosian (1976) fit coverage factor for 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. |
| rpetRadius | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for r filter stack detection. |
| rpetRadiusErr | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for r filter stack detection. |
| rpetMag | AB magnitudes | REAL | 4 | -999 | Petrosian (1976) magnitude from r filter stack detection. |
| rpetMagErr | AB magnitudes | REAL | 4 | -999 | Error in Petrosian (1976) magnitude from r filter stack detection. |
| rpetR50 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for r filter stack detection. at 50% light |
| rpetR50Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for r filter stack detection. at 50% light |
| rpetR90 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for r filter stack detection. at 90% light |
| rpetR90Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for r filter stack detection. at 90% light |
| rpetCf | dimensionless | REAL | 4 | -999 | Petrosian (1976) fit coverage factor for 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. |
| ipetRadius | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for i filter stack detection. |
| ipetRadiusErr | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for i filter stack detection. |
| ipetMag | AB magnitudes | REAL | 4 | -999 | Petrosian (1976) magnitude from i filter stack detection. |
| ipetMagErr | AB magnitudes | REAL | 4 | -999 | Error in Petrosian (1976) magnitude from i filter stack detection. |
| ipetR50 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for i filter stack detection. at 50% light |
| ipetR50Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for i filter stack detection. at 50% light |
| ipetR90 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for i filter stack detection. at 90% light |
| ipetR90Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for i filter stack detection. at 90% light |
| ipetCf | dimensionless | REAL | 4 | -999 | Petrosian (1976) fit coverage factor for 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. |
| zpetRadius | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for z filter stack detection. |
| zpetRadiusErr | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for z filter stack detection. |
| zpetMag | AB magnitudes | REAL | 4 | -999 | Petrosian (1976) magnitude from z filter stack detection. |
| zpetMagErr | AB magnitudes | REAL | 4 | -999 | Error in Petrosian (1976) magnitude from z filter stack detection. |
| zpetR50 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for z filter stack detection. at 50% light |
| zpetR50Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for z filter stack detection. at 50% light |
| zpetR90 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for z filter stack detection. at 90% light |
| zpetR90Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for z filter stack detection. at 90% light |
| zpetCf | dimensionless | REAL | 4 | -999 | Petrosian (1976) fit coverage factor for 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. |
| ypetRadius | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for y filter stack detection. |
| ypetRadiusErr | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for y filter stack detection. |
| ypetMag | AB magnitudes | REAL | 4 | -999 | Petrosian (1976) magnitude from y filter stack detection. |
| ypetMagErr | AB magnitudes | REAL | 4 | -999 | Error in Petrosian (1976) magnitude from y filter stack detection. |
| ypetR50 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for y filter stack detection. at 50% light |
| ypetR50Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for y filter stack detection. at 50% light |
| ypetR90 | arcsec | REAL | 4 | -999 | Petrosian (1976) fit radius for y filter stack detection. at 90% light |
| ypetR90Err | arcsec | REAL | 4 | -999 | Error in Petrosian (1976) fit radius for y filter stack detection. at 90% light |
| ypetCf | dimensionless | REAL | 4 | -999 | Petrosian (1976) fit coverage factor for y filter stack detection. |
