Name: Traffic Data
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Traffic Data

Live traffic data from Roadway Weather Information System (RWIS) sites in Iowa. Any field of NA or 9999 describes an invalid value being sent from sensor and was excluded for this REST service. This data gets updated every 5 minutes.
Organization: State of Iowa
Last updated: 2024-04-12T12:52:20.836338
Tags: bridge, operations, roadway, rwis, weather, winter

Tables

Table 1

@usgov.state_of_iowa_traffic_data_data.table_1

29.93 kB
68 rows
33 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "sensor_status_1_active_0_inactive" BIGINT  -- Sensor Status (1=Active 0=Inactive),
  "occupancy" BIGINT,
  "unique_id" BIGINT,
  "rwis_site_number" BIGINT,
  "rwis_rpu_id" BIGINT,
  "sensor_name" VARCHAR,
  "plss_township" VARCHAR,
  "plss_section" DOUBLE,
  "plss_range" VARCHAR,
  "rwis_name" VARCHAR,
  "nws_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "altitude" DOUBLE,
  "county_name" VARCHAR,
  "route_name" VARCHAR,
  "mile_post" DOUBLE,
  "cost_center" BIGINT,
  "garage_name" VARCHAR,
  "dot_district" BIGINT,
  "county_number" BIGINT,
  "data_last_pulled_from_rwis_sensor_utc" VARCHAR  -- Data Last Pulled From RWIS Sensor (UTC),
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "normal_volume" BIGINT,
  "long_volume" BIGINT,
  "average_speed_mph" BIGINT  -- Average Speed (MPH),
  "average_headway" BIGINT,
  "lane_id" BIGINT,
  "utc_offset" VARCHAR,
  "rams_route_id" VARCHAR,
  "rams_route_measure" DOUBLE
);