I have a large polygon layer in which most of the polygons have a unique name in a text field.
Of the hundreds that are not unique, there will be 2-4 polygons with the same name but different geometries.
I need to keep one of those polygons in each set of duplicates, the one with the largest area. I'll need to delete the rest.
Since the geometries are different I am guessing I cannot use ArcGIS' built-in duplicate finder and will need an SQL statement to do what I need.
How could I do this when I am far from proficient with SQL?