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