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

Table: ls_dr3.ccds_annotated
(The bold columns are indexed columns)
Column NameDescriptionDatatype
airmassAiremass, e.g. 1.35REAL
arawgainAverage gain for this CCD, eg 4.34.REAL
avskyAverage sky level in this image, in ADU, eg 36.9324REAL
blacklist_okWe blacklisted certain programs (Proposal IDs) from other PIs where there were a large number of images covering a single patch of sky, because our pipeline code did not handle the extreme depth very well. True if this CCD was not blacklisted, ie, was used.SMALLINT
cameraThe camera that took this image, e.g. decamCHAR
ccddecoffMedian astrometric offset for the CCD in arcsec.REAL
ccdmdncolMedian (g-i) color from the PS1 catalog of the matched stars.REAL
ccdnameCCD name (see DECam layout), e.g. N10 or S7CHAR
ccdnmatchNumber of stars matched to PS1 catalog of matched starsSMALLINT
ccdnmatchaNumber of stars in amp A matchedSMALLINT
ccdnmatchbNumber of stars in amp B matchedSMALLINT
ccdnstarNumber of stars founds on the CCDSMALLINT
ccdnumCCD number (see DECam layout), eg 1SMALLINT
ccdphoff(ignore)REAL
ccdphrmsPhotometric rms for the CCD (in mag).REAL
ccdraoffMedian astrometric offset for the CCD 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
ccdskymagMean sky background in AB mag/arcsec^2 on each CCDREAL
ccdskyrmsSky rms (in counts)REAL
ccdtransp(ignore)REAL
ccdzptZeropoint for the CCD (AB mag).REAL
ccdzptaZeropoint for amp A (AB mag).REAL
ccdzptbZeropoint for amp B (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
date_obsDate of observation start, eg 2014-08-15. Can be combined with ut, or use mjd_obs insteadCHAR
ddecMaximum distance from RA,Dec center to the edge midpoints, in DecREAL
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 coord of CCD centerDOUBLE
decam_extinction_1Extinction for DECam filter uREAL
decam_extinction_2Extinction for DECam filter gREAL
decam_extinction_3Extinction for DECam filter rREAL
decam_extinction_4Extinction for DECam filter iREAL
decam_extinction_5Extinction for DECam filter zREAL
decam_extinction_6Extinction for DECam filter YREAL
draMaximum distance from RA,Dec center to the edge midpoints, in RAREAL
ebvSFD E(B-V) extinction for CCD centerREAL
expidExposure ID string, e.g. 00348224-S29 (from expnum and ccdname)CHAR
expnumUnique DECam exposure number, e.g. 348244INTEGER
exptimeExposure time in seconds, e.g. 30REAL
filterFilter used for observation, e.g. g, r, zCHAR
fwhm[use seeing instead]REAL
galdepth5-sigma galaxy (0.45 arcsec round exp) detection depth in AB magREAL
galnorm_meanNorm of the PSF model convolved by a 0.45 arcsec exponential galaxyREAL
galnorm_stdStandard deviation of galaxy normREAL
gaussgaldepth5-sigma galaxy detection depth in AB mag, using Gaussian PSF approximationREAL
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).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
haHour angle of the observation (HH:MM:SS)CHAR
heightHeight in pixels of this image, eg 4096.SMALLINT
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
humidityPercent humidity outsideREAL
image_filenamePath to FITS image, eg decam/CP20140810_g_v2/c4d_140815_235218_ooi_g_v2.fits.fz.CHAR
image_hduFITS HDU number in the image_filename file where this image can be found.SMALLINT
maxskyMax of our sky levelREAL
meanskyOur pipeline (not the CP) estimate of the sky level, average over the image, in ADUREAL
minskyMin of our sky levelREAL
mjd_obsDate of observation in MJD (in UTC system), eg 56884.99373389.DOUBLE
nest256HEALPIX index (Nsides 256 => ~14 arcmin size)INTEGER
objectName listed in the object tag from the CCD headerCHAR
outtempOutside temperature (deg C)REAL
photometricTrue if this CCD was considered photometric and used in the DR3 reductionsSMALLINT
pixscale_maxMax of pixel scaleREAL
pixscale_meanPixel scale (via sqrt of area of a 10x10 pixel patch evaluated in a 5x5 grid across the image), in arcsec/pixelREAL
pixscale_minMin of pixel scaleREAL
pixscale_stdStandard deviation of pixel scaleREAL
plverCommunity Pipeline (CP) PLVER version stringCHAR
propidNOAO Proposal ID that took this image, eg 2014B-0404.CHAR
psf_aPSF model major axis (pixels)REAL
psf_bPSF model minor axis (pixels)REAL
psf_ellPSF ellipticity 1 - minor/majorREAL
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 modelREAL
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 coord of CCD centerDOUBLE
ring256HEALPIX index (Nsides 256 => ~14 arcmin size)INTEGER
seeingSeeing in arcseconds determined by fitting a 2-dimensional gaussian to the median PSF of stars on the CCD, eg 1.1019.REAL
sig1Median per-pixel error standard deviation, in nanomaggiesREAL
stdskyStandard deviation of our sky levelREAL
tempOutside temperature in C listed in the OUTTEMP tag in the CCD image header.REAL
tileebvMean SFD E(B-V) extinction in the DECaLS tile, or 0 for non-DECaLS dataREAL
tileidDECaLS tile number, if this was a DECaLS observation; or 0 for data from other programsINTEGER
tilepassDECaLS tile pass number, 1, 2 or 3, if this was a DECaLS observation, or 0 for data from other programs. Set by the observers; pass 1 is supposed to be photometric with good seeing, pass 3 unphotometric or bad seeing, and pass 2 in between.SMALLINT
utTime of observation start, eg 23:50:58.608241.CHAR
widthWidth in pixels of this image, eg 2046.SMALLINT
wise_extinction_1Extinction for WISE bands W1REAL
wise_extinction_2Extinction for WISE bands W2REAL
wise_extinction_3Extinction for WISE bands W3REAL
wise_extinction_4Extinction for WISE bands W4REAL
zptMedian zero point for the entire image (median of all CCDs of the image), eg 25.0927.REAL