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

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:

×483
×290
×32

question asked: 12 Aug '16, 19:20

question was seen: 2,494 times

last updated: 12 Aug '16, 20:13

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