How to spatial join on the fly?

Question

Has anybody figured how to spatially join on the fly?

I'm struggling to build an ArcGIS Dashboard where users can see three layers (territories, districts, regions).

The data must be live since it changes daily, so it's sourced enterprise geodatabase polygon feature class (Entgdb.DBO.Territories). A district is neighboring territories, while a region is neighboring districts. [See screenshot].

I tried using symbology (fill, but no outline), but accessibilty suffers with so many 80 + districts.

Screenshot.jpg

FlickBugDemo.zip

TaiDuong_0-1740415892282.png

DavidPike · Answer

I think you'd use option such as .STIntersects(), .STContains(), .STWithin()

Whichever operations are available within your database engine (may not be ST geom type etc.)  We're talking outside of Esri here so go to your DB documentation.  A query layer in ArcPro might achieve the same thing also (with extra steps).

MatthewTsui5 · Answer

Hi David,

That sounds promising.

By geometry join, are you referring to SQL functions like ST_UNION?

https://developers.arcgis.com/geoanalytics/sql-functions/st_union/#:~:text=ST_Union%20takes%20two%20or%20more,columns%20must%20be%20the%20same.

DavidPike · Answer

You can create a view in the database with geometry joins (or query layer in desktop) and publish that.