Name: Winter Storm Analysis
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Winter Storm Analysis

The dataset analyzes the time and material costs and resource use for clearing and treating roads in Iowa associated with historical winter storms. Information provided by route (route segment) and storm period.
Organization: State of Iowa
Last updated: 2024-04-12T12:51:32.425383
Tags: brine, costs, salt, winter-operations, winter-storms

Tables

Table 1

@usgov.state_of_iowa_winter_storm_analysis_data.table_1

98.36 MB
80,573 rows
82 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "total_passes_with_material" BIGINT,
  "labor_hours" DOUBLE,
  "total_cost_per_lane_mile" VARCHAR  -- Total Cost Per Lane Mile ($),
  "operations_cost_per_lane_mile" VARCHAR  -- Operations Cost Per Lane Mile ($),
  "labor_cost_per_lane_mile" VARCHAR  -- Labor Cost Per Lane Mile ($),
  "equipment_cost_per_lane_mile" VARCHAR  -- Equipment Cost Per Lane Mile ($),
  "total_material_cost_per_lane_mile" VARCHAR  -- Total Material Cost Per Lane Mile ($),
  "liquid_brine_material_cost_per_lane_mile" VARCHAR  -- Liquid & Brine Material Cost Per Lane Mile ($),
  "brine_material_cost_per_lane_mile" VARCHAR  -- Brine Material Cost Per Lane Mile ($),
  "liquid_material_cost_per_lane_mile" VARCHAR  -- Liquid Material Cost Per Lane Mile ($),
  "solid_material_cost_per_lane_mile" VARCHAR  -- Solid Material Cost Per Lane Mile ($),
  "total_liquid_brine_material_per_lane_mile_gal" VARCHAR  -- Total Liquid & Brine Material Per Lane Mile (Gal),
  "brine_material_per_lane_mile_gal" VARCHAR  -- Brine Material Per Lane Mile (Gal),
  "liquid_material_per_lane_mile_gal" VARCHAR  -- Liquid Material Per Lane Mile (Gal),
  "solid_material_per_lane_mile_lbs" VARCHAR  -- Solid Material Per Lane Mile (Lbs),
  "lane_miles_per_hour" VARCHAR,
  "total_cost_per_segment" BIGINT  -- Total Cost Per Segment ($),
  "operations_cost_per_segment" BIGINT  -- Operations Cost Per Segment ($),
  "labor_cost_per_segment" BIGINT  -- Labor Cost Per Segment ($),
  "equipment_cost_per_segment" BIGINT  -- Equipment Cost Per Segment ($),
  "total_material_cost_per_segment" BIGINT  -- Total Material Cost Per Segment ($),
  "total_liquid_brine_cost_per_segment" BIGINT  -- Total Liquid & Brine Cost Per Segment ($),
  "brine_material_cost_per_segment" BIGINT  -- Brine Material Cost Per Segment ($),
  "liquid_material_cost_per_segment" BIGINT  -- Liquid Material Cost Per Segment ($),
  "solid_material_cost_per_segment" BIGINT  -- Solid Material Cost Per Segment ($),
  "total_brine_liquid_material_gal" DOUBLE  -- Total Brine & Liquid Material (Gal),
  "total_salt_material_applied_lbs" BIGINT  -- Total Salt Material Applied (Lbs),
  "salt_used_in_brine_material_lbs" DOUBLE  -- Salt Used In Brine Material (Lbs),
  "salt_used_in_liquid_material_lbs" DOUBLE  -- Salt Used In Liquid Material (Lbs),
  "segment_id" BIGINT,
  "cost_center" DOUBLE,
  "dot_district" DOUBLE,
  "route_name" VARCHAR,
  "route_direction" VARCHAR,
  "official_route_name" VARCHAR,
  "full_route_name" VARCHAR,
  "county_number" DOUBLE,
  "segment_length_mile" DOUBLE  -- Segment Length (Mile),
  "start_reference_post" VARCHAR,
  "start_reference_post_offset" DOUBLE,
  "end_reference_post" VARCHAR,
  "end_reference_post_offset" DOUBLE,
  "number_of_passes_on_segment" BIGINT,
  "number_of_passes_solid_material_applied" BIGINT,
  "number_of_passes_liquid_material_applied" BIGINT,
  "number_of_passes_brine_material_applied" BIGINT,
  "number_of_passes_without_material_applied" BIGINT,
  "last_pass_on_segment_utc" VARCHAR  -- Last Pass On Segment (UTC),
  "number_of_avl_pings" BIGINT,
  "average_velocity_mph" DOUBLE  -- Average Velocity (MPH),
  "average_air_temp_f" DOUBLE  -- Average Air Temp (F),
  "average_road_temp_f" DOUBLE  -- Average Road Temp (F),
  "average_solid_material_lbs" DOUBLE  -- Average Solid Material (Lbs),
  "average_liquid_material_gal" DOUBLE  -- Average Liquid Material (Gal),
  "average_brine_material_gal" DOUBLE  -- Average Brine Material (Gal),
  "total_solid_material_applied_lbs" BIGINT  -- Total Solid Material Applied (Lbs),
  "total_liquid_material_applied_gal" DOUBLE  -- Total Liquid Material Applied (Gal),
  "total_brine_material_applied_gal" BIGINT  -- Total Brine Material Applied (Gal),
  "leftwing_plow_distance_mile" BIGINT  -- Leftwing Plow Distance (Mile),
  "rightwing_plow_distance_mile" BIGINT  -- Rightwing Plow Distance (Mile),
  "front_plow_distance_mile" BIGINT  -- Front Plow Distance (Mile),
  "belly_plow_distance_mile" BIGINT  -- Belly Plow Distance (Mile),
  "distance_traveled_mile" DOUBLE  -- Distance Traveled (Mile),
  "county_name" VARCHAR,
  "rest_service_last_updated" VARCHAR,
  "rest_service_last_updated_utc_offset" VARCHAR,
  "last_past_utc_offset" VARCHAR,
  "cost_symbology" BIGINT,
  "time_spent_spreading_solid_material_hours" DOUBLE  -- Time Spent Spreading Solid Material (Hours),
  "time_spent_spreading_liquid_material_hours" DOUBLE  -- Time Spent Spreading Liquid Material (Hours),
  "time_spent_spreading_brine_material_hours" DOUBLE  -- Time Spent Spreading Brine Material (Hours),
  "total_time_spent_spreading_materials_hours" BIGINT  -- Total Time Spent Spreading Materials (Hours),
  "total_time_on_segment_hours" DOUBLE  -- Total Time On Segment (Hours),
  "common_route_name" VARCHAR,
  "route_system_code" BIGINT,
  "shape_length" DOUBLE  -- Shape, Length,
  "storm_id" VARCHAR,
  "start_date_local_of_query" TIMESTAMP  -- Start Date (Local) Of Query,
  "end_date_local_of_query" TIMESTAMP  -- End Date (Local) Of Query,
  "storm_period" VARCHAR
);