Choose a database in the left panel then select the table you want!
Table: delve_dr3.coadd_objects
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| a_fiducial_g | Fiducial reddening correction (subtract from magnitude) [mag] | REAL |
| a_fiducial_i | Fiducial reddening correction (subtract from magnitude) [mag] | REAL |
| a_fiducial_r | Fiducial reddening correction (subtract from magnitude) [mag] | REAL |
| a_fiducial_z | Fiducial reddening correction (subtract from magnitude) [mag] | REAL |
| a_image | Major axis size based on an isophotal model [pixel] | REAL |
| alphawin_j2000 | Right ascension with full precision (J2000 in ICRS system; not indexed) [degrees] | DOUBLE |
| b_image | Minor axis size based on an isophotal model [pixel] | REAL |
| badpix_frac | Fraction of pixels in the FITVD fitting region labelled as bad | DOUBLE |
| bdf_deblend_flags | Shredder deblend flag bits: 1 no deblend, 2 PSF fit failed, 4 initial deblend on coadd failed, 8 multi-fit deblend failed | INTEGER |
| bdf_flags | BDF fit flags | INTEGER |
| bdf_flux_cov_1_1 | Diagonal variance on the BDF flux g band | DOUBLE |
| bdf_flux_cov_1_2 | Off-diagonal variance on the BDF flux difference in (g-r) | DOUBLE |
| bdf_flux_cov_1_3 | Off-diagonal variance on the BDF flux difference in (g-i) | DOUBLE |
| bdf_flux_cov_1_4 | Off-diagonal variance on the BDF flux difference in (g-z) | DOUBLE |
| bdf_flux_cov_2_1 | Off-diagonal variance on the BDF flux difference in (r-g) | DOUBLE |
| bdf_flux_cov_2_2 | Diagonal variance on the BDF flux r band | DOUBLE |
| bdf_flux_cov_2_3 | Off-diagonal variance on the BDF flux difference in (r-i) | DOUBLE |
| bdf_flux_cov_2_4 | Off-diagonal variance on the BDF flux difference in (r-z) | DOUBLE |
| bdf_flux_cov_3_1 | Off-diagonal variance on the BDF flux difference in (i-g) | DOUBLE |
| bdf_flux_cov_3_2 | Off-diagonal variance on the BDF flux difference in (i-r) | DOUBLE |
| bdf_flux_cov_3_3 | Diagonal variance on the BDF flux i band | DOUBLE |
| bdf_flux_cov_3_4 | Off-diagonal variance on the BDF flux difference in (i-z) | DOUBLE |
| bdf_flux_cov_4_1 | Off-diagonal variance on the BDF flux difference in (z-g) | DOUBLE |
| bdf_flux_cov_4_2 | Off-diagonal variance on the BDF flux difference in (z-r) | DOUBLE |
| bdf_flux_cov_4_3 | Off-diagonal variance on the BDF flux difference in (z-i) | DOUBLE |
| bdf_flux_cov_4_4 | Diagonal variance on the BDF flux z band | DOUBLE |
| bdf_flux_err_g | Uncertainty on BDF_FLUX [3.63 nJy] | DOUBLE |
| bdf_flux_err_g_corrected | Uncertainty on BDF_FLUX_CORRECTED [3.63 nJy] | DOUBLE |
| bdf_flux_err_i | Uncertainty on BDF_FLUX [3.63 nJy] | DOUBLE |
| bdf_flux_err_i_corrected | Uncertainty on BDF_FLUX_CORRECTED [3.63 nJy] | DOUBLE |
| bdf_flux_err_r | Uncertainty on BDF_FLUX [3.63 nJy] | DOUBLE |
| bdf_flux_err_r_corrected | Uncertainty on BDF_FLUX_CORRECTED [3.63 nJy] | DOUBLE |
| bdf_flux_err_z | Uncertainty on BDF_FLUX [3.63 nJy] | DOUBLE |
| bdf_flux_err_z_corrected | Uncertainty on BDF_FLUX_CORRECTED [3.63 nJy] | DOUBLE |
| bdf_flux_g | Flux derived with BDF model. No aperture correction, top of atmosphere. [3.63 nJy] | DOUBLE |
| bdf_flux_g_corrected | BDF_FLUX corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). [3.63 nJy] | DOUBLE |
| bdf_flux_i | Flux derived with BDF model. No aperture correction, top of atmosphere. [3.63 nJy] | DOUBLE |
| bdf_flux_i_corrected | BDF_FLUX corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). [3.63 nJy] | DOUBLE |
| bdf_flux_r | Flux derived with BDF model. No aperture correction, top of atmosphere. [3.63 nJy] | DOUBLE |
| bdf_flux_r_corrected | BDF_FLUX corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). [3.63 nJy] | DOUBLE |
| bdf_flux_z | Flux derived with BDF model. No aperture correction, top of atmosphere. [3.63 nJy] | DOUBLE |
| bdf_flux_z_corrected | BDF_FLUX corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). [3.63 nJy] | DOUBLE |
| bdf_fracdev | Fraction assigned to De Vaucouleurs profile in composite model. | DOUBLE |
| bdf_fracdev_err | Uncertainty on BDF_FRACDEV | DOUBLE |
| bdf_g_1 | First component of gamma giving axis ratio and position angle of ellipse fit | DOUBLE |
| bdf_g_2 | Second component of gamma giving axis ratio and position angle of ellipse fit | DOUBLE |
| bdf_g_cov_1_1 | Covariance of gamma 1,2 axis ratio and position angle components (1,1) term | DOUBLE |
| bdf_g_cov_1_2 | Covariance of gamma 1,2 axis ratio and position angle components (1,2) term | DOUBLE |
| bdf_g_cov_2_1 | Covariance of gamma 1,2 axis ratio and position angle components (2,1) term | DOUBLE |
| bdf_g_cov_2_2 | Covariance of gamma 1,2 axis ratio and position angle components (2,2) term | DOUBLE |
| bdf_gmr_err | Uncertainty on g-r color, accounting for covariance [mag] | DOUBLE |
| bdf_imz_err | Uncertainty on i-z color, accounting for covariance [mag] | DOUBLE |
| bdf_mag_err_g | Uncertainty on BDF_MAG [mag] | DOUBLE |
| bdf_mag_err_i | Uncertainty on BDF_MAG [mag] | DOUBLE |
| bdf_mag_err_r | Uncertainty on BDF_MAG [mag] | DOUBLE |
| bdf_mag_err_z | Uncertainty on BDF_MAG [mag] | DOUBLE |
| bdf_mag_g | Magnitude measured by FITVD BDF model. No aperture correction, top of atmosphere [mag] | DOUBLE |
| bdf_mag_g_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) [mag] | DOUBLE |
| bdf_mag_i | Magnitude measured by FITVD BDF model. No aperture correction, top of atmosphere [mag] | DOUBLE |
| bdf_mag_i_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) [mag] | DOUBLE |
| bdf_mag_r | Magnitude measured by FITVD BDF model. No aperture correction, top of atmosphere [mag] | DOUBLE |
| bdf_mag_r_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) [mag] | DOUBLE |
| bdf_mag_z | Magnitude measured by FITVD BDF model. No aperture correction, top of atmosphere [mag] | DOUBLE |
| bdf_mag_z_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) [mag] | DOUBLE |
| bdf_nfev | integer of function evaluations during BDF fit. | INTEGER |
| bdf_ntry | Number of times the fit was attempted. | SMALLINT |
| bdf_pars_1 | BDF fit parameter 1: row-offset fit position of object in MEDs postage stamp [arcsec] | DOUBLE |
| bdf_pars_2 | BDF fit parameter 2: col-offset fit position of object in MEDs postage stamp [arcsec] | DOUBLE |
| bdf_pars_err_1 | Error on x-offset [arcsec] | DOUBLE |
| bdf_pars_err_2 | Error on y-offset [arcsec] | DOUBLE |
| bdf_rmi_err | Uncertainty on r-i color, accounting for covariance [mag] | DOUBLE |
| bdf_s2n | Signal-to-noise on BDF fit, combining all bands | DOUBLE |
| bdf_t | Intrinsic squared size of best-fit BDF model, before PSF convolution [arcsec^2] | DOUBLE |
| bdf_t_err | Uncertainty on BDF_T [arcsec^2] | DOUBLE |
| bdf_t_ratio | Ratio of BDF_T of the object to PSF_T at the location of the object (stars are near zero). | DOUBLE |
| coadd_object_id | Unique identifier for the coadded objects | BIGINT |
| dec | Declination with quantized precision for indexing (J2000 in ICRS system; see DELTAWIN_J2000 for full precision) [degrees] | DOUBLE |
| deltawin_j2000 | Declination with full precision (J2000 in ICRS system; not indexed) [degrees] | DOUBLE |
| dnf_d1 | DNF photo-z photometric directional distance to nearest neighbor. | DOUBLE |
| dnf_de1 | DNF photo-z photometric Euclidean distance to nearest neighbor. | DOUBLE |
| dnf_id1 | DNF photo-z COADD_OBJECT_ID corresponding to the nearest neighbor in the training sample. | BIGINT |
| dnf_nneighbors | DNF photo-z number of neighbors used for the DNF_Z estimate | DOUBLE |
| dnf_z | DNF photo-z primary point estimate obtained by fitting to the directional neighborhood. Useful for clasification in tomographic bins. | DOUBLE |
| dnf_zerr_fit | DNF photo-z error term derived from the residuals of the regression fit | DOUBLE |
| dnf_zerr_param | DNF photo-z error term due to magnitude/flux uncertainties propagation | DOUBLE |
| dnf_zn | DNF photo-z nearest neighbor spec-z. Useful for estimating N(z) for a given sample. | DOUBLE |
| dnf_zsigma | DNF photo-z uncertainty estimate from photometric uncertainties and residuals from the neighborhood fit | DOUBLE |
| ebv_sfd98 | E(B-V) reddening coefficient from Schlegel, Finkbeiner & Davis, 1998 [mag] | REAL |
| elat | Ecliptic latitude [degrees] | DOUBLE |
| elon | Ecliptic longitude [degrees] | DOUBLE |
| erra_image | Uncertainty in major axis size, from isophotal model [pixel] | REAL |
| errb_image | Uncertainty in minor axis size, from isophotal model [pixel] | REAL |
| errtheta_image | Uncertainty in source position, from isophotal model [degrees] | REAL |
| ext_coadd | Extended object classification from coadd SourceExtractor measurements. 0: high-confidence stars; 1: candidate stars; 2: mostly galaxies; 3: high-confidence galaxies; -9: No data | SMALLINT |
| ext_fitvd | Extended object classification from FITVD multi-epoch fit. 0: high-confidence stars; 1: candidate stars; 2: mostly galaxies; 3: high confidence galaxies; 4: pure galaxy sample; -9: No data | SMALLINT |
| ext_mash | Extended object classification combined for COADD, WAVG, and FITVD. 0: high-confidence stars; 1: candidate stars; 2: mostly galaxies; 3: high confidence galaxies; 4: pure galaxy sample; -9: No data | SMALLINT |
| ext_wavg | Extended object classification from WAVG single-epoch measurements. 0: high-confidence stars; 1: candidate stars; 2: mostly galaxies; 3: high-confidence galaxies; -9: No data | SMALLINT |
| ext_xgb | Extended object classification based on XGBoost morphological classifier. 0: high-confidence stars; 1: candidate stars; 2: mostly galaxies; 3: high confidence galaxies; 4: pure galaxy sample; -9: No data | SMALLINT |
| fitvd_flags | Flag for FITVD BDF fit failure (0=success, 1=failure) | INTEGER |
| flags_footprint | Use FLAGS_FOOTPRINT == 1 to select objects inside the standard Gold footprint. See Section 5.1 of Bechtol et al. (2025) | SMALLINT |
| flags_foreground | Flag describing whether the object is contained in a region with a foreground astrophysical object; recommend FLAGS_FOREGROUND = 0 for general extragalactic studies. See Section 5.2 of Bechtol et al. (2025). | REAL |
| flags_gold | Flag describing object anomalies; recommed FLAGS_GOLD = 0 for most analyses. See Section 4.3 of Bechtol et al. (2025) | SMALLINT |
| flagstr | Brief description of BDF quality flag. See Section 3.4 of Bechtol et al. (2025) | VARCHAR |
| flux_radius_g | Half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel] | REAL |
| flux_radius_i | Half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel] | REAL |
| flux_radius_r | Half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel] | REAL |
| flux_radius_z | Half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions [pixel] | REAL |
| fof_id | Friends-of-friends shredder group ID number | BIGINT |
| fof_size | Friends-of-friends shredder group size | SMALLINT |
| gap_flux_err_g | Uncertainty on Gaussian aperture flux [3.63 nJy] | DOUBLE |
| gap_flux_err_i | Uncertainty on Gaussian aperture flux [3.63 nJy] | DOUBLE |
| gap_flux_err_r | Uncertainty on Gaussian aperture flux [3.63 nJy] | DOUBLE |
| gap_flux_err_z | Uncertainty on Gaussian aperture flux [3.63 nJy] | DOUBLE |
| gap_flux_g | Gaussian Aperture fluxes with FWHM=4 arcsec [3.63 nJy] | DOUBLE |
| gap_flux_i | Gaussian Aperture fluxes with FWHM=4 arcsec [3.63 nJy] | DOUBLE |
| gap_flux_r | Gaussian Aperture fluxes with FWHM=4 arcsec [3.63 nJy] | DOUBLE |
| gap_flux_z | Gaussian Aperture fluxes with FWHM=4 arcsec [3.63 nJy] | DOUBLE |
| gap_mag_err_g | Uncertainty on Gaussian aperture magnitude [mag] | DOUBLE |
| gap_mag_err_i | Uncertainty on Gaussian aperture magnitude [mag] | DOUBLE |
| gap_mag_err_r | Uncertainty on Gaussian aperture magnitude [mag] | DOUBLE |
| gap_mag_err_z | Uncertainty on Gaussian aperture magnitude [mag] | DOUBLE |
| gap_mag_g | Magnitude measured by Gaussian aperture fit [mag] | DOUBLE |
| gap_mag_i | Magnitude measured by Gaussian aperture fit [mag] | DOUBLE |
| gap_mag_r | Magnitude measured by Gaussian aperture fit [mag] | DOUBLE |
| gap_mag_z | Magnitude measured by Gaussian aperture fit [mag] | DOUBLE |
| glat | Latitude in Galactic coordinates [degrees] | REAL |
| glon | Longitude in Galactic coordinates [degrees] | REAL |
| hpix_1024 | HEALPix index for NSIDE = 1024 in NEST schema for the object | INTEGER |
| hpix_16384 | HEALPix index for NSIDE = 16384 in NEST schema for the object | BIGINT |
| hpix_32 | HEALPix index for NSIDE = 32 in NEST schema for the object | INTEGER |
| hpix_4096 | HEALPix index for NSIDE = 4096 in NEST schema for the object | INTEGER |
| hpix_64 | HEALPix index for NSIDE = 64 in NEST schema for the object | INTEGER |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| imaflags_iso_g | Flag identifying sources with missing/flagged pixels, considering all single-epoch images | INTEGER |
| imaflags_iso_i | Flag identifying sources with missing/flagged pixels, considering all single-epoch images | INTEGER |
| imaflags_iso_r | Flag identifying sources with missing/flagged pixels, considering all single-epoch images | INTEGER |
| imaflags_iso_z | Flag identifying sources with missing/flagged pixels, considering all single-epoch images | INTEGER |
| kron_radius | Kron radius measured from detection image [pixel] | REAL |
| mag_auto_g | Magnitude measured in elliptical aperture based on Kron radius [mag] | REAL |
| mag_auto_i | Magnitude measured in elliptical aperture based on Kron radius [mag] | REAL |
| mag_auto_r | Magnitude measured in elliptical aperture based on Kron radius [mag] | REAL |
| mag_auto_z | Magnitude measured in elliptical aperture based on Kron radius [mag] | REAL |
| mag_detmodel_g | Magnitude measured by a galaxy model fit (simple Sersic disk with index = 1) to the objects in the detection image [mag] | REAL |
| mag_detmodel_i | Magnitude measured by a galaxy model fit (simple Sersic disk with index = 1) to the objects in the detection image [mag] | REAL |
| mag_detmodel_r | Magnitude measured by a galaxy model fit (simple Sersic disk with index = 1) to the objects in the detection image [mag] | REAL |
| mag_detmodel_z | Magnitude measured by a galaxy model fit (simple Sersic disk with index = 1) to the objects in the detection image [mag] | REAL |
| magerr_auto_g | Uncertainty in MAG_AUTO [mag] | REAL |
| magerr_auto_i | Uncertainty in MAG_AUTO [mag] | REAL |
| magerr_auto_r | Uncertainty in MAG_AUTO [mag] | REAL |
| magerr_auto_z | Uncertainty in MAG_AUTO [mag] | REAL |
| magerr_detmodel_g | Uncertainty in MAG_DETMODEL [mag] | REAL |
| magerr_detmodel_i | Uncertainty in MAG_DETMODEL [mag] | REAL |
| magerr_detmodel_r | Uncertainty in MAG_DETMODEL [mag] | REAL |
| magerr_detmodel_z | Uncertainty in MAG_DETMODEL [mag] | REAL |
| mu_eff_model_g | Effective model surface brightness at the isophote which includes half of the flux from the model [mag/arcsec^2] | REAL |
| mu_eff_model_i | Effective model surface brightness at the isophote which includes half of the flux from the model [mag/arcsec^2] | REAL |
| mu_eff_model_r | Effective model surface brightness at the isophote which includes half of the flux from the model [mag/arcsec^2] | REAL |
| mu_eff_model_z | Effective model surface brightness at the isophote which includes half of the flux from the model [mag/arcsec^2] | REAL |
| mu_max_g | Surface brightness at brightest pixel [mag/arcsec^2] | REAL |
| mu_max_i | Surface brightness at brightest pixel [mag/arcsec^2] | REAL |
| mu_max_model_g | Maximum surface brightness using the whole area inside the isophote used for MU_EFF_MODEL [mag/arcsec^2] | REAL |
| mu_max_model_i | Maximum surface brightness using the whole area inside the isophote used for MU_EFF_MODEL [mag/arcsec^2] | REAL |
| mu_max_model_r | Maximum surface brightness using the whole area inside the isophote used for MU_EFF_MODEL [mag/arcsec^2] | REAL |
| mu_max_model_z | Maximum surface brightness using the whole area inside the isophote used for MU_EFF_MODEL [mag/arcsec^2] | REAL |
| mu_max_r | Surface brightness at brightest pixel [mag/arcsec^2] | REAL |
| mu_max_z | Surface brightness at brightest pixel [mag/arcsec^2] | REAL |
| mu_mean_model_g | Mean surface brightness using the whole area inside the isophote used for MU_EFF_MODEL [mag/arcsec^2] | REAL |
| mu_mean_model_i | Mean surface brightness using the whole area inside the isophote used for MU_EFF_MODEL [mag/arcsec^2] | REAL |
| mu_mean_model_r | Mean surface brightness using the whole area inside the isophote used for MU_EFF_MODEL [mag/arcsec^2] | REAL |
| mu_mean_model_z | Mean surface brightness using the whole area inside the isophote used for MU_EFF_MODEL [mag/arcsec^2] | REAL |
| mu_threshold_g | Surface brightness threshold (SourceExtractor parameter) [mag/arcsec^2] | REAL |
| mu_threshold_i | Surface brightness threshold (SourceExtractor parameter) [mag/arcsec^2] | REAL |
| mu_threshold_r | Surface brightness threshold (SourceExtractor parameter) [mag/arcsec^2] | REAL |
| mu_threshold_z | Surface brightness threshold (SourceExtractor parameter) [mag/arcsec^2] | REAL |
| nepochs_g | Number of good single-epoch detections of the coadd object | INTEGER |
| nepochs_i | Number of good single-epoch detections of the coadd object | INTEGER |
| nepochs_r | Number of good single-epoch detections of the coadd object | INTEGER |
| nepochs_z | Number of good single-epoch detections of the coadd object | INTEGER |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size) | INTEGER |
| niter_model_g | Number of iterations needed to converge on the MODEL parameters | SMALLINT |
| niter_model_i | Number of iterations needed to converge on the MODEL parameters | SMALLINT |
| niter_model_r | Number of iterations needed to converge on the MODEL parameters | SMALLINT |
| niter_model_z | Number of iterations needed to converge on the MODEL parameters | SMALLINT |
| object_number | SourceExtractor unique running object number within a DES coadd tile. | INTEGER |
| parent_number | SourceExtractor parent object ID before deblending. | INTEGER |
| pfw_attempt_id | DESDM internal processing index number | BIGINT |
| psf_flux_aper_8_g | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) [3.63 nJy] | DOUBLE |
| psf_flux_aper_8_i | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) [3.63 nJy] | DOUBLE |
| psf_flux_aper_8_r | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) [3.63 nJy] | DOUBLE |
| psf_flux_aper_8_z | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) [3.63 nJy] | DOUBLE |
| psf_flux_err_aper_8_g | Uncertainty on PSF_FLUX_APER_8 [3.63 nJy] | DOUBLE |
| psf_flux_err_aper_8_i | Uncertainty on PSF_FLUX_APER_8 [3.63 nJy] | DOUBLE |
| psf_flux_err_aper_8_r | Uncertainty on PSF_FLUX_APER_8 [3.63 nJy] | DOUBLE |
| psf_flux_err_aper_8_z | Uncertainty on PSF_FLUX_APER_8 [3.63 nJy] | DOUBLE |
| psf_flux_flags_g | Flags for FITVD PSF flux measurement: 0=success, 1=bad variance, 512=divide by zero, 1024=degrees of freedom are zero | INTEGER |
| psf_flux_flags_i | Flags for FITVD PSF flux measurement: 0=success, 1=bad variance, 512=divide by zero, 1024=degrees of freedom are zero | INTEGER |
| psf_flux_flags_r | Flags for FITVD PSF flux measurement: 0=success, 1=bad variance, 512=divide by zero, 1024=degrees of freedom are zero | INTEGER |
| psf_flux_flags_z | Flags for FITVD PSF flux measurement: 0=success, 1=bad variance, 512=divide by zero, 1024=degrees of freedom are zero | INTEGER |
| psf_flux_ratio_aper_8_g | PSF aperture correction to put BDF corrected magnitudes onto FGCM photometric system | DOUBLE |
| psf_flux_ratio_aper_8_i | PSF aperture correction to put BDF corrected magnitudes onto FGCM photometric system | DOUBLE |
| psf_flux_ratio_aper_8_r | PSF aperture correction to put BDF corrected magnitudes onto FGCM photometric system | DOUBLE |
| psf_flux_ratio_aper_8_z | PSF aperture correction to put BDF corrected magnitudes onto FGCM photometric system | DOUBLE |
| psf_flux_s2n_aper_8_g | S/N in PSF flux measurement from FITVD in APER8 system | DOUBLE |
| psf_flux_s2n_aper_8_i | S/N in PSF flux measurement from FITVD in APER8 system | DOUBLE |
| psf_flux_s2n_aper_8_r | S/N in PSF flux measurement from FITVD in APER8 system | DOUBLE |
| psf_flux_s2n_aper_8_z | S/N in PSF flux measurement from FITVD in APER8 system | DOUBLE |
| psf_g_1 | Ellipticity of the multi-Gaussian model fit to the PSF (component 1) at the location of the object | DOUBLE |
| psf_g_2 | Ellipticity of the multi-Gaussian model fit to the PSF (component 2) at the location of the object | DOUBLE |
| psf_mag_aper_8_g | Magnitude measured by FITVD PSF model in APER8 system (reddened top of atmosphere) [mag] | DOUBLE |
| psf_mag_aper_8_g_corrected | Magnitude measured by FITVD PSF model corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system). Recommended for point-source studies. [mag] | DOUBLE |
| psf_mag_aper_8_i | Magnitude measured by FITVD PSF model in APER8 system (reddened top of atmosphere) [mag] | DOUBLE |
| psf_mag_aper_8_i_corrected | Magnitude measured by FITVD PSF model corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system). Recommended for point-source studies. [mag] | DOUBLE |
| psf_mag_aper_8_r | Magnitude measured by FITVD PSF model in APER8 system (reddened top of atmosphere) [mag] | DOUBLE |
| psf_mag_aper_8_r_corrected | Magnitude measured by FITVD PSF model corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system). Recommended for point-source studies. [mag] | DOUBLE |
| psf_mag_aper_8_z | Magnitude measured by FITVD PSF model in APER8 system (reddened top of atmosphere) [mag] | DOUBLE |
| psf_mag_aper_8_z_corrected | Magnitude measured by FITVD PSF model corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system). Recommended for point-source studies. [mag] | DOUBLE |
| psf_mag_err_aper_8_g | Uncertainty in PSF_MAG_APER8 [mag] | DOUBLE |
| psf_mag_err_aper_8_i | Uncertainty in PSF_MAG_APER8 [mag] | DOUBLE |
| psf_mag_err_aper_8_r | Uncertainty in PSF_MAG_APER8 [mag] | DOUBLE |
| psf_mag_err_aper_8_z | Uncertainty in PSF_MAG_APER8 [mag] | DOUBLE |
| psf_t | Squared-size for a multi-Gaussian model fit to the PSF at the location of the object [arcsec^2] | DOUBLE |
| ra | Right ascension with quantized precision for indexing (J2000 in ICRS system; see ALPHAWIN_J2000 for full precision) [degrees] | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| s_extractor_flags_g | Flag for SourceExtractor measurement | SMALLINT |
| s_extractor_flags_i | Flag for SourceExtractor measurement | SMALLINT |
| s_extractor_flags_r | Flag for SourceExtractor measurement | SMALLINT |
| s_extractor_flags_z | Flag for SourceExtractor measurement | SMALLINT |
| source | Version name | VARCHAR |
| spread_model_g | Likelihood ratio between PSF model fit and an exponential model fit measured on the coadd. See Desai et al. (2012) | REAL |
| spread_model_i | Likelihood ratio between PSF model fit and an exponential model fit measured on the coadd. See Desai et al. (2012) | REAL |
| spread_model_r | Likelihood ratio between PSF model fit and an exponential model fit measured on the coadd. See Desai et al. (2012) | REAL |
| spread_model_z | Likelihood ratio between PSF model fit and an exponential model fit measured on the coadd. See Desai et al. (2012) | REAL |
| spreaderr_model_g | Uncertainty in SPREAD_MODEL | REAL |
| spreaderr_model_i | Uncertainty in SPREAD_MODEL | REAL |
| spreaderr_model_r | Uncertainty in SPREAD_MODEL | REAL |
| spreaderr_model_z | Uncertainty in SPREAD_MODEL | REAL |
| theta_j2000 | Position angle of source in J2000 coordinates, from non-windowed measurement [degrees] | REAL |
| tilename | Unique name of DES coadd tile containing the object | VARCHAR |
| wavg_mag_psf_g | Magnitude measured by weighted-average of PSF fit to single-epoch detections [mag] | REAL |
| wavg_mag_psf_i | Magnitude measured by weighted-average of PSF fit to single-epoch detections [mag] | REAL |
| wavg_mag_psf_r | Magnitude measured by weighted-average of PSF fit to single-epoch detections [mag] | REAL |
| wavg_mag_psf_z | Magnitude measured by weighted-average of PSF fit to single-epoch detections [mag] | REAL |
| wavg_magerr_psf_g | Uncertainty in WAVG_MAG_PSF [mag] | REAL |
| wavg_magerr_psf_i | Uncertainty in WAVG_MAG_PSF [mag] | REAL |
| wavg_magerr_psf_r | Uncertainty in WAVG_MAG_PSF [mag] | REAL |
| wavg_magerr_psf_z | Uncertainty in WAVG_MAG_PSF [mag] | REAL |
| wavg_spread_model_g | Weighted-average SPREAD_MODEL from single-epoch detections | REAL |
| wavg_spread_model_i | Weighted-average SPREAD_MODEL from single-epoch detections | REAL |
| wavg_spread_model_r | Weighted-average SPREAD_MODEL from single-epoch detections | REAL |
| wavg_spread_model_z | Weighted-average SPREAD_MODEL from single-epoch detections | REAL |
| wavg_spreaderr_model_g | Uncertainty in WAVG_SPREAD_MODEL | REAL |
| wavg_spreaderr_model_i | Uncertainty in WAVG_SPREAD_MODEL | REAL |
| wavg_spreaderr_model_r | Uncertainty in WAVG_SPREAD_MODEL | REAL |
| wavg_spreaderr_model_z | Uncertainty in WAVG_SPREAD_MODEL | REAL |
| xgb_pred | Output pseudo-probability of the XGBoost star/galaxy classifer. Galaxies have XGB_PRED ~ 0 and stars have XGB_PRED ~ 1. See Section 4.2 of Bechtol et al. (2025). | REAL |
| xwin_image | X-centroid from windowed measurements on coadded detection image [pixel] | DOUBLE |
| ywin_image | Y-centroid from windowed measurements on coadded detection image [pixel] | DOUBLE |
