Field Calculator — Get attribute of touching feature from different FC

Bud

I have a POINTS FC and a POLYGONS FC.

In POINTS, I want to use the field calculator to populate a POINTS.ASSET_ID field with the ASSET_IDs from POLYGONS, where a point touches a polygon. The spatial relationship is 1:1.

In other words, I want to get the ASSET_ID from the intersecting polygon and use it to populate the ASSET_ID field in the point.

I want to do this all within a simple field calculation, not using multiple GP tools and joins.

I would also like this to work for cases where the ID fields don’t have the same name.

williamscraigm

You can do this with Arcade in Calculate Field. Given the names you have above and with the Field Name of the calculate field tool being ASSET_ID on the Points layer:

var polygons = FeatureSetByName($datastore, "POLYGONS",['ASSET_ID'], true);
var polygonFeature = First(Intersects(polygons, $feature));
if (!IsEmpty(polygonFeature))
{
  return DefaultValue(polygonFeature, 'ASSET_ID', "9999");
}
else {
  return "9999";
}