Choose a database in the left panel then select the table you want!
Table: decaps_dr1.ccds
(The bold columns are indexed columns)
Column Name | Description | Datatype |
---|---|---|
airmass | Airmass extinction | DOUBLE[] |
arawgain | Average gain for this CCD | DOUBLE[] |
avsky | Average sky level in this image (ADU) | DOUBLE[] |
brick_x0 | Brick region start x | SMALLINT |
brick_x1 | Brick region end x | SMALLINT |
brick_y0 | Brick region start y | SMALLINT |
brick_y1 | Brick region end y | SMALLINT |
camera | The camera that took this image | VARCHAR |
ccd_x0 | Physical array start x | SMALLINT |
ccd_x1 | Physical array end x | SMALLINT |
ccd_y0 | Physical array start y | SMALLINT |
ccd_y1 | Physical array end y | SMALLINT |
ccddecoff | Median astrometric offset for the CCD in arcsec | REAL |
ccdname | CCD name (see DECam layout) | VARCHAR |
ccdnmatch | Number of stars matched to PS1 catalog of matched stars | INTEGER |
ccdnum | CCD number (see DECam layout) | BIGINT |
ccdraoff | Median astrometric offset for the CCD in arcsec | REAL |
ccdzpt | Zero point for the CCD (AB mag) | DOUBLE[] |
cd1_1 | Astrometric header value: transformation matrix | DOUBLE[] |
cd1_2 | Astrometric header value: transformation matrix | DOUBLE[] |
cd2_1 | Astrometric header value: transformation matrix | DOUBLE[] |
cd2_2 | Astrometric header value: transformation matrix | DOUBLE[] |
crpix1 | Astrometric header value: X reference pixel | DOUBLE[] |
crpix2 | Astrometric header value: Y reference pixel | DOUBLE[] |
crval1 | Astrometric header value: RA of reference pixel | DOUBLE[] |
crval2 | Astrometric header value: Dec of reference pixel | DOUBLE[] |
date_obs | Date of observation start | VARCHAR |
dec | Approximate declination center of this CCD (deg) | DOUBLE[] |
dec_bore | Telescope boresight Dec of this exposure (deg) | DOUBLE[] |
expnum | Unique DECam exposure number | BIGINT |
exptime | Exposure time (sec) | DOUBLE[] |
extname | Extension name | VARCHAR |
filter | Filter used for observation | CHAR |
fwhm | [Use seeing instead] | DOUBLE[] |
galnorm | Norm of the PSF model convolved by a 0.45 arcsec exponential galaxy | REAL |
height | Height of the image (pixels) | BIGINT |
image_filename | Path to FITS image | VARCHAR |
image_hdu | FITS HDU number in the image_filename file where this image can be found | BIGINT |
mjd_obs | Date of observation in MJD (in UTC system) | DOUBLE[] |
object | Name listed in the object tag from the CCD header | VARCHAR |
plver | Commuity Pipeline (CP) version number | VARCHAR |
propid | Propsal ID | VARCHAR |
psfnorm | PSF norm = 1/sqrt of N_eff = sqrt(sum(psf_i^2)) for normalized PSF pixels i | DOUBLE[] |
psfplver | PSF Community Pipeline (CP) version number | CHAR |
psfver | Version of the fits format for this PSFTYPE | CHAR |
ra | Approximate right ascension center of this CCD (deg) | DOUBLE[] |
ra_bore | Telescope boresight RA of this exposure (deg) | DOUBLE[] |
seeing | Seeing in arcseconds determined by fitting a 2-dimensional gaussian to the median PSF of stars on the CCD | DOUBLE[] |
sig1 | Median per-pixel error standard deviation, in nanomaggies | DOUBLE[] |
skyplver | Sky Community Pipeline (CP) version number | VARCHAR |
skyver | Sky version | CHAR |
wcsplver | WCS Community Pipeline (CP) version number | VARCHAR |
wcsver | WCS version | CHAR |
width | Width of the image (pixels) | BIGINT |
zpscatter | Zero point scatter | DOUBLE[] |
zpt | Median zero point for the entire image (median of all CCDs of the image) | DOUBLE[] |