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

Location Data Knowledge Base

Data methodologies, and Release schedules.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Approximate Reverse Geocoding Information from Latitude and Longitude Coordinate Pairs

Community Data Engineer
Community Data Engineer
Created on

Find yourself with latitude and longitude coordinate pairs for your spatial objects but not much else information on the locations? If you need more geographical information on a coordinate, try converting it into a spatial object and using the Find Nearest Tool to find coinciding Experian geographical data from an Allocate Input Tool. This can be used to reverse geocode less granular address information such as ZIP Codes, counties, states, and even approximate “places.” Just be sure to send it in with a record ID, as the Find Nearest Tool will append a row each time it finds the closest specified value for each selection:

Lat Lon 1.png

Lat Lon 2.png

Lat Lon 3.png

Attachments
Comments
Alteryx Partner

Good idea. I had created the same working with the Address points in a calgary database so it can return addreses.

Community Data Engineer
Community Data Engineer

Thanks @Simon_Lavergne! That's a great approach to it as well. To give more granular address information on coordinates when reverse geocoding, I went ahead and created a macro that connects to the Google Maps API to find the locations in their geodata. It does traditional geocoding as well (with zip+4 where applicable)! It's posted to the Alteryx Gallery here:

 

https://gallery.alteryx.com/#!app/Google-Maps-Geocoder/562faea8aa690a17f074f271

Community Data Engineer
Community Data Engineer

Good example and help but  It gives me an error on the allocate Input  :


Error: Allocate Input (27): No dataset has been selected.
End: Designer x64: Finished running Lat Lon to Zip Example.yxmd in 0.2 seconds with 1 error

 

Can you help how to resolve it?

 

In Addition, How I can get the Zip and convert it into a string and store it on the Table?

Hi @MattD  Thank you for your post but the data is not available with your solution, could you post it here? 

Labels