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

how to check if cursor object is empty?

kyleturner

It seems an easy task, but I can't figure out how to check if the searchcursor object is empty.
I know that it is empty because the query fails....i.e. arcpy.searchcursor(FC, query).
However, even if it (arcpy.searchcursor..) fails, it still returns a geoprocessing cursor object...

rows = gp.SearchCursor(crosswalk_dbf,query)

print rows ---> returns
<geoprocessing cursor object object at 0x029C7CC0>

I can't check if it's empty, because, well, it's not.
And for reasons I obviously don't understand.......

rows = gp.SearchCursor(crosswalk_dbf,query)
for row in rows:
if not row.isNull(fieldname)

------------

is always 'true'.

Please help.

I'm using Arc10 SP3, win 7 64bit.

Many thanks.

Find more posts tagged with

Accepted answers

All comments

blake.terhune

I agree that I wasn't too keen on having to "consume the iterable" and reset it. I had tried the .next() approach and got the StopIteration error but wasn't quite sure how to handle it; thank you Bruce Harold‌ for mentioning that. That last option with row = None is clever and seems to solve both problems; thanks for sharing.

bixb0012

Since the cursor itself will raise a StopIteration error if there isn't a row to request, I guess I don't understand the value of wrapping it in a generator function to raise a StopIteration error.

bharold

Another one is wrapping the cursor in a generator function and seeing if StopIteration is raised when you request a row.

bixb0012

As Xander Bakker‌ points out, the geoprocessing tool approach to addressing your issue involves creating a feature layer and counting that, and then passing the feature layer to the search cursor if there are results.

Looking at it from purely a Python perspective, i.e., not involving geoprocessing tools, the major issue with the code provided is that it completely consumes the iterable to determine if there is just one or more records. There are several ways in Python to check if an iterable is empty and then do one thing or another depending on the results.

One approach that doesn't fully consume the iterable to check for the existence of items uses next() with a sentinel value:

