topic Selectbylocation and CopyFeatures via Arcpy in ArcGIS Pro Questions

Selectbylocation and CopyFeatures via Arcpy

ZoeChen — Wed, 23 Jun 2021 18:12:43 GMT

Hello everyone, I am having trouble when trying to automate the process of select-by-location and copy-features in python. My codes looks like below: The logic seems to be right but once it runs, it runs forever which definitely exceeds the time I ran in Arcpro. Any ideas would be appreciated, thank you!

import arcpy
from arcpy import env
env.workspace = "D:/Backup/shapefile/NE_validation"
outworkspace = "D:/Backup/shapefile/NE_validation"
NEEEfishnet = "D:/Backup/shapefile/NE_validation/NE_validation.gdb/NEEE_NewEngland_fishnet"

shplist = arcpy.ListFeatureClasses("*Point*")
for shp in shplist:
# select by location
arcpy.management.SelectLayerByLocation(NEEEfishnet, "INTERSECT", shp, None, "NEW_SELECTION", "NOT_INVERT")
# export selected features (use copy features tool)
outfeature = outworkspace + "/" + NEEEfishnet[52:75] + shp[37:40] + ".shp"
arcpy.management.CopyFeatures(NEEEfishnet, outfeature, '', None, None, None)
# clear selection
arcpy.SelectLayerByAttribute_management(NEEEfishnet, "CLEAR_SELECTION")

Update: I change the code to adopt two more functions: make feature layer and save layer to file. The code runs but it does not produce shapefile that is openable. The error message says below. I am going to stop updating, and maybe someone someday will find a solution to this problem...

Re: Selectbylocation and CopyFeatures via Arcpy

DanPatterson — Mon, 21 Jun 2021 20:12:14 GMT

it runs forever which definitely exceeds the time I ran in Arcpro

does it produce output though?

Re: Selectbylocation and CopyFeatures via Arcpy

DavidPike — Mon, 21 Jun 2021 21:12:38 GMT

definitely add some print statements to try and track what's going on, I would also separate the directories that your outputs are going into as it's asking for issues.

Re: Selectbylocation and CopyFeatures via Arcpy

ZoeChen — Mon, 21 Jun 2021 22:14:08 GMT

Thanks, Dan, it does not produce any output.

Re: Selectbylocation and CopyFeatures via Arcpy

ZoeChen — Mon, 21 Jun 2021 22:15:36 GMT

Thanks, David. 👍

Re: Selectbylocation and CopyFeatures via Arcpy

JoshuaBixby — Tue, 22 Jun 2021 14:15:13 GMT

Selections don't apply to data sets, they apply to layers or views. Although you can now pass a data set directly to a Select Layer tool (personally, I disagreed with this change when Esri made it a couple years back), the selection isn't being made directly on the data set. Instead, when a data set is passed directly to a Select Layer tool, a layer or view is created behind the scenes and the selection is placed on it. With your code, you are not retrieving the auto-generated layer.

I still personally think it is best practice to create a layer first and then pass it to Select Layer tools.

Re: Selectbylocation and CopyFeatures via Arcpy

ZoeChen — Tue, 22 Jun 2021 23:32:12 GMT

Wow, thanks for this answer Joshua! It really cleared my puzzles 👏