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

Table: des_dr2.main
(The bold columns are indexed columns)
Column NameDescriptionDatatype
a_imagemajor axis size based on an isophotal model [pixel]REAL
alphawin_j2000right ascension for the object, j2000 in icrs system (full precision but not indexed) [degrees]DOUBLE
awin_image_gg-band major axis size, from 2nd order windowed moment measurements [pixels]REAL
awin_image_ii-band major axis size, from 2nd order windowed moment measurements [pixels]REAL
awin_image_rr-band major axis size, from 2nd order windowed moment measurements [pixels]REAL
awin_image_yy-band major axis size, from 2nd order windowed moment measurements [pixels]REAL
awin_image_zz-band major axis size, from 2nd order windowed moment measurements [pixels]REAL
b_imageminor axis size based on an isophotal model [pixel]REAL
background_gg-band background level, by ccd-amplifier [mag]REAL
background_ii-band background level, by ccd-amplifier [mag]REAL
background_rr-band background level, by ccd-amplifier [mag]REAL
background_yy-band background level, by ccd-amplifier [mag]REAL
background_zz-band background level, by ccd-amplifier [mag]REAL
bwin_image_gg-band minor axis size, from 2nd order windowed moment measurements [pixels]REAL
bwin_image_ii-band minor axis size, from 2nd order windowed moment measurements [pixels]REAL
bwin_image_rr-band minor axis size, from 2nd order windowed moment measurements [pixels]REAL
bwin_image_yy-band minor axis size, from 2nd order windowed moment measurements [pixels]REAL
bwin_image_zz-band minor axis size, from 2nd order windowed moment measurements [pixels]REAL
class_star_gg-band simple morphological extended source classifier. values between 0 (galaxies) and 1 (stars). spread_model exhibits better performance for morphological classification.REAL
class_star_ii-band simple morphological extended source classifier. values between 0 (galaxies) and 1 (stars). spread_model exhibits better performance for morphological classification.REAL
class_star_rr-band simple morphological extended source classifier. values between 0 (galaxies) and 1 (stars). spread_model exhibits better performance for morphological classification.REAL
class_star_yy-band simple morphological extended source classifier. values between 0 (galaxies) and 1 (stars). spread_model exhibits better performance for morphological classification.REAL
class_star_zz-band simple morphological extended source classifier. values between 0 (galaxies) and 1 (stars). spread_model exhibits better performance for morphological classification.REAL
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
ecliptic_latEcliptic LatitudeDOUBLE
ecliptic_lonEcliptic LongitudeDOUBLE
erra_imageuncertainty in major axis size, from isophotal model [pixel]REAL
errawin_image_gg-band uncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errawin_image_ii-band uncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errawin_image_rr-band uncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errawin_image_yy-band uncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errawin_image_zz-band uncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errb_imageuncertainty in minor axis size, from isophotal model [pixel]REAL
errbwin_image_gg-band uncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errbwin_image_ii-band uncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errbwin_image_rr-band uncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errbwin_image_yy-band uncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errbwin_image_zz-band uncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noise [pixel]REAL
errtheta_imageuncertainty in source position, from isophotal model [degrees]REAL
errthetawin_image_gg-band uncertainty in source position angle, from converged windowed measurement [degrees]REAL
errthetawin_image_ii-band uncertainty in source position angle, from converged windowed measurement [degrees]REAL
errthetawin_image_rr-band uncertainty in source position angle, from converged windowed measurement [degrees]REAL
errthetawin_image_yy-band uncertainty in source position angle, from converged windowed measurement [degrees]REAL
errthetawin_image_zz-band uncertainty in source position angle, from converged windowed measurement [degrees]REAL
errx2win_image_gg-band uncertainty in second moment of x-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
errx2win_image_ii-band uncertainty in second moment of x-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
errx2win_image_rr-band uncertainty in second moment of x-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
errx2win_image_yy-band uncertainty in second moment of x-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
errx2win_image_zz-band uncertainty in second moment of x-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
errxywin_image_gg-band uncertainty in second moment of xy-distribution, from converged windowed measurements [pixel2]DOUBLE
errxywin_image_ii-band uncertainty in second moment of xy-distribution, from converged windowed measurements [pixel2]DOUBLE
errxywin_image_rr-band uncertainty in second moment of xy-distribution, from converged windowed measurements [pixel2]DOUBLE
errxywin_image_yy-band uncertainty in second moment of xy-distribution, from converged windowed measurements [pixel2]DOUBLE
errxywin_image_zz-band uncertainty in second moment of xy-distribution, from converged windowed measurements [pixel2]DOUBLE
erry2win_image_gg-band uncertainty in second moment of y-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
erry2win_image_ii-band uncertainty in second moment of y-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
erry2win_image_rr-band uncertainty in second moment of y-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
erry2win_image_yy-band uncertainty in second moment of y-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
erry2win_image_zz-band uncertainty in second moment of y-distribution centroid, from converged windowed measurements [pixel2]DOUBLE
extended_class_coadd0: high confidence stars; 1: candidate stars; 2: mostly galaxies; 3: high confidence galaxies; -9: no data; using sextractor photometrySMALLINT
extended_class_wavg0: high confidence stars; 1: candidate stars; 2: mostly galaxies; 3: high confidence galaxies; -9: no data; using wavg photometrySMALLINT
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
flux_auto_gg-band aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
flux_auto_ii-band aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
flux_auto_rr-band aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
flux_auto_yy-band aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
flux_auto_zz-band aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
flux_radius_gg-band half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
flux_radius_ii-band half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
flux_radius_rr-band half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
flux_radius_yy-band half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
flux_radius_zz-band half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
fluxerr_auto_gg-band uncertainty in aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
fluxerr_auto_ii-band uncertainty in aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
fluxerr_auto_rr-band uncertainty in aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
fluxerr_auto_yy-band uncertainty in aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
fluxerr_auto_zz-band uncertainty in aperture-flux measurement, elliptical model based on the kron radius [adu]REAL
fwhm_image_gg-band fwhm measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
fwhm_image_ii-band fwhm measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
fwhm_image_rr-band fwhm measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
fwhm_image_yy-band fwhm measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
fwhm_image_zz-band fwhm measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensions [pixel]REAL
g_rG-R colorREAL
galactic_bgalactic latitude [degrees]REAL
galactic_lgalactic longitude [degrees]REAL
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
htm9Ninth level (~10 arcmin resolution) Hierarchical Triangular Mesh index (Szalay et al. 2007)INTEGER
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
isoarea_image_gg-band isophotal area of the coadded source [pixel2]INTEGER
isoarea_image_ii-band isophotal area of the coadded source [pixel2]INTEGER
isoarea_image_rr-band isophotal area of the coadded source [pixel2]INTEGER
isoarea_image_yy-band isophotal area of the coadded source [pixel2]INTEGER
isoarea_image_zz-band isophotal area of the coadded source [pixel2]INTEGER
kron_radiuskron radius measured from detection image [pixel]REAL
kron_radius_gg-band kron radius measured from coadded image [pixel]REAL
kron_radius_ii-band kron radius measured from coadded image [pixel]REAL
kron_radius_rr-band kron radius measured from coadded image [pixel]REAL
kron_radius_yy-band kron radius measured from coadded image [pixel]REAL
kron_radius_zz-band kron radius measured from coadded image [pixel]REAL
mag_auto_gg-band magnitude estimation, for an elliptical model based on the kron radius [mag]REAL
mag_auto_g_deredg-band dereddened magnitude estimation (using sfd98), 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_i_deredi-band dereddened magnitude estimation (using sfd98), 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_r_deredr-band dereddened magnitude estimation (using sfd98), 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_y_deredy-band dereddened magnitude estimation (using sfd98), 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_auto_z_deredz-band dereddened magnitude estimation (using sfd98), for an elliptical model based on the kron radius [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
nepochs_gg-band number of epochs the source is detected in single epoch imagesINTEGER
nepochs_ii-band number of epochs the source is detected in single epoch imagesINTEGER
nepochs_rr-band number of epochs the source is detected in single epoch imagesINTEGER
nepochs_yy-band number of epochs the source is detected in single epoch imagesINTEGER
nepochs_zz-band number of epochs the source is detected in single epoch imagesINTEGER
nest4096Nested-scheme HEALPix (Gorski et al. 2005) index with NSIDE=4096 (~1 arcmin resolution)INTEGER
niter_model_gg-band number of iterations in model fitting photometric measurementsINTEGER
niter_model_ii-band number of iterations in model fitting photometric measurementsINTEGER
niter_model_rr-band number of iterations in model fitting photometric measurementsINTEGER
niter_model_yy-band number of iterations in model fitting photometric measurementsINTEGER
niter_model_zz-band number of iterations in model fitting photometric measurementsINTEGER
r_iR-I colorREAL
raright ascension, with quantized precision for indexing (alphawin_j2000 has full precision but not indexed) [degrees]DOUBLE
random_idRandom ID in the range 0.0 => 100.0REAL
ring256Ring-scheme HEALPix (Gorski et al. 2005) index with NSIDE=256 (~14 arcmin resolution)INTEGER
snr_gS/N in g-bandREAL
snr_iS/N in i-bandREAL
snr_rS/N in r-bandREAL
snr_yS/N in Y-bandREAL
snr_zS/N in z-bandREAL
spread_model_gg-band morphology based classifier based on comparison between a psf versus exponential-psf model. values closer to 0 correspond to stars, larger values correspond to galaxiesREAL
spread_model_ii-band morphology based classifier based on comparison between a psf versus exponential-psf model. values closer to 0 correspond to stars, larger values correspond to galaxiesREAL
spread_model_rr-band morphology based classifier based on comparison between a psf versus exponential-psf model. values closer to 0 correspond to stars, larger values correspond to galaxiesREAL
spread_model_yy-band morphology based classifier based on comparison between a psf versus exponential-psf model. values closer to 0 correspond to stars, larger values correspond to galaxiesREAL
spread_model_zz-band morphology based classifier based on comparison between a psf versus exponential-psf model. values closer to 0 correspond to stars, larger values correspond to galaxiesREAL
spreaderr_model_gg-band uncertainty in morphology based classifier based on comparison between psf versus exponential-psf model.REAL
spreaderr_model_ii-band uncertainty in morphology based classifier based on comparison between psf versus exponential-psf model.REAL
spreaderr_model_rr-band uncertainty in morphology based classifier based on comparison between psf versus exponential-psf model.REAL
spreaderr_model_yy-band uncertainty in morphology based classifier based on comparison between psf versus exponential-psf model.REAL
spreaderr_model_zz-band uncertainty in morphology based classifier based on comparison between psf versus exponential-psf model.REAL
theta_j2000position angle of source in j2000 coordinates, from non-windowed measurement [degrees]REAL
thetawin_image_gg-band position angle of source, for converged windowed measurement grow from x to y [degrees]REAL
thetawin_image_ii-band position angle of source, for converged windowed measurement grow from x to y [degrees]REAL
thetawin_image_rr-band position angle of source, for converged windowed measurement grow from x to y [degrees]REAL
thetawin_image_yy-band position angle of source, for converged windowed measurement grow from x to y [degrees]REAL
thetawin_image_zz-band position angle of source, for converged windowed measurement grow from x to y [degrees]REAL
tilenameidentifier of each one of the tiles on which the survey is griddedCHAR
wavg_flux_psf_gg-band weighted average flux measurement of psf fit single epoch detections [adu]REAL
wavg_flux_psf_ii-band weighted average flux measurement of psf fit single epoch detections [adu]REAL
wavg_flux_psf_rr-band weighted average flux measurement of psf fit single epoch detections [adu]REAL
wavg_flux_psf_yy-band weighted average flux measurement of psf fit single epoch detections [adu]REAL
wavg_flux_psf_zz-band weighted average flux measurement of psf fit single epoch detections [adu]REAL
wavg_fluxerr_psf_gg-band uncertainty of weighted averaged flux measurement of psf fit single epoch detections [adu]REAL
wavg_fluxerr_psf_ii-band uncertainty of weighted averaged flux measurement of psf fit single epoch detections [adu]REAL
wavg_fluxerr_psf_rr-band uncertainty of weighted averaged flux measurement of psf fit single epoch detections [adu]REAL
wavg_fluxerr_psf_yy-band uncertainty of weighted averaged flux measurement of psf fit single epoch detections [adu]REAL
wavg_fluxerr_psf_zz-band uncertainty of weighted averaged flux measurement of psf fit single epoch detections [adu]REAL
wavg_mag_psf_gg-band weighted average magnitude, of psf fit single epoch detections [mag]REAL
wavg_mag_psf_g_deredg-band dereddened weighted average magnitude (using sfd98) from 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_i_deredi-band dereddened weighted average magnitude (using sfd98) from 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_r_deredr-band dereddened weighted average magnitude (using sfd98) from 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_y_deredy-band dereddened weighted average magnitude (using sfd98) from psf fit single epoch detections [mag]REAL
wavg_mag_psf_zz-band weighted average magnitude, of psf fit single epoch detections [mag]REAL
wavg_mag_psf_z_deredz-band dereddened weighted average magnitude (using sfd98) from 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
wavg_spread_model_gg-band spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spread_model_ii-band spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spread_model_rr-band spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spread_model_yy-band spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spread_model_zz-band spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_gg-band uncertainty in spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_ii-band uncertainty in spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_rr-band uncertainty in spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_yy-band uncertainty in spread model using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_zz-band uncertainty in spread model using the weighted averaged values from single epoch detectionsREAL
x2win_image_gg-band second moment in x-direction, from converged windowed measurements [pixel2]DOUBLE
x2win_image_ii-band second moment in x-direction, from converged windowed measurements [pixel2]DOUBLE
x2win_image_rr-band second moment in x-direction, from converged windowed measurements [pixel2]DOUBLE
x2win_image_yy-band second moment in x-direction, from converged windowed measurements [pixel2]DOUBLE
x2win_image_zz-band second moment in x-direction, from converged windowed measurements [pixel2]DOUBLE
xwin_imagex-centroid from windowed measurements on coadded image [pixel]DOUBLE
xwin_image_gg-band x-centroid from windowed measurements on coadded band image [pixel]DOUBLE
xwin_image_ii-band x-centroid from windowed measurements on coadded band image [pixel]DOUBLE
xwin_image_rr-band x-centroid from windowed measurements on coadded band image [pixel]DOUBLE
xwin_image_yy-band x-centroid from windowed measurements on coadded band image [pixel]DOUBLE
xwin_image_zz-band x-centroid from windowed measurements on coadded band image [pixel]DOUBLE
xywin_image_gg-band second moment in xy-direction, from converged windowed measurements [pixel2]DOUBLE
xywin_image_ii-band second moment in xy-direction, from converged windowed measurements [pixel2]DOUBLE
xywin_image_rr-band second moment in xy-direction, from converged windowed measurements [pixel2]DOUBLE
xywin_image_yy-band second moment in xy-direction, from converged windowed measurements [pixel2]DOUBLE
xywin_image_zz-band second moment in xy-direction, from converged windowed measurements [pixel2]DOUBLE
y2win_image_gg-band second moment in y-direction, from converged windowed measurements [pixel2]DOUBLE
y2win_image_ii-band second moment in y-direction, from converged windowed measurements [pixel2]DOUBLE
y2win_image_rr-band second moment in y-direction, from converged windowed measurements [pixel2]DOUBLE
y2win_image_yy-band second moment in y-direction, from converged windowed measurements [pixel2]DOUBLE
y2win_image_zz-band second moment in y-direction, from converged windowed measurements [pixel2]DOUBLE
ywin_imagey-centroid from windowed measurements on coadded image [pixel]DOUBLE
ywin_image_gg-band y-centroid from windowed measurements on coadded band images [pixel]DOUBLE
ywin_image_ii-band y-centroid from windowed measurements on coadded band images [pixel]DOUBLE
ywin_image_rr-band y-centroid from windowed measurements on coadded band images [pixel]DOUBLE
ywin_image_yy-band y-centroid from windowed measurements on coadded band images [pixel]DOUBLE
ywin_image_zz-band y-centroid from windowed measurements on coadded band images [pixel]DOUBLE
z_yZ-Y colorREAL