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

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


Stephan Knauss wrote:
> planet_osm_point contains the tags already decoded into columns. But i 
> would need to join this to do the restriction to the bounding-polygon, 
> right? 
Discovered a great thing. The column named "way" actually contains 
points. And it has a gist index. Looks like this is the way to go.
Any hint what's the unit of these values?
select ST_AsText(way)
"POINT(1489169.4304313 6893990.0223961)"

Stephan




More information about the dev mailing list