In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Projection from NAD27 to NAD83 using Alteryx Spatial Tools

livingja
7 - Meteor

I've been trying to project a few coordinates from NAD27 to NAD83 using Alteryx. So far the steps I have taken include the following:

 

I am using a 'Create Points' tool to input my longitude and latitude that pertains to my NAD27, I have also selected 'Fields are Projected Floating Points' as my option in this tool and have selected EPSG:32025 which pertains to NAD27/Oklahoma South . The next tool I use is the 'Spatial Info' tool in which my input is my spatial object field: 'centroid' from the previous tool and I have selected Items to Output: 'Centroid as X and Y Fields', I also have the Projection for XY output selected as EPSG:32125 in order to project to NAD83/Oklahoma South.

 

However, my coordinates are not correct. I have attached a csv of my coordinates. For an example one of my original NAD27 latitudes is:34.626746, longitude is:-97.804664. My projected NAD83 latitude is:24.527699, and longitude is:-9664.478024. Even if I were to move the decimal place of my longitude, the latitude alone puts my coordinate in a different state entirely. 

 

Please help me diagnose where it is I am going wrong so that I might correctly perform this task on Alteryx and I can receive the correctly project coordinates.spatial projection 1.pngspatial projection 2.pngspatial projection 3.png

2 REPLIES 2
CoG
14 - Magnetar

It appears that the NAD83 Oklahoma Southern Projection (EPSG: 32125) is not measured in Lat/Long but rather Easting/Northing and using units of meters not degrees (hence why moving the decimal place to treat it like lat/long messes everything up). Similarly, NAD27 Oklahoma Southern Projection (EPSG: 32025) is not measured in Lat/Long, but is also measured E/N (except using units of US Survery Feet). If you plot, the points you included as Lat/Long via NAD27 projection, all of your points are directly on top of one another for this reason.

 

The values included do appear to be in the form of Lat/Long, which indicates to me that you are not working with values using the EPSG: 32025 projection, but rather, likely using EPSG: 4267, which uses NAD27 Datum and is uses degrees for units, which you can then map to NAD83 (EPSG: 4269), which also uses degrees.

 

Screenshot.png

 

Hope this helps and Happy Solving!

livingja
7 - Meteor

Thank you so much! That was exactly the issue, and that fix worked perfectly. I really appreciate your help.

Labels
Top Solution Authors