The other night I decided the time was right for some new tools, so I downloaded Geoflow from Microsoft (link here). I tried the few demos found on the site, which is based on data from US, and as I’m a Dane I would like to have some local data to work with.
So I set out to find me some data from Denmark, this was a task that was harder that I imagined, but finally I managed to find a data set from the Police Department. As it would be they have a rather fine database which is open to the public (link here). The only issue in that respect is that there is no geolocation data in their dataset.
That meant that I had to manually add Latitude and Longitude to the dataset, one thing that work in my favor is that Denmark is a rather small country and therefor the police jurisdiction areas is rather low. That meant that I only had to find Latitude and Longitude for 13 police headquarters using maps.google.com, a bit tedious, but I managed.
After a little work with the data, I ended up with the following dataset.
When the data is ready, just click on the Map button in the Insert Ribbon.
Then GeoFlow will launch in another window, just as we are used to when working with i.e. PowerPivot, there the first thing at hand is to add the latitude and longitude from the dataset to the map, just point and click ;o)
When that I done, just click the button named Map It, that takes you to the following screen.
Here you have the option to add data to the map, what I did here was add Date, Politikreds (police jurisdiction) and Røveri (robbery) to the map. The result is the the screen below.
When data is mapped in GeoFlow, there you can push the play button in the lower of the screen, then data is visualized over time, and it is easy to spot differences in certain areas, at least way easier than looking at millions of rows in a spreadsheet.
My GeoFlow spreadsheet is available here, and I hope you will have as much fun playing with GeoFlow as I had the other night.
Røverier.xlsx (395.94 kb)