topic Failed to loop through the files in a folder in ArcGIS Pro Questions

Failed to loop through the files in a folder

JinseoYoon — Wed, 07 Jul 2021 23:16:59 GMT

Hi,

I am making a looping code for Intersect_analysis of multiple files in a folder, but I ended up with having only one outcome..

''''

### folder containing facilities
in_folder_2 = r"D:\WORK\PROJECT\COVID_19_2\GIS\CREATED_DATA\FACILITIES"

shp_file_list_2 = [ ]
path_list2 = [ ]
intersectInput_list = [ ]

for shp_file2 in os.listdir(in_folder_2):
if shp_file2.endswith(".shp"):
intersectInput = os.path.join(in_folder_2, shp_file2)
intersectInput_list.append(intersectInput)

intersectInput_list

['D:\\WORK\\PROJECT\\COVID_19_2\\GIS\\CREATED_DATA\\FACILITIES\\N3A_A0010000.shp', 'D:\\WORK\\PROJECT\\COVID_19_2\\GIS\\CREATED_DATA\\FACILITIES\\TBGIS_TRDAR_RELM_prj.shp', 'D:\\WORK\\PROJECT\\COVID_19_2\\GIS\\CREATED_DATA\\FACILITIES\\UPIS_SHP_ZON216.shp']

interFeature = r"D:\WORK\PROJECT\COVID_19_2\Created_Data\PED_FLOW\eoul_flow_time_ymd_20200401.shp"

out_folder2 = r"D:\WORK\PROJECT\COVID_19_2\GIS\CREATED_DATA\FACILITIES_INTERS"

for intersectInput in intersectInput_list:
inFeatures = [intersectInput, interFeature]
name = shp_file2.strip(".shp")
clusterTolerance = 10
intersectOutput = os.path.join(out_folder2, name)
arcpy.Intersect_analysis(inFeatures, intersectOutput, "", clusterTolerance, "point")

The below is my output. Please help me, since I will increase the files in the folder much more than the current 3.

'D:\\WORK\\PROJECT\\COVID_19_2\\GIS\\CREATED_DATA\\FACILITIES_INTERS\\UPIS_SHP_ZON216.shx'

Re: Failed to loop through the files in a folder

DavidPike — Mon, 05 Jul 2021 11:21:04 GMT

I can't see where shapefile2 is referenced for the second for loop, and where outfolder2 is set, why are you stripping .shp from the filename, is the .shx extension intended? Also the code isn't formatted so I cant see the indents, making it a mess to try and read.

Re: Failed to loop through the files in a folder

JinseoYoon — Wed, 07 Jul 2021 23:21:08 GMT

Thank you!

First, the shape_file2 is referenced in the the upper part of the code (for shp_file2 in os.listdir(in_folder_2): ...)

Second, I stripped the ".shp" to use the same name of the file for the output files in a different folder.

Third, I omitted to copy the part of the code indicating the location of the output file folder, now I added it.

Can you please advise?

Re: Failed to loop through the files in a folder

DavidPike — Wed, 07 Jul 2021 23:33:09 GMT

Even then you're outputting a file intersectOutput without an extension? That would only work if Outfolder2 was a GDB. That seems to be why only an shx file is being created.

I don't really know what's going on with ShapeFile2 unless you present your code with the proper formatting/indentation. i.e. throw us a bone.

Re: Failed to loop through the files in a folder

JinseoYoon — Mon, 12 Jul 2021 08:38:07 GMT

Hi David,

Thank you for your response. The problem that I have was the failing of the loop. I input the three files but only one outcome has been created. The shx. shp. extension is not an issue. I could use both types.

I am attaching the code file, if you can advise me again - on why my loop could not go through all of the files in the list - it would be very much appreciated.

Thank you again!!

Re: Failed to loop through the files in a folder

DavidPike — Mon, 12 Jul 2021 09:50:36 GMT

you must surely get an error that shapefile2 is not referenced? what errors are you getting?

intersectInput_list is also on a line without any context.

I'd also use https://pro.arcgis.com/en/pro-app/latest/arcpy/functions/listfeatureclasses.htm when dealing with shapefiles in a folder.

I've quickly (very quickly) adjusted the code, but it is not ideal and not my finest work.

### folder containing facilities in_folder_2 = r"D:\WORK\PROJECT\COVID_19_2\GIS\CREATED_DATA\FACILITIES" shp_file_list_2 = [ ] path_list2 = [ ] intersectInput_list = [ ] for shp_file2 in os.listdir(in_folder_2): if shp_file2.endswith(".shp"): intersectInput = os.path.join(in_folder_2, shp_file2) #append a list of [name, path] for shapefile2 intersectInput_list.append([shp_file2, intersectInput]) ##intersectInput_list interFeature = r"D:\WORK\PROJECT\COVID_19_2\Created_Data\PED_FLOW\eoul_flow_time_ymd_20200401.shp" out_folder2 = r"D:\WORK\PROJECT\COVID_19_2\GIS\CREATED_DATA\FACILITIES_INTERS" for intersectInput in intersectInput_list: inFeatures = [intersectInput[1], interFeature] name = intersectInput[0] clusterTolerance = 10 intersectOutput = os.path.join(out_folder2, name) arcpy.Intersect_analysis(inFeatures, intersectOutput, "", clusterTolerance, "point")

Re: Failed to loop through the files in a folder

JinseoYoon — Mon, 19 Jul 2021 04:27:57 GMT

I am sorry for the delayed response. It works well!! Thank you very much!!! Honestly I do not understand the reason clearly, but I will compare your and my code and figure out.

Thank you very much again!!