Choose a database in the left panel then select the table you want!
Table: ls_dr10.bricks_s
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| area | Area of the brick in square degrees | DOUBLE |
| brickid | A unique integer with 1-to-1 mapping to brickname | INTEGER |
| brickname | Name of the brick | VARCHAR |
| cosky_g | Estimated sky level in the coadded images (stacks) in g-band | REAL |
| cosky_i | Estimated sky level in the coadded images (stacks) in i-band | REAL |
| cosky_r | Estimated sky level in the coadded images (stacks) in r-band | REAL |
| cosky_z | Estimated sky level in the coadded images (stacks) in z-band | REAL |
| dec | DEC of the center of the brick | DOUBLE |
| dec1 | Lower Dec boundary | DOUBLE |
| dec2 | Upper Dec boundary | DOUBLE |
| ebv | Median SFD98 dust map E(B-V) extinction, in magnitudes, evaluated at BRICK_PRIMARY objects in this brick | REAL |
| ext_g | Extinction in g-band | REAL |
| ext_i | Extinction in i-band | REAL |
| ext_r | Extinction in r-band | REAL |
| ext_w1 | Extinction in W1-band | REAL |
| ext_w2 | Extinction in W2-band | REAL |
| ext_w3 | Extinction in W3-band | REAL |
| ext_w4 | Extinction in W4-band | REAL |
| ext_z | Extinction in z-band | REAL |
| galdepth_g | 5-sigma galaxy (0.45arcs round exp) detection depth in g-band (AB) mag | REAL |
| galdepth_i | 5-sigma galaxy (0.45arcs round exp) detection depth in i-band (AB) mag | REAL |
| galdepth_r | 5-sigma galaxy (0.45arcs round exp) detection depth in r-band (AB) mag | REAL |
| galdepth_z | 5-sigma galaxy (0.45arcs round exp) detection depth in z-band (AB) mag | REAL |
| in_desi | True if the brick is in the DESI footprint | SMALLINT |
| ncomp | Total number of BRICK_PRIMARY objects in this brick, of type COMP (there should be 0 such objects) | INTEGER |
| ndev | Total number of BRICK_PRIMARY objects in this brick, of type DEV | INTEGER |
| ndup | Total number of BRICK_PRIMARY objects in this brick, of type DUP | INTEGER |
| nexp | Total number of BRICK_PRIMARY objects in this brick, of type EXP | INTEGER |
| nexp_g | Median number of exposures in the unique area (i.e. BRICK_PRIMARY area) of the brick in g-band | SMALLINT |
| nexp_i | Median number of exposures in the unique area (i.e. BRICK_PRIMARY area) of the brick in i-band | SMALLINT |
| nexp_r | Median number of exposures in the unique area (i.e. BRICK_PRIMARY area) of the brick in r-band | SMALLINT |
| nexp_z | Median number of exposures in the unique area (i.e. BRICK_PRIMARY area) of the brick in z-band | SMALLINT |
| nexphist_g_1 | Histogram of number of pixels in the unique brick area with 0 exposures in g | INTEGER |
| nexphist_g_10 | Histogram of number of pixels in the unique brick area with 9 exposures in g | INTEGER |
| nexphist_g_11 | Histogram of number of pixels in the unique brick area with 10 exposures in g | INTEGER |
| nexphist_g_2 | Histogram of number of pixels in the unique brick area with 1 exposures in g | INTEGER |
| nexphist_g_3 | Histogram of number of pixels in the unique brick area with 2 exposures in g | INTEGER |
| nexphist_g_4 | Histogram of number of pixels in the unique brick area with 3 exposures in g | INTEGER |
| nexphist_g_5 | Histogram of number of pixels in the unique brick area with 4 exposures in g | INTEGER |
| nexphist_g_6 | Histogram of number of pixels in the unique brick area with 5 exposures in g | INTEGER |
| nexphist_g_7 | Histogram of number of pixels in the unique brick area with 6 exposures in g | INTEGER |
| nexphist_g_8 | Histogram of number of pixels in the unique brick area with 7 exposures in g | INTEGER |
| nexphist_g_9 | Histogram of number of pixels in the unique brick area with 8 exposures in g | INTEGER |
| nexphist_i_1 | Histogram of number of pixels in the unique brick area with 0 exposures in i | INTEGER |
| nexphist_i_10 | Histogram of number of pixels in the unique brick area with 9 exposures in i | INTEGER |
| nexphist_i_11 | Histogram of number of pixels in the unique brick area with 10 exposures in i | INTEGER |
| nexphist_i_2 | Histogram of number of pixels in the unique brick area with 2 exposures in i | INTEGER |
| nexphist_i_3 | Histogram of number of pixels in the unique brick area with 3 exposures in i | INTEGER |
| nexphist_i_4 | Histogram of number of pixels in the unique brick area with 4 exposures in i | INTEGER |
| nexphist_i_5 | Histogram of number of pixels in the unique brick area with 5 exposures in i | INTEGER |
| nexphist_i_6 | Histogram of number of pixels in the unique brick area with 6 exposures in i | INTEGER |
| nexphist_i_7 | Histogram of number of pixels in the unique brick area with 7 exposures in i | INTEGER |
| nexphist_i_8 | Histogram of number of pixels in the unique brick area with 8 exposures in i | INTEGER |
| nexphist_i_9 | Histogram of number of pixels in the unique brick area with 8 exposures in i | INTEGER |
| nexphist_r_1 | Histogram of number of pixels in the unique brick area with 0 exposures in r | INTEGER |
| nexphist_r_10 | Histogram of number of pixels in the unique brick area with 9 exposures in r | INTEGER |
| nexphist_r_11 | Histogram of number of pixels in the unique brick area with 10 exposures in r | INTEGER |
| nexphist_r_2 | Histogram of number of pixels in the unique brick area with 1 exposures in r | INTEGER |
| nexphist_r_3 | Histogram of number of pixels in the unique brick area with 2 exposures in r | INTEGER |
| nexphist_r_4 | Histogram of number of pixels in the unique brick area with 3 exposures in r | INTEGER |
| nexphist_r_5 | Histogram of number of pixels in the unique brick area with 4 exposures in r | INTEGER |
| nexphist_r_6 | Histogram of number of pixels in the unique brick area with 5 exposures in r | INTEGER |
| nexphist_r_7 | Histogram of number of pixels in the unique brick area with 6 exposures in r | INTEGER |
| nexphist_r_8 | Histogram of number of pixels in the unique brick area with 7 exposures in r | INTEGER |
| nexphist_r_9 | Histogram of number of pixels in the unique brick area with 8 exposures in r | INTEGER |
| nexphist_z_1 | Histogram of number of pixels in the unique brick area with 0 exposures in z | INTEGER |
| nexphist_z_10 | Histogram of number of pixels in the unique brick area with 9 exposures in z | INTEGER |
| nexphist_z_11 | Histogram of number of pixels in the unique brick area with 10 exposures in z | INTEGER |
| nexphist_z_2 | Histogram of number of pixels in the unique brick area with 1 exposures in z | INTEGER |
| nexphist_z_3 | Histogram of number of pixels in the unique brick area with 2 exposures in z | INTEGER |
| nexphist_z_4 | Histogram of number of pixels in the unique brick area with 3 exposures in z | INTEGER |
| nexphist_z_5 | Histogram of number of pixels in the unique brick area with 4 exposures in z | INTEGER |
| nexphist_z_6 | Histogram of number of pixels in the unique brick area with 5 exposures in z | INTEGER |
| nexphist_z_7 | Histogram of number of pixels in the unique brick area with 6 exposures in z | INTEGER |
| nexphist_z_8 | Histogram of number of pixels in the unique brick area with 7 exposures in z | INTEGER |
| nexphist_z_9 | Histogram of number of pixels in the unique brick area with 8 exposures in z | INTEGER |
| nobjs | Total number of BRICK_PRIMARY objects in this brick, of all types | INTEGER |
| npsf | Total number of BRICK_PRIMARY objects in this brick, of type PSF | INTEGER |
| nrex | Total number of BRICK_PRIMARY objects in this brick, of type REX | INTEGER |
| nser | Total number of BRICK_PRIMARY objects in this brick, of type SER | INTEGER |
| nsimp | Total number of BRICK_PRIMARY objects in this brick, of type SIMP (there should be 0 such objects) | INTEGER |
| psfdepth_g | 5-sigma PSF detection depth in g-band (AB mag), using PsfEx PSF model | REAL |
| psfdepth_i | 5-sigma PSF detection depth in i-band (AB mag), using PsfEx PSF model | REAL |
| psfdepth_r | 5-sigma PSF detection depth in r-band (AB mag), using PsfEx PSF model | REAL |
| psfdepth_z | 5-sigma PSF detection depth in z-band (AB mag), using PsfEx PSF model | REAL |
| psfsize_g | Median PSF size, in arcsec, evaluated at the BRICK_PRIMARY objects in this brick in g-band | REAL |
| psfsize_i | Median PSF size, in arcsec, evaluated at the BRICK_PRIMARY objects in this brick in i-band | REAL |
| psfsize_r | Median PSF size, in arcsec, evaluated at the BRICK_PRIMARY objects in this brick in r-band | REAL |
| psfsize_z | Median PSF size, in arcsec, evaluated at the BRICK_PRIMARY objects in this brick in z-band | REAL |
| ra | RA of the center of the brick | DOUBLE |
| ra1 | Lower RA boundary | DOUBLE |
| ra2 | Upper RA boundary | DOUBLE |
| survey_primary | True for northern (southern) bricks that lie in the northern (southern) region of the Legacy Surveys | SMALLINT |
| trans_g | Median Milky Way dust transparency in g-band, based on ebv. See also MW_TRANSMISSION_G | REAL |
| trans_i | Median Milky Way dust transparency in i-band, based on ebv. See also MW_TRANSMISSION_I | REAL |
| trans_r | Median Milky Way dust transparency in r-band, based on ebv. See also MW_TRANSMISSION_R | REAL |
| trans_wise_1 | Median Milky Way dust transparency in W1, based on ebv. See also, e.g., MW_TRANSMISSION_W1 | REAL |
| trans_wise_2 | Median Milky Way dust transparency in W2, based on ebv. See also, e.g., MW_TRANSMISSION_W2 | REAL |
| trans_wise_3 | Median Milky Way dust transparency in W3, based on ebv. See also, e.g., MW_TRANSMISSION_W3 | REAL |
| trans_wise_4 | Median Milky Way dust transparency in W4, based on ebv. See also, e.g., MW_TRANSMISSION_W4 | REAL |
| trans_z | Median Milky Way dust transparency in z-band, based on ebv. See also MW_TRANSMISSION_Z | REAL |
| wise_nobs_1 | Number of images that contributed to WISE calculations in W1 (not profile-weighted) | SMALLINT |
| wise_nobs_2 | Number of images that contributed to WISE calculations in W2 (not profile-weighted) | SMALLINT |
| wise_nobs_3 | Number of images that contributed to WISE calculations in W3 (not profile-weighted) | SMALLINT |
| wise_nobs_4 | Number of images that contributed to WISE calculations in W4 (not profile-weighted) | SMALLINT |
