The Collision Data Analysis Tool (CDAT) is a free FileMaker Pro application developed by WSDOT Local Programs. It runs on any computer with Windows 7, Vista, Windows XP, and Windows 2000. It is not necessary to have Filemaker Pro. Local agencies can use it to analyze traffic collision data obtained from WSDOT's Transportation Data & GIS division. Follow these steps to download, set up, and use CDAT.
WSDOT Local Programs is currently evaluating how CDAT can be updated to:
• Perform better data queries
• Make better reports
• Produce collision diagrams
• Generate a file that would allow data to be read by a GIS program. This file could be generated by an agency if their data contains GPS coordinates.
If you have specific feedback about CDAT or would like us to make changes to it, please contact our Traffic Services Manager.
Step 1. Download the CDAT program onto your computer.
For Windows 7, Vista, XP and 2000:
Self Extracting Zip File (exe 27 mb) - Recommended. Click on the link. Then click on "run". This creates a folder C:\CDAT. Click on "unzip".
WinZip File (zip 27 mb). Requires WinZip application. Click on the link. Then click on "open". Choose "select all" from the "Actions" pull-down menu. Click on the "Extract" icon. Select a location on your computer where you want to extract the data.
Step 3. Run CDAT
Run the CDAT by double-clicking the CDAT.exe file in the C:\CDAT directory. Import your Collision Data from the WSDOT ftp site.
Step 4. Analyze Collision Data
Analyze your collision data and use it to identify and prioritize issues and projects. The Traffic Services Manager can provide assistance.
Please contact our Traffic Services Manager for general questions or to provide feedback about CDAT. Contact our IT Systems Specialist if you encounter problems installing or running CDAT.