How to count the number of restaurants in Rome?

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
11●2●2●4
accept rate: 0%

edited 31 Dec '18, 14:59

aseerel4c26 ♦
32.6k●18●248●554

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

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

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

learn more about Markdown

Question tags:

amenity ×94
restaurant ×15
count ×8
rome ×3

question asked: 30 Dec '18, 19:59

question was seen: 1,120 times

last updated: 31 Dec '18, 14:59

How to count the number of restaurants in Rome?

Follow this question

Related questions