About this Dataset

Traffic

A SHSP (Strategic Highway Safety Plan) is a statewide-coordinated safety plan that provides a comprehensive framework for reducing highway fatalities and serious injuries on all public roads. The SHSP strategically establishes statewide goals, objectives and key emphasis areas developed in consultation with federal, state, local and private sector safety stakeholders. The SHSP plan process is a requirement of the Federal Highway Administration's Highway Safety Improvement Program (HSIP). In general, the federal HSIP requires that state transportation departments develop an SHSP that: includes consultation from a variety of stakeholders during the development process, analyzes and makes effective use of crash data, addresses the 5Es (engineering, enforcement, education, emergency services and everyone) plus management and operations, considers the safety needs of all public roads, describes a program of projects or strategies to reduce or eliminate safety hazards, is implemented and evaluated. This dataset provides traffic data used for most current SHSP.
Organization: State of Iowa
Last updated: 2024-04-12T12:47:00.435115
Tags: crash, safety, shsp, strategic-highway-safety-plan

Tables

Table 1

@usgov.state_of_iowa_traffic_data_185f5.table_1

7.08 MB
12,987 rows
24 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "route_id" VARCHAR,
  "estimate" VARCHAR,
  "aadt_count_year" BIGINT,
  "aadt" BIGINT,
  "automobile" BIGINT,
  "motorcycle" BIGINT,
  "pickup" BIGINT,
  "passenger_aadt" BIGINT,
  "bus" BIGINT,
  "single_unit_2_axle" BIGINT,
  "single_unit_3_axle" BIGINT,
  "single_unit_4_axle" BIGINT,
  "single_unit_aadt" BIGINT,
  "single_trailer_4_axle" BIGINT,
  "single_trailer_5_axle" BIGINT,
  "single_trailer_6_axle" BIGINT,
  "multiple_trailer_5_axle" BIGINT,
  "multiple_trailer_6_axle" BIGINT,
  "multiple_trailer_7_axle" BIGINT,
  "combination_aadt" BIGINT,
  "shape_length" DOUBLE  -- SHAPE, Length,
  "globalid" VARCHAR
);