compare geometry shape field

742
4
04-05-2017 01:27 PM
helenchu
Occasional Contributor II

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.

0 Kudos
4 Replies
RobertScheitlin__GISP
MVP Esteemed Contributor

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.

0 Kudos
helenchu
Occasional Contributor II

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.

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

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
Occasional Contributor II

Thanks Robert!

0 Kudos