April 26, 2023
7:45 AM EST - 4:00 PM EST
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.
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.
Module 1: Getting Crash Data for Your Locality
- Mapping Resources for Virginia’s Crashes
- VDOT Crash Tool
- End Products / Case Study Example
Module 2: Getting Crash Data for Your Locality
- Steps to Download Crash Data
- Let’s Talk about Crash Severities
- VDOT Crash Tool Filters for Road Departure Crash Types
Module 3: Manipulating Downloaded Data for Importing into Google Maps
- Convert Downloaded Comma Separated Value (CSV) File to an Excel File
- Isolate road and lane departure crashes for our locality or region
- Map crash site locations by Latitude and Longitude into google maps (Geolocate)
Module 4: Importing Crash Data into Google Maps
- Google CREATE MAP Steps
- Style Attributes: Crash Severity
- Street View, My Maps View, Attribute Interpretation
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: $75.00
Private Industry: $300.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.Don't have access to a computer? to get a paper registration form (PDF). Print it out, complete it, and email, mail or FAX it to our office following the instructions on the form. Include your check or government purchase order with your registration form. Please note that emailed or faxed-in registration forms will be considered as a "provisional booking" until payment is received. For more information, call our office at (434) 982-2897, fax at (434) 982-2856 or email email@example.com
Special Registration Instructions for Employees of the Virginia Department of Transportation
VDOT employees must register through the VDOT Virtual Campus. Registration fees and related expenses for all VDOT employees will be paid from the VDOT Learning Services Center budget. Registrants should contact their District Training Coordinator or the VDOT Learning Services Center (Central Office employees) for instructions on how to seek reimbursement for travel expenses.
Due to current travel restrictions, VDOT employees are strongly encouraged to attend U. Va. TTA workshops on a day trip basis. Overnight travel requires permission from your District Administrator or Chief -- and in some cases higher levels of authority. If you require overnight lodging to attend a U. Va. TTA workshop, consult with your supervisor, District Training Coordinator, or VDOT Learning Services Center on travel approval procedures.