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

Pull data from polygon feature to point feature class

AlexP_

Hello,

I am not sure if I am in the right group. I have AGOL web app, arcgis pro 2.7.1, sde, feature service and map service arcgis server. I have a staff as an editor. I am trying to figure out how to set up pull data from polygon feature class parcel number field into point feature class in a parcel number field every time create a new point. If this way doesn't work, please correct me. Please kindly advise. Thank you.

Alex

Trouver plus de publications taguées avec

Enterprise geodatabase

Databases

Data Design

Accepted answers

JoeBorgione

I think on one of your other related posts I suggested an attribute rule. I have one that does exactly what you are looking for:

var parcel = FeatureSetByName($datastore,"MyParcels",["parcel_id"],true)
var intersectLayer = Intersects(parcel, Geometry($feature))
if (Count(intersectLayer) > 0) {
    var layer = First(intersectLayer);
    return layer.parcel_id;    
} else {
    return null;
}

The if/else assures you that if there is not intersecting layer, the rule still fires correctly and does not toss an error.

All comments

JoeBorgione

I think on one of your other related posts I suggested an attribute rule. I have one that does exactly what you are looking for:

var parcel = FeatureSetByName($datastore,"MyParcels",["parcel_id"],true)
var intersectLayer = Intersects(parcel, Geometry($feature))
if (Count(intersectLayer) > 0) {
    var layer = First(intersectLayer);
    return layer.parcel_id;    
} else {
    return null;
}

The if/else assures you that if there is not intersecting layer, the rule still fires correctly and does not toss an error.

AlexP_

Thank you @JoeBorgione

1) Would this still work operate while create a new point feature class on web app builder?

2) is it required GLOBALID?

3) Do I add that attribute rule under new point feature class or under existing polygon feature class?

4) I have a little knowledge with attribute rule. I have existing polygon feature class layer name is parcelview and the field is parent_folio. The new point feature class name is address_edit and the field is parent_folio.

Trying to replace what I have. My understanding is "parcel" is the name of feature class? "MyParcels" is another feature class? parcel_id is a field? I am a bit lost.

Labels.PNG

JoeBorgione

1. It depends where you store your data: if it a hosted feature layer on AGOL, no.

2. To use attribute rules, the feature needs a global id

3. This type of rule is applied to the point feature

4. MyParcels is the name of the feature class, and the variable 'parcel' refers to it

My suggestion is you take a look at the Arcade help pages to be come more familiar with it. Something you need to consider is that when you create attribute rules that take data from one feature to another, all the feature classes must reside in the same 'datastore' which is Arcade for database. At this point in time all my addressing data and the related features are in the same enterprise geodatabase. I notice that you refer to your parcel feature class as 'parcelview': is this an actual database view of the data? If so, that view and your address points need to be in the same datastore.

AlexP_

@JoeBorgione

1) All my data are in the same enterprise geodatabase. parcelview is a enterprise geodatabase view under the same enterprise database also. Is it still ok? Also, you mentioned datastore, is it like enterprise database? Correct me if I am wrong.

JoeBorgione

'datastore' which is Arcade for database.

That's the great thing about having a database view: the view is in the same datastore/database that the points are in. But the actual data that the view is referencing can be elsewhere.

AlexP_

@JoeBorgione

Thank you for clarify.

2) GLOBALID, if I add it, would it be an issue if I need to set up unique identifier/avoid duplicate based on a text field?

JoeBorgione

I see: You want the address field to be unique and never reused. The Address Data Management Solution uses a Domain approach to resolving that issue with street names. The problem with that is Domains in an enterprise geodatabase can only be modified by the domain owner, not multiple editors.

I'm not sure how to scan a feature set for a particular value and dis-allow it from being used again at the time of creation.

AlexP_

Do you think survey123 might have this tool? I am the only domain owner but I don't do this task. It is only one person to edit. An editor does it on webapp builder. Does it required to use ArcGIS Pro to edit from address data management solution and not web appbuilder?

JoeBorgione

Survey123 would not be the tool to use for data editing, and I would venture a guess that is does not have such a tool.

JoeBorgione

here are a couple online resources for a python approach to finding identical values in a given field:

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/find-identical.htm

https://support.esri.com/en/technical-article/000023355

But these are not attribute rules; you would run these as part of a data QA/QC routine. I also looked at Data Reviewer which does not seem to offer a 'find repeated values' check.

Also found this post: https://community.esri.com/t5/electric-questions/check-for-duplicate-assetid-values-with-arcade/m-p/209833 I haven't studied it yet, but it might point you in a directions.

@XanderBakker - any ideas for @AlexP_ ?

AlexP_

Hello @JoeBorgione

I tried to apply globalid but i got an error. please advise.

JoeBorgione

Google that error and you'll come across this from ESRI. It looks like a fairly generic, non-specific error so I really don't know what the problem is. You may want to consult ESRI tech support.

AlexP_

@JoeBorgione I found out that I had to stop the map service then applied GLOBALID again.

AlexP_

@JoeBorgione

Hello I have a question, after applied this attribute rule, would it work thru web map app arcgis online when an editor add new info? Please confirm. editor doesnt have pro. if any other method to use thru web?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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