Hello,
I am trying to select only values on a map that touch AND share the same value in a field. For example, numerous people own/are in charge of multiple plots of land across a state. Some of these parcels touch each other while others do not. One person may own two or more plots of land that touch, own plots of land far away from each other, or a mixture of both options (some that touch some that don't). I'd like to be able to select only parcels that touch and are owned by the same person.
If someone (let's say a value of 'John' in the 'Owner' attribute) owns parcels far away from each other or owns two parcels with another parcel (let's say 'Jasmine' owns the middle one) between, i.e. not touching, they would not be selected. I'd then like to be able to symbolize the 'double' parcels based on owner name, dropping all 'single' parcels from the map. I don't want to go fully manual by creating a new layer per owner then selecting polygons based on spatial proximity.
I've included a very basic table to try to convey the idea.
Any suggestions?
| Owner | Parcel | x,y location |
John | 1 | 2,1 |
| Jasmine | 2 | 1,1 |
| John | 3 | 2,2 |
| Jasmine | 4 | 5,5 |
| John | 5 | 6,8 |
| Jack | 6 | 2,5 |
| Jessica | 7 | 7,6 |
| Jessica | 8 | 6,6 |
| Jasmine | 9 | 3,1 |