You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

This page describes the contents of the PanSTARRS-1 observational metadata database tables.  These tables include information on the observations that contributed to the PS1 survey, including observation date, exposure time, filter, seeing, etc. Other tables include information on secondary data products such as the list of images that contribute to stacks. The information is not specific to individual objects but may be useful in understanding the images and catalogs. The descriptions are extracted from the PSPS Schema Browser interface created by the University of Hawaii. 

 

Contents

Tables included in DR1

FrameMeta


Description: Contains metadata related to an individual exposure. A "Frame" refers to the collection of all images obtained by the 60 OTA devices in the camera in a single exposure. The camera configuration, telescope pointing, observation time, and astrometric solution from the detector focal plane (L,M) to the sky (RA,Dec) is provided.
NameUnitData TypeSizeDefault ValueDescription
frameIDdimensionlessINT4NAUnique frame/exposure identifier.
frameNamedimensionlessVARCHAR(32)32NAFrame/exposure name provided by the camera software.
surveyIDdimensionlessTINYINT1NASurvey identifier. Details in the Survey table.
filterIDdimensionlessTINYINT1NAFilter identifier. Details in the Filter table.
ippChipIDdimensionlessINT4NAIPP chipRun identifier.
ippCamIDdimensionlessINT4NAIPP camRun identifier.
ippWarpIDdimensionlessINT4NAIPP warpRun identifier.
cameraIDdimensionlessSMALLINT2NACamera identifier. Details in the CameraConfig table.
cameraConfigIDdimensionlessSMALLINT2NACamera configuration identifier. Details in the CameraConfig table.
telescopeIDdimensionlessSMALLINT2NATelescope identifier.
analysisVerdimensionlessVARCHAR(100)100
IPP software analysis release version.
md5sumdimensionlessVARCHAR(100)100
IPP MD5 Checksum.
nOTAdimensionlessSMALLINT2-999Number of valid OTA images in this frame/exposure.
photoScatmagnitudesREAL4-999Photometric scatter relative to reference catalog across the full field of view.
nPhotoRefdimensionlessINT4-999Number of photometric reference sources.
expStartdaysFLOAT8-999Modified Julian Date at the start of the exposure.
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.
raBoredegreesFLOAT8-999Right ascension of telescope boresight.
decBoredegreesFLOAT8-999Declination of telescope boresight.
ctype1dimensionlessVARCHAR(100)100
Name of astrometric projection in right ascension.
ctype2dimensionlessVARCHAR(100)100
Name of astrometric projection in declination.
crval1degreesFLOAT8-999Right ascension corresponding to reference pixel.
crval2degreesFLOAT8-999Declination corresponding to reference pixel.
crpix1focal plane pixelsFLOAT8-999Reference pixel for right ascension.
crpix2focal plane pixelsFLOAT8-999Reference pixel for declination.
cdelt1degrees/pixelFLOAT8-999Pixel scale in right ascension.
cdelt2degrees/pixelFLOAT8-999Pixel scale in declination.
pc001001dimensionlessFLOAT8-999Linear transformation matrix element between focal plane pixel L and right ascension.
pc001002dimensionlessFLOAT8-999Linear transformation matrix element between focal plane pixel M and right ascension.
pc002001dimensionlessFLOAT8-999Linear transformation matrix element between focal plane pixel L and declination.
pc002002dimensionlessFLOAT8-999Linear transformation matrix element between focal plane pixel M and declination.
polyOrderdimensionlessTINYINT1255Polynomial order of astrometric fit between the detector focal plane and the sky.
pca1x3y0dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^3 y^0) for right ascension.
pca1x2y1dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^2 y^1) for right ascension.
pca1x1y2dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^1 y^2) for right ascension.
pca1x0y3dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^0 y^3) for right ascension.
pca1x2y0dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^2 y^0) for right ascension.
pca1x1y1dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^1 y^1) for right ascension.
pca1x0y2dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^0 y^2) for right ascension.
pca2x3y0dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^3 y^0) for declination.
pca2x2y1dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^2 y^1) for declination.
pca2x1y2dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^1 y^2) for declination.
pca2x0y3dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^0 y^3) for declination.
pca2x2y0dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^2 y^0) for declination.
pca2x1y1dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^1 y^1) for declination.
pca2x0y2dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^0 y^2) for declination.
batchIDdimensionlessBIGINT8NAInternal database batch identifier.
processingVersiondimensionlessTINYINT1NAData release version.

ImageMeta

