TransBASE Dashboard

  • Create Query
  • Map
  • Graphs
  • Top Locations
  • Collisions
  • Additional Overlays
  • Metadata

Please select geographic boundary under the "Create Query" heading to run the tool.

Case IDCollision DateCollision TimeTime CategoryDay of WeekPrimary RoadSecondary RoadDistanceDirectionParty at FaultParty 1 TypeParty 1 Direction of TravelParty 1 Movement Preceeding CrashParty 2 TypeParty 2 Direction of TravelParty 2 Movement Preceeding CrashVehicle Code ViolationViolation DescriptionHighest Degree of InjuryType of CollisionMotor Vehicle Involved WithWeatherRoad SurfaceLighting
Dashboard TitleField NameOriginal AgencyData Creation DateData DescriptionData Link

Please select geographic boundary under the "Create Query" heading to run the tool.

Please select geographic boundary under the "Create Query" heading to run the tool.

LocationCount of FatalitiesCount of CollisionsCount of Victims
Google Street View
Disclaimer

This data is being provided as public information as defined under San Francisco and California public records laws. The San Francisco Department of Public Health (SFDPH), the San Francisco Municipal Transportation Agency (SFMTA), and the San Francisco Police Department (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. 

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 SFDPH, SFPD, and 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.

Please email transbasesf@gmail.com if you have any questions or issues with the site.

Report Generator
Quick Select Reports
Map
Graphs
Collision Information Table Bar Line Pie
Total Fatal Collisions
Total Injury Collisions
Highest Degree of Injury Severity in Collision
Parties Involved
Vehicle Code Violation
Motor Vehicle Involved With
Type of Collision
Intersection Related
Month
Day of the Week
Time Category
Weather
Lighting
Pedestrian Action
Control Device
Road Surface
Party Information All Parties Driver Parties Only Pedestrian Parties Only Cyclist Parties Only Parked Vehicle Parties Only Other Parties Only Table Bar Line Pie
Party Involved Gender
Party Involved Sobriety
Party Involved Drugs
Party Involved Safety Equipment 1
Party Involved Safety Equipment 2
Party Involved Insurance
Party Involved Direction of Travel
Party Involved Movement Preceding Accident
Party Involved Vehicle Type
Party Involved Race
Victim Information All Victims Driver Victims Only Pedestrian Victims Only Cyclist Victims Only Passenger Victims Only Other Victims Only Table Bar Line Pie
Victim Involved Role
Victim Involved Degree of Injury
Victim Involved Seating Position
Victim Involved Ejected
Victim Involved Safety Equipment 1
Victim Involved Safety Equipment 2
Table
Top Locations
  • Geographic Selection
  • Collision Filter
  • Party Filter
  • Victim Filter
  • Environmental Filter
  • Query Information
Select by Street Corridor
Primary Street

From Street

To Street

Mode
Select by Intersection
Primary Street

Intersection

Mode
Select by Neighborhood
Neighborhood

Mode
Select by Supervisor District
Supervisor District

Mode
Select by Police District
Police District

Mode
Select by Landmark Feature
Landmark Feature
Buffer Distance in Feet (Optional)

Mode
Select by Drawing Boundary
Drawing Tools

Mode
Select by Entire City
Mode

Filter by Collision Severity
Select Collision Severities
Filter by Code Violation
Select Violation Code
Filter by Collision Type
Select Collision Type
Filter by Collision Distance
Distance from Intersection (Feet)
Operator
Distance 1
Distance 2
Filter by Intersection Related
Select Intersection Option
Filter by Collision Date
Select Date Range
Filter by Collision Time
Select Start Time Range
Select End Time Range
Filter by Month
Select by Month in Range
Filter by Party Type
Select Party Type
Filter by Party Gender
Select Party Gender
Filter by Party At Fault
Select Party At Fault
Filter by Party Age
Select Party Age
Operator
Age 1
Age 2
Filter by Party Sobriety
Select Party Sobriety
Filter by Party Condition
Select Party Condition
Filter by Party Direction of Travel
Select Party Direction of Travel
Filter by Party Safety Equipment 1
Select Party Safety Equipment 1
Filter by Party Safety Equipment 2
Select Party Safety Equipment 2
Filter by Party Insurance
Select Party Insurance
Filter by Party Other Associated Factors
Select Party Other Associated Factors
Filter by Party Movement Preceding Collision
Select Party Movement Preceding Collision
Filter by Party Vehicle Type
Select Party Vehicle Type
Filter by Party Race
Select Party Race
Filter by Party Special Info
Select Party Special Info
Filter by Victim Role
Select Victim Role
Filter by Victim Gender
Select Victim Gender
Filter by Victim Degree of Injury
Select Victim Degree of Injury
Filter by Victim Age
Select Victim Age
Operator
Age 1
Age 2
Filter by Victim Seating Position
Select Victim Seating Position
Filter by Victim Safety Equipment
Select Victim Safety Equipment
Filter by Victim Ejected
Select Victim Ejected
Filter by Nearest Traffic Control
Select Traffic Control Devices
Filter by Intersecting Speed Limit
Select Speed Limit
Filter by Intersecting Network
Select Network
Filter by Intersecting Street Class
Select Street Class
Filter by Weather Description
Select Weather Description
Filter by Lighting Description
Select Lighting Description
  • Collision Filters
  • Party Filters
  • Victim Filters
  • Environmental Filters
Original Data Source:
2019 - SFPD ICRD;
2013-2017 - SFPD/Crossroads;
2005-2012 - SWITRS

Database Source:
TransBASESF.org

Database Pull Date:

Collision Level:
Injury Collision
Original Data Source:
2019 - SFPD ICRD;
2013-2017 - SFPD/Crossroads;
2005-2012 - SWITRS

Database Source:
TransBASESF.org

Database Pull Date:

Collision Level:
Injury Collision
Original Data Source:
2019 - SFPD ICRD;
2013-2017 - SFPD/Crossroads;
2005-2012 - SWITRS

Database Source:
TransBASESF.org

Database Pull Date:

Collision Level:
Injury Collision
Original Data Source:
2019 - SFPD ICRD;
2013-2017 - SFPD/Crossroads;
2005-2012 - SWITRS

Database Source:
TransBASESF.org

Database Pull Date:

Collision Level:
Injury Collision
Reset Query
  • Intersection Variables
  • Street Segment Variables
Intersection Infrastructure Overlays
Intersection Transportation Overlays
Intersection Community Overlays
Intersection Business Overlays
Intersection Demographic Overlays
Intersection Zoning Overlays
Street Segment Infrastructure Overlays
Street Segment Transportation Overlays