About this Dataset

Trash Can Locations

Disclaimer : This dataset is provided for informational purposes only. Trash can locations listed here may not reflect current or precise placement in the field. By using this data, you acknowledge that there may be known inaccuracies — including missing locations, outdated entries, or bins placed in slightly different positions than indicated. A. SUMMARY This dataset contains the approximate locations of City owned trash cans. The dataset also provides additional information such as trash can type, neighborhood, and supervisor district. B. HOW THE DATASET IS CREATED This dataset is an extract from Department of Public Works Asset Management System. C. UPDATE PROCESS This dataset will update as needed. D. HOW TO USE THIS DATASET This dataset provides information about the approximate locations and distribution of City-owned trash cans. Trash cans are subject to move, break, and/or be removed.
Organization: City of San Francisco
Last updated: 2025-08-23T22:58:52.290493

Tables

Table 1

@usgov.city_of_san_francisco_trash_can_locations.table_1

361.81 kB
2,818 rows
21 columns

CREATE TABLE table_1 (
  "objectcode" VARCHAR,
  "objectdescription" VARCHAR,
  "recologyid" BIGINT,
  "roadwayid" DOUBLE,
  "roadwaydescription" VARCHAR,
  "cantype" VARCHAR,
  "cancolor" VARCHAR,
  "streetcorner" VARCHAR,
  "onstreet" VARCHAR,
  "fromstreet" VARCHAR,
  "installeddate" VARCHAR,
  "removeddate" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "globalid" VARCHAR,
  "objectid" BIGINT,
  "point" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);