Trying to figure out what the class_field variable is in this query * fc is the Feature Class * Class_field is WHAT? * name_field is the field value? import arcpy fc = 'c:/base/data.gdb/roads' class_field = 'Road Class' name_field = 'Name' # Create an expression with proper delimiters expression = arcpy . AddFieldDelimiters ( fc , name_field ) + ' = 2' # Create a search cursor using an SQL expression with arcpy . da . SearchCursor ( fc , [ class_field , name_field ] , where_clause = expression ) as cursor : for row in cursor : # Print the name of the residential road print ( row [ 1 ] )

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

Search Cursor

jaykapalczynski

Trying to figure out what the class_field variable is in this query

fc is the Feature Class
Class_field is WHAT?
name_field is the field value?

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

fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'c:/base/data.gdb/roads'</SPAN>
class_field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Road Class'</SPAN>
name_field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Name'</SPAN>

<SPAN class="comment token"># Create an expression with proper delimiters</SPAN>
expression <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> name_field<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">' = 2'</SPAN>

<SPAN class="comment token"># Create a search cursor using an SQL expression</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> <SPAN class="punctuation token">[</SPAN>class_field<SPAN class="punctuation token">,</SPAN> name_field<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where_clause<SPAN class="operator token">=</SPAN>expression<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="comment token"># Print the name of the residential road</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</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>

Find more posts tagged with

Accepted answers

MitchHolley1

Please read up on cursors:

SearchCursor—Data Access module | ArcGIS for Desktop

All comments

curtvprice

I moved the correct answer to Mitch Holley‌ who provided a link to the help, because I can. This very general question posed is well-answered by the Esri documentation in this case, and includes many useful examples.

jaykapalczynski

Trying this

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

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\\Users\\xyz\\AppData\\Roaming\ESRI\\Desktop10.4\\ArcCatalog\\xyz@xyz.sde"</SPAN>

fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Inspection_2"</SPAN>

class_field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'regulations'</SPAN>
name_field <SPAN class="operator token">=</SPAN> <SPAN class="string token">'region_1'</SPAN>

<SPAN class="comment token"># Create an expression with proper delimiters</SPAN>
expression <SPAN class="operator token">=</SPAN> u<SPAN class="string token">'{} = No'</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> class_field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Create a search cursor using an SQL expression</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> <SPAN class="punctuation token">[</SPAN>class_field<SPAN class="punctuation token">,</SPAN> name_field<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where_clause<SPAN class="operator token">=</SPAN>expression<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="comment token"># Print the name of the residential road</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0}, {1}'</SPAN><SPAN class="punctuation token">.</SPAN>format<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> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</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>

Get this error:

Traceback (most recent call last):
File "C:\Users\adminjk\Desktop\PythonSync\Python Scripts\SearchCursor2.py", line 16, in <module>
for row in cursor:
RuntimeError: Attribute column not found [42S22:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'No'.] [DGIF_TEST.DBO.Inspection_2]

jaykapalczynski

I now started using this example: not sure if I use a WHERE clause or sql_clause....very new to this so please forgive my ignorance.

But need to insert a WHERE clause : safteysign = Yes OR regulations = No

import arcpy

arcpy.env.workspace = "C:\\Users\\xyz\\AppData\\Roaming\ESRI\\Desktop10.4\\ArcCatalog\\xyz@xyz.sde"

fc = "Inspection"

fields = ['safteysign', 'regulations']

# Use ORDER BY sql clause to sort field values
for row in arcpy.da.SearchCursor(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fc, fields, sql_clause=(None, 'regulations')):
&nbsp;&nbsp;&nbsp; print('{0}, {1}'.format(row[0], row[1]))‍‍‍‍‍‍‍‍‍‍‍‍<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>

RebeccaStrauch__GISP

Have you printed out your expression to make sure it is building correctly? Have you tried to test to make sure it works manually and to make sure there are records being returned? Maybe your return set is null/empty?

edit: btw, it might be better to include the code you are actaully testing v's just a couple of the example in the help. Might be something others can see and test in that.

RebeccaStrauch__GISP

Prints name of the residential road

Yes, so the sample us printing the value of the field "Name". I thought you wanted to print out the value of the class_field field (that is the road class field) which should be row[0]