In 2010, Stamen Design won a Knight News Challenge grant to build out a project they called City Tracking. It's goal is to enable people to easily display data visualizations about their community. Dotspotting is one service developed from the grant funding. Dotspotting allows anyone to upload a spreadsheet of data and generate a map with embed code.
Missionlocal has been doing pseudo-crime maps for months now. An in-house graphic artist builds maps from scratch using Photoshop based on information provided by the Mission Police Department. Any developer might cringe at the thought of such a laborious process, given the rise of automated data applications. It was a no-brainer that a crime mapping service would benefit this hyperlocal news site.
Stamen, whose offices are located in the San Francisco Mission District, approached MissionLocal and offered to collaborate on building out Dotspotting. They needed a test subject to find the kinks in the system.
Here is how it works: Currently, Mission PD e-mails a weekly crime report to MissionLocal. A reporter cleans the data and enters it in a simple Excel spreadsheet. She then uploads the spreadsheet to Dotspotting's website and suddenly a crime map is born.
Stamen built the ability to create custom themes to change the look of the maps and the markers. They also provided MissionLocal with a custom legend with crime types that are most applicable to the MissionDistrict. Here is one such map where reporters realized how prevalent prostitution crimes were during a given week, based by information shown on the map:
= Violent Crimes = Property Crimes = Quality of Life Crimes = Other Crimes
There are lots of innovative ways to create crime maps these days; Google maps being one of the de facto Web services people use. But what Stamen has done is created a service that specializes in building crime maps from spreadsheet data, a format many journalists can understand a learn relatively quickly. The best part of Dotspotting is that not only is it easy to use, but it adds a layer of technical flexibility for developers who might want to extend it with their own themes and customizations.
Now, I should mention that Dotspotting is very much a beta product and MissionLocal has worked closely with the developers to get these maps out the door. They are continually improving the system and adding features on almost a daily basis.
I've integrated Dotspotting into our WordPress theme CalPress. Putting a Dotspotting map on a website is as easy as copying-and-pasting embed code, but sometimes CMSes like WordPress will strip out parts of the embed code. If you're a WordPress theme developer and you're wanting to create a simple function to make it easy to integrate Dotspotting, you can see the media handling function I wrote here (scroll to the very bottom.)