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

Update feature service with ArcGIS api for python

PatrickFilyer

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?

Find more posts tagged with

Accepted answers

SupratimBanik

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

All comments

VaL

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?

NaomiBegg2

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

StephenRoss

DId you ever get this script to work?

MaxMarno

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

GFlonk

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 <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN>username<SPAN class="operator token">=</SPAN>username<SPAN class="punctuation token">,</SPAN> password<SPAN class="operator token">=</SPAN>password<SPAN class="punctuation token">)</SPAN>
fs <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'idoffeatureservice'</SPAN><SPAN class="punctuation token">)</SPAN> 
flc <SPAN class="operator token">=</SPAN> FeatureLayerCollection<SPAN class="punctuation token">.</SPAN>fromitem<SPAN class="punctuation token">(</SPAN>fs<SPAN class="punctuation token">)</SPAN> 
flc<SPAN class="punctuation token">.</SPAN>manager<SPAN class="punctuation token">.</SPAN>overwrite<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"path to feature class inside an FGDB"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Any ideas?

PhilLarkin1

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

Manushi_Majumdar

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?

PatrickFilyer

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.

SupratimBanik

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/

SupratimBanik

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.

PatrickFilyer

Thanks Alexander, working through the demo now.

PatrickFilyer

Ideally this is what I would like to do.

AlexanderBrown5

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

SupratimBanik

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

AlexanderBrown5

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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