I have a set of points on a map, each with a unique location id, with one or more points within a number of polygons with unique polygon ids. I am trying to associate each location id with the number of shared points in its respective polygon.
To do so I used the intersect tool on the points feature and polygon feature, intersecting by polygon id. I then used the dissolve tool with the polygon id as the dissolve field and the location id COUNT in the statistics field. Then unchecked "create multipart features".
This leaves me with a table of points with the polygon id each point is in, and the number of points in each polygon. But removes the location id associated with each point. How can I keep the location id associated with each point?
Here is my table before being dissolved:
Here is my dissolved table, I want to simply keep the location id for each point, but getting the count removes that field.
I did something similar using spatial joins but need to see the differences in output using the intersect and dissolve tools.