Hi,

Can anybody please explain to me why this Overpass API query returns in part duplicate rows? Is there anyway I can automatically remove the duplicates?

[timeout:500][out:csv(::"id", amenity, name; true; ";")]
[diff:"2016-01-05T00:00:00Z","2016-05-31T24:00:00Z"];
area["name"="Groningen"]["admin_level"="10"];
node["amenity"="cafe"](area);
out;

Best regards,

Willy

asked 12 Aug '16, 19:20

friesewoudloper's gravatar image

friesewoudloper
11112
accept rate: 0%


I think I've got the answer. I changed the output format to xml. Then I saw in the output that all the duplicate rows have a parameter type="modify" and the non-duplicate ones type="create". So I guess the duplicate rows are nodes that were modified during the time period and the non-duplicate ones were newly created. Am I right?

Willy

permanent link

answered 12 Aug '16, 19:37

friesewoudloper's gravatar image

friesewoudloper
11112
accept rate: 0%

1

The main issue here is that CSV output doesn't really play well with the diff setting. You probably should file an issue for that: https://github.com/drolbr/Overpass-API/issues

(12 Aug '16, 20:13) mmd
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:

×334
×228
×28

question asked: 12 Aug '16, 19:20

question was seen: 1,061 times

last updated: 12 Aug '16, 20:13

powered by OSQA