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 [email protected] ## N49°00'09" E008°23'33"
_______________________________________________
Talk-GB mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/talk-gb
