AnsweredAssumed Answered

SelectLayerByLocation Alternatives?

Question asked by jamesfreddyc on Sep 29, 2017
Latest reply on Oct 6, 2017 by jamesfreddyc

Being a bit greedy here, I know but has anyone come up with more efficient/faster alternatives to arcpy.SelectLayerByLocation_management?

 

I'd say for the vast majority (ie. 99%) implementing this is entirely acceptable.  However, I've run into a couple of instances lately that require several of these calls to be made in order to build a list/set of results that ultimately return an expected response.

 

...or in another instance, there are a large amount of point features (85 million) that need to be identified as COMPLETELY_WITHIN a simple single polygon feature.  In most cases it's sub 30 seconds to return the expected result.

 

However if these processes are to be published as synchronous GP services, the processing times can be excessive in that context.

 

numpy? dictionaries? pandas? Anything at all that you may have tried to exceed the performance of arcpy.SelectLayerByLocation_management???

 

Case / scenario: select by location on points within a simple polygon feature and return a yes or no if the count is > 0

Outcomes