Public Road Length By Functional System And State, 1980 - 2023 (HM-20)
Department of Transportation
@usgov.dot_gov_public_road_length_by_functional_system_and_st_d239fb67
Department of Transportation
@usgov.dot_gov_public_road_length_by_functional_system_and_st_d239fb67
Annual length of U.S. public roads in miles by functional system for each of the 50 states, DC, and Puerto Rico from the Highway Statistics table HM-20. (Note: In 2009, the Urban functional class of Collectors became Major Collectors and Minor Collectors.)
Organization: Department of Transportation
Last updated: 2025-04-04T21:10:42.550012
Tags: functional-system, highway-statistics, miles, roadway-bridges, rural-urban, state
CREATE TABLE table_1 (
"year" BIGINT,
"state" VARCHAR,
"area" VARCHAR,
"fclass" VARCHAR,
"miles" DOUBLE
);Anyone who has the link will be able to view this.