Airports (regional) airports
The format of the airports packs, read from the published packs themselves. Machine-readable: airports.json.
Format
Generated from:
airports-canadaedition2026.06, schema_version 1; built by makerplane-datapacktools/ourairports.py(commit not recorded) · bootstrap: read from the published pack
pack_meta keys: attribution, cycle, id, kind, schema_version.
airports
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
site_no | TEXT | 1 | |||
icao | TEXT | yes | |||
name | TEXT | ||||
lat | REAL | yes | |||
lon | REAL | yes | |||
elev_ft | REAL | ||||
mag_var | REAL | ||||
state | TEXT | ||||
city | TEXT |
CREATE statement, verbatim
CREATE TABLE airports (site_no TEXT PRIMARY KEY, icao TEXT NOT NULL, name TEXT, lat REAL NOT NULL, lon REAL NOT NULL, elev_ft REAL, mag_var REAL, state TEXT, city TEXT)
pack_meta
The pack's own header: the same id, kind, cycle and licence its manifest entry carries, so a pack copied away from the catalog still identifies itself.
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
key | TEXT | 1 | A pack_meta field name (see the pack_meta table on the index page). | ||
value | TEXT | That field's value, as text. |
CREATE statement, verbatim
CREATE TABLE pack_meta (key TEXT PRIMARY KEY, value TEXT)
runway_ends
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
site_no | TEXT | 1 | |||
rwy_id | TEXT | 2 | |||
end_id | TEXT | 3 | |||
true_alignment_deg | REAL | ||||
lat | REAL | ||||
lon | REAL | ||||
elev_ft | REAL | ||||
displaced_thr_lat | REAL | ||||
displaced_thr_lon | REAL | ||||
displaced_thr_len_ft | REAL | ||||
tdz_elev_ft | REAL | ||||
marking_type | TEXT | ||||
apch_lgt_code | TEXT | ||||
end_lgts_flag | TEXT | ||||
cntrln_lgts_flag | TEXT | ||||
tdz_lgt_flag | TEXT |
CREATE statement, verbatim
CREATE TABLE runway_ends (site_no TEXT, rwy_id TEXT, end_id TEXT, true_alignment_deg REAL, lat REAL, lon REAL, elev_ft REAL, displaced_thr_lat REAL, displaced_thr_lon REAL, displaced_thr_len_ft REAL, tdz_elev_ft REAL, marking_type TEXT, apch_lgt_code TEXT, end_lgts_flag TEXT, cntrln_lgts_flag TEXT, tdz_lgt_flag TEXT, PRIMARY KEY (site_no, rwy_id, end_id))
runways
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
site_no | TEXT | 1 | |||
rwy_id | TEXT | 2 | |||
length_ft | REAL | ||||
width_ft | REAL | ||||
surface | TEXT | ||||
lighting | TEXT |
CREATE statement, verbatim
CREATE TABLE runways (site_no TEXT, rwy_id TEXT, length_ft REAL, width_ft REAL, surface TEXT, lighting TEXT, PRIMARY KEY (site_no, rwy_id))
Indexes
| index | table | columns | unique |
|---|---|---|---|
idx_airports_icao | airports | icao | |
idx_airports_lat | airports | lat |
Not yet described
These have no inline comment in the builder's CREATE statement and no entry in docs/schema_descriptions.yaml. Their names and types above are still exact.
31: airports.city, airports.elev_ft, airports.icao, airports.lat, airports.lon, airports.mag_var, airports.name, airports.site_no, airports.state, runway_ends.apch_lgt_code, runway_ends.cntrln_lgts_flag, runway_ends.displaced_thr_lat, runway_ends.displaced_thr_len_ft, runway_ends.displaced_thr_lon, runway_ends.elev_ft, runway_ends.end_id, runway_ends.end_lgts_flag, runway_ends.lat, runway_ends.lon, runway_ends.marking_type, runway_ends.rwy_id, runway_ends.site_no, runway_ends.tdz_elev_ft, runway_ends.tdz_lgt_flag, runway_ends.true_alignment_deg, runways.length_ft, runways.lighting, runways.rwy_id, runways.site_no, runways.surface, runways.width_ft