Re: [Talk-GB] Data search request: help please

2015-01-23 Thread SK53 
Another data point.

This matches exactly an internal data search on a) all pubs I've had a beer
in with '[Ll]ouise in the name and b) all pubs/bars/taverns/biergartens I
can still remember with [Ll]ouise in the name (both UK only of course).

Jerry

On 22 January 2015 at 22:31, Frederik Ramm frede...@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 frede...@remote.org  ##  N49°00'09 E008°23'33

 ___
 Talk-GB mailing list
 Talk-GB@openstreetmap.org
 https://lists.openstreetmap.org/listinfo/talk-gb

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] Data search request: help please

2015-01-23 Thread Ed Loach 
Another point in favour of the two pubs theory is searching for %Louise% at 
WhatPub.com and making sure filters for open/real ale available etc are cleared:
http://whatpub.com/search?q=%25Louise%25t=ftp=1alt=

Ed


___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

[Talk-GB] Data search request: help please

2015-01-22 Thread Andy Mabbett 
I need some help, please.

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.

How might I do this, given that I am not a coder?

Or, if coding skills are needed, can someone kindly do it for me?

-- 
Andy Mabbett
@pigsonthewing
http://pigsonthewing.org.uk

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] Data search request: help please

2015-01-22 Thread SomeoneElse 

On 22/01/2015 21:59, Andy Mabbett wrote:

I need some help, please.

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.

Do you mean in the UK, or in OSM in the UK?


How might I do this, given that I am not a coder?


My first thought was that if you meant in OSM you could just try:

http://taginfo.openstreetmap.org.uk/search?q=louise#values

There are few enough pages that you can scan the results manually:

http://www.openstreetmap.org/way/164418353

http://www.openstreetmap.org/way/97237916

but that seems a much smaller number than I was expecting...

Cheers,

Andy




___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] Data search request: help please

2015-01-22 Thread Frederik Ramm 
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

Re: [Talk-GB] Data search request: help please

2015-01-22 Thread 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 frede...@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 frede...@remote.org  ##  N49°00'09 E008°23'33

 ___
 Talk-GB mailing list
 Talk-GB@openstreetmap.org
 https://lists.openstreetmap.org/listinfo/talk-gb

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] Data search request: help please

2015-01-22 Thread Roland Olbricht 

Hi Andy,

the following query
http://overpass-turbo.eu/s/7cV
lists definitely all objects in the OSM with the following properties:
- It is situated in the United Kingdom
- Its name tag contains the word Louise
- It is neither a bus stop, a street, a florist, a hairdresser, nor a 
clothes shop.


Please push Run, then wait a minute. Then push Data to see the raw data.

The latter condition may look a bit strange, but that way we end up with 
a reasonably short but comprehensive list, even if the object in 
question is poorly tagged:

- ways 97237916 and 164418353 are proper pubs
- node  is a guest_house and could offer beverages, and ways 235035265 
and 289369460 do not annouce their purpose from their tagging.


Best regards,

Roland

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] Data search request: help please

2015-01-22 Thread Roland Olbricht 

the following query
http://overpass-turbo.eu/s/7cV
lists definitely all objects in the OSM with the following properties


http://overpass-turbo.eu/s/7cW
may help further: More object categories have been excluded, and the 
out center means that every found object is dispayed on the map.


Best regards,

Roland


___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb