Stuff that occurs to me

All of my 'how to' posts are tagged here. The most popular posts are about blocking and private accounts on Twitter, also the science communication jobs list. None of the science or medical information I might post to this blog should be taken as medical advice (I'm not medically trained).

Think of this blog as a sort of nursery for my half-baked ideas hence 'stuff that occurs to me'.

Contact: @JoBrodie Email: jo DOT brodie AT gmail DOT com

Science in London: The 2018/19 scientific society talks in London blog post

Showing posts with label mapping. Show all posts
Showing posts with label mapping. Show all posts

Tuesday, 19 July 2016

Mapping London postcodes onto London boroughs - doable with Google Fusion tables?

Everything I want to do below I can already do manually on my computer. I'm looking for a "yes it's here Jo" off-the-peg solution, but not really looking to learn how to do something new at this stage - maybe later :)

As I'm only likely to do this process once or twice a year I'm caught in that "is it worth expending ages learning something now to make this simpler?" Possibly not. 

If it looks too fiddly then I may well have to carry on with my manual process. Here's a post I wrote previously (with pics and worked examples) on how I used Google Fusion / tables to map UK cinemas, for the Sherlock special.

Is it easy to map a list of postcodes to London boroughs?
If it's fiddly and difficult then that's no good because I already have a low-res working method. It's just inefficient and non-shareable. I have an unshakeable belief that lots of people have probably wanted to do this and someone must have already come up with a solution for the non- or only mildly-technical user.

Background
I have a list of 100 London schools' postcodes (it could be 10, 50 or 2,000 as this needs to be scaleable for others to use) and I would like to display them on a map that says something like: 4 are in Harrow and 16 are in Greenwich, with a magnitude indicator of some kind. I might get it to do "if fewer than 5 show as blue", "if more than 5 show as green", "if 5-10 show as orange" etc). In fact I can do this fine on a PC with a bitmap file of a black and white line drawing of boroughs (using the fill tool on free Paint.exe, no idea what free tool works on a Mac).


Currently I can, with ease, use Google Fusion tables to convert a single column of postcodes to a geocoded map. It looks like a map with one red (the default, can be changed) dot per postcode.

But even at sensible magnification they eye does not naturally see the borough limits and I'd like to (a) add them (as an overlay?) to begin with - at a minimum it should be possible to see the borough boundaries (at least people can count the dots)
(b) see if I can get Google Fusion to combine SE1 1AA and SE1 2ZZ into "two in Borough X" - my workaround is to add a column and write in the borough, re-order and count them and then have two columns with the borough name in one and the number of times it appeared in the other ("Lewisham, 2" / "Barking and Dagenham, 1")
(c) make the raw file available (without my postcodes which are my data) to anyone else who finds themselves with a list of London postcodes and a desire to map them in this way.

Is there a pret-a-Fusion look-up table or a ready-made-London-borough-map that will work with a Google Fusion table of postcodes that I can ust add? I did look but couldn't find it, nor could I understand what I could find ;) I don't really know what KML or SHP files are.

Further reading




Thursday, 26 November 2009

Parking a comment here that I tried to add to another person's blog

This is a single-use only post :) It's the text of a blog comment I tried and failed to add to this blog http://yearsix.chorltonparkblogs.net/2009/11/25/digital-map-skills-and-our-lake-district-big-question/ but the verification system was having none of it. I've also noticed that when adding a blog post using Safari I can't create links within text...

________________________________________________________

Nice concept - I think I should have a bit of a play with this sort of thing myself.

How about a map showing where essential services (pharmacists, shops with late opening times) or advice centres are located, with telephone number, website and opening hours information incorporated. For tourism, how about photos not just of the target destination but of the roads leading in to it, a bit like a stop-motion 'this is what it will look like if you travel from X to Y'.

I'd also like something that is, by design, permanently unfinished so that it is always being updated (perhaps by people uploading geotagged data from mobile phones etc). Is there scope to add audio information ('...and on your left you'll see..') to the location points?

I've enjoyed recording and sharing, via an iPhone app, routes of favourite walks and there's also the opportunity to download others'. The app I use (Geotagging) allows you to take photos en route, keyword tag and geotag them so that they're linked to the points along the journey, and visible to others.

Another nice use of mapping is by the Amazon Conservation Team who've done something that goes by the name "Participatory ethnographic mapping: mapping indigenous lands" creating, jointly with local people, "a "risk" map that identifies areas within the mapped region that either are currently threatened or are at greatest risk of harm from external actors."

Website here http://www.amazonteam.org/index.php/193/Participatory_Ethnographic_Mapping_Mapping_Indigenous_Lands or there's a video describing the project here http://www.youtube.com/watch?v=nxBb2FOj9x4