Description: Contains metadata related to an individual OTA image that comprises a portion of the full exposure. The characterization of the image quality, the detrends applied, and the astrometric solution from the raw pixels (X,Y) to the detector focal plane (L,M) is provided.
NameUnitData TypeSizeDefault ValueDescription
imageIDdimensionlessBIGINT8NAUnique image identifier. Constructed as (100 * frameID + ccdID).
frameIDdimensionlessINT4NAUnique frame/exposure identifier.
ccdIDdimensionlessSMALLINT2NAOTA identifier based on location in the focal plane, specific to an individual device.
photoCalIDdimensionlessINT4NAPhotometric calibration identifier. Details in the PhotoCal table.
filterIDdimensionlessTINYINT1NAFilter identifier. Details in the Filter table.
biasaduREAL4-999OTA bias level.
biasScataduREAL4-999Scatter in bias level.
skyJanskys/arcsec^2REAL4-999Mean sky brightness.
skyScatJanskys/arcsec^2REAL4-999Scatter in mean sky brightness.
nDetectdimensionlessINT4-999Number of detections in this image.
detectionThresholdmagnitudesREAL4-999Reference magnitude for detection efficiency calculation.
astroScatarcsecREAL4-999Measurement of the calibration (not astrometric error) defined to be the sum in quadrature of the standard deviations in the X and Y directions.
photoScatmagnitudesREAL4-999Photometric scatter relative to reference catalog.
nAstroRefdimensionlessINT4-999Number of astrometric reference sources.
nPhotoRefdimensionlessINT4-999Number of photometric reference sources.
recalAstroScatXarcsecREAL4-999Measurement of the re-calibration (not astrometric error) in the X direction.
recalAstroScatYarcsecREAL4-999Measurement of the re-calibration (not astrometric error) in the Y direction.
recalNAstroStarsdimensionlessINT4-999Number of astrometric reference sources used in recalibration.
recalphotoScatmagnitudesREAL4-999Photometric scatter relative to reference catalog.
recalNPhotoStarsdimensionlessINT4-999Number of astrometric reference sources used in recalibration.
nAxis1pixelsSMALLINT2-999Image dimension in x.
nAxis2pixelsSMALLINT2-999Image dimension in y.
psfModelIDdimensionlessINT4-999PSF model identifier.
psfFWHMarcsecREAL4-999Mean PSF full width at half maximum at image center.
psfWidMajorarcsecREAL4-999PSF major axis FWHM at image center.
psfWidMinorarcsecREAL4-999PSF minor axis FWHM at image center.
psfThetadegreesREAL4-999PSF major axis orientation at image center.
momentMajorarcsecREAL4-999PSF major axis second moment.
momentMinorarcsecREAL4-999PSF minor axis second moment.
momentM2Carcsec^2REAL4-999Moment M2C = M_xx - M_yy.
momentM2Sarcsec^2REAL4-999Moment M2S = 2 * M_xy.
momentM3arcsec^2REAL4-999trefoil second moment = sqrt( (M_xxx - 3 * M_xyy)^2 + (3 * M_xxy - M_yyy)^2 ).
momentM4arcsec^2REAL4-999quadrupole second moment = sqrt( (M_xxxx - 6 * M_xxyy + M_yyyy)^2 + (4 * M_xxxy - 4 * M_xyyy)^2 ).
apResidmagnitudesREAL4-999Residual of aperture corrections.
dapResidmagnitudesREAL4-999Scatter of aperture corrections.
detectorIDdimensionlessVARCHAR(100)100 Identifier for each individual OTA detector device.
qaFlagsdimensionlessBIGINT8-999Q/A flags for this image. Values listed in ImageFlags.
detrend1dimensionlessVARCHAR(100)100 Identifier for detrend image 1, the static mask.
detrend2dimensionlessVARCHAR(100)100 Identifier for detrend image 2, the dark model.
detrend3dimensionlessVARCHAR(100)100 Identifier for detrend image 3, the flat.
detrend4dimensionlessVARCHAR(100)100 Identifier for detrend image 4, the fringe.
detrend5dimensionlessVARCHAR(100)100 Identifier for detrend image 5, the noisemap.
detrend6dimensionlessVARCHAR(100)100 Identifier for detrend image 6, the non-linearity correction.
detrend7dimensionlessVARCHAR(100)100 Identifier for detrend image 7, the video dark model.
detrend8dimensionlessVARCHAR(100)100 Identifier for detrend image 8.
photoZeromagnitudesREAL4-999Locally derived photometric zero point for this image.
ctype1dimensionlessVARCHAR(100)100 Name of astrometric projection in focal plane L.
ctype2dimensionlessVARCHAR(100)100 Name of astrometric projection in focal plane M.
crval1focal plane pixelsFLOAT8-999Focal plane L corresponding to reference pixel.
crval2focal plane pixelsFLOAT8-999Focal plane M corresponding to reference pixel.
crpix1raw pixelsFLOAT8-999Reference pixel for focal plane L.
crpix2raw pixelsFLOAT8-999Reference pixel for focal plane M.;
cdelt1focal plane pixels/raw pixelFLOAT8-999Pixel scale in focal plane x.
cdelt2focal plane pixels/raw pixelFLOAT8-999Pixel scale in focal plane y.
pc001001dimensionlessFLOAT8-999Linear transformation matrix element between image pixel x and focal plane pixel L.
pc001002dimensionlessFLOAT8-999Linear transformation matrix element between image pixel y and focal plane pixel L.
pc002001dimensionlessFLOAT8-999Linear transformation matrix element between image pixel x and focal plane pixel M.
pc002002dimensionlessFLOAT8-999Linear transformation matrix element between image pixel y and focal plane pixel M.
polyOrderdimensionlessTINYINT1255Polynomial order of astrometric fit between the image pixels and the detector focal plane.
pca1x3y0dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^3 y^0) for focal plane L.
pca1x2y1dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^2 y^1) for focal plane L.
pca1x1y2dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^1 y^2) for focal plane L.
pca1x0y3dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^0 y^3) for focal plane L.
pca1x2y0dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^2 y^0) for focal plane L.
pca1x1y1dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^1 y^1) for focal plane L.
pca1x0y2dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^0 y^2) for focal plane L.
pca2x3y0dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^3 y^0) for focal plane M.
pca2x2y1dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^2 y^1) for focal plane M.
pca2x1y2dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^1 y^2) for focal plane M.
pca2x0y3dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^0 y^3) for focal plane M.
pca2x2y0dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^2 y^0) for focal plane M.
pca2x1y1dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^1 y^1) for focal plane M.
pca2x0y2dimensionlessFLOAT8-999Polynomial coefficient for the astrometric fit component (x^0 y^2) for focal plane M.
processingVersiondimensionlessTINYINT1NAData release version.

