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; } } }

deleteRow() return SystemError: error return without exception set

FredericPiche

I'm trying to delete a row from a coverage

I'm using arcpy 10.3.1

the code that i am using is (to be able to reproduce the issue)

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">count_row</SPAN><SPAN class="punctuation token">(</SPAN>data<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>

&nbsp;&nbsp;&nbsp; data<SPAN class="punctuation token">.</SPAN>reset<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> i

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">'C:/Data/cea01apr'</SPAN>
feature <SPAN class="operator token">=</SPAN> <SPAN class="string token">'point'</SPAN>
fidfilter<SPAN class="operator token">=</SPAN> <SPAN class="string token">'fid = 1'</SPAN>

featureClassList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

fieldList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">)</SPAN>
fieldString <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>str<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> x <SPAN class="keyword token">in</SPAN> fieldList<SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN> fieldString<SPAN class="punctuation token">,</SPAN> fidfilter<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursorupdate<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Number of rows:'</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>count_row<SPAN class="punctuation token">(</SPAN>cursorupdate<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; rowupdate <SPAN class="operator token">=</SPAN> cursorupdate<SPAN class="punctuation token">.</SPAN>next<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>rowupdate<SPAN class="punctuation token">[</SPAN><SPAN class="number token">12</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; rowupdate<SPAN class="punctuation token">[</SPAN><SPAN class="number token">12</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+=</SPAN>&nbsp; <SPAN class="string token">'h'</SPAN>
&nbsp;&nbsp;&nbsp; cursorupdate<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>rowupdate<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN> fieldString<SPAN class="punctuation token">,</SPAN> fidfilter<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursorupdate<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Number of rows:'</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>count_row<SPAN class="punctuation token">(</SPAN>cursorupdate<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; rowupdate <SPAN class="operator token">=</SPAN> cursorupdate<SPAN class="punctuation token">.</SPAN>next<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> rowupdate<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>rowupdate<SPAN class="punctuation token">[</SPAN><SPAN class="number token">12</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN> fieldString<SPAN class="punctuation token">,</SPAN> fidfilter<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursorupdate1<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Number of rows:'</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>count_row<SPAN class="punctuation token">(</SPAN>cursorupdate1<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursorupdate1<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursorupdate1<SPAN class="punctuation token">.</SPAN>deleteRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

raw_input<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Press the <ENTER> key to exit'</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

the output of that script is

C:\Data>test.py
Number of rows:1
 hhhhhhhhhhhhhhhh
Number of rows:1
 hhhhhhhhhhhhhhhhh
Number of rows:1
Traceback (most recent call last):
&nbsp; File "C:\Data\test.py", line 39, in <module>
&nbsp;&nbsp;&nbsp; cursorupdate1.deleteRow()
SystemError: error return without exception set‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>

I have tried this

arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'test'</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'test'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NEW_SELECTION'</SPAN><SPAN class="punctuation token">,</SPAN> fidfilter<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>DeleteRows_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'test'</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

and i'm getting this error

Traceback (most recent call last):
&nbsp; File "C:\Data\test.py", line 41, in <module>
&nbsp;&nbsp;&nbsp; arcpy.DeleteRows_management('test')
&nbsp; File "C:\***\cots\ArcGIS\Desktop10.3\ArcPy\arcpy\management.py", line 15352, in DeleteRows
&nbsp;&nbsp;&nbsp; raise e
arcgisscripting.ExecuteError: ERROR 999999: Error executing function.
Failed to execute (DeleteRows).‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

trying the old arcpy.UpdateCursor

cursorupdate2 <SPAN class="operator token">=</SPAN>&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#print('Number of rows:' + str(count_row(cursorupdate2)))</SPAN>
row <SPAN class="operator token">=</SPAN> cursorupdate2<SPAN class="punctuation token">.</SPAN>next<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'delete'</SPAN><SPAN class="punctuation token">)</SPAN>
cursorupdate2<SPAN class="punctuation token">.</SPAN>deleteRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

will result into

C:\Data>test.py
ArcInfo
Number of rows:1
 hhhhhhhhhhhhhhhhhhhh
Number of rows:1
 hhhhhhhhhhhhhhhhhhhhh
delete
Traceback (most recent call last):
&nbsp; File "C:\Data\test.py", line 56, in <module>
&nbsp;&nbsp;&nbsp; cursorupdate2.deleteRow(row)
&nbsp; File "C:\***\cots\ArcGIS\Desktop10.3\ArcPy\arcpy\arcobjects\arcobjects.py", line 110, in deleteRow
&nbsp;&nbsp;&nbsp; return convertArcObjectToPythonObject(self._arc_object.DeleteRow(*gp_fixargs(args)))
RuntimeError: ERROR 999999: Error executing function.<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>

uncommenting the line for the number of rows will actually crash python.exe

Find more posts tagged with

Accepted answers

All comments

FredericPiche

i'm trying to delete rows from feature class based on some condition, this could have worked but like you i can't make the infoexpress work.

RebeccaStrauch__GISP

I answered your aml to arcpy question in the other thread is it possible to convert this AML into python? (arcedit)

Basically, my suggestion if you are just trying to select certain features that you want to keep is to not use a cursor or arcedit, just use the arcpy.Reselect_arc to select and copy the features to a new coverage. Based on the code you had in the other thread, I was able to get everything but the correct syntax for the"infoExpress", which is the process of RES, NSEL, RES, etc to get the set you will push out to the new coverage. Here is the code again, but I am getting an error on the last line. I have the help pages for Reselect_arc in a comment

<SPAN class="keyword token">import</SPAN> arcpy

inCover <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Workspace\test\bl01"</SPAN>
<SPAN class="comment token"># inCover = r"c:\Data\cea01apr"&nbsp;&nbsp;&nbsp;&nbsp; # this assumes cea01apr is the Coverage name</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> inCover

