AeroCommonsNavigation Data · pack formats · test reports

Procedures & airways procedures

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

Format

Generated from:

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

airway_legs

columntypenot nulldefaultprimary keydescription
airway_idINTEGERyes
seqINTEGERyes
fix_idTEXTyes
fix_latREAL
fix_lonREAL
fix_typeTEXT
min_alt_ftINTEGER
max_alt_ftINTEGER
directionTEXT
CREATE statement, verbatim
CREATE TABLE airway_legs (
    airway_id   INTEGER NOT NULL REFERENCES airways(id),
    seq         INTEGER NOT NULL,
    fix_id      TEXT NOT NULL,
    fix_lat     REAL,
    fix_lon     REAL,
    fix_type    TEXT,
    min_alt_ft  INTEGER,
    max_alt_ft  INTEGER,
    direction   TEXT
)

airways

columntypenot nulldefaultprimary keydescription
idINTEGER1
identTEXTyes
cycleTEXTyes
CREATE statement, verbatim
CREATE TABLE airways (
    id      INTEGER PRIMARY KEY,
    ident   TEXT NOT NULL,
    cycle   TEXT NOT NULL
)

legs

columntypenot nulldefaultprimary keydescription
transition_idINTEGERyes
seqINTEGERyes
path_termTEXTyes
fix_idTEXT
fix_latREAL
fix_lonREAL
fix_typeTEXT
recd_navaidTEXT
thetaREAL
rhoREAL
courseREAL
dist_nmREAL
time_minREAL
alt_descTEXT
alt1_ftINTEGER
alt2_ftINTEGER
speed_ktINTEGER
turn_dirTEXT
rnpREAL
flagsINTEGERyesWaypoint description bits (ARINC 424 Sec. 5.17): 1 fly-over, 2 initial approach fix, 4 final approach fix, 8 missed approach point, 16 holding leg (HA/HF/HM), 32 first leg of the missed approach, 64 final approach course fix (the fix on the final course before the FAF; never the FAF). Editions built before AER-5555 have no 64 and set 4 on the final approach course fix too, so a final there can carry two 4s: the FAF is the later one in seq order.
centre_fixTEXTRF (radius-to-fix) arc centre; NULL for every other leg type
centre_latREAL
centre_lonREAL
arc_radius_nmREALderived: great_circle(centre, fix); convenience for the renderer
CREATE statement, verbatim
CREATE TABLE legs (
    transition_id   INTEGER NOT NULL REFERENCES transitions(id),
    seq             INTEGER NOT NULL,
    path_term       TEXT NOT NULL,
    fix_id          TEXT,
    fix_lat         REAL,
    fix_lon         REAL,
    fix_type        TEXT,
    recd_navaid     TEXT,
    theta           REAL,
    rho             REAL,
    course          REAL,
    dist_nm         REAL,
    time_min        REAL,
    alt_desc        TEXT,
    alt1_ft         INTEGER,
    alt2_ft         INTEGER,
    speed_kt        INTEGER,
    turn_dir        TEXT,
    rnp             REAL,
    flags           INTEGER NOT NULL,
    centre_fix      TEXT,       -- RF (radius-to-fix) arc centre; NULL for every other leg type
    centre_lat      REAL,
    centre_lon      REAL,
    arc_radius_nm   REAL        -- derived: great_circle(centre, fix); convenience for the renderer
)

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)

procedures

columntypenot nulldefaultprimary keydescription
idINTEGER1
airportTEXTyes
kindTEXTyessid | star | approach
identTEXTyes
runwayTEXT
approach_typeTEXT
rnpREAL
cycleTEXTyes
CREATE statement, verbatim
CREATE TABLE procedures (
    id              INTEGER PRIMARY KEY,
    airport         TEXT NOT NULL,
    kind            TEXT NOT NULL,   -- sid | star | approach
    ident           TEXT NOT NULL,
    runway          TEXT,
    approach_type   TEXT,
    rnp             REAL,
    cycle           TEXT NOT NULL
)

transitions

columntypenot nulldefaultprimary keydescription
idINTEGER1
proc_idINTEGERyes
roleTEXTyesenroute | runway | common
identTEXT
CREATE statement, verbatim
CREATE TABLE transitions (
    id          INTEGER PRIMARY KEY,
    proc_id     INTEGER NOT NULL REFERENCES procedures(id),
    role        TEXT NOT NULL,        -- enroute | runway | common
    ident       TEXT
)

Indexes

indextablecolumnsunique
idx_awy_identairwaysidentyes
idx_awyleg_awyairway_legsairway_id, seq
idx_awyleg_fixairway_legsfix_id
idx_legs_translegstransition_id, seq
idx_proc_airportproceduresairport, kind
idx_trans_proctransitionsproc_id

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.

43: airway_legs.airway_id, airway_legs.direction, airway_legs.fix_id, airway_legs.fix_lat, airway_legs.fix_lon, airway_legs.fix_type, airway_legs.max_alt_ft, airway_legs.min_alt_ft, airway_legs.seq, airways.cycle, airways.id, airways.ident, legs.alt1_ft, legs.alt2_ft, legs.alt_desc, legs.centre_lat, legs.centre_lon, legs.course, legs.dist_nm, legs.fix_id, legs.fix_lat, legs.fix_lon, legs.fix_type, legs.path_term, legs.recd_navaid, legs.rho, legs.rnp, legs.seq, legs.speed_kt, legs.theta, legs.time_min, legs.transition_id, legs.turn_dir, procedures.airport, procedures.approach_type, procedures.cycle, procedures.id, procedures.ident, procedures.rnp, procedures.runway, transitions.id, transitions.ident, transitions.proc_id