About this Dataset

Leaf Collection Streets

The fall leaf collection program runs from the first week of November through the second week of January. This data highlights road ways where the Department of Public Works (DPW) will collect leaves at least twice by “vacuuming” loose leaves residents rake into their treebox(es). Loose leaves will be sent for composting. In neighborhoods with alley trash/recycling collections, bagged leaves may be placed where trash and recycling are collected.
Organization: District of Columbia
Last updated: 2024-04-30T18:33:18.899017
Tags: collection, district-of-columbia, dpw, leaf, pickup, public-service, public-works, washington-dc

Tables

Table 1

@usgov.district_of_columbia_leaf_collection_streets.table_1

934.17 kB
13,891 rows
37 columns

CREATE TABLE table_1 (
  "route_num" VARCHAR,
  "pass" VARCHAR,
  "duedate1" VARCHAR,
  "duedate2" VARCHAR,
  "duedate3" VARCHAR,
  "comdate1" TIMESTAMP,
  "comdate2" TIMESTAMP,
  "comdate3" VARCHAR,
  "disdate1" VARCHAR,
  "disdate2" VARCHAR,
  "disdate3" VARCHAR,
  "pass1_star" TIMESTAMP,
  "pass1_end" TIMESTAMP,
  "pass2_star" TIMESTAMP,
  "pass2_end" TIMESTAMP,
  "username" VARCHAR,
  "comment" VARCHAR,
  "shape_stlength" DOUBLE  -- SHAPE STLENGTH,,
  "objectid" BIGINT,
  "streetsegi" DOUBLE,
  "ward" DOUBLE,
  "blockname" VARCHAR,
  "qa_streets" VARCHAR,
  "qa_streets_pass2" VARCHAR,
  "pass_real" DOUBLE,
  "supervisor_name" VARCHAR,
  "modificationdate" TIMESTAMP,
  "image_url1" VARCHAR,
  "image_url2" VARCHAR,
  "image_url3" VARCHAR,
  "image_url4" VARCHAR,
  "image_url5" VARCHAR,
  "notes" VARCHAR,
  "border_streets" VARCHAR,
  "route_num_org" VARCHAR,
  "shape_stlength_1" DOUBLE,
  "shapelen" BIGINT
);