Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This page describes a "View", which is a database table created by joining other tables.

Excerpt


Description: -- ObjectThin join Detection 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.
gQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from g filter detections.
gMeanPSFMagAB magnitudesREAL4-999Mean PSF magnitude from g filter detections.
gMeanPSFMagErrAB magnitudesREAL4-999Error in mean PSF magnitude from g filter detections.
gMeanPSFMagStdAB magnitudesREAL4-999Standard deviation of PSF magnitudes from g filter detections.
gMeanPSFMagNptdimensionlessSMALLINT2-999Number of measurements included in mean PSF magnitude from g filter detections.
gMeanPSFMagMinAB magnitudesREAL4-999Minimum PSF magnitude from g filter detections.
gMeanPSFMagMaxAB magnitudesREAL4-999Maximum PSF magnitude from g filter detections.
gMeanKronMagAB magnitudesREAL4-999Mean Kron (1980) magnitude from g filter detections.
gMeanKronMagErrAB magnitudesREAL4-999Error in mean Kron (1980) magnitude from g filter detections.
gMeanKronMagStdAB magnitudesREAL4-999Standard deviation of Kron (1980) magnitudes from g filter detections.
gMeanKronMagNptdimensionlessSMALLINT2-999Number of measurements included in mean Kron (1980) magnitude from g filter detections.
gMeanApMagAB magnitudesREAL4-999Mean aperture magnitude from g filter detections.
gMeanApMagErrAB magnitudesREAL4-999Error in mean aperture magnitude from g filter detections.
gMeanApMagStdAB magnitudesREAL4-999Standard deviation of aperture magnitudes from g filter detections.
gMeanApMagNptdimensionlessSMALLINT2-999Number of measurements included in mean aperture magnitude from g filter detections.
gFlagsdimensionlessINT40Information flag bitmask for mean object from g filter detections. Values listed in ObjectFilterFlags.
rQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from r filter detections.
rMeanPSFMagAB magnitudesREAL4-999Mean PSF magnitude from r filter detections.
rMeanPSFMagErrAB magnitudesREAL4-999Error in mean PSF magnitude from r filter detections.
rMeanPSFMagStdAB magnitudesREAL4-999Standard deviation of PSF magnitudes from r filter detections.
rMeanPSFMagNptdimensionlessSMALLINT2-999Number of measurements included in mean PSF magnitude from r filter detections.
rMeanPSFMagMinAB magnitudesREAL4-999Minimum PSF magnitude from r filter detections.
rMeanPSFMagMaxAB magnitudesREAL4-999Maximum PSF magnitude from r filter detections.
rMeanKronMagAB magnitudesREAL4-999Mean Kron (1980) magnitude from r filter detections.
rMeanKronMagErrAB magnitudesREAL4-999Error in mean Kron (1980) magnitude from r filter detections.
rMeanKronMagStdAB magnitudesREAL4-999Standard deviation of Kron (1980) magnitudes from r filter detections.
rMeanKronMagNptdimensionlessSMALLINT2-999Number of measurements included in mean Kron (1980) magnitude from r filter detections.
rMeanApMagAB magnitudesREAL4-999Mean aperture magnitude from r filter detections.
rMeanApMagErrAB magnitudesREAL4-999Error in mean aperture magnitude from r filter detections.
rMeanApMagStdAB magnitudesREAL4-999Standard deviation of aperture magnitudes from r filter detections.
rMeanApMagNptdimensionlessSMALLINT2-999Number of measurements included in mean aperture magnitude from r filter detections.
rFlagsdimensionlessINT40Information flag bitmask for mean object from r filter detections. Values listed in ObjectFilterFlags.
iQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from i filter detections.
iMeanPSFMagAB magnitudesREAL4-999Mean PSF magnitude from i filter detections.
iMeanPSFMagErrAB magnitudesREAL4-999Error in mean PSF magnitude from i filter detections.
iMeanPSFMagStdAB magnitudesREAL4-999Standard deviation of PSF magnitudes from i filter detections.
iMeanPSFMagNptdimensionlessSMALLINT2-999Number of measurements included in mean PSF magnitude from i filter detections.
iMeanPSFMagMinAB magnitudesREAL4-999Minimum PSF magnitude from i filter detections.
iMeanPSFMagMaxAB magnitudesREAL4-999Maximum PSF magnitude from i filter detections.
iMeanKronMagAB magnitudesREAL4-999Mean Kron (1980) magnitude from i filter detections.
iMeanKronMagErrAB magnitudesREAL4-999Error in mean Kron (1980) magnitude from i filter detections.
iMeanKronMagStdAB magnitudesREAL4-999Standard deviation of Kron (1980) magnitudes from i filter detections.
iMeanKronMagNptdimensionlessSMALLINT2-999Number of measurements included in mean Kron (1980) magnitude from i filter detections.
iMeanApMagAB magnitudesREAL4-999Mean aperture magnitude from i filter detections.
iMeanApMagErrAB magnitudesREAL4-999Error in mean aperture magnitude from i filter detections.
iMeanApMagStdAB magnitudesREAL4-999Standard deviation of aperture magnitudes from i filter detections.
iMeanApMagNptdimensionlessSMALLINT2-999Number of measurements included in mean aperture magnitude from i filter detections.
iFlagsdimensionlessINT40Information flag bitmask for mean object from i filter detections. Values listed in ObjectFilterFlags.
zQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from z filter detections.
zMeanPSFMagAB magnitudesREAL4-999Mean PSF magnitude from z filter detections.
zMeanPSFMagErrAB magnitudesREAL4-999Error in mean PSF magnitude from z filter detections.
zMeanPSFMagStdAB magnitudesREAL4-999Standard deviation of PSF magnitudes from z filter detections.
zMeanPSFMagNptdimensionlessSMALLINT2-999Number of measurements included in mean PSF magnitude from z filter detections.
zMeanPSFMagMinAB magnitudesREAL4-999Minimum PSF magnitude from z filter detections.
zMeanPSFMagMaxAB magnitudesREAL4-999Maximum PSF magnitude from z filter detections.
zMeanKronMagAB magnitudesREAL4-999Mean Kron (1980) magnitude from z filter detections.
zMeanKronMagErrAB magnitudesREAL4-999Error in mean Kron (1980) magnitude from z filter detections.
zMeanKronMagStdAB magnitudesREAL4-999Standard deviation of Kron (1980) magnitudes from z filter detections.
zMeanKronMagNptdimensionlessSMALLINT2-999Number of measurements included in mean Kron (1980) magnitude from z filter detections.
zMeanApMagAB magnitudesREAL4-999Mean aperture magnitude from z filter detections.
zMeanApMagErrAB magnitudesREAL4-999Error in mean aperture magnitude from z filter detections.
zMeanApMagStdAB magnitudesREAL4-999Standard deviation of aperture magnitudes from z filter detections.
zMeanApMagNptdimensionlessSMALLINT2-999Number of measurements included in mean aperture magnitude from z filter detections.
zFlagsdimensionlessINT40Information flag bitmask for mean object from z filter detections. Values listed in ObjectFilterFlags.
yQfPerfectdimensionlessREAL4-999Maximum PSF weighted fraction of pixels totally unmasked from y filter detections.
yMeanPSFMagAB magnitudesREAL4-999Mean PSF magnitude from y filter detections.
yMeanPSFMagErrAB magnitudesREAL4-999Error in mean PSF magnitude from y filter detections.
yMeanPSFMagStdAB magnitudesREAL4-999Standard deviation of PSF magnitudes from y filter detections.
yMeanPSFMagNptdimensionlessSMALLINT2-999Number of measurements included in mean PSF magnitude from y filter detections.
yMeanPSFMagMinAB magnitudesREAL4-999Minimum PSF magnitude from y filter detections.
yMeanPSFMagMaxAB magnitudesREAL4-999Maximum PSF magnitude from y filter detections.
yMeanKronMagAB magnitudesREAL4-999Mean Kron (1980) magnitude from y filter detections.
yMeanKronMagErrAB magnitudesREAL4-999Error in mean Kron (1980) magnitude from y filter detections.
yMeanKronMagStdAB magnitudesREAL4-999Standard deviation of Kron (1980) magnitudes from y filter detections.
yMeanKronMagNptdimensionlessSMALLINT2-999Number of measurements included in mean Kron (1980) magnitude from y filter detections.
yMeanApMagAB magnitudesREAL4-999Mean aperture magnitude from y filter detections.
yMeanApMagErrAB magnitudesREAL4-999Error in mean aperture magnitude from y filter detections.
yMeanApMagStdAB magnitudesREAL4-999Standard deviation of aperture magnitudes from y filter detections.
yMeanApMagNptdimensionlessSMALLINT2-999Number of measurements included in mean aperture magnitude from y filter detections.
yFlagsdimensionlessINT40Information flag bitmask for mean object from y filter detections. Values listed in ObjectFilterFlags.
uniquePspsP2iddimensionlessBIGINT8NAUnique internal PSPS detection identifier.
detectIDdimensionlessBIGINT8NAUnique detection identifier.
filterIDdimensionlessTINYINT1NAFilter identifier. Details in the Filter table.
imageIDdimensionlessBIGINT8NAUnique image identifier. Constructed as (100 * frameID + ccdID).
randomDetIDdimensionlessFLOAT8NARandom value drawn from the interval between zero and one.
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.
xPosraw pixelsREAL4-999PSF x center location.
yPosraw pixelsREAL4-999PSF y center location.
xPosErrraw pixelsREAL4-999Error in PSF x center location.
yPosErrraw pixelsREAL4-999Error in PSF y center location.
pltScalearcsec/pixelREAL4-999Local plate scale at this location.
posAngledegreesREAL4-999Position angle (sky-to-chip) at this location.
radegreesFLOAT8-999Right ascension.
dec




