Choose a database in the left panel then select the table you want!

Table: desi_edr.tile
(The bold columns are indexed columns)
Column NameDescriptionDatatype
bgs_efftime_brightEffective exposure time for nominal bright conditions inferred for BGS targetsREAL
efftime_etcEffective exposure time for nominal conditions inferred from ETC dataREAL
efftime_gfaEffective exposure time for nominal conditions derived from exposure GFA dataREAL
efftime_specEffective exposure time for nominal conditions derived from the TSNR2 fits to the spectroscopyREAL
elg_efftime_darkEffective exposure time for nominal dark conditions inferred for ELG targetsREAL
exptimeLength of time shutter was openREAL
faflavorFiberassign flavor nameVARCHAR
faprgrmFiberassign program nameVARCHAR
goaltimeGoal for total effective exposure time for the tileSMALLINT
goaltypeThe intended observing conditions for the tileVARCHAR
lastnightMost recent night with a good exposureINTEGER
lrg_efftime_darkEffective exposure time for nominal dark conditions inferred for LRG targetsREAL
lya_efftime_darkEffective exposure time for nominal dark conditions inferred for LYA targetsREAL
mintfracMinimum fraction of GOALTIME acceptable for considering a tile completeREAL
nexpNumber of exposures used in EFFTIME estimatesSMALLINT
obsstatusObserving conditions bitmaskVARCHAR
programDESI program type - BRIGHT, DARK, or BACKUPVARCHAR
random_idRandom ID in the range 0.0 => 100.0 (not unique)REAL
surveySurvey nameVARCHAR
tiledecDEC of tile given in fiberassign fileREAL
tileidUnique DESI tile IDINTEGER
tileraRA of tile given in fiberassign fileREAL