How do you attribute a polygon record with the field ID of the intersecting polygon of greatest coverage?
e.g. below area P00000392 intersects both Areas LE24 2SW and LE24 2RV, but I want P00000392 to be attributed with LE24 2SW (the largest area).
I've got as far as listing the area coverage by polygon, but I'm struggling to know what to do next. Any advice on this would be much appreciated.
I'm currently running a Pivot Table process as I type, but I'm not even sure this will do what I need. I'll let you know if I find a way through this.
Ah, I've worked it out.
I used Summary Statistics in the end.
Input Table: is the table as shown above.
Statistics Field(s): Field 'LANDUSE_COVERAGE'; Statistics Type: MAX
Case field (optional): CATCHMENT_ID
Then join 'POSTCODE' field to the new output table via 'MAX_Shape_Area' field.
NOTE: the data files need to be created outside a geodatabase folder for the join to work properly.
Sorted.