About this Dataset

Trash And Recycling Collection Points

The DPW Point of Collection datasets provide comprehensive information essential for managing waste and recycling services. These datasets include detailed geographic locations of trash and recycling collection points, such as street and alley collection sites, as well as the specific routes and scheduled collection days. By offering a digital map representation, the data allows the Department of Public Works to visualize and analyze the distribution of waste management resources. This enables efficient planning and coordination of collection activities, ensuring that waste is picked up in a timely, organized manner while optimizing operational effectiveness.
Organization: District of Columbia
Last updated: 2024-09-17T20:45:16.612854
Tags: dc, district-of-columbia, dpw, point-of-collection, recycling, trash, washington-dc

Tables

Table 1

@usgov.district_of_columbia_trash_and_recycling_collection_points.table_1

10.69 MB
105,894 rows
16 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "service_location" VARCHAR,
  "address" VARCHAR,
  "zipcode" BIGINT,
  "trash_route" VARCHAR,
  "recycling_route" VARCHAR,
  "day" VARCHAR,
  "ward" VARCHAR,
  "mar_id" DOUBLE,
  "x_coord" DOUBLE,
  "y_coord" DOUBLE,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "objectid" BIGINT
);