Choose a database in the left panel then select the table you want!
Table: desi_dr1.photometry
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| allmask_g | Bitwise mask set if the central pixel from all images satisfy each condition in g as cataloged on the LS DR9 bitmasks page | SMALLINT |
| allmask_r | Bitwise mask set if the central pixel from all images satisfy each condition in r as cataloged on the LS DR9 bitmasks page | SMALLINT |
| allmask_z | Bitwise mask set if the central pixel from all images satisfy each condition in z as cataloged on the LS DR9 bitmasks page | SMALLINT |
| brickid | Brick ID from Tractor input | INTEGER |
| brickname | Brick name from Tractor input | VARCHAR |
| brick_objid | Imaging Surveys OBJID on that brick | INTEGER |
| dchisq_dev | Difference in chi-squared between DEV (deVauc) Tractor model fits | REAL |
| dchisq_exp | Difference in chi-squared between EXP (exponential) Tractor model fits | REAL |
| dchisq_psf | Difference in chi-squared between PSF (stellar) Tractor model fits | REAL |
| dchisq_rex | Difference in chi-squared between REX (round exponential galaxy) Tractor model fits | REAL |
| dchisq_ser | Difference in chi-squared between SER (Sersic) Tractor model fits | REAL |
| dec | Declination | DOUBLE |
| dec_ivar | Declination inverse variance | REAL |
| ebv | Galactic extinction E(B-V) reddening from SFD98 | REAL |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| fiberflux_g | Predicted g-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeing | REAL |
| fiberflux_r | Predicted r-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeing | REAL |
| fiberflux_z | Predicted z-band flux within a fiber of diameter 1.5 arcsec from this object in 1 arcsec Gaussian seeing | REAL |
| fibertotflux_g | Predicted g-band flux within a fiber of diameter 1.5 arcsec from all sources at this location in 1 arcsec Gaussian seeing | REAL |
| fibertotflux_r | Predicted r-band flux within a fiber of diameter 1.5 arcsec from all sources at this location in 1 arcsec Gaussian seeing | REAL |
| fibertotflux_z | Predicted z-band flux within a fiber of diameter 1.5 arcsec from all sources at this location in 1 arcsec Gaussian seeing | REAL |
| flux_g | Flux in the Legacy Survey g-band (AB) | REAL |
| flux_ivar_g | Inverse variance of FLUX_G (AB) | REAL |
| flux_ivar_r | Inverse variance of FLUX_R (AB) | REAL |
| flux_ivar_w1 | Inverse variance of FLUX_W1 (AB) | REAL |
| flux_ivar_w2 | Inverse variance of FLUX_W2 (AB) | REAL |
| flux_ivar_w3 | Inverse variance of FLUX_W3 (AB) | REAL |
| flux_ivar_w4 | Inverse variance of FLUX_W4 (AB) | REAL |
| flux_ivar_z | Inverse variance of FLUX_Z (AB) | REAL |
| flux_r | Flux in the Legacy Survey r-band (AB) | REAL |
| flux_w1 | WISE flux in W1 (AB) | REAL |
| flux_w2 | WISE flux in W2 (AB) | REAL |
| flux_w3 | WISE flux in W3 (AB) | REAL |
| flux_w4 | WISE flux in W4 (AB) | REAL |
| flux_z | Flux in the Legacy Survey z-band (AB) | REAL |
| fracflux_g | Profile-weighted fraction of the flux from other sources divided by the total flux in g (typically [0,1]) | REAL |
| fracflux_r | Profile-weighted fraction of the flux from other sources divided by the total flux in r (typically [0,1]) | REAL |
| fracflux_z | Profile-weighted fraction of the flux from other sources divided by the total flux in z (typically [0,1]) | REAL |
| fracin_g | Fraction of a sources flux within the blob in g, near unity for real sources | REAL |
| fracin_r | Fraction of a sources flux within the blob in r, near unity for real sources | REAL |
| fracin_z | Fraction of a sources flux within the blob in z, near unity for real sources | REAL |
| fracmasked_g | Profile-weighted fraction of pixels masked from all observations of this object in g, strictly between [0,1] | REAL |
| fracmasked_r | Profile-weighted fraction of pixels masked from all observations of this object in r, strictly between [0,1] | REAL |
| fracmasked_z | Profile-weighted fraction of pixels masked from all observations of this object in z, strictly between [0,1] | REAL |
| gaia_astrometric_params_solved | Which astrometric parameters were estimated for a Gaia source | SMALLINT |
| gaia_astrometric_sigma5d_max | Gaia longest semi-major axis of the 5-d error ellipsoid | REAL |
| gaia_duplicated_source | Gaia duplicated source flag | SMALLINT |
| gaia_phot_bp_mean_flux_over_error | Gaia BP band signal-to-noise | REAL |
| gaia_phot_bp_mean_mag | Gaia BP band magnitude | REAL |
| gaia_phot_bp_rp_excess_factor | Gaia BP/RP excess factor | REAL |
| gaia_phot_g_mean_flux_over_error | Gaia G band signal-to-noise | REAL |
| gaia_phot_g_mean_mag | Gaia G band magnitude | REAL |
| gaia_phot_rp_mean_flux_over_error | Gaia RP band signal-to-noise | REAL |
| gaia_phot_rp_mean_mag | Gaia RP band magnitude | REAL |
| galdepth_g | Galaxy model-based depth in Legacy Survey g-band | REAL |
| galdepth_r | Galaxy model-based depth in Legacy Survey r-band | REAL |
| galdepth_z | Galaxy model-based depth in Legacy Survey z-band | REAL |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| htm9 | Ninth level (~10 arcmin resolution) Hierarchical Triangular Mesh index (Szalay et al. 2007) | INTEGER |
| ls_id | Unique Legacy Survey object ID | BIGINT |
| maskbits | Bitwise mask from the imaging indicating potential issue or blending | SMALLINT |
| morphtype | Imaging Surveys morphological type from Tractor | VARCHAR |
| mw_transmission_g | Milky Way dust transmission in LS g-band | REAL |
| mw_transmission_r | Milky Way dust transmission in LS r-band | REAL |
| mw_transmission_w1 | Milky Way dust transmission in WISE W1 | REAL |
| mw_transmission_w2 | Milky Way dust transmission in WISE W2 | REAL |
| mw_transmission_w3 | Milky Way dust transmission in WISE W3 | REAL |
| mw_transmission_w4 | Milky Way dust transmission in WISE W4 | REAL |
| mw_transmission_z | Milky Way dust transmission in LS z-band | REAL |
| nest4096 | Nested-scheme HEALPix (Gorski et al. 2005) index with Nsides=4096 (~52 arcsec size) | INTEGER |
| nobs_g | Number of images for central pixel in g-band | SMALLINT |
| nobs_r | Number of images for central pixel in r-band | SMALLINT |
| nobs_z | Number of images for central pixel in z-band | SMALLINT |
| parallax | Reference catalog parallax | REAL |
| parallax_ivar | Inverse variance of PARALLAX | REAL |
| pmdec | Reference catalog proper motion in the Dec direction | REAL |
| pmdec_ivar | Inverse variance of PMDEC | REAL |
| pmra | Reference catalog proper motion in the RA direction | REAL |
| pmra_ivar | Inverse variance of PMRA | REAL |
| psfdepth_g | PSF-based depth in g-band | REAL |
| psfdepth_r | PSF-based depth in r-band | REAL |
| psfdepth_z | PSF-based depth in z-band | REAL |
| ra | Right ascension | DOUBLE |
| ra_ivar | Right ascension inverse variance | REAL |
| random_id | Random ID in the range 0.0 => 100.0 (not unique) | REAL |
| ref_cat | Reference catalog source for star: T2 for Tycho2, G2 for Gaia DR2, L2 for the SGA, empty otherwise | VARCHAR |
| ref_epoch | Reference epoch for Gaia/Tycho astrometry. Typically 2015.5 for Gaia | REAL |
| ref_id | Tyc1*1000000+Tyc2*10+Tyc3 for Tycho-2; sourceid for Gaia DR2 | BIGINT |
| release | Imaging Surveys release ID | SMALLINT |
| ring256 | Ring-scheme HEALPix (Gorski et al. 2005) index with Nsides=256 (~14 arcmin size) | INTEGER |
| sersic | Power-law index for the Sersic profile model (MORPHTYPE=SER) | REAL |
| sersic_ivar | Inverse variance of SERSIC | REAL |
| shape_e1 | Ellipticity component 1 of galaxy model for galaxy type MORPHTYPE | REAL |
| shape_e1_ivar | Inverse variance of SHAPE_E1 | REAL |
| shape_e2 | Ellipticity component 2 of galaxy model for galaxy type MORPHTYPE | REAL |
| shape_e2_ivar | Inverse variance of SHAPE_E2 | REAL |
| shape_r | Half-light radius of galaxy model (>0) | REAL |
| shape_r_ivar | Inverse variance of SHAPE_R | REAL |
| targetid | Unique DESI target ID | BIGINT |
| wisemask_w1 | W1 bitmask as cataloged on the DR9 bitmasks page here https://www.legacysurvey.org/dr9/bitmasks | SMALLINT |
| wisemask_w2 | W2 bitmask as cataloged on the DR9 bitmasks page here https://www.legacysurvey.org/dr9/bitmasks | SMALLINT |
