Baselight

San Francisco Speed Limit Compliance

City of San Francisco

@usgov.city_of_san_francisco_sanfranciscospeedlimitcompliance

Loading...
Loading...

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
Loading...
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
);

Share link

Anyone who has the link will be able to view this.