UVA Transportation Training Academy
← Back to List of Workshops

Safe Roads – Crash Data Analysis and Countermeasure Implementation

When

March 27, 2025

Time

7:45am - 4:00pm EST

Contact Hours

8

Location Online - Course

This hybrid online class will combine both live instruction and independent online work that you will complete during the day.  Independent work will include quizzes, readings, videos and short assignments.  Access to a computer with a webcam (either a camera that is built into your laptop or one that connects via USB), a reliable internet connection and a workspace that is free from distraction and noise will set you up for success.

Description

Attendees will learn how to access and use mapping resources to identify High Crash Locations in their locality or Planning District Commission (PDC) / Metropolitan Planning Organization (MPO) / Transportation Planning Organization (TPO) region. The course teaches methods to capture data in Microsoft excel from VDOT’s Crash Tool using filters for crash severity and road departure crash types. Steps to manipulate data and import crash attributes into Google maps closes out the day. The end product for a Virginia county case study demonstrates the value of this process for capital project and regional transportation planning purposes.

Agenda

Module 1: Getting Crash Data for Your Locality

  1. Mapping Resources for Virginia’s Crashes
  2. VDOT Crash Tool
  3. End Products / Case Study Example

Module 2: Getting Crash Data for Your Locality

  1. Steps to Download Crash Data
  2. Let’s Talk about Crash Severities
  3. VDOT Crash Tool Filters for Road Departure Crash Types

Module 3: Manipulating Downloaded Data for Importing into Google Maps

  1. Convert Downloaded Comma Separated Value (CSV) File to an Excel File
  2. Isolate road and lane departure crashes for our locality or region
  3. Map crash site locations by Latitude and Longitude into google maps (Geolocate)

Module 4: Importing Crash Data into Google Maps

  1. Google CREATE MAP Steps
  2. Style Attributes: Crash Severity
  3. Street View, My Maps View, Attribute Interpretation

Instructor

Walter C. Catlett

Walt Catlett possesses over 25 years of experience in urban drainage and stormwater management, combined with over 30 years of safety experience from the concrete pipe industry, military, and consulting engineering.  He is an effective trainer and educator responsible for the training of military personnel and public works professionals.  He serves on Virginia’s Local Transportation Assistance Program (LTAP) Advisory Board. He also serves on the Arkansas Department of Transportation’s Research Advisory Council. He has a B.S. in Civil Engineering from Texas A&M University in College Station, TX and a Master of Strategic Studies from the U.S. Army War College in Carlisle Barracks, PA.  Mr. Catlett served in the United States Marine Corps and United States Army Reserves for a combined 30 years.

Who Should Attend

This workshop should be of interest to those in a variety of fields including engineers and project managers, transportation and land use planners, law enforcement, agency directors, safety data collectors, managers, and analysts.

Registration and Payment

The following registration fees cover the session, all course materials and meals:

Local Government: $30.00
State/Federal: $30.00
Private Industry: $30.00

Click here for UVA TTA's general registration information, cancellation policy, and refund policy. UVA TTA accepts the following credit cards: American Express, VISA, MasterCard, and Discover. Credit card information cannot be taken over the phone. Alternatively, after registering you can print out a voucher to send in with your payment. After you have completed the transaction you will receive an automatically generated email confirming registration and payment if applicable. Final confirmation and instructions will be sent out during the week prior to the class date.