topic Re: County and State Isolation in ArcGIS Pro Questions

County and State Isolation

TaylorBoles1 — Mon, 06 Dec 2021 20:23:56 GMT

Hello.

I am trying to select certain counties from a few states using the select by attribute tool. I am using census data. I have selected the counties that I want by name, but the problem I am running into is that I do not know how to specify which state I want certain counties selected from. Most county names are unoriginal. I have been trying to go through my attribute table and take out the counties from states that I do not need, but I am wondering if there is an easier way to do this like a script I could write. I tried to write WHERE name (county name) <> whatever county I need OR <> the state fip code that corresponds with it but my expression was no valid. Thanks for you help.

Here's an example of the code I was using in particular:

NAME <> 'Angelina' Or STATEFP <> ‘48’

Re: County and State Isolation

JayantaPoddar — Mon, 06 Dec 2021 21:06:50 GMT

Don't use <> operator for text. Instead use = for single value and IN for multiple values. Also use AND gate for both the arguments to be true. An example is given below (I used County boundaries layer available in Living Atlas).

NAME IN ('Angelina', 'Galveston', 'Garza') AND STATE_FIPS= '48'

Re: County and State Isolation

TaylorBoles1 — Tue, 07 Dec 2021 16:55:36 GMT

Hello,

I am still having trouble with that expression. I even changed my source layer to the one you are using to try to fix it. I have attached an image of the error I am getting. Thank you! 🙂

Re: County and State Isolation

JayantaPoddar — Tue, 07 Dec 2021 17:48:56 GMT

The quotes look odd. Please ensure you are using the straight quotes (refer my example above).

In my keyboard, it's the key next to Enter Key. Here check this out.

NAME IN ('Angelina', 'Hardin', 'Jasper', 'Liberty', 'Nacogdoches', 'Polk', 'Sabine', 'San Augustine', 'Shelby', 'Tyler') AND STATE_FIPS = '48'