StackToImage

Description: Contains the mapping of which input images were used to construct a particular stack.
NameUnitData TypeSizeDefault ValueDescription
stackImageIDdimensionlessBIGINT8NAUnique stack identifier.
imageIDdimensionlessBIGINT8NAUnique image identifier. Constructed as (100 * frameID + ccdID).

StackToFrame

Description: Contains the mapping of input frames used to construct a particular stack along with processing stats.
NameUnitData TypeSizeDefault ValueDescription
stackImageIDdimensionlessBIGINT8NAUnique stack identifier.
frameIDdimensionlessINT4NAUnique frame/exposure identifier.
scaleFactordimensionlessREAL40normalization factor applied to input image before stacking.
zpmagnitudesREAL40Photometric zeropoint. 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.

StackMeta

Description: Contains the metadata describing the stacked image produced from the combination of a set of single epoch exposures. The nature of the stack is given by the StackTypeID. The astrometric and photometric calibration of the stacked image are listed.
NameUnitData TypeSizeDefault ValueDescription
stackImageIDdimensionlessBIGINT8NAUnique stack identifier.
batchIDdimensionlessBIGINT8NAInternal database batch identifier.
surveyIDdimensionlessTINYINT1NASurvey identifier. Details in the Survey table.
filterIDdimensionlessTINYINT1NAFilter identifier. Details in the Filter table.
stackTypeIDdimensionlessTINYINT10Stack type identifier. Details in the StackType table.
tessIDdimensionlessTINYINT10Tessellation identifier. Details in the TessellationType table.
projectionIDdimensionlessSMALLINT2-1Projection cell identifier.
skyCellIDdimensionlessTINYINT1255Skycell region identifier.
photoCalIDdimensionlessINT4NAPhotometric calibration identifier. Details in the PhotoCal table.
analysisVerdimensionlessVARCHAR(100)100 IPP software analysis release version.
md5sumdimensionlessVARCHAR(100)100 IPP MD5 Checksum.
expTimesecondsREAL4-999Exposure time of the stack. Necessary for converting listed fluxes and magnitudes back to measured ADU counts.
nP2ImagesdimensionlessSMALLINT2-999Number of input exposures/frames contributing to this stack.
detectionThresholdmagnitudesREAL4-999Reference magnitude for detection efficiency calculation.
astroScatdimensionlessREAL4-999Measurement of the calibration (not astrometric error) defined to be the sum in quadrature of the standard deviations in the X and Y directions.
photoScatdimensionlessREAL4-999Photometric scatter relative to reference catalog.
nAstroRefdimensionlessINT4-999Number of astrometric reference sources.
nPhotoRefdimensionlessINT4-999Number of photometric reference sources.
recalAstroScatXarcsecREAL4-999Measurement of the re-calibration (not astrometric error) in the X direction.
recalAstroScatYarcsecREAL4-999Measurement of the re-calibration (not astrometric error) in the Y direction.
recalNAstroStarsdimensionlessINT4-999Number of astrometric reference sources used in recalibration.
recalphotoScatmagnitudesREAL4-999Photometric scatter relative to reference catalog.
recalNPhotoStarsdimensionlessINT4-999Number of astrometric reference sources used in recalibration.
psfModelIDdimensionlessINT4-999PSF model identifier.
psfFWHMarcsecREAL4-999Mean PSF full width at half maximum at image center.
psfWidMajorarcsecREAL4-999PSF major axis FWHM at image center.
psfWidMinorarcsecREAL4-999PSF minor axis FWHM at image center.
psfThetadegreesREAL4-999PSF major axis orientation at image center.
photoZeromagnitudesREAL4-999Locally derived photometric zero point for this stack.
ctype1dimensionlessVARCHAR(100)100 Name of astrometric projection in right ascension.
ctype2dimensionlessVARCHAR(100)100 Name of astrometric projection in declination.
crval1degreesFLOAT8-999Right ascension corresponding to reference pixel.
crval2degreesFLOAT8-999Declination corresponding to reference pixel.
crpix1sky pixelsFLOAT8-999Reference pixel for right ascension.
crpix2sky pixelsFLOAT8-999Reference pixel for declination.
cdelt1degrees/pixelFLOAT8-999Pixel scale in right ascension.
cdelt2degrees/pixelFLOAT8-999Pixel scale in declination.
pc001001dimensionlessFLOAT8-999Linear transformation matrix element between image pixel x and right ascension.
pc001002dimensionlessFLOAT8-999Linear transformation matrix element between image pixel y and right ascension.
pc002001dimensionlessFLOAT8-999Linear transformation matrix element between image pixel x and declination.
pc002002dimensionlessFLOAT8-999Linear transformation matrix element between image pixel y and declination.
processingVersiondimensionlessTINYINT1NAData release version.

