topic Re: Chasing my tail with Arcade/Attribute Rules in ArcGIS Pro Questions

Chasing my tail with Arcade/Attribute Rules

JoeBorgione — Mon, 23 Mar 2020 17:08:00 GMT

I am testing the feasibility of the Address Management Solution for my agency. There are a number of attribute rules embedded upon the feature classes that populate fields upon editing. For example, the site address point feature class concatenates address elements (pre dir, house num, street name etc) into the full address field. Easy enough.

However, I'd like to populate attributes based on spatial location: add a new point and be able to populate city and zip from underlying coincident polygons: if the new point falls within the city of Holladay (municipality layer) and 84124 (zip code layer) I want the appropriate fields in the point populated.

I've done this sort of thing using attribute assistant, and I could make the calculations using arcpy, but with Arcade the scripting language of choice for Attributes Rules, I'm wallowing in the trough of the the learning curve.

Re: Chasing my tail with Arcade/Attribute Rules

JakeSkinner — Mon, 23 Mar 2020 17:44:16 GMT

Hey Joe,

I haven't used Attribute Rules, but take a look at the following blog on how to do this using Arcade in a web map:

https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2018/12/10/overlapping-features-in-pop-ups-quick-introduction-to-using-featuresets-with-arcade

This may give you the correct expression you're looking for.

Re: Chasing my tail with Arcade/Attribute Rules

DanPatterson_Retired — Mon, 23 Mar 2020 17:49:53 GMT

Arcade ehh? couple of years to go Joe

Re: Chasing my tail with Arcade/Attribute Rules

JoeBorgione — Mon, 23 Mar 2020 17:54:28 GMT

Thanks Jake; I've got a Pro project open right now following along what Kelly Gerrow‌ describes. There is also a blog entry by Xander Bakker‌ I'll follow along too. These are giving me exposure to the Arcade logic.

Re: Chasing my tail with Arcade/Attribute Rules

JoeBorgione — Mon, 23 Mar 2020 18:02:45 GMT

I'm hoping!

Re: Chasing my tail with Arcade/Attribute Rules

JakeSkinner — Sun, 12 Dec 2021 03:48:50 GMT

Hey Joe,

I was able to get this to work. I tested adding a county name to a point feature. The county name is stored in a field called NAME. The county feature class is in the same geodatabase as the point feature class, and the feature class is named Counties. Here was the expression I used:

var countyBoundary =  FeatureSetByName($datastore, "Counties", ["NAME"], true)
var intersectLayer = Intersects(countyBoundary, Geometry($feature))
var layer = First (intersectLayer)
return layer.NAME‍‍‍‍

Re: Chasing my tail with Arcade/Attribute Rules

JoeBorgione — Mon, 23 Mar 2020 19:59:36 GMT

Awesome! Thanks Jake! I'm right in the middle of not only the covid19 mojo like everyone else, but we had a significant earthquake here in the Salt Lake Valley; I'm working from home doing damage assessment database work and I'm getting tugged in multiple directions at once. I think that's new normal.

At any rate, I'll give your suggestion a try asap!

Re: Chasing my tail with Arcade/Attribute Rules

JoeBorgione — Mon, 23 Mar 2020 23:22:09 GMT

I was able to get the suggested code from Jake Skinner‌ to work, but I have a question regarding FeatureSetByName() function. I had several different data sources in my ArcGIS Pro map and tried to use $map instead of $datastore and that failed with an error to the effect that $map was not defined.

As I understand it, if one uses $datastore, all the layers one is working with need to be in the same location so for testing I have my points and my municipalities in the same local file gdb; I can now calculate the city name on a new point. Does $map not work in ArcGis Pro 2.5? I'm going to be adding points and right now I don't know where all the layers that I need to use will be coming from, but I'm pretty sure I don't want them in the same Egdb as my address points.

Kelly Gerrow‌

Xander Bakker‌

Re: Chasing my tail with Arcade/Attribute Rules

XanderBakker — Tue, 24 Mar 2020 12:23:06 GMT

Hi Joe Borgione ,

$map works in ArcGIS Pro 2.5, but it won't work in Arcade expressions used for Attribute Rules and Field Calculations (and others). Have a look at Profiles | ArcGIS for Developers which lists all the available profiles where you can apply Arcade expressions and each profile has a table with the Globals that are available in that profile.

Re: Chasing my tail with Arcade/Attribute Rules

JoeBorgione — Tue, 24 Mar 2020 13:48:16 GMT

That's an unfortunate limitation. It seems to me that with services being exploited as data sources, logically we would want $map to work in Pro for calculations and/or attribute rules. Time for an idea's post....

Re: Chasing my tail with Arcade/Attribute Rules

JoeBorgione — Tue, 22 Jun 2021 08:42:36 GMT

Vote early and vote often: https://community.esri.com/ideas/18212