About this Dataset

Street Division Annual Statistics

The Street Division of the Public Works Department provides maintenance and repair for the City of Bloomington’s approximately 237 lane miles of streets. It is tasked with street paving and resurfacing; maintenance repairs to the City’s alley network; construction and installation of sidewalks, curbs and accessible ramps; repair and maintenance of lane markings, street signs and traffic control devices; snow removal operations; street sweeping and leaf collection. In addition, the Division works with the City’s Urban Forester to provide care and maintenance of trees in the public right of way in order to reduce accidents.

Data is included per year of Street Division operations since 2004.

Note: Public Works Department division data sets prior to 2014 are available upon request.
Organization: City of Bloomington
Last updated: 2023-05-20T03:41:40.095446

Tables

Table 1

@usgov.city_of_bloomington_street_division_annual_statistics_47b4d.table_1

33.84 kB
21 rows
37 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "number_of_employees" BIGINT,
  "number_of_division_vehicles" BIGINT,
  "annual_budget" DOUBLE,
  "number_of_snow_events" BIGINT,
  "tons_of_salt_used" BIGINT,
  "lane_miles_paved" BIGINT,
  "tons_of_asphalt" DOUBLE,
  "cost_of_asphalt" DOUBLE,
  "streets_paved_complete" DOUBLE  -- Streets Paved (Complete),
  "potholes_repaired" DOUBLE,
  "lane_miles_of_crack_seal" DOUBLE,
  "lineal_feet_of_sidewalk_repaired" BIGINT,
  "lineal_feet_of_sidewalk_repaired_via_sidewalk_repair_a_41305385" DOUBLE  -- Lineal Feet Of Sidewalk Repaired Via Sidewalk Repair Assistance Program (began In 2019),
  "lineal_feet_of_sidewalk_trip_hazards_repaired_sidewalk_dffc1ce6" DOUBLE  -- Lineal Feet Of Sidewalk Trip Hazards Repaired (sidewalk Grinding) - Program Began In 2018,
  "number_of_sidewalk_trip_hazards_saw_cut" DOUBLE,
  "number_of_ada_accessible_ramps_installed" DOUBLE,
  "lane_miles_of_sidewalks" DOUBLE,
  "lane_miles_of_side_paths" DOUBLE,
  "number_of_unsafe_trees_removed" BIGINT  -- Number Of Unsafe Trees Removed.,
  "number_of_trees_trimmed" DOUBLE,
  "number_of_leafer_loads" DOUBLE,
  "cost_of_leafing" DOUBLE,
  "gallons_of_unleaded" DOUBLE,
  "gallons_of_diesel" DOUBLE,
  "certified_lane_miles" DOUBLE,
  "number_of_signals" DOUBLE,
  "number_of_signs" DOUBLE,
  "lineal_feet_of_pavement_markings" DOUBLE,
  "number_of_school_zone_flashers" DOUBLE,
  "number_of_driver_feedbacks" DOUBLE,
  "hawk_signalized_pedestrian_crossing" DOUBLE,
  "number_of_rapid_flashing_beacon_ped_crossings" DOUBLE,
  "number_of_yield_flashing_crosswalks" DOUBLE,
  "number_of_street_lights" DOUBLE,
  "number_of_leased_street_lights" DOUBLE,
  "number_of_city_owned_and_maintained_street_lights" DOUBLE
);