(ArcGIS Pro 2.2) In ArcMap 10.5.1 when I select a number of features and apply a search cursor to it, the cursor examines the selected features only but in ArcGIS Pro it does not: #arcmap, python 2.x: import arcpy with arcpy . da . SearchCursor ( "National_Grid" , 'USNG' ) as cursor : for row in cursor : print row [ 0 ] . . . 12TVL320100 12TVL320120 12TVL340120 12TVL340140 12TVL360120 12TVL360140 ##################### #ArcGIS Pro python 3.x: import arcpy fc = r 'C:\LAS_Data\NationalGrid\National_Grid.shp' fields = 'USNG' gridlist = [ ] with arcpy . da . SearchCursor ( fc , fields ) as cursor : for row in cursor : gridlist . append ( row [ 0 ] ) gridlist [ '12TUK920880' , '12TUK920900' , '12TUK920920' , '12TUK920940' , '12TUK920960' , '12TUK920980' , '12TUK940840' , '12TUK940860' , '12TUK940880' , '12TUK940900' , '12TUK940920' , '12TUK940940' , '12TUK940960' , '12TUK940980' , '12TUK960840' , '12TUK960860' , '12TUK960880' , '12TUK960900' , '12TUK960920' , '12TUK960940' , etc , etc , etc . . . . ] Bummer. Is this a new known (intended) feature? Is there a way to convince the search cursor to honor the selected set?

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

da.SearchCursor() not honoring selected set in ArcGIS Pro

JoeBorgione

(ArcGIS Pro 2.2)

In ArcMap 10.5.1 when I select a number of features and apply a search cursor to it, the cursor examines the selected features only but in ArcGIS Pro it does not:

<SPAN class="comment token">#arcmap, python 2.x:</SPAN>

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"National_Grid"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USNG'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
12TVL320100
12TVL320120
12TVL340120
12TVL340140
12TVL360120
12TVL360140


<SPAN class="comment token">#####################</SPAN>

<SPAN class="comment token">#ArcGIS Pro python 3.x:</SPAN>

<SPAN class="keyword token">import</SPAN> arcpy
fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\LAS_Data\NationalGrid\National_Grid.shp'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="string token">'USNG'</SPAN>
gridlist <SPAN class="operator token">=</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>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN><SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gridlist<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

gridlist
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'12TUK920880'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920900'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920920'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920940'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940840'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940860'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940880'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940900'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940920'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940940'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960840'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960860'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960880'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960900'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960920'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960940'</SPAN><SPAN class="punctuation token">,</SPAN>etc<SPAN class="punctuation token">,</SPAN>etc<SPAN class="punctuation token">,</SPAN>etc<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="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>

Bummer.

Is this a new known (intended) feature? Is there a way to convince the search cursor to honor the selected set?

Vind meer berichten getagd met

Accepted answers

JoshuaBixby

I am not sure what is going on. I am running 2.2.1, and I just tested passing a layer with a selection set to a search cursor, and the cursor only enumerated the selected records. And, the layer was based on a shape file.

All comments

MikeVolz

It looks like you are using a shapefile as your source. Can you try the same script on another source such as a file gdb and see if the same behavior occurs?

JoeBorgione

Good idea, but same results none the less...

<SPAN class="keyword token">del</SPAN> fc
fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'J:\BuildingFootPrints\Emigration\EmigrationFootPrints\EmigrationFootPrints.gdb\NatGrid_FC'</SPAN>
gridlist <SPAN class="operator token">=</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>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN><SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gridlist<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
gridlist
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'12TUK920880'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920900'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920920'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920940'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK920980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940840'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940860'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940880'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940900'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940920'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940940'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK940980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960840'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960860'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960880'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960900'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960920'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960940'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK960980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980780'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980800'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980820'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980840'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980860'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980880'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980900'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980920'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980940'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980960'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUK980980'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'12TUL920000'</SPAN><SPAN class="punctuation token">,</SPAN> blah<SPAN class="punctuation token">,</SPAN> blah<SPAN class="punctuation token">,</SPAN>blah<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><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>

JoshuaBixby

Where are you running the code, from a Command Prompt, and IDE, or the interactive Python window in Pro?

JoeBorgione

for now in the ArcGIS Pro python window. That's typically how I test code: run commands there, and when the work, copy and paste into a python file and execute as such...

JoshuaBixby

Your code snippets above are not equivalent. Your ArcMap snippet is passing a layer to the search cursor while your Pro snippet is passing a feature class. Feature classes and tables don't have selections against them, layers and table views do. Try passing the layer to the Search Cursor in Pro.

JoeBorgione

Another good idea but with the same results... Sigh....

JoeBorgione

Okay. Another Joe loves Pro so much thread. It's not software; it's an adventure...

I opened up a new project and added a polygon feature class. I created a layer file from it (arcpy.MakeFeatureLayer_management()).

Selecting 4 polygons in the layer file, I ran the search cursor and it returned the field data in the specified selected records. Then I ran it directly on the feature class with a few features selected. Works just fine.

Please refer to the above line that starts with Okay...

Doe mee aan het gesprek

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

Snelle Links

Alle Gemeenschappen
Recente Berichten
Gevolgde Inhoud
Community Hulp

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