AnsweredAssumed Answered

Using Python to query a text string

Question asked by abutterer on Mar 2, 2018
Latest reply on Mar 2, 2018 by jborgion

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.

Outcomes