About this Dataset

Street Sweeping Schedule

A. SUMMARY Mechanical street sweeping and street cleaning schedule managed by San Francisco Public Works. B. HOW THE DATASET IS CREATED This dataset is created by extracting all street sweeping schedule data from a Department of Public Works database, it is then geocoded to add common identifiers such as Centerline Network Number ("CNN") then published to the open data portal. C. UPDATE PROCESS This dataset will be updated on an 'as needed' basis, when sweeping schedules change. D. HOW TO USE THIS DATASET Use this dataset to understand, track, or analyze street sweeping in San Francisco.
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:06.832686
Tags: cleaning, mechanical, schedule, street-sweeping, streets, sweeping

Tables

Table 1

@usgov.city_of_san_francisco_street_sweeping_schedule.table_1

1.19 MB
37,474 rows
17 columns

CREATE TABLE table_1 (
  "cnn" BIGINT,
  "corridor" VARCHAR,
  "limits" VARCHAR,
  "cnnrightleft" VARCHAR,
  "blockside" VARCHAR,
  "fullname" VARCHAR,
  "weekday" VARCHAR,
  "fromhour" BIGINT,
  "tohour" BIGINT,
  "week1" BIGINT,
  "week2" BIGINT,
  "week3" BIGINT,
  "week4" BIGINT,
  "week5" BIGINT,
  "holidays" BIGINT,
  "blocksweepid" DOUBLE,
  "line" VARCHAR
);