nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Copy values automatically between two feature classes

Raj-Chavada

We have two feature classes in enterprise geodatabase (SQL Server). Let’s say - feature class (FC) X. FC Y. They are participating in a relationship class (1 – m). FC X is origin and FC Y is destination.

We are using ArcGIS Pro 2.7.

There is requirement to auto populate some common fields between FC X and FC Y one it is populated in FC X (origin). Is this possible to set it up using out of box solution (e.g. attribute rule – custom arcade expression calculating/copying values from FC X to FC Y based on the relationship class)

Any feedback related to developing a technical solution closely relating to this requirement will be appreciated.

Encuentra más publicaciones etiquetadas con

Enterprise geodatabase

Accepted answers

JohannesLindner

Seems like you don't find any matches in line 8. When you call First() on an empty featureset, the result will be null (line9).

if(matchfeature != null) {
  return matchfeature.TECH_REV
}
return null

All comments

Eduardo_Fernandez_EsriAu

Hello Raj

An attribute rule should do the trick (specifically, an immediate calculation) with Arcade expression

Calculation attribute rules—ArcGIS Pro | Documentation

What exactly do you want to copy across into FCY ( for example, it is just to copy text A, concatenate A and B or do a numerical calculation between A+B) and is there any spatial operations that would trigger this event? For example, I draw a new point (an asset) within a polygon ( a park), update Address of asset based on Park Address field? This influences the arcade expression and configuration of the attribute rule.

Here are some examples - Attribute rule script expression examples—ArcGIS Pro | Documentation

Have a look at the examples "Mark another feature as requiring evaluation" and "Edit another feature class"

Hope this helps

Cheers Ed

Raj-Chavada

Thanks for your reply and sharing documentation on the same, Ed! Yes, basically, I want to copy values from X to Y based on common ID.

FC X = Polygon (project development)

FC Y = Line (sewer upgrades)

After reading few technical blogs - (https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/attribute-rules-and-group-templates/ , https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/advanced-gdb-attribute-rules-editing-external-features-with-attribute-rules/) , with my limited knowledge of Arccade expression language I build following logic but running into issue with line 12.

Here is the expression that I came with so far for FC Y to copy values for TECH_REV from FC X based on common ID - DBNUMBER. After user draws lines for sewer upgrades and populate the DBNUMBER, I want this rule to fire up and get the value for TECH_REV from FC X.

//s1 - get features from projects developments feature class
var origin = FeatureSetByName($datastore, "Project_Developments", ["DBNUMBER","TECH_REV"], false);

//s2 - get common ID from newly added feature
var dbnumber = $feature.DBNUMBER;

// s3 - filter feature based on common ID
var match = Filter(origin, "DBNUMBER = @dbnumber");
var matchfeature = first(match);

// s4 - update TECH_REV field in sewer upgrades
return matchfeature.TECH_REV;

JohannesLindner

Seems like you don't find any matches in line 8. When you call First() on an empty featureset, the result will be null (line9).

if(matchfeature != null) {
  return matchfeature.TECH_REV
}
return null

Raj-Chavada

Here is the complete and working script :

//s1 - get features from projects developments feature class
var origin = FeatureSetByName($datastore, "PROJECT_DEVELOPMENTS", ["DBNUMBER","TECH_REV", "CONS_Q", "CONS_YR", "CONS_DUR"], false);

//s2 - get common ID from newly added feature
var dbnumber = $feature.DBNUMBER;

// s3 - filter feature based on common ID
var match = Filter(origin, "DBNUMBER = @dbnumber");
var matchfeature = first(match);

// s4 - update TECH_REV, EST_OCC_QTR, EST_OCC_YR, EST_CON_DUR field in sewer upgrades
if (matchfeature != null) {
return {
    "result" : {
        "attributes" : {
              "EST_OCC_QTR" : matchfeature.CONS_Q,
              "EST_OCC_YR"  : matchfeature.CONS_YR,
              "EST_CON_DUR" : matchfeature.CONS_DUR,
              "TECH_REV"    : matchfeature.TECH_REV
       }
}
}
}

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.