[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