Hi, On 01/22/2015 10:59 PM, Andy Mabbett wrote: > I want to compile a list of all the pubs (including taverns bars, etc) > in the UK, with the word "Louise" as part of the name.
I, too, found a much smaller number than expected, by querying a database I have installed for rendering purposes: select 'W' as type,osm_id,coalesce(amenity,tourism) as what,tags->'name' as name,st_x(st_centroid(way)) as lon,st_y(st_centroid(way)) as lat from planet_osm_polygon where tags->'name' like '%Louise%' and way && st_makebox2d(st_makepoint(-14.02,49.88),st_makepoint(1.83,61.07)) and ( amenity in('pub','bar','restaurant','fastfood') or tourism='hotel' ); type | osm_id | what | name | lon | lat ------+-----------+------+-----------------+--------------------+------------------ W | 164418353 | pub | The Bree Louise | -0.135489232160522 | 51.5270537134717 W | 97237916 | pub | Princess Louise | -0.12157304700441 | 51.5172546574115 (2 rows) And the same query for points gives zero results. Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09" E008°23'33" _______________________________________________ Talk-GB mailing list Talk-GB@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk-gb