In an ArcPro python script I have created a feature layers from a GDB feature class and made a selection. field_values = { } # Field names are identical between the source and the target row_cnt = int ( arcpy . GetCount_management ( selected_layer ) . getOutput ( 0 ) ) cnt = 0 with da . SearchCursor ( selected_layer , update_fields ) as _cursor : for _row in _cursor : update_values = _row [ : - 1 ] _geo = _row [ - 1 ] for i in range ( len ( update_values ) ) : fld = update_fields [ i ] if fld not in field_values : field_values [ fld ] = [ update_values [ i ] ] else : field_values [ fld ] . append ( update_values [ i ] ) # add this row to the excel table for visual comparison of source data to the final row test_rows . append ( update_values ) cnt += 1 The row count of the selected layer is 21, but when I increase the cnt variable by one each time through the cursor, the total number of lines is 167. Has anyone experienced this issue with ArcPy for Pro? Do layer selections in Pro not work with da.Cursors? I was thinking that a naming conflict between the feature class and the layer could be happening so I appended "_lyr" to the end of the layer name.

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

Why is Search Cursor not honoring layer Selection?

RichardHughes

In an ArcPro python script I have created a feature layers from a GDB feature class and made a selection.

field_values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
 <SPAN class="comment token"># Field names are identical between the source and the target</SPAN>
 row_cnt <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>selected_layer<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>
 cnt <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
 <SPAN class="keyword token">with</SPAN> da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>selected_layer<SPAN class="punctuation token">,</SPAN> update_fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> _cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> _row <SPAN class="keyword token">in</SPAN> _cursor<SPAN class="punctuation token">:</SPAN>
       update_values <SPAN class="operator token">=</SPAN> _row<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
       _geo <SPAN class="operator token">=</SPAN> _row<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
       <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>update_values<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
          fld <SPAN class="operator token">=</SPAN> update_fields<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN>
          <SPAN class="keyword token">if</SPAN> fld <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> field_values<SPAN class="punctuation token">:</SPAN>
             field_values<SPAN class="punctuation token">[</SPAN>fld<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>update_values<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
          <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
             field_values<SPAN class="punctuation token">[</SPAN>fld<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>update_values<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
 
 <SPAN class="comment token"># add this row to the excel table for visual comparison of source data to the final row</SPAN>
       test_rows<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>update_values<SPAN class="punctuation token">)</SPAN>
 cnt <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</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>

The row count of the selected layer is 21, but when I increase the cnt variable by one each time through the cursor, the total number of lines is 167.

Has anyone experienced this issue with ArcPy for Pro? Do layer selections in Pro not work with da.Cursors?

I was thinking that a naming conflict between the feature class and the layer could be happening so I appended "_lyr" to the end of the layer name.

Find more posts tagged with

Accepted answers

All comments

bixb0012

Outside of ArcGIS Pro means executed in a separate process from the Pro application, either a standalone script or even a script tool run from within Pro. If I ran code from within the interactive Python window, the selections would be honored, but that was about it.

JoeBorgione

I suspect 'Outside of ArcGIS Pro' refers to using cursors in a stand alone script, possibly calling it as a scheduled task etc..

JimHerberich

I wonder what does "outside of ArcGIS Pro" mean? Everything I am doing is very much "inside" of ArcGIS Pro...

JoeBorgione

Good to know. That's the kind of bug that makes you crazy....

bixb0012

Likely related to a defect already logged:

#BUG-000118589 Search Cursor does not recognize selection sets on table views or feature layers outside of ArcGIS Pro

I has been marked as Implemented in 2.4

JimHerberich

I'm seeing this as new behavior in 2.3. First observed from a Python Toolbox, then taken to the Python window to investigate when it no longer worked as expected. Make a selection on the layer in the map. Pass the layer name to SearchCursor. All rows are processed, not just those selected.

For a layer with 3134 features and 72 are selected:

i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</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><SPAN class="string token">'Feature Service Name\\layer_name'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'ObjectID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
        i <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

i is 3134. In this case the layer comes from a Portal Feature Service. I'll bet that's the source of the trouble. Even tried a brand new project. Same issue.

RichardHughes

So what I've come to realize is that the reference to the feature layer with selection must be made using the feature layer name. It seems that in the past I've used the output from the MakeFeatureLayer_management function as input into other tools, but what actually should be passed is the name of the layer. So I end up using layer.name.

JoeBorgione

Same questions as the other guys, and I'll add:

When/how are you making the selection?

but when I increase the cnt variable by one each time through the cursor,

You increase cnt on line 17, but it's after the the cursor is done. (Same as Dan's question)

I'm not real sure what line # 3 is doing for you....

bixb0012

How are you running this code? In ArcGIS Pro, either the interactive Python window or script tool, or from outside the application?

And, what version of Pro are you running?

DanPatterson_Retired

cnt is used on row 4 and 17, what is its purpose?

or is this a code formatting issue?

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.