NOTICE: 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 -->
    <query type="way">
      <has-kv k="name" v="Tesco"/>
      <bbox-query {{bbox}}/>
  <!-- print results -->
  <print mode="body"/>
  <recurse type="down"/>
  <print mode="skeleton" order="quadtile"/>

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

accept rate: 0%

edited 27 Aug '14, 12:34

aseerel4c26's gravatar image

aseerel4c26 ♦


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

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 ♦
accept rate: 22%

edited 27 Aug '14, 11:50


Given that I added one yesterday, I also doubt that it was the last one to be mapped!

(27 Aug '14, 16:06) Andy Allan

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 27 Aug '14, 11:13

question was seen: 7,826 times

last updated: 27 Aug '14, 16:27

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