Alteryx designer Discussions

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

Easting/Northing conversion Macro

Alteryx Partner

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.

 

 

Highlighted
Alteryx
Alteryx

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

Nick Jewell | Alteryx Product Strategy
Highlighted
Alteryx Partner

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

Highlighted
Alteryx
Alteryx

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

Nick Jewell | Alteryx Product Strategy
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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.

Labels