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,
  "operations_cost_per_lane_mile" VARCHAR,
  "labor_cost_per_lane_mile" VARCHAR,
  "equipment_cost_per_lane_mile" VARCHAR,
  "total_material_cost_per_lane_mile" VARCHAR,
  "liquid_brine_material_cost_per_lane_mile" VARCHAR,
  "brine_material_cost_per_lane_mile" VARCHAR,
  "liquid_material_cost_per_lane_mile" VARCHAR,
  "solid_material_cost_per_lane_mile" VARCHAR,
  "total_liquid_brine_material_per_lane_mile_gal" VARCHAR,
  "brine_material_per_lane_mile_gal" VARCHAR,
  "liquid_material_per_lane_mile_gal" VARCHAR,
  "solid_material_per_lane_mile_lbs" VARCHAR,
  "lane_miles_per_hour" VARCHAR,
  "total_cost_per_segment" BIGINT,
  "operations_cost_per_segment" BIGINT,
  "labor_cost_per_segment" BIGINT,
  "equipment_cost_per_segment" BIGINT,
  "total_material_cost_per_segment" BIGINT,
  "total_liquid_brine_cost_per_segment" BIGINT,
  "brine_material_cost_per_segment" BIGINT,
  "liquid_material_cost_per_segment" BIGINT,
  "solid_material_cost_per_segment" BIGINT,
  "total_brine_liquid_material_gal" BIGINT,
  "total_salt_material_applied_lbs" BIGINT,
  "salt_used_in_brine_material_lbs" BIGINT,
  "salt_used_in_liquid_material_lbs" BIGINT,
  "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,
  "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,
  "number_of_avl_pings" BIGINT,
  "average_velocity_mph" DOUBLE,
  "average_air_temp_f" BIGINT,
  "average_road_temp_f" BIGINT,
  "average_solid_material_lbs" BIGINT,
  "average_liquid_material_gal" BIGINT,
  "average_brine_material_gal" BIGINT,
  "total_solid_material_applied_lbs" BIGINT,
  "total_liquid_material_applied_gal" BIGINT,
  "total_brine_material_applied_gal" BIGINT,
  "leftwing_plow_distance_mile" VARCHAR,
  "rightwing_plow_distance_mile" VARCHAR,
  "front_plow_distance_mile" VARCHAR,
  "belly_plow_distance_mile" VARCHAR,
  "distance_traveled_mile" BIGINT,
  "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_liquid_material_hours" DOUBLE,
  "time_spent_spreading_brine_material_hours" BIGINT,
  "total_time_spent_spreading_materials_hours" DOUBLE,
  "total_time_on_segment_hours" DOUBLE,
  "common_route_name" VARCHAR,
  "route_system_code" BIGINT,
  "shape_length" DOUBLE
);