Using Attribute Rules to calculate fields from intersecting polygons

TINATHOMPSON

We have recently made the move to ArcGIS Pro for everything except our 911 Addressing.  We are searching for an Attribute rule that would allow us to take attribute data from several polygon layers and put them into our address layer.  In other words, we want to enter a new address point and have the attribute rule to go out and find certain data (ESN, Community, Senate, House, JP District, etc.) and enter that into our Address layer.  We were able to do this in ArcGIS Desktop using a script but that script will not work in Attribute rules.  Unfortunately, I do not understand Arcade and I'm pretty limited with vbscript.  I'm hoping that there is someone out there that has built something like this that would share it with me.

 

Thank You all in advance.

JoeBorgione

The trick with getting values from underlying polygon features is those features have to reside in the same "datastore" as your points.  The datastore is nothing more than than the database, be it FGDB or EGDB that holds your data. It's a limitation of Arcade.  However, here is a rule that I apply to get underlying zip code onto a site address point: 

 

var zip = FeatureSetByName($datastore,"MSD.SLCOMSD.ZipcodesMSD",["ZIP_MOD_ID"], true)
var intersectLayer = Intersects(zip, Geometry($feature))
if (Count(intersectLayer) > 0) {
    var layer = First(intersectLayer);
    return layer.ZIP_MOD_ID;    
} else {
    return null;
}

 

Here I'm extracting the value of the field ZIP_MOD_ID from the ZipcodesMSD layer in our SDE database.  The if statement makes sure there is an intersecting layer to the point; @XanderBakker guided me through this one so all my intersecting rules check for that first.