I have a shapefile with polygons representing a collection of nautical charts. The charts have different scales (an attribute in the layer) and some overlap. I want to create a layer which eliminates overlaps choosing the chart that has the best (lowest) scale. The way I see this working is that for each polygon, I need to see if there are any areas that overlap with a polygon with a lower scale value and remove that area for the polygon.
The end result is that I have a layer where anywhere I query, I will have only one polygon and it will represent the chart with the lowest scale for the point queried.
For example with this input (assuming red scale > yellow scale > green scale):
And the red polygon would become: