Choose a database in the left panel then select the table you want!
Table: des_dr2.mag
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| alphawin_j2000 | right ascension for the object, j2000 in icrs system (full precision but not indexed) [degrees] | DOUBLE |
| coadd_object_id | unique identifier for the coadded objects | BIGINT |
| dec | declination, with quantized precision for indexing (deltawin_j2000 has full precision but not indexed) [degrees] | DOUBLE |
| deltawin_j2000 | declination for the object, j2000 in icrs system (full precision but not indexed) [degrees] | DOUBLE |
| ebv_sfd98 | e(b-v) reddening coefficient from schlegel, finkbeiner & davis, 1998 [mag] | DOUBLE |
| flags_g | g-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objects | SMALLINT |
| flags_i | i-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objects | SMALLINT |
| flags_r | r-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objects | SMALLINT |
| flags_y | y-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objects | SMALLINT |
| flags_z | z-band additive flag describing cautionary advice about source extraction process. use less than 4 for well behaved objects | SMALLINT |
| g_r | G-R color | REAL |
| hpix_1024 | healpix identifier for nside=1024 grid size, in a nested schema | BIGINT |
| hpix_16384 | healpix identifier for nside=16384 grid size, in a nested schema | BIGINT |
| hpix_32 | healpix identifier for nside=32 grid size, in a nested schema | BIGINT |
| hpix_4096 | healpix identifier for nside=4096 grid size, in a nested schema | BIGINT |
| hpix_64 | healpix identifier for nside=64 grid size, in a nested schema | BIGINT |
| i_z | I-Z color | REAL |
| imaflags_iso_g | g-band flag identifying sources with missing/flagged pixels, considering all single epoch images | INTEGER |
| imaflags_iso_i | i-band flag identifying sources with missing/flagged pixels, considering all single epoch images | INTEGER |
| imaflags_iso_r | r-band flag identifying sources with missing/flagged pixels, considering all single epoch images | INTEGER |
| imaflags_iso_y | y-band flag identifying sources with missing/flagged pixels, considering all single epoch images | INTEGER |
| imaflags_iso_z | z-band flag identifying sources with missing/flagged pixels, considering all single epoch images | INTEGER |
| mag_aper_10_g | aperture 10 equivalent to 29.63 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_10_i | aperture 10 equivalent to 29.63 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_10_r | aperture 10 equivalent to 29.63 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_10_y | aperture 10 equivalent to 29.63 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_10_z | aperture 10 equivalent to 29.63 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_11_g | aperture 11 equivalent to 44.44 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_11_i | aperture 11 equivalent to 44.44 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_11_r | aperture 11 equivalent to 44.44 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_11_y | aperture 11 equivalent to 44.44 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_11_z | aperture 11 equivalent to 44.44 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_12_g | aperture 12 equivalent to 66.67 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_12_i | aperture 12 equivalent to 66.67 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_12_r | aperture 12 equivalent to 66.67 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_12_y | aperture 12 equivalent to 66.67 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_12_z | aperture 12 equivalent to 66.67 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_1_g | aperture 1 equivalent to 1.85 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_1_i | aperture 1 equivalent to 1.85 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_1_r | aperture 1 equivalent to 1.85 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_1_y | aperture 1 equivalent to 1.85 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_1_z | aperture 1 equivalent to 1.85 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_2_g | aperture 2 equivalent to 3.7 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_2_i | aperture 2 equivalent to 3.7 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_2_r | aperture 2 equivalent to 3.7 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_2_y | aperture 2 equivalent to 3.7 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_2_z | aperture 2 equivalent to 3.7 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_3_g | aperture 3 equivalent to 5.55 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_3_i | aperture 3 equivalent to 5.55 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_3_r | aperture 3 equivalent to 5.55 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_3_y | aperture 3 equivalent to 5.55 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_3_z | aperture 3 equivalent to 5.55 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_4_g | aperture 4 equivalent to 7.41 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_4_i | aperture 4 equivalent to 7.41 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_4_r | aperture 4 equivalent to 7.41 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_4_y | aperture 4 equivalent to 7.41 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_4_z | aperture 4 equivalent to 7.41 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_5_g | aperture 5 equivalent to 11.11 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_5_i | aperture 5 equivalent to 11.11 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_5_r | aperture 5 equivalent to 11.11 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_5_y | aperture 5 equivalent to 11.11 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_5_z | aperture 5 equivalent to 11.11 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_6_g | aperture 6 equivalent to 14.81 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_6_i | aperture 6 equivalent to 14.81 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_6_r | aperture 6 equivalent to 14.81 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_6_y | aperture 6 equivalent to 14.81 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_6_z | aperture 6 equivalent to 14.81 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_7_g | aperture 7 equivalent to 18.52 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_7_i | aperture 7 equivalent to 18.52 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_7_r | aperture 7 equivalent to 18.52 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_7_y | aperture 7 equivalent to 18.52 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_7_z | aperture 7 equivalent to 18.52 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_8_g | aperture 8 equivalent to 22.22 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_8_i | aperture 8 equivalent to 22.22 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_8_r | aperture 8 equivalent to 22.22 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_8_y | aperture 8 equivalent to 22.22 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_8_z | aperture 8 equivalent to 22.22 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_9_g | aperture 9 equivalent to 25.93 [pixel], g-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_9_i | aperture 9 equivalent to 25.93 [pixel], i-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_9_r | aperture 9 equivalent to 25.93 [pixel], r-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_9_y | aperture 9 equivalent to 25.93 [pixel], y-band magnitude estimation for circular apertures [mag] | REAL |
| mag_aper_9_z | aperture 9 equivalent to 25.93 [pixel], z-band magnitude estimation for circular apertures [mag] | REAL |
| mag_auto_g | g-band magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| mag_auto_i | i-band magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| mag_auto_r | r-band magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| mag_auto_y | y-band magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| mag_auto_z | z-band magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| mag_petro_g | g-band magnitude for a petrosian radius [mag] | REAL |
| mag_petro_i | i-band magnitude for a petrosian radius [mag] | REAL |
| mag_petro_r | r-band magnitude for a petrosian radius [mag] | REAL |
| mag_petro_y | y-band magnitude for a petrosian radius [mag] | REAL |
| mag_petro_z | z-band magnitude for a petrosian radius [mag] | REAL |
| magerr_aper_10_g | aperture 10 equivalent to 29.63 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_10_i | aperture 10 equivalent to 29.63 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_10_r | aperture 10 equivalent to 29.63 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_10_y | aperture 10 equivalent to 29.63 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_10_z | aperture 10 equivalent to 29.63 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_11_g | aperture 11 equivalent to 44.44 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_11_i | aperture 11 equivalent to 44.44 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_11_r | aperture 11 equivalent to 44.44 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_11_y | aperture 11 equivalent to 44.44 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_11_z | aperture 11 equivalent to 44.44 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_12_g | aperture 12 equivalent to 66.67 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_12_i | aperture 12 equivalent to 66.67 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_12_r | aperture 12 equivalent to 66.67 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_12_y | aperture 12 equivalent to 66.67 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_12_z | aperture 12 equivalent to 66.67 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_1_g | aperture 1 equivalent to 1.85 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_1_i | aperture 1 equivalent to 1.85 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_1_r | aperture 1 equivalent to 1.85 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_1_y | aperture 1 equivalent to 1.85 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_1_z | aperture 1 equivalent to 1.85 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_2_g | aperture 2 equivalent to 3.7 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_2_i | aperture 2 equivalent to 3.7 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_2_r | aperture 2 equivalent to 3.7 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_2_y | aperture 2 equivalent to 3.7 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_2_z | aperture 2 equivalent to 3.7 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_3_g | aperture 3 equivalent to 5.55 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_3_i | aperture 3 equivalent to 5.55 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_3_r | aperture 3 equivalent to 5.55 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_3_y | aperture 3 equivalent to 5.55 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_3_z | aperture 3 equivalent to 5.55 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_4_g | aperture 4 equivalent to 7.41 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_4_i | aperture 4 equivalent to 7.41 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_4_r | aperture 4 equivalent to 7.41 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_4_y | aperture 4 equivalent to 7.41 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_4_z | aperture 4 equivalent to 7.41 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_5_g | aperture 5 equivalent to 11.11 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_5_i | aperture 5 equivalent to 11.11 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_5_r | aperture 5 equivalent to 11.11 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_5_y | aperture 5 equivalent to 11.11 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_5_z | aperture 5 equivalent to 11.11 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_6_g | aperture 6 equivalent to 14.81 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_6_i | aperture 6 equivalent to 14.81 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_6_r | aperture 6 equivalent to 14.81 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_6_y | aperture 6 equivalent to 14.81 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_6_z | aperture 6 equivalent to 14.81 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_7_g | aperture 7 equivalent to 18.52 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_7_i | aperture 7 equivalent to 18.52 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_7_r | aperture 7 equivalent to 18.52 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_7_y | aperture 7 equivalent to 18.52 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_7_z | aperture 7 equivalent to 18.52 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_8_g | aperture 8 equivalent to 22.22 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_8_i | aperture 8 equivalent to 22.22 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_8_r | aperture 8 equivalent to 22.22 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_8_y | aperture 8 equivalent to 22.22 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_8_z | aperture 8 equivalent to 22.22 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_9_g | aperture 9 equivalent to 25.93 [pixel], g-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_9_i | aperture 9 equivalent to 25.93 [pixel], i-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_9_r | aperture 9 equivalent to 25.93 [pixel], r-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_9_y | aperture 9 equivalent to 25.93 [pixel], y-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_aper_9_z | aperture 9 equivalent to 25.93 [pixel], z-band uncertainty in magnitude estimation for circular apertures [mag] | REAL |
| magerr_auto_g | g-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| magerr_auto_i | i-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| magerr_auto_r | r-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| magerr_auto_y | y-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| magerr_auto_z | z-band uncertainty in magnitude estimation, for an elliptical model based on the kron radius [mag] | REAL |
| magerr_petro_g | g-band uncertainty in magnitude for a petrosian radius [mag] | REAL |
| magerr_petro_i | i-band uncertainty in magnitude for a petrosian radius [mag] | REAL |
| magerr_petro_r | r-band uncertainty in magnitude for a petrosian radius [mag] | REAL |
| magerr_petro_y | y-band uncertainty in magnitude for a petrosian radius [mag] | REAL |
| magerr_petro_z | z-band uncertainty in magnitude for a petrosian radius [mag] | REAL |
| petro_radius_g | g-band petrosian radius [pixel] | REAL |
| petro_radius_i | i-band petrosian radius [pixel] | REAL |
| petro_radius_r | r-band petrosian radius [pixel] | REAL |
| petro_radius_y | y-band petrosian radius [pixel] | REAL |
| petro_radius_z | z-band petrosian radius [pixel] | REAL |
| r_i | R-I color | REAL |
| ra | right ascension, with quantized precision for indexing (alphawin_j2000 has full precision but not indexed) [degrees] | DOUBLE |
| tilename | identifier of each one of the tiles on which the survey is gridded | CHAR |
| wavg_mag_psf_g | g-band weighted average magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_mag_psf_i | i-band weighted average magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_mag_psf_r | r-band weighted average magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_mag_psf_y | y-band weighted average magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_mag_psf_z | z-band weighted average magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_magerr_psf_g | g-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_magerr_psf_i | i-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_magerr_psf_r | r-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_magerr_psf_y | y-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag] | REAL |
| wavg_magerr_psf_z | z-band uncertainty of weighted averaged magnitude, of psf fit single epoch detections [mag] | REAL |
| xwin_image | x-centroid from windowed measurements on coadded image [pixel] | DOUBLE |
| ywin_image | y-centroid from windowed measurements on coadded image [pixel] | DOUBLE |
| z_y | Z-Y color | REAL |
