topic Re: Python: deletion of feature classes and tables except for those with specified na in Python Questions

Python: deletion of feature classes and tables except for those with specified names

RichardCarr — Fri, 15 Nov 2013 14:24:18 GMT

Hello,
I would like to add a piece of python to the end of arcpy script that will search a file geodatabase and delete all files except for those in a list that I will specify. I am not sure where to start - so any ideas would be most welcome!

geodatabase: C:\...\ParcelProcessingShell.gdb
files to retain: "Template_TBL", "dbt_Assessors", "PARCELS"

Re: Python: deletion of feature classes and tables except for those with specified na

T__WayneWhitley — Sun, 12 Dec 2021 04:12:53 GMT

Could do something like:

import arcpy
arcpy.env.workspace = r'C:\...\ParcelProcessingShell.gdb'  #your workspace path

keepers = ["Template_TBL", "dbt_Assessors", "PARCELS"]
for each in arcpy.ListFeatureClasses():
     if each not in keepers:
          try:
               arcpy.Delete_management(each)
          except:
               print 'oops, cannot delete ' + each

Of course, it looks like you have tables in there too?...if so, then you'll also need to use ListTables to return the listing on those and loop to delete tables not in 'keepers'...

Hope that helps,
Wayne

Re: Python: deletion of feature classes and tables except for those with specified na

RichardCarr — Fri, 15 Nov 2013 15:26:26 GMT

That worked perfectly. I did indeed need to have a separate loop for the tables, which worked as well. Thanks!

Re: Python: deletion of feature classes and tables except for those with specified na

ChrisSnyder — Sun, 12 Dec 2021 04:12:56 GMT

You also could use a wildcard(s) to denote the keeper group. Also a demo of a practical use of the Python set() object.

keeperString = "*_t"
keeperFcSet = set(arcpy.ListFeatureClasses(keeperString))
allFcSet = set(arcpy.ListFeatureClasses())
delFcSet = allFcSet.difference(keeperFcSet)
for delFc in delFcSet:
   try:
      arcpy.Delete_management(delFc)
   except:
      print "Can't delete " + str(delFc)