Speed Limits Per Street Segment by US Government | Demographics and Population Studies

About this Dataset

Speed Limits Per Street Segment

A. SUMMARY ** Maximum speed limits per street segment for the City of San Francisco. Speed limits are indicated primarily for streets that have speeds greater than 25 MPH, unless the speed limit has been changed from a higher speed or a speed survey has been conducted to enforce the de facto speed limit of 25 MPH. 25 MPH is the de fact speed limit for most residential and commercial streets, and apply to streets on this map denoted by a 0 MPH label. Alleys narrower than 25 feet can have de facto speed limits of 15 MPH. B. METHODOLOGY ** Speed limit legislation information is taken from MTAB legislation and in some cases directives from engineers in the 5212 classification. Speed limit implementation information is taken from SSD Shops Reports and then parsed via python code. Implementation for speed limits will specify when signs are put in stating the new speed limits, and the work order that the sign installation was spec'd in. C. UPDATE FREQUENCY ** Updated quarterly or on an as need basis by request
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:07.627648
Tags: mph, speed, speed-limits

Tables

Table 1

@usgov.city_of_san_francisco_speed_limits_per_street_segment.table_1

1.14 MB
15729 rows
20 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cnn" BIGINT,
  "street" VARCHAR,
  "st_type" VARCHAR,
  "from_st" VARCHAR,
  "to_st" VARCHAR,
  "speedlimit" BIGINT,
  "schoolzone" VARCHAR,
  "schoolzone_limit" BIGINT,
  "mtab_date" VARCHAR,
  "mtab_motion" VARCHAR,
  "mtab_reso_text" VARCHAR,
  "status" VARCHAR,
  "workorder" VARCHAR,
  "install_date" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" VARCHAR
);