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

(The bold columns are indexed columns)

Column Name | Description | Datatype |
---|---|---|

airmass | Airemass, e.g. 1.35 | REAL |

arawgain | Average gain for this CCD, eg 4.34. | REAL |

avsky | Average sky level in this image, in ADU, eg 36.9324 | REAL |

camera | The camera that took this image, e.g. decam | CHAR |

ccddecoff | Median astrometric offset for the CCD | REAL |

ccddecrms | rms in astrometric offset for the CCD | REAL |

ccdmdncol | Median (g-i) color from the PS1 catalog of the matched stars. | REAL |

ccdname | CCD name (see DECam layout), e.g. N10 or S7 | CHAR |

ccdnmatch | Number of stars matched to PS1 catalog of matched stars | SMALLINT |

ccdnmatcha | Number of stars in amp A matched | SMALLINT |

ccdnmatchb | Number of stars in amp B matched | SMALLINT |

ccdnmatchc | Number of stars in amp C matched | SMALLINT |

ccdnmatchd | Number of stars in amp D matched | SMALLINT |

ccdnstar | Number of stars founds on the CCD | SMALLINT |

ccdnum | CCD number (see DECam layout), eg 1 | SMALLINT |

ccdphoff | (ignore) | REAL |

ccdphrms | Photometric rms for the CCD (in mag). | REAL |

ccdraoff | Median astrometric offset for the CCD | REAL |

ccdrarms | rms in astrometric offset for the CCD | REAL |

ccdskycounts | Mean 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 |

ccdskymag | Mean sky background in AB mag/arcsec^2 on each CCD | REAL |

ccdskyrms | Sky rms (in counts) | REAL |

ccdtransp | (ignore) | REAL |

ccdzpt | Zeropoint for the CCD (AB mag). | REAL |

ccdzpta | Zeropoint for amp A (AB mag). | REAL |

ccdzptb | Zeropoint for amp B (AB mag). | REAL |

ccdzptc | Zeropoint for amp C (AB mag). | REAL |

ccdzptd | Zeropoint for amp D (AB mag). | REAL |

cd1_1 | Astrometric header value: transformation matrix. | REAL |

cd1_2 | Astrometric header value: transformation matrix. | REAL |

cd2_1 | Astrometric header value: transformation matrix. | REAL |

cd2_2 | Astrometric header value: transformation matrix. | REAL |

crpix1 | Astrometric header value: X reference pixel. | REAL |

crpix2 | Astrometric header value: Y reference pixel. | REAL |

crval1 | Astrometric header value: RA of reference pixel. | DOUBLE |

crval2 | Astrometric header value: Dec of reference pixel. | DOUBLE |

date_obs | Date of observation start, eg 2014-08-15. Can be combined with ut, or use mjd_obs instead | CHAR |

ddec | Maximum distance from RA,Dec center to the edge midpoints, in Dec | REAL |

dec | Approximate Dec center of this CCD (deg). | DOUBLE |

dec0 | Dec coordinate of pixel (1,1) | DOUBLE |

dec1 | Dec coordinate of pixel (1,H) | DOUBLE |

dec2 | Dec coordinate of pixel (W,H) | DOUBLE |

dec3 | Dec coordinate of pixel (W,1) | DOUBLE |

dec_bore | Telescope boresight Dec of this exposure (deg). | DOUBLE |

dec_center | Dec coord of CCD center | DOUBLE |

decam_extinction_1 | Extinction for DECam filter u | REAL |

decam_extinction_2 | Extinction for DECam filter g | REAL |

decam_extinction_3 | Extinction for DECam filter r | REAL |

decam_extinction_4 | Extinction for DECam filter i | REAL |

decam_extinction_5 | Extinction for DECam filter z | REAL |

decam_extinction_6 | Extinction for DECam filter Y | REAL |

dra | Maximum distance from RA,Dec center to the edge midpoints, in RA | REAL |

ebv | SFD E(B-V) extinction for CCD center | REAL |

expid | Exposure ID string, e.g. 00348224-S29 (from expnum and ccdname) | CHAR |

expnum | Unique DECam exposure number, e.g. 348244 | INTEGER |

exptime | Exposure time in seconds, e.g. 30 | REAL |

filter | Filter used for observation, e.g. g, r, z | CHAR |

fwhm | [use seeing instead] | REAL |

galdepth | 5-sigma galaxy (0.45 arcsec round exp) detection depth in AB mag | REAL |

galnorm_mean | Norm of the PSF model convolved by a 0.45 arcsec exponential galaxy | REAL |

