About this Dataset

Stop Signs

A. SUMMARY
Stop signs located at each intersection node.

B. METHODOLOGY
Stop sign legislation information is taken from MTAB legislation. Stop sign implementation information is taken from SSD Shops Reports and then parsed via python code. Implementation for stop signs will specify where signs are installed or removed, and the work order that the sign installation/removal was spec'd in.

C. UPDATE FREQUENCY
Updated four times a year at the end of each quarter.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:08.889971
Tags: intersections, signage, stop-signs, traffic-control

Tables

Table 1

@usgov.city_of_san_francisco_stop_signs.table_1

453.4 kB
11,016 rows
24 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "street" VARCHAR,
  "x_street" VARCHAR,
  "direction" VARCHAR,
  "st_facing" VARCHAR,
  "dist" VARCHAR,
  "cnn" DOUBLE,
  "concatenat" VARCHAR,
  "mtab_date" TIMESTAMP,
  "mtab_reso_text" VARCHAR,
  "mtab_motion" VARCHAR,
  "status" VARCHAR,
  "workorder" VARCHAR,
  "install_date" DOUBLE,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE
);