[OSM-dev] Best way to select from a region

Stephan Knauss osm at stephans-server.de
Tue Sep 1 07:25:01 BST 2009


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




More information about the dev mailing list