NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi I'd like to get a list of the location of all the Tesco supermarkets in the UK into excel. I'm running a query through Overpass Turbo but I'm not getting a full list of results. I shows ~600 nodes but I know there are over 3000 Tesco's in the UK. Here is my query

<osm-script output="xml" timeout="100000">
  <!-- gather results -->
  <union>
    <query type="way">
      <has-kv k="name" v="Tesco"/>
      <bbox-query {{bbox}}/>
    </query>
  </union>
  <!-- print results -->
  <print mode="body"/>
  <recurse type="down"/>
  <print mode="skeleton" order="quadtile"/>
</osm-script>

Am I missing something? Also - can I use a wildcard for the name search? It only returns stores with the exact name "Tesco" rather than "Tesco Express".

asked 27 Aug '14, 11:13

dotman's gravatar image

dotman
31113
accept rate: 0%

edited 27 Aug '14, 12:34

aseerel4c26's gravatar image

aseerel4c26 ♦
32.6k18248554

4

Don't forget to include in your query type=node as well. Most of the smaller shops I tag are only nodes.

(27 Aug '14, 11:49) AlaskaDave

Added that. Results look much better now. Thanks

(27 Aug '14, 11:59) dotman
1

Can you update your question or add an answer? Showing your new query will help other users having the same problem.

(27 Aug '14, 16:27) scai ♦

This wiki page suggests you can get names that start Tesco by changing v= to regv= if I've understood correctly.

Also, it looks like you are only querying named ways, rather than also checking node POIs and relations.

Finally, I doubt all Tesco stores are mapped. Taginfo can perhaps show you how many to expect

permanent link

answered 27 Aug '14, 11:47

EdLoach's gravatar image

EdLoach ♦
19.5k16156280
accept rate: 22%

edited 27 Aug '14, 11:50

2

Given that I added one yesterday, I also doubt that it was the last one to be mapped! http://www.openstreetmap.org/node/3043305147

(27 Aug '14, 16:06) Andy Allan
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×483
×35
×6
×1

question asked: 27 Aug '14, 11:13

question was seen: 7,732 times

last updated: 27 Aug '14, 16:27

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum