Arcade: Intersect or Filter Two Feature Classes to Populate a Related Table

ArmstKP

I have a table that is related (one to one) to my parks feature class.  It has park amenity fields (benches, pool, kayak_rental, etc.) with a yes or no value.

Intersect option: I want to be able to intersect the parks feature class with our benches feature class and if there is an intersection, write yes or no to the benches field in the related table for that park.

Filter option:  If the park_name field of the parks fc equals the park_name field of the benches fc, return yes to benches field in the related table for that park.

JohannesLindner

// Calculation Attribute Rule in the point fc
// field: empty
// triggers: insert
// exclude from application evaluation

var parks_fc = FeaturesetByName($datastore, "ParksFC")
var parks_table = FeaturesetByName($datastore, "ParksTable")

var park_polygon
// get the park polygon
// by filtering for the park_name attribute
if(!IsEmpty($feature.park_name)) {
    var p_name = $feature.park_name 
    park_polygon = First(Filter(parks_fc, "park_name = @p_name"))
}
// or by intersecting the bench with the parks fc
if(park_polygon == null) {
    park_polygon = First(Intersects($feature, parks_fc))
}
if(park_polygon == null) { return }  // we couldn't find a corresponding park polygon, abort

// get the related table row
var key = park_polygon.KeyField
var park_row = First(Filter(parks_table, "KeyField = <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/301813">@Key</a>"))
if(park_row == null) { return }  // the polygon doesn't have a corresponding table row, abort


// return a dictionary to instruct ArcGIS to update the park table
return {
//    result: attributes: {park_name: park_polygon.park_name}},  // set the bench's park_name field
    edit: [{
        className: "ParksTable",
        updates: [{
            objectID: park_row.OBJECTID,
            attributes: {HasBenches: "Yes"}
        }]
    }]
}

 

Edit lines 6, 7, 12-14, 23, 24, 32, 35 to fit your table and field names.

Further reading for the return dictionary: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/attribute-rule-dictionary-keywords.htm