[OSM-talk] all POIs within a specific radius

[kenneth gonsalves]

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.