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

When will Arcade get more useful, esp with FeatureSet?

dougbrowning

Still wish there was a dedicated Arcade board. It is not just AGOL anymore. Anyway.

I have been using Arcade a ton. Lots of useful stuff. Most of my use cases use the FeatureSet functions. Two biggest uses are grabbing info or a summary between parents and children in relationship classes and aggerating stats of Points in Polygons. These work great and I can do some cool stuff.

Unfortunately only being able to use FeatureSet in a popup is really limiting what I can do for the user. While popups are great the times a user will be clicking on each say polygon one by one is pretty slim.

The problem is you cannot really do anything with the expression except look at it.

Lets say I have a calculation that does an avg of Bare Ground across all points in a polygon. I want symbolize the polygons say red to green based on the Avg - nope can't. Ok how about filter the map to show only Avgs under 40% - nope can't. Ok I will open the attribute table and browse or sort - nope can't do that either. Ok how about a label that shows good/bad - nope can't do that. User finally says forget it I will export the data - nope Arcade goes away!

So users come back to me and say this is pretty and all but I cant actually do anything with it.

How are people dealing with this? Again I love Arcade and its powerful but I am having a hard time finding good workflows to actually do anything with them.

I understand that FeatureSet can get slow and that will cause many of these to be painful. I have suggested things like adding a where clause to the FeatureSet calls that would speed them up. I have created a Arc Idea to calc the Arcade values on export. Labels I think would be ok. Filter I really thought would work but no FeatureSet is blocked.

Will any of these be opened up to FeatureSet at some point? Any suggestions or tricks people have used?

Thank for any insight

Najděte více příspěvků označených jako

Arcade

Accepted answers

All comments

jcarlson

I remember your post about a "where" clause, and discovered something interesting on that point. When you bring in a FeatureSet and then subsequently apply a Filter or Instersects function on it, your browser will actually submit a query to the original feature service, not the in-memory set you've requested.

Say I request a FeatureSet and ask for no fields, no geometry. I can actually still use Filter against any field in the service, and run a spatial intersection against the layer, because those happen on the server side.

But to your larger question of how to actually use Arcade for more advanced things, I agree that its potentially use for things people want, like symbology, seems teasingly out of reach to those particular Arcade profiles.

For us, by far the most interesting and most useful application of Arcade has been in Dashboards, by means of Data Expressions. While it still can't translate to the map, we can still do things there that are impossible anywhere else in the off-the-shelf tools available to us.

So maybe the symbology itself can't change based on an ad-hoc field, but we can use a Data Expression to get the Dashboard to treat our calculated fields as though they were "baked in". Here's an example of using a List with a Data Expression.

Esri's census features have their own "diversity index", but I wanted the Simpson's Index of Diversity, which wasn't in the layer. So I used a Data Expression to create it as a field, and was then able to alter the color on my List using the calculated index.

Not as good as changing the symbology itself, but it's at least something.

Would be curious to see how others answer this question!

dougbrowning

Thanks @jcarlson I already started on the dashboard to do just that. Having other issues with dashboards though. When building a FeatureSet in the data expression I am trying to use geometry but it says that Geometry is not a valid function for some reason? Like umm its right there dude.

I have also noticed what you said on Filter. I can even say return geo false then load that into a Intersects and somehow it still works. That means more calls like you said which may explain why its so dang slow. This seems like it would be super inefficient right?

I may try and go by to ByRelationship it just has so many bugs in it. Testing it does not seem much faster. I wonder if it calls them all then filters but that would be silly right.

thanks

jcarlson

I actually find that those additional calls make for better performance, because I can get a FeatureSet with, say, 2 fields and no geometry, but then subset that using functions that access any number of fields and geometry. It puts the work on the server, as opposed to some in-memory FeatureSet in my browser. The FeatureSet(s) going to and from the server are comparatively tiny when it's only a couple of fields, as opposed to requesting polylines or polygons[o

Making multiple small requests = lower net I/O = faster execution.

I'd be curious to see the expression you're attempting. I don't seem to run into the same issues.

