I have an external Dataset containing Cadastral data. When the lot is shared between different landowners, there are multiple overlapping polygons each storing the landownership and other important attributes separately.
Every overlapping polygon has the same properyID - common feature.
I can extract the table bring it to an SQL engine and create the queries manually; merging all the landowners (L1,L2,L3 etc) and linked it back to a dissolved table by ID.
Can anybody recommend an easier way to do it on ArcGIS Desktop?