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. _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
