Using Select Layer By Attribute in Python Script Tool

Question

I just want to try to use a Python script to select specific roads in my Layer called "Route_01_Shatin" and so I coded as below:

arcpy.management.SelectLayerByAttribute('Route_01_Shatin', 'NEW_SELECTION', "\"ALIAS_ENAM\" = \'Roadabout\'")

but then when I ran it, I did not receive any error messages but none of the roads are selected.

What is my problem?

Does that field have values of Roadabout or might they be Roundabout? — PolyGeo, Feb 16, 2020 at 5:56
You don't need to escape single-quotes inside a double-quote string. — Vince, Feb 16, 2020 at 11:57
Does it work if you select by attributes using the same clause in Pro directly, without a script? Is the layer in a shapefile or database? — Son of a Beach, Feb 16, 2020 at 21:15

PolyGeo · Accepted Answer · 2020-02-20 09:28:18Z

0

If your field named ALIAS_ENAM of your layer named Route_01_Shatin has any values of 'Roadabout', then I think this should work:

arcpy.management.SelectLayerByAttribute('Route_01_Shatin', 'NEW_SELECTION', "ALIAS_ENAM = 'Roadabout'")

answered Feb 20, 2020 at 9:28

PolyGeo♦

65.1k29 gold badges109 silver badges338 bronze badges

Add a comment |

1 Answer 1