How to delete features of an ArcGIS Online Hosted Feature Layer?

ImtiazSyed

Hi All,

I used this script to delete all the features from a hosted feature layer where it had relationships and had sync capability enabled on it. 

https://esri.github.io/arcgis-python-api/apidoc/html/arcgis.features.toc.html?highlight=query#arcgis.features.FeatureLayer.out_statistics

<SPAN class="keyword token">import</SPAN> arcgis
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"https://site.maps.arcgis.com"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"username"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"password"</SPAN><SPAN class="punctuation token">)</SPAN>

feature_layer_item <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"<item-id>"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
flayers <SPAN class="operator token">=</SPAN> feature_layer_item<SPAN class="punctuation token">.</SPAN>layers

flayer <SPAN class="operator token">=</SPAN> flayers<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">#count = flayer.query(return_count_only=true)</SPAN>

max_objid <SPAN class="operator token">=</SPAN> flayer<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN>out_statistics<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"statisticType"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"MAX"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"onStatisticField"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"outStatisticFieldName"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"MAX_OBJ"</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> return_geometry<SPAN class="operator token">=</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
maxoid <SPAN class="operator token">=</SPAN> max_objid<SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'MAX_OBJ'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">#Delete in steps of 20000, in case the dataset is large</SPAN>

i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
step <SPAN class="operator token">=</SPAN> <SPAN class="number token">20000</SPAN>

<SPAN class="comment token">#replace maxoid with count if attempting to delete features based on feature count</SPAN>

<SPAN class="comment token">#using for loop</SPAN>
<SPAN class="comment token">#for i in range(1,20000,maxoid):</SPAN>

<SPAN class="keyword token">while</SPAN> i <SPAN class="operator token"><=</SPAN> maxoid<SPAN class="punctuation token">:</SPAN>
    i <SPAN class="operator token">+=</SPAN> step
    flayer<SPAN class="punctuation token">.</SPAN>delete_features<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN>f<SPAN class="string token">"OBJECTID <= {i}"</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Feature Layer was truncated"</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>‍</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><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thanks,

Imtiaz