About this Dataset

RoadConditions

This dataset provides winter road conditions for Illinois, Kansas, Minnesota, Missouri, Nebraska, North Dakota, South Dakota and Wisconsin. Conditions are updated every 10 minutes during the winter season (October 15 to April 15) and on an as-needed basis during the non-winter months.
Organization: State of Iowa
Last updated: 2024-04-12T12:49:13.312317
Tags: 511, illinois, kansas, minnesota, missouri, nebraska, north-dakota, operations, road-conditions, snow, south-dakota, travel, winter, wisconsin, wrc

Tables

Table 1

@usgov.state_of_iowa_roadconditions_data.table_1

17.34 MB
6,678 rows
29 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "primary_mile_marker" DOUBLE,
  "secondary_mile_marker" DOUBLE,
  "route_name" VARCHAR,
  "segment_unique_id" VARCHAR,
  "long_segment_name" VARCHAR,
  "cars_headline_phrase" VARCHAR,
  "date_report_was_last_updated" VARCHAR,
  "date_of_report_creation" VARCHAR,
  "literal_condition_description" VARCHAR,
  "data_source" VARCHAR,
  "source_link" VARCHAR,
  "date_of_data_read_in_for_processing" VARCHAR,
  "status" VARCHAR,
  "primary_latitude" DOUBLE,
  "primary_longitude" DOUBLE,
  "secondary_latitude" DOUBLE,
  "secondary_longitude" DOUBLE,
  "report_id" VARCHAR,
  "shape_length" VARCHAR  -- SHAPE, Length,
  "road_condition" DOUBLE,
  "shape_length_2" DOUBLE  -- SHAPE, Length 2,
  "editdate" VARCHAR,
  "type_of_route" DOUBLE,
  "creationdate" VARCHAR,
  "editor" VARCHAR,
  "write_date_to_agol" VARCHAR,
  "creator" VARCHAR
);