Regular readers (ahem) may remember I wrote a post about how to draw your own Fusion table maps freehand. I remember thinking at the time that there must be a better way of doing this. It turned out there was, thanks to Paul Bradshaw and Scraperwiki.
I followed Paul’s walkthrough with Bristol as my guinea pig until I hit a snag uploading the CSV file to the Fusion table. The Fusion table didn’t automatically draw a map using the polygon ward data contained in the CSV file.
The workaround for this problem is to head back to MapIt, hosted by MySociety. Type in a Bristol post code, locate Bristol City Council and click on “covered by or overlapping with this area”
You get a list of all the wards of Bristol. Download each one as a KML file.
Repeat this step for all 35 wards in Bristol (yes, this is tedious).
Next, open a new Fusion table and import from this computer. Upload each KML file to the Fusion table (again, slightly tedious, but at least you can see the map taking shape if you get bored).
When it’s done, you will have a perfect ward map of your town:
I hear that section of the Bristol Channel contains a lot of floating voters…
Anyway, now I have a decent ward map of Bristol the possibilities for data journalism have just significantly expanded. Here’s one I made earlier: a map of the percentage of Bristol residents on a means-tested benefit.
We can see that the affluent areas around Stoke Bishop and Clifton have fewer people on means-tested benefits than Lawrence Hill and Hartcliffe.
The original data is here.
This took about an hour to do. It’s much easier than my previous post, which you may now discard from your bookmarks!