Hi,

I am trying to count how many restaurants have been added in Rome. In the majority of cases restaurants seem to be added as nodes and tagged as amenity=restaurant, but sometimes they are also added as polygons and tagged as either amenity=restaurants or building=restaurants. If I union both nodes and polygons, may I double-count some restaurants? I mean, is it possible to find the same restaurant added both as a polygon and as a node within that polygon? If this is the case, any idea how to remove duplicates after union the results?

Thanks, Jacopo

asked 30 Dec '18, 19:59

jprimav's gravatar image

jprimav
114
accept rate: 0%

edited 31 Dec '18, 14:59

aseerel4c26's gravatar image

aseerel4c26 ♦
31.7k15235543

1

Not sure about the polygons and nodes, but to filter possible double ones you could compare them by name & address, so let's say 'for each result on the whole list, if address & name are the same then delete one'.

(30 Dec '18, 20:50) tijmenheid
1

Note that it is an "error" to map the same restaurant as node and polygon. I expect the the number of such errors is small, but if they appear, they should be fixed in the original data.

(31 Dec '18, 06:52) escada
Be the first one to answer this question!
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:

×76
×9
×4
×2

question asked: 30 Dec '18, 19:59

question was seen: 102 times

last updated: 31 Dec '18, 14:59

powered by OSQA