Spatial SQL subquery in definition query to filter layer or label

GaetanPRU — Wed, 15 Sep 2021 09:27:34 GMT

Hello,

I saw in ArcGIS PRO documentation that it's possible to use SQL subqueries in definition queries.

I would like to know if it is possible to use spatial function like st_intersects or st_within to dynamically filter a layer or create label classes.

I tried this subquery in definition query but when I check this request it's OK but I can't apply it :

OBJECTID IN (SELECT TABLE2.OBJECTID FROM SCHEMA.TABLE1, SCHEMA.TABLE2 WHERE SCHEMA.TABLE1.NAME= 'xxxx' AND SDE.ST_INTERSECTS(SCHEMA.TABLE1.SHAPE, SCHEMA.TABLE2.SHAPE) = 1 ;

I work with ArcGIS PRO 2.6.2, maybe it's possible in newest version.

Thanks

topic Spatial SQL subquery in definition query to filter layer or label in ArcGIS Pro Questions

Spatial SQL subquery in definition query to filter layer or label