I have a polygon shapefile (selected in the attached pic) and a geologic table shapefile containing rock types (text) and an arbitrary corresponding number value (integer). Most polygons exist completely within a certain rock type. However, some polygons cross over multiple, different rock types. I would like to perform some kind of spatial join that determines what the most predominant rock type is within each polygon and assigns a single rock type. None of the merge rules (ie, first, last, max, min, etc) seem to accomplish this. In the screenshot, there are three geologic rock types within the selected polygon. I wish to add only "Kch" as the final attribute. This would seem to be a "majority" rule. However, I don't see an option anywhere for majority other than zonal statistics which produces a raster which I don't want. Thanks!