galnorm_std | Standard deviation of galaxy norm | REAL |

gaussgaldepth | 5-sigma galaxy detection depth in AB mag, using Gaussian PSF approximation | REAL |

gausspsfdepth | 5-sigma PSF detection depth in AB mag, using Gaussian PSF approximation (using seeing value) | REAL |

good_region_1 | If 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_2 | SMALLINT | |

good_region_3 | SMALLINT | |

good_region_4 | SMALLINT | |

ha | Hour angle of the observation (HH:MM:SS) | CHAR |

height | Height in pixels of this image, eg 4096. | SMALLINT |

htm9 | HTM index (order 9 => ~10 arcmin size) | BIGINT |

humidity | Percent humidity outside | REAL |

image_filename | Path to FITS image, eg decam/CP20140810_g_v2/c4d_140815_235218_ooi_g_v2.fits.fz. | CHAR |

image_hdu | FITS HDU number in the image_filename file where this image can be found. | SMALLINT |

maxsky | Max of our sky level | REAL |

meansky | Our pipeline (not the CP) estimate of the sky level, average over the image, in ADU | REAL |

minsky | Min of our sky level | REAL |

mjd_obs | Date of observation in MJD (in UTC system), eg 56884.99373389. | DOUBLE |

nest256 | HEALPIX index (Nsides 256, Nest scheme => ~52 arcsec size) | BIGINT |

object | Name listed in the object tag from the CCD header | CHAR |

outtemp | Outside temperature (deg C) | REAL |

photometric | True if this CCD was considered photometric and used in the DR3 reductions | SMALLINT |

pixscale_max | Max of pixel scale | REAL |

pixscale_mean | Pixel scale (via sqrt of area of a 10x10 pixel patch evaluated in a 5x5 grid across the image), in arcsec/pixel | REAL |

pixscale_min | Min of pixel scale | REAL |

pixscale_std | Standard deviation of pixel scale | REAL |

plver | Community Pipeline (CP) PLVER version string | CHAR |

propid | NOAO Proposal ID that took this image, eg 2014B-0404. | CHAR |

psf_a | PSF model major axis (pixels) | REAL |

psf_b | PSF model minor axis (pixels) | REAL |

psf_ell | PSF ellipticity 1 - minor/major | REAL |

psf_mx2 | PSF model second moment in x (pixels^2) | REAL |

psf_mxy | PSF model second moment in x-y (pixels^2) | REAL |

psf_my2 | PSF model second moment in y (pixels^2) | REAL |

psf_theta | PSF position angle (deg) | REAL |

psfdepth | 5-sigma PSF detection depth in AB mag, using PsfEx PSF model | REAL |

psfnorm_mean | PSF 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_std | Standard deviation of PSF norm | REAL |

ra | Approximate RA center of this CCD (deg). | DOUBLE |

ra0 | RA coordinate of pixel (1,1) | DOUBLE |

ra1 | RA coordinate of pixel (1,H) | DOUBLE |

ra2 | RA coordinate of pixel (W,H) | DOUBLE |

ra3 | RA coordinate of pixel (W,1) | DOUBLE |

ra_bore | Telescope boresight RA of this exposure (deg). | DOUBLE |

ra_center | RA coord of CCD center | DOUBLE |

ring256 | HEALPIX index (Nsides 256, Ring scheme => ~52 arcsec size) | BIGINT |

seeing | Seeing in arcseconds determined by fitting a 2-dimensional gaussian to the median PSF of stars on the CCD, eg 1.1019. | REAL |

sig1 | Median per-pixel error standard deviation, in nanomaggies | REAL |

stdsky | Standard deviation of our sky level | REAL |

temp | Outside temperature in C listed in the OUTTEMP tag in the CCD image header. | REAL |

tileebv | Mean SFD E(B-V) extinction in the DECaLS tile, or 0 for non-DECaLS data | REAL |

tileid | DECaLS tile number, if this was a DECaLS observation; or 0 for data from other programs | INTEGER |

tilepass | DECaLS 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 |

ut | Time of observation start, eg 23:50:58.608241. | CHAR |

width | Width in pixels of this image, eg 2046. | SMALLINT |

wise_extinction_1 | Extinction for WISE bands W1 | REAL |

wise_extinction_2 | Extinction for WISE bands W2 | REAL |

wise_extinction_3 | Extinction for WISE bands W3 | REAL |

wise_extinction_4 | Extinction for WISE bands W4 | REAL |

zpt | Median zero point for the entire image (median of all CCDs of the image), eg 25.0927. | REAL |