I need to select the 3 features that have the largest attribute value. How is this best completed? I would like to do this within a model builder environment. I have been trying to figure out the sql statement within the select tool but am having syntax problems.
What tool can select the records with the highest values in a particular field?
See https://community.esri.com/t5/arcgis-pro-ideas/use-select-by-attributes-to-select-greatest-n/idi-p/1370912
Thanks Katherine, I did see that. Just figured that since it seems like such an important query that ESRI would have a tool. Guess not.
This is yet another example of where Esri has done a poor job of implementing SQL support in the file geodatabase. If your data were stored in just about any other database, the query would be quite trivial, but doing something simple like this is way more complicated than it needs to be because Esri doesn't support TOP, LIMIT, or similar keywords.
Have you seen this post? Might be helpful...
arcgis desktop - Using Select Layer By Attribute to return top 3 records - Geographic Information Systems Stack Exchange
As the post states, "Python scripts in the form of custom tools can be used in Model Builder".
Hope that helps at least a bit! Good luck!
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
