I'm doing a spatial join between two polygon data sets (A and B). B polygons are always smaller than A polygons and there's only a small number of them. They have 2 attributes that I'd like to pass on to A polygons ('height' and 'area') if A contains B. One A polygon may contain more than one B polygon.
Let's imagine there's a case where 1 A polygon contains 5 B polygons. The 'height' and the 'area' from B that I want to pass on to A are those ones from the B polygon with the maximum 'height'. In ArcGIS Pro -> Geoprocessing I know how to pass the 'height' [Merge Rule -> Maximum]. However, I don't know how to pass also the 'area' from that very same B polygon with max 'height'.
Steps in ArcGIS Pro -> Geoprocessing (to explain what I've done)
- Choose Target Features
- Choose Join Features
- Choose Output Feature Class
- Join Operation: Join one to one
- Untick 'Keep all target features'
Setting up 'Field Map of Join features'
- Output field 1: 'Out_height'
Source 1: 'Height' (from B) & Merge Rule: 'Maximum'
Output field 2: 'Out_area'
- Source 2: 'Shape_Area' (from B) & Merge Rule: 'Join' (what should I use otherwise if not 'join'??)
Match Option: Contains
What I have done in 'Output field 2' will populate 'Out_area' with the area of the A polygon (which will therefore be duplicated) instead of the area of the B polygon with max 'height (which is what I want).