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 London boroughs. Show all posts
Showing posts with label London boroughs. Show all posts

Wednesday, 25 January 2017

Simple-text list of London boroughs - plain text, alphabetised

Blank map of London boroughs. Wikipedia has more.


Updated 18 January 2021, adding extra files

I find I need this so often and keep having to process a list from Wikipedia or elsewhere that I've finally decided to add it here for copying and pasting. Each time I do this, and search for a list, I stupidly believe that I'll come across a list I think I saw once - but I never do. So here it is.

1. The Plain Text alphabetic version will parse downwards into one column in an Excel spreadsheet if you copy / paste it in.
2. The second version is numbered alphabetically. There are 32 London boroughs and City of London is a separate thing so 33 in total.
3. The third version is bullet points

Help yourself :)

A bonus file - a tab-separated version (.tab) which will parse the boroughs across 33 column headings (you never know when you'll need that!). It can be opened directly into an Excel sheet or can be opened as a text / notepad file and then the contents copied and pasted into Excel.

Other useful bits at the end.

1. Plain Text version (or download and save this .txt file)
Barking and Dagenham
Barnet
Bexley
Brent
Bromley
Camden
City of London
Croydon
Ealing
Enfield
Greenwich
Hackney
Hammersmith and Fulham
Haringey
Harrow
Havering
Hillingdon
Hounslow
Islington
Kensington and Chelsea
Kingston upon Thames
Lambeth
Lewisham
Merton
Newham
Redbridge
Richmond upon Thames
Southwark
Sutton
Tower Hamlets
Waltham Forest
Wandsworth
Westminster

2. Numbered alphabetically

  1. Barking and Dagenham
  2. Barnet
  3. Bexley
  4. Brent
  5. Bromley
  6. Camden
  7. City of London
  8. Croydon
  9. Ealing
  10. Enfield
  11. Greenwich
  12. Hackney
  13. Hammersmith and Fulham
  14. Haringey
  15. Harrow
  16. Havering
  17. Hillingdon
  18. Hounslow
  19. Islington
  20. Kensington and Chelsea
  21. Kingston upon Thames
  22. Lambeth
  23. Lewisham
  24. Merton
  25. Newham
  26. Redbridge
  27. Richmond upon Thames
  28. Southwark
  29. Sutton
  30. Tower Hamlets
  31. Waltham Forest
  32. Wandsworth
  33. Westminster
Note that Wikipedia has a numbered map of the London boroughs but orders them non-alphabetically (from the centre outwards) so be aware :) 
3. Bullet point version
  • Barking and Dagenham
  • Barnet
  • Bexley
  • Brent
  • Bromley
  • Camden
  • City of London
  • Croydon
  • Ealing
  • Enfield
  • Greenwich
  • Hackney
  • Hammersmith and Fulham
  • Haringey
  • Harrow
  • Havering
  • Hillingdon
  • Hounslow
  • Islington
  • Kensington and Chelsea
  • Kingston upon Thames
  • Lambeth
  • Lewisham
  • Merton
  • Newham
  • Redbridge
  • Richmond upon Thames
  • Southwark
  • Sutton
  • Tower Hamlets
  • Waltham Forest
  • Wandsworth
  • Westminster
Other useful bits
London borough mapping tool (eg if you've got 4 things in Lewisham and 10 in Sutton and want to map this with a colour-graded heatmap etc) - https://data.london.gov.uk/dataset/excel-mapping-template-for-london-boroughs-and-wards

London schools atlas: https://maps.london.gov.uk/schools/




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