> hi, > > I know that this sounds a bit of a dumb question: > > 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 _______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk
