Spatial SQL subquery in definition query to filter layer or label

243
0
09-15-2021 02:26 AM
GaetanPRU
New Contributor III

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

GaetanPRU
0 Replies