Home » Server Options » Spatial » Help with SDO_CS.TRANSFORM (4267 - 4269) (10g,, Solaris)
Help with SDO_CS.TRANSFORM (4267 - 4269) [message #416653] Mon, 03 August 2009 14:04 Go to next message
Messages: 2
Registered: August 2009
Junior Member
Hi everyone, I'm having a little issue (probably very stupid on my part) with a coordinate transform.

I'm attempting to convert points from NAD27 (SRID 4267) to NAD83 (4269), and coming up with a different answer than what's given by www.ngs.noaa.gov/cgi-bin/nadcon.prl

Here's my query & result in oracle:

MDSYS.SDO_GEOMETRY(2001, 4267, MDSYS.SDO_POINT_TYPE(145.11492, 64.4279888, NULL), NULL, NULL)
SDO_GEOMETRY(2001, 4269, SDO_POINT_TYPE(145.11492, 64.4263234, NULL), NULL, NULL)

However, the result given from the noaa conversion site using the above coordinates is 145.117275 x 64.427607 (also get this result using mapinfo or arcgis).

Can anyone advise me in what direction to proceed?
Re: Help with SDO_CS.TRANSFORM (4267 - 4269) [message #416834 is a reply to message #416653] Tue, 04 August 2009 10:36 Go to previous message
Messages: 2
Registered: August 2009
Junior Member
Found the answer to this at the oracle forums:


Basically the TRANSFORM using NADCON won't work with our version (, only TRANSFORM_LAYER works.

Previous Topic: Installing Just Locator
Next Topic: Functions to return polygon data
Goto Forum:

Current Time: Tue Aug 22 04:28:14 CDT 2017

Total time taken to generate the page: 0.12532 seconds