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
airmassAirmass of observation (measured at the telescope bore-sight).REAL
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)
ccd_cutsIgnore.INTEGER
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
ccdnameCCD name: e.g. "N10", "S7" for DECam; "CCD3" for Mosaic, 90prime.VARCHAR(n)
ccdnastromNumber of stars (after sigma-clipping) used to compute astrometric correction.SMALLINT
ccdnphotomNumber of Gaia+PS1 stars detected with signal-to-noise ratio greater than five.SMALLINT
ccdphrmsPhotometric rms for the CCD (in mag).REAL
ccdraoffMedian astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec.REAL
ccdrarmsRMS in astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec.REAL
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
ccdskysbSky surface brightness (in AB mag/arcsec2).REAL
ccdzptZeropoint for the CCD (AB mag).REAL
cd1_1Astrometric header value: transformation matrix.REAL
cd1_2Astrometric header value: transformation matrix.REAL
cd2_1Astrometric header value: transformation matrix.REAL
cd2_2Astrometric header value: transformation matrix.REAL
crpix1Astrometric header value: X reference pixel.REAL
crpix2Astrometric header value: Y reference pixel.REAL
crval1Astrometric header value: RA of reference pixel.DOUBLE
crval2Astrometric header value: Dec of reference pixel.DOUBLE
ddecMaximum distance from RA,Dec center to the edge midpoints, in Dec.REAL
decApproximate Dec center of this CCD (deg).DOUBLE
dec0Dec coordinate of pixel (1,1).DOUBLE
dec1Dec coordinate of pixel (1,H).DOUBLE
dec2Dec coordinate of pixel (W,H).DOUBLE
dec3Dec coordinate of pixel (W,1).DOUBLE
dec_boreTelescope boresight Dec of this exposure (deg).DOUBLE
dec_centerDec coordinate of CCD center.DOUBLE
decam_extinction_1Extinction for optical filter u.REAL
decam_extinction_2Extinction for optical filter g.REAL
decam_extinction_3Extinction for optical filter r.REAL
decam_extinction_4Extinction for optical filter i.REAL
decam_extinction_5Extinction for optical filter z.REAL
decam_extinction_6Extinction for optical filter Y.REAL
draMaximum distance from RA,Dec center to the edge midpoints, in RA.REAL
ebvSFD98 E(B-V) extinction for CCD center.REAL
expnumUnique DECam exposure number, e.g. 348244.BIGINT
exptimeExposure time in seconds, e.g. 30.REAL
filterFilter used for observation, e.g. g, r, z.CHAR
fwhmFWHM (in pixels) measured by the CP.REAL
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_stdStandard deviation of galaxy norm.REAL
gaussgaldepth5-sigma galaxy detection depth in AB mag, using Gaussian PSF approximation.REAL
gausspsfdepth5-sigma PSF detection depth in AB mag, using Gaussian PSF approximation (using seeing value).REAL
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_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_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
humidityPercent humidity outside.REAL
image_filenamePath to FITS image, e.g. decam/CP20140810_g_v2/c4d_140815_235218_ooi_g_v2.fits.fz.VARCHAR(n)
image_hduFITS HDU number in the image_filename file where this image can be found.SMALLINT
ls_ccd_idUnique ID for all CCDs, composed from camera name, ccd name and exposure number.BIGINT
maxskyMax of our sky level.REAL
meanskyOur pipeline (not the CP) estimate of the sky level, average over the image, in ADU.REAL
minskyMin of our sky level.REAL
mjd_obsDate of observation in MJD (in UTC system), e.g. 56884.99373389.DOUBLE
objectName listed in the object tag from the CCD header.VARCHAR(n)
outtempOutside temperate (deg C).REAL
pixscale_maxMax of pixel scale.REAL
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_stdStandard deviation of pixel scale.REAL
plprocidUnique, time-based, CP processing hash.VARCHAR(n)
plverCommunity Pipeline (CP) PLVER version string.VARCHAR(n)
procdateCP processing date.VARCHAR(n)
propidNOAO Proposal ID that took this image, e.g. 2014B-0404.VARCHAR(n)
psf_aPSF model major axis (pixels).REAL
psf_bPSF model minor axis (pixels).REAL
psf_ellPSF ellipticity 1 - minor/major.REAL
psf_mx2PSF model second moment in x (pixels^2).REAL
psf_mxyPSF model second moment in x-y (pixels^2).REAL
psf_my2PSF model second moment in y (pixels^2).REAL
psf_thetaPSF position angle (deg).REAL
psfdepth5-sigma PSF detection depth in AB mag, using PsfEx PSF model.REAL
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_stdStandard deviation of PSF normREAL
raApproximate RA center of this CCD (deg).DOUBLE
ra0RA coordinate of pixel (1,1).DOUBLE
ra1RA coordinate of pixel (1,H).DOUBLE
ra2RA coordinate of pixel (W,H).DOUBLE
ra3RA coordinate of pixel (W,1).DOUBLE
ra_boreTelescope boresight RA of this exposure (deg).DOUBLE
ra_centerRA coordinate of CCD center.DOUBLE
sig1Median per-pixel error standard deviation, in nanomaggies.REAL
skyrmsSky rms for the entire image (in counts).REAL
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
tileidTile number, 0 for data from programs other than MzLS or DECaLS.INTEGER
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
widthWidth in pixels of this image, e.g. 2046.SMALLINT
wise_extinction_1Extinction for WISE band W1.REAL
wise_extinction_2Extinction for WISE band W2.REAL
wise_extinction_3Extinction for WISE band W3.REAL
wise_extinction_4Extinction for WISE band W4.REAL
yshiftIgnore value. It is always False/0.SMALLINT
zptMedian zero point for the entire image (median of all CCDs of the image), e.g. 25.0927.REAL