How to spatial join on the fly?

[MatthewTsui5]

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.

[RickeyFight]

@MatthewTsui5 
Have you tried this?
https://learn.arcgis.com/en/projects/access-attributes-from-another-layer-with-arcade/

[MatthewTsui5]

Hi RickeyFight,

I have tried it. Unfortunately, the doc helps to spatially join attribute on the fly between two layers. It doesn't help to visualize seperate polygons with the same attribute as one polygon.

[DavidPike]

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

[MatthewTsui5]

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%20....

[DavidPike]

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).