Vision Zero Benchmarking by US Government | Demographics and Population Studies

About this Dataset

Vision Zero Benchmarking

A. SUMMARY This dataset contains the underlying data for the Vision Zero Benchmarking website. Vision Zero is the collaborative, citywide effort to end traffic fatalities in San Francisco. The goal of this benchmarking effort is to provide context to San Francisco’s work and progress on key Vision Zero metrics alongside its peers. The Controller's Office City Performance team collaborated with the San Francisco Municipal Transportation Agency, the San Francisco Department of Public Health, the San Francisco Police Department, and other stakeholders on this project. B. HOW THE DATASET IS CREATED The Vision Zero Benchmarking website has seven major metrics. The City Performance team collected the data for each metric separately, cleaned it, and visualized it on the website. This dataset has all seven metrics and some additional underlying data. The majority of the data is available through public sources, but a few data points came from the peer cities themselves. C. UPDATE PROCESS This dataset is for historical purposes only and will not be updated. To explore more recent data, visit the source website for the relevant metrics. D. HOW TO USE THIS DATASET This dataset contains all of the Vision Zero Benchmarking metrics. Filter for the metric of interest, then explore the data. Where applicable, datasets already include a total. For example, under the Fatalities metric, the "Total Fatalities" category within the metric shows the total fatalities in that city. Any calculations should be reviewed to not double-count data with this total. E. RELATED DATASETS N/A
Organization: City of San Francisco
Last updated: 2025-03-29T16:45:39.823560

Tables

Table 1

@usgov.city_of_san_francisco_vision_zero_benchmarking.table_1

37.23 KB
3547 rows
10 columns


CREATE TABLE table_1 (
  "metric" VARCHAR,
  "city" VARCHAR,
  "year" BIGINT,
  "category_within_metric" VARCHAR,
  "value_total" DOUBLE,
  "value_percent" DOUBLE,
  "value_per_100_000_residents" DOUBLE,
  "source" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);