topic Re: Auto Create Centroid When New Record/Feature Added in Join in ArcGIS Online Questions

Auto Create Centroid When New Record/Feature Added in Join

ArmstKP — Tue, 29 Mar 2022 03:25:11 GMT

I have created a join layer with the Join Features Analysis tool; it is a polygon layer. I then created centroids from my join layer by using the Find Centroids Analysis tool, but centroids don't auto create when new polygons are added in the join layer...

How would I go about this, in my current AGOL workflow??

Thanks!

Re: Auto Create Centroid When New Record/Feature Added in Join

Reinaldo_Cartagena — Tue, 29 Mar 2022 19:22:06 GMT

As an automatic function I have not seen, but in case of MSSQL Server this scripts and the following link can help you: STX (geometry Data Type) | Microsoft Docs

use Demo_GNX go Drop view OutPutView go Create View OutPutView as (SELECT ET.Codigo ,ET.Shape ,ET.Shape.STCentroid().STX as X ,ET.Shape.STCentroid().STY as Y ,ET.Shape.STCentroid().STSrid as STSrid FROM Demo_GNX.DBO.LimiteEntidadTerritorial as ET) go SELECT * FROM OutPutView go

For the other RDBMS check ST_Geometry in ArcGIS Pro, see the link:

Databases and ST_Geometry—ArcGIS Pro | Documentation

Reinaldo.

Re: Auto Create Centroid When New Record/Feature Added in Join

ArmstKP — Tue, 10 May 2022 03:22:35 GMT

I could do this, but one can't use Arcade on symbology if it is a view...