How to Have Model Add Columns & Summarize Points by Name

253
4
Jump to solution
07-08-2021 12:59 PM
Labels (2)
CraigHarris1
New Contributor II

Hello:

I created the below model that would provide an overall summary count of points within a buffer. While this works, I’m now being asked to breakout the total number of points by name (for example, 5 Walmart, 9 Target, 12 Best Buy, etc.).  I’m hung up how to modify the model to automatically add a new column for every / each name and then sum / count its number points within that buffer.  Any suggestions would really be appreciated – thanks!

CraigHarris1_0-1625774099131.png

 

1 Solution

Accepted Solutions
DanPatterson
MVP Esteemed Contributor
4 Replies
DanPatterson
MVP Esteemed Contributor

could you add

Summary Statistics (Analysis)—ArcGIS Pro | Documentation

to your workflow


... sort of retired...
CraigHarris1
New Contributor II

Thanks! For the model I have posted, where would I add Summary Statistics? (I'm new to ModelBuilder). :)

0 Kudos
DanPatterson
MVP Esteemed Contributor

I don't use it period... but you would put it and connect it in the place after you have gathered the input data you want to summarize.  So what output do you want to summarize?


... sort of retired...
0 Kudos
CraigHarris1
New Contributor II

I have a point layer of retailers.  I want a column for each store name and a count of how many stores they have within a polygon layer.

0 Kudos