Choose a database in the left panel then select the table you want!
Table: desi_edr.ztile
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| chi2 | Best fit chi squared | DOUBLE |
| 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 |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| firstnight | KPNO Calendar Date for the first NIGHT of the observation of the TILEID | INTEGER |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| htm9 | Ninth level (~10 arcmin resolution) Hierarchical Triangular Mesh index (Szalay et al. 2007) | INTEGER |
| id | Arbitrary primary key composed from targetid, survey, program. NOTE: this column is stored as a NUMERIC(39,0) datatype. | DOUBLE |
| lastnight | KPNO Calendar Date for the last NIGHT of the observation of the TILEID | INTEGER |
| main_nspec | Number of coadded spectra for this TARGETID in Main survey | SMALLINT |
| main_primary | Boolean flag (True/False) for the primary coadded spectrum in Main survey | BOOLEAN |
| max_mjd | Maximum value of the Modified Julian Date (when the shutter was open for the last exposure, i.e. not including the exposure time) | 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 | REAL |
| mean_fiber_ra | Mean (over exposures) RA of actual fiber position | REAL |
| mean_fiber_x | Mean (over exposures) fiber CS5 X location on focal plane | REAL |
| mean_fiber_y | Mean (over exposures) fiber CS5 Y location on focal plane | REAL |
| mean_mjd | Mean (over exposures) of the Modified Julian Date (MJD) when the shutter was opened | 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) | DOUBLE |
| 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 |
| spectype | Spectype from Redrock file | VARCHAR |
| spgrp | Type of spectral grouping. For ztile table this can be = cumulative, perexp, or pernight | VARCHAR |
| spgrpval | Value corresponding to the grouping type indicated in the spgrp column. For ztile table this is a night or exposure id | 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 |
| sv_nspec | Number of coadded spectra for this TARGETID in SV (SV1+2+3) | SMALLINT |
| sv_primary | Boolean flag (True/False) for the primary coadded spectrum in SV (SV1+2+3) | BOOLEAN |
| targetid | Unique DESI target ID | BIGINT |
| targetphotid | Foreign key on the target table. NOTE: this column is stored as a NUMERIC(39,0) datatype. | DOUBLE |
| tileid | Unique DESI tile ID | INTEGER |
| 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 | Boolean flag (True/False) for the primary coadded spectrum in this zcatalog | BOOLEAN |
| zerr | Redshift error from Redrock | DOUBLE |
| zwarn | Redshift warning bitmask measured by Redrock | BIGINT |
