topic Re: Pull data from polygon feature to point feature class in Geodatabase Questions

Pull data from polygon feature to point feature class

AlexP_ — Mon, 22 Mar 2021 14:59:51 GMT

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

Re: Pull data from polygon feature to point feature class

JoeBorgione — Mon, 22 Mar 2021 15:13:54 GMT

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.

Re: Pull data from polygon feature to point feature class

AlexP_ — Mon, 22 Mar 2021 15:27:05 GMT

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.

Re: Pull data from polygon feature to point feature class

JoeBorgione — Mon, 22 Mar 2021 15:36:30 GMT

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.

Re: Pull data from polygon feature to point feature class

AlexP_ — Mon, 22 Mar 2021 16:02:29 GMT

@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.

Re: Pull data from polygon feature to point feature class

JoeBorgione — Mon, 22 Mar 2021 15:59:36 GMT

'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.

Re: Pull data from polygon feature to point feature class

AlexP_ — Mon, 22 Mar 2021 16:02:12 GMT

@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?

Re: Pull data from polygon feature to point feature class

JoeBorgione — Mon, 22 Mar 2021 16:34:16 GMT

GlobalIDs are maintained internally by the geodatabase, so you have no control over them. I let the geodatabse do it's job. The same goes for ObjectID: I avoid using either one for anything than they are intended for. I think I've also mentioned database sequences in one or more of my responses to your earlier posts. I find deploying a database sequence and then capturing the next value in an attribute rule to be a very convenient and easy way to create a unique id of your own design. Here is an example of using a database sequence which is numeric to update a text type of unique id field.

// This rule will create a new unique id when new feature is created // Define the leading text and the delimiter for the ID var prefix = "MyID" var join_char = "-" //Ensure the ID is not already set, if it is, return the original id if (IsEmpty($feature.siteaddid)) { return Concatenate([prefix, NextSequenceValue("MyDatabaseSequence")], join_char) } else { return $feature.siteaddid }

In this example I use the text of MyID as the prefix to my unique identifier and concatenate to the next value in a database sequence named MyDatabaseSequence. If the next value of my sequence is 100, then the unique id field value will be:

MyID-100

Re: Pull data from polygon feature to point feature class

AlexP_ — Mon, 22 Mar 2021 17:21:29 GMT

@JoeBorgione Thank you for reply. The one I asked about sequence on post was for a different case. This case here is for example, address field, entry address info 1234 NW 102 AVE. but if an editor re entry the same address. it needs to set up to avoid duplicate . hope this clarify.

Re: Pull data from polygon feature to point feature class

JoeBorgione — Mon, 22 Mar 2021 17:25:52 GMT

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.

Re: Pull data from polygon feature to point feature class

AlexP_ — Mon, 22 Mar 2021 18:26:38 GMT

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?

Re: Pull data from polygon feature to point feature class

JoeBorgione — Mon, 22 Mar 2021 19:21:00 GMT

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.

Re: Pull data from polygon feature to point feature class

JoeBorgione — Mon, 22 Mar 2021 19:28:17 GMT

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_ ?

Re: Pull data from polygon feature to point feature class

AlexP_ — Mon, 05 Apr 2021 21:56:02 GMT

Hello @JoeBorgione

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

Re: Pull data from polygon feature to point feature class

JoeBorgione — Mon, 05 Apr 2021 22:01:24 GMT

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.

Re: Pull data from polygon feature to point feature class

AlexP_ — Tue, 06 Apr 2021 12:27:47 GMT

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

Re: Pull data from polygon feature to point feature class

AlexP_ — Tue, 06 Apr 2021 13:43:21 GMT

@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?