Dataset: Smart Trash Containers

About this Dataset

Smart Trash Containers

Location of the City of Pittsburgh's Smart Trash Containers.

NOTE: This data set does not contain other public trash cans such as those in City Parks and the Central Business District.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2020-11-30T02:49:42.381255
Tags: _etl, cans, containers, trash

Tables

Smart Trash Containers

@usgov.allegheny_county_city_of_pitts_smart_trash_containers.smart_trash_containers

75.62 KB
1194 rows
17 columns


CREATE TABLE smart_trash_containers (
  "n__id" BIGINT,
  "container_id" BIGINT,
  "receptacle_model_id" BIGINT,
  "assignment_date" TIMESTAMP,
  "last_updated_date" TIMESTAMP,
  "group_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "neighborhood" VARCHAR,
  "dpw_division" DOUBLE,
  "council_district" DOUBLE,
  "ward" DOUBLE,
  "fire_zone" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);