topic Re: Parcel Drafter setup question in Local Government Solutions Users Questions

Parcel Drafter setup question

KimberlyMeinert — Tue, 31 Jul 2018 17:06:48 GMT

I deployed the Parcel Drafter solution via ArcPro and am trying to get it set up. Is the list of snapping layers expecting an actual Parcel Fabric feature that has been published? When I try to add the published version of our PLSS control points, for instance, I get an "invalid foreign key" error, leading me to believe that perhaps it's expecting a very specific schema and not just any old layer.

Re: Parcel Drafter setup question

KimberlyMeinert — Tue, 07 Aug 2018 13:28:36 GMT

Anybody? I tried just choosing the Parcel Lines layer that is automatically deployed, and I get the same error, so now I'm thinking it's not that I was trying to use my own. Even using Esri's default isn't working. Is this a bug?

Re: Parcel Drafter setup question

ChrisBuscaglia — Tue, 07 Aug 2018 14:30:14 GMT

Hello Kimberly,

Sorry for the delayed response, we'd be glad to take a look at your configuration. The invalid foreign key error should only apply to the Parcel Drafter Lines and Parcels, not the snapping layers. Can you please send a screenshot of both the 'Parcel Layers' and 'Advanced Settings' tab in the configuration panel?

Thanks

Chris Buscaglia

Local Government Solutions Team

Re: Parcel Drafter setup question

KimberlyMeinert — Tue, 07 Aug 2018 17:54:37 GMT

Hi Chris! Here's what I get when I try to pick the snapping layers, even when I pick the Parcel Drafter Lines themselves, not even "my own" control points or whatnot. Same thing happens either way.

And here's the parcel layer settings themselves. You'll notice the "foreign key" box is blank and grayed out. Just for giggles, I started deploying the Parcel Drafter app the "old-fashioned way" (ha) by adding it to a Web App Builder and this field is filled in already, so I'm wondering if it's something in the way ArcPro is deploying it through the "solutions" button. I also was able to snap to my own layers this way, so I'm going to continue with the manually-deployed application. Hope that helps.

Re: Parcel Drafter setup question

ChrisBuscaglia — Tue, 07 Aug 2018 18:27:35 GMT

Kimberly -

I'm not able to reproduce with the automated deployment option, so I'm scratching my head a bit. I deployed the app and the Parcel/Lines layers are hooked up correctly.

When you say that you manually deployed the solution - did you use the layers that were actually deployed with the automated approach, or did you have to publish these manually with the download.

Chris

Re: Parcel Drafter setup question

KimberlyMeinert — Tue, 07 Aug 2018 18:35:15 GMT

I was able to use the services and web map I deployed with ArcPro, but then I took the web map and made the app from that in Web App Builder, adding the Parcel Drafter widget from the list and continuing on that way. So the building blocks worked fine for me, it was how it decided to execute the application itself I guess? I have ArcPro 2.2.0 at the moment, I see there's an update now.

Re: Parcel Drafter setup question

AngeloHilton — Tue, 05 Feb 2019 22:00:57 GMT

Did you ever find out what was causing the foreign key error? We're encountering the same issue.

Thanks!

Re: Parcel Drafter setup question

KimberlyMeinert — Tue, 05 Feb 2019 22:24:04 GMT

No, not really. Like I had mentioned above, when I deployed the application the old-fashioned manual way (ie, not using the "easy button" in ArcPro), it worked, so I went with it.

Re: Parcel Drafter setup question

ChrisBuscaglia — Tue, 05 Feb 2019 22:43:47 GMT

Angelo -

Thanks for posting - this error happens when you don't have the proper relationship between the parcels and lines feature layers used for the application.

Can you share the URL to the app?

Thanks,

Chris Buscaglia

Government Solutions

Re: Parcel Drafter setup question

AngeloHilton — Tue, 05 Feb 2019 23:04:58 GMT

Chris,

This is a corporate portal page so the URL will not work outside of the company.

However, the data sets were already set up by ESRI. I just downloaded them and added to a web map then connected to a webapp. All of the other fields connect except the foreign key which should connect to the field created by ESRI.

Thanks!

Re: Parcel Drafter setup question

ChrisBuscaglia — Tue, 05 Feb 2019 23:29:03 GMT

