[OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

d8930 d8930 at uggsrock.com
Fri Feb 19 16:19:03 GMT 2010


Hi,
I am working on this as well. However, for testing I am using a point that
lies in the German city of Wiesbaden-Naurod. This city has the
geocoordinates 8.301388 / 50.13472. When I transform it by
SELECT astext(ST_Transform(ST_SetSRID(ST_MakePoint(8.301388,50.13472),
4326), 900913))
I get the value POINT(924106.285037392 6469639.74359406), which pretty much
is the same as the value in my PostGIS-DB (that was fed from OSM):
646985238;92409686 (considering multiplication by 100).
However, the other way round, with 
SELECT
astext(ST_Transform(ST_SetSRID(ST_MakePoint(92409686/100,646985238/100),
900913), 4326))")
I get the strange result POINT(1.30152356525693e-06 7.86059348425535e-06)
instead of somethin with 8.3* and 50.1*.
Any idea, why this could be?
-- 
View this message in context: http://n2.nabble.com/OSM2PQSQL-PostGis-Coordinate-Conversion-tp4367010p4598704.html
Sent from the General Discussion mailing list archive at Nabble.com.




More information about the talk mailing list