We recently received some geolocation information in Easting/Northing format that cannot be readily geocoded in Alteryx right now. We've put together a batch macro which converts the long/lats using an R script, all ready for geocoding downstream. It's defined for the UK Ordance Survey National Grid but presume can be adjusted for other types:
We hope it proves useful to the community.
Solved! Go to Solution.
Nice one!
Don't forget that you can also convert Eastings/Northings to a Spatial Object (Centroid) using the Create Points tool, and then pull the Lat/Long from a Spatial Info tool (Centroid X and Y properties).
Cheers!
Nick
Thanks Nick, that's a handy feature tucked away there! May be worth a blog or documentation update by someone to bring this to light.
Cheers
Hi,
I did some digging and found a really really good blog article from The Data School (and ultimately, @chris_love) that takes you through a slightly more detailed step-by-step instruction - much kudos to those guys!
http://www.thedataschool.co.uk/rob-suddaby/making-sense-of-eastings-and-northings/
Cheers,
Nick
Thanks Nick
Also, slightly off topic, but its worth remembering that you can change the projection of a non-WGS84 shape file on import too by changing the projection. Often a requirement in UK where shp files will be projected in British National Grid.