nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SelectLayerByLocation_management fails for unknown reason

ChuckBenton

I have an ArcGIS hosted feature layer, and want to make a selection based on a lat/lon. The last line is generating an error:

RuntimeError: Object: Error in executing tool)

I can't identify what I'm doing wrong. All is in WGS84. Here's the code

import arcpy
from arcgis.gis import GIS

gis = GIS("https://www.arcgis.com", "xyz", "xyz")
append_layer_itemid = '33518827e9e24defbacd671bfd26XXXX'

#Grab the layer
fs_item = gis.content.get(append_layer_itemid)
fs_layer = fs_item.layers[0]

#make a layer with the points
arcpy.env.workspace = r"C:\Users\cbent\OneDrive\Documents\ArcGIS\Projects\MyProject\MyProject.gdb"
arcpy.MakeFeatureLayer_management('points_layer', 'point_layer')

arcpy.SelectLayerByLocation_management(fs_layer,'INTERSECT','point_layer')

It's the last line that's failing, any ideas?

Chuck

Trouver plus de publications taguées avec

Content Management

Desktop

Feature Services

Accepted answers

ChuckBenton

Changing fs_layer in arcpy.SelectLayerByLocation_management(fs_layer,'INTERSECT','point_layer') to "https://services8.arcgis.com/2G8bTpCps4vdRut5/arcgis/rest/services/ParcelAtlas_V2_4/FeatureServer/0" fixed the issue. Basically had to use the service URL directly.

All comments

ChuckBenton

The online Parcel Layer is in WGS_1984_Web_Mercator_Auxiliary_Sphere (WKID 3857). Earlier I did have the point layer in a different WGS 1984 WKID, which has been corrected.

I now print the point_layer WIKI and bail if it isn't 3857. I also confirm it exists. Still seeing the same error:

RuntimeError: Object: Error in executing tool

. Any suggestions?

Screenshot 2021-09-08 105352.png

SubtypeOrder_test_gdb.zip

danretired

it may be failing here

arcpy.MakeFeatureLayer_management('points_layer', 'point_layer')

You might want to use arcpy.Exists to confirm the existence prior to select by location. It would also be a good idea to check both layer coordinate systems while you are at it and bail if they differ

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Se connecter
S'inscrire

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.