Select to view content in your preferred language

How to search for a specific value in a specific field across multiple feature classes?

160
5
Tuesday
Pip
by
New Contributor

After a long time away from GIS, I'm trying to learn my way around ArcGIS Pro (3.3). In ArcMap you could use the Find tool and select 'In field' to show you all features that had a given value in that field across multiple layers (feature classes). In ArcGIS Pro it seems you can only search one layer at a time with Select by Attributes, as the Locate/Layer Search tool doesn't let you specify the field to search. I am dealing with nearly 100 feature classes, so to search through each one is a pain!

For example, say I need to search my whole project for any feature that has the field 'Surface Type', and the Surface Type = 'Asphalt'. I want to be able to get a list or select all features - whether they are a road line, a carpark polygon, or a sports court point - that have an asphalt surface. I don't want to export all of these to a new feature or gdb, I just need a list like the old Find tool provided.

Am I missing something obvious here, or does this functionality not exist (yet)? Thank you in advance!

5 Replies
Bud
by
Esteemed Contributor

If you don't get an answer you could try submitting an idea.

0 Kudos
RhettZufelt
MVP Notable Contributor

You can use the Locate tool and do a Layer Search:

RhettZufelt_2-1738802574169.png (With display field set)

 

You can have it only select certain fields BUT, only if you search One FC at a time (see the menu of CleanOut under Seach in layer above).

It will search all layers and all fields using the Search in all layers option, and you can change to detailed view to see what FC/field it was found in:

RhettZufelt_3-1738802628688.png (default display field)

However, it can be a bit confusing.  If you see above, I searched for H1-021 which should be in AsBuilt# or Project field, but it is reporting some other value in the Description (K-891).

Turns out the "Description" is the display field for that layer, so if you set the Display field to the one you want to search:

RhettZufelt_4-1738802743416.png

then the results are easier to make sense of. (first image above is with Display field set, second one shows default behavior)

You can then select what you want in the results pane and right click, add to selection as well.

I see that in earlier versions (3.1.3) the "Match exact" doesn't' work and it does a "Match any part" always, however, in 3.2.1 that seems to have been fixed.

I also miss the good old days of ArcMap where tools like this actually functioned as expected.

R_

Bud
by
Esteemed Contributor

Any thoughts on a specific idea that can be submitted to make it more intuitive?

0 Kudos
RhettZufelt
MVP Notable Contributor

Sure, match (or make similar to the one that served us so well in ArcMap for so long.

At least give us the ability to return all results and show what layer and Field the result was found in, as well as letting us sort by the Value/Layer/Field results:

RhettZufelt_0-1738857349016.png

And a way to search all 'In" layers for value in specific field:

RhettZufelt_1-1738857406473.png

And, no need to add a 'not called for field' in the results and rename it to something that doesn't make sense ( below from Pro, I do NOT have a field named "Description" in any of the datasets, why oh why does it list one?)

RhettZufelt_2-1738857573118.png

If you are putting a value there that wasn't requested in the search, at least label it with the proper Field name, not the value of some other cryptic field set in the Display options for that particular layer....

R_

Pip
by
New Contributor

Thank you for your answers - I didn't know about Detailed view, that helps a little!

But it seems that my options are either 1) search for X value in Y field one FC at a time or 2) search for X value in all fields in all FCs, then manually scroll through looking for the features I'm actually interested in. I see Bud has submitted an idea to be able to sort the results list (thank you!), but it would be nice if an actual 'search for X value in Y field in all FCs' was possible. Here's hoping for a future release...

0 Kudos