Arcade Visualization: Aggregating features

[AlfredBaldenweck]

Hi all,

I was wondering if it was possible to aggregate (polygon) data visually with Arcade in Pro?

For example, dissolving counties into their state and treating them as one polygon (so that, for example, the stroke layer forms the state boundary, rather than county boundaries).

Thanks!

[AlfredBaldenweck · Accepted solution]

It's not possible in Arcade, but it is possible in an enterprise GDB using a Query Layer.

/*SQL Server*/
SELECT 
MIN(OBJECTID) AS ObjectID, 
PARENT_NAME AS ADMU_NAME, 
geometry:: UnionAggregate([SHAPE]) AS Shape 
from gdb.dbo.admu_ofc_poly
GROUP BY PARENT_NAME

Shoutout to Trevor Hart at Geodatabase Geek for the tutorial:

SQL Server 2012 – Fun with geometry aggregates! | Geodatabase Geek (wordpress.com)