Winter Storm Analysis - Past 48 Hours

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" BIGINT  -- Total Brine & Liquid Material (Gal),
  "total_salt_material_applied_lbs" BIGINT  -- Total Salt Material Applied (Lbs),
  "salt_used_in_brine_material_lbs" BIGINT  -- Salt Used In Brine Material (Lbs),
  "salt_used_in_liquid_material_lbs" BIGINT  -- Salt Used In Liquid Material (Lbs),
  "segment_id" BIGINT,
  "cost_center" BIGINT,
  "dot_district" BIGINT,
  "route_name" BIGINT,
  "route_direction" VARCHAR,
  "official_route_name" VARCHAR,
  "full_route_name" VARCHAR,
  "county_number" BIGINT,
  "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" BIGINT  -- Average Air Temp (F),
  "average_road_temp_f" BIGINT  -- Average Road Temp (F),
  "average_solid_material_lbs" BIGINT  -- Average Solid Material (Lbs),
  "average_liquid_material_gal" BIGINT  -- Average Liquid Material (Gal),
  "average_brine_material_gal" BIGINT  -- Average Brine Material (Gal),
  "total_solid_material_applied_lbs" BIGINT  -- Total Solid Material Applied (Lbs),
  "total_liquid_material_applied_gal" BIGINT  -- Total Liquid Material Applied (Gal),
  "total_brine_material_applied_gal" BIGINT  -- Total Brine Material Applied (Gal),
  "leftwing_plow_distance_mile" VARCHAR  -- Leftwing Plow Distance (Mile),
  "rightwing_plow_distance_mile" VARCHAR  -- Rightwing Plow Distance (Mile),
  "front_plow_distance_mile" VARCHAR  -- Front Plow Distance (Mile),
  "belly_plow_distance_mile" VARCHAR  -- Belly Plow Distance (Mile),
  "distance_traveled_mile" BIGINT  -- 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" BIGINT  -- 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" BIGINT  -- Time Spent Spreading Brine Material (Hours),
  "total_time_spent_spreading_materials_hours" DOUBLE  -- 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
);