Choose a database in the left panel then select the table you want!
Table: desi_edr.tile
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| bgs_efftime_bright | Effective exposure time for nominal bright conditions inferred for BGS targets | DOUBLE |
| efftime_etc | Effective exposure time for nominal conditions inferred from ETC data | DOUBLE |
| efftime_gfa | Effective exposure time for nominal conditions derived from exposure GFA data | DOUBLE |
| efftime_spec | Effective exposure time for nominal conditions derived from the TSNR2 fits to the spectroscopy | DOUBLE |
| elg_efftime_dark | Effective exposure time for nominal dark conditions inferred for ELG targets | DOUBLE |
| exptime | Length of time shutter was open | DOUBLE |
| faflavor | Fiberassign flavor name | VARCHAR |
| faprgrm | Fiberassign program name | VARCHAR |
| goaltime | Goal for total effective exposure time for the tile | DOUBLE |
| goaltype | The intended observing conditions for the tile | VARCHAR |
| lastnight | Most recent night with a good exposure | INTEGER |
| lrg_efftime_dark | Effective exposure time for nominal dark conditions inferred for LRG targets | DOUBLE |
| lya_efftime_dark | Effective exposure time for nominal dark conditions inferred for LYA targets | DOUBLE |
| mintfrac | Minimum fraction of GOALTIME acceptable for considering a tile complete | DOUBLE |
| nexp | Number of exposures used in EFFTIME estimates | BIGINT |
| obsstatus | Observing conditions bitmask | VARCHAR |
| program | DESI program type - BRIGHT, DARK, or BACKUP | VARCHAR |
| random_id | Random ID in the range 0.0 => 100.0 (not unique) | REAL |
| survey | Survey name | VARCHAR |
| tiledec | DEC of tile given in fiberassign file | DOUBLE |
| tileid | Unique DESI tile ID | INTEGER |
| tilera | RA of tile given in fiberassign file | DOUBLE |
