AeroCommonsNavigation Data · pack formats · test reports

Airports & runways navdata

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

Format

Generated from:

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

airports

columntypenot nulldefaultprimary keydescription
site_noTEXT1
icaoTEXTyesARPT_ID, e.g. "KSBA"
nameTEXT
latREALyes
lonREALyes
elev_ftREAL
mag_varREALsigned: +E, -W
stateTEXT
cityTEXT
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.

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_noTEXTyes1
rwy_idTEXTyes2
end_idTEXTyes3e.g. "07" or "25L"
true_alignment_degREAL
latREAL
lonREAL
elev_ftREAL
displaced_thr_latREAL
displaced_thr_lonREAL
displaced_thr_len_ftREAL
tdz_elev_ftREAL
marking_typeTEXT"BSC" / "NPI" / "PIR" / "NSTD" / ""
apch_lgt_codeTEXT"P2L", "ALSF1", "MALSR", ...
end_lgts_flagTEXT"Y" / "N"
cntrln_lgts_flagTEXT
tdz_lgt_flagTEXT
vgsi_codeTEXTVGSI type/box-count/side, e.g. "P4L"; NULL if none installed
visual_gpaREALpublished 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

columntypenot nulldefaultprimary keydescription
site_noTEXTyes1
rwy_idTEXTyes2e.g. "07/25"
length_ftREAL
width_ftREAL
surfaceTEXT"ASPH", "CONC", "TURF", ...
lightingTEXT"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

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.

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