Choose a database in the left panel then select the table you want!
Table: ls_dr8.ccds_annotated
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| airmass | Airmass of observation (measured at the telescope bore-sight). | REAL |
| annotated | True/1 unless there is an error when computing the "annotated" quantities in this row of the file. | SMALLINT |
| camera | The camera that took this image, e.g. decam. | VARCHAR |
| ccd_cuts | Ignore. | INTEGER |
| ccddecoff | Median astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec. | REAL |
| ccddecrms | RMS in astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec. | REAL |
| ccdname | CCD name: e.g. "N10", "S7" for DECam; "CCD3" for Mosaic, 90prime. | VARCHAR |
| ccdnastrom | Number of stars (after sigma-clipping) used to compute astrometric correction. | SMALLINT |
| ccdnphotom | Number of Gaia+PS1 stars detected with signal-to-noise ratio greater than five. | SMALLINT |
| ccdphrms | Photometric rms for the CCD (in mag). | REAL |
| ccdraoff | Median astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec. | REAL |
| ccdrarms | RMS in astrometric offset for the CCD (GAIA - Legacy Survey) in arcsec. | 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 |
| ccdskysb | Sky surface brightness (in AB mag/arcsec2). | REAL |
| ccdzpt | Zeropoint for the CCD (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 |
| 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 coordinate of CCD center. | DOUBLE |
| decam_extinction_1 | Extinction for optical filter u. | REAL |
| decam_extinction_2 | Extinction for optical filter g. | REAL |
| decam_extinction_3 | Extinction for optical filter r. | REAL |
| decam_extinction_4 | Extinction for optical filter i. | REAL |
| decam_extinction_5 | Extinction for optical filter z. | REAL |
| decam_extinction_6 | Extinction for optical filter Y. | REAL |
| dra | Maximum distance from RA,Dec center to the edge midpoints, in RA. | REAL |
| ebv | SFD98 E(B-V) extinction for CCD center. | REAL |
| expnum | Unique DECam exposure number, e.g. 348244. | BIGINT |
| exptime | Exposure time in seconds, e.g. 30. | REAL |
| filter | Filter used for observation, e.g. g, r, z. | CHAR |
| fwhm | FWHM (in pixels) measured by the CP. | REAL |
| galdepth | 5-sigma galaxy (0.45" round exp) detection depth in AB mag. | REAL |
| galnorm_mean | Norm of the PSF model convolved by a 0.45" 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). x0 value. | SMALLINT |
| good_region_2 | 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). x1 value. | SMALLINT |
| good_region_3 | 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). y0 value. | SMALLINT |
| good_region_4 | 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). y1 value. | SMALLINT |
| height | Height in pixels of this image, e.g. 4096. | SMALLINT |
| humidity | Percent humidity outside. | REAL |
| image_filename | Path to FITS image, e.g. decam/CP20140810_g_v2/c4d_140815_235218_ooi_g_v2.fits.fz. | VARCHAR |
| image_hdu | FITS HDU number in the image_filename file where this image can be found. | SMALLINT |
| ls_ccd_id | Unique ID for all CCDs, composed from camera name, ccd name and exposure number. | BIGINT |
| 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), e.g. 56884.99373389. | DOUBLE |
| object | Name listed in the object tag from the CCD header. | VARCHAR |
| outtemp | Outside temperate (deg C). | REAL |
| 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 |
| plprocid | Unique, time-based, CP processing hash. | VARCHAR |
| plver | Community Pipeline (CP) PLVER version string. | VARCHAR |
| procdate | CP processing date. | VARCHAR |
| propid | NOAO Proposal ID that took this image, e.g. 2014B-0404. | VARCHAR |
| 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 coordinate of CCD center. | DOUBLE |
| sig1 | Median per-pixel error standard deviation, in nanomaggies. | REAL |
| skyrms | Sky rms for the entire image (in counts). | REAL |
| stdsky | Standard deviation of our sky level. | REAL |
| tileebv | Mean SFD98 E(B-V) extinction in the tile, 0 for data from programs other than BASS, MzLS or DECaLS. | REAL |
| tileid | Tile number, 0 for data from programs other than MzLS or DECaLS. | INTEGER |
| tilepass | Tile 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 |
| width | Width in pixels of this image, e.g. 2046. | SMALLINT |
| wise_extinction_1 | Extinction for WISE band W1. | REAL |
| wise_extinction_2 | Extinction for WISE band W2. | REAL |
| wise_extinction_3 | Extinction for WISE band W3. | REAL |
| wise_extinction_4 | Extinction for WISE band W4. | REAL |
| yshift | Ignore value. It is always False/0. | SMALLINT |
| zpt | Median zero point for the entire image (median of all CCDs of the image), e.g. 25.0927. | REAL |
