Iowa DOT Winter Road Conditions

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "segment_id" BIGINT,
  "route_id" BIGINT,
  "segment_name" VARCHAR,
  "route_description" VARCHAR,
  "cost_center_circles" VARCHAR,
  "cost_center_name" VARCHAR,
  "primary_milepost" DOUBLE,
  "primary_latitude" DOUBLE,
  "primary_longitude" DOUBLE,
  "secondary_milepost" DOUBLE,
  "secondary_latitude" DOUBLE,
  "secondary_longitude" DOUBLE,
  "cars_event_id" VARCHAR,
  "cars_hl_pavement_condition" VARCHAR,
  "location_link_direction" VARCHAR,
  "road_condition" VARCHAR,
  "cars_message_update_date_utc" VARCHAR  -- CARS Message Update Date (UTC),
  "cars_message_initial_date_utc" VARCHAR  -- CARS Message Initial Date (UTC),
  "cars_phrase_pavement_condition" VARCHAR,
  "dot_district" BIGINT,
  "cost_center_number" BIGINT,
  "road_condition_not_normal_start_time_utc" VARCHAR  -- Road Condition Not Normal Start Time (UTC),
  "road_condition_not_normal_end_time_utc" VARCHAR  -- Road Condition Not Normal End Time (UTC),
  "total_elapsed_time_segment_not_normal_hours" DOUBLE  -- Total Elapsed Time Segment Not Normal (Hours),
  "route_name" VARCHAR,
  "rest_service_last_updated_utc_offset" VARCHAR,
  "route_segment_index" BIGINT,
  "cars_update_message_date_utc_offset" VARCHAR,
  "cars_initial_message_date_utc_offset" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "previous_road_condition" VARCHAR,
  "road_condition_change" VARCHAR,
  "length_miles" DOUBLE  -- Length (Miles),
  "deprecated" VARCHAR,
  "road_condition_code" BIGINT,
  "previous_road_conditon_headline" VARCHAR,
  "previous_condition_ph_phrase" VARCHAR,
  "change_in_road_condition_start_time_utc" VARCHAR  -- Change In Road Condition Start Time (UTC),
  "change_in_road_condition_end_utc" VARCHAR  -- Change In Road Condition End (UTC),
  "time_road_segment_has_been_current_condition_hours" DOUBLE  -- Time Road Segment Has Been Current Condition (Hours),
  "event_update_id" VARCHAR,
  "previous_road_condition_code" BIGINT,
  "route_system_rank" BIGINT,
  "condition_change_start_utc_offset" VARCHAR,
  "condition_change_end_utc_offset" VARCHAR,
  "condition_not_normal_start_utc_offset" VARCHAR,
  "condition_not_normal_end_utc_offset" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);