About this Dataset

Brighten B-Town Progress Data

This data set contains data and maps related to the status of the Brighten B-town initiative.

The “Brighten B-town” initiative is a partnership among three City departments -- Parks and Recreation, Utilities, and Public Works -- representing a methodical, internally-coordinated and geographically-targeted delivery of upkeep and maintenance services designed for greater efficiency and more visible results. Spanning services the City regularly delivers over the course of the year -- including landscaping, painting, pruning and street cleaning -- the pilot program establishes an order for simultaneous delivery of those services to specified City zones, so that each zone will receive comprehensive attention within a discrete period.
Organization: City of Bloomington
Last updated: 2023-05-20T03:55:41.318462
Tags: parks-and-recreation, public-works, utilities

Tables

Table 1

@usgov.city_of_bloomington_brighten_b_town_progress_data_814cf.table_1

45.18 kB
670 rows
33 columns

CREATE TABLE table_1 (
  "centerlineid" DOUBLE,
  "zone" DOUBLE,
  "fullname" VARCHAR,
  "xstreetback" VARCHAR,
  "xstreetahead" VARCHAR,
  "block" DOUBLE,
  "length" DOUBLE,
  "rcltag" VARCHAR,
  "all_status" VARCHAR,
  "pw_street" VARCHAR,
  "pw_fac_status" VARCHAR,
  "urban_for_parks" VARCHAR,
  "landscape_parks" VARCHAR,
  "util_status" VARCHAR,
  "completelength" DOUBLE,
  "public_works_street_curb_paint_lin_ft" DOUBLE  -- Public Works Street Curb Paint Lin Ft.,
  "public_works_facilities_lbs_of_debris_collected" DOUBLE  -- Public Works Facilities # Lbs Of Debris Collected,
  "publ_works_facilities_of_graffitti_removed" DOUBLE  -- Publ Works Facilities # Of Graffitti Removed,
  "public_works_facilities_of_signs_defaced" DOUBLE  -- Public Works Facilities # Of Signs Defaced,
  "utilities_of_hydrant_painted" DOUBLE  -- Utilities # Of Hydrant Painted,
  "utilities_inlets_cleaned" DOUBLE  -- Utilities #Inlets Cleaned,
  "utilities_amount_of_debris_removed" DOUBLE,
  "parks_mulching_of_loads" DOUBLE  -- Parks Mulching # Of Loads,
  "parks_plants_installed" DOUBLE  -- Parks # Plants Installed,
  "parks_of_invasive_plant_removals" DOUBLE  -- Parks # Of Invasive Plant Removals,
  "parks_trees_planted" DOUBLE  -- Parks # Trees Planted,
  "parks_of_tree_removals" DOUBLE  -- Parks # Of Tree Removals,
  "parks_of_prunings" DOUBLE  -- Parks # Of Prunings,
  "parks_of_tree_grates_installed" DOUBLE  -- Parks # Of Tree Grates Installed,
  "dir" VARCHAR,
  "streetname" VARCHAR,
  "suffix" VARCHAR,
  "notes" VARCHAR
);