This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 12-28-201501:41 PM - edited on 02-27-202002:25 PM by KylieF
Parse TomTom US Address Points
As @MattD recently referred to in his post, reverse geocoding is a helpful spatial task using Alteryx Designer and TomTom US Address spatial data. I've recently helped a few prospective customers understand how to find address information by reverse geocoding latitude/longitude points. For new users, parsing data isn't always straight-forward. And for new users who have never seen regex, well, let's not go there...
The reverse geocode process returns the entire address in one cell. So, the customer still needs to parse out the string if they want the address in separate fields. I built a macro that returns address, city, state, zip, and zip+4 in separate fields.
Here is an Alteryx Gallery link to the macro that only needs to reference the '__Addr_Pt' and '_Centroid' fields.