Annual Quarter-Hourly Speed Profiles

Overview

The quarter-hourly speed profile table contains information about the average observed speed per network link, provided in quarter-hourly buckets for a typical week. This data is available for 2021, 2022, 2023 and 2024, and is updated annually. Data is available for download in CSV format.

See what coverage we have in specific areas here.

FRC	Quarter-hourly speed profile % Coverage in 2022 data * percentage of segments providing speed values for over 2/3 of quarter-hour buckets
1	92.6%
2	95.3%
3	83.2%
4	44.6%

Sample Download

Click here to download a sample of Replica's quarter-hourly speed profile per network link table.

Schema

Field name	Content Type	Sample Value	Description
stable_edge_id	String	6544473848226082043	A unique identifier for each road segment.
osm_id	String	5149900	OSM Way ID (version 2021-09-01 for the 2021 data; version 2022-12-01 for the 2022 data)
forward	Boolean	TRUE	Orientation of speed relative to OSM way (True: parallel, False: antiparallel).
speed_mph	Integer	44	Average speed for the network link in miles per hour.
speed_p95_mph	Integer	45	Percentile 95 of speeds in the network link in miles per hour.
speed_p85_mph	Integer	42	Percentile 85 of speeds in the network link in miles per hour.
speed_p50_mph	Integer	40	Median of speeds in the network link in miles per hour.
street_name	String	Scenic Avenue	The common name of the network link if available. Matches the name assigned by OpenStreetMap.
geometry	Geography	LINESTRING(-122.279327301964 37.8109962748959, -122.279142155032 37.8109143185075, -122.279041013398 37.8108588116808)	The geometry of the network link.
lat	Float	37.8109315588127	Latitude of the point on the network link nearest to its centroid.
lng	Float	-122.27918110236033	Longitude of the point on the network link nearest to its centroid.
length	Float	29.46	The length of the network link in meters.
heading	Integer	121	The heading of the network link.
highway	String	secondary_link	The classification of the link based on OpenStreetMap data if available.
mon_0, mon_1...mon_95	Float	66.2	One column per quarter hour. The value in each column represents the speed on the network link in the quarter-hour bucket. Buckets are expressed as 0-95 and are counted from midnight. If a specific day of the week is chosen for download, the column names will reflect the day of week (e.g. mon_0, tue_0, wed_0). If an "Average Weekday" or "Average Weekend Day" is selected for download, the columns will be named wkdy_0...wkdy_95 and wknd_0...wknd_95 respectively. The average weekday values are averaged over Monday to Friday; the average weekend values are averaged over Saturday and Sunday.

Quality Metrics and Methodology

Read about the Quality Metrics and Methodology on the overview page for Replica's Annual Speeds Data.