Arcpy - FeatureClassToFeatureClass

TrilliumLevine1

Hello All,

I have a dictionary with a list of feature class paths (keys) and destination feature datasets (values) that I'm trying to use to do a batch FeatureClassToFeatureClass operation with.  No matter what I've tried, however, I keep getting the same error when I run the script:

Here is the code I'm running to do this:

for key, value in FCFDdict.iteritems():
        inFC = str(key)
        destination = str(value)
        outFC = str(os.path.basename(key))
        arcpy.env.workspace = destination
        arcpy.FeatureClassToFeatureClass_conversion(inFC, destination, outFC)

My dictionary is populated with unicode strings, and looks like this:

{
u'C:\\Scripts\\Redefine Projection\\MyGeodatabase.gdb\\FD_A\\infotafeln_1': u'C:\\Scripts\\Redefine Projection\\MyGeodatabase.gdb\\FD_A_redefined', 
u'C:\\Scripts\\Redefine Projection\\MyGeodatabase.gdb\\FD_B\\sielhautproben_2': u'C:\\Scripts\\Redefine Projection\\MyGeodatabase.gdb\\FD_B_redefined', 
u'C:\\Scripts\\Redefine Projection\\MyGeodatabase.gdb\\FD_B\\infotafeln_2': u'C:\\Scripts\\Redefine Projection\\MyGeodatabase.gdb\\FD_B_redefined'
}

Anyone out there have any idea what I'm doing wrong here?  I've also tried feeding FeatureClassToFeatureClass the key's basename, to no avail.  Any feedback is greatly appreciated!

FreddieGibson

Hi Trillium,

Your problem should be that you're trying to export the feature class to a new feature dataset with the same name. Names must be unique within a geodatabase. So in your case you can't have both FD_A\infotafeln_1 and FD_A_redefined\infotafeln_1. You would have to rename the new feature class to another unique name that doesn't exist in the entire geodatabase. To prove this I've provided the code I used to test. You should be able to run this on your machine to confirm. You'll see in the new instance that I add an underscore to the name to make it unique.

import arcpy
import os
import unittest


# This will create a geodatabase similar to yours
def CreateUserEnvironment(gdbPath):
    gdbContents = [("FD_A", ["infotafeln_1"]), 
                   ("FD_B", ["sielhautproben_2", "infotafeln_2"]), 
                   ("FD_A_redefined", []), 
                   ("FD_B_redefined", [])]
    
    if arcpy.Exists(gdbPath):
        arcpy.management.Delete(gdbPath)
        
    arcpy.management.CreateFileGDB(os.path.dirname(gdbPath), os.path.basename(gdbPath))
    
    for ds, fcs in gdbContents:
        dsPath = arcpy.management.CreateFeatureDataset(gdbPath, ds, arcpy.SpatialReference(3857))
        for fc in fcs:
            arcpy.management.CreateFeatureclass(dsPath, fc, "POINT", spatial_reference=arcpy.Describe(dsPath).spatialReference)
            
def TestWorkflow(gdbPath):
    expPath = {"{0}\\FD_A\\infotafeln_1".format(gdbPath):"{0}\\FD_A_redefined".format(gdbPath),
               "{0}\\FD_B\\sielhautproben_2".format(gdbPath):"{0}\\FD_B_redefined".format(gdbPath),
               "{0}\\FD_B\\infotafeln_2".format(gdbPath):"{0}\\FD_B_redefined".format(gdbPath)}
    
    for k,v in expPath.items():
        # Workflow you're currently implementing
        try:
            print("Exporting to new feature dataset with same name")
            arcpy.conversion.FeatureClassToFeatureClass(k, v, os.path.basename(k))
        except arcpy.ExecuteError as e:
            print(e.message)
            
        # Workflow I'm suggesting
        try:
            print("Exporting to new feature dataset with different name")
            arcpy.conversion.FeatureClassToFeatureClass(k, v, os.path.basename(k) + "_")
            print(arcpy.GetMessages())
        except arcpy.ExecuteError as e:
                    print(e.message)        
                    
        print("*"*25 + "\n")
        


if __name__ == "__main__":
    gdbPath = os.path.join(os.path.dirname(__file__), "MyData.gdb")
    CreateUserEnvironment(gdbPath)
    TestWorkflow(gdbPath)