4 Replies Latest reply on Dec 11, 2012 12:38 PM by PATRICK GELLENS

    how to make my own geocoding

    PATRICK GELLENS

      Allan,

       

      I tried to make import my geocoding but I had a error message that they didn't find Latitude and Longitude. I have attached my csv file to see what's wrong with.

      I attribut some ID to my LIGUES

      Is that what you mean when you told me to use the GIS tool?

      I am not sure.

        • 1. Re: how to make my own geocoding
          Andrew Ball

          Hi Patrick,

           

          The file is ok, but I think you need to do a find-replace on it.

          As you are in France, you have used a comma as your decimal place. However, Tableau is expecting the Geo file to be a csv (comma seperated), with periods as decimal places.

           

          You will need to do two seperate find-and-replace actions:

          1) Find-and-replace all commas "," with periods "."

          2) Find-and-replace all semi colons ";" with commas ","

           

          Once done, I would advice loading 2 or 3 rows just to make sure it works before loading the full lot, as importing can take a while.

           

          Note: I haven't changed my locale to test this, so it may respond differently

           

          Thanks,

          • 2. Re: how to make my own geocoding
            PATRICK GELLENS

            Hello Andrew,

            It seems it worked. I didn't have any error message.

            And now how I use my personnal geocoding?

            • 3. Re: how to make my own geocoding
              Andrew Ball

              Hi Patrick,

               

              You can use it in the following way:

              1. Connect to a datasource
              2. Right-click on one of the fields (e.g. PATH)
              3. Go to "Geographic Role" -> Name of custom geocoding file
              4. Select the corresponding field (e.g. PATH)

               

              If you then double click on this field, Tableau will create a map in the view. You will need to include additional fields in level of detail (e.g. LIGUE, SIGLE etc) so Tableau can identify which map point you mean

               

              Thanks,

              • 4. Re: how to make my own geocoding
                PATRICK GELLENS

                Andrew,

                I did what you explain but I would like to use filled map to display datas on LIGUES and I don't find the way.

                http://public.tableausoftware.com/static/images/es/essaifilledmap/Feuille1/1.png