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

(The bold columns are indexed columns)

Column Name | Description | Datatype |
---|---|---|

brickname | Name of the brick | CHAR |

dec | Dec of the center of the brick | DOUBLE |

ebv | Median SFD dust map E(B-V) extinction, in magnitudes, evaluated at BRICK_UNIQUE objects in this brick | REAL |

ext_g | Extinction in g-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.45arcsec round exp) detection depth in g-band (AB) mag | REAL |

galdepth_r | 5-sigma galaxy (0.45arcsec round exp) detection depth in r-band (AB) mag | REAL |

galdepth_z | 5-sigma galaxy (0.45arcsec round exp) detection depth in z-band (AB) mag | REAL |

htm9 | HTM index (order 9 => ~10 arcmin size) | BIGINT |

ncomp | Total number of BRICK_UNIQUE objects in this brick of COMP types | SMALLINT |

ndev | Total number of BRICK_UNIQUE objects in this brick of DEV types | SMALLINT |

nest256 | HEALPIX index (Nsides 256, Nest scheme => ~52 arcsec size) | BIGINT |

nexp | Total number of BRICK_UNIQUE objects in this brick of EXP types | SMALLINT |

nexp_g | Median number of exposures in the unique are (i.e. BRICK_PRIMARY area) of the brick in the g-band | SMALLINT |

nexphist_g_1 | Histogram of number of pixels in the unique brick area with 0,1,2,3,4 or 5 exposures in g | INTEGER |

nexphist_g_2 | INTEGER | |

nexphist_g_3 | INTEGER | |

nexphist_g_4 | INTEGER | |

nexphist_g_5 | INTEGER | |

nexphist_g_6 | INTEGER | |

nexphist_r_1 | Histogram of number of pixels in the unique brick area with 0,1,2,3,4 or 5 exposures in r | INTEGER |

nexphist_r_2 | INTEGER | |

nexphist_r_3 | INTEGER | |

nexphist_r_4 | INTEGER | |

nexphist_r_5 | INTEGER | |

nexphist_r_6 | INTEGER | |

nexphist_z_1 | Histogram of number of pixels in the unique brick area with 0,1,2,3,4 or 5 exposures in z | INTEGER |

nexphist_z_2 | INTEGER | |

nexphist_z_3 | INTEGER | |

nexphist_z_4 | INTEGER | |

nexphist_z_5 | INTEGER | |

nexphist_z_6 | INTEGER | |

nexp_r | Median number of exposures in the unique are (i.e. BRICK_PRIMARY area) of the brick in the r-band | SMALLINT |

nexp_z | Median number of exposures in the unique are (i.e. BRICK_PRIMARY area) of the brick in the z-band | SMALLINT |

nobjs | Total number of BRICK_UNIQUE objects in this brick of all types | SMALLINT |

npsf | Total number of BRICK_UNIQUE objects in this brick of PSF types | SMALLINT |

nrex | Total number of BRICK_UNIQUE objects in this brick of REX types | SMALLINT |

nsimp | Total number of BRICK_UNIQUE objects in this brick of SIMP types | SMALLINT |

psfdepth_g | 5-sigma PSF detection depth in g-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_UNIQUE objects in this brick in g-band | REAL |

psfsize_r | Median PSF size, in arcsec, evaluated at the BRICK_UNIQUE objects in this brick in r-band | REAL |

psfsize_z | Median PSF size, in arcsec, evaluated at the BRICK_UNIQUE objects in this brick in z-band | REAL |

ra | RA of the center of the brick | DOUBLE |

ring256 | HEALPIX index (Nsides 256, Ring scheme => ~52 arcsec size) | BIGINT |

trans_g | Median Milky Way dust transparency in g-band, based on ebv. See also DECAM_MW_TRANSMISSION | REAL |

trans_r | Median Milky Way dust transparency in r-band, based on ebv. See also DECAM_MW_TRANSMISSION | REAL |

trans_wise_1 | Median Milky Way dust transparency in WISE bands, based on ebv. See also, e.g., MW_TRANSMISSION_W1 | REAL |

trans_wise_2 | Median Milky Way dust transparency in WISE bands, based on ebv. See also, e.g., MW_TRANSMISSION_W2 | REAL |

trans_wise_3 | Median Milky Way dust transparency in WISE bands, based on ebv. See also, e.g., MW_TRANSMISSION_W3 | REAL |

trans_wise_4 | Median Milky Way dust transparency in WISE bands, 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 DECAM_MW_TRANSMISSION | REAL |

wise_nobs_1 | Number of images that contributed to WISE calculations in each filter (not profile-weighted) | SMALLINT |

wise_nobs_2 | Number of images that contributed to WISE calculations in each filter (not profile-weighted) | SMALLINT |

wise_nobs_3 | Number of images that contributed to WISE calculations in each filter (not profile-weighted) | SMALLINT |

wise_nobs_4 | Number of images that contributed to WISE calculations in each filter (not profile-weighted) | SMALLINT |