TABLE  ObjectThin

Contains the positional information for objects in a number of coordinate systems.

The objects associate single epoch detections and the stacked
detections within a one arcsecond radius. The mean position from the
single epoch data is used as the basis for coordinates when available, or
the position of an object in the stack when it is not. The right ascension
and declination for both the stack and single epoch mean is provided. The
number of detections in each filter from single epoch data is listed,
along with which filters the object has a stack detection.

Required constraints:
  • Primary key is (objID,uniquePspsOBid)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
objNamevarchar32 IAU name for this object. meta.id
objNameHMSvarchar32 Alternate Pan-STARRS name for this object. meta.id
objAltName1varchar32 Alternate name for this object. meta.id
objAltName2varchar32 Altername name for this object. meta.id
objAltName3varchar32 Altername name for this object. meta.id
objPopularNamevarchar140 Well known name for this object. meta.id
objIDbigint8 Unique object identifier. meta.id;meta.main
uniquePspsOBidbigint8 Unique internal PSPS object identifier. meta.id
ippObjIDbigint8 IPP internal object identifier. meta.id
surveyIDtinyint1 Survey identifier. Details in the Survey table. meta.id
htmIDbigint8 Hierarchical triangular mesh (Szalay 2007) index. pos.HTM
zoneIDint4 Local zone index, found by dividing the sky into bands of declination 1/2 arcminute in height: zoneID = floor((90 + declination)/0.0083333). meta.id
tessIDtinyint1 Tessellation identifier. Details in the TessellationType table.0meta.id
projectionIDsmallint2 Projection cell identifier.-1meta.id
skyCellIDtinyint1 Skycell region identifier.255meta.id
randomIDfloat8 Random value drawn from the interval between zero and one. meta.id
batchIDbigint8 Internal database batch identifier. meta.id
dvoRegionIDint4 Internal DVO region identifier.-1meta.id
processingVersiontinyint1 Data release version. meta.id;meta.software
objInfoFlagint4 Information flag bitmask indicating details of the photometry. Values listed in ObjectInfoFlags0meta.code
qualityFlagtinyint1 Subset of objInfoFlag denoting whether this object is real or a likely false positive. Values listed in ObjectQualityFlags0meta.code.qual
raStackfloat8degreesRight ascension from stack detections, weighted mean value across filters, in equinox J2000. See StackObjectThin for stack epoch information.-999pos.eq.ra
decStackfloat8degreesDeclination from stack detections, weighted mean value across filters, in equinox J2000. See StackObjectThin for stack epoch information.-999pos.eq.dec
raStackErrreal4arcsecRight ascension standard deviation from stack detections.-999stat.error
decStackErrreal4arcsecDeclination standard deviation from stack detections.-999stat.error
raMeanfloat8degreesRight ascension from single epoch detections (weighted mean) in equinox J2000 at the mean epoch given by epochMean.-999pos.eq.ra
decMeanfloat8degreesDeclination from single epoch detections (weighted mean) in equinox J2000 at the mean epoch given by epochMean.-999pos.eq.dec
raMeanErrreal4arcsecRight ascension standard deviation from single epoch detections.-999stat.error
decMeanErrreal4arcsecDeclination standard deviation from single epoch detections.-999stat.error
epochMeanfloat8daysModified Julian Date of the mean epoch corresponding to raMean, decMean (equinox J2000). Note that Gaia DR1 data is sometimes included in the mean position; in those cases, the epochMean value is near the Gaia DR1 epoch 2015.5 = MJD 15023. As a result, epochMean is not necessarily near the mean value of the PS1 measurement dates.-999 
posMeanChisqreal4 Reduced chi squared value of mean position.-999stat.stdev
cxfloat8 Cartesian x on a unit sphere. pos.cartesian.x;pos.eq
cyfloat8 Cartesian y on a unit sphere. pos.cartesian.y;pos.eq
czfloat8 Cartesian z on a unit sphere. pos.cartesian.y;pos.eq
lambdafloat8degreesEcliptic longitude.-999 
betafloat8degreesEcliptic latitude.-999 
lfloat8degreesGalactic longitude.-999 
bfloat8degreesGalactic latitude.-999 
nStackObjectRowssmallint2 Number of independent StackObjectThin rows associated with this object.-999 
nStackDetectionssmallint2 Number of stack detections.-999 
nDetectionssmallint2 Number of single epoch detections in all filters.-999 
ngsmallint2 Number of single epoch detections in g filter.-999 
nrsmallint2 Number of single epoch detections in r filter.-999 
nismallint2 Number of single epoch detections in i filter.-999 
nzsmallint2 Number of single epoch detections in z filter.-999 
nysmallint2 Number of single epoch detections in y filter.-999 
Total length499