Using GEONAMES to find the nearest largest (population) city?

[acerdell]

Hi All,

I have the lat long information (various locations) and I am trying to figure out a way to find nearest largest city (population-over 250k). CASS is not an option since I do not subscribe to it. I know how to find a distance between two locations using distance module, but no idea on this

Has anybody used geonames through alteryx to retrieve such information. Thanks

[patrick_mcauliffe]

@acerdell what country or geographical region is this for?

[jdunkerley79 · Accepted solution]

Interest data source.

Attach a quick example seems a clean enough set to work with. I kept source data zipped for size.