Expression for select by attribute

NaimeCelik

Hello, I have unique list  like ProcessedData=["Line1","Line17","Line76"....] and I have a point data in which every point has the line name they belong to in its attribute table. I want to select those points based on their line names but only the ones in that unique list. I am applying the python code below but processing is very slow. I need to select 10000 lines and the process is very slow with the code below. Is there any other way of writing the expression so that it selects them in same time instead of one by one in a for loop ?

for item in ProcessedData:

     Expression= "\"LineName\" = "+ "'"+item+"'" 

     arcpy.SelectLayerByAttribute_management ("PointData", "ADD_TO_SELECTION", Expression)

jskinner

Hi Naime,

Instead of iterating through your list with a 'for' loop, try using 'IN' within your expression to select multiple values.  Ex:

list = ['Alabama', 'Arizona']
list = str(list)[1:-1]
expression = "State_Name IN (" + list + ")"

arcpy.SelectLayerByAttribute_management("COUNTIES", "NEW_SELECTION", expression)