[Talk-GB] Data search request: help please

[Neil Pilgrim]

A quick search on FHRS (which admittedly doesn't do all of them) seems to
support the two-pub hypothesis (excepting maybe a bowling club).

--
Neil

On 22 January 2015 at 22:31, Frederik Ramm <frederik at remote.org> wrote:

> 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 frederik at remote.org  ##  N49°00'09" E008°23'33"
>
> _______________________________________________
> Talk-GB mailing list
> Talk-GB at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-gb/attachments/20150122/5655f2e3/attachment.html>