Home » Server Options » Spatial » Help with SDO_CS.TRANSFORM (4267 - 4269) (10g, 10.2.0.0.0, Solaris)
Help with SDO_CS.TRANSFORM (4267 - 4269) [message #416653] Mon, 03 August 2009 14:04 Go to next message
sfsnedigar
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:

SELECT SDO_CS.TRANSFORM(
MDSYS.SDO_GEOMETRY(2001, 4267, MDSYS.SDO_POINT_TYPE(145.11492, 64.4279888, NULL), NULL, NULL)
,4269
)
FROM DUAL;
-------------------------------------------------------------
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?
Thanks!
-Seth
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
sfsnedigar
Messages: 2
Registered: August 2009
Junior Member
Found the answer to this at the oracle forums:

forums.oracle.com/forums/thread.jspa?messageID=3669862&#3669862

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

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


Current Time: Fri Mar 29 09:19:08 CDT 2024