I have a dataset of state pesticide permit polygons. Each polygon is identified by a permit number and site id plus there are attributes for effective date and expiration date. In many cases the polygons overlap in one of three ways:
- 1. Edge overlaps where imprecise drawing causes overlaps.
- 2. Polygons are designed to represent the same area. Sometimes these are drawn slightly differently so they are not exact matches
- 3. The same area is divided into different numbers of polygons at different times.
What I need to do is take overlap cases 2 & 3 and keep the overlapping polygon with the most recent effective date.