On Mon, 2011-08-08 at 10:40 +0200, Frederik Ramm wrote: > > select name from planet_osm_point where place = 'locality' and > > ST_DWithin(way,(select way from planet_osm_point where name > > like 'Bangalore%' limit 1),300) order by name; > > Is it possible that your database is not in Mercator projection but > in > latitude/longitude (-l option on osm2pgsql)? In that case you would > be > selecting everything within 300 degrees of Bangalore, and you'd have > to > try a distance of about .0003 for something roughly like 300 metres.
as usual you are right - thanks. _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk