This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Overpass API query with diff setting returning duplicate rows

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

overpass api diff

asked 12 Aug '16, 19:20

friesewoudloper
11●1●1●2
accept rate: 0%

One Answer:

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

answered 12 Aug '16, 19:37

friesewoudloper
11●1●1●2
accept rate: 0%

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