About this Dataset

Sanitation Route Areas

This map data layer represents the daily sanitation pick up route areas for the City of Bloomington. Curbside collection of trash, recycle and yard waste is provided to residences with four units or less within the city limits. Trash and recycling pick up is provided weekly on an assigned day of the week. Yard waste collection occurs on a by-weekly schedule for part of the year.
Organization: City of Bloomington
Last updated: 2023-05-20T03:39:42.771363
Tags: gis, maps, public-works, sanitation

Tables

Table 1

@usgov.city_of_bloomington_sanitation_route_areas_f05e5.table_1

145.68 kB
93 rows
19 columns

CREATE TABLE table_1 (
  "zoneid" BIGINT,
  "service" VARCHAR,
  "pickupday" VARCHAR,
  "yardwasteweek" VARCHAR,
  "routeid" VARCHAR,
  "routecode" VARCHAR,
  "trashtruck" DOUBLE,
  "recycletruck" DOUBLE,
  "ywtruck" DOUBLE,
  "trashroutename" VARCHAR,
  "recycleroutename" VARCHAR,
  "ywroutename" VARCHAR,
  "routeday" DOUBLE,
  "frequency" VARCHAR,
  "ywfrequency" VARCHAR,
  "schedule_url" VARCHAR,
  "geometry" VARCHAR,
  "area_sq_ft" DOUBLE  -- Area (sq Ft),
  "globalid" VARCHAR
);