Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

I have a lot of small towns (<15.000 population) from Germany in my data set, so Tableau (Desktop 10.3 Pro Version) has no geographical coordinates for them.

For this reason, I made a .csv file (CustomGeo.csv is attached) with the following rows: Country (Name), State/Province, City, Latitude, Longitude. Also, I created a schema.ini with the following content:

[CustomGeo.csv]

ColNameHeader=True

DecimalSymbol=,

Format=Delimited(;)

Col1="Country (Name)" Text

Col2="State/Province" Text

Col3="City" Text

Col4="Latitude" Double

Col5="Longitude" Double

Now, after I imported the CSV file into Tableau (Map -> Geocoding -> Import Custom Geocoding), I have more than 600 ambiguous cities and I don't understand why. There are big cities like Stuttgart and München which are tagged as ambiguous. Bigger cities in Germany can have more than one Postcode (PLZ).

The possibility to select the field State/Province under Edit Locations and State/Province does not change anything.

Here you can download the CSV file and my data set with for geocoding important columns [hosted on google drive]: 

Custom Geocoding csv

Data set

Be careful if you want to open the CSV file with Excel. Excel could change the column format so the latitude and longitude data could be fucked up :)

I hope anyone can help me with that problem. I do not know how to continue.

1 Answer

0 votes
by (47.2k points)

  • You will need to extend an existing role If you use the column names (Country (Name), State/Province, City, Latitude, Longitude) 

  • Tableau has geo data for bigger cities (>15000 population).  You will have the bigger cities as well in your custom geocoding file, if you extend the existing role with all cities in Germany. Due to this, the error with ambiguous cities will show up and bigger cities like München (Munich) or Stuttgart can not be displayed on the map.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Sep 21, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Dec 10, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Apr 9, 2020 in BI by Anup (1.6k points)

Browse Categories

...