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

Using Python to query a text string

AaronButterer

I'm just getting started with Python and was following the example in: Using Feature Layers | ArcGIS for Developers

I was able to follow the example but then I tried to manipulate it to use my data. Everything was good until I got to the query. I was able to query the numerical data fine but when I tried to pull a text value I couldn't make it work.

I tried a couple different ways but the one that seems to closest (to my admittedly untrained eye) is:

query_result1 = feature_layer.query(where='recordCulvertCorrect=' "no"',
out_fields='objectid,globalid,Date_,CulvertName,pullCulvertMaterial,pullCulvertDiameter')

My guess is it has to do with the way I am trying to work with the text string but I can't see to find what I'm looking for on line. Any help is appreciated.

Find more posts tagged with

Accepted answers

jskinner

Hi Aaron,

Try the following:

query_result1 = feature_layer.query(where="recordCulvertCorrect='no'",
out_fields='objectid,globalid,Date_,CulvertName,pullCulvertMaterial,pullCulvertDiameter')

All comments

JoeBorgione

A bit after the fact but something I like to do is create a where/select statement to a variable. This approach I use a lot because I'm always plowing through a list in a for loop:

select <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OBJECTID = {}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>street_name_list<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"view"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"ADD_TO_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN>select<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

So the variable 'select' is the 'where clause' in select layer by attribute method:

SelectLayerByAttribute_management (in_layer_or_view, {selection_type}, {where_clause})

AaronButterer

That did it. Thanks!

JamesCrandall

Just a quick guess.

query_result1 <SPAN class="operator token">=</SPAN> feature_layer<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"recordCulvertCorrect='no'"</SPAN><SPAN class="punctuation token">,</SPAN> out_fields<SPAN class="operator token">=</SPAN><SPAN class="string token">'objectid,globalid,Date_,CulvertName,pullCulvertMaterial,pullCulvertDiameter'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

jskinner

Hi Aaron,

Try the following:

query_result1 = feature_layer.query(where="recordCulvertCorrect='no'",
out_fields='objectid,globalid,Date_,CulvertName,pullCulvertMaterial,pullCulvertDiameter')

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.