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

2011-07-25 Thread Pena Kupen
Thank's! I tried and it works ok :-) -Pena Rahkonen Jukka [jukka.rahko...@mmmtike.fi] kirjoitti: Hi, If you do not need to reproject or you are reprojecting just between KKJ zones you can live without towgs84 parameters. However, reprojecting to/from all the other systems will give an err

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

2011-07-25 Thread Rahkonen Jukka
Hi, If you do not need to reproject or you are reprojecting just between KKJ zones you can live without towgs84 parameters. However, reprojecting to/from all the other systems will give an error of 150-200 meters. That is the thing that is not safe. Updating spatial_ref_sys is safe. The most

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

2011-07-24 Thread Pena Kupen
Thank's Jukka, On my spatial_ref_sys-table, there is proj4text like: +proj=tmerc +lat_0=0 +lon_0=27 +k=1.00 +x_0=350 +y_0=0 +ellps=intl +units=m +no_defs So towgs84-parameter is missing. If it is not, update the record. It this safe? Can it affect with unwanted result somewhere? Y

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

2011-07-24 Thread Rahkonen Jukka
Hi, I suppose that towgs84 parameters are missing. You can check this with psql: select proj4text from spatial_ref_sys where srid=2393; The result should be close to +proj=tmerc +lat_0=0 +lon_0=27 +k=1.00 +x_0=350 +y_0=0 +ellps=intl +towgs84=-90.7,-106.1,-119.2,4.09,0.218,-1.05,1.37

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

2011-07-24 Thread 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,