mjhjmtu

Can you please take a look at this snippet and let me know why I am not able to properly pass the Where Clause ('"[NAME_1]" = Ohio') in SearchCursor?

import arcpy
from arcpy import env
def unique_values(table , field):
 with arcpy.da.SearchCursor(table, [field], '"[NAME_1]" = Ohio') as cursor:
 return sorted(row[0] for row in cursor)
uniques = unique_values(r'C:arcgisArcTutorAAAsrcUSA.shp' , 'NAME_2')
for unique in uniques:
 print (unique)

I am getting this error on runtime

Traceback (most recent call last):
 File "<module1>", line 8, in <module>
 File "<module1>", line 7, in unique_values
 File "<module1>", line 7, in <setcomp>
RuntimeError: Unspecified error

Same error on this format as well

with arcpy.da.SearchCursor(table, [field], '"NAME_1" = Ohio') as cursor:

Use AddFieldDelimiters:

The field delimiters used in an SQL expression differ depending on the
format of the queried data. For instance, file geodatabases and
shapefiles use double quotation marks (" "), personal geodatabases use
square brackets ([ ]), and enterprise geodatabases don't use field
delimiters. The function can take away the guess work in ensuring that
the field delimiters used with your SQL expression are the correct
ones.

with single quotes around Ohio and three double quotes surrounding everything:

sql = """0 = 'Ohio'""".format(arcpy.AddFieldDelimiters(table,'NAME_1'))
with arcpy.da.SearchCursor(table,field,sql) as cursor:
 ...

I wasn't able to replicate your error, but try this:

import arcpy 

expression = "NAME_1 = 'Ohio'"

def unique_values(table , field):
 with arcpy.da.SearchCursor(table, [field], where_clause=expression) as cursor:
 return sorted(row[0] for row in cursor)

uniques = unique_values(r'C:arcgisArcTutorAAAsrcUSA.shp' , 'NAME_2')

for unique in uniques:
 print (unique)

The SearchCursor where_clause parameter takes a SQL string as its input. There are more examples here