I'm having a bit of a headache on this one, I hope you'll be able to help me out. (I'm on QGIS 3.10)
Problem
Here is the case : the national Dutch zoning plan regulation is delivered with shapes in which the maximum building height is stated. Unfortunately, they keep in the dataset current and previous zones. I would like to keep only the ones that are applicable on a national scale.
I have multiple features (in my case buildings) that are overlapping and/or being duplicated in one single layer. When there is an overlap, I would like to keep the geometries that are with the attributes the closest to current date.
My understanding would be that overlapping geometries should be compared and the one with the date attribute closest to today's date should be kept.
Done so far
But so far no success, with multiple methods I could try :
- Filtering out by dates doesn't make sense as depending on where you are in the country, the latest plan might be more or less old.
- There is no exhaustive list of attributes which could make the trick by filtering out the ones that are considered outdated by the municipalities.
- Join Attributes By Location doesn't work in this case.
- Delete Duplicates works but there is no control over which one is deleted, meaning that some times it is an outdated rule that is being kept.
- Vector Overlay hasn't worked neither.
As the data I'm dealing with is country scale, I cannot rely on manual sorting... :/