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 StackModelFitExp 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. |
| gExpRadius | arcsec | REAL | 4 | -999 | Exponential fit radius for g filter stack detection. |
| gExpRadiusErr | arcsec | REAL | 4 | -999 | Error in exponential fit radius for g filter stack detection. |
| gExpMag | AB magnitudes | REAL | 4 | -999 | Exponential fit magnitude for g filter stack detection. |
| gExpMagErr | AB magnitudes | REAL | 4 | -999 | Error in exponential fit magnitude for g filter stack detection. |
| gExpAb | dimensionless | REAL | 4 | -999 | Exponential fit axis ratio for g filter stack detection. |
| gExpAbErr | dimensionless | REAL | 4 | -999 | Error in exponential fit axis ratio for g filter stack detection. |
| gExpPhi | degrees | REAL | 4 | -999 | Major axis position angle, phi, of exponential fit for g filter stack detection. |
| gExpPhiErr | degrees | REAL | 4 | -999 | Error in major axis position angle of exponential fit for g filter stack detection. |
| gExpRa | degrees | FLOAT | 8 | -999 | Right ascension of exponential fit center for g filter stack detection. |
| gExpDec | degrees | FLOAT | 8 | -999 | Declination of exponential fit center for g filter stack detection. |
| gExpRaErr | arcsec | REAL | 4 | -999 | Error in right ascension of exponential fit center for g filter stack detection. |
| gExpDecErr | arcsec | REAL | 4 | -999 | Error in declination of exponential fit center for g filter stack detection. |
| gExpChisq | dimensionless | REAL | 4 | -999 | Exponential fit reduced chi squared 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. |
| rExpRadius | arcsec | REAL | 4 | -999 | Exponential fit radius for r filter stack detection. |
| rExpRadiusErr | arcsec | REAL | 4 | -999 | Error in exponential fit radius for r filter stack detection. |
| rExpMag | AB magnitudes | REAL | 4 | -999 | Exponential fit magnitude for r filter stack detection. |
| rExpMagErr | AB magnitudes | REAL | 4 | -999 | Error in exponential fit magnitude for r filter stack detection. |
| rExpAb | dimensionless | REAL | 4 | -999 | Exponential fit axis ratio for r filter stack detection. |
| rExpAbErr | dimensionless | REAL | 4 | -999 | Error in exponential fit axis ratio for r filter stack detection. |
| rExpPhi | degrees | REAL | 4 | -999 | Major axis position angle, phi, of exponential fit for r filter stack detection. |
| rExpPhiErr | degrees | REAL | 4 | -999 | Error in major axis position angle of exponential fit for r filter stack detection. |
| rExpRa | degrees | FLOAT | 8 | -999 | Right ascension of exponential fit center for r filter stack detection. |
| rExpDec | degrees | FLOAT | 8 | -999 | Declination of exponential fit center for r filter stack detection. |
| rExpRaErr | arcsec | REAL | 4 | -999 | Error in right ascension of exponential fit center for r filter stack detection. |
| rExpDecErr | arcsec | REAL | 4 | -999 | Error in declination of exponential fit center for r filter stack detection. |
| rExpChisq | dimensionless | REAL | 4 | -999 | Exponential fit reduced chi squared 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. |
| iExpRadius | arcsec | REAL | 4 | -999 | Exponential fit radius for i filter stack detection. |
| iExpRadiusErr | arcsec | REAL | 4 | -999 | Error in exponential fit radius for i filter stack detection. |
| iExpMag | AB magnitudes | REAL | 4 | -999 | Exponential fit magnitude for i filter stack detection. |
| iExpMagErr | AB magnitudes | REAL | 4 | -999 | Error in exponential fit magnitude for i filter stack detection. |
| iExpAb | dimensionless | REAL | 4 | -999 | Exponential fit axis ratio for i filter stack detection. |
| iExpAbErr | dimensionless | REAL | 4 | -999 | Error in exponential fit axis ratio for i filter stack detection. |
| iExpPhi | degrees | REAL | 4 | -999 | Major axis position angle, phi, of exponential fit for i filter stack detection. |
| iExpPhiErr | degrees | REAL | 4 | -999 | Error in major axis position angle of exponential fit for i filter stack detection. |
| iExpRa | degrees | FLOAT | 8 | -999 | Right ascension of exponential fit center for i filter stack detection. |
| iExpDec | degrees | FLOAT | 8 | -999 | Declination of exponential fit center for i filter stack detection. |
| iExpRaErr | arcsec | REAL | 4 | -999 | Error in right ascension of exponential fit center for i filter stack detection. |
| iExpDecErr | arcsec | REAL | 4 | -999 | Error in declination of exponential fit center for i filter stack detection. |
| iExpChisq | dimensionless | REAL | 4 | -999 | Exponential fit reduced chi squared 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. |
| zExpRadius | arcsec | REAL | 4 | -999 | Exponential fit radius for z filter stack detection. |
| zExpRadiusErr | arcsec | REAL | 4 | -999 | Error in exponential fit radius for z filter stack detection. |
| zExpMag | AB magnitudes | REAL | 4 | -999 | Exponential fit magnitude for z filter stack detection. |
| zExpMagErr | AB magnitudes | REAL | 4 | -999 | Error in exponential fit magnitude for z filter stack detection. |
| zExpAb | dimensionless | REAL | 4 | -999 | Exponential fit axis ratio for z filter stack detection. |
| zExpAbErr | dimensionless | REAL | 4 | -999 | Error in exponential fit axis ratio for z filter stack detection. |
| zExpPhi | degrees | REAL | 4 | -999 | Major axis position angle, phi, of exponential fit for z filter stack detection. |
| zExpPhiErr | degrees | REAL | 4 | -999 | Error in major axis position angle of exponential fit for z filter stack detection. |
| zExpRa | degrees | FLOAT | 8 | -999 | Right ascension of exponential fit center for z filter stack detection. |
| zExpDec | degrees | FLOAT | 8 | -999 | Declination of exponential fit center for z filter stack detection. |
| zExpRaErr | arcsec | REAL | 4 | -999 | Error in right ascension of exponential fit center for z filter stack detection. |
| zExpDecErr | arcsec | REAL | 4 | -999 | Error in declination of exponential fit center for z filter stack detection. |
| zExpChisq | dimensionless | REAL | 4 | -999 | Exponential fit reduced chi squared 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. |
| yExpRadius | arcsec | REAL | 4 | -999 | Exponential fit radius for y filter stack detection. |
| yExpRadiusErr | arcsec | REAL | 4 | -999 | Error in exponential fit radius for y filter stack detection. |
| yExpMag | AB magnitudes | REAL | 4 | -999 | Exponential fit magnitude for y filter stack detection. |
| yExpMagErr | AB magnitudes | REAL | 4 | -999 | Error in exponential fit magnitude for y filter stack detection. |
| yExpAb | dimensionless | REAL | 4 | -999 | Exponential fit axis ratio for y filter stack detection. |
| yExpAbErr | dimensionless | REAL | 4 | -999 | Error in exponential fit axis ratio for y filter stack detection. |
| yExpPhi | degrees | REAL | 4 | -999 | Major axis position angle, phi, of exponential fit for y filter stack detection. |
| yExpPhiErr | degrees | REAL | 4 | -999 | Error in major axis position angle of exponential fit for y filter stack detection. |
| yExpRa | degrees | FLOAT | 8 | -999 | Right ascension of exponential fit center for y filter stack detection. |
| yExpDec | degrees | FLOAT | 8 | -999 | Declination of exponential fit center for y filter stack detection. |
| yExpRaErr | arcsec | REAL | 4 | -999 | Error in right ascension of exponential fit center for y filter stack detection. |
| yExpDecErr | arcsec | REAL | 4 | -999 | Error in declination of exponential fit center for y filter stack detection. |
| yExpChisq | dimensionless | REAL | 4 | -999 | Exponential fit reduced chi squared for y filter stack detection. |
