topic Re: Delete all empty shapefiles in a Folder in Python Questions

Delete all empty shapefiles in a Folder

MittRamgobin — Thu, 25 Sep 2014 09:06:18 GMT

I want to delete all empty shapefiles in a folder. The following is not working:

 #Find empty shapefiles and delete them

arcpy.env.workspace = r"S:\SupportServices\LGAShapefiles"

shapefiles = arcpy.ListFeatureClasses()

for shapefile in shapefiles:

if arcpy.management.GetCount(shapefile)[0]=="0":

arcpy.Delete_management(shapefile)

print shapefile + "Deleted"

Re: Delete all empty shapefiles in a Folder

RiyasDeen — Thu, 25 Sep 2014 09:51:22 GMT

Hi Mitt,

It should be

if int(arcpy.GetCount_management(shapefile).getOutput(0)) == 0:

have a look at example 2 ArcGIS Desktop

Re: Delete all empty shapefiles in a Folder

MittRamgobin — Thu, 25 Sep 2014 23:57:49 GMT

Hi Riyas,

Thank you for your input.

I am now getting the following error:

ExecuteError: Failed to execute. Parameters are not valid.

ERROR 000732: Input Rows: Dataset GISTRAN.SubstationCOOROW, SHIRE OF.shp does not exist or is not supported

Failed to execute (GetCount).

What is going on?

Re: Delete all empty shapefiles in a Folder

RiyasDeen — Fri, 26 Sep 2014 00:19:52 GMT

Hi Mitt,

Sorry, Get Count accepts a layer input. We need to create a layer from the shapefile and pass it as input to the get count tool. Use below code, tested. Mind the line intents

arcpy.env.workspace = r"C:\tempdelete\Test_road" 
shapefiles = arcpy.ListFeatureClasses() 
for shapefile in shapefiles:
  layerName = arcpy.Describe(shapefile).baseName
  arcpy.AddMessage(layerName)
  arcpy.MakeFeatureLayer_management (shapefile, layerName)
  arcpy.AddMessage(arcpy.GetCount_management(layerName).getOutput(0))

  if int(arcpy.GetCount_management(layerName).getOutput(0)) == 0:
  arcpy.Delete_management(shapefile)

Re: Delete all empty shapefiles in a Folder

MittRamgobin — Fri, 26 Sep 2014 00:38:47 GMT

Hi Riyas,

This time it gets stuck at the MakeFeatureLayer

ERROR 000732: Input Features: Dataset GISTRAN.SubstationCOOROW, SHIRE OF.shp does not exist or is not supported

Failed to execute (MakeFeatureLayer).

Re: Delete all empty shapefiles in a Folder

MittRamgobin — Sat, 11 Dec 2021 08:37:22 GMT


import arcpy
import sys
import os


# Script to create LGA Map with WP Infrastructure


# Define variables


arcpy.env.workspace = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde"
arcpy.env.overwriteOutput = True
#LGA = arcpy.GetParameterAsText(0) # Input Required Local Government Area
LGA ="COOROW, SHIRE OF"


#Define Layers to Intersect


#1. Transmission Layers
T330OH = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_330kV_OH_Carrier"    
T330UG = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_330kV_UG_Cable"
T220OV = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_220kV_OH_Carrier"
T132OH = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_132kV_OH_Carrier"
T132UG = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_132kV_UG_Cable"
T66OV = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_66kV_OH_Carrier"
T66UG = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_66kV_UG_Cable"
T33OH = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_33kV_OH_Carrier"
T33UG = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_33kV_UG_Cable"
TransStruc = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Trans_Structure"
Substation = r"C:\Users\N041871\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DynamicCredentials@GISR.sde\GISTRAN.Transmission\GISTRAN.Substation"
#Group Transmission Values:
Transmission = (T330OH, T330UG, T220OV, T132OH, T132UG, T66OV, T66UG, T33OH, T33UG, TransStruc, Substation)
 
