Latest Contributions by RandyBurton

A sample script using the REST API: import urllib, urllib2, json, sys, time, arcpy # Credentials and feature service information username = <username> password = <password> # addList (geometry and fields) : [ X_LON, Y_LAT, Name, C_long, F_date ] addList = [     [ -8572606.3109, 4705898.3536000028, 'US Capitol', 20180822, '2018-08-22 12:00:00' ]     ] URL = "https://<server info>/arcgis/rest/services/example/FeatureServer/0/addFeatures" # obtain a token referer = "http://www.arcgis.com/" query_dict = { 'username': username, 'password': password, 'referer': referer } query_string = urllib.urlencode(query_dict) url = "https://www.arcgis.com/sharing/rest/generateToken" token = json.loads(urllib.urlopen(url + "?f=json", query_string).read()) if "token" not in token:     print(token['error'])     sys.exit(1) # exit if no token for item in addList :     f_date = int(time.mktime(time.strptime(item[4], "%Y-%m-%d %H:%M:%S")))*1000 # UTC in miliseconds         feature_data = [{         "attributes": { "Name": item[2], "C_long": item[3], "F_date": f_date },         "geometry": { "x": item[0], "y": item[1] }}]     # print feature_data         submitData = {         "features": json.dumps(feature_data),         "f": "json",         "token": token['token']         }     # print submitData     jsonResponse = urllib.urlopen(URL, urllib.urlencode(submitData))     jsonOutput = json.loads(jsonResponse.read())     print json.dumps(jsonOutput, indent=4, sort_keys=False)     # parse jsonOutput for results‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

You can also use the Rest API. See:  Add Features and Update Features . There are forms to add and update features using the REST API.  Sign in to your account.  In the content section select the feature layer you want, then (on next page) select the specific layer.  This will take you into the services directory and show you basic info about your layer.  At the bottom of this page, under supported operations, there is a link to the Add Features and Update Features forms.  I would suggest learning with a practice/backup feature until you are comfortable with the process. ... View more

Your whereClause as shown is missing a + sign and space before " IS NULL".  When joining strings, I like to use .format as I find the code is a bit clearer.  You might try something like: mayDevice = "{}_DEVICE_ID".format(mayFeature) whereClause = "{} IS NULL".format(mayDevice)‍‍‍ ... View more

I hit a timeout on my data request, so there are a lot of records; the json indicated: "exceededTransferLimit": true with perhaps 1,000 records returned.  You may need to do something to limit your query results. I also noticed that you are not requesting the geometry ( 'returnGeometry': 'false' )  which would cause JSONToFeatures to fail.  You should see something like this in your json:    "geometry": {     "rings": [      [       [        -9165686.7350331135,        3936948.9098836873       ],       [        -9165681.1218573805,        3936946.988356465       ],       [        -9165681.5995294657,        3936947.138881634       ],       [        -9165686.7350331135,        3936948.9098836873       ]      ]     ]    }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

And when you print(cslfJson), does it appear to be correctly formatted json and a feature? ... View more

Can you provide the complete error message? ... View more

Should you need unique items sorted: for k in d.keys():     print "{}: ".format(k),     for i in sorted(set(d[k])):         print i,     print # results # 1974:  2775 2983 2985 3004 3005 3006 3008 3021 27027 # 1970:  2183 ‍‍‍‍‍‍‍‍‍ ... View more

Using set on a list will give unique elements: d = {'1974': [3005, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3008, 3008,               3006, 3006, 3004, 3004, 3004, 3004, 3004, 3004, 27027, 2775, 3021,               3021, 3005, 3005, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3008,               3008, 3008, 3006, 3006, 3004, 3004, 3004, 3021, 3021, 2775, 3005,               3008, 3005, 3005, 3004, 3004, 3004, 3005, 3005, 3005, 3005, 3005,               3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3005, 3008, 3008,               3008, 3008, 3008, 3006, 3004, 2985, 3021, 2775, 3005, 3005, 3005,               3008, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3006,               3004, 3004, 3004, 3004, 3005, 2983, 3021, 3021, 27027, 2775, 2775,               3005, 3005, 3005, 3004, 2983, 2983, 3005, 3005, 3008, 3008, 3008,               3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005, 3005, 3005, 3005,               3008, 3006, 3006, 3004, 3004, 3004, 3004, 3004, 3004, 3008, 3005,               2985, 2985, 2983, 3021, 3021, 2775, 3005, 3005, 3008, 3008, 3005,               3008, 3008, 3008, 3008, 3004, 3004, 2983, 3005, 3005, 3005, 3005,               3008, 3008, 3008, 3008, 3008, 3005, 3005, 3006, 3006, 3006, 3006,               3004, 3004, 3004, 2985, 3005, 3005, 3005, 3005, 3005, 3008, 3008,               3008, 3008, 3008, 3008, 3008, 3008, 3005, 3005, 3005, 3005, 3005,               3005, 3008, 3006, 3006, 2985, 2985, 2985, 2985, 3021, 3021, 3021,               27027, 3021],      '1970': [2183, 2183, 2183, 2183, 2183, 2183, 2183, 2183]} for k in d.keys():     print k, set(d ) # 1974 set([3008, 2983, 2985, 3021, 27027, 2775, 3004, 3005, 3006]) # 1970 set([2183]) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

You may want to restructure your if/elif/else in your function so that it will always return something - perhaps a zero or 25 for any unknown value. if (fld == 'S1640'):   return 55 elif (fld == 'S1500'):   return 45 elif (fld == 'S1400'):   return 35 else:  # for S1200 and any other value, just in case   return 25 ‍‍‍‍‍‍‍‍ ... View more