Australian Local Government Areas (LGAs) now in Tableau 8.2.2

The Tableau product team continues to deliver the goods for Australian users. Another quiet feature release, this time in 8.2.2, allows us to plot LGAs out of the box both as points as well as filled maps. The trick is that the associated geographic role is “County” – hopefully the UI labels will be adjusted in a future release. Simply set your LGA field (either names or codes are recognised) to the County role and then drag and drop to render as a map.

Check out the following example of Socio-Economic Indexes for Areas (SEIFA) data plotted by LGA:

LGA

 If you just want the LGAs as a reference layer we also have (as reported in comments to my last blog post) the LGA boundaries and labels available in the map tile layer. Again it is masquerading as “US County Borders” and “US County Names”. They appear as shown:

LGA tiles

You can download the workbook (which also shows the same data by postcode/postal area) from here. I was going to upload this to Tableau Public but it seems that the LGA data isn’t working up there yet… only the postal areas.

About Alan Eldridge

Hi. I'm Alan. By day I manage the APAC sales engineering team for Snowflake Computing. By night, I'm a caped crusader. Or sleeping. Most often it's sleeping.
This entry was posted in Uncategorized. Bookmark the permalink.

6 Responses to Australian Local Government Areas (LGAs) now in Tableau 8.2.2

  1. Frances says:

    Thanks Alan. I’m trying to get the ACT to come up on my maps, but I can’t find it on mine or yours – the LGA name is “Unincorporated ACT”. It looks like none of the unincorporated areas are included – is that correct? Is there a way around this? I am trying to do a dashboard that has ACT data, so will need to continue using the custom shapefiles if so.

    • Hi Frances – thanks for the question. I noticed this when the feature was first delivered and it looks like the product team have used the original edition of the ASGS LGA specification from 2011. This is different from the current specification which was published in 2014 – most noticeably was that the “unincorporated” area were not defined and were just left as blank. I have raised a bug on this so hopefully it will get updated.

      In the meantime you can use the custom polygon approach outlined in my post here:
      https://alanattableau.wordpress.com/2014/08/03/australian-region-boundaries-in-tableau/

      The LGA boundaries in the custom polygon files are based on the 2014 specification.

      Hope this helps.

      Cheers,
      Alan

  2. I noticed that the Sunshine Coast Regional Council is not there, nor does it show up in version 9.2 with my own data set. Any idea when it will get incorporated or a workaround?

    • Hi Cameron,

      It’s working for me. I copied the list of QLD LGAs from the ABS website and pasted it into Tableau and “Sunshine Coast (R)” and “Sunshine Coast” plot successfully as a centroid and as a filled region. Perhaps your label of “Sunshine Coast Regional Council” isn’t being recognised, in which case you need to “edit locations…” to fix the unrecognised value.

      Let me know if you need further help with this.

      Cheers,
      Alan

  3. Peter Maclaurin says:

    Hi Cameron,

    I’m brand new to Tableau so I’ve a lot to learn. However I am having a problem with Mapping Flinders (S) QLD LGA as a filled (?) map. It comes up as ambiguous and asks for the Latitude and Longitude. When I enter that I just get a dot. Central Highlands is also another I had a problem with, though that one did map the LGA correctly when I entered the latitude and longitude. Using Version 10.1.1 and can’t upgrade thanks to our IT section.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s