Every airport in OurAirports, with its IANA time zone,
its name and city, as one SQLite file. Built for the Live Track Home Assistant
integrations, which need to turn an airport code such as KORD into a place, a
position and a local clock. Anyone may use it under the licence below.
The current file is always at the same address:
https://github.com/StrausbergAutomationWorks/AirportZones/releases/download/data/saw_airport_zones.sqlite.gz
https://github.com/StrausbergAutomationWorks/AirportZones/releases/download/data/SHA256SUMS
Release data holds the latest build only. It is rebuilt weekly from that
week's OurAirports data. Check SHA256SUMS (a few bytes) and download the file
only when the hash has changed.
Gzipped SQLite, about 5 MB compressed and 12 MB unpacked. Three tables:
| Table | Columns |
|---|---|
zones |
ident (primary key), tz, lat, lon, cross_check, name, municipality, iata_code, iso_country, type |
aliases |
code (primary key), ident, field |
meta |
k, v: format, build time, sources, licence, attribution, row count |
identis the OurAirports identifier. Resolve a code againstzones.identfirst, thenaliases.code, which holds codes that match an airport on itsicao_code,gps_code,local_codeoriata_codeinstead. Alocal_codeshared by more than one airport is left out rather than guessed.tzis the IANA zone name for the airport's coordinates, computed with timezonefinder. The file stores zone names, not offsets, so daylight saving is handled by your own time zone database.lat,lonare the coordinates the zone was computed from.cross_checkcompares the zone with a second, independent implementation, GeoTimeZone:same_name,same_clock(a different name with the same offsets), orDIFFERS:<zone>. Rows markedDIFFERSlie on a zone border and have not been reviewed yet. Both libraries use the same boundary data, so agreement is a check on the code, not on the boundaries.name,municipality,iata_code,iso_country,typeare OurAirports' own values,NULLwhere OurAirports has none.municipalityis the city.typeincludesclosed: closed airports are kept, because a flight plan can still name one, and should not be presented as open.
meta.format is saw_airport_zones/1. A change to the columns changes that value.
The time zones are derived from
Timezone Boundary Builder
data, which is © OpenStreetMap contributors and available under the
Open Database License (ODbL) v1.0.
This database is therefore made available under the ODbL v1.0 as well. See
DATA_LICENSE.md.
Airport data is from OurAirports (davidmegginson/ourairports-data), released into the public domain.
If you use or share this database, keep the attribution with it. The file
carries it in its own meta table under attribution.
Not affiliated with or endorsed by OurAirports, OpenStreetMap or the Timezone Boundary Builder project. No warranty: check a zone or a name against an authoritative source before relying on it for anything that matters.