Yes, this is strange - does the line feature layer have a relateGUID field?

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Bearing (type: esriFieldTypeDouble, alias: Bearing, SQL Type: sqlTypeOther, nullable: true, editable: true)
Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
Radius (type: esriFieldTypeDouble, alias: Radius, SQL Type: sqlTypeOther, nullable: true, editable: true)
ArcLength (type: esriFieldTypeDouble, alias: ArcLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
ChordLength (type: esriFieldTypeDouble, alias: ChordLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
SequenceID (type: esriFieldTypeInteger, alias: SequenceID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Category (type: esriFieldTypeInteger, alias: Category, SQL Type: sqlTypeOther, nullable: true, editable: true)
RelateGuid (type: esriFieldTypeGUID, alias: RelateGuid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Re: Parcel Drafter setup question

AngeloHilton — Wed, 06 Feb 2019 15:18:15 GMT

Yes, the line layer already had the RelateGuid filed set up when I downloaded it from ESRI.

Re: Parcel Drafter setup question

ChrisBuscaglia — Wed, 06 Feb 2019 15:56:30 GMT

Can you please send me a screenshot of your rest endpoint showing the fields as shown above? What DBMS are you using, oracle?

Re: Parcel Drafter setup question

AngeloHilton — Fri, 08 Feb 2019 17:18:05 GMT

Yes, Oracle DB.

Re: Parcel Drafter setup question

ChrisBuscaglia — Fri, 08 Feb 2019 17:32:19 GMT

Angelo,

I think that you uncovered a bug, the widget may be looking for a camelcase "RelateGuid" field in the lines layer - instead, Oracle DB is changing it to be relateguid - all lowercase.

Using the AGO Assistant - you can manually change the name of the field in the application json.

ArcGIS Online Assistant

Data Section -

"relatedGUID": {
"name": "RelateGuid",
"type": "esriFieldTypeGUID",
"alias": "RelateGuid",
"length": 38,
"editable": true,
"nullable": true
},

Re: Parcel Drafter setup question

AngeloHilton — Mon, 11 Feb 2019 14:48:52 GMT

Chris,

Thank you for helping us identify the issue!

Re: Parcel Drafter setup question

ChrisBuscaglia — Mon, 11 Feb 2019 15:51:18 GMT

Angelo -

Did this resolve the issue?

Thanks

Chris

Re: Parcel Drafter setup question

Pompomcini — Wed, 01 Dec 2021 15:53:11 GMT

Hi all,

Here's my solution to the foreign key error. 3 years later, but who knows, it might help someone 🙂

-----Layer preparation for Parcel Drafter-----

Create a file geodatabase and create the following layers:

Line layer:
- Bearing (double)
- Distance (double)
- Radius (double)
- ArcLength (double)
- ChordLength (double)
- SequenceID (double)
  - Note: SequenceID has to be entered as written, otherwise the attribute won’t be recognized in the parcel drafter tool.
- LineType (double)
Polygon layer:
- Rotation (double)
- ClosingRate (double)
- Zone (Text)
- Scale (double)
- ClosingDistance (double)
Relation class between the two layers:
- Origin table: the Polygon layer
- Destination table: the line layer
  - Note: The relation must be from the polygon to the line, otherwise there won’t be a foreign key and you would get the “Invalid foreign key” error.
- Origin Foreign key is the objectID

Share layers to portal

To Keep the relation when uploading the layers, you must publish the layers from a map containing only the related layers. To make sure the relation is active, check that there is a relation in the “relates” tab of the properties of each layer.

Click on the share tab and in the share as group, click on web layer and then publish web layer. See this post for more details.

In the sharing options, you must share the layer as a hosted layer (under “copy all data”, select “feature”). If you reference the layer, you will have an “invalid foreign key” error.

If you have done this step correctly, you should have one feature layer in your portal content, which has the 2 layers in it.

Set up the parcel drafter tool

In the parcel drafter tool, select the wanted polygon layer. Some fields should automatically be completed. If you have followed every step, you should have a foreign key and Sequence ID already filled in. Fill in the connection line and limit line values with 0 and 1.

Complete the set up by choosing the attributes corresponding to the COGO values and add fields for the geometry information of the coordinates.