Choose a database in the left panel then select the table you want!
Table: des_dr2.y6_gold
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| a_fiducial_g | SED-independent interstellar extinction based on the E(B - V) reddening maps from Schlegel, Finkbeiner & Davis (1998) in band g | DOUBLE |
| a_fiducial_i | SED-independent interstellar extinction based on the E(B - V) reddening maps from Schlegel, Finkbeiner & Davis (1998) in band i | DOUBLE |
| a_fiducial_r | SED-independent interstellar extinction based on the E(B - V) reddening maps from Schlegel, Finkbeiner & Davis (1998) in band r | DOUBLE |
| a_fiducial_y | SED-independent interstellar extinction based on the E(B - V) reddening maps from Schlegel, Finkbeiner & Davis (1998) in band Y | DOUBLE |
| a_fiducial_z | SED-independent interstellar extinction based on the E(B - V) reddening maps from Schlegel, Finkbeiner & Davis (1998) in band z | DOUBLE |
| a_image | Detection image based basic shape parameter; A = semimajor-axis | DOUBLE |
| alphawin_j2000 | Right Ascension (J2000.0) of the object using a Gaussian window with a FWHM corresponding to the disk containing 50% of the flux | DOUBLE |
| b_image | Detection image based basic shape parameter; B = semiminor-axis | DOUBLE |
| 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 | SMALLINT |
| 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_1_5 | Off-diagonal variance on the BDF flux difference in (g-Y) | 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_2_5 | Off-diagonal variance on the BDF flux difference in (r-Y) | 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_3_5 | Off-diagonal variance on the BDF flux difference in (i-Y) | 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_cov_4_5 | Off-diagonal variance on the BDF flux difference in (z-Y) | DOUBLE |
| bdf_flux_cov_5_1 | Off-diagonal variance on the BDF flux difference in (Y-g) | DOUBLE |
| bdf_flux_cov_5_2 | Off-diagonal variance on the BDF flux difference in (Y-r) | DOUBLE |
| bdf_flux_cov_5_3 | Off-diagonal variance on the BDF flux difference in (Y-i) | DOUBLE |
| bdf_flux_cov_5_4 | Off-diagonal variance on the BDF flux difference in (Y-z) | DOUBLE |
| bdf_flux_cov_5_5 | Diagonal variance on the BDF flux Y band | DOUBLE |
| bdf_flux_err_g | Uncertainty on BDF_FLUX_G | DOUBLE |
| bdf_flux_err_g_corrected | Uncertainty on BDF_FLUX_CORRECTED_G | DOUBLE |
| bdf_flux_err_i | Uncertainty on BDF_FLUX_I | DOUBLE |
| bdf_flux_err_i_corrected | Uncertainty on BDF_FLUX_CORRECTED_I | DOUBLE |
| bdf_flux_err_r | Uncertainty on BDF_FLUX_R | DOUBLE |
| bdf_flux_err_r_corrected | Uncertainty on BDF_FLUX_CORRECTED_R | DOUBLE |
| bdf_flux_err_y | Uncertainty on BDF_FLUX_Y | DOUBLE |
| bdf_flux_err_y_corrected | Uncertainty on BDF_FLUX_CORRECTED_Y | DOUBLE |
| bdf_flux_err_z | Uncertainty on BDF_FLUX_Z | DOUBLE |
| bdf_flux_err_z_corrected | Uncertainty on BDF_FLUX_CORRECTED_Z | DOUBLE |
| bdf_flux_g | Flux derived with BDF model in g-band. No aperture correction, top of atmosphere. | DOUBLE |
| bdf_flux_g_corrected | BDF_FLUX_G corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). | DOUBLE |
| bdf_flux_i | Flux derived with BDF model in i-band. No aperture correction, top of atmosphere. | DOUBLE |
| bdf_flux_i_corrected | BDF_FLUX_I corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). | DOUBLE |
| bdf_flux_r | Flux derived with BDF model in r-band. No aperture correction, top of atmosphere. | DOUBLE |
| bdf_flux_r_corrected | BDF_FLUX_R corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). | DOUBLE |
| bdf_flux_y | Flux derived with BDF model in Y-band. No aperture correction, top of atmosphere. | DOUBLE |
| bdf_flux_y_corrected | BDF_FLUX_Y corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). | DOUBLE |
| bdf_flux_z | Flux derived with BDF model in z-band. No aperture correction, top of atmosphere. | DOUBLE |
| bdf_flux_z_corrected | BDF_FLUX_Z corrected for interstellar extinction (i.e. de-reddened; top of Galaxy) and PSF aperture ratio (APER8 system). | 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 | DOUBLE |
| bdf_imz_err | Uncertainty on i-z color, accounting for covariance | DOUBLE |
| bdf_mag_err_g | Uncertainty on BDF_MAG_G | DOUBLE |
| bdf_mag_err_i | Uncertainty on BDF_MAG_I | DOUBLE |
| bdf_mag_err_r | Uncertainty on BDF_MAG_R | DOUBLE |
| bdf_mag_err_y | Uncertainty on BDF_MAG_Y | DOUBLE |
| bdf_mag_err_z | Uncertainty on BDF_MAG_Z | DOUBLE |
| bdf_mag_g | Magnitude measured by FITVD BDF model in g-band. No aperture correction, top of atmosphere | DOUBLE |
| bdf_mag_g_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) | DOUBLE |
| bdf_mag_i | Magnitude measured by FITVD BDF model in i-band. No aperture correction, top of atmosphere | DOUBLE |
| bdf_mag_i_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) | DOUBLE |
| bdf_mag_r | Magnitude measured by FITVD BDF model in r-band. No aperture correction, top of atmosphere | DOUBLE |
| bdf_mag_r_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) | DOUBLE |
| bdf_mag_y | Magnitude measured by FITVD BDF model in Y-band. No aperture correction, top of atmosphere | DOUBLE |
| bdf_mag_y_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) | DOUBLE |
| bdf_mag_z | Magnitude measured by FITVD BDF model in z-band. No aperture correction, top of atmosphere | DOUBLE |
| bdf_mag_z_corrected | BDF_MAG corrected for interstellar extinction (de-reddened top of Galaxy) and PSF aperture ratio (APER8 system) | DOUBLE |
| bdf_nfev | Number 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 | DOUBLE |
| bdf_pars_2 | BDF fit parameter 2: col-offset fit position of object in MEDs postage stamp | DOUBLE |
| bdf_pars_err_1 | Error on x-offset | DOUBLE |
| bdf_pars_err_2 | Error on y-offset | DOUBLE |
| bdf_rmi_err | Uncertainty on r-i color, accounting for covariance | 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 | DOUBLE |
| bdf_t_err | Uncertainty on BDF_T | 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 |
| bdf_zmy_err | Uncertainty on z-Y color, accounting for covariance | DOUBLE |
| coadd_object_id | Unique identifier for the coadded objects | INTEGER |
| conc | Concentration index -- values near 0 indicate stellar object, significantly above 0 extended | DOUBLE |
| conc_flags | Flag for CONC index fit failure (0 = success; 1 = failure) | SMALLINT |
| coverfrac_griz | Fractional area of HEALPix (nside=4096) pixel covered simultaneously by griz bands | DOUBLE |
| coverfrac_grizy | Fractional area of HEALPix (nside=4096) pixel covered simultaneously by grizY bands | DOUBLE |
| coverfrac_riz | Fractional area of HEALPix (nside=4096) pixel covered simultaneously by riz bands | DOUBLE |
| coverfrac_rizy | Fractional area of HEALPix (nside=4096) pixel covered simultaneously by rizY bands | DOUBLE |
| dec | Declination (J2000.0) with quantized precision for indexing (DELTAWIN_J2000 has full precision but not indexed) | DOUBLE |
| deltawin_j2000 | Declination (J2000.0) of the object using a Gaussian window with a FWHM corresponding to the disk containing 50% of the flux | 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. | INTEGER |
| dnf_nneighbors | DNF photo-z number of neighbors used for the DNF_Z estimate | REAL |
| 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) | DOUBLE |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| erra_image | Uncertainty in major axis size, from isophotal model | DOUBLE |
| errb_image | Uncertainty in minor axis size, from isophotal model | DOUBLE |
| errtheta_image | Uncertainty in source position, from isophotal model | DOUBLE |
| 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) | SMALLINT |
| flags_footprint | Flag describing whether the object is contained in the fiducial footprint of the survey. See Sevilla-Noarbe et al. (2021) for description | SMALLINT |
| flags_foreground | Flag describing whether the object is contained in a region with a foreground astrophysical object. See Sevilla-Noarbe et al. (2021) for description. | SMALLINT |
| flags_gold | Flag describing object anomalies. See Sevilla-Noarbe et al. (2021) for description. | 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, in g band | DOUBLE |
| flux_radius_i | Half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions, in i band | DOUBLE |
| flux_radius_r | Half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions, in r band | DOUBLE |
| flux_radius_y | Half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions, in Y band | DOUBLE |
| flux_radius_z | Half-light radius for the object, from elliptical growth-curve, modeled in 2 dimensions, in z band | DOUBLE |
| fof_id | Friends-of-friends shredder group ID number | INTEGER |
| fof_size | Friends-of-friends shredder group size | SMALLINT |
| gap_flux_err_g | Uncertainty on Gaussian aperture flux | DOUBLE |
| gap_flux_err_i | Uncertainty on Gaussian aperture flux | DOUBLE |
| gap_flux_err_r | Uncertainty on Gaussian aperture flux | DOUBLE |
| gap_flux_err_y | Uncertainty on Gaussian aperture flux | DOUBLE |
| gap_flux_err_z | Uncertainty on Gaussian aperture flux | DOUBLE |
| gap_flux_g | Gaussian Aperture fluxes with FWHM=4 arcsec | DOUBLE |
| gap_flux_i | Gaussian Aperture fluxes with FWHM=4 arcsec | DOUBLE |
| gap_flux_r | Gaussian Aperture fluxes with FWHM=4 arcsec | DOUBLE |
| gap_flux_y | Gaussian Aperture fluxes with FWHM=4 arcsec | DOUBLE |
| gap_flux_z | Gaussian Aperture fluxes with FWHM=4 arcsec | DOUBLE |
| gap_mag_err_g | Uncertainty on Gaussian aperture magnitude | DOUBLE |
| gap_mag_err_i | Uncertainty on Gaussian aperture magnitude | DOUBLE |
| gap_mag_err_r | Uncertainty on Gaussian aperture magnitude | DOUBLE |
| gap_mag_err_y | Uncertainty on Gaussian aperture magnitude | DOUBLE |
| gap_mag_err_z | Uncertainty on Gaussian aperture magnitude | DOUBLE |
| gap_mag_g | Magnitude measured by Gaussian aperture fit | DOUBLE |
| gap_mag_i | Magnitude measured by Gaussian aperture fit | DOUBLE |
| gap_mag_r | Magnitude measured by Gaussian aperture fit | DOUBLE |
| gap_mag_y | Magnitude measured by Gaussian aperture fit | DOUBLE |
| gap_mag_z | Magnitude measured by Gaussian aperture fit | DOUBLE |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| 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 | SMALLINT |
| 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 | Ninth level (~10 arcmin resolution) Hierarchical Triangular Mesh index (Szalay et al. 2007) | INTEGER |
| imaflags_iso_g | Flag identifying sources with missing/flagged pixels, considering all single epoch images, in g band | SMALLINT |
| imaflags_iso_i | Flag identifying sources with missing/flagged pixels, considering all single epoch images, in i band | SMALLINT |
| imaflags_iso_r | Flag identifying sources with missing/flagged pixels, considering all single epoch images, in r band | SMALLINT |
| imaflags_iso_y | Flag identifying sources with missing/flagged pixels, considering all single epoch images, in Y band | SMALLINT |
| imaflags_iso_z | Flag identifying sources with missing/flagged pixels, considering all single epoch images, in z band | SMALLINT |
| kron_radius | Detection image luminosity weighted radius for the object, encompassing approximately 90% of the total flux | DOUBLE |
| mag_aper_4_g | Magnitude measured in circular aperture with 1.9488 arcsec diameter | DOUBLE |
| mag_aper_4_i | Magnitude measured in circular aperture with 1.9488 arcsec diameter | DOUBLE |
| mag_aper_4_r | Magnitude measured in circular aperture with 1.9488 arcsec diameter | DOUBLE |
| mag_aper_4_y | Magnitude measured in circular aperture with 1.9488 arcsec diameter | DOUBLE |
| mag_aper_4_z | Magnitude measured in circular aperture with 1.9488 arcsec diameter | DOUBLE |
| mag_aper_8_g | Magnitude measured in a circular aperture of 22.22 pixels (5.8437 arcsecs) diameter, g band | DOUBLE |
| mag_aper_8_i | Magnitude measured in a circular aperture of 22.22 pixels (5.8437 arcsecs) diameter, i band | DOUBLE |
| mag_aper_8_r | Magnitude measured in a circular aperture of 22.22 pixels (5.8437 arcsecs) diameter, r band | DOUBLE |
| mag_aper_8_y | Magnitude measured in a circular aperture of 22.22 pixels (5.8437 arcsecs) diameter, Y band | DOUBLE |
| mag_aper_8_z | Magnitude measured in a circular aperture of 22.22 pixels (5.8437 arcsecs) diameter, z band | DOUBLE |
| mag_auto_g | Magnitude measurement in an elliptical aperture, shaped by the second moments of the object and scaled by the Kron radius, g band | DOUBLE |
| mag_auto_i | Magnitude measurement in an elliptical aperture, shaped by the second moments of the object and scaled by the Kron radius, i band | DOUBLE |
| mag_auto_r | Magnitude measurement in an elliptical aperture, shaped by the second moments of the object and scaled by the Kron radius, r band | DOUBLE |
| mag_auto_y | Magnitude measurement in an elliptical aperture, shaped by the second moments of the object and scaled by the Kron radius, Y band | DOUBLE |
| mag_auto_z | Magnitude measurement in an elliptical aperture, shaped by the second moments of the object and scaled by the Kron radius, z band | DOUBLE |
| mag_detmodel_g | Magnitude measurement, for a bulge + disk model fit on the detection image, g band | DOUBLE |
| mag_detmodel_i | Magnitude measurement, for a bulge + disk model fit on the detection image, i band | DOUBLE |
| mag_detmodel_r | Magnitude measurement, for a bulge + disk model fit on the detection image, r band | DOUBLE |
| mag_detmodel_y | Magnitude measurement, for a bulge + disk model fit on the detection image, Y band | DOUBLE |
| mag_detmodel_z | Magnitude measurement, for a bulge + disk model fit on the detection image, z band | DOUBLE |
| magerr_aper_4_g | Uncertainty in MAG_APER_4_G | DOUBLE |
| magerr_aper_4_i | Uncertainty in MAG_APER_4_I | DOUBLE |
| magerr_aper_4_r | Uncertainty in MAG_APER_4_R | DOUBLE |
| magerr_aper_4_y | Uncertainty in MAG_APER_4_Y | DOUBLE |
| magerr_aper_4_z | Uncertainty in MAG_APER_4_Z | DOUBLE |
| magerr_aper_8_g | Error in MAG_APER_8_G, scaled from FLUXERR_APER_8 | DOUBLE |
| magerr_aper_8_i | Error in MAG_APER_8_I, scaled from FLUXERR_APER_8 | DOUBLE |
| magerr_aper_8_r | Error in MAG_APER_8_R, scaled from FLUXERR_APER_8 | DOUBLE |
| magerr_aper_8_y | Error in MAG_APER_8_Y, scaled from FLUXERR_APER_8 | DOUBLE |
| magerr_aper_8_z | Error in MAG_APER_8_Z, scaled from FLUXERR_APER_8 | DOUBLE |
| magerr_auto_g | Error in MAG_AUTO_G, scaled from FLUXERR_AUTO | DOUBLE |
| magerr_auto_i | Error in MAG_AUTO_I, scaled from FLUXERR_AUTO | DOUBLE |
| magerr_auto_r | Error in MAG_AUTO_R, scaled from FLUXERR_AUTO | DOUBLE |
| magerr_auto_y | Error in MAG_AUTO_Y, scaled from FLUXERR_AUTO | DOUBLE |
| magerr_auto_z | Error in MAG_AUTO_Z, scaled from FLUXERR_AUTO | DOUBLE |
| magerr_detmodel_g | Error in MAG_DETMODEL_G, scaled from FLUXERR_DETMODEL | DOUBLE |
| magerr_detmodel_i | Error in MAG_DETMODEL_I, scaled from FLUXERR_DETMODEL | DOUBLE |
| magerr_detmodel_r | Error in MAG_DETMODEL_R, scaled from FLUXERR_DETMODEL | DOUBLE |
| magerr_detmodel_y | Error in MAG_DETMODEL_Y, scaled from FLUXERR_DETMODEL | DOUBLE |
| magerr_detmodel_z | Error in MAG_DETMODEL_Z, scaled from FLUXERR_DETMODEL | DOUBLE |
| mask_flags | Flag indicating the object was masked, e.g. due to bright star masking | SMALLINT |
| moly_number_g | Unique identifier of the MOLYGON that this object resides in. | DOUBLE |
| moly_number_i | Unique identifier of the MOLYGON that this object resides in. | DOUBLE |
| moly_number_r | Unique identifier of the MOLYGON that this object resides in. | DOUBLE |
| moly_number_y | Unique identifier of the MOLYGON that this object resides in. | DOUBLE |
| moly_number_z | Unique identifier of the MOLYGON that this object resides in. | DOUBLE |
| mu_eff_model_g | Effective model surface brightness above background. The surface brightness is measured at the isophote which includes half of the flux of the model, above background, in g band | DOUBLE |
| mu_eff_model_i | Effective model surface brightness above background. The surface brightness is measured at the isophote which includes half of the flux of the model, above background, in i band | DOUBLE |
| mu_eff_model_r | Effective model surface brightness above background. The surface brightness is measured at the isophote which includes half of the flux of the model, above background, in r band | DOUBLE |
| mu_eff_model_y | Effective model surface brightness above background. The surface brightness is measured at the isophote which includes half of the flux of the model, above background, in Y band | DOUBLE |
| mu_eff_model_z | Effective model surface brightness above background. The surface brightness is measured at the isophote which includes half of the flux of the model, above background, in z band | DOUBLE |
| mu_max_g | Surface brightness at the brightest pixel in g band | DOUBLE |
| mu_max_i | Surface brightness at the brightest pixel in i band | DOUBLE |
| mu_max_model_g | Maximum surface brightness in g band using the whole area inside the isophote used for MU_EFF_MODEL_G | DOUBLE |
| mu_max_model_i | Maximum surface brightness in i band using the whole area inside the isophote used for MU_EFF_MODEL_I | DOUBLE |
| mu_max_model_r | Maximum surface brightness in r band using the whole area inside the isophote used for MU_EFF_MODEL_R | DOUBLE |
| mu_max_model_y | Maximum surface brightness in Y band using the whole area inside the isophote used for MU_EFF_MODEL_Y | DOUBLE |
| mu_max_model_z | Maximum surface brightness in z band using the whole area inside the isophote used for MU_EFF_MODEL_Z | DOUBLE |
| mu_max_r | Surface brightness at the brightest pixel in r band | DOUBLE |
| mu_max_y | Surface brightness at the brightest pixel in Y band | DOUBLE |
| mu_max_z | Surface brightness at the brightest pixel in z band | DOUBLE |
| mu_mean_model_g | Mean surface brightness in g band using the whole area inside the isophote used for MU_EFF_MODEL_G | DOUBLE |
| mu_mean_model_i | Mean surface brightness in i band using the whole area inside the isophote used for MU_EFF_MODEL_I | DOUBLE |
| mu_mean_model_r | Mean surface brightness in r band using the whole area inside the isophote used for MU_EFF_MODEL_R | DOUBLE |
| mu_mean_model_y | Mean surface brightness in Y band using the whole area inside the isophote used for MU_EFF_MODEL_Y | DOUBLE |
| mu_mean_model_z | Mean surface brightness in z band using the whole area inside the isophote used for MU_EFF_MODEL_Z | DOUBLE |
| mu_threshold_g | Surface brightness threshold (SExtractor parameter) in g band | DOUBLE |
| mu_threshold_i | Surface brightness threshold (SExtractor parameter) in i band | DOUBLE |
| mu_threshold_r | Surface brightness threshold (SExtractor parameter) in r band | DOUBLE |
| mu_threshold_y | Surface brightness threshold (SExtractor parameter) in Y band | DOUBLE |
| mu_threshold_z | Surface brightness threshold (SExtractor parameter) in z band | DOUBLE |
| n_images_g | Number of g band exposures at the object location (from the Healpix map) | DOUBLE |
| n_images_i | Number of i band exposures at the object location (from the Healpix map) | DOUBLE |
| n_images_r | Number of r band exposures at the object location (from the Healpix map) | DOUBLE |
| n_images_y | Number of Y band exposures at the object location (from the Healpix map) | DOUBLE |
| n_images_z | Number of z band exposures at the object location (from the Healpix map) | DOUBLE |
| nepochs_g | Number of epochs the source is detected in single epoch images | SMALLINT |
| nepochs_i | Number of epochs the source is detected in single epoch images | SMALLINT |
| nepochs_r | Number of epochs the source is detected in single epoch images | SMALLINT |
| nepochs_y | Number of epochs the source is detected in single epoch images | SMALLINT |
| nepochs_z | Number of epochs the source is detected in single epoch images | SMALLINT |
| niter_model_g | Number of iterations for convergence in SExtractor model fitting | SMALLINT |
| niter_model_i | Number of iterations for convergence in SExtractor model fitting | SMALLINT |
| niter_model_r | Number of iterations for convergence in SExtractor model fitting | SMALLINT |
| niter_model_y | Number of iterations for convergence in SExtractor model fitting | SMALLINT |
| niter_model_z | Number of iterations for convergence in SExtractor model fitting | SMALLINT |
| object_number | SExtractor unique number for a processing tile | INTEGER |
| parent_number | SExtractor OBJECT_NUMBER of parent object of which this object is a deblended child | INTEGER |
| pfw_attempt_id | DESDM internal processing index number | INTEGER |
| psf_flux_aper_8_g | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) | DOUBLE |
| psf_flux_aper_8_i | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) | DOUBLE |
| psf_flux_aper_8_r | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) | DOUBLE |
| psf_flux_aper_8_y | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) | DOUBLE |
| psf_flux_aper_8_z | Flux measured by FITVD PSF model in APER8 system (reddened, top of atmosphere) | DOUBLE |
| psf_flux_err_aper_8_g | Uncertainty on PSF_FLUX_APER_8_G | DOUBLE |
| psf_flux_err_aper_8_i | Uncertainty on PSF_FLUX_APER_8_I | DOUBLE |
| psf_flux_err_aper_8_r | Uncertainty on PSF_FLUX_APER_8_R | DOUBLE |
| psf_flux_err_aper_8_y | Uncertainty on PSF_FLUX_APER_8_Y | DOUBLE |
| psf_flux_err_aper_8_z | Uncertainty on PSF_FLUX_APER_8_Z | 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 | SMALLINT |
| 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 | SMALLINT |
| 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 | SMALLINT |
| psf_flux_flags_y | Flags for FITVD PSF flux measurement: 0=success, 1=bad variance, 512=divide by zero, 1024=degrees of freedom are zero | SMALLINT |
| 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 | SMALLINT |
| 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_y | 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_y | 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) | 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. | DOUBLE |
| psf_mag_aper_8_i | Magnitude measured by FITVD PSF model in APER8 system (reddened top of atmosphere) | 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. | DOUBLE |
| psf_mag_aper_8_r | Magnitude measured by FITVD PSF model in APER8 system (reddened top of atmosphere) | 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. | DOUBLE |
| psf_mag_aper_8_y | Magnitude measured by FITVD PSF model in APER8 system (reddened top of atmosphere) | DOUBLE |
| psf_mag_aper_8_y_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. | DOUBLE |
| psf_mag_aper_8_z | Magnitude measured by FITVD PSF model in APER8 system (reddened top of atmosphere) | 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. | DOUBLE |
| psf_mag_err_aper_8_g | Uncertainty in PSF_MAG_APER_8_G | DOUBLE |
| psf_mag_err_aper_8_i | Uncertainty in PSF_MAG_APER_8_I | DOUBLE |
| psf_mag_err_aper_8_r | Uncertainty in PSF_MAG_APER_8_R | DOUBLE |
| psf_mag_err_aper_8_y | Uncertainty in PSF_MAG_APER_8_Y | DOUBLE |
| psf_mag_err_aper_8_z | Uncertainty in PSF_MAG_APER_8_Z | DOUBLE |
| psf_t | Squared-size for a multi-Gaussian model fit to the PSF at the location of the object | DOUBLE |
| ra | Right Ascension (J2000.0) with quantized precision for indexing (ALPHAWIN_J2000 has full precision but not indexed) | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| ring256 | Ring-scheme HEALPix (Gorski et al. 2005) index with NSIDE=256 (~14 arcmin resolution) | INTEGER |
| s_extractor_flags_g | SExtractor 16-bit flag parameter which contains basic warnings about the source extraction process | SMALLINT |
| s_extractor_flags_i | SExtractor 16-bit flag parameter which contains basic warnings about the source extraction process | SMALLINT |
| s_extractor_flags_r | SExtractor 16-bit flag parameter which contains basic warnings about the source extraction process | SMALLINT |
| s_extractor_flags_y | SExtractor 16-bit flag parameter which contains basic warnings about the source extraction process | SMALLINT |
| s_extractor_flags_z | SExtractor 16-bit flag parameter which contains basic warnings about the source extraction process | SMALLINT |
| spread_model_g | Morphology based classifier based on a linear discriminant between the pixel map of the object convolved with the PSF model and the pixel map convolved with a PSF+exponential model. Values closer to 0 correspond to stars, larger values correspond to galaxies | DOUBLE |
| spread_model_i | Morphology based classifier based on a linear discriminant between the pixel map of the object convolved with the PSF model and the pixel map convolved with a PSF+exponential model. Values closer to 0 correspond to stars, larger values correspond to galaxies | DOUBLE |
| spread_model_r | Morphology based classifier based on a linear discriminant between the pixel map of the object convolved with the PSF model and the pixel map convolved with a PSF+exponential model. Values closer to 0 correspond to stars, larger values correspond to galaxies | DOUBLE |
| spread_model_y | Morphology based classifier based on a linear discriminant between the pixel map of the object convolved with the PSF model and the pixel map convolved with a PSF+exponential model. Values closer to 0 correspond to stars, larger values correspond to galaxies | DOUBLE |
| spread_model_z | Morphology based classifier based on a linear discriminant between the pixel map of the object convolved with the PSF model and the pixel map convolved with a PSF+exponential model. Values closer to 0 correspond to stars, larger values correspond to galaxies | DOUBLE |
| spreaderr_model_g | Uncertainty in SPREAD_MODEL_G | DOUBLE |
| spreaderr_model_i | Uncertainty in SPREAD_MODEL_I | DOUBLE |
| spreaderr_model_r | Uncertainty in SPREAD_MODEL_R | DOUBLE |
| spreaderr_model_y | Uncertainty in SPREAD_MODEL_Y | DOUBLE |
| spreaderr_model_z | Uncertainty in SPREAD_MODEL_Z | DOUBLE |
| theta_j2000 | Position angle of the ellipse fit to the object with the N/S/E/W axes in equatorial J2000 coordinates, from non-windowed measurement. THETA_J2000 = THETA_IMAGE-90(MOD 180) | DOUBLE |
| tilename | Identifier of each one of the tiles on which the survey is gridded for data processing | VARCHAR |
| wavg_mag_psf_g | Magnitude measured by weighted-average of PSF fit to single-epoch detections | DOUBLE |
| wavg_mag_psf_i | Magnitude measured by weighted-average of PSF fit to single-epoch detections | DOUBLE |
| wavg_mag_psf_r | Magnitude measured by weighted-average of PSF fit to single-epoch detections | DOUBLE |
| wavg_mag_psf_y | Magnitude measured by weighted-average of PSF fit to single-epoch detections | DOUBLE |
| wavg_mag_psf_z | Magnitude measured by weighted-average of PSF fit to single-epoch detections | DOUBLE |
| wavg_magerr_psf_g | Uncertainty in WAVG_MAG_PSF_G | DOUBLE |
| wavg_magerr_psf_i | Uncertainty in WAVG_MAG_PSF_I | DOUBLE |
| wavg_magerr_psf_r | Uncertainty in WAVG_MAG_PSF_R | DOUBLE |
| wavg_magerr_psf_y | Uncertainty in WAVG_MAG_PSF_Y | DOUBLE |
| wavg_magerr_psf_z | Uncertainty in WAVG_MAG_PSF_Z | DOUBLE |
| wavg_spread_model_g | SPREAD MODEL using the weighted averaged values from single epoch detections | DOUBLE |
| wavg_spread_model_i | SPREAD MODEL using the weighted averaged values from single epoch detections | DOUBLE |
| wavg_spread_model_r | SPREAD MODEL using the weighted averaged values from single epoch detections | DOUBLE |
| wavg_spread_model_y | SPREAD MODEL using the weighted averaged values from single epoch detections | DOUBLE |
| wavg_spread_model_z | SPREAD MODEL using the weighted averaged values from single epoch detections | DOUBLE |
| wavg_spreaderr_model_g | Uncertainty in WAVG_SPREAD_MODEL_G | DOUBLE |
| wavg_spreaderr_model_i | Uncertainty in WAVG_SPREAD_MODEL_I | DOUBLE |
| wavg_spreaderr_model_r | Uncertainty in WAVG_SPREAD_MODEL_R | DOUBLE |
| wavg_spreaderr_model_y | Uncertainty in WAVG_SPREAD_MODEL_Y | DOUBLE |
| wavg_spreaderr_model_z | Uncertainty in WAVG_SPREAD_MODEL_Z | DOUBLE |
| 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). | DOUBLE |
| xwin_image | X position of the barycenter of the object within the image using a Gaussian window with a FWHM corresponding to the radius of the aperture containing 50% of the flux | DOUBLE |
| ywin_image | Y position of the barycenter of the object within the image using a Gaussian window with a FWHM corresponding to the radius of the aperture containing 50% of the flux | DOUBLE |
