asked on

I need to convert NAD83 to WGS84 gps coordinates

We have an Oracle DB that stores the Florida State Planes NAD83 or FL83-NF points format for our MapGuide application for our service locations. However, periodically we need to convert the NAD83 format to WGS84 format to upload into another application Route Star with Lat/Lon coordinates.

I'd like to use either an Excel formula to accomplish the data point conversion or write an SQL statement to do the conversion and display the converted information in a View.

Can this be accomplished? If so, what will the the method or easiest solution.

Here are a few Geometric points:

Fieldname - [GEOM]

MDSYS.SDO_GEOMETRY(2001,2238,MDSYS.SDO_POINT_TYPE(1428420.626,504310.203,'null'),'null','null')

MDSYS.SDO_GEOMETRY(2001,2238,MDSYS.SDO_POINT_TYPE(1359888.11760939,508209.901693337,'null'),'null','null')

edrz01

ASKER

Here are a few Geometric points:

Fieldname - [GEOM]

MDSYS.SDO_GEOMETRY(2001,2238,MDSYS.SDO_POINT_TYPE(1428420.626,504310.203,'null'),'null','null')

MDSYS.SDO_GEOMETRY(2001,2238,MDSYS.SDO_POINT_TYPE(1359888.11760939,508209.901693337,'null'),'null','null')

Ray Paseur

This may be too far out in left field, so please forgive the intrusion if this is not useful for you. Using a web server configured with the (free) "LAMP" stack of Linux, Apache, MySQL and PHP, you can call the Google Geocoders and Mapping software. These are very flexible interfaces, able to draw maps from addresses, geocodes, or in many cases, the names of famous locations. I have an article here that describes some of this.
https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_3350-Using-the-Google-Maps-API-in-PHP.html

Hope that's helpful or at least something to stimulate your thinking, ~Ray

ASKER CERTIFIED SOLUTION

edrz01

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

edrz01

ASKER

EE... I am accepting my solution to close this question.

edrz01

ASKER

The question was resolved internally through contacts outside EE. And I hope anyone else that has a similar question can use this answer.

joyacv2

hi,

I read but this doesn't solve my problem