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

About this Dataset

Atmospheric Data

Live atmospheric 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:49:12.750917
Tags: bridge, operations, roadway, rwis, weather, winter-operations

Tables

Table 1

@usgov.state_of_iowa_atmospheric_data_data.table_1

43.08 kB
94 rows
40 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "sensor_status_1_active_0_inactive" BIGINT  -- Sensor Status (1=Active 0=Inactive),
  "wind_direction_text" VARCHAR,
  "precipitation_type" VARCHAR,
  "precipitation_intensity" VARCHAR,
  "rwis_rpu_id" BIGINT,
  "plss_township" VARCHAR,
  "plss_section" DOUBLE,
  "plss_range" VARCHAR,
  "rwis_site_number" BIGINT,
  "rwis_name" VARCHAR,
  "nws_id" VARCHAR,
  "latitude_ll84" DOUBLE  -- Latitude (LL84),
  "longitude_ll84" DOUBLE  -- Longitude (LL84),
  "altitude" DOUBLE,
  "county_name" VARCHAR,
  "route_name" VARCHAR,
  "mile_post" DOUBLE,
  "garage_name" VARCHAR,
  "county_number" BIGINT,
  "data_last_pulled_from_rwis_sensor_utc" VARCHAR  -- Data Last Pulled From RWIS Sensor (UTC),
  "rest_service_data_last_update_utc" VARCHAR  -- REST Service Data Last Update (UTC),
  "cost_center" DOUBLE,
  "dot_district" BIGINT,
  "air_temperature_f" DOUBLE  -- Air Temperature (F),
  "relative_humidity" DOUBLE  -- Relative Humidity (%),
  "dew_point_f" DOUBLE  -- Dew Point (F),
  "visibility_miles" DOUBLE  -- Visibility (Miles),
  "average_windspeed_mph" BIGINT  -- Average Windspeed (MPH),
  "max_windspeed_mph" BIGINT  -- Max Windspeed (MPH),
  "average_windspeed_knots" DOUBLE  -- Average Windspeed (Knots),
  "max_windspeed_knots" DOUBLE  -- Max Windspeed (Knots),
  "wind_direction_degrees" BIGINT,
  "precipitation_rate_inch_per_hour" DOUBLE  -- Precipitation Rate (Inch Per Hour),
  "precipitation_accumulation_inches" DOUBLE  -- Precipitation Accumulation (Inches),
  "sensor_id" VARCHAR,
  "utc_offset" VARCHAR,
  "rams_route_measure" DOUBLE,
  "rams_route_id" VARCHAR
);