Selecting polygon with maximum value

Question

Dear all

I am using a polygon shapefile and I want to select the polygon with the highest value. I am trying to implement this in ModelBuilder using ArcGIS Desktop v. 10.1. Ideally I want to select the maximum record and then use that selection to conduct additional analyses.

Any advice greatly appreciated.

Thank you,

Paul

RichardFairhurst · Answer

Many thanks for your reply. I had read about linking "Summary Statistics" with a tabular join. When you say

"join back to the original to do selections"

do you mean a tabular join? The problem is that after the summary statistics, all I have is the Maximum value and an ID value - is there a simple means by which I can also return the value of that polygon which has the maximum value?

Thanks again for your help,

Paul

Actually, normally for this type of analysis I do not use the ID value, because every record will be exported in the summary or an arbitrary min or max ID value will be outputted.  I usually create a dummy field and make every record have the same value in that field (for example all records have 1 in that field).  That is that case field that I summarize and tabular join to.  The summary produces the Max value for the table or current selection.  I use the join and a select by Attribute (Select from current selection if the summary was on a selection set) and find the record with a value equal to the max summary value (actually I really us a range relative to the Max value that is very small if the field is a double, i.e., Table.NumberField >= SummaryTable.MAX_NumberField - .0001 AND Table.NumberField <= SummaryTable.MAX_NumberField + .0001, because there can be slight rounding of the value during the summary that prevents the use of = ).

JackBeers_III · Answer

Once you generate the summary table, use the Model Only Tool "Get Field Value."  You can use this to return the value of the Summary Statistics Max Value for the field. You could then use the value to do other querys or analysis.  It should look something like this:

[ATTACH=CONFIG]21980[/ATTACH]

Capture.PNG

PaulMcKenzie · Answer

Many thanks for your reply. I had read about linking "Summary Statistics" with a tabular join. When you say

"join back to the original to do selections"

do you mean a tabular join? The problem is that after the summary statistics, all I have is the Maximum value and an ID value - is there a simple means by which I can also return the value of that polygon which has the maximum value?

Thanks again for your help,

Paul