Traffic Crashes Resulting in Injury

<strong><em>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.</em></strong>

<strong>A. SUMMARY</strong>
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 <u><a href="https://tims.berkeley.edu/help/SWITRS.php">TIMS documentation</a></u>

<strong>B. HOW THE DATASET IS CREATED</strong>
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.

<strong>C. UPDATE PROCESS</strong>
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).

<strong>D. HOW TO USE THIS DATASET</strong>
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 <u><a href="https://transbase.sfgov.org">TransBASE Dashboard</a></u>. 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.

<strong>E. RELATED DATASETS</strong>
<u><a href="https://data.sfgov.org/d/8gtc-pjc6/">Traffic Crashes Resulting in Injury: Parties Involved</a></u>
<u><a href="https://data.sfgov.org/d/nwes-mmgh">Traffic Crashes Resulting in Injury: Victims Involved</a></u>
<u><a href="https://transbase.sfgov.org">TransBASE Dashboard</a></u>
<u><a href="https://iswitrs.chp.ca.gov/Reports/jsp/index.jsp">iSWITRS</a></u>
<u><a href="https://tims.berkeley.edu/help/SWITRS.php">TIMS</a></u>

<strong><em>重定向通知：网站 https://transbase.sfgov.org/ 已停止运营。访问Transbase的用户将被重定向至本页面，在此用户可以查看、可视化和下载交通事故数据。</em></strong>

<strong>A. 摘要</strong>

本表格收录了旧金山城市内所有导致人员受伤的交通事故。截至当年死亡数据由首席法医办公室（OME）的死亡记录获得，仅包括符合旧金山零死亡愿景死亡协议（由旧金山公共卫生部（SFDPH）、旧金山警察局（SFPD）和旧金山市政交通局（SFMTA）维护）的案件。受伤交通事故数据来源于2018年至当年的SFPD临时碰撞系统，2013年至2017年来源于Crossroads Software交通事故数据库（CR），以及所有早于2013年的年度数据均由加利福尼亚州公路巡逻队（CHP）维护的州级综合交通记录系统（SWITRS）。仅包含有效地理信息的交通事故被绘制在地图上。所有可地理编码的交通事故数据均表示在由公共工程部（SFDPW）维护的简化旧金山街道中心线模型上。碰撞伤害数据按季度进行查询和汇总。复杂交叉口发生的事故，涉及多条道路的交通事故将被绘制在单个点上，而发生在高速公路上的伤亡事故将被排除。

事故、当事人和受害者表格具有关系型结构。交通事故表格包含每起事故的信息，每起事故一条记录。当事人表格包含所有参与事故的当事人的信息，每名当事人一条记录。当事人包括参与交通事故的驾驶员、行人、骑自行车者和停放车辆。受害者表格包含关于每名在碰撞中受伤的当事人的信息，包括任何乘客。受害者表格中还包含受伤严重程度。

例如，发生一起事故（事故表中的一条记录）涉及驾驶员当事人和行人当事人（当事人表中两条记录）。只有行人受伤，因此是唯一的受害者（受害者表中的一条记录）。

有关交通事故伤害数据集的更多信息，请参阅<u><a href="https://tims.berkeley.edu/help/SWITRS.php">TIMS文档</a></u>

<strong>B. 数据集创建方式</strong>

交通事故伤害数据收集自加利福尼亚州公路巡逻队的555号碰撞报告，由警察在事故发生后30天内提交。所有与SWITRS数据模式匹配的字段都会被程序提取、去标识化、地理编码并加载到TransBASE中。有关TransBASE的详细信息，请参阅以下D节。

<strong>C. 更新流程</strong>

经SFPD和SFDPH工作人员审查后，数据将在上一季度结束后的约一个月内公开（第一季度为5月，第二季度为8月，第三季度为11月，第四季度为2月）。

<strong>D. 如何使用此数据集</strong>

根据旧金山和加利福尼亚州公共记录法，本数据作为公共信息提供。SFDPH、SFMTA和SFPD不能以任何方式限制或限制其他方使用该数据或对其解释。当数据被传达、分发、复制、绘制或以其他方式使用时，用户应承认TransBASE.sfgov.org为数据来源，如适用，提供对原始数据源的引用，包括数据提取的日期，并注意相关元数据文档中指定的任何保留意见。然而，用户不应将对其数据的分析或解释归因于旧金山市政府。虽然本数据是为旧金山市政府的使用而收集和/或生产的，但它不能保证其准确性或完整性。因此，旧金山市政府，包括SFDPH、SFMTA和SFPD，不对信息的准确性或其适用性做出任何陈述，并免除任何遗漏或错误的责任。鉴于所有数据都与方法论假设和限制相关，市政府建议用户在分析、解释或传达数据之前审查与数据相关的方法论文档。

本数据集还可以在<u><a href="https://transbase.sfgov.org">TransBASE仪表板</a></u>上查询。TransBASE是由SFDPH维护的具有地理空间功能的数据库，目前包含来自多个机构和多个地理尺度的200多个空间参考变量，包括基础设施、交通、区划、人口统计和社会人口统计数据以及碰撞数据，所有这些数据都与交叉口或街道段相关联。TransBASE促进了一种以数据为驱动的理解方法，以解决与交通相关的健康问题，并基于大量不断增长的证据库，该证据库证明了交通系统设计和土地利用决策对健康的重要性。TransBASE的目的是为公众和私人改善交通系统安全、可持续性、社区健康和旧金山的公平性提供信息。

<strong>E. 相关数据集</strong>

<u><a href="https://data.sfgov.org/d/8gtc-pjc6/">导致人员受伤的交通事故：涉及当事人</a></u>

<u><a href="https://data.sfgov.org/d/nwes-mmgh">导致人员受伤的交通事故：涉及受害者</a></u>

<u><a href="https://transbase.sfgov.org">TransBASE仪表板</a></u>

<u><a href="https://iswitrs.chp.ca.gov/Reports/jsp/index.jsp">iSWITRS</a></u>

<u><a href="https://tims.berkeley.edu/help/SWITRS.php">TIMS</a></u>