This must be possible, but how? Points layer - cross reference Poly layer

[SimonLaughton]

Hello

Please bare with me!  I have been given a task which the way I would normally think of doing it would take quite some time and I think there must be a better way to do it.  I will try my best to explain and hopefully someone can help (if you understand my drivel!).

The point of the task is this in simple terms:  As a local authority we want to be able to see how many requests we get from each parish area in order to be able to best divide them up by members of staff to give roughly even workloads.

I have a GIS layer (points) with many records on it.  There is a field on this layer which gives an abbreviation of the type of request being made.  There is approximately 250 types of request, and a quite a few thousand records on the layer.

I also have a layer which shows all of the Parish boundaries in the area (approx 25).

The output required
The desired output is to give me a table/spreadsheet (I guess excel) which gives me a total per parish for each type of request.  I will mock up something like I am hoping to achieve and attach it to this message.  I am open to better ways of doing this! Thank you.

[JimCousins]

My first thought is to run a spatial join of the points to the parish polygons, to create that association. Summary statistics should allow you to get a count of each request type within each parish.

Regards,

  Jim

[SimonLaughton]

Thanks Jim (and others who replied!).

I think I have manage to do a Spatial Join - I now have a points layer which contains both the Request Type code and the Parish it falls in (see picture).  I am now trying to get this to the final format of showing me how many Requests are in each Parish by Type (as per my original output image).  I have the Summary stat tool up  trying to work out how to do this but failing! If this is the best method (I note the other replies below suggested alternatives), could you walk me though it? Thank you!

[JimCousins]

This is an "out of the box" solution, and other methods may get you exactly what you want.
I see you have each SRRECTYPE associated with NAME_1.

For the summary statistics, you want the Statistics Field(s) to pint to the SRRECTYPE column with the Statistic Type set to COUNT. You want this based on the unique values of NAME_1 paired with SRRECTYPE, so select NAME_1 and SRECTYPE for the Case Field(Optional) entries in the bottom dialog box.

This should look at each unique value of NAME_1 combined with SRRECTYPE and provide a count of each unique value in the pairing of NAME_1 with SRRECTYPE.

Your result may not be in the format you want as output, but all of the information is there for you to reformat. However, one of the other solutions presented may provide the output in the format you want.

[JeffHouser]

Hello Simon,

Please refer to Jim's reply to solve your question.  The only other thing I could mention if Summary-Statistics is not what you're looking for, you can try:

Use the "Table To Excel" Tool:

• Go to the Analysis tab and open the Geoprocessing pane.
• Search for the Table To Excel tool.
• The Table to Excel is based on whole Attribute Table or selected features after the spatial Join.

~Jeff

[DavidPike]

For your output you'd probably want Pivot Table (Data Management)—ArcGIS Pro | Documentation or more likely Transpose Fields (Data Management)—ArcGIS Pro | Documentation after the Summary Statistics.

[SimonLaughton]

Thanks - I am on desktop 10.8.2 and I dont think this includes the Pivot Table tool 🙂