topic Re: Arcade expression to populate a field from one point layer to another that are on the same line in Attribute Rules Questions

Arcade expression to populate a field from one point layer to another that are on the same line

GIS_geek — Wed, 17 Jan 2024 17:33:30 GMT

Hello,

My organization is moving from Geometric Network to Utility Network and that means we have to move all of our Attribute Assistant methods to Attribute Rules. I was hoping to get assistance on one of them.

We number fire hydrants based on the corresponding valve. Both points are on the same line and that is the only relationship between them. All three features (hydrant, valve, and line) are in the same geodatabase. The attached code I am running comes up with an error mentioning "Invalid expression. Error on line 5. Wrong number of arguments." Hoping to get some help on this.

var valves = FeatureSetByName($datastore, "dwSystemValve"); var hydrants = FeatureSetByName($datastore, "dwHydrant"); var fireLines = FeatureSetByName($datastore, "dwLateralLine"); var intersectingValve = Intersects(valves, fireLines, true); var intersectingHydrant = Intersects(hydrants, fireLines, true); var commonFireLine = Filter(intersectingValve, intersectingHydrant); var valveField = "NUM"; var hydrantField = "NUM"; var result = {}; for (var i in commonFireLine) { var valveValue = commonFireLine[i].attributes[valveField]; var hydrantValue = commonFireLine[i].attributes[hydrantField]; result[valveValue] = hydrantValue; } result

Re: Arcade expression to populate a field from one point layer to another that are on the same line

MikeMillerGIS — Wed, 17 Jan 2024 17:43:08 GMT

Vavles is a featureset, sort like the path to the class on disk. You cannot intersect a featureSet with a featureSet. You need to loop over the features, such as for (var feat in valves)

Re: Arcade expression to populate a field from one point layer to another that are on the same line

MikeMillerGIS — Wed, 17 Jan 2024 17:46:18 GMT

Bigger question, what and when do you want this rule to fire? Is this something you want run on the entire database? Do you want it to run each time you edit a hydrant, or valve, etc?

Re: Arcade expression to populate a field from one point layer to another that are on the same line

GIS_geek — Wed, 17 Jan 2024 17:51:03 GMT

Hi Mike,

I want this to run each time I add or edit a hydrant.

Re: Arcade expression to populate a field from one point layer to another that are on the same line

MikeMillerGIS — Thu, 18 Jan 2024 10:49:48 GMT

Hopefully this gets you closer

Re: Arcade expression to populate a field from one point layer to another that are on the same line

Ed_ — Wed, 17 Jan 2024 20:45:10 GMT

What's going on in line 4 and what's the purpose of loop within a loop?

Re: Arcade expression to populate a field from one point layer to another that are on the same line

GIS_geek — Wed, 17 Jan 2024 22:13:04 GMT

Getting an error, "Invalid expression. Error on line 11. Close parenthesis expected." Not sure why since I see the closed parenthesis in line 14. I am a bit of a novice so not sure what to look for now. I appreciate your time and effort on this @MikeMillerGIS .

Re: Arcade expression to populate a field from one point layer to another that are on the same line

GIS_geek — Wed, 17 Jan 2024 22:22:07 GMT

@Ed_ A lot of this was from other code I found in other forums. I thought applied to what I am trying to accomplish so I was testing it out.

Re: Arcade expression to populate a field from one point layer to another that are on the same line

MikeMillerGIS — Wed, 17 Jan 2024 23:21:14 GMT

I did not format the dictionary correctly on line 11, will fix it tomorrow when back on my PC. Needs a { in front of global I'd and one more } on 14 after the other one.

Re: Arcade expression to populate a field from one point layer to another that are on the same line

MikeMillerGIS — Thu, 18 Jan 2024 10:53:33 GMT

If you are referring to my post, line 4 intersects the hydrant with the lateral lines. As the OP said they want this to run on the hydrant. Is every hydrant connected to only one line? I have no idea, I do not have access to his data, so without that knowledge, the only safe way to code it is loop over all results and find the valves that are connected to each lateral line. Now in reality, hydrants connect to one line, so I could have called First() on the result, but that info was not provided.

Re: Arcade expression to populate a field from one point layer to another that are on the same line

GIS_geek — Thu, 18 Jan 2024 20:18:30 GMT

@MikeMillerGIShydrants are connected to only one line.

Re: Arcade expression to populate a field from one point layer to another that are on the same line

MikeMillerGIS — Thu, 18 Jan 2024 21:03:06 GMT

You can adjust the code to call First then and skip the first loop.

Re: Arcade expression to populate a field from one point layer to another that are on the same line

GIS_geek — Mon, 22 Jan 2024 18:07:57 GMT

Hi Mike,

I updated the code as best as I could as shown below. I am receiving the following error "Invalid expression. Error on line 8. Expected convertable to geometry."

Re: Arcade expression to populate a field from one point layer to another that are on the same line

MikeMillerGIS — Tue, 23 Jan 2024 17:16:45 GMT

this line is trying to intersect two database classes.

var intersecting_valves = Intersects(valves, fireLines);

You need to change that to the first line

var intersecting_valves = Intersects(valves, intersecting_lines );

why did you comment out this?

// valves_to_update = [];

needs to be

var valves_to_update = [];