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

About this Dataset

Surface Data

Live surface/pavement 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 10 minutes.
Organization: State of Iowa
Last updated: 2024-04-12T12:52:59.082510
Tags: bridge, operations, roadway, rwis, weather, winter

Tables

Table 1

@usgov.state_of_iowa_surface_data_data.table_1

42.36 kB
203 rows
34 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "sensor_status_1_active_0_inactive" BIGINT  -- Sensor Status (1=Active 0=Inactive),
  "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" DOUBLE,
  "garage_name" VARCHAR,
  "dot_district" BIGINT,
  "county_number" BIGINT,
  "data_last_pulled_from_rwis_sensor_utc" VARCHAR  -- Data Last Pulled From RWIS Sensor (UTC),
  "surface_condition" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "surface_temperature_f" DOUBLE  -- Surface Temperature (F),
  "ice_percentage_on_road" BIGINT,
  "freeze_temperature_f" DOUBLE  -- Freeze Temperature (F),
  "sensor_id" DOUBLE,
  "utc_offset" VARCHAR,
  "sensor_priority_for_temperature" BIGINT,
  "friction_index" BIGINT,
  "rams_route_measure" DOUBLE,
  "rams_route_id" VARCHAR
);