Showing posts with label golf courses. Show all posts
Showing posts with label golf courses. Show all posts

Tuesday, 19 September 2017

Buildings of Great Britain

One of the great things about Great Britain is of course Ordnance Survey, our 225 year old national mapping agency. Since a lot of their data was made open in the last decade it has become easier than ever to explore and map the country (particularly if you're some kind of GIS boffin). I should point out before going any further that Ordnance Survey covers Great Britain only, not Northern Ireland. For that, you'll need to look at Ordnance Survey Northern Ireland, who also have a good selection of open data. In the past, I've created sets of building data for English cities, done some calculations on how much land is taken up by golf courses, and a variety of other things, including creating 3D building models using OS open data. Today I'm sharing some shapefiles of all buildings in Great Britain. 


London has lots of red buildings

Why have I done this? The main reason is that I want to share these complete files with others who might need them and don't want to - or know how to - patch together separate tiles of Ordnance Survey open data. If you need some building footprint data, you can just download the set you need and zoom to your chosen area, or extract what you need from an individual shapefile. I used the OS OpenMap - Local product for this, so the detail in the buildings is very good, as you can see below in the zoomed-in extract.

The reason I did this in the first place was because I wanted to come up with a number for the percentage of the land area of Great Britain that is covered by buildings. There has been some debate about this topic, and it was covered in an FT Fact Check piece in 2016 by Kate Allen partly in response to the claim that golf courses cover more land than housing. My calculations using new OS data revealed that Great Britain is 0.54% golf course (1,256 sq km, about the same area as Greater Manchester). But do buildings cover more than this? Yes they do. 


Click to enlarge - you can see lots of detail

Using the data I'm sharing here, I calculated that buildings in the UK cover 1.35% of the land. I reported this previously in a tweet that was quite widely shared. To my embarrassment, for the GB figure I used the UK area as the denominator so the figure reported there was a little low, though the England, Scotland and Wales figures were and are accurate. Here's the important information you need, if you're ever faced with an awkward silence at a party.

> Great Britain is 1.35% buildings

> England is 2.0% buildings
> Scotland is 0.4% buildings
> Wales is 0.9% buildings

The Great Britain figure equates to about twice the area covered by Greater London - 3,150 sq km. However, the OS OpenMap - Local product isn't the most detailed building-level data covering Great Britain. For that, you'd need to look at OS MasterMap, a much bigger job. That is, unless you are Mike Gale and Tom Armitage at Edina and you have all this information in a lightning-fast database ready to query. They very kindly went beyond the call of duty and did some calculations and confirmed that my figures are pretty much spot on. They did loads of other really cool stuff too, but more on that another time perhaps.

If you click on the link, you'll see the set of shapefiles I created in a Dropbox folder. It contains some licence information, a few sample images, plus the following shapefile sets:

  • All buildings in Wales in a single shapefile
  • All buildings in Scotland in a single shapefile
  • All buildings in the North of England in a single shapefile
  • All buildings in the Midlands in a single shapefile
  • All buildings in the South West of England in a single shapefile
  • All buildings in the South East of England in a single shapefile

The complete set, and individual files, are pretty big, since they cover large areas and have millions of individual polygon features in them. This isn't exactly the best way to view and map this data, I know. That's obviously an understatement. But I also know that it's the format many people know and love, and want to work with. So, if you want to play around with buildings or use this as background mapping, be my guest. 


Data notes
Giant shapefiles make the world go round, okay. More seriously, there are better ways to download and view this data, but that's for another blog post. On a related note, see this from Emu Analytics on a very cool project which utilises OS building data. If you download the files and look at the attribute table in your GIS of choice, you'll see that I've added an area column for each polygon showing the area in square metres. 

Using this to query the dataset can be interesting - e.g. to find the largest building. Be aware, however, that the OS OpenMap - Local data still has a degree of generalisation in it so sometimes separate buildings can be merged together - e.g. if they are very close together. But I know from what Mike and Tom did with MasterMap data that this doesn't affect the final calculation much at all, thankfully.

As for the golf courses vs. housing thing, I know that's not strictly-speaking solved definitively either. The reason for this is that we have no way of knowing exactly what area houses cover vs non-residential buildings. As far as I know, even Ordnance Survey don't know this, and probably can't know this from what data we have available to us. However, the vast majority of buildings are residential (not sure on the %) and I'm very confident that housing covers a much bigger area than golf courses, I just can't say how much.


Monday, 17 July 2017

What Percent Golf Course is Your Area?

There has been a fairly long-running debate in the UK media about the extent to which golf courses cover the landscape. I've been working on a related topic recently, so when Ordnance Survey last week released an open dataset containing golf course coverage I thought I'd have a go at answering the question myself. The answer I arrived at was that Great Britain is about 0.54% golf course - or about 1,256 square kilometres (about the same area as the whole of Greater Manchester). 

The local authority with the largest area of golf courses is Woking in Surrey, at 10.74%. I originally calculated it at just over 7% but I had to make some edits due to the number of courses that straddle the local authority boundary and weren't being included. I've done the calculation a couple of times and also manually so I'm sure it's pretty accurate.

Woking - 10% golf course


Edinburgh - about 4.2% golf course


Why am I doing this? Do I hate golf and golfers? No, not at all. I used to play golf (a fine game) and have some golf clubs in my shed so I couldn't say I'm part of any anti-golf lobby. The reason is that I like to know things like this, particularly when such figures are used to debate issues like housing and the availability of land in some parts of the country. The fact that Woking appears to be 10% golf course is not a criticism, it just appears to be a fact. But I do find these numbers interesting. Here's the top 20 by local authority - and remember that Ordnance Survey just covers Great Britain not the whole UK so there are no Northern Ireland figures here. I'm not aware of a similar dataset that would allow me to do these calculations for Northern Ireland.

Is this a lot? Well, that depends

I've also done some summary statistics for Great Britain and the different countries within it. From this, we can see that Great Britain is about 0.54% golf course, England 0.74%, Scotland 0.28% and Wales 0.34%. From my analysis of the data, this does seem to include golf driving ranges as well. I'm not sure about crazy golf - don't think that's included but it would probably be a tiny fraction of land. The same goes for 'pitch and putt' type areas


Golf courses take up about the same area as Greater Manchester


If you want to explore the data yourself, I've made it available in a Google sheet - and also added in area codes and region names. According to my calculations, only 10 local authority areas in Great Britain have no golf courses within them, as follows:

  • Tamworth
  • Adur
  • City of London
  • Camden
  • Hammersmith and Fulham
  • Islington
  • Kensington and Chelsea
  • Lambeth
  • Tower Hamlets
  • Westminster


Finally, at the suggestion of David O'Sullivan, I had a little look to see if there was a correlation between the percent of each area covered by golf courses and the percent voting for Brexit. There really isn't.

Not much of a relationship at all

Data credit: Contains Ordnance Survey data © Crown copyright and database right 2017

Data note: to deal with the issue of golf courses that straddle local authority boundaries, I cut them in two using a local authority boundary file. My original calculations didn't do this and it turns out it makes a bit of a difference in some areas, including Woking, where the courses on boundaries end up not being counted. I'm pretty confident these figures are accurate - based on the underlying data - but of course other people have calculated similar numbers in the past and arrived at different results. Some of these were based on estimates but my calculations are based on the new Ordnance Survey dataset so I'm confident they are at least close to the correct figure.