[OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

d8930 d8930 at uggsrock.com
Mon Feb 22 10:36:29 GMT 2010



d8930 wrote:
> 
> It works for me, though there was an extra ") in what you quoted.
> 
> gis=> select
> astext(ST_Transform(ST_SetSRID(ST_MakePoint(92409686/100,646985238/100),900913),
> 4326));
>                  astext                  
> -----------------------------------------
>  POINT(8.30129560793713 50.135942170124)
> (1 row)
> 
> You will get slightly better accuracy if you divide by 100.0 to force
> the result to be calculated as a float:
> 
> gis=> select
> astext(ST_Transform(ST_SetSRID(ST_MakePoint(92409686/100.0,646985238/100.0),900913),
> 4326));
>                  astext                  
> -----------------------------------------
>  POINT(8.30130333344857 50.135944358132)
> (1 row)
> 
Which version of Postgres do you use? I am using 8.3.

-- 
View this message in context: http://n2.nabble.com/OSM2PQSQL-PostGis-Coordinate-Conversion-tp4367010p4611266.html
Sent from the General Discussion mailing list archive at Nabble.com.




More information about the talk mailing list