Is there a way to remove layers from the Table of Contents if no features are present?

Question

Is there a tool or python script out there that can look through a Map in Pro, and remove any layers that are empty? I have about 30-40 layers that reference 5 feature classes in a GDB. They have queries on them to make 30-40 separate layers whjich i then need to export to CAD. It would be great to have a tool that removes the empty layers (as a result of the queries) before exporting. Otherwise the CAD DWG will contain a bunch of empty layers.

JakeSkinner · Answer

Replace the print statements to arcpy.AddMessage instead.  This will print which layer the script is failing on, and this should give us some insight on what's going on.  Ex:

arcpy.AddMessage(f"	{lyr.name}")

David_Brooks · Answer

@JakeSkinner thanks for the example, but that returns an error

any ideas?

JakeSkinner · Answer

@David_Brooks,

You could so something like below:

import arcpy

project = r"C:\Projects\Example.aprx"

aprx = arcpy.mp.ArcGISProject(project)
for m in aprx.listMaps():
    print(f"Map: {m.name}")
    for lyr in m.listLayers():
        print(f"	{lyr.name}")
        if lyr.isBasemapLayer == False:
            results = arcpy.GetCount_management(lyr)
            count = results.getOutput(0)
            if count == '0':
                print(f"Removing {lyr.name}")
                m.removeLayer(lyr)
aprx.save()