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; } } }

Attribute Rules: Copy parcel number to address point when new address point created?

avonmoos

I need assistance building an expression which would copy the parcel number attribute from our parcel layer to the parcel attribute in our address point layer when creating a new one. This would be based on the parcel that the address point being created sits on.

Vind meer berichten getagd met

Accepted answers

JohannesLindner

Create a Calculation Attribute Rule for your point feature class (SiteAddress).

As field for the rule, choose "BaseParcel"

As triggers, choose "Insert".

As expression, use this:

var parcels = FeatureSetByName($datastore, "SurveyParcel", ["ParcelID"], false)
var intersecting_parcel = First(Intersects(parcels, $feature))
if(intersecting_parcel == null) {
    return null
}
return intersecting_parcel.ParcelID

This should work if you're working in a file geodatabase. If you work in an Enterprise geodatabase, you have to replace "SurveyParcel" in line 1 with the complete name of the feature class ("Databasename.Dataowner.SurveyParcel").

All comments

JohannesLindner

As you're asking this in the ArcGIS Pro community, I'm assuming you mean Attribute Rules, not Assistant.

Introduction to attribute rules—ArcGIS Pro | Documentation

If you indeed mean Assistant, I'll move your question to the ArcMap community.

// Attribute Rule on the Address Points
// triggers: Insert

// load the parcels
var parcels = FeatureSetByName($datastore, "Databasename.Dataowner.Parcels", ["ParcelNumber"], false)

// intersect with the new point
var intersecting_parcel = First(Intersects(parcels, $feature))

// return null if no parcel was intersected
if(intersecting_parcel == null) {
    return null
}

// else return that parcel's number
return intersecting_parcel.ParcelNumber

avonmoos

Thank you for the quick response! I'm pretty green when it comes to Arcade, below are the features and fields I will be using. Where in your code do I place these in the variables?

$feature.SurveyParcel

and the parcel ID field is called ParcelID

$feature.SiteAddress

and the parcel ID field is called BaseParcel

JohannesLindner

Create a Calculation Attribute Rule for your point feature class (SiteAddress).

As field for the rule, choose "BaseParcel"

As triggers, choose "Insert".

As expression, use this:

var parcels = FeatureSetByName($datastore, "SurveyParcel", ["ParcelID"], false)
var intersecting_parcel = First(Intersects(parcels, $feature))
if(intersecting_parcel == null) {
    return null
}
return intersecting_parcel.ParcelID

avonmoos

Thank you 👍

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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