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.
