Summarize Tool

I am trying to find the most populated cities within various polygons (which have I.D.'s). My cities have a POP value associated. When I use the Summarize tool I group by the polygon ID, then select the MAX for Population. The issue is I also need the city name. There are multiple Cities within a given polygon. I tried using "first" but that returns the first city entry with the max pop (which is not the same city). I want to simply carry over the city associated with the max POP value within each polygon but I don't see a way to accomplish that.

Any help is appreciated!

Transformation

Accepted answers

I found the solution that worked for me. It required first decending the POP value, then using the MultiTool Formula, creating a new field called RANK grouping my polygon ID and adding in the formula [Row-1:RANK]=1, then filtering out rank 1 and it gave me the result I needed.

Thank you everyone for your help with this.

Forgive me if I'm stating the obvious, but isn't this precisely what the Unique tool is meant for??

Sort on your polygon ID, and population fields, then take the Unique polygon.

All comments

If you can't group by POLYGON ID, CITY

then you might try joining back to the original data on the POP size and getting the cityname that way.

OR....

SORT the data by POLYGON, POP (Descending) and Sample the first record (grouping by POLYGON) and finding the data (city/pop) that way.

Just a thought,

Mark

I tried these options. When I do this it returns each city name, the polygon ID and each associated POP.

For example this is what the above steps are giving me:

ID City POP

1 Atlanta 500

1 Marietta 300

1 Kennesaw 200

1 Alpharetta 100

2 Rome 200

2 White 50

The desired output I want would be:

ID City POP

1 Atlanta 500

2 Rome 200

Thank you for your response.

I found the solution that worked for me. It required first decending the POP value, then using the MultiTool Formula, creating a new field called RANK grouping my polygon ID and adding in the formula [Row-1:RANK]=1, then filtering out rank 1 and it gave me the result I needed.

Thank you everyone for your help with this.

Forgive me if I'm stating the obvious, but isn't this precisely what the Unique tool is meant for??

Sort on your polygon ID, and population fields, then take the Unique polygon.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703