3 Replies Latest reply on Oct 30, 2018 6:33 AM by Michael Gillespie

    Custom Geo Coding for France

    David Branch
    David Branch Oct 30, 2018 4:45 AM

      Hi all,

      I am trying to create a filled map of France using the IRIS categorisation of the country.  This is the categorisation that aims to capture units of the country in blocks of about ~2000 residents and is defined by the French national statistics agency (https://www.insee.fr/en/metadonnees/definition/c1523)

      Despite quite a lot of hunting online, I cannot find anyone who has done this with Tableau.  Does anyone in the network know how to do this? 

      Many thanks in advance

      David

      • 80 Views
      • Tags:
        • 1. Re: Custom Geo Coding for France
          Michael Gillespie
          Michael Gillespie Moderator Oct 30, 2018 5:46 AM (in response to David Branch)

          David, let's try!

           

          What data is available from INSEE?  Can you get a spatial file (.shp or .kml or GeoJSON or...)?

           

          Tableau doesn't recognize the IRIS boundaries natively, but if we can get a spatial representation of the data we can easily use Tableau to visualize it.

           

          If we can't get our hands on an actual spatial file, how does INSEE make the boundaries available?  We may need to do some work in QGIS or ArcServe or another geospatial tool.

          • 2. Re: Custom Geo Coding for France
            David Branch
            David Branch Oct 30, 2018 6:19 AM (in response to Michael Gillespie)

            Hi Michael,

             

            Yes- I have uncovered a file on their website that allows you to draw the shapes on a filled map of France.  This is at:

             

            https://www.data.gouv.fr/fr/datasets/contour-des-iris-insee-tout-en-un/

             

            the next issue I am having is with establishing a link from this data set to another data set I have that has IRIS as the title of a column….the geospatial data set does not seem to allow you to pick up the IRIS column heading…

             

            Do you know if there is a way of making the French IRIS areas as one of the Geospatial roles in tableau?  That would seem like the perfect way of handling this….

             

            Any tips most welcome

             

            David

            • 3. Re: Custom Geo Coding for France
              Michael Gillespie
              Michael Gillespie Moderator Oct 30, 2018 6:33 AM (in response to David Branch)

              What is in that IRIS column in your secondary data set?  The name of the IRIS area?  Something else?

               

              In the data set you linked to, the Geometry field is the one you want to drop on the canvas: that will draw the boundaries of each IRIS area.  You can drop "Nom Iris" on colour and get a VERY busy map of each area.

               

              So, we don't necessarily have to make the IRIS area name a geo field...