[OSM-talk] querying the postgis db
lawgon at thenilgiris.com
Tue Jul 26 07:33:27 BST 2011
On Tue, 2011-07-26 at 10:20 +0400, Alexandr Zeinalov wrote:
> > I have installed osm data in a postgis db, and would like to get a
> > of all localities within a particular city - can anyone give a hint
> > the sql required for this?
> Something like:
> SELECT a.osm_id,a.name,ST_X(a.way),ST_Y(a.way) FROM planet_osm_point
> a,planet_osm_polygon b WHERE a.place='locality' AND b.osm_id='id of
> boundary of particular city' AND a.way && b.way
cool - thanks, that should get me started.
More information about the talk