compare geometry shape field

Question

Hi

My question is not about WAB but I'm sure you guys can help me out.

I have polygon layer A and a layer B

When there's a new polygon created in layer B, I need to compare that polygons with all the polygons in A layer and  the get an ID field from layer A.  I'd like to do this in SQL.

Thanks for your help.

helenchu · Answer

Thanks Robert!

rscheitlin · Answer

Helen,

I can not provide any help on database triggers. This is something you should post to a https://community.esri.com/community/gis/enterprise-gis/arcgis-for-server?sr=search&searchId=ded7e848-a7fc-47f8-a32f-25fdaafb1814&searchIndex=4‌ or a SQL server forum.

helenchu · Answer

Could you please tell me more about the issue I could run into ?

I plan to use update trigger in SQL table B.  When there's new record -> compare 'shape' fields from both tables and get & return me a field I need from table A.  It's strictly SQL because I'm not calling this from any JS app.  I just need that field added to a SQL table. I'm stuck at the syntax to compare the 'shape' fields.  Thanks.