VITAL SIGNS INDICATOR Fatalities From Crashes (EN4-6)

FULL MEASURE NAME Fatalities from crashes (traffic collisions)

LAST UPDATED May 2022

DESCRIPTION Fatalities from crashes refers to deaths as a result of injuries sustained in collisions. The California Highway Patrol includes deaths within 30 days of the collision that are a result of injuries sustained as part of this metric. This total fatalities dataset includes fatality counts for the region and counties, as well as individual collision data and metropolitan area data.

DATA SOURCE National Highway Safety Administration: Fatality Analysis Reporting System

CONTACT INFORMATION vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator) The data is reported by the California Highway Patrol (CHP) to the Statewide Integrated Traffic Records System (SWITRS), which was accessed via SafeTREC’s Transportation Injury Mapping System (TIMS). The data was tabulated using provided categories specifying injury level, individuals involved, causes of collision, and location/jurisdiction of collision (for more: http://tims.berkeley.edu/help/files/switrs_codebook.doc).

For more regarding reporting procedures and injury classification, see the California Highway Patrol Manual (https://one.nhtsa.gov/nhtsa/stateCatalog/states/ca/docs/CA_CHP555_Manual_2_2003_ch1-13.pdf).

Vital Signs: Injuries From Crashes – Bay Area Total (2022) DRAFT

VITAL SIGNS INDICATOR Injuries From Crashes (EN7-9)

FULL MEASURE NAME Serious injuries from crashes (traffic collisions)

LAST UPDATED May 2022

DESCRIPTION Injuries from crashes refers to serious but not fatal injuries sustained in a collision. The California Highway Patrol classifies a serious injury as any combination of the following: broken bones; dislocated or distorted limbs; severe lacerations; skull, spinal, chest or abdominal injuries that go beyond visible injuries; unconsciousness at or when taken from the scene; or severe burns. This injuries dataset includes serious injury counts for the region and counties, as well as individual collision data.

DATA SOURCE California Highway Patrol: Statewide Integrated Traffic Records System

CONTACT INFORMATION vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator) The data is reported by the California Highway Patrol (CHP) to the Statewide Integrated Traffic Records System (SWITRS), which was accessed via SafeTREC’s Transportation Injury Mapping System (TIMS). The data was tabulated using provided categories specifying injury level, individuals involved, causes of collision, and location/jurisdiction of collision (for more: http://tims.berkeley.edu/help/files/switrs_codebook.doc).

For more regarding reporting procedures and injury classification, see the California Highway Patrol Manual (https://one.nhtsa.gov/nhtsa/stateCatalog/states/ca/docs/CA_CHP555_Manual_2_2003_ch1-13.pdf).

Redirect Notice: The website https://transbase.sfgov.org/ is no longer in operation. Visitors to Transbase will be redirected to this page where they can view, visualize, and download Traffic Crash data.

A. SUMMARY This table contains all crashes resulting in an injury in the City of San Francisco. Fatality year-to-date crash data is obtained from the Office of the Chief Medical Examiner (OME) death records, and only includes those cases that meet the San Francisco Vision Zero Fatality Protocol maintained by the San Francisco Department of Public Health (SFDPH), San Francisco Police Department (SFPD), and San Francisco Municipal Transportation Agency (SFMTA). Injury crash data is obtained from SFPD’s Interim Collision System for 2018 through the current year-to-date, Crossroads Software Traffic Collision Database (CR) for years 2013-2017 and the Statewide Integrated Transportation Record System (SWITRS) maintained by the California Highway Patrol for all years prior to 2013. Only crashes with valid geographic information are mapped. All geocodable crash data is represented on the simplified San Francisco street centerline model maintained by the Department of Public Works (SFDPW). Collision injury data is queried and aggregated on a quarterly basis. Crashes occurring at complex intersections with multiple roadways are mapped onto a single point and injury and fatality crashes occurring on highways are excluded.

The crash, party, and victim tables have a relational structure. The traffic crashes table contains information on each crash, one record per crash. The party table contains information from all parties involved in the crashes, one record per party. Parties are individuals involved in a traffic crash including drivers, pedestrians, bicyclists, and parked vehicles. The victim table contains information about each party injured in the collision, including any passengers. Injury severity is included in the victim table.

For example, a crash occurs (1 record in the crash table) that involves a driver party and a pedestrian party (2 records in the party table). Only the pedestrian is injured and thus is the only victim (1 record in the victim table).

To learn more about the traffic injury datasets, see the TIMS documentation

B. HOW THE DATASET IS CREATED Traffic crash injury data is collected from the California Highway Patrol 555 Crash Report as submitted by the police officer within 30 days after the crash occurred. All fields that match the SWITRS data schema are programmatically extracted, de-identified, geocoded, and loaded into TransBASE. See Section D below for details regarding TransBASE.

C. UPDATE PROCESS After review by SFPD and SFDPH staff, the data is made publicly available approximately a month after the end of the previous quarter (May for Q1, August for Q2, November for Q3, and February for Q4).

D. HOW TO USE THIS DATASET This data is being provided as public information as defined under San Francisco and California public records laws. SFDPH, SFMTA, and SFPD cannot limit or restrict the use of this data or its interpretation by other parties in any way. Where the data is communicated, distributed, reproduced, mapped, or used in any other way, the user should acknowledge TransBASE.sfgov.org as the source of the data, provide a reference to the original data source where also applicable, include the date the data was pulled, and note any caveats specified in the associated metadata documentation provided. However, users should not attribute their analysis or interpretation of this data to the City of San Francisco. While the data has been collected and/or produced for the use of the City of San Francisco, it cannot guarantee its accuracy or completeness. Accordingly, the City of San Francisco, including SFDPH, SFMTA, and SFPD make no representation as to the accuracy of the information or its suitability for any purpose and disclaim any liability for omissions or errors that may be contained therein. As all data is associated with methodological assumptions and limitations, the City recommends that users review methodological documentation associated with the data prior to its analysis, interpretation, or communication.

This dataset can also be queried on the TransBASE Dashboard. TransBASE is a geospatially enabled database maintained by SFDPH that currently includes over 200 spatially referenced variables from multiple agencies and across a range of geographic scales, including infrastructure, transportation, zoning, sociodemographic, and collision data, all linked to an intersection or street segment. TransBASE facilitates a data-driven approach to understanding and addressing transportation-related health issues, informed by a large and growing evidence base regarding the importance of transportation system design and land use decisions for health. TransBASE’s purpose is to inform public and private efforts to improve transportation system safety, sustainability, community health and equity in San Francisco.

E. RELATED DATASETS Traffic Crashes Resulting in Injury: Parties Involved Traffic Crashes Resulting in Injury: Victims Involved TransBASE Dashboard iSWITRS TIMS

A. SUMMARY This table contains all parties involved in a traffic crash resulting in an injury in the City of San Francisco. Fatality year-to-date crash data is obtained from the Office of the Chief Medical Examiner (OME) death records, and only includes those cases that meet the San Francisco Vision Zero Fatality Protocol maintained by the San Francisco Department of Public Health (SFDPH), San Francisco Police Department (SFPD), and San Francisco Municipal Transportation Agency (SFMTA). Injury crash data is obtained from SFPD’s Interim Collision System for 2018 to YTD, Crossroads Software Traffic Collision Database (CR) for years 2013-2017 and the Statewide Integrated Transportation Record System (SWITRS) maintained by the California Highway Patrol for all years prior to 2013. Only crashes with valid geographic information are mapped. All geocodable crash data is represented on the simplified San Francisco street centerline model maintained by the Department of Public Works (SFDPW). Collision injury data is queried and aggregated on a quarterly basis. Crashes occurring at complex intersections with multiple roadways are mapped onto a single point and injury and fatality crashes occurring on highways are excluded.

The crash, party, and victim tables have a relational structure. The traffic crashes table contains information on each crash, one record per crash. The party table contains information from all parties involved in the crashes, one record per party. Parties are individuals involved in a traffic crash including drivers, pedestrians, bicyclists, and parked vehicles. The victim table contains information about each party injured in the collision, including any passengers. Injury severity is included in the victim table.

For example, a crash occurs (1 record in the crash table) that involves a driver party and a pedestrian party (2 records in the party table). Only the pedestrian is injured and thus is the only victim (1 record in the victim table).

B. HOW THE DATASET IS CREATED Traffic crash injury data is collected from the California Highway Patrol 555 Crash Report as submitted by the police officer within 30 days after the crash occurred. All fields that match the SWITRS data schema are programmatically extracted, de-identified, geocoded, and loaded into TransBASE. See Section D below for details regarding TransBASE.

C. UPDATE PROCESS After review by SFPD and SFDPH staff, the data is made publicly available approximately a month after the end of the previous quarter (May for Q1, August for Q2, November for Q3, and February for Q4).

D. HOW TO USE THIS DATASET This data is being provided as public information as defined under San Francisco and California public records laws. SFDPH, SFMTA, and SFPD cannot limit or restrict the use of this data or its interpretation by other parties in any way. Where the data is communicated, distributed, reproduced, mapped, or used in any other way, the user should acknowledge TransBASE.sfgov.org as the source of the data, provide a reference to the original data source where also applicable, include the date the data was pulled, and note any caveats specified in the associated metadata documentation provided. However, users should not attribute their analysis or interpretation of this data to the City of San Francisco. While the data has been collected and/or produced for the use of the City of San Francisco, it cannot guarantee its accuracy or completeness. Accordingly, the City of San Francisco, including SFDPH, SFMTA, and SFPD make no representation as to the accuracy of the information or its suitability for any purpose and disclaim any liability for omissions or errors that may be contained therein. As all data is associated with methodological assumptions and limitations, the City recommends that users review methodological documentation associated with the data prior to its analysis, interpretation, or communication.

This dataset can also be queried on the TransBASE Dashboard. TransBASE is a geospatially enabled database maintained by SFDPH that currently includes over 200 spatially referenced variables from multiple agencies and across a range of geographic scales, including infrastructure, transportation, zoning, sociodemographic, and collision data, all linked to an intersection or street segment. TransBASE facilitates a data-driven approach to understanding and addressing transportation-related health issues, informed by a large and growing evidence base regarding the importance of transportation system design and land use decisions for health. TransBASE’s purpose is to inform public and private efforts to improve transportation system safety, sustainability, community health and equity in San Francisco.

E. RELATED DATASETS Traffic Crashes Resulting in Injury Traffic Crashes Resulting in Injury: Victims Involved TransBASE Dashboard iSWITRS TIMS

Dataset Description: This dataset is an amended version of the UC Berkeley Transportation Injury Mapping System (TIMS) collision records from the six SCAG Counties (Imperial, Los Angeles, Orange, Riverside, San Bernardino, and Ventura) of all collisions between January 1, 2015 and December 31, 2019, downloaded from the TIMS webpage on March 23, 2022. SCAG developed this collection of collisions to determine the Regional High-Injury network. This dataset represents collisions between 2015 and 2019 located in the SCAG region that resulted in serious injury or fatality and have a clear mode type (Auto-Auto, Auto-Pedestrian, or Auto-Bicycle). Some collisions from the original dataset needed to be manually verified for location. Data development/processing methodology:SCAG prepared the collision data by filtering out collisions from the data downloaded from TIMS that did not fall into the scope of this analysis per the location, collision severity, and mode parameters. For more details on the methodology, please contact the point of contact.

Data Source: Statewide Integrated Traffic Records System (SWITRS), Transportation Injury Mapping System (TIMS),https://tims.berkeley.edu/Bicycle and pedestrian traffic collisions in Santa Clara County between 2008-2018.

SACOG Regional Transportation Collision Dataset Transportation Injury Mapping System data, includes years 2012-2022.Provisional years 2023 and2024From TIMS"We geocoded the 2023-2024 provisional SWITRS data and uploaded it into TIMS. We have started including partial year SWITRS data for the current year with a 3-month delay. Currently, TIMS includes SWITRS data up to crashes that occurred on December 31, 2024. Please email tims_info@berkeley.edu if you have any follow up questions regarding this update.Please note that the provisional data are subject to change and only contain records added to the I-SWITRS website by CHP up until March 11 2025. Therefore, they should not be directly compared to the number of crashes in previous years."

VITAL SIGNS INDICATOR Injuries From Crashes (EN7-9)

FULL MEASURE NAME Serious injuries from crashes (traffic collisions)

LAST UPDATED October 2017

DESCRIPTION Injuries from crashes refers to serious but not fatal injuries sustained in a collision. The California Highway Patrol classifies a serious injury as any combination of the following: broken bones; dislocated or distorted limbs; severe lacerations; skull, spinal, chest or abdominal injuries that go beyond visible injuries; unconsciousness at or when taken from the scene; or severe burns. This injuries dataset includes serious injury counts for the region and counties, as well as individual collision data.

DATA SOURCE California Highway Patrol: Statewide Integrated Traffic Records System

CONTACT INFORMATION vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator) The data is reported by the California Highway Patrol (CHP) to the Statewide Integrated Traffic Records System (SWITRS), which was accessed via SafeTREC’s Transportation Injury Mapping System (TIMS). The data was tabulated using provided categories specifying injury level, individuals involved, causes of collision, and location/jurisdiction of collision (for more: http://tims.berkeley.edu/help/files/switrs_codebook.doc). Fatalities were normalized over historic population data from the US Census and American Community Surveys and vehicle miles traveled (VMT) data from the Federal Highway Administration.

For more regarding reporting procedures and injury classification, see the California Highway Patrol Manual (http://www.nhtsa.gov/nhtsa/stateCatalog/states/ca/docs/CA_CHP555_Manual_2_2003_ch1-13.pdf).

A. SUMMARY This table contains all fatalities resulting from a traffic crash in the City of San Francisco. Fatality year-to-date crash data is obtained from the Office of the Chief Medical Examiner (OME) death records, and only includes those cases that meet the San Francisco Vision Zero Fatality Protocol maintained by the San Francisco Department of Public Health (SFDPH), San Francisco Police Department (SFPD), and San Francisco Municipal Transportation Agency (SFMTA). Injury crash data is obtained from SFPD’s Interim Collision System for 2018 to YTD, Crossroads Software Traffic Collision Database (CR) for years 2013-2017 and the Statewide Integrated Transportation Record System (SWITRS) maintained by the California Highway Patrol for all years prior to 2013. Only crashes with valid geographic information are mapped. All geocodable crash data is represented on the simplified San Francisco street centerline model maintained by the Department of Public Works (SFDPW). Collision injury data is queried and aggregated on a quarterly basis. Crashes occurring at complex intersections with multiple roadways are mapped onto a single point and injury and fatality crashes occurring on highways are excluded.

The fatality table contains information about each party injured or killed in the collision, including any passengers.

B. HOW THE DATASET IS CREATED Traffic crash injury data is collected from the California Highway Patrol 555 Crash Report as submitted by the police officer within 30 days after the crash occurred. All fields that match the SWITRS data schema are programmatically extracted, de-identified, geocoded, and loaded into TransBASE. See Section D below for details regarding TransBASE. This table is filtered for fatal traffic crashes.

C. UPDATE PROCESS After review by SFPD and SFDPH staff, the data is made publicly available approximately a month after the end of the previous quarter (May for Q1, August for Q2, November for Q3, and February for Q4).

D. HOW TO USE THIS DATASET This data is being provided as public information as defined under San Francisco and California public records laws. SFDPH, SFMTA, and SFPD cannot limit or restrict the use of this data or its interpretation by other parties in any way. Where the data is communicated, distributed, reproduced, mapped, or used in any other way, the user should acknowledge the Vision Zero initiative and the TransBASE database as the source of the data, provide a reference to the original data source where also applicable, include the date the data was pulled, and note any caveats specified in the associated metadata documentation provided. However, users should not attribute their analysis or interpretation of this data to the City of San Francisco. While the data has been collected and/or produced for the use of the City of San Francisco, it cannot guarantee its accuracy or completeness. Accordingly, the City of San Francisco, including SFDPH, SFMTA, and SFPD make no representation as to the accuracy of the information or its suitability for any purpose and disclaim any liability for omissions or errors that may be contained therein. As all data is associated with methodological assumptions and limitations, the City recommends that users review methodological documentation associated with the data prior to its analysis, interpretation, or communication.

TransBASE is a geospatially enabled database maintained by SFDPH that currently includes over 200 spatially referenced variables from multiple agencies and across a range of geographic scales, including infrastructure, transportation, zoning, sociodemographic, and collision data, all linked to an intersection or street segment. TransBASE facilitates a data-driven approach to understanding and addressing transportation-related health issues, informed by a large and growing evidence base regarding the importance of transportation system design and land use decisions for health. TransBASE’s purpose is to inform public and private efforts to improve transportation system safety, sustainability, community health and equity in San Francisco.

E. RELATED DATASETS Traffic Crashes Resulting in Injury Traffic Crashes Resulting in Injury: Parties Involved Traffic Crashes Resulting in Injury: Victims Involved iSWITRS TIMS

The project needs data for macroscopic statistical modeling, which are OTS rankings and historical crash data. OTS crash ranking data California Office of Traffic Safety (OTS) provides a crash ranking dataset that was developed so that individual cities could compare their city’s traffic safety statistics to those of other cities with similar-sized populations. The OTS crash rankings are based on the Empirical Bayesian Ranking Method. It adds weights to different crash statistical categories including observed crash counts, population and daily vehicle miles traveled (DVMT). In addition, the OTS crash rankings include different types of crashes with larger percentages of total victims and areas of focus for the OTS grant program. In conjunction with the research context, two types of crash rankings are focused on, namely pedestrians and bicyclists. SWITRS crash data The Transportation Injury Mapping System (TIMS) to provide the project quick, easy, and free access to California crash d..., The Safe Transportation Research and Education Center (SafeTREC) at the University of California, Berkeley, develops the Transportation Injury Mapping System (TIMS) to provide a quick, easy and free access to California crash data provided by the Statewide Integrated Traffic Records System (SWITRS). We collect five-year-long crash data, which are from 01/01/2014 to 12/31/2018. The crash data includes bicyclist and pedestrian collisions with vehicles resulting in injuries across four types of crash severity: fatal, severe injury, visible injury, and complaint of injury. The data consists of three tables including the collision dataset, the involved parties dataset, and the victims dataset. In particular, we use the collision and parties datasets that contain enough information for modeling. The rows in the crash data are built based on each case of a crash and includes information such as weather, road surface, road condition, control device, and lighting. The parties dataset includes in..., The data files can be viewed by Excel.Â