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

Table: des_dr1.main
(The bold columns are indexed columns)
Column NameDescriptionDatatype
a_imageMajor axis size based on an isophotal modelREAL
alphawin_j2000Right ascension for the object, J2000 in ICRS system (full precision but not indexed)DOUBLE
awin_image_gMajor axis size, from 2nd order windowed moment measurementsREAL
awin_image_iMajor axis size, from 2nd order windowed moment measurementsREAL
awin_image_rMajor axis size, from 2nd order windowed moment measurementsREAL
awin_image_yMajor axis size, from 2nd order windowed moment measurementsREAL
awin_image_zMajor axis size, from 2nd order windowed moment measurementsREAL
b_imageMinor axis size based on an isophotal modelREAL
background_gBackground level, by CCD-amplifierREAL
background_iBackground level, by CCD-amplifierREAL
background_rBackground level, by CCD-amplifierREAL
background_yBackground level, by CCD-amplifierREAL
background_zBackground level, by CCD-amplifierREAL
bwin_image_gMinor axis size, from 2nd order windowed moment measurementsREAL
bwin_image_iMinor axis size, from 2nd order windowed moment measurementsREAL
bwin_image_rMinor axis size, from 2nd order windowed moment measurementsREAL
bwin_image_yMinor axis size, from 2nd order windowed moment measurementsREAL
bwin_image_zMinor axis size, from 2nd order windowed moment measurementsREAL
class_star_gSimple morphological extended source classifier. Values between 0 (galaxies) and 1 (stars). SPREAD_MODEL exhibits better performance for morphological classification.REAL
class_star_iSimple morphological extended source classifier. Values between 0 (galaxies) and 1 (stars). SPREAD_MODEL exhibits better performance for morphological classification.REAL
class_star_rSimple morphological extended source classifier. Values between 0 (galaxies) and 1 (stars). SPREAD_MODEL exhibits better performance for morphological classification.REAL
class_star_ySimple morphological extended source classifier. Values between 0 (galaxies) and 1 (stars). SPREAD_MODEL exhibits better performance for morphological classification.REAL
class_star_zSimple 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)DOUBLE
deltawin_j2000Declination for the object, J2000 in ICRS (full precision but not indexed)DOUBLE
ebv_sfd98E(B-V) reddening oefficient from Schelgel, Finkbeiner & Davis (1998)REAL
ecliptic_latEcliptic LatitudeDOUBLE
ecliptic_lonEcliptic LongitudeDOUBLE
erra_imageUncertainty in major axis size, from isophotal modelREAL
errawin_image_gUncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errawin_image_iUncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errawin_image_rUncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errawin_image_yUncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errawin_image_zUncertainty in major axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errb_imageUncertainty in minor axis size, from isophotal modelREAL
errbwin_image_gUncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errbwin_image_iUncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errbwin_image_rUncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errbwin_image_yUncertainty in minor axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errbwin_image_zUncertainty in Minor axis size, from converged windowed measurement, assuming uncorrelated noiseREAL
errtheta_imageUncertainty in source position, from isophotal modelREAL
errthetawin_image_gUncertainty in source position angle, from converged windowed measurementREAL
errthetawin_image_iUncertainty in source position angle, from converged windowed measurementREAL
errthetawin_image_rUncertainty in source position angle, from converged windowed measurementREAL
errthetawin_image_yUncertainty in source position angle, from converged windowed measurementREAL
errthetawin_image_zUncertainty in source position angle, from converged windowed measurementREAL
errx2win_image_gUncertainty in second moment of x-distribution centroid, from converged windowed measurementsDOUBLE
errx2win_image_iUncertainty in second moment of x-distribution centroid, from converged windowed measurementsDOUBLE
errx2win_image_rUncertainty in second moment of x-distribution centroid, from converged windowed measurementsDOUBLE
errx2win_image_yUncertainty in second moment of x-distribution centroid, from converged windowed measurementsDOUBLE
errx2win_image_zUncertainty in second moment of x-distribution centroid, from converged windowed measurementsDOUBLE
errxywin_image_gUncertainty in second moment of xy-distribution, from converged windowed measurementsDOUBLE
errxywin_image_iUncertainty in second moment of xy-distribution, from converged windowed measurementsDOUBLE
errxywin_image_rUncertainty in second moment of xy-distribution, from converged windowed measurementsDOUBLE
errxywin_image_yUncertainty in second moment of xy-distribution, from converged windowed measurementsDOUBLE
errxywin_image_zUncertainty in second moment of xy-distribution, from converged windowed measurementsDOUBLE
erry2win_image_gUncertainty in second moment of y-distribution centroid, from converged windowed measurementsDOUBLE
erry2win_image_iUncertainty in second moment of y-distribution centroid, from converged windowed measurementsDOUBLE
erry2win_image_rUncertainty in second moment of y-distribution centroid, from converged windowed measurementsDOUBLE
erry2win_image_yUncertainty in second moment of y-distribution centroid, from converged windowed measurementsDOUBLE
erry2win_image_zUncertainty in second moment of y-distribution centroid, from converged windowed measurementsDOUBLE
flags_gAdditive flag describing cautionary advice about source extraction process. Use less than 4 for well behaved objectsSMALLINT
flags_iAdditive flag describing cautionary advice about source extraction process. Use less than 4 for well behaved objectsSMALLINT
flags_rAdditive flag describing cautionary advice about source extraction process. Use less than 4 for well behaved objectsSMALLINT
flags_yAdditive flag describing cautionary advice about source extraction process. Use less than 4 for well behaved objectsSMALLINT
flags_zAdditive flag describing cautionary advice about source extraction process. Use less than 4 for well behaved objectsSMALLINT
flux_aper_8_gFlux measurement for circular aperturesREAL
flux_aper_8_iFlux measurement for circular aperturesREAL
flux_aper_8_rFlux measurement for circular aperturesREAL
flux_aper_8_yFlux measurement for circular aperturesREAL
flux_aper_8_zFlux measurement for circular aperturesREAL
flux_auto_gFlux measurement, for an elliptical model based on Kron radiusREAL
flux_auto_iFlux measurement, for an elliptical model based on Kron radiusREAL
flux_auto_rFlux measurement, for an elliptical model based on Kron radiusREAL
flux_auto_yFlux measurement, for an elliptical model based on Kron radiusREAL
flux_auto_zFlux measurement, for an elliptical model based on Kron radiusREAL
flux_radius_gHalf-light radius for the object, from elliptical growth-curve, modeled in 2 dimensionsREAL
flux_radius_iHalf-light radius for the object, from elliptical growth-curve, modeled in 2 dimensionsREAL
flux_radius_rHalf-light radius for the object, from elliptical growth-curve, modeled in 2 dimensionsREAL
flux_radius_yHalf-light radius for the object, from elliptical growth-curve, modeled in 2 dimensionsREAL
flux_radius_zHalf-light radius for the object, from elliptical growth-curve, modeled in 2 dimensionsREAL
fluxerr_aper_8_gUncertainty in aperture-flux measurement, elliptical model based on the Kron radiusREAL
fluxerr_aper_8_iUncertainty in aperture-flux measurement, elliptical model based on the Kron radiusREAL
fluxerr_aper_8_rUncertainty in aperture-flux measurement, elliptical model based on the Kron radiusREAL
fluxerr_aper_8_yUncertainty in aperture-flux measurement, elliptical model based on the Kron radiusREAL
fluxerr_aper_8_zUncertainty in aperture-flux measurement, elliptical model based on the Kron radiusREAL
fluxerr_auto_guncertainty in flux measurement, for an elliptical model based on Kron radiusREAL
fluxerr_auto_iuncertainty in flux measurement, for an elliptical model based on Kron radiusREAL
fluxerr_auto_runcertainty in flux measurement, for an elliptical model based on Kron radiusREAL
fluxerr_auto_yuncertainty in flux measurement, for an elliptical model based on Kron radiusREAL
fluxerr_auto_zuncertainty in flux measurement, for an elliptical model based on Kron radiusREAL
fwhm_image_gFWHM measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensionsREAL
fwhm_image_iFWHM measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensionsREAL
fwhm_image_rFWHM measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensionsREAL
fwhm_image_yFWHM measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensionsREAL
fwhm_image_zFWHM measured from the isophotal area, from elliptical growth-curve, modeled in 2 dimensionsREAL
g_rG-R colorREAL
galactic_bGalactic LatitudeDOUBLE
galactic_lGalactic LongitudeDOUBLE
hpix_1024Healpix ID for nside=1024, nested schemaBIGINT
hpix_16384Healpix ID for nside=16384, nested schemaBIGINT
hpix_32Healpix ID for nside=32, nested schemaBIGINT
hpix_4096Healpix ID for nside=4096, nested schemaBIGINT
hpix_64Healpix ID for nside=64, nested schemaBIGINT
htm9HTM Level-9 indexINTEGER
i_zI-Z colorREAL
imaflags_iso_gFlag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
imaflags_iso_iFlag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
imaflags_iso_rFlag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
imaflags_iso_yFlag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
imaflags_iso_zFlag identifying sources with missing/flagged pixels, considering all single epoch imagesINTEGER
isoarea_image_gIsophotal area of the coadded sourceINTEGER
isoarea_image_iIsophotal area of the coadded sourceINTEGER
isoarea_image_rIsophotal area of the coadded sourceINTEGER
isoarea_image_yIsophotal area of the coadded sourceINTEGER
isoarea_image_zIsophotal area of the coadded sourceINTEGER
kron_radiusKron radiusREAL
kron_radius_gKron radius measured from detection imageREAL
kron_radius_iKron radius measured from detection imageREAL
kron_radius_rKron radius measured from detection imageREAL
kron_radius_yKron radius measured from detection imageREAL
kron_radius_zKron radius measured from detection imageREAL
mag_aper_8_gMagnitude estimation for circular aperturesREAL
mag_aper_8_g_deredDereddened magnitude estimation (using SFD98) for circular aperturesREAL
mag_aper_8_iMagnitude estimation for circular aperturesREAL
mag_aper_8_i_deredDereddened magnitude estimation (using SFD98) for circular aperturesREAL
mag_aper_8_rMagnitude estimation for circular aperturesREAL
mag_aper_8_r_deredDereddened magnitude estimation (using SFD98) for circular aperturesREAL
mag_aper_8_yMagnitude estimation for circular aperturesREAL
mag_aper_8_y_deredDereddened magnitude estimation (using SFD98) for circular aperturesREAL
mag_aper_8_zMagnitude estimation for circular aperturesREAL
mag_aper_8_z_deredDereddened magnitude estimation (using SFD98) for circular aperturesREAL
mag_auto_gMagnitude estimation, for an elliptical model based on the Kron radiusREAL
mag_auto_g_deredDereddened magnitude estimation (using SFD98), for an elliptical model based on the Kron radiusREAL
mag_auto_iMagnitude estimation, for an elliptical model based on the Kron radiusREAL
mag_auto_i_deredDereddened magnitude estimation (using SFD98), for an elliptical model based on the Kron radiusREAL
mag_auto_rMagnitude estimation, for an elliptical model based on the Kron radiusREAL
mag_auto_r_deredDereddened magnitude estimation (using SFD98), for an elliptical model based on the Kron radiusREAL
mag_auto_yMagnitude estimation, for an elliptical model based on the Kron radiusREAL
mag_auto_y_deredDereddened magnitude estimation (using SFD98), for an elliptical model based on the Kron radiusREAL
mag_auto_zMagnitude estimation, for an elliptical model based on the Kron radiusREAL
mag_auto_z_deredDereddened magnitude estimation (using SFD98), for an elliptical model based on the Kron radiusREAL
magerr_aper_8_gUncertainty in magnitude estimation for circular aperturesREAL
magerr_aper_8_iUncertainty in magnitude estimation for circular aperturesREAL
magerr_aper_8_rUncertainty in magnitude estimation for circular aperturesREAL
magerr_aper_8_yUncertainty in magnitude estimation for circular aperturesREAL
magerr_aper_8_zUncertainty in magnitude estimation for circular aperturesREAL
magerr_auto_gUncertainty in magnitude estimation, for an elliptical model based on the Kron radiusREAL
magerr_auto_iUncertainty in magnitude estimation, for an elliptical model based on the Kron radiusREAL
magerr_auto_rUncertainty in magnitude estimation, for an elliptical model based on the Kron radiusREAL
magerr_auto_yUncertainty in magnitude estimation, for an elliptical model based on the Kron radiusREAL
magerr_auto_zUncertainty in magnitude estimation, for an elliptical model based on the Kron radiusREAL
nepochs_gNumber of epochs the source in detected in single epoch imagesINTEGER
nepochs_iNumber of epochs the source in detected in single epoch imagesINTEGER
nepochs_rNumber of epochs the source in detected in single epoch imagesINTEGER
nepochs_yNumber of epochs the source in detected in single epoch imagesINTEGER
nepochs_zNumber of epochs the source in detected in single epoch imagesINTEGER
nest4096Healpix ID with nside=4096, nested schemaINTEGER
niter_model_gNumber of iterations in model fitting photometric measurementsINTEGER
niter_model_iNumber of iterations in model fitting photometric measurementsINTEGER
niter_model_rNumber of iterations in model fitting photometric measurementsINTEGER
niter_model_yNumber of iterations in model fitting photometric measurementsINTEGER
niter_model_zNumber 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)DOUBLE
ring256Healpix ID with nside=256, ring schemaINTEGER
snr_gS/NREAL
snr_iS/NREAL
snr_rS/NREAL
snr_yS/NREAL
snr_zS/NREAL
spread_model_gMorphology based classifier based on comparison between a PSF versus exponential-PSF model. Values closer to 0 correspond to stars, larger values correspond to galaxies.REAL
spread_model_iMorphology based classifier based on comparison between a PSF versus exponential-PSF model. Values closer to 0 correspond to stars, larger values correspond to galaxies.REAL
spread_model_rMorphology based classifier based on comparison between a PSF versus exponential-PSF model. Values closer to 0 correspond to stars, larger values correspond to galaxies.REAL
spread_model_yMorphology based classifier based on comparison between a PSF versus exponential-PSF model. Values closer to 0 correspond to stars, larger values correspond to galaxies.REAL
spread_model_zMorphology based classifier based on comparison between a PSF versus exponential-PSF model. Values closer to 0 correspond to stars, larger values correspond to galaxies.REAL
spreaderr_model_gUncertainty in morphology based classifier based on comparison between PSF versus exponential-PSF model.REAL
spreaderr_model_iUncertainty in morphology based classifier based on comparison between PSF versus exponential-PSF model.REAL
spreaderr_model_rUncertainty in morphology based classifier based on comparison between PSF versus exponential-PSF model.REAL
spreaderr_model_yUncertainty in morphology based classifier based on comparison between PSF versus exponential-PSF model.REAL
spreaderr_model_zUncertainty 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 measurementREAL
thetawin_image_gPosition angle of source, for converged windowed measurement grow from x to yREAL
thetawin_image_iPosition angle of source, for converged windowed measurement grow from x to yREAL
thetawin_image_rPosition angle of source, for converged windowed measurement grow from x to yREAL
thetawin_image_yPosition angle of source, for converged windowed measurement grow from x to yREAL
thetawin_image_zPosition angle of source, for converged windowed measurement grow from x to yREAL
tilenameTile nameCHAR
wavg_flux_psf_gWeighted average flux measurement of PSF fit single epoch detectionsREAL
wavg_flux_psf_iWeighted average flux measurement of PSF fit single epoch detectionsREAL
wavg_flux_psf_rWeighted average flux measurement of PSF fit single epoch detectionsREAL
wavg_flux_psf_yWeighted average flux measurement of PSF fit single epoch detectionsREAL
wavg_flux_psf_zWeighted average flux measurement of PSF fit single epoch detectionsREAL
wavg_fluxerr_psf_gUncertainty of weighted average flux, of PSF fit single epoch detectionsREAL
wavg_fluxerr_psf_iUncertainty of weighted average flux, of PSF fit single epoch detectionsREAL
wavg_fluxerr_psf_rUncertainty of weighted average flux, of PSF fit single epoch detectionsREAL
wavg_fluxerr_psf_yUncertainty of weighted average flux, of PSF fit single epoch detectionsREAL
wavg_fluxerr_psf_zUncertainty of weighted average flux, of PSF fit single epoch detectionsREAL
wavg_mag_psf_gWeighted average magnitude, of PSF fit single epoch detectionsREAL
wavg_mag_psf_g_deredDereddened weighted average magnitude (using SFD98) from PSF fit single epoch detectionsREAL
wavg_mag_psf_iWeighted average magnitude, of PSF fit single epoch detectionsREAL
wavg_mag_psf_i_deredDereddened weighted average magnitude (using SFD98) from PSF fit single epoch detectionsREAL
wavg_mag_psf_rWeighted average magnitude, of PSF fit single epoch detectionsREAL
wavg_mag_psf_r_deredDereddened weighted average magnitude (using SFD98) from PSF fit single epoch detectionsREAL
wavg_mag_psf_yWeighted average magnitude, of PSF fit single epoch detectionsREAL
wavg_mag_psf_y_deredDereddened weighted average magnitude (using SFD98) from PSF fit single epoch detectionsREAL
wavg_mag_psf_zWeighted average magnitude, of PSF fit single epoch detectionsREAL
wavg_mag_psf_z_deredDereddened weighted average magnitude (using SFD98) from PSF fit single epoch detectionsREAL
wavg_magerr_psf_gUncertainty of weighted averaged magnitude, of PSF fit single epoch detectionsREAL
wavg_magerr_psf_iUncertainty of weighted averaged magnitude, of PSF fit single epoch detectionsREAL
wavg_magerr_psf_rUncertainty of weighted averaged magnitude, of PSF fit single epoch detectionsREAL
wavg_magerr_psf_yUncertainty of weighted averaged magnitude, of PSF fit single epoch detectionsREAL
wavg_magerr_psf_zUncertainty of weighted averaged magnitude, of PSF fit single epoch detectionsREAL
wavg_spread_model_gSPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spread_model_iSPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spread_model_rSPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spread_model_ySPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spread_model_zSPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_gUncertainty in SPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_iUncertainty in SPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_rUncertainty in SPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_yUncertainty in SPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
wavg_spreaderr_model_zUncertainty in SPREAD MODEL using the weighted averaged values from single epoch detectionsREAL
x2win_image_gSecond moment in x-direction, from converged windowed measurementsDOUBLE
x2win_image_iSecond moment in x-direction, from converged windowed measurementsDOUBLE
x2win_image_rSecond moment in x-direction, from converged windowed measurementsDOUBLE
x2win_image_ySecond moment in x-direction, from converged windowed measurementsDOUBLE
x2win_image_zSecond moment in x-direction, from converged windowed measurementsDOUBLE
xwin_imageX-centroid from windowed measurements on coadded imageDOUBLE
xwin_image_gX-centroid from windowed measurements on coadded imageDOUBLE
xwin_image_iX-centroid from windowed measurements on coadded imageDOUBLE
xwin_image_rX-centroid from windowed measurements on coadded imageDOUBLE
xwin_image_yX-centroid from windowed measurements on coadded imageDOUBLE
xwin_image_zX-centroid from windowed measurements on coadded imageDOUBLE
xywin_image_gSecond moment in xy-direction, from converged windowed measurementsDOUBLE
xywin_image_iSecond moment in xy-direction, from converged windowed measurementsDOUBLE
xywin_image_rSecond moment in xy-direction, from converged windowed measurementsDOUBLE
xywin_image_ySecond moment in xy-direction, from converged windowed measurementsDOUBLE
xywin_image_zSecond moment in xy-direction, from converged windowed measurementsDOUBLE
y2win_image_gSecond moment in y-direction, from converged windowed measurementsDOUBLE
y2win_image_iSecond moment in y-direction, from converged windowed measurementsDOUBLE
y2win_image_rSecond moment in y-direction, from converged windowed measurementsDOUBLE
y2win_image_ySecond moment in y-direction, from converged windowed measurementsDOUBLE
y2win_image_zSecond moment in y-direction, from converged windowed measurementsDOUBLE
ywin_imageY-centroid from windowed measurements on coadded imageDOUBLE
ywin_image_gY-centroid from windowed measurements on coadded imageDOUBLE
ywin_image_iY-centroid from windowed measurements on coadded imageDOUBLE
ywin_image_rY-centroid from windowed measurements on coadded imageDOUBLE
ywin_image_yY-centroid from windowed measurements on coadded imageDOUBLE
ywin_image_zY-centroid from windowed measurements on coadded imageDOUBLE
z_yZ-Y colorREAL