UK Area Polygon Mapping in Tableau
Ever since Tableau introduced filled maps in version 7 we’ve repeatedly been asked about filled maps in the UK and why it’s limited to just England, Scotland, Wales and Northern Ireland.
Our understanding is there are two main reasons. First is installation size and keeping Tableau as lean as possible. I don’t know if you’ve notices but for such a small country the UK is split into many different areas. Even if you just take the first one or two letters of the postcode as a grouping method there are 124 different shapes covering the country! That compares to only 50 states to cover the whole of the United States of America and from a country that would only rank as the 12th largest state in America.
The second reason comes down to complexity. Tableau try to maintain simplicity throughout the product, the first question asked when a new function is developed is “Is it as simple as it can be?” I can imagine the poor developers working on filled maps thinking “OK we’ve covered most of the globe using the hierarchy Country – State – County – City but the UK, that doesn’t seem to fit.” If we take a look at how the hierarchy applies to the UK then it would align something like:
Level | Current Example | Potential Options |
Country | United Kingdom |
|
State | England |
|
County |
|
You can see how the alignment can become very confusing very quickly. This isn’t to say that Tableau won’t solve it some day, after all they have developers many times smarter than myself working for them.
How The Information Lab Can Help
Like many other challenges in Tableau there is always a way to achieve the visualisation you’re looking for. All you need is a method and some data. For the method we have a video taking you step by step through the process (see the bottom of this post) and as for the data we’ve done as much of the hard work as we can so you don’t have to. If you don’t see the UK boundary data you’d like then please get in contact and we’ll help you out as best as we can.
UK Boundary Polygon Data
Area | TDE v7 | TDE v8 |
Regions | Download | Download |
Counties (partial coverage) | Download | Download |
Local Authority Districts | Download | Download |
Counties, Unitary Authorities, and Local Authority Districts | Download | Download |
Counties, Unitary Authorities, and Metropolitan Counties | Download | Download |
Strategic Health Authorities | Download | Download |
Clinical Commissioning Groups | Download | Download |
Creating Polygon Area Maps in Tableau
Hi guys
This looks very useful and could be extended for us here in Switzerland. What would be really useful is to know the process that you went through to build this so we could extend it for use here!
thanks!
nathan
(and by that I mean creating the polygons and points, not what’s in the video! thanks!)
Is it possible to get Boundary Polygon Data for Ireland? Thanks
http://tableaumapping.bi/2013/11/25/ireland-counties/
Hi,
Great work.
Have you guys got any plans to do this for UK Electoral wards?
This is a great way of making custom polygon maps. Providing the data in a Tableau Data Extract is really helpful. Thanks
Thanks this is helpful, would be really interested if anyone has be able to plot points over shaded polygons in the UK? Without using a static background image.
Any luck with getting the Boundary Polygon Data for Ireland?
Nice to see some thematic maps in tableau – although there is a slight glitch. If you apply a filter and the reference polygon has no data then that area is simply removed from the map – leaving gaps. Is there anyway of layering another CCG boundary on top?
Awesome! Is there any plan/another article where this has been repeated for UK postcode boundaries? (just the outcodes – e.g., AB11 etc.) Or is that just way too much work?
Tim,
Check out tableaumapping.bi for more boundary data, but I *think* postcode boundary data is not in the public domain, you have to purchase it…
Hi Tim, did you ever find an answer to your question? I am trying to do exactly the same thing. Thanks, David
I am a newbe. Anyone can detail what you do with tde format? When I upload it, it opens automatically in Notepad and it is all that I have.
How you take advantage from that?
Thanks
Hi. You have to open it using Tableau Desktop. Download from http://www.tableausoftware.com
Hi. Is this data available at the census ward level?
Mel, check out tableaumapping.bi for more data
Hi
The dataset appears to include only English and Welsh counties. Is it possible to have Scotland and N. Ireland included (or am I missing something)?
Thanks
Hi Kathy – for more recent datasets (this one is two years old) try here: http://www.tableaumapping.bi
Note that some datasets have only E+W because the geographies are only relevant at that level.
Hi Guys,
I followed your great tutorial on UK polygon mapping.
I was wondering if its possible to have the polygon shaded in different colours depending on the measure chosen in the parameter field?
thanks!
Great job!!!
Is there any filled map for Northern Ireland?
Hi, this is very useful but the boundaries are now out of date for Northern Ireland following a reorganisation there last year reducing the number of authorities from 26 to 11. Can this extract be updated to reflect that please?
P.S. the current (legacy) NI local authorities appear to be allocated incorrectly among the NI polygons in v8.
HI There,
Thank you for your post. It’s very helpful.
Wondering if you have examples of London – LSOA level geo-mapping?
Thanks