Hello:
I have a list of about 1,200 addresses (including street, city, state, and zip) for which I would like to create a heat map. I understand I need to first geocode the addresses, and thought I could do that in Tableau.
I have the addresses stored as a CSV file, and have created a schema.ini file to specify the data types (see attached). However, when try to I import both the CSV and .ini files for custom geocoding, I get an error message that the CSV file could not be used because it does not contain a unique column.
Thank you!
Hello John,
You'd use a schema.ini file for custom geocoding in Tableau when you want to extend a dimension to be geographically representative of the underlying geospatial data (using an existing or provided lat/lon for example). Tableau cannot geocode anything lower than zip code as the lowest level of detail. Addresses are not available to be matched as they're not in the underlying database for the geocoding matching effort.
And, addresses would be a lower level of granularity than that of zip code. So, that work will need to be done in a different service. If the addresses are in U.S. or in Canada, you can try the following website which allows up to 2,500 addresses per day (free) to be returned and assigned a latitude/longitude. With that data then you'd bring it in automatically into Tableau ensuring the fields are properly named Latitude and Longitude and that they're decimal values. Here's the website for GeoCodio: https://www.geocod.io Best, Don
