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

(The bold columns are indexed columns)
Column NameDescriptionDatatype
bricknameName of brick, encoding the brick sky position, e.g. 1126p222 near RA=112.6, Dec=+22.2VARCHAR(n)
decDeclination at epoch J2000DOUBLE
ebvGalactic extinction \(E(B-V)\) reddening from SFD98, used to compute DECAM_MW_TRANSMISSION and WISE_MW_TRANSMISSIONREAL
ext_gExtinction in g-bandREAL
ext_rExtinction in r-bandREAL
ext_w1Extinction in W1REAL
ext_w2Extinction in W1REAL
ext_w3Extinction in W1REAL
ext_w4Extinction in W1REAL
ext_zExtinction in z-bandREAL
galdepth_gAs for PSFDEPTH_G but for a galaxy (0.45 arcsec exp, round) detection sensitivityREAL
galdepth_rAs for PSFDEPTH_R but for a galaxy (0.45 arcsec exp, round) detection sensitivityREAL
galdepth_zAs for PSFDEPTH_Z but for a galaxy (0.45 arcsec exp, round) detection sensitivityREAL
ncompTotal number of BRICK_UNIQUE objects in this brick of COMP typesSMALLINT
ndevTotal number of BRICK_UNIQUE objects in this brick of DEV typesSMALLINT
nexpTotal number of BRICK_UNIQUE objects in this brick of EXP typesSMALLINT
nexp_gMedian number of exposures in the unique are (i.e. BRICK_PRIMARY area) of the brick in the g-bandSMALLINT
nexp_rMedian number of exposures in the unique are (i.e. BRICK_PRIMARY area) of the brick in the r-bandSMALLINT
nexp_zMedian number of exposures in the unique are (i.e. BRICK_PRIMARY area) of the brick in the z-bandSMALLINT
nexphist_g_1Histogram of number of pixels in the unique brick area with 0,1,2,3,4 or 5 exposures in gINTEGER
nexphist_g_2INTEGER
nexphist_g_3INTEGER
nexphist_g_4INTEGER
nexphist_g_5INTEGER
nexphist_g_6INTEGER
nexphist_r_1Histogram of number of pixels in the unique brick area with 0,1,2,3,4 or 5 exposures in rINTEGER
nexphist_r_2INTEGER
nexphist_r_3INTEGER
nexphist_r_4INTEGER
nexphist_r_5INTEGER
nexphist_r_6INTEGER
nexphist_z_1Histogram of number of pixels in the unique brick area with 0,1,2,3,4 or 5 exposures in zINTEGER
nexphist_z_2INTEGER
nexphist_z_3INTEGER
nexphist_z_4INTEGER
nexphist_z_5INTEGER
nexphist_z_6INTEGER
nobjsTotal number of BRICK_UNIQUE objects in this brick of all typesSMALLINT
npsfTotal number of BRICK_UNIQUE objects in this brick of PSF typesSMALLINT
nrexTotal number of BRICK_UNIQUE objects in this brick, of type REXSMALLINT
nsimpTotal number of BRICK_UNIQUE objects in this brick of SIMP typesSMALLINT
psfdepth_gFor a \(5\sigma\) point source detection limit in \(g\), \(5/\sqrt(\mathrm{PSFDEPTH\_G})\) gives flux in nanomaggies and \(-2.5[\log_{10}(5 / \sqrt(\mathrm{PSFDEPTH\_G})) - 9]\) gives corresponding magnitudeREAL
psfdepth_rFor a \(5\sigma\) point source detection limit in \(g\), \(5/\sqrt(\mathrm{PSFDEPTH\_R})\) gives flux in nanomaggies and \(-2.5[\log_{10}(5 / \sqrt(\mathrm{PSFDEPTH\_R})) - 9]\) gives corresponding magnitudeREAL
psfdepth_zFor a \(5\sigma\) point source detection limit in \(g\), \(5/\sqrt(\mathrm{PSFDEPTH\_Z})\) gives flux in nanomaggies and \(-2.5[\log_{10}(5 / \sqrt(\mathrm{PSFDEPTH\_Z})) - 9]\) gives corresponding magnitudeREAL
psfsize_gWeighted average PSF FWHM in the \(g\) bandREAL
psfsize_rWeighted average PSF FWHM in the \(r\) bandREAL
psfsize_zWeighted average PSF FWHM in the \(z\) bandREAL
raRight ascension at epoch J2000DOUBLE
trans_gMedian Milky Way dust transparency in g-band, based on ebv. See also DECAM_MW_TRANSMISSIONREAL
trans_rMedian Milky Way dust transparency in r-band, based on ebv. See also DECAM_MW_TRANSMISSIONREAL
trans_wise_1Median Milky Way dust transparency in WISE bands, based on ebv. See also, e.g., MW_TRANSMISSION_W1REAL
trans_wise_2Median Milky Way dust transparency in WISE bands, based on ebv. See also, e.g., MW_TRANSMISSION_W1REAL
trans_wise_3Median Milky Way dust transparency in WISE bands, based on ebv. See also, e.g., MW_TRANSMISSION_W1REAL
trans_wise_4Median Milky Way dust transparency in WISE bands, based on ebv. See also, e.g., MW_TRANSMISSION_W1REAL
trans_zMedian Milky Way dust transparency in z-band, based on ebv. See also DECAM_MW_TRANSMISSIONREAL
wise_nobs_1Number of images that contributed to WISE calculations in each filter (not profile-weighted)SMALLINT
wise_nobs_2Number of images that contributed to WISE calculations in each filter (not profile-weighted)SMALLINT
wise_nobs_3Number of images that contributed to WISE calculations in each filter (not profile-weighted)SMALLINT
wise_nobs_4Number of images that contributed to WISE calculations in each filter (not profile-weighted)SMALLINT