Navaids & airways navaids
The format of the navaids packs, read from the published packs themselves. Machine-readable: navaids.json.
Format
Generated from:
navaids-conusedition2612, schema_version 1; built by pyEfistools/build_navaid_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.
awy_segments
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
awy_id | TEXT | ||||
seq | INTEGER | ||||
p1 | TEXT | ||||
lat1 | REAL | ||||
lon1 | REAL | ||||
p2 | TEXT | ||||
lat2 | REAL | ||||
lon2 | REAL |
CREATE statement, verbatim
CREATE TABLE awy_segments (awy_id TEXT, seq INTEGER,
p1 TEXT, lat1 REAL, lon1 REAL,
p2 TEXT, lat2 REAL, lon2 REAL)fixes
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
id | TEXT | ||||
use_code | TEXT | ||||
lat | REAL | ||||
lon | REAL |
CREATE statement, verbatim
CREATE TABLE fixes (id TEXT, use_code TEXT, lat REAL, lon REAL)
navaids
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
id | TEXT | ||||
type | TEXT | ||||
name | TEXT | ||||
freq | TEXT | ||||
elev_ft | REAL | ||||
lat | REAL | ||||
lon | REAL |
CREATE statement, verbatim
CREATE TABLE navaids (id TEXT, type TEXT, name TEXT, freq TEXT,
elev_ft REAL, lat REAL, lon REAL)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)
Indexes
| index | table | columns | unique |
|---|---|---|---|
idx_fix_ll | fixes | lat, lon | |
idx_nav_ll | navaids | lat, lon | |
idx_seg_ll | awy_segments | lat1, lon1 |
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.
19: awy_segments.awy_id, awy_segments.lat1, awy_segments.lat2, awy_segments.lon1, awy_segments.lon2, awy_segments.p1, awy_segments.p2, awy_segments.seq, fixes.id, fixes.lat, fixes.lon, fixes.use_code, navaids.elev_ft, navaids.freq, navaids.id, navaids.lat, navaids.lon, navaids.name, navaids.type