compare geometry shape field

[helenchu]

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.

[RobertScheitlin__GISP]

Helen,

I'd like to do this in SQL.

There lies the issue. You could do this using a queryTask (spatial Query) in JS, but not sure what this requirement for SQL is.

[helenchu]

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.

[RobertScheitlin__GISP]

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=ded7e84...‌ or a SQL server forum.

[helenchu]

Thanks Robert!