topic Re: Wish list: spatial queries with arcpy.da in Python Questions

Wish list: spatial queries with arcpy.da

MarkCederholm — Wed, 04 Jan 2012 14:42:01 GMT

I'd like to see da support spatial queries (i.e. using a geometry class, since not all geodatabases support spatial SQL).

Re: Wish list: spatial queries with arcpy.da

JasonPardy — Fri, 10 Dec 2021 23:20:43 GMT

Hi Mark,

There are currently no plans for the data access (da) module to support spatial queries. However, for file geodatabases, personal geodatabases, shapefiles, etc., you can use the Select Layer By Location tool.

In 10.1 final, you will be able to use a new tool named Make Query Layer which allows you create a query layer from a DBMS table based on an input SQL select statement. The SQL can include a spatial query. This layer can then be used as input to GP tools and supported by the da module. Here is an example of creating a query layer with a SQL spatial query and using it in a tool or in searchcursor.

arcpy.MakeQueryLayer_management(r'Database Connections\Connection to pardy.sde', 'CMarkets', """SELECT c.mkt_id, c.shape, c.names FROM cola_markets c WHERE SDO_OVERLAPS(c.shape, SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1,1003,3), SDO_ORDINATE_ARRAY(4,6, 8,8))) = 'TRUE'""", "MKTID")
arcpy.GetCount_managment("CMarkets")
rows = arcpy.da.SearchCursor("CMarkets", "NAMES")

Jason

Re: Wish list: spatial queries with arcpy.da

DanPatterson_Retired — Fri, 06 Jan 2012 21:11:53 GMT

This would be a welcome and useful addition

Re: Wish list: spatial queries with arcpy.da

stevegourley — Tue, 13 Jan 2015 01:12:37 GMT

This would be very useful.

Re: Wish list: spatial queries with arcpy.da

Venkata_RaoTammineni — Tue, 13 Jan 2015 06:39:48 GMT

good one. very useful.

Re: Wish list: spatial queries with arcpy.da

curtvprice — Tue, 13 Jan 2015 07:20:39 GMT

I recently had the chance to experiment with the methods exposed off the geometry object. I was working with file geodatabase and I found these operators to be very fast, especially when compared with using tools like Select Layer By Location.

Re: Wish list: spatial queries with arcpy.da

FridjofSchmidt — Fri, 17 Jul 2015 12:29:27 GMT

I'm surprised this still isn't supported, since the 10.2 documentation states: "The records returned by SearchCursor can be constrained to match attribute criteria or spatial criteria." But how to constrain the records to match spatial criteria?