using where clause for selecting more than one value in the field in arcpy.Select_analysis

Question

I have a problem in using the Select_analysis or Select by attribute, what I need t do, is to extract all the residential uses from a land use feature class, and make a feature class for residential, but there are more than one value for residential uses like (''Residential and driving school'', ''mixed commercial Residential'', ''mixed residential with other uses'', 'residential') As I use the following script:

uses_FieldForLandUses= arcpy.GetParameterAsText(4) # field of land use
Values_of_Residential_uses_in_Land_use_field= arcpy.GetParameterAsText(5) # type: string (multi value)- all the values for residential
Output_Residential_uses_parcels= arcpy.GetParameterAsText(6) # type: feature class    
#Variables for residential uses
valueList = [x.strip() for x in Values_of_Residential_uses_in_Land_use_field.split(";")]

FieldInfo = arcpy.ListFields(inputLandUseParcels_FeatureClass,uses_FieldForLandUses)[0]
fieldType = FieldInfo.type


if uses_FieldForLandUses  == '#' or not uses_FieldForLandUses:
    Field = "LAND_USE" # provide a default value if unspecified

# Process: Select

if fieldType == 'String':
    where = "{} IN ('{}')".format(arcpy.AddFieldDelimiters(inputLandUseParcels_FeatureClass,uses_FieldForLandUses), "', '".join(valueList))


arcpy.Select_analysis(inputLandUseParcels_FeatureClass, Output_Residential_uses_parcels, where)

but when selecting more than one value for residential, I get the following error:

ExecuteError: ERROR 000358: Invalid expression land_use IN (''Residential and driving school'', ''mixed commercial Residential'', ''mixed residential with other uses'', 'residential')
Failed to execute (Select).

Answer 1

In the result the expression it has returned two single quotes, it should be or with one single quote or with double quote. I suggest to try it:

where = "{} in ({})".......

Also do not forget if the source is .gdb Expression should be:

**Fieldname = 'value'**

if the source is .mdb: Expression is:

**[Fieldname] = value**

And if it is shapefile: Expression is:

**"Fieldname" = 'value'**

If you respect the expression for each type of input it should work.

Answer 2

First of all: write a line before select_analysis: print where Just to view what "where clause" returns.

Than try to convert it in specific expressions: For example: If your feature class "inputLandUseParcels_FeatureClass" is shapefile, than "where" should be:

'"Fieldname" in ("value1","value2","value3")'

if the input feature is inside ".gdb" or ".mdb" see the example in first reply.

Answer 3

This is what I want to do that the residential values is the user input , so I can not write '"Fieldname" in ("value1","value2","value3")'

Answer 4

The problem are the doubled single quotes in your where clause string. I did changes in valueList Generation and the assignment of the where variable:

uses_FieldForLandUses= arcpy.GetParameterAsText(4) # field of land use
Values_of_Residential_uses_in_Land_use_field= arcpy.GetParameterAsText(5) # type: string (multi value)- all the values for residential
Output_Residential_uses_parcels= arcpy.GetParameterAsText(6) # type: feature class    
#Variables for residential uses

if fieldType == 'String':
    valueList = ["'" + x.strip() + "'" for x in Values_of_Residential_uses_in_Land_use_field.split(";")]
else: # e.g. integer
    valueList = [x.strip() for x in Values_of_Residential_uses_in_Land_use_field.split(";")]

FieldInfo = arcpy.ListFields(inputLandUseParcels_FeatureClass,uses_FieldForLandUses)[0]
fieldType = FieldInfo.type


if uses_FieldForLandUses  == '#' or not uses_FieldForLandUses:
    Field = "LAND_USE" # provide a default value if unspecified

# Process: Select
where = "{} IN ('{}')".format(arcpy.AddFieldDelimiters(inputLandUseParcels_FeatureClass,uses_FieldForLandUses), ", ".join(valueList))

arcpy.Select_analysis(inputLandUseParcels_FeatureClass, Output_Residential_uses_parcels, where)