| Help with SDO_CS.TRANSFORM (4267 - 4269) [message #416653] |
Mon, 03 August 2009 14:04  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
