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: -- DiffDetObject join DiffDetection joined by diffobjID column.
NameUnitData TypeSizeDefault ValueDescription
diffObjNamedimensionlessVARCHAR(32)32NAIAU name for this object.
diffObjAltName1dimensionlessVARCHAR(32)32
Altername name for this object.
diffObjAltName2dimensionlessVARCHAR(32)32
Altername name for this object.
diffObjAltName3dimensionlessVARCHAR(32)32
Altername name for this object.
diffObjIDdimensionlessBIGINT8NAUnique difference object identifier.
uniquePspsDOiddimensionlessBIGINT8NAUnique internal PSPS difference 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).
randomDiffObjIDdimensionlessFLOAT8NARandom value drawn from the interval between zero and one.
batchIDdimensionlessBIGINT8NAInternal database batch identifier.
dvoRegionIDdimensionlessINT4-1Internal DVO region identifier.
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.
radegreesFLOAT8-999Right ascension.
dec




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.
gQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from g filter detections.
rQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from r filter detections.
iQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from i filter detections.
zQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from z filter detections.
yQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from y filter detections.
processingVersiondimensionlessTINYINT1NAData release version.
nDetectionsdimensionlessSMALLINT2-999Number of difference detections in all filters.
ngdimensionlessSMALLINT2-999Number of difference detections in g filter.
nrdimensionlessSMALLINT2-999Number of difference detections in r filter.
nidimensionlessSMALLINT2-999Number of difference detections in i filter.
nzdimensionlessSMALLINT2-999Number of difference detections in z filter.
nydimensionlessSMALLINT2-999Number of difference detections in y filter.
fromPosImagedimensionlessTINYINT1NADetection is from positive image (if 1) or negative image (if 0).
filterIDdimensionlessTINYINT1NAFilter identifier. Details in the Filter table.
tessIDdimensionlessTINYINT10Tessellation identifier. Details in the TessellationType table.
projectionIDdimensionlessSMALLINT2-1Projection cell identifier.
skyCellIDdimensionlessTINYINT1255Skycell region identifier.
obsTimedaysFLOAT8-999Modified Julian Date at the midpoint of the observation. Note these are international atomic time rather than UTC, so if you want UTC times you will need to add 34 or 35 seconds to correct for leap seconds.
xPossky pixelsREAL4-999PSF x center location.
yPossky pixelsREAL4-999PSF y center location.
xPosErrsky pixelsREAL4-999Error in PSF x center location.
yPosErrsky pixelsREAL4-999Error in PSF y center location.
pltScalearcsec/pixelREAL4-999Local plate scale at this location.
posAngledegreesREAL4-999Position angle (sky-to-chip) at this location.
raErrarcsecREAL4-999Right ascension error.
decErrarcsecREAL4-999Declination error.
zpmagnitudesREAL40Photometric zeropoint. Necessary for converting listed fluxes and magnitudes back to measured ADU counts.
telluricExtmagnitudesREAL4NAEstimated Telluric extinction due to non-photometric observing conditions. Necessary for converting listed fluxes and magnitudes back to measured ADU counts.
expTimesecondsREAL4-999Exposure time of the positive single-epoch image. Necessary for converting listed fluxes and magnitudes back to measured ADU counts.
airMassdimensionlessREAL40Airmass at midpoint of the exposure. Necessary for converting listed fluxes and magnitudes back to measured ADU counts.
DpsfFluxJanskysREAL4-999Flux from PSF fit.
DpsfFluxErrJanskysREAL4-999Error in PSF flux.
xPosChipraw pixelsREAL4-999PSF x position in original chip pixels.
yPosChipraw pixelsREAL4-999PSF y position in original chip pixels.
ccdIDdimensionslessSMALLINT2-999OTA identifier of original chip (see ImageMeta).
DpsfMajorFWHMarcsecREAL4-999PSF major axis FWHM.
DpsfMinorFWHMarcsecREAL4-999PSF minor axis FWHM.
DpsfThetadegreesREAL4-999PSF major axis orientation.
DpsfCoredimensionlessREAL4-999PSF core parameter k, where F = F0 / (1 + k r^2 + r^3.33).
DpsfQfdimensionlessREAL4-999PSF coverage factor.
DpsfQfPerfectdimensionlessREAL4-999PSF-weighted fraction of pixels totally unmasked.
DpsfChiSqdimensionlessREAL4-999Reduced chi squared value of the PSF model fit.
DpsfLikelihooddimensionlessREAL4-999Likelihood that this detection is best fit by a PSF.
DmomentXXarcsec^2REAL4-999Second moment M_xx.
DmomentXYarcsec^2REAL4-999Second moment M_xy.
DmomentYYarcsec^2REAL4-999Second moment M_yy.
DmomentR1arcsecREAL4-999First radial moment.
DmomentRHarcsec^0.5REAL4-999Half radial moment (r^0.5 weighting).
DapFluxJanskysREAL4-999Aperture flux.
DapFluxErrJanskysREAL4-999Error in aperture flux.
DapFillFdimensionlessREAL4-999Aperture fill factor.
DkronFluxJanskysREAL4-999Kron (1980) flux.
DkronFluxErrJanskysREAL4-999Error in Kron (1980) flux.
DkronRadarcsecREAL4-999Kron (1980) radius.
diffNPossky pixelsINT4-999Number of difference pixels within the aperture that are positive.
diffFPosRatiodimensionlessREAL4-999Ratio of the sum of positive flux pixel values to the sum of the absolute value of all unmasked pixel within the aperture.
diffNPosRatiodimensionlessREAL4-999Ratio of the number of positive flux pixels to the number of unmasked pixels within the aperture.
diffNPosMaskdimensionlessREAL4-999Ratio of the number of positive flux pixels to the number of positive or masked pixels within the aperture.
diffNPosAlldimensionlessREAL4-999Ratio of the number of positive flux pixels to the total number of all pixels within the aperture.
diffPosDistsky pixelsREAL4-999Distance to matching source in positive image.
diffNegDistsky pixelsREAL4-999Distance to matching source in negative image.
diffPosSNdimensionlessREAL4-999Signal to noise of matching source in positive image.
diffNegSNdimensionlessREAL4-999Signal to noise of matching source in negative image.
DskyJanskys/arcsec^2REAL4-999Background sky level.
DskyErrJanskys/arcsec^2REAL4-999Error in background sky level.
DinfoFlagdimensionlessBIGINT80Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags.
DinfoFlag2dimensionlessINT40Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags2.
DinfoFlag3dimensionlessINT40Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags3.

  • No labels