nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

County and State Isolation

TaylorBoles1

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’

Vind meer berichten getagd met

Analysis

Accepted answers

JayantaPoddar

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'

All comments

JayantaPoddar

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'

TaylorBoles1

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! 🙂

Problem.jpg

JayantaPoddar

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'

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.