AeroCommonsNavigation Data · pack formats · test reports

Roads & highways highways

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

Format

Generated from:

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

highway_lines

columntypenot nulldefaultprimary keydescription
idINTEGER1
fclassTEXTyes
min_latREAL
max_latREAL
min_lonREAL
max_lonREAL
vertsBLOByes
flagsINTEGERyes0Bit 0: tunnel. Bit 1: bridge. Absent in editions built before 2026q3r1; a reader treats a missing column as 0.
refTEXTRoute 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.

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)

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