ImageDetEffMeta

Description: Contains the detection efficiency information for a given individual OTA image. Provides the number of recovered sources out of 500 injected fake source and statistics about the magnitudes of the recovered sources for a range of magnitude offsets.
NameUnitData TypeSizeDefault ValueDescription
imageIDdimensionlessBIGINT8NAUnique image identifier. Constructed as (100 * frameID + ccdID).
frameIDdimensionlessINT4NAUnique frame/exposure identifier.
magrefmagnitudesREAL4NADetection efficiency reference magnitude.
nInjecteddimensionlessINT4NANumber of fake sources injected in each magnitude bin.
offset01magnitudesREAL4NADetection efficiency magnitude offset for bin 1.
counts01dimensionlessREAL4NADetection efficiency count of recovered sources in bin 1.
diffMean01magnitudesREAL4NADetection efficiency mean magnitude difference in bin 1.
diffStdev01magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 1.
errMean01magnitudesREAL4NADetection efficiency mean magnitude error in bin 1.
offset02magnitudesREAL4NADetection efficiency magnitude offset for bin 2.
counts02dimensionlessREAL4NADetection efficiency count of recovered sources in bin 2.
diffMean02magnitudesREAL4NADetection efficiency mean magnitude difference in bin 2.
diffStdev02magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 2.
errMean02magnitudesREAL4NADetection efficiency mean magnitude error in bin 2.
offset03magnitudesREAL4NADetection efficiency magnitude offset for bin 3.
counts03dimensionlessREAL4NADetection efficiency count of recovered sources in bin 3.
diffMean03magnitudesREAL4NADetection efficiency mean magnitude difference in bin 3.
diffStdev03magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 3.
errMean03magnitudesREAL4NADetection efficiency mean magnitude error in bin 3.
offset04magnitudesREAL4NADetection efficiency magnitude offset for bin 4.
counts04dimensionlessREAL4NADetection efficiency count of recovered sources in bin 4.
diffMean04magnitudesREAL4NADetection efficiency mean magnitude difference in bin 4.
diffStdev04magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 4.
errMean04magnitudesREAL4NADetection efficiency mean magnitude error in bin 4.
offset05magnitudesREAL4NADetection efficiency magnitude offset for bin 5.
counts05dimensionlessREAL4NADetection efficiency count of recovered sources in bin 5.
diffMean05magnitudesREAL4NADetection efficiency mean magnitude difference in bin 5.
diffStdev05magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 5.
errMean05magnitudesREAL4NADetection efficiency mean magnitude error in bin 5.
offset06magnitudesREAL4NADetection efficiency magnitude offset for bin 6.
counts06dimensionlessREAL4NADetection efficiency count of recovered sources in bin 6.
diffMean06magnitudesREAL4NADetection efficiency mean magnitude difference in bin 6.
diffStdev06magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 6.
errMean06magnitudesREAL4NADetection efficiency mean magnitude error in bin 6.
offset07magnitudesREAL4NADetection efficiency magnitude offset for bin 7.
counts07dimensionlessREAL4NADetection efficiency count of recovered sources in bin 7.
diffMean07magnitudesREAL4NADetection efficiency mean magnitude difference in bin 7.
diffStdev07magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 7.
errMean07magnitudesREAL4NADetection efficiency mean magnitude error in bin 7.
offset08magnitudesREAL4NADetection efficiency magnitude offset for bin 8.
counts08dimensionlessREAL4NADetection efficiency count of recovered sources in bin 8.
diffMean08magnitudesREAL4NADetection efficiency mean magnitude difference in bin 8.
diffStdev08magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 8.
errMean08magnitudesREAL4NADetection efficiency mean magnitude error in bin 8.
offset09magnitudesREAL4NADetection efficiency magnitude offset for bin 9.
counts09dimensionlessREAL4NADetection efficiency count of recovered sources in bin 9.
diffMean09magnitudesREAL4NADetection efficiency mean magnitude difference in bin 9.
diffStdev09magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 9.
errMean09magnitudesREAL4NADetection efficiency mean magnitude error in bin 9.
offset10magnitudesREAL4NADetection efficiency magnitude offset for bin 10.
counts10dimensionlessREAL4NADetection efficiency count of recovered sources in bin 10.
diffMean10magnitudesREAL4NADetection efficiency mean magnitude difference in bin 10.
diffStdev10magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 10.
errMean10magnitudesREAL4NADetection efficiency mean magnitude error in bin 10.
offset11magnitudesREAL4NADetection efficiency magnitude offset for bin 11.
counts11dimensionlessREAL4NADetection efficiency count of recovered sources in bin 11.
diffMean11magnitudesREAL4NADetection efficiency mean magnitude difference in bin 11.
diffStdev11magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 11.
errMean11magnitudesREAL4NADetection efficiency mean magnitude error in bin 11.
offset12magnitudesREAL4NADetection efficiency magnitude offset for bin 12.
counts12dimensionlessREAL4NADetection efficiency count of recovered sources in bin 12.
diffMean12magnitudesREAL4NADetection efficiency mean magnitude difference in bin 12.
diffStdev12magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 12.
errMean12magnitudesREAL4NADetection efficiency mean magnitude error in bin 12.
offset13magnitudesREAL4NADetection efficiency magnitude offset for bin 13.
counts13dimensionlessREAL4NADetection efficiency count of recovered sources in bin 13.
diffMean13magnitudesREAL4NADetection efficiency mean magnitude difference in bin 13.
diffStdev13magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 13.
errMean13magnitudesREAL4NADetection efficiency mean magnitude error in bin 13.

