topic Re: Auto populate attribute field from intersecting feature (polygon field to point field) in ArcGIS Pro Questions

Auto populate attribute field from intersecting feature (polygon field to point field)

BDU_RyanChittenden — Fri, 20 Aug 2021 05:39:27 GMT

Hi, I am using attribute rule to auto populate an attribute field from a polygon feature to an attribute field in a point feature.

I have suppression repair points with an empty "DPA_AGENCY" Field and a polygon feature that contains the "DPA_AGENCY" information which I want the point "DPA_AGENCY" field to grab from. I've looked up Arcade expressions and I am not even sure I have the right one.

The feature "Suppression_repair_points" the attribute field "DPA_AGENCY"

"Direct_Protection_areas" is the feature I wish to pull info from the "DPA_AGENCY" field

ESRI attribute rule example:

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

JohannesLindner — Fri, 20 Aug 2021 05:48:25 GMT

You found a quite complicated example 🙂

// Calculation rule // Suppression_repair_points, field DPA_AGENCY // Triggers: Insert, Update // optional: // if DPA_AGENCY is already filled, just return its value (do nothing) //if(!IsEmpty($feature.DPA_AGENCY)) { // return $feature.DPA_AGENCY //} // load the polygon fc var dpa_fc = FeatureSetByName($datastore, "database.dataowner.DirectProtection_areas") // intersect the feature with the polyons var dpa_inter = Intersects(dpa_fc, $feature) // if the feature doesn't intersect a dpa polygon, return null if(dpa_inter == null || Count(dpa_inter) == 0) { return null } // grab the first intersecting polygon and return its DPA_AGENCY value return First(dpa_inter).DPA_AGENCY

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

BDU_RyanChittenden — Fri, 20 Aug 2021 06:23:00 GMT

Thank you! Still receiving an error though.

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

JohannesLindner — Fri, 20 Aug 2021 06:30:23 GMT

FeatureSetByName needs the complete name of the feature class.

If you're in a file geodatabase, thats probably just the name of the feature class (DirectProtectionAreas21_2).

If you're in an Enterprise geodatabase, the full name is "DatabaseName.DataownerName.DirectProtectionAreas21_2", where you have to replace DatabaseName and DataownerName.

Browse to the feature class in the catalog to see its full name:

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

BDU_RyanChittenden — Fri, 20 Aug 2021 06:51:18 GMT

it's a file geodatabase.

So I'd replace: "database.dataowner.DirectProtectionAreas21_2"

with: "DatabaseName.DataownerName.DirectProtectionAreas21_2"

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

JohannesLindner — Fri, 20 Aug 2021 06:54:04 GMT

var dpa_fc = FeatureSetByName($datastore, "DirectProtectionAreas21_2")

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

BDU_RyanChittenden — Fri, 20 Aug 2021 07:14:52 GMT

expression valid this time but: ERROR 002717: Invalid Arcade expression, Arcade error: Table not found DirectProtectionAreas21_2, Script line: 12 [DirectProtectionAreas21_2]
Failed to execute (AddAttributeRule).

// Calculation rule
// Suppression_repair_points, field DPA_AGENCY
// Triggers: Insert, Update

// optional:
// if DPA_AGENCY is already filled, just return its value (do nothing)
//if(!IsEmpty($feature.DPA_AGENCY)) {
// return $feature.DPA_AGENCY
//}

// load the polygon fc
var dpa_fc = FeatureSetByName($datastore, "DirectProtectionAreas21_2")

// intersect the feature with the polyons
var dpa_inter = Intersects(dpa_fc, $feature)

// if the feature doesn't intersect a dpa polygon, return null
if(dpa_inter == null || Count(dpa_inter) == 0) {
return null
}

// grab the first intersecting polygon and return its DPA_AGENCY value
return First(dpa_inter).DPA_AGENCY

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

BDU_RyanChittenden — Fri, 20 Aug 2021 22:59:56 GMT

What is dpa_inter and dpa_fc?

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

BDU_RyanChittenden — Sun, 22 Aug 2021 02:00:09 GMT

ERROR: INVALID EXPRESSION ERROR ON LINE 12 Table not found DirectProtectionAreas21_2

// Calculation rule
// Suppression_repair_points, field DPA_AGENCY
// Triggers: Insert, Update

// optional:
// if DPA_AGENCY is already filled, just return its value (do nothing)
//if(!IsEmpty($feature.DPA_AGENCY)) {
// return $feature.DPA_AGENCY
//}

// load the polygon fc
var dpa_fc = FeatureSetByName($datastore, "database.dataowner.DirectProtection_areas")

// intersect the feature with the polyons
var dpa_inter = Intersects(dpa_fc, $feature)

// if the feature doesn't intersect a dpa polygon, return null
if(dpa_inter == null || Count(dpa_inter) == 0) {
return null
}

// grab the first intersecting polygon and return its DPA_AGENCY value
return First(dpa_inter).DPA_AGENCY

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

BDU_RyanChittenden — Sun, 22 Aug 2021 05:36:43 GMT

var zones = FeatureSetByName($datastore,"DirectProtectionAreas21",["DPA_GROUP"],true)

var intersectingZones = Intersects(zones, Geometry($feature))

var matchedZone = First(intersectingZones)

return IIf(IsEmpty(matchedZone), null, matchedZone.DPA_GROUP);

Re: Auto populate attribute field from intersecting feature (polygon field to point field)

Ron_S1 — Wed, 06 Nov 2024 16:47:30 GMT

Hi,

I have been having the same issue whenever I try to use a feature class from an enterprise geodatabase, I copied the exact full name of the layer, but I keep getting an error "Table not found", it does work perfectly fine if I just use a layer from a file geodatabase.

Is there an extra step or modification that I need to do? This is my script:

var zones = FeatureSetByName($datastore,"pgsdeprod.prod_projects.IHS_Fields
",["FIELD_NAME"],true)

var intersectingZones = Intersects(zones, Geometry($feature))

var matchedZone = First(intersectingZones)

return IIf(IsEmpty(matchedZone), "other", matchedZone.FIELD_NAME);

Thank you!