Choose a database in the left panel then select the table you want!
Table: desi_dr1.zpix
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| bgs_target | BGS (bright time program) target selection bitmask | BIGINT |
| chi2 | Best fit chi squared | DOUBLE |
| cmx_target | Target selection bitmask for commissioning | BIGINT |
| coadd_exptime | Sum of the exposure times contributing to the coadd for this target | REAL |
| coadd_fiberstatus | Bitwise AND of the FIBERSTATUS values of the spectra used in the coadd | INTEGER |
| coadd_numexp | Number of exposures included in the coadd for this target | SMALLINT |
| coadd_numnight | Number of different nights included in the coadd for this target | SMALLINT |
| coadd_numtile | Number of different tiles included in the coadd for this target | SMALLINT |
| coeff_0 | Redrock template coefficients | DOUBLE |
| coeff_1 | Redrock template coefficients | DOUBLE |
| coeff_2 | Redrock template coefficients | DOUBLE |
| coeff_3 | Redrock template coefficients | DOUBLE |
| coeff_4 | Redrock template coefficients | DOUBLE |
| coeff_5 | Redrock template coefficients | DOUBLE |
| coeff_6 | Redrock template coefficients | DOUBLE |
| coeff_7 | Redrock template coefficients | DOUBLE |
| coeff_8 | Redrock template coefficients | DOUBLE |
| coeff_9 | Redrock template coefficients | DOUBLE |
| deltachi2 | Delta-chi-squared for template fit from Redrock | DOUBLE |
| desiname | Human-readable identifier of a sky location DESI JXXX.XXXX[+/-]YY.YYYY, where X,Y=truncated decimal target_ra, target_dec, precise to 0.36 arcsec | VARCHAR |
| desi_target | Dark survey + calibration targeting bits | BIGINT |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| healpix | HEALPixel containing this location at NSIDE=64 in the NESTED scheme | INTEGER |
| htm9 | Ninth level (~10 arcmin resolution) Hierarchical Triangular Mesh index (Szalay et al. 2007) | INTEGER |
| id | Arbitrary primary key composed from targetid, survey, program | VARCHAR |
| main_nspec | Number of coadded spectra for this TARGETID in Main survey | SMALLINT |
| main_primary | True/False flag for the primary coadded spectrum in Main survey | CHAR |
| max_mjd | Maximum value of the Modified Julian Date (when the shutter was open for the last exposure used in the coadded spectrum) | DOUBLE |
| mean_delta_x | Mean (over exposures) fiber difference between measured and requested CS5 X location on focal plane | REAL |
| mean_delta_y | Mean (over exposures) fiber difference between measured and requested CS5 Y location on focal plane | REAL |
| mean_fiber_dec | Mean (over exposures) DEC of actual fiber position | DOUBLE |
| mean_fiber_ra | Mean (over exposures) RA of actual fiber position | DOUBLE |
| mean_mjd | Mean value of the Modified Julian Date (when the shutter was open for exposures used in the coadded spectrum) | DOUBLE |
| mean_psf_to_fiber_specflux | Mean of the PSF_TO_FIBER_SPECFLUX values of the spectra used in the coadd | REAL |
| min_mjd | Minimum value of the Modified Julian Date (when the shutter was open for the first exposure used in the coadded spectrum) | DOUBLE |
| mws_target | Milky Way Survey targeting bits | BIGINT |
| ncoeff | Number of Redrock template coefficients | BIGINT |
| nest4096 | Nested-scheme HEALPix (Gorski et al. 2005) index with Nsides=4096 (~52 arcsec size) | INTEGER |
| npixels | Number of unmasked wavelengths that contributed to the redshift fit | BIGINT |
| program | DESI program type - BRIGHT, DARK, or BACKUP | VARCHAR |
| random_id | Random ID in the range 0.0 => 100.0 (not unique) | REAL |
| ring256 | Ring-scheme HEALPix (Gorski et al. 2005) index with Nsides=256 (~14 arcmin size) | INTEGER |
| rms_delta_x | RMS (over exposures) of the fiber difference between measured and requested CS5 X location on focal plane | REAL |
| rms_delta_y | RMS (over exposures) of the fiber difference between measured and requested CS5 Y location on focal plane | REAL |
| scnd_target | Target selection bitmask for secondary programs | BIGINT |
| spectype | Spectype from Redrock file | VARCHAR |
| spgrp | Type of spectral grouping. For zpix table this is always = healpix | VARCHAR |
| spgrpval | Value corresponding to the grouping type indicated in the spgrp column. For zpix table this is the same as the healpix column | INTEGER |
| std_fiber_dec | Standard deviation (over exposures) of DEC of actual fiber position | REAL |
| std_fiber_ra | Standard deviation (over exposures) of RA of actual fiber position | REAL |
| subtype | Spectral subtype | VARCHAR |
| survey | Survey name | VARCHAR |
| sv1_bgs_target | BGS (bright time program) target selection bitmask for SV1 | BIGINT |
| sv1_desi_target | DESI (dark time program) target selection bitmask for SV1 | BIGINT |
| sv1_mws_target | MWS (bright time program) target selection bitmask for SV1 | BIGINT |
| sv1_scnd_target | Secondary target selection bitmask for SV1 | BIGINT |
| sv2_bgs_target | BGS (bright time program) target selection bitmask for SV2 | BIGINT |
| sv2_desi_target | DESI (dark time program) target selection bitmask for SV2 | BIGINT |
| sv2_mws_target | MWS (bright time program) target selection bitmask for SV2 | BIGINT |
| sv2_scnd_target | Secondary target selection bitmask for SV2 | BIGINT |
| sv3_bgs_target | BGS (bright time program) target selection bitmask for SV3 | BIGINT |
| sv3_desi_target | DESI (dark time program) target selection bitmask for SV3 | BIGINT |
| sv3_mws_target | MWS (bright time program) target selection bitmask for SV3 | BIGINT |
| sv3_scnd_target | Secondary target selection bitmask for SV3 | BIGINT |
| sv_nspec | Number of coadded spectra for this TARGETID in SV (SV1+2+3) | SMALLINT |
| sv_primary | True/False flag for the primary coadded spectrum in SV (SV1+2+3) | CHAR |
| targetid | Unique DESI target ID | BIGINT |
| tsnr2_bgs | BGS template (S/N)^2 summed over B, R, Z | REAL |
| tsnr2_bgs_b | BGS B template (S/N)^2 | REAL |
| tsnr2_bgs_r | BGS R template (S/N)^2 | REAL |
| tsnr2_bgs_z | BGS Z template (S/N)^2 | REAL |
| tsnr2_elg | ELG template (S/N)^2 summed over B, R, Z | REAL |
| tsnr2_elg_b | ELG B template (S/N)^2 | REAL |
| tsnr2_elg_r | ELG R template (S/N)^2 | REAL |
| tsnr2_elg_z | ELG Z template (S/N)^2 | REAL |
| tsnr2_gpbbackup | GPBBACKUP template (S/N)^2 summed over B, R, Z | REAL |
| tsnr2_gpbbackup_b | GPBBACKUP B template (S/N)^2 | REAL |
| tsnr2_gpbbackup_r | GPBBACKUP R template (S/N)^2 | REAL |
| tsnr2_gpbbackup_z | GPBBACKUP Z template (S/N)^2 | REAL |
| tsnr2_gpbbright | GPBBRIGHT template (S/N)^2 summed over B, R, Z | REAL |
| tsnr2_gpbbright_b | GPBBRIGHT B template (S/N)^2 | REAL |
| tsnr2_gpbbright_r | GPBBRIGHT R template (S/N)^2 | REAL |
| tsnr2_gpbbright_z | GPBBRIGHT Z template (S/N)^2 | REAL |
| tsnr2_gpbdark | GPBDARK template (S/N)^2 summed over B, R, Z | REAL |
| tsnr2_gpbdark_b | GPBDARK B template (S/N)^2 | REAL |
| tsnr2_gpbdark_r | GPBDARK R template (S/N)^2 | REAL |
| tsnr2_gpbdark_z | GPBDARK Z template (S/N)^2 | REAL |
| tsnr2_lrg | LRG template (S/N)^2 summed over B, R, Z | REAL |
| tsnr2_lrg_b | LRG B template (S/N)^2 | REAL |
| tsnr2_lrg_r | LRG R template (S/N)^2 | REAL |
| tsnr2_lrg_z | LRG Z template (S/N)^2 | REAL |
| tsnr2_lya | LYA template (S/N)^2 summed over B, R, Z | REAL |
| tsnr2_lya_b | LYA B template (S/N)^2 | REAL |
| tsnr2_lya_r | LYA R template (S/N)^2 | REAL |
| tsnr2_lya_z | LYA Z template (S/N)^2 | REAL |
| tsnr2_qso | QSO template (S/N)^2 summed over B, R, Z | REAL |
| tsnr2_qso_b | QSO B template (S/N)^2 | REAL |
| tsnr2_qso_r | QSO R template (S/N)^2 | REAL |
| tsnr2_qso_z | QSO Z template (S/N)^2 | REAL |
| z | Redshift measured by Redrock | DOUBLE |
| zcat_nspec | Number of coadded spectra for this TARGETID in this zcatalog | SMALLINT |
| zcat_primary | True/False flag for the primary coadded spectrum in this zcatalog | CHAR |
| zerr | Redshift error from Redrock | DOUBLE |
| zwarn | Redshift warning bitmask measured by Redrock | BIGINT |