raErrarcsecREAL4-999Right ascension error.
decErrarcsecREAL4-999Declination error.
extNSigmadimensionlessREAL40An extendedness measure based on the deviation between PSF and Kron (1980) magnitudes, normalized by the PSF magnitude uncertainty.
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 frame/exposure. 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.
psfFluxJanskysREAL4-999Flux from PSF fit.
psfFluxErrJanskysREAL4-999Error on flux from PSF fit.
psfMajorFWHMarcsecREAL4-999PSF major axis FWHM.
psfMinorFWHMarcsecREAL4-999PSF minor axis FWHM.
psfThetadegreesREAL4-999PSF major axis orientation.
psfCoredimensionlessREAL4-999PSF core parameter k, where F = F0 / (1 + k r^2 + r^3.33).
psfQfdimensionlessREAL4-999PSF coverage factor.
psfQfPerfectdimensionlessREAL4-999PSF weighted fraction of pixels totally unmasked.
psfChiSqdimensionlessREAL4-999Reduced chi squared value of the PSF model fit.
psfLikelihooddimensionlessREAL4-999Likelihood that this detection is best fit by a PSF.
momentXXarcsec^2REAL4-999Second moment M_xx.
momentXYarcsec^2REAL4-999Second moment M_xy.
momentYYarcsec^2REAL4-999Second moment M_yy.
momentR1arcsecREAL4-999First radial moment.
momentRHarcsec^0.5REAL4-999Half radial moment (r^0.5 weighting).
momentM3Carcsec^2REAL4-999Cosine of trefoil second moment term: r^2 cos(3 theta) = M_xxx - 3 * M_xyy.
momentM3Sarcsec^2REAL4-999Sine of trefoil second moment: r^2 sin (3 theta) = 3 * M_xxy - M_yyy.
momentM4Carcsec^2REAL4-999Cosine of quadrupole second moment: r^2 cos (4 theta) = M_xxxx - 6 * M_xxyy + M_yyyy.
momentM4Sarcsec^2REAL4-999Sine of quadrupole second moment: r^2 sin (4 theta) = 4 * M_xxxy - 4 * M_xyyy.
apFluxJanskysREAL4-999Flux in seeing-dependent aperture.
apFluxErrJanskysREAL4-999Error on flux in seeing-dependent aperture.
apFillFdimensionlessREAL4-999Aperture fill factor.
apRadiusarcsecREAL4-999Aperture radius.
kronFluxJanskysREAL4-999Kron (1980) flux.
kronFluxErrJanskysREAL4-999Error on Kron (1980) flux.
kronRadarcsecREAL4-999Kron (1980) radius.
skyJanskys/arcsec^2REAL4-999Background sky level.
skyErrJanskys/arcsec^2REAL4-999Error in background sky level.
infoFlagdimensionlessBIGINT80Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags.
infoFlag2dimensionlessINT40Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags2.
infoFlag3dimensionlessINT40Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags3.