Atmospheric Data by US Government | Environmental and Climate Sciences

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

42.07 KB
94 rows
40 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "sensor_status_1_active_0_inactive" BIGINT,
  "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,
  "longitude_ll84" DOUBLE,
  "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,
  "rest_service_data_last_update_utc" VARCHAR,
  "cost_center" DOUBLE,
  "dot_district" BIGINT,
  "air_temperature_f" DOUBLE,
  "relative_humidity" DOUBLE,
  "dew_point_f" DOUBLE,
  "visibility_miles" DOUBLE,
  "average_windspeed_mph" BIGINT,
  "max_windspeed_mph" BIGINT,
  "average_windspeed_knots" DOUBLE,
  "max_windspeed_knots" DOUBLE,
  "wind_direction_degrees" BIGINT,
  "precipitation_rate_inch_per_hour" DOUBLE,
  "precipitation_accumulation_inches" DOUBLE,
  "sensor_id" VARCHAR,
  "utc_offset" VARCHAR,
  "rams_route_measure" DOUBLE,
  "rams_route_id" VARCHAR
);