featureType <SPAN class="operator token">=</SPAN> <SPAN class="string token">'point'</SPAN>&nbsp;&nbsp; <SPAN class="comment token"># this is the feature type</SPAN>
recCountIn <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>featureType<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>getOutput<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Number of {0} records in {1}: {2}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>featureType<SPAN class="punctuation token">,</SPAN> inCover<SPAN class="punctuation token">,</SPAN> recCountIn<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># these aren't used, but good info</SPAN>
featureClassList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
fieldList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>inCover<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> featureType<SPAN class="punctuation token">)</SPAN>
fieldString <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>str<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> x <SPAN class="keyword token">in</SPAN> fieldList<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fieldString<SPAN class="punctuation token">)</SPAN>

tempCover <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Workspace\test\cl01testIn"</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arcpy<SPAN class="punctuation token">.</SPAN>Copy_management<SPAN class="punctuation token">(</SPAN>inCover<SPAN class="punctuation token">,</SPAN> tempCover<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nCopy worked"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nCopy didnt work, may already exist"</SPAN><SPAN class="punctuation token">)</SPAN>

tempCoverOut <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Workspace\test\cl01Out"</SPAN>

fidfilter<SPAN class="operator token">=</SPAN> <SPAN class="string token">'fid < 16'</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># just for the sake of showing 15 vs&nbsp; one record...</SPAN>

<SPAN class="comment token"><SPAN># take a look at </SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fresources.arcgis.com%2Fen%2Fhelp%2Fmain%2F10.1%2Findex.html%23%2FSelect%2F001300000005000000%2F" target="_blank">http://resources.arcgis.com/en/help/main/10.1/index.html#/Select/001300000005000000/</A></SPAN>
<SPAN class="comment token"><SPAN># or </SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fdesktop.arcgis.com%2Fen%2Farcmap%2F10.3%2Ftools%2Fcoverage-toolbox%2Fselect.htm" target="_blank">http://desktop.arcgis.com/en/arcmap/10.3/tools/coverage-toolbox/select.htm</A><SPAN> </SPAN></SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\nReselect {0} from {1} then nselect for the other {2} and save to new coverage"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fidfilter<SPAN class="punctuation token">,</SPAN> recCountIn<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN>recCountIn <SPAN class="operator token">-</SPAN> int<SPAN class="punctuation token">(</SPAN>fidfilter<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

infoExpress <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"RESELECT FID LT 16"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"NSELECT"</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\n my test infoExpress: {0}\n&nbsp; but doesn't work"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>infoExpress<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">""</SPAN>"
<SPAN class="comment token"># sample from help pages</SPAN>
infoExpress <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"RESELECT stream_name CN 'AQUEDUCT'"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"NSELECT"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"RESELECT stream_order > 3"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"ASELECT length > 10000"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="string token">""</SPAN>"


<SPAN class="comment token"># Execute Reselect</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Reselect_arc<SPAN class="punctuation token">(</SPAN>tempCover<SPAN class="punctuation token">,</SPAN> tempCoverOut<SPAN class="punctuation token">,</SPAN> infoExpress<SPAN class="punctuation token">,</SPAN> featureType<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</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>‍</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>

This doesn't look like anything that you were trying to do in this thread, but I'm assuming that what you were trying to do is in the other.....bad assumption??? anyway, that's all I can do tonight. Hopefully that is enough to get you going. Have fun!

FredericPiche

also converting to gdb change the shape(geometry) values, losing precision

FredericPiche

I did a quick test (converted one of my coverage into gdb) and i am able to delete a row.

I hope to make my delete work on the coverage since I need to do a clean_arc after deleting stuff

the clean_arc doesn't seem to work on a geodatabase file

JoshuaBixby

My guess, it is a "coverage thing." Even if you contact Esri Support and they log a bug, I don't believe it will be addressed given the problem is with coverages. My advice is to migrate the data from coverages to feature classes in a file geodatabase.

Regarding shapefiles and geodatabases for testing, if you have a license to use ArcPy Data Access cursors, you have all of the tools available for creating shapefiles and feature classes to test them.

FredericPiche

right now i 'm just trying to do a delete, naming convention and everything else will follow 😉

FredericPiche

I don't have a shapefile or geodatabase right now available to me, i cannot test that.

i did test the old arcpy.updatecursor, see my question for the result

NeilAyres

Just to be a little picky about naming variables....

This is a list of field objects (not a straight list) :

fieldList <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>ListFields<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>feature<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN>

This is a list of strings (not a string) :

fieldString <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> <SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">[</SPAN>str<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>x<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>name<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN> <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">for</SPAN> x <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">in</SPAN> fieldList<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">]</SPAN>

I must agree with Joshua. Coverages, really.... Havn't met one of those for a very looong time.

JoshuaBixby

You seem to have narrowed down the issue quite a bit, I recommend contacting Esri Support to see if this is a bug.

Beyond contacting Esri Support, working with coverages continues to get more and more tenuous with each version of ArcGIS for Desktop. Given that the ArcPy Data Access module was introduced back in ArcGIS 10.1, it could be the locking doesn't quite work with coverages because coverages would not have been a focus of the new cursors. Have you tried a similar workflow using the original cursors, the ones that pre-date the arcpy.da cursors?

If you try your exact same workflow on shapefiles and feature classes in a file geodatabase, does it work? If so, then it likely points to an issue with coverages. If not, then the problem lies somewhere in the code and how cursors are being handled.

FredericPiche

thanks, i was looking for that but didn't know it was under highlighting. updated

DanPatterson_Retired

Your code is unreadable, you need to use Python syntax highlighting... follow the ... (3 dots), then select More, then

syntax highlighting, python, and paste your code inside and save.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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