s_cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> s_cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> next<SPAN class="punctuation token">(</SPAN>s_cursor<SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; s_cursor<SPAN class="punctuation token">.</SPAN>reset<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> s_cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> row
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Cursor is empty!"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Another approach sets the variable for holding what is returned by the iterable to a sentinel value and then checks after processing the iterable to see if anything was processed:

row <SPAN class="operator token">=</SPAN> None
<SPAN class="keyword token">with</SPAN> s_cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> s_cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> row
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Cursor is empty!"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

XanderBakker

To check if a applying a where clause returns no results can also be done with the GetCount tool. Just make a featurelayer and check the result. Below some examples including using the search cursor on empty results, which really is no problem at all.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> arcpy
&nbsp;&nbsp;&nbsp; fc1 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Xander\GeoNet\Ellipse\data.gdb\Ellipses'</SPAN>
&nbsp;&nbsp;&nbsp; fc2 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'D:\Xander\GeoNet\Ellipse\data.gdb\Ellipses_empty'</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># get count on a featureclass</SPAN>
&nbsp;&nbsp;&nbsp; cnt1 <SPAN class="operator token">=</SPAN> getCount<SPAN class="punctuation token">(</SPAN>fc1<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; cnt2 <SPAN class="operator token">=</SPAN> getCount<SPAN class="punctuation token">(</SPAN>fc2<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"fc1 has {0} features"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>cnt1<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"fc2 has {0} features"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>cnt2<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Cursor on a featureclass with features</SPAN>
&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> None
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc1<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OID@'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oid <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> max_oid <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> oid
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> oid <SPAN class="operator token">></SPAN> max_oid<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> oid
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"max_oid for fc1:"</SPAN><SPAN class="punctuation token">,</SPAN> max_oid

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Cursor on a featureclass without features</SPAN>
&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> None
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc2<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OID@'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oid <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> max_oid <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> oid
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> oid <SPAN class="operator token">></SPAN> max_oid<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> oid
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"max_oid for fc2:"</SPAN><SPAN class="punctuation token">,</SPAN> max_oid


&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># get count on a feature layer (with where clause)</SPAN>
&nbsp;&nbsp;&nbsp; where <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Ellipse = 1"</SPAN>
&nbsp;&nbsp;&nbsp; fl1 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc1<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"flay1"</SPAN><SPAN class="punctuation token">,</SPAN> where<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; fl2 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc2<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"flay2"</SPAN><SPAN class="punctuation token">,</SPAN> where<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; cnt1 <SPAN class="operator token">=</SPAN> getCount<SPAN class="punctuation token">(</SPAN>fl1<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; cnt2 <SPAN class="operator token">=</SPAN> getCount<SPAN class="punctuation token">(</SPAN>fl2<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"fl1 has {0} features"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>cnt1<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"fl2 has {0} features"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>cnt2<SPAN class="punctuation token">)</SPAN>


&nbsp;&nbsp; <SPAN class="comment token"># Cursor on a featurelayer (where clause) with features</SPAN>
&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> None
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fl1<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OID@'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oid <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> max_oid <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> oid
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> oid <SPAN class="operator token">></SPAN> max_oid<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> oid
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"max_oid for fl1:"</SPAN><SPAN class="punctuation token">,</SPAN> max_oid


&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Cursor on a featureclass (where clause) with features, but without results</SPAN>
&nbsp;&nbsp;&nbsp; where <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Ellipse = -1"</SPAN> <SPAN class="comment token"># there are no features witch match this where clause</SPAN>
&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> None
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc1<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'OID@'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> where<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oid <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> max_oid <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> oid
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">elif</SPAN> oid <SPAN class="operator token">></SPAN> max_oid<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; max_oid <SPAN class="operator token">=</SPAN> oid
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"max_oid for fc1 (with where clause, no match):"</SPAN><SPAN class="punctuation token">,</SPAN> max_oid


<SPAN class="keyword token">def</SPAN> <SPAN class="token function">getCount</SPAN><SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> int<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>fc<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">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation 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>‍</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 will print:

fc1 has <SPAN class="number token">722</SPAN> features
fc2 has <SPAN class="number token">0</SPAN> features
max_oid <SPAN class="keyword token">for</SPAN> fc1<SPAN class="punctuation token">:</SPAN> <SPAN class="number token">722</SPAN>
max_oid <SPAN class="keyword token">for</SPAN> fc2<SPAN class="punctuation token">:</SPAN> None
fl1 has <SPAN class="number token">361</SPAN> features
fl2 has <SPAN class="number token">0</SPAN> features
max_oid <SPAN class="keyword token">for</SPAN> fl1<SPAN class="punctuation token">:</SPAN> <SPAN class="number token">361</SPAN>
max_oid <SPAN class="keyword token">for</SPAN> fc1 <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">with</SPAN> where clause<SPAN class="punctuation token">,</SPAN> no match<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> None<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

blake.terhune

I know I'm playing necromancer and raising this discussion from the dead but I was looking for an answer to this question and found my own solution that I thought I would post. Maybe someone else has come up with something better by now.

Thanks to Joshua Bixby‌ for his blog post on cursors, here's what I came up with:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> s_cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> sum<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN> <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> s_cursor<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; <SPAN class="comment token">## Counts items in cursor, returns 0 if empty</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; s_cursor<SPAN class="punctuation token">.</SPAN>reset<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token">## Return cursor back to the first row after counting</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> s_cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Process rows</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Cursor is empty!"</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>

The check for rows will iterate through the cursor leaving nothing for the .next() item so you have to .reset() the cursor to start from the beginning again. In my case, I couldn't just count the rows with GetCount_management() in the original feature class because I was using a where clause in the search cursor.

ChrisSnyder

An even shorter way:

if arcpy.SearchCursor(myTable, sql_statement).next() == None:
   print "Empty cursor!"

The only trick though is to figure out if your SQL is returning any records or not... Which could be accomlished through a cursor statment like the one above or a combo of the MakeFeatureLayer/MakeTableView and the GetCount tool. Which one is faster? I dunno... It would also improve performance if the fields in your SQL were properly indexed also.

PhilMorefield

Here's another way...

import types
import arcpy as ap

rows = ap.SearchCursor(myTable, sql_statement)
row = rows.next()

if type(row) != types.NoneType:
    # do a bunch of work

GeorgeNewbury

Be careful when you do the 'row = rows.next()' because then you are moving the cursor forward, which could throw off any subsequent looping.

I prefer the method Matthew described:

    row, rows= None, None
    rows= arcpy.SearchCursor(inputFC)
    for row in rows:
        -- do work---
            
    del row, rows

Of course you can put your query clause in there to or do any sorting. If you wanted to know how many records were in there you could add a count:

    rowCount = 0
    row, rows= None, None
    rows= arcpy.SearchCursor(inputFC)
    for row in rows:
        rowCount += 1
        -- do work---
            
    del row, rows

If the count is 0 then rows was empty. It used be to be that you would use the '.next()' method for a while loop, but now with the new syntax ('row in rows') I try to avoid the next method.

-George

kyleturner

Thanks for your help gentlemen.

Chris, I tried your getcount_management option, but it seems that you can only use it on a layer/fc. I tried count = int(gp.getcount_management(rows).getoutput(0))......which fails.
I suppose I could have made a layer, but I figured out another way.

Here's how I fixed it:
rows = gp.SearchCursor(fc,query)
row = rows.next()
if not (row == None):
do what you need to do

elif (row == None):
well, then someone needs to fix the dataset.

Thanks again gentlemen for your time.
Cheers.

kyleturner

If your cursor is empty, it will never step in. Nothing in the loop
for row in rows:
will execute because there is no row in rows, if you follow.

So I tested your code and came back with 4 rows, is that right? i am confused, I thought you wanted to test if the cursor object was empty?

Duh...I should have tested for row == None outside the for/loop, being sure to set row = None before the call to Searchcursor....duh.
Yes, the code as shown will find something, because "AirfieldSurface" is in the dbf. However, change the FCls30 variable to something like, ZZZ, and see what happens.

Thanks again.

ChrisSnyder

Yes, like Mathew says, your issue is that the SQL statement you provide in your cursor is probably incorrect and is returning 0 records (which is why you get no cursor row object). My code will only run the cursor if your query returns 1 or more records.

ChrisSnyder

Sure - see (code comments denoted by the # symbol):

#STEP1: Execute a SQL query (the MakeFeatureLayer tools is probably the quickest way to do this)
arcpy.MakeFeatureLayer_management(indxTileFC, indxTileFL, "HCPUNIT_NM <> 'OESF')
#STEP2: Are any records returned? If 0 records satisfy the SQL query, then let us know! If 0 records are returned, the SQl query is probably incorrect!!!
if int(arcpy.GetCount_management(indxTileFL).getoutput(0)) == 0:
   print "Query returned no records!"
#STEP3: If there are records returned by the query, then run a search cursor and look for Null field values in MY_FIELD
else:
   #Create a search cursor object using the same query as the one in the MakeFeatureLayer 
   searchRows = arcpy.SearchCursor(indxTileFC, "HCPUNIT_NM <> 'OESF')
   #For each row in the collection of search cursor rows
   for searchRow in searchRows:
      #if the value in the "MY_FIELD" field is Null let us know... If theer are no Null values in the MY_FIELD field, then no message will be printed.
      if searchRow.MY_FIELD == None: #Another way: if searchRow.isNull("MY_FIELD") == True:
         print "MY _FIELD is Null!"
   #Delete the search cursor objects so the read lock is released on the search cursor table
   del searchRow, searchRows

MathewCoyle

If your cursor is empty, it will never step in. Nothing in the loop

for row in rows:

will execute because there is no row in rows, if you follow.

So I tested your code and came back with 4 rows, is that right? i am confused, I thought you wanted to test if the cursor object was empty?

kyleturner

All:

To help expedite this matter, I attached a very brief snippet of my code along with the necessary table (the table is zipped up because I can't attach a dbf).
This is really starting to make me crazy.

Chris: Your suggestion looks like it's the ticket, but can you 'dumb it down' a bit.

import arcgisscripting
gp = arcgisscripting.create(9.3)
table = 'C:/Users/lilaandmax/Downloads/AttributeCrosswalk.dbf'
####### the following three0FC works 
three0FC = 'AirfieldSurface'
######## but if you do this, three0FC = 'XAirfieldSurface'  ## nothing happens 
query = "Three0FCla = '" + three0FC + "'"
row, rows = None, None
rows = gp.SearchCursor(table, query)

for row in rows:
    if row.isNull("Three0FCla"):
        print "isNull"
    elif row == None:
        print "None"
    elif row == "":
        print "emptyspace"
    else:
        print row.getValue("Three0FCla")

Thanks

AttributeCrosswalk.zip

search.py.zip

MathewCoyle

You need to copy and paste the exact indentation you are using, that is probably where your error is.

kyleturner

Thanks for the help Mathew. (Chris I haven't tried your suggestion yet.)

Still no go.
I even tried a very basic search from the Python cursor. Here's what I tried:

> row, rows = None, None
> query = "Fieldname = '" + "'" variable + "'" --- The quotes are right in my code I know for sure, maybe not here tho.
> table = "C:/path/to/data.dbf
> rows = row.searchcursor(table, query)
> for row in rows:
        if row == None:
           print 'asdf'
        if row == 'None':    ### just to be sure
           print 'jkl'
        if not row == 'None':
          print 'not asdf'
        if not row == None:
          print 'not jkl'

And nothing is printed.   Nothing at all.

What's the deal.

Thanks

ChrisSnyder

Maybe this would help?

arcpy.MakeFeatureLayer_management(indxTileFC, indxTileFL, "HCPUNIT_NM <> 'OESF'); showGpMessage()
if int(arcpy.GetCount_management(indxTileFL).getoutput(0)) == 0:
   print "Query returned no records!"
else: #if there are records returned by the query, then run a search cursor and look for Null field values in MY_FIELD
   searchRows = arcpy.SearchCursor(indxTileFC, "HCPUNIT_NM <> 'OESF')
   for searchRow in searchRows:
      if searchRow.MY_FIELD == None: #Another way: if searchRow.isNull("MY_FIELD") == True:
         print "MY _FIELD is Null!"
   del searchRow, searchRows

MathewCoyle

I am sure there is a more elegant way, but you could do something simple like...

checkvar = "cursor empty"
rows = arcpy.SearchCursor(fc, query)
for row in rows:
    if checkvar == "cursor empty":
        checkvar = "cursor full"
print checkvar

Here's something probably better, early morning brain not working yet.

row = None
rows = arcpy.SearchCursor(fc, query)
for row in rows:
    #cursor things
if not row:
    print "cursor was empty"

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.