Download the data
Data for 20 of the largest US counties are available on this page. Each county consists of the OpenStreetMap road network file (GPKG format) and the tabular data file (.tsv format). Join the two together using the osm_id field.
Don’t see your county here? Run our Python/PostGIS code to analyze it yourself. Or contact us for a custom analysis. In both cases, you’ll need a GIS data file with the parcel boundaries. UPDATE September 2022: The code is now better documented, including for Windows machines, thanks to Theodore Lau. Try it out, and please contact us if you have problems.
The data dictionary is available here.
If you use the data, please cite:
Millard-Ball, Adam. 2022. The width and value of residential streets. Journal of the American Planning Association, 88(1): 30-43.
International street-width data are from Angel et al. 2016, Atlas of Urban Expansion.
OpenStreetMap data are © OpenStreetMap contributors
| County | State | Road network | Tabular data |
|---|---|---|---|
| Maricopa | AZ | osm_04013.gpkg | metrics_04013.tsv |
| Alameda | CA | osm_06001.gpkg | metrics_06001.tsv |
| Los Angeles | CA | osm_06037.gpkg | metrics_06037.tsv |
| Orange | CA | osm_06059.gpkg | metrics_06059.tsv |
| Riverside | CA | osm_06065.gpkg | metrics_06065.tsv |
| San Bernardino | CA | osm_06071.gpkg | metrics_06071.tsv |
| San Diego | CA | osm_06073.gpkg | metrics_06073.tsv |
| Santa Clara | CA | osm_06085.gpkg | metrics_06085.tsv |
| Miami-Dade | FL | osm_12086.gpkg | metrics_12086.tsv |
| Cook | IL | osm_17031.gpkg | metrics_17031.tsv |
| Middlesex | MA | osm_25017.gpkg | metrics_25017.tsv |
| Hennepin | MN | osm_27053.gpkg | metrics_27053.tsv |
| Kings | NY | osm_36047.gpkg | metrics_36047.tsv |
| Queens | NY | osm_36081.gpkg | metrics_36081.tsv |
| Shelby | TN | osm_47157.gpkg | metrics_47157.tsv |
| Bexar | TX | osm_48029.gpkg | metrics_48029.tsv |
| Dallas | TX | osm_48113.gpkg | metrics_48113.tsv |
| Harris | TX | osm_48201.gpkg | metrics_48201.tsv |
| Tarrant | TX | osm_48439.gpkg | metrics_48439.tsv |
| King | WA | osm_53033.gpkg | metrics_53033.tsv |
The following counties are not included in the published analysis, but the data were compiled per special request.
Note that these data are for the urban portion of each county only, and there are boundary effects (widths are inflated for streets on the edge of the urban area). The original parcel data are here.
| County | State | Road network | Tabular data |
|---|---|---|---|
| Contra Costa | CA | osm_06013.gpkg | metrics_06013.tsv |
| Fresno | CA | osm_06019.gpkg | metrics_06019.tsv |
| Kern | CA | osm_06029.gpkg | metrics_06029.tsv |
| Monterey | CA | osm_06053.gpkg | metrics_06053.tsv |
| Placer | CA | osm_06061.gpkg | metrics_06061.tsv |
| Sacramento | CA | osm_06067.gpkg | metrics_06067.tsv |
| San Francisco | CA | osm_06075.gpkg | metrics_06075.tsv |
| San Joaquin | CA | osm_06077.gpkg | metrics_06077.tsv |
| Solano | CA | osm_06095.gpkg | metrics_06095.tsv |
| Sonoma | CA | osm_06097.gpkg | metrics_06097.tsv |
| Stanislaus | CA | osm_06099.gpkg | metrics_06099.tsv |
| Tulare | CA | osm_06107.gpkg | metrics_06107.tsv |
| Ventura | CA | osm_06111.gpkg | metrics_06111.tsv |