How to tell what has caused the number of segments in a database polyline to increase?

Question

A bit of background - I'm keeping an eye on accidental breakages of some long distance paths in the UK as described here. I've recently noticed that the results of

SELECT count(*) FROM planet_osm_line WHERE (osm_id = '-112695');

has gone up from 41 to 42 in the last 24 hours. That relation is the Midshires Way. I can see how many pieces it is really in by using this external relation analyser, but I don't want to use that more than I have to to avoid a significant load on an external site. I can look at the relation history in OSM and externally, and I can see that the relation itself has not changed; the change must have been to one of the constituent ways in the relation.

How can I easily see which ways that make up a relation have been recently changed, preferably using something I can install and run locally?

What I normally do is to look at the graphs in the graph from osmsurround and go through them one by one, but with a relation in many pieces, that's a lot of work. I can see 7 "obvious" gaps to fill in; the breakages range from 11 months to 6 years ago. None seem to be more recent than that.

Accepted Answer

Overpass does allow examination of what has changed between two dates. For Midshires Way this looks like this (also below). Changed allows two dates so changes in a specific period can be filtered.

rel(112695); // Midshires Way
(._;>>;); // recurse down for relation members
way._(changed:"2021-10-06T07:00:00Z"); // only select ways which have changed since 6 October
(._;>;); // get geometry of the ways

How to tell what has caused the number of segments in a database polyline to increase?

Follow this question

Related questions