StackDetEffMeta

Description: Contains the detection efficiency information for a given stacked image. Provides the number of recovered sources out of 500 injected sources for each magnitude bin and statistics about the magnitudes of the recovered sources for a range of magnitude offsets.
NameUnitData TypeSizeDefault ValueDescription
stackImageIDdimensionlessBIGINT8NAUnique stack identifier.
magrefmagnitudesREAL4NADetection efficiency reference magnitude.
nInjecteddimensionlessINT4NANumber of fake sources injected in each magnitude bin.
offset01magnitudesREAL4NADetection efficiency magnitude offset for bin 1.
counts01dimensionlessREAL4NADetection efficiency count of recovered sources in bin 1.
diffMean01magnitudesREAL4NADetection efficiency mean magnitude difference in bin 1.
diffStdev01magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 1.
errMean01magnitudesREAL4NADetection efficiency mean magnitude error in bin 1.
offset02magnitudesREAL4NADetection efficiency magnitude offset for bin 2.
counts02dimensionlessREAL4NADetection efficiency count of recovered sources in bin 2.
diffMean02magnitudesREAL4NADetection efficiency mean magnitude difference in bin 2.
diffStdev02magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 2.
errMean02magnitudesREAL4NADetection efficiency mean magnitude error in bin 2.
offset03magnitudesREAL4NADetection efficiency magnitude offset for bin 3.
counts03dimensionlessREAL4NADetection efficiency count of recovered sources in bin 3.
diffMean03magnitudesREAL4NADetection efficiency mean magnitude difference in bin 3.
diffStdev03magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 3.
errMean03magnitudesREAL4NADetection efficiency mean magnitude error in bin 3.
offset04magnitudesREAL4NADetection efficiency magnitude offset for bin 4.
counts04dimensionlessREAL4NADetection efficiency count of recovered sources in bin 4.
diffMean04magnitudesREAL4NADetection efficiency mean magnitude difference in bin 4.
diffStdev04magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 4.
errMean04magnitudesREAL4NADetection efficiency mean magnitude error in bin 4.
offset05magnitudesREAL4NADetection efficiency magnitude offset for bin 5.
counts05dimensionlessREAL4NADetection efficiency count of recovered sources in bin 5.
diffMean05magnitudesREAL4NADetection efficiency mean magnitude difference in bin 5.
diffStdev05magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 5.
errMean05magnitudesREAL4NADetection efficiency mean magnitude error in bin 5.
offset06magnitudesREAL4NADetection efficiency magnitude offset for bin 6.
counts06dimensionlessREAL4NADetection efficiency count of recovered sources in bin 6.
diffMean06magnitudesREAL4NADetection efficiency mean magnitude difference in bin 6.
diffStdev06magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 6.
errMean06magnitudesREAL4NADetection efficiency mean magnitude error in bin 6.
offset07magnitudesREAL4NADetection efficiency magnitude offset for bin 7.
counts07dimensionlessREAL4NADetection efficiency count of recovered sources in bin 7.
diffMean07magnitudesREAL4NADetection efficiency mean magnitude difference in bin 7.
diffStdev07magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 7.
errMean07magnitudesREAL4NADetection efficiency mean magnitude error in bin 7.
offset08magnitudesREAL4NADetection efficiency magnitude offset for bin 8.
counts08dimensionlessREAL4NADetection efficiency count of recovered sources in bin 8.
diffMean08magnitudesREAL4NADetection efficiency mean magnitude difference in bin 8.
diffStdev08magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 8.
errMean08magnitudesREAL4NADetection efficiency mean magnitude error in bin 8.
offset09magnitudesREAL4NADetection efficiency magnitude offset for bin 9.
counts09dimensionlessREAL4NADetection efficiency count of recovered sources in bin 9.
diffMean09magnitudesREAL4NADetection efficiency mean magnitude difference in bin 9.
diffStdev09magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 9.
errMean09magnitudesREAL4NADetection efficiency mean magnitude error in bin 9.
offset10magnitudesREAL4NADetection efficiency magnitude offset for bin 10.
counts10dimensionlessREAL4NADetection efficiency count of recovered sources in bin 10.
diffMean10magnitudesREAL4NADetection efficiency mean magnitude difference in bin 10.
diffStdev10magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 10.
errMean10magnitudesREAL4NADetection efficiency mean magnitude error in bin 10.
offset11magnitudesREAL4NADetection efficiency magnitude offset for bin 11.
counts11dimensionlessREAL4NADetection efficiency count of recovered sources in bin 11.
diffMean11magnitudesREAL4NADetection efficiency mean magnitude difference in bin 11.
diffStdev11magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 11.
errMean11magnitudesREAL4NADetection efficiency mean magnitude error in bin 11.
offset12magnitudesREAL4NADetection efficiency magnitude offset for bin 12.
counts12dimensionlessREAL4NADetection efficiency count of recovered sources in bin 12.
diffMean12magnitudesREAL4NADetection efficiency mean magnitude difference in bin 12.
diffStdev12magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 12.
errMean12magnitudesREAL4NADetection efficiency mean magnitude error in bin 12.
offset13magnitudesREAL4NADetection efficiency magnitude offset for bin 13.
counts13dimensionlessREAL4NADetection efficiency count of recovered sources in bin 13.
diffMean13magnitudesREAL4NADetection efficiency mean magnitude difference in bin 13.
diffStdev13magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 13.
errMean13magnitudesREAL4NADetection efficiency mean magnitude error in bin 13.

