London Drug Map

A look into open data about crime and policing in England.
londondrugs banner
Found at https://data.police.uk/. I downloaded a date range from 2011 through 2016, ~5 years. The uncompressed filesize for all select-able policing forces was approximately 5.45 GB. A quick C# script was written to filter out only the “Drug” crime type category, and it’s long/lat degree coordinates.

The output was used to make the map below. Click map for larger size.
LondonDrugs_PoliceRaw

londonlarger

1more londonmap

The downloadable data comes in a multi-directory/multi-file structure. Below is a c# console application which was created to parse the root folder, and export the specific crime type’s coordinates throughout out all the files.
Continue reading

Chicago Police Gun Related Incident Visualizations 2008 – 2016

A look into Chicago Police Department’s gun related incident reports from January 2008 through February 2016. The data is from data.cityofchicago.org.

Stacked bar chart of monthly incidents by primary type.
Click chart image to expand
Chicago Police Department Monthly Gun Related Incident Reports
Line chart of monthly incidents by primary type.
Click chart image to expand
Chicago Police Department Monthly Gun Related Incident Reports Line Chart

Static Map
Chicago Police Department Gun Related Incident Reports Jan 2008 - Feb 2016 Heat Map

chicago-homicideschicago-race-map

Animated Map

Continue reading

Illinois to Chicago Tweet Maps

Playing around with the MapD demo. In order to show off their plotting speed capabilities, they provide a sample set of twitter geo data to view on an web based interactive world map. Time range of tweets displayed is from Nov,1 2014 through Feb 28, 2015. I don’t know how inclusive the tweet data is, and what percentage of the total tweets this sample contains.

Here are some screenshots I took of Tweets made from Illinois to Chicago.

IL Tweetmap

Continue reading