Thank you Joshua, I was thinking about edit_features, I'll give it a go. Taking advantage of opportunity (please let me know if you'd prefer me to open new question) - I try to run something like this: # below returns response suggesting query is correct table . validate_sql ( sql = "my_timestamp_column ) # below throws exception table . delete_features ( where = "my_timestamp_column ) Line 5 fails with exception: Traceback ( most recent call last ) : File "harvester/test/simulate_entry_point.py" , line 40 , in module > route_event ( File "/lib/python3.8/site-packages/arcgis/features/layer.py" , line 1446 , in delete_features return self . _con . post ( path = delete_url , postdata = params , token = self . _token ) File "/lib/python3.8/site-packages/arcgis/_impl/connection.py" , line 1183 , in post self . _handle_json_error ( resp_json [ 'error' ] , errorcode ) File "/lib/python3.8/site-packages/arcgis/_impl/connection.py" , line 1204 , in _handle_json_error raise RuntimeError ( errormessage ) RuntimeError : Unable to delete features . ( Error Code : 400 ) There is only 40 items meeting criteria so should not be hitting any limits. I think this might be due to open-ended nature of the query (although I'd like arcgis to delete all features meeting criteria, I have seen posts here where people had to run multiple queries with bundles of ~2000 items).

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table.delete_features() RuntimeError: Unable to Delete Features

JamesKwong1

Thank you Joshua, I was thinking about edit_features, I'll give it a go.

Taking advantage of opportunity (please let me know if you'd prefer me to open new question) - I try to run something like this:

<SPAN class="comment token"># below returns response suggesting query is correct</SPAN>
table<SPAN class="punctuation token">.</SPAN>validate_sql<SPAN class="punctuation token">(</SPAN>sql<SPAN class="operator token">=</SPAN><SPAN class="string token">"my_timestamp_column < TIMESTAMP '2019-01-06 11:00:00'"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># below throws exception</SPAN>
table<SPAN class="punctuation token">.</SPAN>delete_features<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"my_timestamp_column < TIMESTAMP '2019-01-06 11:00:00'"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Line 5 fails with exception:

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
File <SPAN class="string token">"harvester/test/simulate_entry_point.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">40</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
route_event<SPAN class="punctuation token">(</SPAN>
File <SPAN class="string token">"/lib/python3.8/site-packages/arcgis/features/layer.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1446</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> delete_features
<SPAN class="keyword token">return</SPAN> self<SPAN class="punctuation token">.</SPAN>_con<SPAN class="punctuation token">.</SPAN>post<SPAN class="punctuation token">(</SPAN>path<SPAN class="operator token">=</SPAN>delete_url<SPAN class="punctuation token">,</SPAN> postdata<SPAN class="operator token">=</SPAN>params<SPAN class="punctuation token">,</SPAN> token<SPAN class="operator token">=</SPAN>self<SPAN class="punctuation token">.</SPAN>_token<SPAN class="punctuation token">)</SPAN>
File <SPAN class="string token">"/lib/python3.8/site-packages/arcgis/_impl/connection.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1183</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> post
self<SPAN class="punctuation token">.</SPAN>_handle_json_error<SPAN class="punctuation token">(</SPAN>resp_json<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'error'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> errorcode<SPAN class="punctuation token">)</SPAN>
File <SPAN class="string token">"/lib/python3.8/site-packages/arcgis/_impl/connection.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1204</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> _handle_json_error
<SPAN class="keyword token">raise</SPAN> RuntimeError<SPAN class="punctuation token">(</SPAN>errormessage<SPAN class="punctuation token">)</SPAN>
RuntimeError<SPAN class="punctuation token">:</SPAN> 
Unable to delete features<SPAN class="punctuation token">.</SPAN>
<SPAN class="punctuation token">(</SPAN>Error Code<SPAN class="punctuation token">:</SPAN> <SPAN class="number token">400</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

There is only 40 items meeting criteria so should not be hitting any limits.

I think this might be due to open-ended nature of the query (although I'd like arcgis to delete all features meeting criteria, I have seen posts here where people had to run multiple queries with bundles of ~2000 items).

Vind meer berichten getagd met

Accepted answers

JamesKwong1

The solution is to provide actual date in UTC

import datetime
from arcgis.gis import GIS
from arcgis.features import Table

g = GIS(username="my_user_name", password="my_secret")
pit = g.content.get('my_published_csv_item_id')
t = Table.fromitem(item=pit)

t.delete_features(where="my_datet_time_column < '{}'".format((datetime.datetime.utcnow() - datetime.timedelta(seconds=3600)).strftime("%Y-%m-%d %H:%M:%S")))
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

JamesKwong1

The solution is to provide actual date in UTC

import datetime
from arcgis.gis import GIS
from arcgis.features import Table

g = GIS(username="my_user_name", password="my_secret")
pit = g.content.get('my_published_csv_item_id')
t = Table.fromitem(item=pit)

t.delete_features(where="my_datet_time_column < '{}'".format((datetime.datetime.utcnow() - datetime.timedelta(seconds=3600)).strftime("%Y-%m-%d %H:%M:%S")))
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JamesKwong1

Many thanks Joshua, I can delete by oids (and this is my workaround at the moment - I run table.query with time condition and then collect oids and delete with another call)

However since calls to arcgis are very expensive in terms of time I'd love to save one call if possible and run table.delete_features with query...

bixb0012

If the SQL validates and there are only 40 or so items, I don't think it is related to the query. As a test, see if you can pass an OID using the deletes parameter. If it throws the same error, then it is likely related to your permissions or service configuration.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.