I know that there are many similar topics around and I think I have checked them all but they all refer to different settings or aims.
My case is simple: I have
- polygons: building_blocks
- points: buildings (with a field called "type" indicating one of nine classes [basic, bungalow, villa, hall...])
I want to create pie charts from the building blocks indicating the fraction of the contained building types. Accordingly, I need the number of each of the nine building types as a separate column in the output polygon feature table.
I have tried the following tools:
- Spatial Join: Calculates the sum of points, but without distinguishing by "type"
- Aggregate Points: Has a Summary Fields option, but it doesn't group by "type"
- Count Overlapping Features: Has no group option
I know that it could be done with multiple steps:
- select all points with building type 1
- run aggregate
- join the tables and add a new column for type 1
- repeat with building types 2-9
But it is for a cartography course and I'm sure that this could be done easier (with two or three steps at least instead of 9)
Am I missing something crucial here?
I am using ArcGIS Pro 2.9.3 as a GIS Professional Advanced user.