Good Day.
Please look at the attched file. Is there a public library where I can download the latitude & longitude for the list of countries in the attached. file.
Some do not have a province and some have wrong GIS data.
For example Afghanistan information is below. I know technically 3rd one is correct. but if I can have a mapping table from any public data set, I can use Find & Replace to fix every record
Afghanistan | ||
Afghanistan | 33 | 65 |
Afghanistan | 33.9391 | 67.71 |
Solved! Go to Solution.
Hi @chinu267
I would suggest taking a look at the Mapbox macros.
There is a free quota that you can use for search which hopefully will meet your requirements.
The macro you need is the one called "Mapbox Search".
Then you get results like this:
What's cool is there is in-built fuzzy matching just incase the Country names are mistyped.