Conditional merging of Shapefiles

216
2
07-15-2020 05:50 AM
MoritzWollen
New Contributor II

Hi everyone,

 

i try to merge a set of shapefiles under certain conditions. There are two attributes for the geometries in my files - "Type" and "Score".

 

All related geometries overlap completely. The attribute "Type" of overlapping geometries can be different. I want to adopt the geometry and all its attributes that has the highest score. In the field map of the merge tool I can set the merge rule for "Score" to maximum - but then the "Type" value of the associated geometry is not automatically taken over.

 

Is there a way to define advanced merge conditions?

 

Thank you.

0 Kudos
2 Replies
JoshuaBixby
MVP Esteemed Contributor

Several of the merge rules only apply to fields if they are numeric.  What data type is "Type"?  If text, how are you determining the highest value?

0 Kudos
MoritzWollen
New Contributor II

The data type of "Type" is text. The data type of "Score" is float. I calculate the highest value exclusively from the Score.

In summary, I try to remove duplicates (same geometry). I want to keep the geometry with the attributes that have the highest Score.

0 Kudos