I have a feature class which looks like this:
What I need to do is loop through each group of records in the NAME field where the value is the same (these are community names) and perform a calculation which is based on the Area values for each USE_CATEGORY and the Sum of all USE_CATEGORY Area values (which will give us the total area for the community). I think the following excel snapshot outlines the calculation to be done against each community (NAME):
The end goal is to create a new table that will show the community along with the calculated diversity index for that community:
I'm thinking some sort of loop would be used to select the records for each community, but I'm not sure of the best way to go about that and also how do you move on to select the records for the next community. Looking for some guidance and ideas on how to best get this done.