1 Reply Latest reply on Jul 16, 2018 9:26 AM by Sarah Battersby

    Dual Layer Maps - overlaying polygons (and points) onto polygons

    haroon saleem

      Hi All,

       

      I have two Polygon shape files. One for region, and one for sub-region with a sql server table used to link both (i..e a region has many subregions).

       

      I would like to display a map with lines separating the different regions, and then sub-regions shown within these differentiated by colour. Please could you advise how i would do this?

       

      Please could you also advise what i would need to do if the subregions were points rather than polygons, (stored in either a shapefile or a sql server table)  and i wanted to display them as circles for each sub-region point on the region map.

        • 1. Re: Dual Layer Maps - overlaying polygons (and points) onto polygons
          Sarah Battersby

          A few potential options if your datasets are both in SQL Server - you could join your two tables in Tableau and use a dual axis map (one axis showing the regions, and one for the sub-regions).  You should be able to use the tips here (Dual Axis Mapping - Many Ways ) and look at the spatial file + spatial file section.  Starting in Tableau 2018.1, Tableau has direct support for SQL Server spatial data. 

           

          You could also union the tables together in SQL Server or with custom SQL in Tableau and then map them (no need for a dual axis map that way)

           

          If you wanted to show points instead, you can just change the mark type to Circle instead of Filled Map, and that will give you the centroid.  Alternatively, if you don't like the positioning of the centroids as calculated by Tableau, you could calculate the centroid in SQL Server and read that in as a geographic data type instead of the polygons from your table.

           

          -Sarah

          Tableau Research

          2 of 2 people found this helpful