Roads & highways highways
The format of the highways packs, read from the published packs themselves. Machine-readable: highways.json.
Format
Generated from:
highways-conusedition2026q3r1, schema_version 1; built by pyEfistools/build_highway_db.py(commit not recorded) · bootstrap: read from the published pack
pack_meta keys: attribution, cycle, id, kind, license, license_url, schema_version.
highway_lines
| column | type | not null | default | primary key | description |
|---|---|---|---|---|---|
id | INTEGER | 1 | |||
fclass | TEXT | yes | |||
min_lat | REAL | ||||
max_lat | REAL | ||||
min_lon | REAL | ||||
max_lon | REAL | ||||
verts | BLOB | yes | |||
flags | INTEGER | yes | 0 | Bit 0: tunnel. Bit 1: bridge. Absent in editions built before 2026q3r1; a reader treats a missing column as 0. | |
ref | TEXT | Route shield text, e.g. "I 70". Absent in editions built before 2026q3r1; a reader treats a missing column as NULL. |
CREATE statement, verbatim
CREATE TABLE highway_lines (
id INTEGER PRIMARY KEY,
fclass TEXT NOT NULL,
min_lat REAL, max_lat REAL, min_lon REAL, max_lon REAL,
verts BLOB NOT NULL,
flags INTEGER NOT NULL DEFAULT 0,
ref 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)
R-trees
SQLite R*Tree virtual tables, the spatial index a reader queries by bounding box.
highway_rtree: id, min_lat, max_lat, min_lon, max_lon
CREATE VIRTUAL TABLE highway_rtree USING rtree(
id, min_lat, max_lat, min_lon, max_lon
)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.
7: highway_lines.fclass, highway_lines.id, highway_lines.max_lat, highway_lines.max_lon, highway_lines.min_lat, highway_lines.min_lon, highway_lines.verts