Count points within polygons where an attribute matches in both

MichaelRobb2 — Wed, 22 Nov 2023 16:33:51 GMT

I am trying to do something which should be relatively simple but I can't seem to work it out, at least not without doing lots of intermediate steps, perhaps outputting to Excel to summarise it that way.

Essentially I have two layers:

Polygon layer representing GP practice catchments (one per catchment)
Point layer of patients location and the details of the GP practice they are registered to (one record per patient)

All I am trying to do is determine, for each GP practice catchment, the number of patients who are registered to that practice and within the catchment, and the number of patients who are registered to that practice and out with the catchment. Ideally outputted to a nice table.

Part of the difficulty I am having is that I can't work out how to deal with GP practice catchment cross-over i.e a patient could be within 2 catchments but registered to only 1 (or neither!) of those GP practices. I've attached a word document which I hope better explains the data.

Perhaps I am over complicating this in my head, I had thought that a spatial join and summarise would suffice but I kind of only want to spatially join patients to a particularly catchment if their Practice_ID is the same as said catchment.

Hopefully my scribblings make sense, thanks in advance for anyone's help.

Re: Count points within polygons where an attribute matches in both

DavidPike — Wed, 22 Nov 2023 19:56:38 GMT

yes it should just be a spatial join and some data wrangling. I think what you're missing is that the join has to be One_to_Many to account for the overlapping catchments.

topic Count points within polygons where an attribute matches in both in ArcGIS Pro Questions

Count points within polygons where an attribute matches in both

Re: Count points within polygons where an attribute matches in both