Re: [OSM-talk] querying the postgis db

2011-07-27 Thread Richard Weait
On Tue, Jul 26, 2011 at 2:09 AM, Kenneth Gonsalves law...@gmail.com wrote: 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

Re: [OSM-talk] querying the postgis db

2011-07-26 Thread Alexandr Zeinalov
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)

Re: [OSM-talk] querying the postgis db

2011-07-26 Thread kenneth gonsalves
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