Name: Historic Road Conditions
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Historic Road Conditions

Authoritative Iowa Winter Road Conditions beginning 2016. Records are the first instance of when the data changed. This was done to reduce the number of records to only when the attributes of the event were modified.
Organization: State of Iowa
Last updated: 2024-04-12T12:52:13.057706
Tags: operations, road, road-conditions, snow, travel, winter

Tables

Table 1

@usgov.state_of_iowa_historic_road_conditions_data.table_1

577.75 MB
304,686 rows
22 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "road_condition" VARCHAR,
  "headline" VARCHAR,
  "phrase" VARCHAR,
  "cars_segment_id" BIGINT,
  "cars_route_name" VARCHAR,
  "cars_short_name" VARCHAR,
  "cars_long_name" VARCHAR,
  "cars_district" VARCHAR,
  "cars_subarea" VARCHAR,
  "cars_segment_length_miles" DOUBLE,
  "cost_center" DOUBLE,
  "condition_not_normal_elapsed" DOUBLE,
  "condition_end_utc" VARCHAR,
  "condition_not_normal_start_utc" VARCHAR,
  "condition_elapsed" DOUBLE,
  "condition_not_normal_end_utc" VARCHAR,
  "condition_start_utc" VARCHAR,
  "maint_district" VARCHAR,
  "shape_length_2" DOUBLE  -- SHAPE, Length 2,
  "shape_length" DOUBLE  -- SHAPE, Length
);