I'm trying to use arcpy to recreate clicking on a row in an attribute table, and exporting that row to a new class. I'm iterating through a feature class with 12,000+ records and filtering out features that meet a certain criteria (room classification). Using Select Layer By Attribute and Copy Features I'm getting every single row copied over. I think my where clause might be the issue. Here is my snippet: for row in arcpy . da . SearchCursor ( fc , '*' , sql_clause = ( None , "WHERE CurrentSpaceClass = 'CR_Reg'" ) ) : OID_field = arcpy . Describe ( fc ) . OIDFieldName site = row [ 8 ] room_number = row [ 9 ] pa_ratio = row [ 18 ] angle = row [ 16 ] site_no_space = site . replace ( ' ' , '_' ) room_feature = scratch_gdb + site_no_space . lower ( ) + "_room_" + room_number where = '{0} = {1}' . format ( arcpy . AddFieldDelimiters ( fc , OID_field ) , row [ 0 ] ) arcpy . SelectLayerByAttribute_management ( fc , "NEW_SELECTION" , where ) arcpy . CopyFeatures_management ( fc , room_feature )

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

Select Row from Feature Class and Copy Features Not Working

deleted-user-1_r2dgYuILKY

I'm trying to use arcpy to recreate clicking on a row in an attribute table, and exporting that row to a new class. I'm iterating through a feature class with 12,000+ records and filtering out features that meet a certain criteria (room classification). Using Select Layer By Attribute and Copy Features I'm getting every single row copied over. I think my where clause might be the issue.

Here is my snippet:

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</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> <SPAN class="string token">'*'</SPAN> <SPAN class="punctuation token">,</SPAN>sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"WHERE CurrentSpaceClass = 'CR_Reg'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; OID_field <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>OIDFieldName
&nbsp;&nbsp;&nbsp; site <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; room_number <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; pa_ratio <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">18</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; angle <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">16</SPAN><SPAN class="punctuation token">]</SPAN>

&nbsp;&nbsp;&nbsp; site_no_space <SPAN class="operator token">=</SPAN> site<SPAN class="punctuation token">.</SPAN>replace<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>
&nbsp;&nbsp;&nbsp; room_feature <SPAN class="operator token">=</SPAN> scratch_gdb <SPAN class="operator token">+</SPAN> site_no_space<SPAN class="punctuation token">.</SPAN>lower<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_room_"</SPAN> <SPAN class="operator token">+</SPAN> room_number
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; where <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{0} = {1}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN>OID_field<SPAN class="punctuation token">)</SPAN><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>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN>where<SPAN class="punctuation token">)</SPAN> 
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN>room_feature<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>

Find more posts tagged with

Accepted answers

deleted-user-1_r2dgYuILKY

Ah duh, I just realized I needed to assign arcpy.SelectLayerByAttribute to a variable "selection" and then copy that. That did the trick!

All comments

jjeremy525

Hi I’m trying to do the same thing any chance I can see your entire python script. I want to select layer by attribute with two conditions example like this x = 1 AND b = 2 and export each row that meets this criteria to a new shapefile. I also want to add the feature classes attributes from the row at end of the output name.

deleted-user-1_r2dgYuILKY

Ah duh, I just realized I needed to assign arcpy.SelectLayerByAttribute to a variable "selection" and then copy that. That did the trick!

DarrenWiens2

If you print where (or AddMessage), is it what you're expecting?

Best guess:

where = "{0} = '{1}'".format(arcpy.AddFieldDelimiters(fc,OID_field),row[0])<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

You should consider adding a check to see if anything is selected, otherwise, yes, you'll return the entire original feature class.

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.