So my project is about finding ''Road accident Hot Spots in the city and how safe are School zones. I have road accident points from 2000 to 2012 with the following fields.
crash road, crash id, crash dist, crash date, crash time, crash day of the week, speed limit, light, road wetness and case of the crash which is in coded with alphabets and numeric.
I have decided to do hotspot analysis using Optimized Hotspot analysis Tool for individual year for recent 5 years, and then for school opening and closing times. Since I am cutting down the data to certain time frame I have few incidents to work with and the hotspots end up in city centre which is not unusual. is there any way I can relate school zones to accidents? not visually though.