[OSM-talk] querying the postgis db

kenneth gonsalves 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
> list
> > of all localities within a particular city - can anyone give a hint
> on
> > 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 mailing list