community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

Meteor

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

@acerdell what country or geographical region is this for?

Interest data source.

 

geonames.jpg

 

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

Labels