Auto Create Centroid When New Record/Feature Added in Join

507
2
03-28-2022 07:20 PM
ArmstKP
Occasional Contributor III

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!

Tags (4)
0 Kudos
2 Replies
Reinaldo_Cartagena
New Contributor III

Hi

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.

0 Kudos
ArmstKP
Occasional Contributor III

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

0 Kudos