1 / 18

Automating Crash Data Analysis for Local Communities

Learn how automation in ArcMap improved crash data analysis for city safety reporting, identifying patterns for better safety measures in local communities. Project utilized LBRS data and crash databases to streamline processes and reporting.

cricardo
Download Presentation

Automating Crash Data Analysis for Local Communities

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automating Crash Data Analysis for Local Communities Kevin Miller, PE, PTOE Principal LJB Inc. Hyatt Regency Columbus 2016 Ohio GIS Conference September 28 – 30, 2016 Columbus, Ohio

  2. Agenda Project Background Project Approach Automation within ArcMap Project Results

  3. Project Background • Purpose: update City of Dublin crash mapping system • Change from location-based centerline system to current LBRS system • Replicate existing automation (MS Access) in ArcMap and improve process

  4. Project Background • Use existing LBRS data + 3 years of crash data • Create crash database • Crashes geolocated • Create customized ArcGIS toolbar • Develop automation tools • Process crash data • Reports • Analyze patterns

  5. Geolocate from Crash Report

  6. Geolocate from Crash Report Created customized intersection fields for LBRS nodes Assigned to intersection and used distances to place along routes created from LBRS

  7. Geolocate from Crash Report

  8. Import Excel Files into GIS

  9. Manually Place by Intersection

  10. Manually Place by Intersection

  11. Create Temporary Route Events

  12. Customized Data Review

  13. Customized Data Review

  14. Create/Modify Log Points

  15. Finalize and Commit Data

  16. Next Steps – Reporting

  17. Project Results Conversion to LBRS routes Easier to automate/analyze crash data Improved safety reporting Better identification of crash patterns within the city

  18. Automating Crash Data Analysis for Local Communities Kevin Miller, PE, PTOE (937) 623-6737 kmiller@ljbinc.com Hyatt Regency Columbus 2016 Ohio GIS Conference September 28 – 30, 2016 Columbus, Ohio

More Related