I need to create a model in the ArcGIS ModelBuilder. I am working with a feature class of zip-codes for a state. I have got to the point where the zip-codes that have duplicates are selected from the feature class. There is a field called "Spots" within this feature class that has numeric values from 0-10. Of the zip-codes that have duplicates, I want to delete the feature that has the smaller number in the "Spots" field. Furthurmore, if the spots field is the same for the duplicates, I'd like to keep only the bottom row. I hope this makes sense! Any help would be great!
I've had very little luck with model builder on tasks simpler than this. I'd use arcpy, its a lot more powerful and user-friendly. For your task I'd try something like this...
Someone else might have something to say about that last codeblock, but its a good start. Honestly though, I needlessly banged my head against the keyboard trying to use Model Builder until I realized python is way better. Python is a great skill to learn! Give it a try, you'll be surprised.