AeroCommonsNavigation Data · pack formats · test reports

Navaids & airways navaids

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

Format

Generated from:

pack_meta keys: attribution, cycle, effective, expires, id, kind, license, license_url, schema_version.

awy_segments

columntypenot nulldefaultprimary keydescription
awy_idTEXT
seqINTEGER
p1TEXT
lat1REAL
lon1REAL
p2TEXT
lat2REAL
lon2REAL
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

columntypenot nulldefaultprimary keydescription
idTEXT
use_codeTEXT
latREAL
lonREAL
CREATE statement, verbatim
CREATE TABLE fixes (id TEXT, use_code TEXT, lat REAL, lon REAL)

navaids

columntypenot nulldefaultprimary keydescription
idTEXT
typeTEXT
nameTEXT
freqTEXT
elev_ftREAL
latREAL
lonREAL
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.

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)

Indexes

indextablecolumnsunique
idx_fix_llfixeslat, lon
idx_nav_llnavaidslat, lon
idx_seg_llawy_segmentslat1, 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