topic Re: Dissolving features using Shape.ST() function in Geodatabase Questions

Dissolving features using Shape.ST() function

HaniDraidi — Wed, 02 Mar 2016 21:13:22 GMT

Is there a way to dissolve features dynamically based on a field using a certain Shape.ST() function for a feature class in enterprise GDB?

If yes, what is this function?

Thank you

Re: Dissolving features using Shape.ST() function

Anonymous User — Wed, 02 Mar 2016 23:12:01 GMT

Have you tried:

ST_Aggr_Union—Ayuda | ArcGIS for Desktop

Regards

Jesús de Diego

Re: Dissolving features using Shape.ST() function

VinceAngelo — Thu, 03 Mar 2016 14:06:07 GMT

Please clarify your question by specifying which RDBMS you are using (including a specific version) and which version of ArcGIS is available.

- V

Re: Dissolving features using Shape.ST() function

HaniDraidi — Thu, 03 Mar 2016 21:27:12 GMT

I am using ArcGIS Desktop & Server 10.3.1 with SQL Server 2014

Re: Dissolving features using Shape.ST() function

VinceAngelo — Thu, 03 Mar 2016 21:42:19 GMT

Since you're using a Microsoft geometry type, the Microsoft documentation is the place to locate SQL functions.

The other side of this is the "for a feature class in enterprise GDB". I would urge you NOT to place such a function in a view -- the performance will likely be inadequate. You'll need to weigh your "dynamically" constraint against performance.

- V