About this Dataset

Street Sweeping Routes

SDOT Street Sweeping Routes. Maintained by joined efforts with Seattle Department of Transportation and Seattle Public Utility Water Quality Program.

Feature Class: ROUTES_STREETSWEEPRO

Refresh Cycle: Weekly

Contact: Street Maintenance team
Organization: City of Seattle
Last updated: 2025-02-28T23:34:07.184162
Tags: gis, sdot, seattle-gis-open-data, street-sweeping-routes

Tables

Table 1

@usgov.city_of_seattle_street_sweeping_routes_001ed.table_1

211.62 kB
8,856 rows
15 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "routename" VARCHAR,
  "route_name" VARCHAR,
  "frequency" VARCHAR,
  "route_day" VARCHAR,
  "pay_week" VARCHAR,
  "mgmtunit" VARCHAR,
  "type" VARCHAR,
  "routenum" BIGINT,
  "program" VARCHAR,
  "edit_date" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "broom" VARCHAR,
  "routemiles" DOUBLE,
  "shape_length" DOUBLE  -- Shape, Length
);