On Wed, 2011-07-27 at 07:41 -0400, Richard Weait 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? > > Here's a hint. ;-) > > Find locality points inside any Toronto polygon (includes Toronto, > Iowa (Ohio, NSW AU, etc) > > gis=# select p.name from planet_osm_point p, planet_osm_polygon g > where p.place='locality' AND ST_Within(p.way,g.way) AND > g.name='Toronto';
works like a charm. But it is not a 'hint', you are putting my ball instead of teaching me to putt ;-) Thanks anyway. _______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk
