Traffic Summary of each of WI’s 72 County Profiles

Markdown
Data Viz
Crash data summaries for each of the 72 counties. The reports include dynamic maps showing crash locations and hotspots.
Author
Affiliation

Jacci Ziebert

WisDOT

Published

May 1, 2023

Screenshot of a County Profile.

Dane County’s Traffic Safety Summary

What I learned

I learned to create a parameterized R Markdown report. I used our crash data API for the maps using the googleway package. This project was previously done using Excel and Publisher and took many months. This project fully automated the report by using “County” as the parameter.

Highlighted packages

plotly, googleway, and kableExtra