Slow Streets by US Government | Transportation and Logistics

About this Dataset

Slow Streets

A. SUMMARY This data shows the locations of slow streets designated as part of the SFMTA response to sheltering in place and supporting essential movement throughout San Francisco. B. HOW THE DATASET IS CREATED The data was created using the city's centerline (CNN) shapefile. Using the Slow Street extents, polylines from the CNN data were queried out. Additional fields were added to give the segments various attributes related to the Slow Streets program. C. UPDATE PROCESS As-needed. D. HOW TO USE THIS DATASET This data is mainly used to show the extent of Slow Streets implemented as part of the SFMTA's Slow Streets program. Each record is a block of Slow Street.
Organization: City of San Francisco
Last updated: 2021-08-07T18:42:15.357707
Tags: biking, street, streets, transit, walking

Tables

Table 1

@usgov.city_of_san_francisco_slow_streets.table_1

34.79 KB
240 rows
23 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "shape" VARCHAR,
  "classcode" BIGINT,
  "cnn" BIGINT,
  "f_node_cnn" BIGINT,
  "f_st" VARCHAR,
  "nhood" VARCHAR,
  "oneway" VARCHAR,
  "st_type" VARCHAR,
  "streetname" VARCHAR,
  "t_st" VARCHAR,
  "zip_code" BIGINT,
  "slw_st" BIGINT,
  "length" DOUBLE,
  "extents" VARCHAR,
  "status" VARCHAR,
  "phase" DOUBLE,
  "install_date" VARCHAR,
  "agency" VARCHAR,
  "type" VARCHAR,
  "supervisor_district" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);