select by attribute

133
3
10-26-2020 07:29 PM
New Contributor II

Hi, 

I had my table joined with another one which share common IDs'. 

But I found that I could not perform well for 'select by attribute' in the joined table.

I tried to select polygons of specific attributes, but the result showed wrong selections. 

Is there an workaround to solve that issue?

Thanks,

Min

Reply
0 Kudos
3 Replies
Esri Contributor

Hi Min,

Could you provide some more information?

Screenshots would be great but also could include any information related to the specific software you are using as well as the layers you have joined?

Alber

Reply
0 Kudos
New Contributor II

Thanks, Albertus

I've solved that issue. I used Arcmap 10.7 while using gssurgo data of USDA (soil data)

Each original shape soil survey database. Each shape/raster file for U.S state has its own attribute tables in the database.

The problem was my AOI is boundary area of multiple U.S states, so I had to merge them into one. 

The merged table (of original shape file) was joined with its attribute tables. But the Arcmap could not select rows with given attributes.

So I used Join Field function (Data Management tools>Joins>Join Field) for original shape files.

After that a merged/clipped shape file worked well.

Thanks for your advice. I will add more explanation to clarify in next time.

Min

Esri Contributor

Glad you were able to get this sorted.

Reply
0 Kudos