Tables not included in DR1

The tables below are not part of the DR1 database, but their descriptions are included for completeness.

DiffToImage

Description: Contains the mapping of which input images were used to construct a particular difference image.
NameUnitData TypeSizeDefault ValueDescription
diffImageIDdimensionlessBIGINT8NAUnique difference identifier.
imageIDdimensionlessBIGINT8NAUnique image identifier. Constructed as (100 * frameID + ccdID).

 

DiffMeta

Description: Contains metadata related to a difference image constructed by subtracting a stacked image from a single epoch image, or in the case of the MD Survey from a nightly stack (stack made from all exposures in a single filter in a single night). The astrometric calibration of the reference stack is listed.
NameUnitData TypeSizeDefault ValueDescription
diffImageIDdimensionlessBIGINT8NAUnique difference identifier.
batchIDdimensionlessBIGINT8NAInternal database batch identifier.
surveyIDdimensionlessTINYINT1NASurvey identifier. Details in the Survey table.
filterIDdimensionlessTINYINT1NAFilter identifier. Details in the Filter table.
diffTypeIDdimensionlessTINYINT10Difference type identifier. Details in the DiffType table.
frameIDdimensionlessINT4NAFrame/exposure identifier for the postitive image in warp-stack difference images; not populated for stack-stack differences.
posImageIDdimensionlessBIGINT8NAImage identifier for the positive image. For warp-stack difference images, this corresponds to the ForcedWarpToImage.forcedWarpID entry. For stack-stack difference images, this corresponds to StackMeta.stackImageID.
negImageIDdimensionlessBIGINT8NAImage identifier for the negative image. For warp-stack difference images, this corresponds to the StackMeta.stackImageID entry.
ippDiffIDdimensionlessBIGINT8NAIPP diffRun identifier.
tessIDdimensionlessTINYINT10Tessellation identifier. Details in the TessellationType table.
projectionIDdimensionlessSMALLINT2-1Projection cell identifier.
skyCellIDdimensionlessTINYINT1255Skycell region identifier.
photoCalIDdimensionlessINT4NAPhotometric calibration identifier. Details in the PhotoCal table.
analysisVerdimensionlessVARCHAR(100)100 IPP software analysis release version.
md5sumdimensionlessVARCHAR(100)100 IPP MD5 Checksum.
detectionThresholdmagnitudesREAL4-999Reference magnitude for detection efficiency calculation.
expTimesecondsREAL4-999Exposure time of positive image. Necessary for converting listed fluxes and magnitudes back to measured ADU counts.
psfModelIDdimensionlessINT4-999PSF model identifier.
psfFWHMarcsecREAL4-999Mean PSF full width at half maximum at image center.
psfWidMajorarcsecREAL4-999PSF major axis FWHM at image center.
psfWidMinorarcsecREAL4-999PSF minor axis FWHM at image center.
psfThetadegreesREAL4-999PSF major axis orientation at image center.
kerneldimensionlessVARCHAR(100)100 Subtraction kernel.
modedimensionlessTINYINT10Subtraction mode for which input to convolve.
numStampsdimensionlessINT4-999Number of stamps.
stampDevMeandimensionlessREAL4-999Mean stamp deviation.
stampDevRMSdimensionlessREAL4-999RMS stamp deviation.
normalizationdimensionlessREAL4-999Normalization.
convolveMaxdimensionlessREAL4-999Maxiumum convolution fraction.
deconvolveMaxdimensionlessREAL4-999Maximum deconvolution fraction.
ctype1dimensionlessVARCHAR(100)100 Name of astrometric projection in right ascension.
ctype2dimensionlessVARCHAR(100)100 Name of astrometric projection in declination.
crval1degreesFLOAT8-999Right ascension corresponding to reference pixel.
crval2degreesFLOAT8-999Declination corresponding to reference pixel.
crpix1sky pixelsFLOAT8-999Reference pixel for right ascension.
crpix2sky pixelsFLOAT8-999Reference pixel for declination.
cdelt1degrees/pixelFLOAT8-999Pixel scale in right ascension.
cdelt2degrees/pixelFLOAT8-999Pixel scale in declination.
pc001001dimensionlessFLOAT8-999Linear transformation matrix element between image pixel x and right ascension.
pc001002dimensionlessFLOAT8-999Linear transformation matrix element between image pixel y and right ascension.
pc002001dimensionlessFLOAT8-999Linear transformation matrix element between image pixel x and declination.
pc002002dimensionlessFLOAT8-999Linear transformation matrix element between image pixel y and declination.
processingVersiondimensionlessTINYINT1NAData release version.

