Grab sections of Service to process

kapalczynski — Fri, 19 Jan 2024 20:30:56 GMT

I am trying to delete records via REST Service. the smaller tables delete no issues but Feature Classes with images seem to NOT delete as they have more than 10,000 records

If I look at the ObjectIDs and grab the first half and then the second half they both delete.

But I want this to be automated... So I am trying to think this through... Trying to figure out how to query for the first say 2000 records and then do something... then grab 2001st record through 4000 and do something etc.

Anyone have any ideas?

Im POST like below using a where clause.. so what ever solution would have to have a viable WHERECLAUSE ... not sure how to do this without manually setting the where clause to something like this:

How can I grab my features in CHUCKS

if targetLayer == "GIS_DATA.SDEInventory": whereclause="{}".format("OBJECTID<15000") processDeletion(url, whereclause) whereclause="{}".format("OBJECTID>=15000") processDeletion(url, whereclause) def processDeletion(targetLayer, whereclause): targetFeature = targetLayer recordstoDelete = whereclause gis_payload = { 'token': portaltoken, 'f': 'json', 'where': recordstoDelete } response = requests.request("POST", url=targetFeature , data=gis_payload)

Re: Grab sections of Service to process

JRhodes — Fri, 19 Jan 2024 21:47:12 GMT

This should work for you, or hopefully put you on the right track. The code below will delete ALL features in your service in 2000-record chunks, unless you modify the where_clause variable to specify only certain features. Use with caution.

You may also want to look at Truncate (Feature Layer)—ArcGIS REST APIs | ArcGIS Developers if you are truly trying to delete every feature.

import requests feature_layer_url = "https://<your_server_url>/arcgis/rest/services/<some_feature_service>/FeatureServer/0" where_clause = "1=1" # this will grab all features, or you can replace with a different where clause. The objectid chunks will be handled later. batch_size = 2000 while True: query_url = f"{feature_layer_url}/query?where={where_clause}&returnIdsOnly=true&f=json&token={portaltoken}" query_result = requests.get(query_url).json() object_ids = query_result.get("objectIds", []) if not object_ids: break # No more features to delete for i in range(0, len(object_ids), batch_size): batch_ids = object_ids[i:i + batch_size] where_clause_with_ids = f"{where_clause} AND OBJECTID >= {min(batch_ids)} AND OBJECTID <= {max(batch_ids)}" delete_params = { 'where': where_clause_with_ids, 'f': 'json', 'rollbackOnFailure': True, 'token': portaltoken } response = requests.post(f"{feature_layer_url}/deleteFeatures", data=delete_params) delete_result = response.json() if 'deleteResults' in delete_result: deleted_features = delete_result['deleteResults'] for feature in deleted_features: if 'success' in feature and feature['success']: print(f"Deleted feature with objectId {feature['objectId']}") else: print(f"Failed to delete feature with objectId {feature['objectId']}") else: print(f"Error deleting features. Response: {delete_result}")

topic Re: Grab sections of Service to process in ArcGIS API for Python Questions

Grab sections of Service to process

Re: Grab sections of Service to process