Convert XY coordinates from NAD 1927 to NAD 83

[KevinChristy1]

Alright big brain time guys.

I am attempting to transform some XY coordinates in a table from NAD 1927 State Plane Florida West FIPS 0902 to NAD 1983 State Plane Florida West FIPS 0902. But here's the kicker:

I need to do it without ArcGIS Pro or ArcMap. Does anybody know how to get the conversion factor? And maybe how to do this within MS SQL?

Big thanks in advance

Kevin

[DanPatterson]

It isn't a conversion factor, It requires a reprojection.  Perhaps an online projection site would be the quickest if the number of values is small.  Also if you are versed in python, there are packages that can help with the transformation

[KevinChristy1]

So I need it to be written into a program and running continuously. I am familiar with going the python route and am thinking that may have to be the way I go.

[MehdiPira1]

Hi Kevin Christy,

You can use open-source gdal library which can be found and installed using pip from the link below:

GDAL · PyPI 

and by importing subprocess and reformatting the code below in your script:

gdaltransform -s_srs EPSG:26759 -t_srs EPSG:2237 1074753.9 533951.34

This re-projects from NAD 1927 State Plane Florida West FIPS 0902 to NAD 1983 State Plane Florida West FIPS 0902.

The following link provides more information:

gdaltransform — GDAL documentation 

I hope that helps and gives you an idea.