Frederik Ramm wrote: >> Any hint what's the unit of these values? > PostGIS should be able to tell you via the geometry_columns table
ok, got it. without anything special it is 900913. As it's for mapnik, sounds reasonable to use the same projection than google ;) Just in case someone searches through the list archive, here the solution to get it transformed into lat/lon. select name, ST_AsText(way), ST_AsText(ST_Transform(way, 4326)) from planet_osm_point "Berlin";"POINT(1489169.4304313 6893990.0223961)";"POINT(13.3774366 52.5161201)" Stephan _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev