AeroCommonsNavigation Data · pack formats · test reports

Obstacles obstacles

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

Format

Generated from:

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

obstacles

columntypenot nulldefaultprimary keydescription
oas_noTEXT1
latREALyes
lonREALyes
amsl_ftREALyestip elevation, ft MSL
agl_ftREALyesheight above ground, ft
typeTEXT"TOWER", "ANTENNA", "BLDG", "STACK", "WIND TURB", ...
quantityINTEGERnumber of objects at this site (usually 1)
lightingTEXTR=red, W=white, D=dual, M=marked, N=none, U=unknown
markingTEXT
stateTEXT
cityTEXT
CREATE statement, verbatim
CREATE TABLE obstacles (
    oas_no    TEXT PRIMARY KEY,
    lat       REAL NOT NULL,
    lon       REAL NOT NULL,
    amsl_ft   REAL NOT NULL,        -- tip elevation, ft MSL
    agl_ft    REAL NOT NULL,        -- height above ground, ft
    type      TEXT,                 -- "TOWER", "ANTENNA", "BLDG", "STACK", "WIND TURB", ...
    quantity  INTEGER,              -- number of objects at this site (usually 1)
    lighting  TEXT,                 -- R=red, W=white, D=dual, M=marked, N=none, U=unknown
    marking   TEXT,
    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)

Indexes

indextablecolumnsunique
idx_obstacles_aglobstaclesagl_ft
idx_obstacles_latobstacleslat

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.

6: obstacles.city, obstacles.lat, obstacles.lon, obstacles.marking, obstacles.oas_no, obstacles.state