About this Dataset

San Francisco Speed Limit Compliance

Statistics on speeding rates and exceedance of speed limit along selected street segments throughout San Francisco. The dataset was prepared as part of the SF Indicators project and covers from 2004 through 2009. http://www.sfindicatorproject.org/indicators/view/49
Organization: City of San Francisco
Last updated: 2023-12-02T06:15:54.055198
Tags: cars, collisions, department-of-public-health, dph, environmental-health, hdmt, healthy-development-measurement-tool, motor-vehicles, phes, safety, san-francisco, sci, sfdph, sfmta, sfphes, speed-limit, sustainable-communities-index, transportation

Tables

Table 1

@usgov.city_of_san_francisco_sanfranciscospeedlimitcompliance.table_1

77.51 kB
613 rows
9 columns

CREATE TABLE table_1 (
  "cnn" BIGINT,
  "the_geom" VARCHAR,
  "speedlimit" BIGINT,
  "streetname" VARCHAR,
  "over_pct" DOUBLE,
  "o5mph_pct" DOUBLE,
  "speed_avg" DOUBLE,
  "speedo_avg" DOUBLE,
  "spd5o_avg" DOUBLE
);