[mapserver-users] How to convert from 2393(Finish YKJ) to 4326 (WGS84)

[Pena Kupen]

Hello all,

Last time I was successfully helped by Ralf - Thank's once more time!
http://postgis.refractions.net/pipermail/postgis-users/2011-March/029055.html

Now I have same type of problem, but I cannot get correct result.

Table is:
CREATE TABLE location (
    location_id integer NOT NULL,
    coord geometry
);

Data is in coord column as 2393 format.

My sql is like:
select 
y(location.coord) as y_ykj, 
x(location.coord) as x_ykj, 
y(ST_Transform(location.coord,4326)) as y_wgs84, 
x(ST_Transform(location.coord,4326)) as x_wgs84
from location where location_id = 'AAA123A'

result for y_ykj and x_ykj are ok, but point of x_wgs84 and y_wgs84 are about 180meters too much in east.

-Pena


-- 
Wippies-vallankumous on täällä! Varmista paikkasi vallankumouksen eturintamassa ja liity Wippiesiin heti!
http://www.wippies.com/