topic Re: Attribute Rules: Update Attributes in ArcGIS Pro Questions

Attribute Rules: Update Attributes

Anonymous User — Wed, 16 Sep 2020 20:42:06 GMT

I have old features that I am adding via copy and paste to a current production feature class that has attribute rules enabled. I am having trouble figuring out a way to update "at will" specific fields that are null for the old features being brought in.

The attribute rule for the current feature populates point data fields with data from a polygon boundary vi INTERSECT, but when I perform the copy and past the fields remain null and are not updated via the attribute rule.

I know with attribute assistant you can "Run Change Rules for Selected Features" is there a simple way to do this with attribute rules or mimics the rule using ARCADE or Python in the field calculator as I attempted below?

Re: Attribute Rules: Update Attributes

XanderBakker — Thu, 17 Sep 2020 14:03:05 GMT

Hi Brian Acheff ,

The error message is indicating that you cannot use the $map global variable in a field calculation of an attribute calculation rule. You should use the $datastore instead. See Profiles | ArcGIS for Developers for more information on what global variables and functions are available in each profile.

Re: Attribute Rules: Update Attributes

Anonymous User — Thu, 17 Sep 2020 14:41:56 GMT

Xander Bakker‌

Thank you for noticing my simple mistake.

When I use $datastore the expression check out, but returns nothing.

I noticed the $editcontext.editType global for attribute rules and the following expression:

if ($editContext.editType == "UPDATE")

would this need to be inserted into the expression or would I need to create a rules using this and then when field calculating call out the if ($editContext.editType == "UPDATE") ?

Re: Attribute Rules: Update Attributes

Anonymous User — Thu, 17 Sep 2020 16:01:42 GMT

Xander Bakker‌

This checks out, but returns this error, would you be able to point me in the correct direction or if I am headed in the correct direction with this script?

Re: Attribute Rules: Update Attributes

JoeBorgione — Thu, 17 Sep 2020 16:48:37 GMT

Xander Bakker‌ helped me out here: https://community.esri.com/thread/259345-attribute-rule-for-intersecting-layer when I had a problem with updating points or lines with underlying feature layers.

Re: Attribute Rules: Update Attributes

Anonymous User — Thu, 17 Sep 2020 17:22:02 GMT

Joe Borgione & Xander Bakker,

Thank you for you help.

Joe's forward of his trouble with this showed me to Xander's remark to not use $feature."field name" and instead use $feature["field name"].

The expression was not done as an attribute rule, but rather as a geoprocessing field calculation, though I did disable then re-enable the attribute rule associated with Intersect, so I cannot be sure if the that helped at all.

This is the correct expression:

‌

Re: Attribute Rules: Update Attributes

XanderBakker — Thu, 17 Sep 2020 17:33:38 GMT

Hi Brian Acheff ,

Let me respond to this comment first. When you return the First record of an intersect, you are returning an entire record. Not only the MACOG_ID value even though it is the only attribute you are requesting. You would have to query the actual field to get the value (adding for instance ["MACOG_ID"] at the end of the line).

Re: Attribute Rules: Update Attributes

XanderBakker — Thu, 17 Sep 2020 17:38:31 GMT

Hi Brian Acheff ,

In this screenshot on line 13 you are using as update the text 'MACOG_ID'. This should be updates array you created before. See algo the example expression called "Edit another feature class with a calculation rule." in this link: Attribute rule script expression examples—ArcGIS Pro | Documentation

Re: Attribute Rules: Update Attributes

Anonymous User — Thu, 17 Sep 2020 17:42:28 GMT

Xander Bakker‌,

I am confused by your reply, used the expression to field calculate the MACOG_ID field in the HandHold feature class (the $feature) that intersects the MACOG_Intersections_Poly.

Could you elaborate on your reply?

Re: Attribute Rules: Update Attributes

XanderBakker — Sat, 11 Dec 2021 16:56:26 GMT

Hi Brian.Acheff ,

Maybe it is best to show what I mean it the expression:

if ($feature["MACOG_ID"] == null) {
    // first returns a feature
    var feat = First(Intersects(FeatureSetByName($datastore, "MACOG_Intersections_Poly", ["MACOG_ID"]), $feature));
    // access the attribute to return the actual value
    return feat["MACOG_ID"];
}‍‍‍‍‍‍

Re: Attribute Rules: Update Attributes

Anonymous User — Thu, 17 Sep 2020 18:05:08 GMT

Xander Bakker‌,

Ahhhhh I now get why it is important to format my ARCADE syntax using VAR and not just throwing together a sandwich of functions. They are not one in the same but different

I am learning to overcome this type of bad habit in Python scripting & expressions, so thank you for your critique!

Re: Attribute Rules: Update Attributes

Anonymous User — Fri, 18 Sep 2020 14:31:33 GMT

Xander Bakker‌,

Am attempting you continue the task and am running into this error.

Re: Attribute Rules: Update Attributes

MikeMillerGIS — Fri, 18 Sep 2020 14:49:58 GMT

If you have applied the attribute rule to the class, and it is set for update, you can trigger an update by simply calc'ing a field to itself.

Re: Attribute Rules: Update Attributes

JoeBorgione — Fri, 18 Sep 2020 14:54:40 GMT

That's a cool trick. Thanks Michael Miller!

Re: Attribute Rules: Update Attributes

XanderBakker — Sat, 11 Dec 2021 16:56:29 GMT

Hi Brian.Acheff ;

The error you are receiving may be caused by not having a result in the intersection. Can you try this?

// don't do any intersects if you are not going to use it
if (IsEmpty($feature.MACOD_ID)) {
    // intersect the data (don't retrieve the geometry when you don't need it)
    var fs = Intersects(FeatureSetByName($datastore, "MACOG_Intersections_Poly", ["MACOG_ID"], False), $feature);
    // count the resulting features
    var cnt = Count(fs);
    // don't try and access the first feature if there are no features
    if (cnt > 0) {
        // get the first feature and return the MACOG_ID
        var feat = First(fs);
        return feat["MACOG_ID"];
    }
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Attribute Rules: Update Attributes

JoeBorgione — Fri, 18 Sep 2020 15:31:36 GMT

For intersecting underlying features, that's what works for me.

Re: Attribute Rules: Update Attributes

Anonymous User — Fri, 18 Sep 2020 15:47:00 GMT

Xander Bakker‌,

It checks out, but returns Null