Trash Pickup Days by US Government | Transportation and Logistics

About this Dataset

Trash Pickup Days

Washington DC Trash Routes digitized by tracing street centerlines that form the boundaries of the various routes. The layer includes supercan routes (one collection per week) and the conventional area (two collections per week). The routes delineate the areas collected by a single crew on a single day either once or twice (in the conventional area) per week.
Organization: District of Columbia
Last updated: 2024-04-30T18:30:27.352776
Tags: boundary, container, conventional-area, inner-city, outer-ring, route, supercan, trash

Tables

Table 1

@usgov.district_of_columbia_trash_pickup_days_c3f5c.table_1

31.95 KB
144 rows
31 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "route_number" BIGINT,
  "day" VARCHAR,
  "day_number" BIGINT,
  "route_id" VARCHAR,
  "cust_cnt" BIGINT,
  "new_test_count" BIGINT,
  "prop_count" BIGINT,
  "ave_time_o" DOUBLE,
  "ave_time_1" DOUBLE,
  "crewsb" BIGINT,
  "crewsa" BIGINT,
  "ave_loadsb" DOUBLE,
  "ave_loadsa" DOUBLE,
  "route_days" BIGINT,
  "route_da_1" BIGINT,
  "incr_decr" BIGINT,
  "incr_decr2" VARCHAR,
  "trakster_a" VARCHAR,
  "traksterrt" VARCHAR,
  "srs" VARCHAR,
  "threshold" VARCHAR,
  "route_1" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" TIMESTAMP,
  "editor" VARCHAR,
  "edited" TIMESTAMP,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);