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 |