#2. Distrubution Layers
POLES = os.path.join("ARCFM.Structure", "ARCFM.Pole")
HVOH = os.path.join("ARCFM.Distribution_HV", "ARCFM.Conductor_HV")
HVUG = os.path.join("ARCFM.Distribution_HV", "ARCFM.Cable_HV")
LVOH = os.path.join("ARCFM.Distribution_LV", "ARCFM.Conductor_LV")
LVUG = os.path.join("ARCFM.Distribution_LV", "ARCFM.Cable_LV")
#Group Distribution Values
Distribution = (POLES, HVOH, HVUG, LVOH, LVUG)
                                  
#Select Required LGA
arcpy.MakeFeatureLayer_management("GISEXT.Local_Government_Authority", "LGAlyr")
fieldName = "NAME"
Query = "\""+fieldName+"\"='"+LGA+"'"
arcpy.SelectLayerByAttribute_management ("LGAlyr", "NEW_SELECTION", Query)
###arcpy.SelectLayerByAttribute_management ("LGAlyr", "NEW_SELECTION", """ "NAME" = 'ALBANY, CITY OF' """) - working code


for Struc in Transmission:
    outputPath = r"S:\SupportServices\LGAShapefiles"
    basefileName = arcpy.Describe(Struc).baseName + LGA
    fileFormat= '.shp'
    finalDest = os.path.join(outputPath,basefileName+fileFormat)
    arcpy.Clip_analysis(Struc, "LGAlyr",finalDest)
#arcpy.Clip_analysis(Struc,"LGAlyr", finalDest)
print "Transmission Shapefile Created"


##for Struc in Distribution:
##    outputPath = r"S:\SupportServices\LGAShapefiles"
##    basefileName = arcpy.Describe(Struc).baseName + LGA
##    fileFormat= '.shp'
##    finalDest = os.path.join(outputPath,basefileName+fileFormat)
##    arcpy.Clip_analysis(Struc, "LGAlyr",finalDest)





#Find empty shapefiles and delete them
arcpy.env.workspace = r"S:\SupportServices\LGAShapefiles"


shapefiles = arcpy.ListFeatureClasses()


for shapefile in shapefiles:
    layerName = arcpy.Describe(shapefile).baseName
    arcpy.AddMessage(layerName)
    arcpy.MakeFeatureLayer_management (shapefile, layerName)
    arcpy.AddMessage(arcpy.GetCount_management(layerName).getOutput(0))
    if int(arcpy.GetCount_management(layerName).getOutput(0)) == 0:
        arcpy.Delete_management(shapefile)

Re: Delete all empty shapefiles in a Folder

RiyasDeen — Fri, 26 Sep 2014 01:03:33 GMT

Hi Mitt,

It's the period character in your shapefile name that's creating the issue.

Change line 43 in above code to replace . with _

basefileName = arcpy.Describe(Struc).baseName.replace('.','_') + LGA

Re: Delete all empty shapefiles in a Folder

MittRamgobin — Fri, 26 Sep 2014 01:40:56 GMT

Hi Riyas,

Now there is this

ExecuteError: ERROR 000210: Cannot create output S:\SupportServices\LGAShapefiles\GISTRAN_Trans_330kV_OH_CarrierKONDININ, SHIRE OF.shp

ERROR 000354: The name contains invalid characters

Failed to execute (Clip).

Re: Delete all empty shapefiles in a Folder

RiyasDeen — Fri, 26 Sep 2014 01:58:53 GMT

, in your shapefile name is creating issue with clip. Interestingly if your shape file name is GISTRAN.Trans_330kV_OH_CarrierKONDININ, SHIRE OF.shp (with period) it's slipping through

. is creating issue with make feature layer

It's better to avoid special characters in your shape file name all together.

Change your LGA name to Shire of KONDININ without , separator.

Re: Delete all empty shapefiles in a Folder

