Delete features from featureservice

Question

Hello

I have collected > 100k features in a hosted feature service (Service definition with 1000 records) and like to delete the features from time to time.

Doing manually, ArcMap allows downloading only 1000 features by time (Service definition with 1000 records), REST (with the WHERE-query 1=1) doesn't work. I get a weird, cryptical answer form the server.

Has anybody experience and a solution?

Thx!

Chris

RossCBrewer · Answer

I successfully deleted over 100,000 records from a hosted feature layer using the REST Delete Features tool by way of putting 1=1 in the where clause (and nothing in the Object ID field), BUT I did this in my organization's Portal 10.7.1 environment; so, ArcGIS Online might limit how many can be deleted due to cloud resource usage...

*I'm also posting to thank Chris for the 1=1 in where syntax help!

ChristianSailer2 · Answer

Hi Jake

Thank you this workaround works!

Christian

JakeSkinner · Answer

I'm not sure the max amount of features you can delete at once for an ArcGIS Online Hosted Feature Service.  One thing you could do is use a pythons script to delete features 1000 at a time.  Ex:

import urllib, urllib2, json, smtplib

username = "user"
password = "password"

tokenURL = 'https://www.arcgis.com/sharing/rest/generateToken'
params = {'f': 'pjson', 'username': username, 'password': password, 'referer': 'http://www.arcgis.com'}
req = urllib2.Request(tokenURL, urllib.urlencode(params))
response = urllib2.urlopen(req)
data = json.load(response)
token = data['token']

x = 1000

while x <= 95000:
    url = 'http://services.arcgis.com/Fz6ji5ArUSDM/ArcGIS/rest/services/Parcels/FeatureServer/0/deleteFeatures'
    where = "OBJECTID <= " + str(x)
    params = {'f': 'pjson', 'where': where, 'token': token}
    req = urllib2.Request(url, urllib.urlencode(params))
    response = urllib2.urlopen(req)
    x += 1000