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 StackModelFitSer joined by objID column.
NameUnitData TypeSizeDefault ValueDescription
objNamedimensionlessVARCHAR(32)32NAIAU name for this object.
objAltName1dimensionlessVARCHAR(32)32NAAlternate name for this object.
objAltName2dimensionlessVARCHAR(32)32
Altername name for this object.
objAltName3dimensionlessVARCHAR(32)32
Altername name for this object.
objIDdimensionlessBIGINT8NAUnique object identifier.
uniquePspsOBiddimensionlessBIGINT8NAUnique internal PSPS object identifier.
ippObjIDdimensionlessBIGINT8NAIPP internal object identifier.
surveyIDdimensionlessTINYINT1NASurvey identifier. Details in the Survey table.
htmIDdimensionlessBIGINT8NAHierarchical triangular mesh (Szalay 2007) index.
zoneIDdimensionlessINT4NALocal zone index, found by dividing the sky into bands of declination 1/2 arcminute in height: zoneID = floor((90 + declination)/0.0083333).
tessIDdimensionlessTINYINT10Tessellation identifier. Details in the TessellationType table.
projectionIDdimensionlessSMALLINT2-1Projection cell identifier.
skyCellIDdimensionlessTINYINT1255Skycell region identifier.
randomIDdimensionlessFLOAT8NARandom value drawn from the interval between zero and one.
batchIDdimensionlessBIGINT8NAInternal database batch identifier.
dvoRegionIDdimensionlessINT4-1Internal DVO region identifier.
processingVersiondimensionlessTINYINT1NAData release version.
objInfoFlagdimensionlessINT40Information flag bitmask indicating details of the photometry. Values listed in ObjectInfoFlags.
qualityFlagdimensionlessTINYINT10Subset of objInfoFlag denoting whether this object is real or a likely false positive. Values listed in ObjectQualityFlags.
raStackdegreesFLOAT8-999Right ascension from stack detections, weighted mean value across filters, in equinox J2000. See StackObjectThin for stack epoch information.
decStackdegreesFLOAT8-999Declination from stack detections, weighted mean value across filters, in equinox J2000. See StackObjectThin for stack epoch information.
raStackErrarcsecREAL4-999Right ascension standard deviation from stack detections.
decStackErrarcsecREAL4-999Declination standard deviation from stack detections.
raMeandegreesFLOAT8-999Right ascension from single epoch detections (weighted mean) in equinox J2000 at the mean epoch given by epochMean.
decMeandegreesFLOAT8-999Declination from single epoch detections (weighted mean) in equinox J2000 at the mean epoch given by epochMean.
raMeanErrarcsecREAL4-999Right ascension standard deviation from single epoch detections.
decMeanErrarcsecREAL4-999Declination standard deviation from single epoch detections.
epochMeandaysFLOAT8-999Modified Julian Date of the mean epoch corresponding to raMean, decMean (equinox J2000).
posMeanChisqdimensionlessREAL4-999Reduced chi squared value of mean position.
cxdimensionlessFLOAT8NACartesian x on a unit sphere.
cydimensionlessFLOAT8NACartesian y on a unit sphere.
czdimensionlessFLOAT8NACartesian z on a unit sphere.
lambdadegreesFLOAT8-999Ecliptic longitude.
betadegreesFLOAT8-999Ecliptic latitude.
ldegreesFLOAT8-999Galactic longitude.
bdegreesFLOAT8-999Galactic latitude.
nStackObjectRowsdimensionlessSMALLINT2-999Number of independent StackObjectThin rows associated with this object.
nStackDetectionsdimensionlessSMALLINT2-999Number of stack detections.
nDetectionsdimensionlessSMALLINT2-999Number of single epoch detections in all filters.
ngdimensionlessSMALLINT2-999Number of single epoch detections in g filter.
nrdimensionlessSMALLINT2-999Number of single epoch detections in r filter.
nidimensionlessSMALLINT2-999Number of single epoch detections in i filter.
nzdimensionlessSMALLINT2-999Number of single epoch detections in z filter.
nydimensionlessSMALLINT2-999Number of single epoch detections in y filter.
primaryDetectiondimensionlessTINYINT1255Identifies if this row is the primary stack detection.
bestDetectiondimensionlessTINYINT1255Identifies if this row is the best detection.
gippDetectIDdimensionlessBIGINT8NAIPP internal detection identifier.
gstackDetectIDdimensionlessBIGINT8NAUnique stack detection identifier.
gstackImageIDdimensionlessBIGINT8NAUnique stack identifier for g filter detection.
gSerRadiusarcsecREAL4-999Sersic (1963) fit radius for g filter stack detection.
gSerRadiusErrarcsecREAL4-999Error in Sersic (1963) fit radius for g filter stack detection.
gSerMagAB magnitudesREAL4-999Sersic (1963) fit magnitude for g filter stack detection.
gSerMagErrAB magnitudesREAL4-999Error in Sersic (1963) fit magnitude for g filter stack detection.
gSerAbdimensionlessREAL4-999Sersic (1963) fit axis ratio for g filter stack detection.
gSerAbErrdimensionlessREAL4-999Error in Sersic (1963) fit axis ratio for g filter stack detection.
gSerNudimensionlessREAL4-999Sersic (1963) fit index for g filter stack detection.
gSerNuErrdimensionlessREAL4-999Error in Sersic (1963) fit index for g filter stack detection.
gSerPhidegreesREAL4-999Major axis position angle, phi, of Sersic (1963) fit for g filter stack detection.
gSerPhiErrdegreesREAL4-999Error in major axis position angle of Sersic (1963) fit for g filter stack detection.
gSerRadegreesFLOAT8-999Right ascension of Sersic (1963) fit center for g filter stack detection.
gSerDecdegreesFLOAT8-999Declination of Sersic (1963) fit center for g filter stack detection.
gSerRaErrarcsecREAL4-999Error in right ascension of Sersic (1963) fit center for g filter stack detection.
gSerDecErrarcsecREAL4-999Error in declination of Sersic (1963) fit center for g filter stack detection.
gSerChisqdimensionlessREAL4-999Sersic (1963) fit reduced chi squared for g filter stack detection.
rippDetectIDdimensionlessBIGINT8NAIPP internal detection identifier.
rstackDetectIDdimensionlessBIGINT8NAUnique stack detection identifier.
rstackImageIDdimensionlessBIGINT8NAUnique stack identifier for r filter detection.
rSerRadiusarcsecREAL4-999Sersic (1963) fit radius for r filter stack detection.
rSerRadiusErrarcsecREAL4-999Error in Sersic (1963) fit radius for r filter stack detection.
rSerMagAB magnitudesREAL4-999Sersic (1963) fit magnitude for r filter stack detection.
rSerMagErrAB magnitudesREAL4-999Error in Sersic (1963) fit magnitude for r filter stack detection.
rSerAbdimensionlessREAL4-999Sersic (1963) fit axis ratio for r filter stack detection.
rSerAbErrdimensionlessREAL4-999Error in Sersic (1963) fit axis ratio for r filter stack detection.
rSerNudimensionlessREAL4-999Sersic (1963) fit index for r filter stack detection.
rSerNuErrdimensionlessREAL4-999Error in Sersic (1963) fit index for r filter stack detection.
rSerPhidegreesREAL4-999Major axis position angle, phi, of Sersic (1963) fit for r filter stack detection.
rSerPhiErrdegreesREAL4-999Error in major axis position angle of Sersic (1963) fit for r filter stack detection.
rSerRadegreesFLOAT8-999Right ascension of Sersic (1963) fit center for r filter stack detection.
rSerDecdegreesFLOAT8-999Declination of Sersic (1963) fit center for r filter stack detection.
rSerRaErrarcsecREAL4-999Error in right ascension of Sersic (1963) fit center for r filter stack detection.
rSerDecErrarcsecREAL4-999Error in declination of Sersic (1963) fit center for r filter stack detection.
rSerChisqdimensionlessREAL4-999Sersic (1963) fit reduced chi squared for r filter stack detection.
iippDetectIDdimensionlessBIGINT8NAIPP internal detection identifier.
istackDetectIDdimensionlessBIGINT8NAUnique stack detection identifier.
istackImageIDdimensionlessBIGINT8NAUnique stack identifier for i filter detection.
iSerRadiusarcsecREAL4-999Sersic (1963) fit radius for i filter stack detection.
iSerRadiusErrarcsecREAL4-999Error in Sersic (1963) fit radius for i filter stack detection.
iSerMagAB magnitudesREAL4-999Sersic (1963) fit magnitude for i filter stack detection.
iSerMagErrAB magnitudesREAL4-999Error in Sersic (1963) fit magnitude for i filter stack detection.
iSerAbdimensionlessREAL4-999Sersic (1963) fit axis ratio for i filter stack detection.
iSerAbErrdimensionlessREAL4-999Error in Sersic (1963) fit axis ratio for i filter stack detection.
iSerNudimensionlessREAL4-999Sersic (1963) fit index for i filter stack detection.
iSerNuErrdimensionlessREAL4-999Error in Sersic (1963) fit index for i filter stack detection.
iSerPhidegreesREAL4-999Major axis position angle, phi, of Sersic (1963) fit for i filter stack detection.
iSerPhiErrdegreesREAL4-999Error in major axis position angle of Sersic (1963) fit for i filter stack detection.
iSerRadegreesFLOAT8-999Right ascension of Sersic (1963) fit center for i filter stack detection.
iSerDecdegreesFLOAT8-999Declination of Sersic (1963) fit center for i filter stack detection.
iSerRaErrarcsecREAL4-999Error in right ascension of Sersic (1963) fit center for i filter stack detection.
iSerDecErrarcsecREAL4-999Error in declination of Sersic (1963) fit center for i filter stack detection.
iSerChisqdimensionlessREAL4-999Sersic (1963) fit reduced chi squared for i filter stack detection.
zippDetectIDdimensionlessBIGINT8NAIPP internal detection identifier.
zstackDetectIDdimensionlessBIGINT8NAUnique stack detection identifier.
zstackImageIDdimensionlessBIGINT8NAUnique stack identifier for z filter detection.
zSerRadiusarcsecREAL4-999Sersic (1963) fit radius for z filter stack detection.
zSerRadiusErrarcsecREAL4-999Error in Sersic (1963) fit radius for z filter stack detection.
zSerMagAB magnitudesREAL4-999Sersic (1963) fit magnitude for z filter stack detection.
zSerMagErrAB magnitudesREAL4-999Error in Sersic (1963) fit magnitude for z filter stack detection.
zSerAbdimensionlessREAL4-999Sersic (1963) fit axis ratio for z filter stack detection.
zSerAbErrdimensionlessREAL4-999Error in Sersic (1963) fit axis ratio for z filter stack detection.
zSerNudimensionlessREAL4-999Sersic (1963) fit index for z filter stack detection.
zSerNuErrdimensionlessREAL4-999Error in Sersic (1963) fit index for z filter stack detection.
zSerPhidegreesREAL4-999Major axis position angle, phi, of Sersic (1963) fit for z filter stack detection.
zSerPhiErrdegreesREAL4-999Error in major axis position angle of Sersic (1963) fit for z filter stack detection.
zSerRadegreesFLOAT8-999Right ascension of Sersic (1963) fit center for z filter stack detection.
zSerDecdegreesFLOAT8-999Declination of Sersic (1963) fit center for z filter stack detection.
zSerRaErrarcsecREAL4-999Error in right ascension of Sersic (1963) fit center for z filter stack detection.
zSerDecErrarcsecREAL4-999Error in declination of Sersic (1963) fit center for z filter stack detection.
zSerChisqdimensionlessREAL4-999Sersic (1963) fit reduced chi squared for z filter stack detection.
yippDetectIDdimensionlessBIGINT8NAIPP internal detection identifier.
ystackDetectIDdimensionlessBIGINT8NAUnique stack detection identifier.
ystackImageIDdimensionlessBIGINT8NAUnique stack identifier for y filter detection.
ySerRadiusarcsecREAL4-999Sersic (1963) fit radius for y filter stack detection.
ySerRadiusErrarcsecREAL4-999Error in Sersic (1963) fit radius for y filter stack detection.
ySerMagAB magnitudesREAL4-999Sersic (1963) fit magnitude for y filter stack detection.
ySerMagErrAB magnitudesREAL4-999Error in Sersic (1963) fit magnitude for y filter stack detection.
ySerAbdimensionlessREAL4-999Sersic (1963) fit axis ratio for y filter stack detection.
ySerAbErrdimensionlessREAL4-999Error in Sersic (1963) fit axis ratio for y filter stack detection.
ySerNudimensionlessREAL4-999Sersic (1963) fit index for y filter stack detection.
ySerNuErrdimensionlessREAL4-999Error in Sersic (1963) fit index for y filter stack detection.
ySerPhidegreesREAL4-999Major axis position angle, phi, of Sersic (1963) fit for y filter stack detection.
ySerPhiErrdegreesREAL4-999Error in major axis position angle of Sersic (1963) fit for y filter stack detection.
ySerRadegreesFLOAT8-999Right ascension of Sersic (1963) fit center for y filter stack detection.
ySerDecdegreesFLOAT8-999Declination of Sersic (1963) fit center for y filter stack detection.
ySerRaErrarcsecREAL4-999Error in right ascension of Sersic (1963) fit center for y filter stack detection.
ySerDecErrarcsecREAL4-999Error in declination of Sersic (1963) fit center for y filter stack detection.
ySerChisqdimensionlessREAL4-999Sersic (1963) fit reduced chi squared for y filter stack detection.

  • No labels