Appendix A: Crash Data Preparation Crash data for the five-year period of 2019-2023 was acquired from TxDOT’s CRIS data portal. Crashes used for this analysis were all reportable crashes with the city attribute equal to Fort Worth. The crash, unit, person, and primary persons table were used for this analysis. Prior to the analysis, the person and primary person tables were combined, so any statistics that refer to persons refer to this combined dataset. Severity Crash level severity is assigned based on the most severe outcome to those involved, using the KABCO scale. For example, a crash where one person had a suspected minor injury (B), and another person had a possible injury (C), the overall crash would be assigned a severity of suspected minor injury (B). Severity was determined by first examining the severity for all persons involved in each crash, using their injury severity ID. For crashes that did not have any associated persons, information from the unit table was used. For these crashes, severity was determined using the columns that listed the count of each severity (death count, serious injury count, etc.), with the assigned severity being the most severe injury level with a value > 0. Note, for any crash where all severity counts were 0, the crash was assigned not injured (O).
Mode
Each crash was identified as involving or not involving the following modes:
Pedestrian
•
Bicyclist
•
Motorcyclist
•
Motor vehicle
•
Commercial Motor Vehicle (CMV)
•
This was done using the criteria outlined in the Texas Strategic Highway Safety Plan 28 (SHSP). Motor vehicle-involved crashes weren’t explicitly outlined in the SHSP but were flagged using the same logic as other modes, using the vehicle unit description of ‘Motor Vehicle’.
28 https://www.texasshsp.com/wp-content/uploads/2022/08/2022-2027-Texas-SHSP.pdf - Appendix D
50
Made with FlippingBook - Share PDF online