DiffDetEffMeta

Description: Contains the detection efficiency information for a given individual difference image. Provides the number of recovered sources out of 500 injected sources and statistics about the magnitudes of the recovered sources for a range of magnitude offsets.
NameUnitData TypeSizeDefault ValueDescription
diffImageIDdimensionlessBIGINT8NAUnique difference image identifier.
magrefmagnitudesREAL4NADetection efficiency reference magnitude.
nInjecteddimensionlessINT4NANumber of fake sources injected in each magnitude bin.
offset01magnitudesREAL4NADetection efficiency magnitude offset for bin 1.
counts01dimensionlessREAL4NADetection efficiency count of recovered sources in bin 1.
diffMean01magnitudesREAL4NADetection efficiency mean magnitude difference in bin 1.
diffStdev01magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 1.
errMean01magnitudesREAL4NADetection efficiency mean magnitude error in bin 1.
offset02magnitudesREAL4NADetection efficiency magnitude offset for bin 2.
counts02dimensionlessREAL4NADetection efficiency count of recovered sources in bin 2.
diffMean02magnitudesREAL4NADetection efficiency mean magnitude difference in bin 2.
diffStdev02magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 2.
errMean02magnitudesREAL4NADetection efficiency mean magnitude error in bin 2.
offset03magnitudesREAL4NADetection efficiency magnitude offset for bin 3.
counts03dimensionlessREAL4NADetection efficiency count of recovered sources in bin 3.
diffMean03magnitudesREAL4NADetection efficiency mean magnitude difference in bin 3.
diffStdev03magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 3.
errMean03magnitudesREAL4NADetection efficiency mean magnitude error in bin 3.
offset04magnitudesREAL4NADetection efficiency magnitude offset for bin 4.
counts04dimensionlessREAL4NADetection efficiency count of recovered sources in bin 4.
diffMean04magnitudesREAL4NADetection efficiency mean magnitude difference in bin 4.
diffStdev04magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 4.
errMean04magnitudesREAL4NADetection efficiency mean magnitude error in bin 4.
offset05magnitudesREAL4NADetection efficiency magnitude offset for bin 5.
counts05dimensionlessREAL4NADetection efficiency count of recovered sources in bin 5.
diffMean05magnitudesREAL4NADetection efficiency mean magnitude difference in bin 5.
diffStdev05magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 5.
errMean05magnitudesREAL4NADetection efficiency mean magnitude error in bin 5.
offset06magnitudesREAL4NADetection efficiency magnitude offset for bin 6.
counts06dimensionlessREAL4NADetection efficiency count of recovered sources in bin 6.
diffMean06magnitudesREAL4NADetection efficiency mean magnitude difference in bin 6.
diffStdev06magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 6.
errMean06magnitudesREAL4NADetection efficiency mean magnitude error in bin 6.
offset07magnitudesREAL4NADetection efficiency magnitude offset for bin 7.
counts07dimensionlessREAL4NADetection efficiency count of recovered sources in bin 7.
diffMean07magnitudesREAL4NADetection efficiency mean magnitude difference in bin 7.
diffStdev07magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 7.
errMean07magnitudesREAL4NADetection efficiency mean magnitude error in bin 7.
offset08magnitudesREAL4NADetection efficiency magnitude offset for bin 8.
counts08dimensionlessREAL4NADetection efficiency count of recovered sources in bin 8.
diffMean08magnitudesREAL4NADetection efficiency mean magnitude difference in bin 8.
diffStdev08magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 8.
errMean08magnitudesREAL4NADetection efficiency mean magnitude error in bin 8.
offset09magnitudesREAL4NADetection efficiency magnitude offset for bin 9.
counts09dimensionlessREAL4NADetection efficiency count of recovered sources in bin 9.
diffMean09magnitudesREAL4NADetection efficiency mean magnitude difference in bin 9.
diffStdev09magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 9.
errMean09magnitudesREAL4NADetection efficiency mean magnitude error in bin 9.
offset10magnitudesREAL4NADetection efficiency magnitude offset for bin 10.
counts10dimensionlessREAL4NADetection efficiency count of recovered sources in bin 10.
diffMean10magnitudesREAL4NADetection efficiency mean magnitude difference in bin 10.
diffStdev10magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 10.
errMean10magnitudesREAL4NADetection efficiency mean magnitude error in bin 10.
offset11magnitudesREAL4NADetection efficiency magnitude offset for bin 11.
counts11dimensionlessREAL4NADetection efficiency count of recovered sources in bin 11.
diffMean11magnitudesREAL4NADetection efficiency mean magnitude difference in bin 11.
diffStdev11magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 11.
errMean11magnitudesREAL4NADetection efficiency mean magnitude error in bin 11.
offset12magnitudesREAL4NADetection efficiency magnitude offset for bin 12.
counts12dimensionlessREAL4NADetection efficiency count of recovered sources in bin 12.
diffMean12magnitudesREAL4NADetection efficiency mean magnitude difference in bin 12.
diffStdev12magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 12.
errMean12magnitudesREAL4NADetection efficiency mean magnitude error in bin 12.
offset13magnitudesREAL4NADetection efficiency magnitude offset for bin 13.
counts13dimensionlessREAL4NADetection efficiency count of recovered sources in bin 13.
diffMean13magnitudesREAL4NADetection efficiency mean magnitude difference in bin 13.
diffStdev13magnitudesREAL4NADetection efficiency standard deviation of magnitude differences in bin 13.
errMean13magnitudesREAL4NADetection efficiency mean magnitude error in bin 13.

