I have a point feature and a polygon feature and want to join the point to the polygon so that I can get the count for each polygon. Question is the points are grouped by a filed called type, it has like "A","B","C", etc.
Is there a way to join grouped points by the "type" field so that after joining, I'm going to have the polygon feature with fields like "CountA", "CountB", etc., and the it reflects the number of the points falls in that polygon respectively?
I don't see a query statement option in the spatial join function and currently my solution is to create different point features by "type" field, and make the spatial join respectively.
Is there an easier way to do that?
Polygon and points are stored in file geodatabase as below:
Either in python window or stand-alone script will be fine.