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. _______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk
