[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