topic Re: Update feature service with ArcGIS api for python in ArcGIS API for Python Questions

Update feature service with ArcGIS api for python

PatrickFilyer — Mon, 24 Jul 2017 17:02:43 GMT

I am trying to figure out how to update a feature service hosted on arcgis online using the arcgis api for python. Essentially, every morning I would like to run a script that takes new features from a feature class on our organizations egdb and update a replica of the feature service on AGOL.

Is this possible?

Re: Update feature service with ArcGIS api for python

AlexanderBrown5 — Mon, 24 Jul 2017 17:11:02 GMT

Patrick,

If you utilize the Python API from an IDE and pull in ArcPy functions as well, you can utilize adding/editing features:

Editing features | ArcGIS for Developers

You just need to create loop through your feature class to grab the pertinent attributes, format them for the ingestion into the Python API. Definitely possible.

~Alex

Re: Update feature service with ArcGIS api for python

RohitSingh2 — Mon, 24 Jul 2017 17:13:17 GMT

It is possible using the ArcGIS API for Python alone.

See updating_features_in_a_feature_layer | ArcGIS for Developers and overwriting_feature_layers | ArcGIS for Developers

Re: Update feature service with ArcGIS api for python

AlexanderBrown5 — Mon, 24 Jul 2017 17:22:22 GMT

Rohit,

Do you have to export your new data to a csv? Can you connect directly to your geodatabases using the Python API? Definitely easier utilizing just the ArcGIS API, but I can see numerous occasions where users would want to update directly from their authoritative databases.

~Alex

Re: Update feature service with ArcGIS api for python

PatrickFilyer — Mon, 24 Jul 2017 17:24:00 GMT

Ideally this is what I would like to do.

Re: Update feature service with ArcGIS api for python

PatrickFilyer — Mon, 24 Jul 2017 17:28:50 GMT

Thanks Alexander, working through the demo now.

Re: Update feature service with ArcGIS api for python

RohitSingh2 — Mon, 24 Jul 2017 17:28:58 GMT

You don't have to export your data to a csv.

You can overwrite feature layers using arcgis.features.managers module — arcgis 1.2.0 documentation

You can also read in a file geodatabase or shapefile as a Spatial Data Frame and get it in pandas before pushing the updates to a feature layer, on similar patterns as the examples shared above.

Re: Update feature service with ArcGIS api for python

RohitSingh2 — Mon, 24 Jul 2017 17:30:15 GMT

Another example / workflow is shared in Kevin's blog post at https://blogs.esri.com/esri/arcgis/2017/03/14/updating-your-hosted-feature-services-with-arcgis-pro-and-the-arcgis-api-for-python/

Re: Update feature service with ArcGIS api for python

PatrickFilyer — Thu, 27 Jul 2017 14:55:36 GMT

I made a test data set and was able to successfully add a point using the python api. However, when i implement this into our GIS, I will be adding polygons. Would you know how to write the geometry (coordinates) for a polygon? Adding a point is pretty straight forward as it is just an x,y value.

Re: Update feature service with ArcGIS api for python

ManushiMajumdar — Tue, 29 Aug 2017 20:51:22 GMT

My new csv that has to add features to the feature service has 65k rows. Is this still a good approach to update them, or should I use another technique?

Re: Update feature service with ArcGIS api for python

PhilLarkin1 — Thu, 30 Nov 2017 00:12:29 GMT

Thanks for the API. It is helpful.

Here is some advice for those attempting to use .overwrite(). If you are passing a string file path, try pointing to the zipfile name while dropping the '.zip'. This worked for me.

C:\RootFolder\example.zip
C:\RootFolder\example

Re: Update feature service with ArcGIS api for python

GFlonk — Sun, 12 Dec 2021 10:36:26 GMT

When trying to use the overwrite() function, my code returns the following error:

AttributeError: 'FeatureLayerCollection' object has no attribute 'managers'

My code looks like the following:

gis = GIS(username=username, password=password)
fs = gis.content.get('idoffeatureservice') 
flc = FeatureLayerCollection.fromitem(fs) 
flc.manager.overwrite("path to feature class inside an FGDB")‍‍‍‍‍‍‍‍‍‍

Any ideas?

Re: Update feature service with ArcGIS api for python

MaxMarno — Mon, 09 Apr 2018 19:00:56 GMT

Is it possible to pass a SpatialDataFrame as the overwrite parameter? Thus far it seems that the overwrite() function accepts only local data files...

Re: Update feature service with ArcGIS api for python

StephenRoss — Mon, 16 Jul 2018 15:50:53 GMT

DId you ever get this script to work?

Re: Update feature service with ArcGIS api for python

NaomiBegg2 — Sun, 20 Jan 2019 22:31:40 GMT

Does this require Portal or can it be done using straight AGOL?

Re: Update feature service with ArcGIS api for python

VaL — Mon, 21 Jun 2021 13:06:53 GMT

I have similar requirement to update a hosted feature layer in AGOL using scheduled python script.

My source data is stored in an SDE DB. What is the best way to achieve that in 2021?