This has been asked lots of times before. You may want to have a look at the following links for some answers:
Have a go at downloading Boundary-Line (tm) from OS. This will give you an ESRI shapefile which you can import into Tableau using Richard Leeke's shapetotab tool. Note, you may have to re-project the file to WGS 84 datum from British National Grid. I used "District Borough Unitary Region". You may need to group some of the polygons to achieve the country lines / or merge some of the shape files, but it does look possible. I also note that the provinces in NI aren't available.
To get symbols to show, use a dual axis and mixed mark types.
So I had a go at doing this for you.
Here it is with the default Tableau Map
And also with OSM
Dual Axis mixed mark types showing P&K and Scottish Borders using OSM
I did have to simplify the polygons to a tolerance of 0.001 (using QGIS) so Tableau wouldn't throw the out of memory problem. I tried to do the same in Kraken with unsimplified polygons and it tried hard, but it eventually coughed up at the row count.
Message was edited by: Allan Walker added Viz and workbook
UK Regions.zip 765.8 KB
It is possible to re-project the shapefile and simplify the boundaries directly using the shapetotab command, so you don't actually need to use a GIS such as QGIS.
I'm interested to know if there are scenarios where you find that doesn't work for you, Allan - I seem to remember you advocating the extra conversion steps via a GIS in the past.
I keep forgetting about --simplify! I just had QGIS open on my desktop, and used the GUI.
That's really useful, thanks. Just to build on this, is it possible to map one set of data (polygons) over another set of data (points) using different extracts? I can follow what you've done with the example above, but it's the same extract used to create the points and the polygons.
When I try the same with point and polygon files, it doesn't recognise the points as geographically referenced and I end up with this view:
Not entirely sure what's going on, and I'm not sure if I'm trying to get Tableau to do something that it can't do (at least in v7). Any suggestions or pointers would be appreciated!