ForcedWarpToImage

Description: Contains the mapping of which input image comprises a particular warp image used for forced photometry.
NameUnitData TypeSizeDefault ValueDescription
forcedWarpIDdimensionlessBIGINT8NAUnique forced warp identifier.
imageIDdimensionlessBIGINT8NAUnique image identifier. Constructed as (100 * frameID + ccdID).

 

ForcedWarpMeta

Description: Contains the metadata related to a sky-aligned distortion corrected warp image, upon which forced photometry is performed. The astrometric and photometric calibration of the warp image are listed.
NameUnitData TypeSizeDefault ValueDescription
forcedWarpIDdimensionlessBIGINT8NAUnique forced warp identifier.
batchIDdimensionlessBIGINT8NAInternal database batch identifier.
surveyIDdimensionlessTINYINT1NASurvey identifier. Details in the Survey table.
filterIDdimensionlessTINYINT1NAFilter identifier. Details in the Filter table.
frameIDdimensionlessINT4NAFrame/exposure identifier of the Frame associated with this warp.
ippSkycalIDdimensionlessINT4NAIPP skycal identifier for the run that generated the positions for forced photometry.
stackMetaIDdimensionlessINT4NAIdentifier for the stack which yielded the positions for forced photometry.
tessIDdimensionlessTINYINT10Tessellation identifier. Details in the TessellationType table.
projectionIDdimensionlessSMALLINT2-1Projection cell identifier.
skyCellIDdimensionlessTINYINT1255Skycell region identifier.
photoCalIDdimensionlessINT4NAPhotometric calibration identifier. Details in the PhotoCal table.
analysisVerdimensionlessVARCHAR(100)100 IPP software analysis release version.
md5sumdimensionlessVARCHAR(100)100 IPP MD5 Checksum.
expTimesecondsREAL4-999Exposure time of the source frame/exposure for this warp image. Necessary for converting listed fluxes and magnitudes back to measured ADU counts.
recalAstroScatXarcsecREAL4-999Measurement of the re-calibration (not astrometric error) in the X direction.
recalAstroScatYarcsecREAL4-999Measurement of the re-calibration (not astrometric error) in the Y direction.
recalNAstroStarsdimensionlessINT4-999Number of astrometric reference sources used in recalibration.
recalphotoScatmagnitudesREAL4-999Photometric scatter relative to reference catalog.
recalNPhotoStarsdimensionlessINT4-999Number of astrometric reference sources used in recalibration.
psfModelIDdimensionlessINT4-999PSF model identifier.
psfFWHMarcsecREAL4-999Mean PSF full width at half maximum at image center.
psfWidMajorarcsecREAL4-999PSF major axis FWHM at image center.
psfWidMinorarcsecREAL4-999PSF minor axis FWHM at image center.
psfThetadegreesREAL4-999PSF major axis orientation at image center.
photoZeromagnitudesREAL4-999Locally derived photometric zero point for this warp image.
ctype1dimensionlessVARCHAR(100)100 Name of astrometric projection in right ascension.
ctype2dimensionlessVARCHAR(100)100 Name of astrometric projection in declination.
crval1degreesFLOAT8-999Right ascension corresponding to reference pixel.
crval2degreesFLOAT8-999Declination corresponding to reference pixel.
crpix1sky pixelsFLOAT8-999Reference pixel for right ascension.
crpix2sky pixelsFLOAT8-999Reference pixel for declination.
cdelt1degrees/pixelFLOAT8-999Pixel scale in right ascension.
cdelt2degrees/pixelFLOAT8-999Pixel scale in declination.
pc001001dimensionlessFLOAT8-999Linear transformation matrix element between image pixel x and right ascension.
pc001002dimensionlessFLOAT8-999Linear transformation matrix element between image pixel y and right ascension.
pc002001dimensionlessFLOAT8-999Linear transformation matrix element between image pixel x and declination.
pc002002dimensionlessFLOAT8-999Linear transformation matrix element between image pixel y and declination.
processingVersiondimensionlessTINYINT1NAData release version.

  • No labels