OHS, UK - Crash Data Analysis Tool Update

Abstract OHS, Crash Data Analysis Tool Update (CDAT FY25) Kentucky State Police provides a feature-rich tool for secure public and private access to Kentucky crash data called “KYOPS”. This secure portal is sufficient for tabulation and rudimentary analysis, however advanced crash analysis can require significant data post-processing. The Transportation Cabinet monitors lane departure, cable crossover, and other specific crash types routinely. These crash types are based on complex algorithms using several crash and roadway data and they are stored as crash flags that are easy to query against but absent from the existing system. Many of these flags are based on research and new flags are being created often including analysis based on the Highway Safety Manual (HSM). A tool is needed to be able to make use of these flags for better safety analysis. The Crash Data Analysis Tool (CDAT) fills an important need for safety analysis. This tool uses a static annual snapshot of crash data for reproducible analysis that is perfect for research and safety applications. It utilizes best practices and standardizes algorithms to reduce the likelihood of errors in analysis. CDAT works like a web form, which gives far broader access to safety experts to perform better safety analysis with the most modern tools and techniques. CDAT was developed starting in 2018 and has been widely used since. The tool has over 100 users with varying degrees of access determined by KYTC. Since 2022, CDAT has been used to query over 1,600 times by 87 unique users. With such frequent use, this project proposes to develop a team of users and cabinet personnel to identify enhancements for the tool. The team can help prioritize the enhancements resulting in the most important updates getting the most attention. The goal is to identify, prioritize, and implement bug fixes, additional features, and enhancements to the CDAT tool.