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

Filter Options - similar to SQL "in"

SaraMoulton1

I am creating a map in AGO in which I would like to show only 4 types of sitetypes in 7 towns.
(using this dataset: https://maps.vcgi.vermont.gov/arcgis/rest/services/EGC_services/OPENDATA_VCGI_EMERGENCY_SP_NOCACHE_v1/MapServer/29)

In ArcMap, I am able to filter the dataset using this query:
"TOWNNAME" IN ('TOWN1','TOWN2','TOWN3','TOWN4','TOWN5','TOWN6','TOWN7') and "SITETYPE" IN ('SINGLE FAMILY DWELLING', 'SEASONAL HOME', 'MOBILE HOME', 'MULTI-FAMILY DWELLING')

But I am finding it awkward to replicate this in AGO.
Below is a screen shot of how it is starting out, but it is going to be a laborious process to get all the towns and sitetypes accounted for in the filter.

Is there an easier way to replicate the SQL query in AGO?

Trouver plus de publications taguées avec

Accepted answers

SaraMoulton1

I went around and around on it for a bit, but I got the combination you were trying to show. Here is what I ended up with and it is working.

Top of the Edit tab dialog

Middle of the Edit tab dialog

Thank you!

All comments

Katie_Clark

Michael,

If I understood the post correctly, that's what the OP did in ArcMap and it worked fine, but the ArcGIS Online web map filtering system is set up a little differently. Based on the drop down options (is, is not, starts with, ends with, contains, does not contain, is blank, is not blank) I'm not sure how you would implement an IN statement.

I could be wrong though? I know there is still much that I have to learn. If you know how to do this in ArcGIS Online, that would really be a help to both me and the OP!

MikeVolz

It worked but wouldn't an In statement make it cleaner and simpler (KISS)?

Katie_Clark

Yup, exactly. Glad it worked for you!

SaraMoulton1

I went around and around on it for a bit, but I got the combination you were trying to show. Here is what I ended up with and it is working.

Top of the Edit tab dialog

Middle of the Edit tab dialog

Thank you!

Katie_Clark

The reason the first one you tried didn't return any results is because it looks like it's set up as an "And" statement. You want to make sure that the word "or" shows up in the view. Example:

This is what the edit view looks like for that:

What does your edit view look like?

SaraMoulton1

Link to dataset: Layer: VT E911 Site Locations (ID: 29)

I tried using Sets, but didn't get the results I needed.

This try returned no records:

This one returned too many (included data outside of Brattleboro):

I couldn't see how to set up the selection set differently.

Katie_Clark

The link you provided appears to be broken so I wasn't able to look at the dataset. However, I think you could you achieve this in AGO using sets. This will group the criteria.

So under the edit tab, check "add set". For the dropdown of the set, choose "Any of the following expressions in this set are true". This creates "OR" statements. You would have a set for the town name and the housing type.

Does that achieve what you are looking for?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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