San Francisco Injury Traffic Crashes: Parties Involved, 2013 to Present

Traffic crash injury data for San Francisco is collected from police reports and medical examiner records. The dataset has a relational structure with separate tables for crashes, parties, and victims, and is updated quarterly. Data from 2013 onward is sourced from systems like SWITRS and Crossroads, with only geocodable crashes mapped onto city street models.

Use Cases

• Analyze injury severity patterns based on the victim table structure mentioned in the description
• Study party types (drivers, pedestrians, bicyclists) involved in crashes based on the relational party table
• Model geographic risk factors for injuries using the geocoded crash locations
• Assess temporal trends in crash injuries using quarterly aggregated data

Strengths

• Data is sourced from authoritative systems like the California Highway Patrol's SWITRS and police reports
• Relational structure separates crash, party, and victim information for detailed analysis
• Quarterly update process with public release schedule provides regular data refreshes

Limitations

• Column-level documentation is absent; field semantics must be inferred after download
• Row count is unknown, which may limit suitability assessment
• Highway crashes are excluded, limiting the scope of analysis

Provenance

Source

City of San Francisco, combining data from SFPD, SFDPH, SFMTA, and the California Highway Patrol.

Collection Method

Extracted from police crash reports and medical examiner records, then geocoded and loaded into TransBASE.

Time Range

2013 to present, with older data from pre-2013 SWITRS records.

Freshness

Updated quarterly, with data released approximately a month after the quarter ends.

Geography

City of San Francisco, excluding highways.