I have a table of crimes by precinct. There is a field with the precinct number (I.E. 1, 2, 3, 4...) I also have a field each for Burglaries, Assault, Arsons with a count of how many in each precinct. Is there a way to summarize the precinct field so that each of the three crime type fields are ranked from highest count value to lowest (I.E. 1,2,3,4... instead of the current count 45,35,43...)

2 Answers 2


While sorting won't immediately give a numerical ranking, it will arrange the file so you can easily calculate it. If you need the actual numerical rank, you can add a field for each type of rank, sort on that basis, and then us CalculateField_management to set the rank.

Sort_management will allow you to sort on multiple fields, specifying ascending/descending for each.


In ArcMap, open the attribute table.

Right click on one of the column headers and click Advanced Sorting.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.