I need to do something that seems really simple. I need to filter out a bunch of records from the Sewer Mains layer based on their facility IDs? I can't use the Filter expression option though because the dataset is too big and basically freezes the software when I attempt to open the data set to add facility IDs to exclude. Is there a way to do this using Arcade?
The end goal of what I'm after is for the layer to be displayed without the records that I specify in the list. A SQL expression to better understand this would like something like this:
FACILITY NOT IN ('11111', '22222', '33333', '444444')
I don't care if I have to get there in a round about way using Arcade. What I do have going is there are 3 layers of Sewer Mains that have some overlap in the unique Id's and I thought it might be possible to use an intersect or something to filter out records from one layer if something simpler will not work.
Thanks for any help in advance
Mark