Tuesday 24 October 2017

arcgis desktop - Performing Full Text Search of Esri geodatabase?


How would you go about searching the contents of features, the values in the attribute columns, in an Esri geodatabase? (preference for file-gdb, but SDE would be useful too.)


I can envisage workflow where one dumps the whole gdb using Export XML Workspace and searches the result for strings (yuk!), or loops through all the tables in a python version of Select by Attributes. While both of these would work, they are not appealing.


The goal is to be able to efficiently answer a question like: which of these 50 feature classes has something to do with "Keno"?



Answer



The Features tab of the Find tool will do this if you add every feature class in the File Geodatabase to a map.




For example, if you are trying to find Afghanistan on a map of the world, you can enter Afghanistan or just Afgh in the Find tool, and you'll get a list of the features from layers in your map that contain that search string in any of their attributes.



No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...