Obstacles obstacles
The format of the obstacles packs, read from the published packs themselves. Machine-readable: obstacles.json.
Format
Generated from:
obstacles-conusedition261001, schema_version 1; built by pyEfistools/build_obstacle_db.py(commit not recorded) · bootstrap: read from the published pack
pack_meta keys: attribution, cycle, effective, expires, id, kind, license, license_url, schema_version.
obstacles
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
oas_no | TEXT | 1 | |||
lat | REAL | yes | |||
lon | REAL | yes | |||
amsl_ft | REAL | yes | tip elevation, ft MSL | ||
agl_ft | REAL | yes | 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 |
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.
| 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)
Indexes
| index | table | columns | unique |
|---|---|---|---|
idx_obstacles_agl | obstacles | agl_ft | |
idx_obstacles_lat | obstacles | lat |
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