Monday, September 11, 2017

More heatmaps: other types of crime is San Francisco, 2003-2016

This is a follow-up to the earlier post about visualizing SFPD data. Now let's focus on other crime categories: vehicle theft, larceny/theft, burglary, assault.


Animated GIF is not the best way to explore patterns. Check out the original interactive charts for each type of crime below.

SFPD incident database and heatmaps: drug-related incident patterns

San Francisco Police Department provides free access to a great data source:  https://data.sfgov.org/browse?category=Public+Safety. The following couple of charts display drug-related incident distribution by year, weekday, time of day, and district.




Some observations:

  • the notorious "welfare Wednesday" effect is present in early years;
  • incident numbers drop significantly starting 2010, which may be caused by Proposition 215: Wikipedia says "It was not until March 2009 that federal officials announced that they would no longer try to thwart medical marijuana distribution/use in California".
There is a follow-up post focusing on other types of crime in SF using the same data source.

The following are the steps to create the weekday/time heatmap chart using charte.ca editor.