Airports & runways navdata
The format of the navdata packs, read from the published packs themselves. Machine-readable: navdata.json.
Format
Generated from:
airports-conusedition2612, schema_version 1; built by pyEfistools/build_airport_db.py(commit not recorded) · bootstrap: read from the published pack
pack_meta keys: attribution, cycle, effective, expires, id, kind, license, license_url, schema_version.
airports
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
site_no | TEXT | 1 | |||
icao | TEXT | yes | ARPT_ID, e.g. "KSBA" | ||
name | TEXT | ||||
lat | REAL | yes | |||
lon | REAL | yes | |||
elev_ft | REAL | ||||
mag_var | REAL | signed: +E, -W | |||
state | TEXT | ||||
city | TEXT |
CREATE statement, verbatim
CREATE TABLE airports (
site_no TEXT PRIMARY KEY,
icao TEXT NOT NULL, -- ARPT_ID, e.g. "KSBA"
name TEXT,
lat REAL NOT NULL,
lon REAL NOT NULL,
elev_ft REAL,
mag_var REAL, -- signed: +E, -W
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 | yes | 1 | ||
rwy_id | TEXT | yes | 2 | ||
end_id | TEXT | yes | 3 | e.g. "07" or "25L" | |
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 | "BSC" / "NPI" / "PIR" / "NSTD" / "" | |||
apch_lgt_code | TEXT | "P2L", "ALSF1", "MALSR", ... | |||
end_lgts_flag | TEXT | "Y" / "N" | |||
cntrln_lgts_flag | TEXT | ||||
tdz_lgt_flag | TEXT | ||||
vgsi_code | TEXT | VGSI type/box-count/side, e.g. "P4L"; NULL if none installed | |||
visual_gpa | REAL | published visual glide path angle (deg); NULL if not published |
CREATE statement, verbatim
CREATE TABLE runway_ends (
site_no TEXT NOT NULL,
rwy_id TEXT NOT NULL,
end_id TEXT NOT NULL, -- e.g. "07" or "25L"
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, -- "BSC" / "NPI" / "PIR" / "NSTD" / ""
apch_lgt_code TEXT, -- "P2L", "ALSF1", "MALSR", ...
end_lgts_flag TEXT, -- "Y" / "N"
cntrln_lgts_flag TEXT,
tdz_lgt_flag TEXT,
vgsi_code TEXT, -- VGSI type/box-count/side, e.g. "P4L"; NULL if none installed
visual_gpa REAL, -- published visual glide path angle (deg); NULL if not published
PRIMARY KEY (site_no, rwy_id, end_id)
)runways
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
site_no | TEXT | yes | 1 | ||
rwy_id | TEXT | yes | 2 | e.g. "07/25" | |
length_ft | REAL | ||||
width_ft | REAL | ||||
surface | TEXT | "ASPH", "CONC", "TURF", ... | |||
lighting | TEXT | "HIGH", "MED", "LOW", "NSTD", "" |
CREATE statement, verbatim
CREATE TABLE runways (
site_no TEXT NOT NULL,
rwy_id TEXT NOT NULL, -- e.g. "07/25"
length_ft REAL,
width_ft REAL,
surface TEXT, -- "ASPH", "CONC", "TURF", ...
lighting TEXT, -- "HIGH", "MED", "LOW", "NSTD", ""
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.
22: airports.city, airports.elev_ft, airports.lat, airports.lon, airports.name, airports.site_no, airports.state, 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.lat, runway_ends.lon, 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.site_no, runways.width_ft