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

Table: des_dr2.mag
(The bold columns are indexed columns)
Column NameDescriptionDatatype
alphawin_j2000right ascension for the object, j2000 in icrs system (full precision but not indexed) [degrees]DOUBLE
coadd_object_idunique identifier for the coadded objectsBIGINT
decdeclination, with quantized precision for indexing (deltawin_j2000 has full precision but not indexed) [degrees]DOUBLE
deltawin_j2000declination for the object, j2000 in icrs system (full precision but not indexed) [degrees]DOUBLE
ebv_sfd98e(b-v) reddening coefficient from schlegel, finkbeiner & davis, 1998 [mag]DOUBLE
flags_gg-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objectsSMALLINT
flags_ii-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objectsSMALLINT
flags_rr-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objectsSMALLINT
flags_yy-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objectsSMALLINT
flags_zz-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objectsSMALLINT
g_rG-R colorREAL
hpix_1024healpix identifier for nside=1024 grid size, in a nested schemaBIGINT
hpix_16384healpix identifier for nside=16384 grid size, in a nested schemaBIGINT
hpix_32healpix identifier for nside=32 grid size, in a nested schemaBIGINT
hpix_4096healpix identifier for nside=4096 grid size, in a nested schemaBIGINT
hpix_64healpix identifier for nside=64 grid size, in a nested schemaBIGINT
i_zI-Z colorREAL
imaflags_iso_gg-band flag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
imaflags_iso_ii-band flag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
imaflags_iso_rr-band flag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
imaflags_iso_yy-band flag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
imaflags_iso_zz-band flag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
mag_aper_10_gaperture 10 equivalent to 29.63 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_10_iaperture 10 equivalent to 29.63 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_10_raperture 10 equivalent to 29.63 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_10_yaperture 10 equivalent to 29.63 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_10_zaperture 10 equivalent to 29.63 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_11_gaperture 11 equivalent to 44.44 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_11_iaperture 11 equivalent to 44.44 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_11_raperture 11 equivalent to 44.44 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_11_yaperture 11 equivalent to 44.44 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_11_zaperture 11 equivalent to 44.44 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_12_gaperture 12 equivalent to 66.67 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_12_iaperture 12 equivalent to 66.67 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_12_raperture 12 equivalent to 66.67 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_12_yaperture 12 equivalent to 66.67 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_12_zaperture 12 equivalent to 66.67 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_1_gaperture 1 equivalent to 1.85 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_1_iaperture 1 equivalent to 1.85 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_1_raperture 1 equivalent to 1.85 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_1_yaperture 1 equivalent to 1.85 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_1_zaperture 1 equivalent to 1.85 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_2_gaperture 2 equivalent to 3.7 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_2_iaperture 2 equivalent to 3.7 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_2_raperture 2 equivalent to 3.7 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_2_yaperture 2 equivalent to 3.7 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_2_zaperture 2 equivalent to 3.7 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_3_gaperture 3 equivalent to 5.55 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_3_iaperture 3 equivalent to 5.55 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_3_raperture 3 equivalent to 5.55 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_3_yaperture 3 equivalent to 5.55 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_3_zaperture 3 equivalent to 5.55 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_4_gaperture 4 equivalent to 7.41 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_4_iaperture 4 equivalent to 7.41 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_4_raperture 4 equivalent to 7.41 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_4_yaperture 4 equivalent to 7.41 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_4_zaperture 4 equivalent to 7.41 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_5_gaperture 5 equivalent to 11.11 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_5_iaperture 5 equivalent to 11.11 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_5_raperture 5 equivalent to 11.11 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_5_yaperture 5 equivalent to 11.11 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_5_zaperture 5 equivalent to 11.11 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_6_gaperture 6 equivalent to 14.81 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_6_iaperture 6 equivalent to 14.81 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_6_raperture 6 equivalent to 14.81 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_6_yaperture 6 equivalent to 14.81 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_6_zaperture 6 equivalent to 14.81 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_7_gaperture 7 equivalent to 18.52 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_7_iaperture 7 equivalent to 18.52 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_7_raperture 7 equivalent to 18.52 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_7_yaperture 7 equivalent to 18.52 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_7_zaperture 7 equivalent to 18.52 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_8_gaperture 8 equivalent to 22.22 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_8_iaperture 8 equivalent to 22.22 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_8_raperture 8 equivalent to 22.22 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_8_yaperture 8 equivalent to 22.22 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_8_zaperture 8 equivalent to 22.22 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_aper_9_gaperture 9 equivalent to 25.93 [pixel], g-band magnitude estimation for circular apertures [mag]REAL
mag_aper_9_iaperture 9 equivalent to 25.93 [pixel], i-band magnitude estimation for circular apertures [mag]REAL
mag_aper_9_raperture 9 equivalent to 25.93 [pixel], r-band magnitude estimation for circular apertures [mag]REAL
mag_aper_9_yaperture 9 equivalent to 25.93 [pixel], y-band magnitude estimation for circular apertures [mag]REAL
mag_aper_9_zaperture 9 equivalent to 25.93 [pixel], z-band magnitude estimation for circular apertures [mag]REAL
mag_auto_gg-band magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
mag_auto_ii-band magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
mag_auto_rr-band magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
mag_auto_yy-band magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
mag_auto_zz-band magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
mag_petro_gg-band magnitude for a petrosian radius [mag]REAL
mag_petro_ii-band magnitude for a petrosian radius [mag]REAL
mag_petro_rr-band magnitude for a petrosian radius [mag]REAL
mag_petro_yy-band magnitude for a petrosian radius [mag]REAL
mag_petro_zz-band magnitude for a petrosian radius [mag]REAL
magerr_aper_10_gaperture 10 equivalent to 29.63 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_10_iaperture 10 equivalent to 29.63 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_10_raperture 10 equivalent to 29.63 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_10_yaperture 10 equivalent to 29.63 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_10_zaperture 10 equivalent to 29.63 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_11_gaperture 11 equivalent to 44.44 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_11_iaperture 11 equivalent to 44.44 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_11_raperture 11 equivalent to 44.44 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_11_yaperture 11 equivalent to 44.44 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_11_zaperture 11 equivalent to 44.44 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_12_gaperture 12 equivalent to 66.67 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_12_iaperture 12 equivalent to 66.67 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_12_raperture 12 equivalent to 66.67 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_12_yaperture 12 equivalent to 66.67 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_12_zaperture 12 equivalent to 66.67 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_1_gaperture 1 equivalent to 1.85 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_1_iaperture 1 equivalent to 1.85 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_1_raperture 1 equivalent to 1.85 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_1_yaperture 1 equivalent to 1.85 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_1_zaperture 1 equivalent to 1.85 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_2_gaperture 2 equivalent to 3.7 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_2_iaperture 2 equivalent to 3.7 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_2_raperture 2 equivalent to 3.7 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_2_yaperture 2 equivalent to 3.7 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_2_zaperture 2 equivalent to 3.7 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_3_gaperture 3 equivalent to 5.55 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_3_iaperture 3 equivalent to 5.55 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_3_raperture 3 equivalent to 5.55 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_3_yaperture 3 equivalent to 5.55 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_3_zaperture 3 equivalent to 5.55 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_4_gaperture 4 equivalent to 7.41 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_4_iaperture 4 equivalent to 7.41 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_4_raperture 4 equivalent to 7.41 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_4_yaperture 4 equivalent to 7.41 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_4_zaperture 4 equivalent to 7.41 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_5_gaperture 5 equivalent to 11.11 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_5_iaperture 5 equivalent to 11.11 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_5_raperture 5 equivalent to 11.11 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_5_yaperture 5 equivalent to 11.11 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_5_zaperture 5 equivalent to 11.11 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_6_gaperture 6 equivalent to 14.81 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_6_iaperture 6 equivalent to 14.81 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_6_raperture 6 equivalent to 14.81 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_6_yaperture 6 equivalent to 14.81 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_6_zaperture 6 equivalent to 14.81 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_7_gaperture 7 equivalent to 18.52 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_7_iaperture 7 equivalent to 18.52 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_7_raperture 7 equivalent to 18.52 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_7_yaperture 7 equivalent to 18.52 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_7_zaperture 7 equivalent to 18.52 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_8_gaperture 8 equivalent to 22.22 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_8_iaperture 8 equivalent to 22.22 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_8_raperture 8 equivalent to 22.22 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_8_yaperture 8 equivalent to 22.22 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_8_zaperture 8 equivalent to 22.22 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_9_gaperture 9 equivalent to 25.93 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_9_iaperture 9 equivalent to 25.93 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_9_raperture 9 equivalent to 25.93 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_9_yaperture 9 equivalent to 25.93 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_aper_9_zaperture 9 equivalent to 25.93 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag]REAL
magerr_auto_gg-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
magerr_auto_ii-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
magerr_auto_rr-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
magerr_auto_yy-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
magerr_auto_zz-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
magerr_petro_gg-band uncertainty in magnitude for a petrosian radius [mag]REAL
magerr_petro_ii-band uncertainty in magnitude for a petrosian radius [mag]REAL
magerr_petro_rr-band uncertainty in magnitude for a petrosian radius [mag]REAL
magerr_petro_yy-band uncertainty in magnitude for a petrosian radius [mag]REAL
magerr_petro_zz-band uncertainty in magnitude for a petrosian radius [mag]REAL
petro_radius_gg-band petrosian radius [pixel]REAL
petro_radius_ii-band petrosian radius [pixel]REAL
petro_radius_rr-band petrosian radius [pixel]REAL
petro_radius_yy-band petrosian radius [pixel]REAL
petro_radius_zz-band petrosian radius [pixel]REAL
r_iR-I colorREAL
raright ascension, with quantized precision for indexing (alphawin_j2000 has full precision but not indexed) [degrees]DOUBLE
tilenameidentifier of each one of the tiles on which the survey is griddedCHAR
wavg_mag_psf_gg-band weighted average magnitude, of psf fit single epoch detections [mag]REAL
wavg_mag_psf_ii-band weighted average magnitude, of psf fit single epoch detections [mag]REAL
wavg_mag_psf_rr-band weighted average magnitude, of psf fit single epoch detections [mag]REAL
wavg_mag_psf_yy-band weighted average magnitude, of psf fit single epoch detections [mag]REAL
wavg_mag_psf_zz-band weighted average magnitude, of psf fit single epoch detections [mag]REAL
wavg_magerr_psf_gg-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag]REAL
wavg_magerr_psf_ii-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag]REAL
wavg_magerr_psf_rr-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag]REAL
wavg_magerr_psf_yy-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag]REAL
wavg_magerr_psf_zz-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag]REAL
xwin_imagex-centroid from windowed measurements on coadded image [pixel]DOUBLE
ywin_imagey-centroid from windowed measurements on coadded image [pixel]DOUBLE
z_yZ-Y colorREAL


Data Lab is migrating from datalab.noao.edu to datalab.noirlab.edu. You are currently being re-directed.
If you are not automatically redirected in 5 seconds, please click here
Please update your bookmark to Data Lab accordingly.