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; } } }

SQL Query in labeling

ELTerrell

Hi all,

I have 10 cities within a county and I'm trying to label 9 of them. I thought an SQL query in the label feature would eliminate the one I didn't want labeled. I thought it should look something like this "Name" = 'New York' AND 'Los Angeles' and just leave out the one I don't want?

Vind meer berichten getagd met

Accepted answers

mvolz47

Does ArcGIS Explorer Desktop have classes for labels like ArcMap does? If so, you can add a SQL Query there, that should allow either the syntax:

"Name" = 'New York' OR "Name" = 'Los Angeles'

or

"Name" in ('New York', 'Los Angeles')

All comments

EllenBryson2

Michael made a great suggestion with the IN function.

If you're wondering how to fix your original query, here's the solution.

"Name" = 'New York' OR "Name" = 'Los Angeles'

You need to mention the field name twice. And in this context I think the OR is what you want.

ELTerrell

Thanks Ben! I'll try that next.

BenVan_Kesteren1

"Name" in ('New York', 'Los Angeles')

This is the SQL I use often as sometimes the list can get quite long, and writing "Name" = xyz OR "Name" = xyz OR... over and over gets tedious 😄

ELTerrell

That worked...I just needed the second 'Name' instead of Name = New York OR Los Angeles.

mvolz47

ELTerrell

I tried that, I still get an error message. I also tried IS. I can only think that maybe it has something to do with the quotations?

mvolz47

How about OR instead of AND?

ELTerrell

So I found a solution although it wasn't the one I anticipated. I "added label classes from symbology categories" after having deleted the one city from symbology.

However, I'm thinking there has to be a way to label those using SQL query.

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.