Datadory notebook
How Developers & Builders Use Highways & Railtracks Data
Datadory delivers how developers builders use highways railtracks data with comprehensive historical coverage, validated schemas, and standardized fields — delivered daily, weekly, or on demand.
1,744 datasets. Pick your catch.
What does highways-railtracks data look like from an integration standpoint?
The split matters because it dictates your toolchain rather than your budget. Keyless REST suits tag-filtered pulls and row-level joins; anonymous cloud buckets suit warehouse-scale scans; one registered STOMP broker is the only place streaming discipline applies. For this persona specifically, tagging rates 11 records relevant to developers-builders, with five rated relevance 3: Geofabrik (quality score 10), then Network Rail Data Feeds, the OpenStreetMap Overpass API, the Overture Maps Transportation Theme and the USDOT Open Data Portal, each scoring 9.
How do you stream live GB train movements into your stack?
Network Rail Data Feeds is the pool's only real-time source, and its developer experience is deliberately spartan: create a free NTROD account (email, name, password, email-code confirmation), subscribe to feeds in the account portal, then point a STOMP client at the broker with your credentials - connection specifics live on the community wiki's Connecting with Stomp page. The portal exposes 5 real-time STOMP topics: MOVEMENT for train positioning and movement events, TD for signalling-berth steps, TSR for temporary speed restrictions, VSTP for late-created schedules and RTPPM for the percentage of trains arriving on time, reported operator- and sector-level. TRUST and TD streams move millions of messages per week.
Data Coverage and Field Structure
Datadory delivers this dataset fully structured and normalized, ready for direct analysis without manual pipeline configuration or schema parsing.
Which federal files need a real parser before they render?
Three US series reward someone who writes an ingester rather than clicking export buttons. The National Bridge Inventory (NBI) ASCII Files publish about 624,000 bridge records for 2025 as 445-character fixed-width rows - condition ratings live in single characters (deck is ITEM 58 at position 259, superstructure ITEM 59 at position 260) - so parse against FHWA's record-format dictionary, not guesswork. A working pipeline:
- Fetch the year page (
ascii2025.cfm) and follow the ZIP links through the disclaim.cfm gateway. - Choose the combined all-states file, about 51 MB zipped, unless per-state deltas matter.
- Pick fixed-width or comma-delimited (single-quote text qualifier) and pin the choice in CI.
- Map character positions from format.cfm; keep mtguide.pdf handy for coding conventions.
- Re-run after each June 15 finalization, since annual editions run 1992-2025 and inspections lag roughly 24 months.
The FHWA Highway Statistics Series (1945-present) is friendlier: recent editions expose about 153 table files whose URLs follow a verifiable pattern (/policyinformation/statistics/{year}/xls/hm48.xlsx, vm2.xlsx, dl20.xlsx), making scripted enumeration trivial across eighty-plus years of state tables covering mileage, VMT, motor fuel, finance and bridges. The Highway Performance Monitoring System (HPMS) splits the difference - older releases are state ZIPs from about 1 MB (Delaware) to 323 MB (California 2014), while 2018-onward ArcGIS FeatureServers answer f=json queries returning route_id, aadt, f_system, through_lanes, iri and truck per segment.
Where to go next
This page is the developer angle on the industry slice. For the dataset-by-dataset treatment, read the highways-railtracks data guide; the persona page collects every qualifying dataset for builders, and the industry hub ties together the best-of, free-list and per-dataset pages. For the same evidence base framed around storefront logistics rather than integration work, see how e-commerce operators put these feeds to use.
Pick up where this leaves off
Every one of these ships with sample rows before you commit to anything.
OpenStreetMap Overpass API
USDOT Open Data Portal - National Transportation Datasets
crossingid · railroad · typexing …+1 more
Overture Maps Transportation Theme
Geofabrik OpenStreetMap Data Extracts
highway · railway · name …+8 more
Network Rail Data Feeds Data
National Bridge Inventory (NBI) ASCII Files
Want rows instead of a pitch? Name the datasets.
API, files, or your warehouse. Daily, weekly, or hourly.
Get a sampleQuestions worth asking
How do I load Overture roads into DuckDB?
Run `LOAD spatial; LOAD httpfs;` then `SELECT * FROM read_parquet('s3://overturemaps-us-west-2/release/<release>/theme=transportation/type=segment/*')` with a `bbox.xmin` predicate so partition pruning kicks in. The August 2026 release holds about 128 million residential segments plus roughly 1.5 million rail segments under commercial delivery terms - attribute "(c) OpenStreetMap contributors, Overture Maps Foundation."