Procedures & airways procedures
The format of the procedures packs, read from the published packs themselves. Machine-readable: procedures.json.
Format
Generated from:
procedures-conusedition2612, schema_version 1; built by makerplane-data packtools/build/procedures.py at 6b3d2e542d35 · bootstrap: read from the published pack
pack_meta keys: attribution, cycle, effective, expires, id, kind, license, license_url, schema_version.
airway_legs
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
airway_id | INTEGER | yes | |||
seq | INTEGER | yes | |||
fix_id | TEXT | yes | |||
fix_lat | REAL | ||||
fix_lon | REAL | ||||
fix_type | TEXT | ||||
min_alt_ft | INTEGER | ||||
max_alt_ft | INTEGER | ||||
direction | TEXT |
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
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
id | INTEGER | 1 | |||
ident | TEXT | yes | |||
cycle | TEXT | yes |
CREATE statement, verbatim
CREATE TABLE airways (
id INTEGER PRIMARY KEY,
ident TEXT NOT NULL,
cycle TEXT NOT NULL
)legs
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
transition_id | INTEGER | yes | |||
seq | INTEGER | yes | |||
path_term | TEXT | yes | |||
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 | yes | Waypoint 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_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 |
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.
| 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)
procedures
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
id | INTEGER | 1 | |||
airport | TEXT | yes | |||
kind | TEXT | yes | sid | star | approach | ||
ident | TEXT | yes | |||
runway | TEXT | ||||
approach_type | TEXT | ||||
rnp | REAL | ||||
cycle | TEXT | yes |
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
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
id | INTEGER | 1 | |||
proc_id | INTEGER | yes | |||
role | TEXT | yes | enroute | runway | common | ||
ident | TEXT |
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
| index | table | columns | unique |
|---|---|---|---|
idx_awy_ident | airways | ident | yes |
idx_awyleg_awy | airway_legs | airway_id, seq | |
idx_awyleg_fix | airway_legs | fix_id | |
idx_legs_trans | legs | transition_id, seq | |
idx_proc_airport | procedures | airport, kind | |
idx_trans_proc | transitions | proc_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