[postgis-users] Convert from 3067 to 2393

Pena Kupen kupen at wippies.fi
Fri Mar 4 02:53:44 PST 2011


Hello all,

I try to do some conversion between different coordinates (3067 to 2393 ) without saving them to database.
My sql is following:
select x(ST_Transform(tbl.p,2393)), y(ST_Transform(tbl.p,2393)) from (select GeomFromText('POINT(108043 6683685)',3067) as p) as tbl

result:
3107866.533 6686516.654

Correct one is:
3108053.305 6686493.081

location is about 200m too much on west.

Any ideas?

--
BRH

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




More information about the postgis-users mailing list