HNSE-O1-5. Integrating Crash Datasets to Facilitate Traffic Safety Analyses

Jonathan Pasternack1
Faculty Mentor: Shashi Nambisan, Ph.D.2
1Howard R. Hughes College of Engineering, Department of Civil and Environmental Engineering and Construction

Traffic crashes are of significant concern to society. Understanding key factors related to traffic crashes is critical to develop strategies to enhance road safety. Factors include attributes related to the crashes, persons and vehicles involved, and environmental conditions. These data are based on reports and records maintained by multiple agencies at the local, state, and national levels. Unfortunately, such data are not readily available in an integrated manner. The Nevada Department of Transportation (NDOT) consolidates and captures in a digital format crash reports filed by individual law enforcement officers and their agencies. NDOT’s database has separate subsets for attributes related to crashes, persons, and vehicles with a common field linking two of these three subsets. A consolidated database is required to perform the desired analyses. This presentation will summarize the steps needed to integrate the individual data subsets into one consolidated database using data obtained from NDOT for the years 2015 to 2019. It will demonstrate an automated procedure to develop the consolidated databases. Next, it will highlight the process to georeference data for individual crashes and link them to the crash attributes in a GIS environment. In addition, the presentation will touch upon challenges and issues related to integrating individual data sets and to incorporating them in a geographic information system (GIS) environment. Future work includes developing queries and conducting statistical analyses to answer hypotheses regarding similarities and differences in road safety outcomes based on spatial and temporal characteristics


Nov 15 - 19 2021


All Day
The Office of Undergraduate Research


The Office of Undergraduate Research


9 Replies to “HNSE-O1-5. Integrating Crash Datasets to Facilitate Traffic Safety Analyses”

  1. Hi Jonathan, Thank you for your information and research that you provided. It was very knowledgeable and really opened my eyes about car accidentss. To be honest I always though car accidents were human faults due to people not being proper drivers or not knowing how to drive right. It really opened my eye about car accidentws. I learned that car accidents aren’t just by people but also because of current road conditions. rebuttal on closing. I like how you were able to organize all of your information and include it with in your presentations, This could potentially save lives by helping fix really bad road conitions, have drivers aware of causuos drivers and more.
    Over all really great and informative presentations!
    Octavio Ibarra

  2. I really feel more informed about car accidents. You brought up many things that never even came to mind when thinking about what car accidents actually do. I agree with you when you say organizing car crashes would help separate what vehicles or people cause accidents.

  3. Hello Jonathan,
    After watching your presentation I feel more informed on car accidents and how to increase road safety. Using previous data from the Nevadas Department of transformation is a good idea. Organizing the crashes found would be beneficial because we can separate which vehicles or people cause more crashes. Your explanation of everything was well said and I enjoyed the aesthetic of your PowerPoint. The map image created a huge impact because it showed the audience how frequent car accidents can be. My only criticism was I couldn’t see the map or its interactions. Using the interactive properties of that map can help create more engagement and seriousness. Overall, wonderful presentation!

    1. This presentation was very well put together and was also very informative! The safety on the road is so important and I like how you outlined the crashes and kept everything easy to follow and very organized. Great work and awesome insight!

  4. Hello Jonathan,
    This was a very informative presentation, which provided great information on the issues of car accidents and methods that can be taken to increase road safety. The concept of organizing road accidents into specific categories would prove to be very beneficial as you mentioned. It will allow those who deal with these issues to properly analyze the leading causes and types of accidents that happen in the road, and the map that you included which showed the sites of accidents was very helpful, and shows where these accidents are occurring. Overall, this was very well done and gave me deeper insight to an issue that doesn’t get enough attention.

Leave a Reply

Your email address will not be published. Required fields are marked *