Like any city, San Francisco has a myriad of crimes. Now I compare reporting a crime like taking a doctor’s appointment. I tend to put going for doctor’s appointment at the bottom of my daily important works. While I am giving this analogy, it is not exactly same for crime reporting. Most of the cases victims are usually too shaken up to go and report the crime. So, I always wondered does delay in the reporting impacts the ability to solve the crime? So, when I received crime data for San Francisco for last 5 years, I thought why not see how much impact it has. Spoiler, it has quite a huge impact.

For this particular dashboard, I decided to use long form of dashboard as I wanted to show as much as information possible using charts. I also decided to use simple, true and tried form of chart; bar chart and line chart. First, chart I used was to show the change in amount of crimes in last five year.

Next, I used a heat map to show the times when crimes happen most. After that I moved to the center piece of my dashboard, which was to see the relation between reporting time and resolution time of the crime. Upon analysis, I noticed that most of the crimes that got reported within 24 hours, over 70% of them reached a resolution. But crimes like kidnapping being only exceptional.

I also noticed that in the dataset there was a column to check if the report was made online. I was surprised to see none of the cases reported online reached a resolution. Considering the impact of timely reporting a crime, one would assume that online reporting system will play a vital role. But it was the opposite in this case. Therefore, I think this is a situation of concern for San Francisco Police Department.

The Data School
Author: The Data School