[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

3107866.533 6686516.654

Correct one is:
3108053.305 6686493.081

location is about 200m too much on west.

Any ideas?


Wippies-vallankumous on täällä! Varmista paikkasi vallankumouksen eturintamassa ja liity Wippiesiin heti!

More information about the postgis-users mailing list