AlfredBaldenweck

I've been feeling this way for a bit, too.

Even just in a normal Pro session, there are tons of things that , like Josh says, are teasingly out of reach.

Particularly, as you say, using FeatureSet outside of popups. We have all these cool things that could work (I wanted to symbolize by whether or not some points were within 3 miles of some turbines), but most profiles are completely agnostic to things other than the feature class itself.

Arcade is great at getting things dynamically. I'd love to be able to use it for quick and dirty visualization without having to make a new layer or a new feature class, but right now it just can't do what I want. I love it for field calculations and pop-ups, but visualization needs a lot more work.

Another use case I noticed last week was this post: Re: Symbolize top 10 attributes by count dynamical... - Esri Community

Why don't we have a $view global that's not just for view scale? Let us adjust symbology by what's in the view, a la DRA for raster datasets.

I second the Arcade Board idea; I'm never sure where to ask questions for it.

dougbrowning

Answered in the other post but I have some code where I want to make one FeatureSet call with one field then I loop that in a Filter. If Filter does a new call for every one of the 5,000 items in my loop that has to be slower than using in memory. On our VPN all these calls actually make a big speed difference. I do not see why it would have to go back to the server on that. User clicks popup, it does one call, then a bunch of filters, then display. Why more calls to the server?

thanks

JohannesLindner

In regards to an Arcade community, please lend your support to this idea: Arcade Community - Esri Community

In regards to making featuresets available in the labeling and visualization profile: This would be great, but it's probably not coming any time soon. Post from February 2022:

There are no plans to extend the labeling or visualization profiles to include FeatureSet functionality for performance reasons. Label and visualization expressions are executed on a per-feature basis and a feature set query executed per-feature would slow down draw performance.
For this use-case the recommendation is to use a calculate attribute rule where the script is executed at data creation or update time rather than once per draw loop. FeatureSetByName can be used to perform FeatureSet lookups with any other dataset in the same workspace. Cross-database cases are not currently possible but an idea to support that for future workflows could be submitted for conversation.

dougbrowning

We have the dashboard now with a data expression as you posted. It turns rows red if a matching error report is found in the Error form layer. And now with the Geometry(f) part right it will even change on zoom which is sweet. thanks on that.

Do you know how to get it to use the same symbology as the map in the list? It works when its a layer but when it goes to data expression it changes all the symbols to the same symbol. I think it may be the no value symbol from the map.

In the properties all I see is symbol on/off.

Is there a way to say hey use the symbology from over on the map? It is that or we have to recreate it in Ops using a big if statement I guess.

thanks

jcarlson

Yeah, I don't know if the FeatureSet comes in w/ default symbology. According to the REST docs, a Feature can come in with a Symbol property, but I don't recall ever having seen that in Arcade...

A workaround I've used is to use SVG elements and pipe in attributes to them. Like here, I have a list of features and I wanted graduated symbols in the List.

I had to use Advanced Formatting to scale the attribute to a pixel size that made sense, but I was satisfied with the result. Though a bit tedious, you could find SVG versions of the symbols you like, then pipe those into an expression with When(class_a, "svg string", class_b, "other svg string"...)

dougbrowning

Most of my stuff is using FeatureSet and intersects with a Polygon and points. Hard to tell if attribute rules can handle that yet. Also these go across databases for sure. Some I use Esri layers even. Like summarizes our data points inside HUCs from Living Atlas. So still wont work it sounds like from your text. But for now I am AGOL which has no attribute rules yet anyway.

Bummer. I still think if they could speed up FeatureSet it could work.

thanks

dougbrowning

@jcarlson Have you noticed if using FeatureSetByRelationshipName is faster? In theory you would think it does the query by key server side and just returns the one record I need.

I was skipping FeatureSetByRelationshipName since it had bugs but seems to work on my data.

Should be faster than this right?

var sql = "PlotKey = '" + $feature.PlotKey + "'";
var tbl = Filter(FeatureSetByName($map,"Soil Stability"), sql);

I tested but have not seem much difference yet.

thanks

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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