Highway Safety
Safe Routes to School Crash Statistics...
Crash Statistics are used to support School Travel Plans that call for Safe Routes to School funding in support of safer environments for Ohio's bikers and pedestrians especially, but not limited to, school zones. ODOT Highway Safety and Ohio Public Safety work together to collect and analyze crash statistics in support of all efforts toward Every Move You Make...Keep It Safe.
Ohio School Crash Statistics Instructions
Use link to the right to Open Excel Document.
Click on arrow in Column F and choose County. This will narrow results by the county you are researching.
Click on arrow in Column G and choose City, Village or Township by name. This will further narrow the results by jurisdiction (there will be some overlap with this selection).
Click on arrow in Column C and choose School by name. This will further narrow results by school.
Select and Copy all visible fields.
Open new book in Excel.
Paste Special and select formulas to paste information (including map links) into new book (This step is crucial. If you do not paste into new book, all statewide information will be accessed during the next step).
Save the new book to your computer.
The result will be the accidents for the specific school you are researching.
The procedure may have to be repeated for multiple schools. (Note: Crashes are unique by school. If looking for all crashes in a school district, it will be likely that duplicates exist).
Remember to further narrow results to areas students actually use, or have the potential to use, to travel back and forth to school.