MittRamgobin — Fri, 26 Sep 2014 03:33:06 GMT

Works like a treat now!

Thank you Riyas

Re: Delete all empty shapefiles in a Folder

LilaDevkota — Fri, 26 Sep 2014 03:38:29 GMT

Try to delete shp files from Arc catalogue's catalogue tree.

Re: Delete all empty shapefiles in a Folder

konstantBrr — Fri, 12 Feb 2021 07:37:32 GMT

import arcpy, math, gc # Workspace, overwrite arcpy.env.workspace = r"D:\testScript\My.gdb" arcpy.env.overwriteOutput = True # INPUTS objects_input = r"D:\testScript\objects.shp" # must be polygons objects = "objects_lyr.shp" arcpy.MakeFeatureLayer_management(objects_input, objects) # OUTPUTS, most temporal out_path=r"D:\testScript" out_name="Hello.shp" geometry_type = "POLYGON" template = "study_quads.shp" has_m = "DISABLED" has_z = "DISABLED" Myres = "Myres.shp" arcpy.Delete_management(out_name) out_name_erase = "in_memory" + "\\" + "out_name_erase" polygon = "in_memory" + "\\" + "polygon" polygon_dissolve = "in_memory" + "\\" + "polygon_dissolve" arcpy.CreateFeatureclass_management(out_path, out_name, geometry_type) # Parameters distance = 18 # distance for move in direction direction = 360 # direction in degrees (90 is from north to south) index = 0 # Set UpdateCursor cur_objects = arcpy.da.UpdateCursor(objects, ("Dir")) for row_objects in cur_objects: try: fid = row_objects[0] sql = '"Dir" = ' + str(index) index += 1 # Initialize lists lines_list = [] lines_created = [] # Select current feature arcpy.SelectLayerByAttribute_management(objects, "NEW_SELECTION", sql) vertexes = "in_memory" + "\\" + "vertexes" # Convert object to vertexes arcpy.FeatureVerticesToPoints_management(objects, vertexes, "ALL") index_vertex = 0 # Set SearchCursor for vertexes cur_vertexes = arcpy.da.SearchCursor(vertexes, ("SHAPE@XY")) for row_vertexes in cur_vertexes: vertex_coords_x = row_vertexes[0][0] vertex_coords_y = row_vertexes[0][1] # Define points coordinates point_move_x = vertex_coords_x - (distance) * math.cos(math.radians(direction)) point_move_y = vertex_coords_y - (distance) * math.cos(math.radians(90 - direction)) # Make list of points new_line = ([[vertex_coords_x, vertex_coords_y], [point_move_x, point_move_y]]) lines_list.append(new_line) # From second cycle if index_vertex > 0: lines_vertexes = ([[vertex_coords_x, vertex_coords_y], start_line]) lines_ends = ([[point_move_x, point_move_y], end_line]) lines_list.append(lines_vertexes) lines_list.append(lines_ends) start_line = [vertex_coords_x, vertex_coords_y] end_line = [point_move_x, point_move_y] index_vertex = index_vertex + 1 # Cycle that makes polylines from points for lines_step in lines_list: lines_created.append(arcpy.Polyline(arcpy.Array([arcpy.Point(*sour) for sour in lines_step]))) arcpy.FeatureToPolygon_management(lines_created, polygon) arcpy.AggregatePolygons_cartography(polygon, polygon_dissolve, 1) # Final editing arcpy.Erase_analysis(polygon_dissolve, objects, out_name_erase) arcpy.Append_management(out_name_erase, out_name, "NO_TEST") arcpy.Delete_management("in_memory") arcpy.Delete_management(vertexes) start_line = [] # Clear selection, memory and deleting temps arcpy.SelectLayerByAttribute_management(objects, "CLEAR_SELECTION") print ("Object number: " + str(index - 1) + " -- done.") gc.collect() # Catch errors except Exception as e: pass print ("Error:") print (e) print ("\n") index += 1