AeroCommonsNavigation Data · pack formats · test reports

Airports (regional) airports

The format of the airports packs, read from the published packs themselves. Machine-readable: airports.json.

Format

Generated from:

pack_meta keys: attribution, cycle, id, kind, schema_version.

airports

columntypenot nulldefaultprimary keydescription
site_noTEXT1
icaoTEXTyes
nameTEXT
latREALyes
lonREALyes
elev_ftREAL
mag_varREAL
stateTEXT
cityTEXT
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.

columntypenot nulldefaultprimary keydescription
keyTEXT1A pack_meta field name (see the pack_meta table on the index page).
valueTEXTThat field's value, as text.
CREATE statement, verbatim
CREATE TABLE pack_meta (key TEXT PRIMARY KEY, value TEXT)

runway_ends

columntypenot nulldefaultprimary keydescription
site_noTEXT1
rwy_idTEXT2
end_idTEXT3
true_alignment_degREAL
latREAL
lonREAL
elev_ftREAL
displaced_thr_latREAL
displaced_thr_lonREAL
displaced_thr_len_ftREAL
tdz_elev_ftREAL
marking_typeTEXT
apch_lgt_codeTEXT
end_lgts_flagTEXT
cntrln_lgts_flagTEXT
tdz_lgt_flagTEXT
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

columntypenot nulldefaultprimary keydescription
site_noTEXT1
rwy_idTEXT2
length_ftREAL
width_ftREAL
surfaceTEXT
lightingTEXT
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

indextablecolumnsunique
idx_airports_icaoairportsicao
idx_airports_latairportslat

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