topic Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API? in ArcGIS API for Python Questions

How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

deleted-user-XxVvJu7MUIrG — Sun, 12 Dec 2021 10:57:24 GMT

Hello everyone,

I am trying to update feature layers used in web maps on ArcGIS Enterprise with ArcGIS API for Python. I can have access to their feature sets by the code. I am using the sample of "Updating Features in a Feature Layer". The sample uses csv file to update the feature layer. Are there any possibilities to use spatial view of SQL Server to update feature layers? I converted the spatial view to a query layer and then converted it to a feature class, but I could not use the feature class for merging. I received the following error message:

can not merge DataFrame with instance of type <class 'arcpy.arcobjects.arcobjects.Result'

Please help me for this case.

Thank you!

Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

JakeSkinner — Tue, 30 Oct 2018 15:29:55 GMT

Hi Kimia,

You may want to try the following tool:

https://community.esri.com/docs/DOC-11621-update-hosted-feature-service-with-feature-class

Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

deleted-user-XxVvJu7MUIrG — Tue, 30 Oct 2018 19:30:27 GMT

Hi Jake,

Thanks for sharing the tool. I really appreciate it. I am trying to run the tool, it is failed. It looks like the URL of the feature service is not correct.

The URL I am using for the tool is similar to the following.

https://servergis.CompanyName.com/arcgis/rest/services/Hosted/NameOfFeatureService/FeatureServer/0

Thank you

Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

JakeSkinner — Tue, 30 Oct 2018 19:36:57 GMT

Can you share the service to a Group in ArcGIS Online and invite my user account (jskinner_CountySandbox)? I'll download a copy, re-upload, and then try executing the tool.

Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

deleted-user-XxVvJu7MUIrG — Tue, 30 Oct 2018 19:59:19 GMT

I need your email address to invite you to ArcGIS Online.

Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

JakeSkinner — Tue, 30 Oct 2018 20:04:18 GMT

You won't need to create a user account for me. You can invite my user account that already exist. Within an ArcGIS Online Group click invite user and uncheck Only search for members in. Search for jskinner_CountySandbox and send the invite to that account.

Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

deleted-user-XxVvJu7MUIrG — Tue, 30 Oct 2018 20:32:02 GMT

I sent an invitation to you.

Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

JakeSkinner — Wed, 31 Oct 2018 12:37:45 GMT

I was able to get this to work. Here are the steps I took in ArcGIS Pro after I downloaded the service as a feature class:

1. Published the feature class to ArcGIS Online

2. Exported a selection out of the feature class

3. Updated the Design Elevation for the export to 10

4. Executed the tool using the ElementNumber field as the unique identifier:

The service updated successfully with the new features who have a Design Elevation of 10.

Re: How to update feature layers on ArcGIS Enterprise with spatial views of SQL Server with Python API?

deleted-user-XxVvJu7MUIrG — Wed, 31 Oct 2018 19:59:05 GMT

Hello Jake,

Thanks for sending the result. I believe that the tool is working well. It seems that there is an issue on my end. I created a new feature class and divided it in two parts. So, the second part is appended to the first part by the tool. I published the first part as "Hosted Feature Layer" on both ArcGIS Online and Enterprise. I executed the tool, but I received two different error messages.

For ArcGIS Online, it looks that everything is working well, but no new row is appended to the hosted feature layer. I checked the tool twice. One time with defining a field value and the other time with no field value. Both had the following error.

This is the error message.

For ArcGIS Enterprise, there is a problem in connection.

It is "ConnectionError: HTTPSConnectionPool(host=' ', port=7443): Max retries with url: /arcgis/sharing/rest/generateToken

Thank you