How to edit a feature class used in a Feature Service via Python?

NickJacob

Hello,

I'm experimenting around a bit with ArcGIS for Server and I have a feature class that I'd like to edit with a python script.  The catch is that this feature class is the basis for a Feature Service I have published.  Does anyone know what the best approach is for editing these features via arcpy?  I initially thought I could simpy overwrite the feature class, but I fear server will place a lock on it.  Is it possible to delete or add new features through a POST operation, or do I have the wrong idea?

I essentially have a feature class of polygons used in a feature service and I want to execute a python script every couple of minutes with Windows Task Scheduler that updates it.

Any advice is definitely welcome!

- Nick

PF1

Ok... Ok... I created a better sample that you should be able to run (without all my custom classes, error checking, validation, etc).  This runs on my environment with just the base python installation for ArcGIS 10, 10.1 or 10.2. 

import httplib
import urllib
import json
from urlparse import urlparse
from datetime import datetime



def parseUrl(url):
 result=dict()
 up=urlparse(url)
 host=up.netloc
 #assume port 80 at first
 port=80
 #result["host"]=host
 result["path"]=up.path
 result["https"]=False
 if (up.scheme.upper()=='HTTPS'):
  result["https"]=True
  #switch to port 443 if HTTPS by default
  port=443
 #accept non-default port if provided...
 if (up.netloc.find(":") != -1):
  port=int(host[host.find(":")+1:])
  host=host[0:host.find(":")]
 result["host"]=host
 result["port"]=port
 return result


ags_fs_url=r'http://sampleserver6.arcgisonline.com/arcgis/rest/services/Wildfire/FeatureServer/0'
urlp=parseUrl(ags_fs_url)
headers={"Content-type": "application/x-www-form-urlencoded","Accept": "text/plain"}


print "\n\n****QUERYING SERVICE***"

conn=httplib.HTTPConnection(urlp['host'],urlp['port'])
params=dict()
params['f']='json'
params['where']="rotation=42"
params['outFields']="objectid,description,rotation"
params['returnGeometry']=False
conn.request("POST",urlp['path']+"/query",urllib.urlencode(params),headers)
resp=conn.getresponse()
data=resp.read()
jdata=json.loads(data)
print "Response JSON: \n%s"%str(jdata)


#Try to add the date to the description
print "\n\n****TRYING TO ADD THE DATE WITH UNICODE CHARACTERS***"
feature=jdata["features"][0]
dt=datetime.strftime(datetime.now(),"%Y%m%d_%H:%M:%S")
old_desc=feature['attributes']['description']
new_desc="Go Broncos! @ %s"%dt
print "Setting description from '%s' to '%s'"%(old_desc,new_desc)
feature['attributes']['description']=new_desc

conn=httplib.HTTPConnection(urlp['host'],urlp['port'])
params=dict()
params['f']='json'
params['updates']=[feature]
conn.request("POST",urlp['path']+"/applyEdits",urllib.urlencode(params),headers)
resp=conn.getresponse()
data=resp.read()
jdata=json.loads(data)
print "Request Parameters: \n%s"%str(params)
print "Response JSON: \n%s"%str(jdata)

#Lets try without unicode...
print "\n\n****TRYING TO ADD THE DATE WITHOUT UNICODE CHARACTERS***"
new_feature=dict()
for k in feature.keys():
 new_feature[str(k)]=dict()

for k in feature['attributes'].keys():
 if type(feature['attributes']) == unicode:
  new_feature['attributes'][str(k)]=str(feature['attributes'])
 else:
  new_feature['attributes'][str(k)]=feature['attributes']

conn=httplib.HTTPConnection(urlp['host'],urlp['port'])
params=dict()
params['f']='json'
params['updates']=[new_feature]
conn.request("POST",urlp['path']+"/applyEdits",urllib.urlencode(params),headers)
resp=conn.getresponse()
data=resp.read()
jdata=json.loads(data)
print "Request Parameters: \n%s"%str(params)
print "Response JSON: \n%s"%str(jdata)

And the output:

****QUERYING SERVICE***
Response JSON:
@{u'fields': [{u'alias': u'OBJECTID', u'type': u'esriFieldTypeOID', u'name': u'objectid'}, {u'alias': u'Rotation', u'type': u'esriFieldTypeSmallInteger', u'name': u'rotation'}, {u'alias': u'Description', u'length': 75, u'type': u'esriFieldTypeString', u'name': u'description'}], u'globalIdFieldName': u'', u'objectIdFieldName': u'objectid', u'features': [{u'attributes': {u'rotation': 42, u'description': u'Go Broncos! @ 20131105_12:33:55', u'objectid': 1609}}]}


****TRYING TO ADD THE DATE WITH UNICODE CHARACTERS***
Setting description from 'Go Broncos! @ 20131105_12:33:55' to 'Go Broncos! @ 20131105_12:38:14'
Request Parameters:
@{'updates': [{u'attributes': {u'rotation': 42, u'description': 'Go Broncos! @ 20131105_12:38:14', u'objectid': 1609}}], 'f': 'json'}
Response JSON:
{u'error': {u'message': u'Unable to complete operation.', u'code': 400, u'details': []}}


****TRYING TO ADD THE DATE WITHOUT UNICODE CHARACTERS***
Request Parameters:
@{'updates': [{'attributes': {'rotation': 42, 'description': 'Go Broncos! @ 20131105_12:38:14', 'objectid': 1609}}], 'f': 'json'}
Response JSON:
{u'addResults': [], u'deleteResults': [], u'updateResults': [{u'success': True, u'objectId': 1609}]}

BTW... GO Broncos!!  🙂