https://community.esri.com/t5/arcgis-pro-questions/arcade-visualization-aggregating-features/m-p/1311502#M71396 <P>Hi all,</P><P>I was wondering if it was possible to aggregate (polygon) data visually with Arcade in Pro?</P><P>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).</P><P>Thanks!</P> Tue, 25 Jul 2023 13:56:28 GMT AlfredBaldenweck 2023-07-25T13:56:28Z https://community.esri.com/t5/arcgis-pro-questions/arcade-visualization-aggregating-features/m-p/1311502#M71396 <P>Hi all,</P><P>I was wondering if it was possible to aggregate (polygon) data visually with Arcade in Pro?</P><P>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).</P><P>Thanks!</P> Tue, 25 Jul 2023 13:56:28 GMT https://community.esri.com/t5/arcgis-pro-questions/arcade-visualization-aggregating-features/m-p/1311502#M71396 AlfredBaldenweck 2023-07-25T13:56:28Z https://community.esri.com/t5/arcgis-pro-questions/arcade-visualization-aggregating-features/m-p/1357355#M75990 <P>It's not possible in Arcade, but it is possible in an enterprise GDB using a Query Layer.</P><LI-CODE lang="sql">/*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</LI-CODE><P>&nbsp;</P><P>Shoutout to Trevor Hart at Geodatabase Geek for the tutorial:</P><P><A href="https://gdbgeek.wordpress.com/2012/07/16/sql-server-2012-fun-with-geometry-aggregates/" target="_blank" rel="noopener">SQL Server 2012 – Fun with geometry aggregates! | Geodatabase Geek (wordpress.com)</A>&nbsp;</P> Wed, 06 Dec 2023 14:22:41 GMT https://community.esri.com/t5/arcgis-pro-questions/arcade-visualization-aggregating-features/m-p/1357355#M75990 AlfredBaldenweck 2023-12-06T14:22:41Z