About this Dataset

Recycling Pickup Days

Washington DC Recycling Routes digitized by tracing street centerlines that form the boundaries of the various routes. The layer includes recycling routes serviced by one collection per week. The routes delineate the areas collected by a single crew on a single day per week.
Organization: District of Columbia
Last updated: 2024-04-30T18:04:37.211574
Tags: boundary, container, recycling, route

Tables

Table 1

@usgov.district_of_columbia_recycling_pickup_days_ecf2b.table_1

39.02 kB
119 rows
37 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "ward" VARCHAR,
  "route" VARCHAR,
  "route_day" VARCHAR,
  "customer" VARCHAR,
  "objectid" BIGINT,
  "ave_time_o" DOUBLE,
  "ave_time_1" DOUBLE,
  "crewb" BIGINT,
  "crewa" BIGINT,
  "ave_loadsb" DOUBLE,
  "ave_loadsa" DOUBLE,
  "route_days" BIGINT,
  "route_da_1" BIGINT,
  "tonnesmost" DOUBLE,
  "tonnesleas" DOUBLE,
  "ave_timeo2" DOUBLE,
  "ave_load20" DOUBLE,
  "ave_tons20" DOUBLE,
  "crews_rte" DOUBLE,
  "incr_decr" BIGINT,
  "count2017" BIGINT,
  "altered" BIGINT,
  "r2018_coun" BIGINT,
  "traksterrt" VARCHAR,
  "symbology" VARCHAR,
  "route_2018" VARCHAR,
  "route_2019" VARCHAR,
  "dcgis_resrecyrteply_area" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" TIMESTAMP,
  "editor" VARCHAR,
  "edited" TIMESTAMP,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);