Merging multiple feature layers into one layer

KatelynNiesen

I'm working on a project in ArcPro 2.3 that has multiple independent feature layers, as in over 50, that need to be combined into one working feature layer. At the moment, each layer is a simple hand-drawn polygon. The polygons all regard the same category of data so I would ideally like to have the layers combined for easier processing, as well as all attribute data into one table. I plan to eventually join a data set to the combined attribute table, hence the need for the feature layers to all be on one layer. 

Anyway, does anyone know of a tool or workflow that I could go about for combining the large amount of feature layers into one layer? 

Apologies if this is unclear.

Thank you!

DamB99

I know that this post is ancient but still am very surprised that nobody replied to this simple question. Am posting here for a reference.

The easiest option is to create a New Group Layer with specific name in my case is aaa. Then put all your layers under this Group layer (see the attached image)

Then open Python Window (View > Python Window) and type the content below as appropriate

 

#proj = arcpy.mp.ArcGISProject('CURRENT')
# First check which data frame is relevant to you. 
#for i in proj.listMaps():
#    print(i.name)
# in my case it prints 
#BaseMap 
#Map
#So the one I want to loop through is second item in a list so [1], first (in this case BaseMap is [0], third would be [2] ...
# Define which project file are you processing. In this case current
proj = arcpy.mp.ArcGISProject('CURRENT')
# Select your Map Frame
mf = proj.listMaps()[1]
# Get list of all Layers, Group Layers under this Map Frame
mfl = mf.listLayers()
lyr_names = [] # To create an empty list to later contain list of names
# Loop through the full list of layers
for ly in mfl:
    # Checking that it is a correct Group Layer
    if ly.isGroupLayer and ly.name == "aaa":
        # just for your reference. completely unecessary
        print(ly)# it will print aaa in this case
        # adding all layers to the list of layers within this Group Layer
        lyrs = ly.listLayers()
        # Obtaining names of these layers
        for lyr in lyrs:
            # You have to use longName to get not just layer name but also that is within Group layer in this case aaa. You can also use just object so lyr_names.append(lyr)
            lyr_names.append(lyr.longName)
# in my case result for lyr_names is 
#['aaa\\a__5C1bii_SOx', 'aaa\\a__5C1bii_PM10', 'aaa\\a__5C1bii_PM2_5', 'aaa\\a__5C1bii_NOx', 'aaa\\a__5C1bii_NMVOC', 'aaa\\a__5C1bii_CO', 'aaa\\a__5D2_CH4', 'aaa\\a__5D1_CH4', 'aaa\\a__5C1bv_SOx', 'aaa\\a__5C1bv_PM10', 'aaa\\a__5C1bv_NOx', 'aaa\\a__5C1bv_NMVOC', 'aaa\\a__5C1bv_CO', 'aaa\\a__5C1biii_SOx', 'aaa\\a__5C1biii_NOx', 'aaa\\a__5C1biii_NMVOC', 'aaa\\a__5C1biii_CO']
# then simply use Merge tool
#arcpy.management.Merge(lyr_names,YOUR_OUTPUT_PATH_NAME e.g.)
# In case you want to add Source information (layer name) to output add "ADD_SOURCE_INFO"
#arcpy.management.Merge(lyr_names,YOUR_OUTPUT_PATH_NAME e.g.,"ADD_SOURCE_INFO") 
arcpy.management.Merge(lyr_names,r"D:\testing\testing2022\test.gdb\bbb")

 

Just in case you need to preserve the file name or string from file name (like it was in my case) here below is some additional code showing how to do it.

 

# the same as above code until this part below for lyr in lyrs
for lyr in lyrs:
    print(lyr)
    # in my case all layers start with a__ e.g. a__5C1bii_PM2_5
    lyr1 = lyr.name.split("a__")
    # you get back also the Group Layer which is of course not the actual layer
    if lyr1 != "aaa":
        lyr1= lyr1[1]
        # All other files have after a__ exactly two underscores the first is NFR code and the second is the pollutant. Exception is PM2_5
        if "PM2_5" in lyr1:
            # Irrelevant for this showcase so have removed the actual content
        else:
            # Which pollutant 
            lyr2 = lyr1.split("_")[1]
            # NFR code
            lyr3 = lyr1.split("_")[0]
            # Add columns first one is NFR (Text with 15 length and Field Alias 'Nomenclature For Reporting' and second is with correct name of the pollutant obtained from the layer name e.g. CO, PM10 ... and is Double 
            # if filename would be a__5C1bii_CO then this below would be filled out as
            #arcpy.management.AddFields(r"aaa\a__5C1bii_CO",  "NFR TEXT 'Nomenclature For Reporting' 15 # #; CO DOUBLE CO  # # #", None)
            # 
            arcpy.management.AddFields("{0}".format(lyr),  "NFR TEXT 'Nomenclature For Reporting' 15 # #; {0} DOUBLE {0}  # # #".format(lyr2), None)
            # Now calculate pollutant field with correct value obtained from (existing) grid_code column 
            arcpy.management.CalculateField("{0}".format(lyr), "{0}".format(lyr2), "!grid_code!", "PYTHON3", '', "TEXT", "NO_ENFORCE_DOMAINS")
            # calculate field with the value obtained from file/layer name
            arcpy.management.CalculateField("{0}".format(lyr), "NFR", "'{0}'".format(lyr3), "PYTHON3", '', "TEXT", "NO_ENFORCE_DOMAINS")
            # Pay attention to the "'{0}'" part. If you want to populate field (calculate field) with a string you have to enclose the {0} part in single qoutes! if you would populate field with a number (short, long, float or double) no single quotes would be necessary. So this code above would be
            # arcpy.management.CalculateField("{0}".format(lyr), "NFR", "{0}".format(lyr3), "PYTHON3", '', "TEXT", "NO_ENFORCE_DOMAINS")
            # Ignore the "TEXT" part of the code. ArcGIS is not using it because you are calculating the existing column. This parameter is used only if you are calculating into a new (non existing) column

 

Based on my experience when you have multiple files having the same source (in my case were hundreds of rasters converted to points) and you want to join you usually want to preserve filename or you need to add/populate columns with values from the file name. 

Merging.png