Data Lab is hiring a Software Engineer. More information.

Choose a database in the left panel then select the table you want!

(The bold columns are indexed columns)
Column NameDescriptionDatatype
airmassREAL
airmassAirmass of observation (measured at the telescope bore-sight).REAL
annotatedSMALLINT
annotatedTrue/1 unless there is an error when computing the "annotated" quantities in this row of the file.SMALLINT
cameraThe camera that took this image, e.g. decam.VARCHAR(n)
cameraVARCHAR(n)
ccd_cutsIgnore.INTEGER
ccd_cutsINTEGER
ccddecoffREAL
ccddecoffMedian astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec.REAL
ccddecrmsRMS in astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec.REAL
ccddecrmsREAL
ccdnameCCD name: e.g. "N10", "S7" for DECam; "CCD3" for Mosaic, 90prime.VARCHAR(n)
ccdnameVARCHAR(n)
ccdnastromNumber of stars (after sigma-clipping) used to compute astrometric correction.SMALLINT
ccdnastromSMALLINT
ccdnphotomNumber of Gaia+PS1 stars detected with signal-to-noise ratio greater than five.SMALLINT
ccdnphotomSMALLINT
ccdphrmsPhotometric rms for the CCD (in mag).REAL
ccdphrmsREAL
ccdraoffMedian astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec.REAL
ccdraoffREAL
ccdrarmsREAL
ccdrarmsRMS in astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec.REAL
ccdskycountsREAL
ccdskycountsMean sky count level per pixel in the CP-processed frames measured (with iterative rejection) for each CCD in the image section [500:1500,1500:2500].REAL
ccdskysbREAL
ccdskysbSky surface brightness (in AB mag/arcsec2).REAL
ccdzptZeropoint for the CCD (AB mag).REAL
ccdzptREAL
cd1_1REAL
cd1_1Astrometric header value: transformation matrix.REAL
cd1_2REAL
cd1_2Astrometric header value: transformation matrix.REAL
cd2_1REAL
cd2_1Astrometric header value: transformation matrix.REAL
cd2_2REAL
cd2_2Astrometric header value: transformation matrix.REAL
crpix1REAL
crpix1Astrometric header value: X reference pixel.REAL
crpix2REAL
crpix2Astrometric header value: Y reference pixel.REAL
crval1DOUBLE
crval1Astrometric header value: RA of reference pixel.DOUBLE
crval2DOUBLE
crval2Astrometric header value: Dec of reference pixel.DOUBLE
ddecREAL
ddecMaximum distance from RA,Dec center to the edge midpoints, in Dec.REAL
decDOUBLE
decApproximate Dec center of this CCD (deg).DOUBLE
dec0Dec coordinate of pixel (1,1).DOUBLE
dec0DOUBLE
dec1Dec coordinate of pixel (1,H).DOUBLE
dec1DOUBLE
dec2DOUBLE
dec2Dec coordinate of pixel (W,H).DOUBLE
dec3Dec coordinate of pixel (W,1).DOUBLE
dec3DOUBLE
dec_boreDOUBLE
dec_boreTelescope boresight Dec of this exposure (deg).DOUBLE
dec_centerDOUBLE
dec_centerDec coordinate of CCD center.DOUBLE
decam_extinction_1Extinction for optical filter u.REAL
decam_extinction_1REAL
decam_extinction_2Extinction for optical filter g.REAL
decam_extinction_2REAL
decam_extinction_3Extinction for optical filter r.REAL
decam_extinction_3REAL
decam_extinction_4REAL
decam_extinction_4Extinction for optical filter i.REAL
decam_extinction_5Extinction for optical filter z.REAL
decam_extinction_5REAL
decam_extinction_6Extinction for optical filter Y.REAL
decam_extinction_6REAL
draMaximum distance from RA,Dec center to the edge midpoints, in RA.REAL
draREAL
ebvREAL
ebvSFD98 E(B-V) extinction for CCD center.REAL
expnumUnique DECam exposure number, e.g. 348244.BIGINT
expnumBIGINT
exptimeExposure time in seconds, e.g. 30.REAL
exptimeREAL
filterFilter used for observation, e.g. g, r, z.CHAR
filterCHAR
fwhmREAL
fwhmFWHM (in pixels) measured by the CP.REAL
galdepthREAL
galdepth5-sigma galaxy (0.45" round exp) detection depth in AB mag.REAL
galnorm_meanNorm of the PSF model convolved by a 0.45" exponential galaxy.REAL
galnorm_meanREAL
galnorm_stdREAL
galnorm_stdStandard deviation of galaxy norm.REAL
gaussgaldepth5-sigma galaxy detection depth in AB mag, using Gaussian PSF approximation.REAL
gaussgaldepthREAL
gausspsfdepthREAL
gausspsfdepth5-sigma PSF detection depth in AB mag, using Gaussian PSF approximation (using seeing value).REAL
good_region_1SMALLINT
good_region_1If only a subset of the CCD images was used, this array of x0,x1,y0,y1 values gives the coordinates that were used, [x0,x1), [y0,y1). -1 for no cut (most CCDs). x0 value.SMALLINT
good_region_2SMALLINT
good_region_2If only a subset of the CCD images was used, this array of x0,x1,y0,y1 values gives the coordinates that were used, [x0,x1), [y0,y1). -1 for no cut (most CCDs). x1 value.SMALLINT
good_region_3If only a subset of the CCD images was used, this array of x0,x1,y0,y1 values gives the coordinates that were used, [x0,x1), [y0,y1). -1 for no cut (most CCDs). y0 value.SMALLINT
good_region_3SMALLINT
good_region_4SMALLINT
good_region_4If only a subset of the CCD images was used, this array of x0,x1,y0,y1 values gives the coordinates that were used, [x0,x1), [y0,y1). -1 for no cut (most CCDs). y1 value.SMALLINT
heightHeight in pixels of this image, e.g. 4096.SMALLINT
heightSMALLINT
humidityREAL
humidityPercent humidity outside.REAL
image_filenameVARCHAR(n)
image_filenamePath to FITS image, e.g. decam/CP20140810_g_v2/c4d_140815_235218_ooi_g_v2.fits.fz.VARCHAR(n)
image_hduSMALLINT
image_hduFITS HDU number in the image_filename file where this image can be found.SMALLINT
ls_ccd_idBIGINT
ls_ccd_idUnique ID for all CCDs, composed from camera name, ccd name and exposure number.BIGINT
maxskyMax of our sky level.REAL
maxskyREAL
meanskyREAL
meanskyOur pipeline (not the CP) estimate of the sky level, average over the image, in ADU.REAL
minskyREAL
minskyMin of our sky level.REAL
mjd_obsDate of observation in MJD (in UTC system), e.g. 56884.99373389.DOUBLE
mjd_obsDOUBLE
objectVARCHAR(n)
objectName listed in the object tag from the CCD header.VARCHAR(n)
outtempREAL
outtempOutside temperate (deg C).REAL
pixscale_maxMax of pixel scale.REAL
pixscale_maxREAL
pixscale_meanREAL
pixscale_meanPixel scale (via sqrt of area of a 10x10 pixel patch evaluated in a 5x5 grid across the image), in arcsec/pixel.REAL
pixscale_minMin of pixel scale.REAL
pixscale_minREAL
pixscale_stdREAL
pixscale_stdStandard deviation of pixel scale.REAL
plprocidVARCHAR(n)
plprocidUnique, time-based, CP processing hash.VARCHAR(n)
plverVARCHAR(n)
plverCommunity Pipeline (CP) PLVER version string.VARCHAR(n)
procdateCP processing date.VARCHAR(n)
procdateVARCHAR(n)
propidVARCHAR(n)
propidNOAO Proposal ID that took this image, e.g. 2014B-0404.VARCHAR(n)
psf_aPSF model major axis (pixels).REAL
psf_aREAL
psf_bPSF model minor axis (pixels).REAL
psf_bREAL
psf_ellPSF ellipticity 1 - minor/major.REAL
psf_ellREAL
psf_mx2REAL
psf_mx2PSF model second moment in x (pixels^2).REAL
psf_mxyREAL
psf_mxyPSF model second moment in x-y (pixels^2).REAL
psf_my2REAL
psf_my2PSF model second moment in y (pixels^2).REAL
psf_thetaPSF position angle (deg).REAL
psf_thetaREAL
psfdepth5-sigma PSF detection depth in AB mag, using PsfEx PSF model.REAL
psfdepthREAL
psfnorm_meanPSF norm = 1/sqrt of N_eff = sqrt(sum(psf_i^2)) for normalized PSF pixels i; mean of the PSF model evaluated on a 5x5 grid of points across the image. Point-source detection standard deviation is sig1 / psfnorm.REAL
psfnorm_meanREAL
psfnorm_stdREAL
psfnorm_stdStandard deviation of PSF normREAL
raApproximate RA center of this CCD (deg).DOUBLE
raDOUBLE
ra0RA coordinate of pixel (1,1).DOUBLE
ra0DOUBLE
ra1RA coordinate of pixel (1,H).DOUBLE
ra1DOUBLE
ra2RA coordinate of pixel (W,H).DOUBLE
ra2DOUBLE
ra3RA coordinate of pixel (W,1).DOUBLE
ra3DOUBLE
ra_boreTelescope boresight RA of this exposure (deg).DOUBLE
ra_boreDOUBLE
ra_centerDOUBLE
ra_centerRA coordinate of CCD center.DOUBLE
sig1REAL
sig1Median per-pixel error standard deviation, in nanomaggies.REAL
skyrmsREAL
skyrmsSky rms for the entire image (in counts).REAL
stdskyREAL
stdskyStandard deviation of our sky level.REAL
tileebvMean SFD98 E(B-V) extinction in the tile, 0 for data from programs other than BASS, MzLS or DECaLS.REAL
tileebvREAL
tileidTile number, 0 for data from programs other than MzLS or DECaLS.INTEGER
tileidINTEGER
tilepassSMALLINT
tilepassTile pass number, 1, 2 or 3, if this was an MzLS or DECaLS observation, or 0 for data from other programs. Set by the observers.SMALLINT
widthSMALLINT
widthWidth in pixels of this image, e.g. 2046.SMALLINT
wise_extinction_1REAL
wise_extinction_1Extinction for WISE band W1.REAL
wise_extinction_2REAL
wise_extinction_2Extinction for WISE band W2.REAL
wise_extinction_3Extinction for WISE band W3.REAL
wise_extinction_3REAL
wise_extinction_4REAL
wise_extinction_4Extinction for WISE band W4.REAL
yshiftSMALLINT
yshiftIgnore value. It is always False/0.SMALLINT
zptREAL
zptMedian zero point for the entire image (median of all CCDs of the image), e.g. 25.0927.REAL