Batch merge multiple shapefiles - with confusing file structure

NathanielClement — Tue, 24 Dec 2013 16:36:16 GMT

I have a series of folders that have different shapefiles in each one. The naming convention is odd. All I need to do is search through each subfolder and get the shapefiles ending with *_CadastralPolygons.shp. I figured I could output it to a holding folder for now (called "hold"). The naming convention doesnt matter either, I just need to get this working in my "testing" folder then I can apply it to my larger dataset. Thanks

File Structure:

Re: Batch merge multiple shapefiles - with confusing file structure

MattSayler — Fri, 10 Dec 2021 20:48:22 GMT

It can be done with python using os.listdir() to list the folders and arcpy.ListFeatureClasses() to grab all the feature classes in the folder:

Something like:

import arcpy
import os

mainLoc = r"c:\testing"
outputLoc = r"c:\finalLocation\Output.gdb" #Note: ouput location should be outside the "testing" folder or additional runs will include any previously generated output
FCList = []

for dir in os.listdir(mainLoc):
    arcpy.env.workspace = dir
    FCsubList = arcpy.ListFeatureClasses("*_CadastralPolygons.shp", "Polygon")
    FCList.append(FCsubList)

arcpy.Merge_management(FCList, outputLoc)

topic Re: Batch merge multiple shapefiles - with confusing file structure in Geoprocessing Questions

Batch merge multiple shapefiles - with confusing file structure

Re: Batch merge multiple shapefiles - with confusing file structure