About this Dataset

Annual Aggregated County Road Mileage

An annual snapshot of county road mileage, in both lane and centerline miles, aggregated by Year, County, Function Classification, Thru Lane Surface, and Truck Route Classification.

Washington State counties are required to maintain a complete inventory of all county roads, assuring the capability to evaluate and compare the transportation needs and capabilities across the state, thus providing a high level of accountability both by individual county and statewide (WAC 136-60).

Each county is responsible for maintaining current information regarding its Road Log and, no later than April 1st of each year, submits an updated Road Log for its complete road system with all data elements as of December 31st of the preceding year (known in this dataset as "Calendar Year"). This dataset contains aggregated mileage submitted by WA counties and certified by the WA State County Road Administration Board (CRAB) as part of the county road inventory. More information about the County Road Log is available at: https://www.crab.wa.gov/county-road-log.
Organization: State of Washington
Last updated: 2025-02-14T22:09:30.088358
Tags: county, mileage, roads

Tables

Table 1

@usgov.state_of_washington_annual_county_road_mileage_by_county.table_1

73.15 kB
7,931 rows
13 columns

CREATE TABLE table_1 (
  "calendar_year" BIGINT,
  "county_order_number" BIGINT,
  "county_name" VARCHAR,
  "jurisdiction" BIGINT,
  "function_class" BIGINT,
  "function_class_description" VARCHAR,
  "thru_lane_surface" VARCHAR,
  "is_paved" BOOLEAN,
  "truck_route_description" VARCHAR,
  "is_fgts" BOOLEAN,
  "is_cfgs" BOOLEAN,
  "total_lane_miles" DOUBLE,
  "total_centerline_miles" DOUBLE
);