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 |
