Invalid Expression Error

Question

I am trying to write a script that runs a select by location then a subset selection of select by attribute but I keep getting an invalid expression error. The last where clause is to selected any blank fields in the STD_CND field.

arcpy.SelectLayerByLocation_management("Culvert_subset", "INTERSECT", "Cont_Buff")
arcpy.SelectLayerByAttribute_management("Culvert_subset","SUBSET_SELECTION",'"STD_CND" = poor' or '"STD_CND = Very Poor' or '"STD_CND" = ""')

Additionally once this selection is made will it continue (or be saved) through the rest of the script or should I create a new shapefile from it?

Any thoughts? 
Thanks!

MathewCoyle · Answer

You need a closing bracket and the last comma.arcpy.SelectLayerByAttribute_management("Culvert_subset", "SUBSET_SELECTION", '''"STD_CND" in ('poor', 'Very Poor', '')''')

EmilyAgar1 · Answer

I am just trying it in the python window right now, but it will be a piece to a tool that I am working on.
import arcpy
arcpy.env.workspace = "W:\ENG\Geomatics\PROJECT\Python Script"

arcpy.Buffer_analysis("5yrContract_subset", "Cont_Buff", "50 METERS", "FULL", "FLAT", "NONE")

arcpy.SelectLayerByLocation_management("Culvert_subset", "INTERSECT", "Cont_Buff")
arcpy.SelectLayerByAttribute_management("Culvert_subset","SUBSET_SELECTION", '''"STD_CND" in ('poor', 'Very Poor' '')'''

Parsing error <type 'exceptions.SyntaxError'>: invalid syntax (line 8)

MathewCoyle · Answer

Post your exact code you executed and the error you received. Are you trying to do with through a script tool, python window, stand alone script?