topic Re: Update Feature with ArcGIS API for Python in ArcGIS API for Python Questions

Update Feature with ArcGIS API for Python

PierreWeisse1 — Tue, 28 Aug 2018 05:10:07 GMT

Hello, I work with ArcGIS API for Python on a service hosted in AGOL. I would like to update a field based on another field. I have tried many times, I do not understand how to do it. The example in the API is based on the update between two documents.

Someone to help me ?

Thank you

Re: Update Feature with ArcGIS API for Python

simoxu — Sun, 12 Dec 2021 08:36:03 GMT

Hope the following code snippet gives you some clue:

from arcgis.gis import GIS
from arcgis.features import FeatureSet, Feature

gis = GIS(url="",username="",password="")
fs=gis.content.get(itemId)

# assume the first layer is the layer you want to update
fl=fs.layers[0]

# set return_geometry false will save you time and data 
features=fl.query(where=sql_where,out_fields='OBJECTID,FieldName'
                   ,return_geometry=False)

for feature in features:
   # Calculate the new value and assign it to the field in the current record
   feature.set_value('FieldName',NewValue)

# update the features in AGOL
results = fl.edit_features(updates=features)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Update Feature with ArcGIS API for Python

PierreWeisse1 — Wed, 29 Aug 2018 00:05:22 GMT

Thank you Simo Xu

Have a good day

Re: Update Feature with ArcGIS API for Python

simoxu — Wed, 29 Aug 2018 23:50:55 GMT

You are welcome, thank you

Re: Update Feature with ArcGIS API for Python

PierreWeisse1 — Tue, 25 Sep 2018 03:09:02 GMT

Hello Simo,

Maybe you can help me on this point. I'm still working with this web service, hosted under AGOL and with ArcGIS API for Python.

On a field of type 'date', I would like to empty the field of its contents.

However when I try, here is the result 1/1/1900 11h05

Do you have an idea ?

Thank you

Re: Update Feature with ArcGIS API for Python

simoxu — Tue, 25 Sep 2018 06:28:43 GMT

I don't know how you did it, but could you test whether or not the following code works?

feature.set_value('DateFieldName',None)

Re: Update Feature with ArcGIS API for Python

PierreWeisse1 — Tue, 25 Sep 2018 22:22:01 GMT

With your proposal it does not change. The content of the field remains the same.

Before asking for your help I tried this:

feature.set_value('DateFieldName',"")
RESULT >> 1/1/1900 11:05 AM

The field settings have this parameter.
Allow null values is set to Yes

Re: Update Feature with ArcGIS API for Python

simoxu — Wed, 26 Sep 2018 08:48:46 GMT

You are right.

I tried SQL in Map Viewer, it didn't work either.

I have to manually do it in AGOL Map Viewer using Arcade expression to set the Date column to NULL. But I am not sure this is what you want.

Re: Update Feature with ArcGIS API for Python

JonathanPollack1 — Wed, 21 Aug 2019 20:49:30 GMT

Very nicely done. I wish the Esri help documentation on this topic was this straightforward and to the point.