add a list in arcpy.MakeFeatureLayer_management

danielROUFFART1

Hi! i ty to make

 

 

 

 

output = r'C:\Temp\test.gdb\BAV1'
target = r'C:\download

fcs2 = [a, b, c, d]
# Set the workspace
arcpy.env.workspace = ready
for x in range(len(fcs2)):
    arcpy.MakeFeatureLayer_management(fcs2, output)

arcpy.SelectLayerByAttribute_management(output, 'NEW_SELECTION', "city = 'Paris'")

arcpy.CopyFeatures_management(output, target)

but i've got an error message, can you help me about my script for put my list please

Anonymous User

If your fields change between featureclasses, and the sql needs to change between each featureclass, you can use if/elif to create your sql.

arcpy.env.overwriteOutput = True #<- move to top of script since it only needs to be set once


for fc in fcs2:
    # fichier temporaire d'affinage de la selection
    flds = [f.name for f in arcpy.ListFields(fc)]
    # create empty whereclause variable
    whereclause = None

    if 'commune' in flds:
        whereclause = f"""{arcpy.AddFieldDelimiters(fc, 'commune')} = 'Perpignan'"""

    elif 'nomcom' in flds:
        # build the query using field deliminators
        whereclause = f"""{arcpy.AddFieldDelimiters(fc, 'nomcom')} = 'SALEILLES'"""

    else:
        print(f'commune not found in {fc}')

    if whereclause:
        # describe first to get the name
        fc_desc = arcpy.Describe(fc)
        print("fc_desc")
        print (fc_desc)
        # create the temp layer with selection
        tmpLyr = arcpy.MakeFeatureLayer_management(fc, fc_desc.name + '_lyr', whereclause)
        out_name = fc_desc.baseName + '_export'
        print (out_name)
        new_name = fc_desc.name.replace('.','_').replace('rezo_h','')
        print(new_name)
        ditched_features_path = os.path.join(out_name, sauve + "\_"+ new_name)
        print (ditched_features_path)
        # copie de la selection en shape
        arcpy.CopyFeatures_management(tmpLyr, ditched_features_path)
    else:
        print ("no data")