Choose a database in the left panel then select the table you want!
Table: desi_dr1.mws
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| alphafe | [alpha/Fe] from template fitting | DOUBLE |
| alphafe_err | [alpha/Fe] uncertainty from template fitting | DOUBLE |
| bestgrid | Model grid that produced the best fit | CHAR |
| chisq_b | Chi-square in the B arm | DOUBLE |
| chisq_c_b | Chi-square in the B arm after fitting continuum only | DOUBLE |
| chisq_c_r | Chi-square in the R arm after fitting continuum only | DOUBLE |
| chisq_c_tot | Total chi-square for all arms for polynomial only fit | DOUBLE |
| chisq_c_z | Chi-square in the Z arm after fitting continuum only | DOUBLE |
| chisq_r | Chi-square in the R arm | DOUBLE |
| chisq_tot | Total chi-square for all arms | DOUBLE |
| chisq_z | Chi-square in the Z arm | DOUBLE |
| covar | Covariance matrix for ([Fe/H], [a/Fe], log10micro, Teff,logg) | DOUBLE |
| elat | Ecliptic latitude | DOUBLE |
| elem | Elemental abundance ratios to hydrogen [elem/H] | DOUBLE |
| elem_err | Uncertainties in the elemental abundance ratios | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| feh | [Fe/H] from template fitting | DOUBLE |
| feh_err | [Fe/H] uncertainty from template fitting | DOUBLE |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| healpix | HEALPixel containing this location at NSIDE=64 in the NESTED scheme | BIGINT |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| integ_coadd_flux_b | Integ. flux in wavelength range 4000, 5800A | REAL |
| integ_coadd_flux_r | Integ. flux in wavelength range 5800, 7600A | REAL |
| integ_coadd_flux_z | Integ. flux in wavelength range 7600, 9800A | REAL |
| log10micro | Log10 of Microturbulence (km/s) | DOUBLE |
| logg | Log of surface gravity | DOUBLE |
| logg_err | Logg of surface gravity uncertainty | DOUBLE |
| median_coadd_flux_b | Median flux in wavelength range 4000, 5800A | REAL |
| median_coadd_flux_r | Median flux in wavelength range 5800, 7600A | REAL |
| median_coadd_flux_z | Median flux in wavelength range 7600, 9800A | REAL |
| median_coadd_snr_b | Median SNR/sqrt(A) in wavelength range 4000, 5800A | REAL |
| median_coadd_snr_r | Median SNR/sqrt(A) in wavelength range 5800, 7600A | REAL |
| median_coadd_snr_z | Median SNR/sqrt(A) in wavelength range 7600, 9800A | REAL |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size) | INTEGER |
| param | Array of atmospheric parameters ([Fe/H], [a/Fe], log10micro, Teff,logg) | DOUBLE |
| program | DESI program type - backup, bright, dark, other | VARCHAR |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| ref_cat | Reference catalog source for star: T2 for Tycho-2, G2 for Gaia DR2, L2 for the SGA, empty otherwise | CHAR |
| ref_id | Tyc1*1,000,000+Tyc2*10+Tyc3 for Tycho-2; sourceid for Gaia DR2 | BIGINT |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| rr_spectype | Spectype from Redrock file | VARCHAR |
| rr_z | Redrock redshift | DOUBLE |
| rv_adop | Adopted radial velocity (km/s) | DOUBLE |
| rv_err | Uncertainty in the adopted radial velocity (km/s) | DOUBLE |
| rvs_warn | RVSpecFit warning flag | BIGINT |
| sn_b | Median S/N in the B arm | REAL |
| sn_r | Median S/N in the R arm | REAL |
| snr_med | Median signal-to-noise ratio | DOUBLE |
| sn_z | Median S/N in the Z arm | REAL |
| source_id | Gaia DR3 unique source identifier (unique within a particular Data Release) | BIGINT |
| srcfile | DESI data file | VARCHAR |
| success | Bit indicating whether the code has likely produced useful results (0=False, 1=True) | SMALLINT |
| survey | Survey name - cmx, main, special, sv1, sv2, sv3 | VARCHAR |
| target_dec | Target declination (deg) | DOUBLE |
| targetid | Unique identifier for each object observed by DESI | BIGINT |
| target_ra | Target right ascension (deg) | DOUBLE |
| teff | Effective temperature | DOUBLE |
| teff_err | Effective temperature uncertainty | DOUBLE |
| vrad | Radial velocity | DOUBLE |
| vrad_err | Radial velocity error | DOUBLE |
| vrad_kurt | Radial velocity posterior kurtosis | DOUBLE |
| vrad_skew | Radial velocity posterior skewness | DOUBLE |
| vsini | Stellar rotation velocity | DOUBLE |
| zcat_primary | Boolean flag (True/False) for the primary coadded spectrum in the zcatalog | CHAR |
