Easting/Northing conversion Macro

[Andrew_Paterson]

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:

https://gallery.alteryx.com/#!app/Easting_Northing-to-Latitude_Longtitude-Conversion/582f3591a18e9e0...

We hope it proves useful to the community.

[NickJ · Accepted 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

[Andrew_Paterson]

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

[NickJ]

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

[chris_love]

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.