topic Re: compare geometry shape field in ArcGIS Web AppBuilder Questions

compare geometry shape field

helenchu — Wed, 05 Apr 2017 20:27:24 GMT

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.

Re: compare geometry shape field

RobertScheitlin__GISP — Wed, 05 Apr 2017 22:59:51 GMT

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.

Re: compare geometry shape field

helenchu — Fri, 07 Apr 2017 11:48:54 GMT

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.

Re: compare geometry shape field

RobertScheitlin__GISP — Fri, 07 Apr 2017 11:57:47 GMT

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.

Re: compare geometry shape field

helenchu — Fri, 07 Apr 2017 17:09:35 GMT

Thanks Robert!