I am working on a simple application. The user can choose either Numeric values or string values to select (i.e. valName). However if you write the where clause like this: arcpy . SelectLayerByAttribute_management ( lyr , "NEW_SELECTION" , FieldName + opName + "'" + valName + "'" ) It doesn't work for numbers and if you write like this: arcpy . SelectLayerByAttribute_management ( lyr , "NEW_SELECTION" , FieldName + opName + valName ) It doesn't work for strings. Any simple solution without if condition?

This worked for me: if type ( valName ) is str or type ( valName ) is unicode : whereClause = FieldName + opName + "'" + valName + "'" else : whereClause = FieldName + opName + str ( valName ) arcpy . SelectLayerByAttribute_management ( lyr , "NEW_SELECTION" , whereClause )

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 Layer by Attribute in ArcPy

MohammadrezaNikfal1

I am working on a simple application. The user can choose either Numeric values or string values to select (i.e. valName). However if you write the where clause like this:

arcpy<SPAN class="punctuation token">.</SPAN><SPAN class="token function">SelectLayerByAttribute_management</SPAN><SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> FieldName <SPAN class="operator token">+</SPAN> opName <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN> <SPAN class="operator token">+</SPAN> valName <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

It doesn't work for numbers and if you write like this:

arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN>FieldName <SPAN class="operator token">+</SPAN> opName <SPAN class="operator token">+</SPAN> valName<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

It doesn't work for strings.

Any simple solution without if condition?

Find more posts tagged with

Accepted answers

MohammadrezaNikfal1

This worked for me:

<SPAN class="keyword token">if</SPAN> type<SPAN class="punctuation token">(</SPAN>valName<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">is</SPAN> str <SPAN class="operator token">or</SPAN> type<SPAN class="punctuation token">(</SPAN>valName<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">is</SPAN> unicode<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; whereClause <SPAN class="operator token">=</SPAN> FieldName <SPAN class="operator token">+</SPAN> opName <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN> <SPAN class="operator token">+</SPAN> valName <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN>
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; whereClause <SPAN class="operator token">=</SPAN> FieldName <SPAN class="operator token">+</SPAN> opName <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>valName<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> whereClause<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

RandyBurton

You can also use "in"

<SPAN class="keyword token">if</SPAN> type<SPAN class="punctuation token">(</SPAN>valName<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">,</SPAN> unicode<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

MohammadrezaNikfal1

This worked for me:

<SPAN class="keyword token">if</SPAN> type<SPAN class="punctuation token">(</SPAN>valName<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">is</SPAN> str <SPAN class="operator token">or</SPAN> type<SPAN class="punctuation token">(</SPAN>valName<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">is</SPAN> unicode<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; whereClause <SPAN class="operator token">=</SPAN> FieldName <SPAN class="operator token">+</SPAN> opName <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN> <SPAN class="operator token">+</SPAN> valName <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN>
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; whereClause <SPAN class="operator token">=</SPAN> FieldName <SPAN class="operator token">+</SPAN> opName <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>valName<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> whereClause<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

<SPAN class="string token">"{} {} '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>FieldName<SPAN class="punctuation token">,</SPAN>opName<SPAN class="punctuation token">,</SPAN>valName<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> type<SPAN class="punctuation token">(</SPAN>valName<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">is</SPAN> str <SPAN class="keyword token">else</SPAN> <SPAN class="string token">"{} {} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>FieldName<SPAN class="punctuation token">,</SPAN>opName<SPAN class="punctuation token">,</SPAN>valName<SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

You might try something like:

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.