[Talk-GB] Data search request: help please
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
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
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
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 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
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
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