topic Re: Update attributes on a point after moving it inside a polygon in State & Local Government Questions

Update attributes on a point after moving it inside a polygon

StevenBell2 — Wed, 12 Sep 2018 20:38:18 GMT

I have a feature layer of points representing people and a feature layer of polygons representing areas they are assigned to be in. I would like to have a web app where a user can move an existing point into a different polygon then have the point update to the name of the new area. If it's possible I would like the point to be updated by clicking a button that runs a tool that updates by the point's location rather than by having the user type in the information.

I'm having trouble searching for answers to this because all the ones I find relate to doing a spatial join. But I don't want to create a new feature class. I need to only update the attributes of the feature in the existing point feature layer.

Thank you.

Steve

Re: Update attributes on a point after moving it inside a polygon

DarrenWiens2 — Wed, 12 Sep 2018 20:58:05 GMT

Are you hoping for a Python or JS solution, or something else?

Re: Update attributes on a point after moving it inside a polygon

StevenBell2 — Wed, 12 Sep 2018 23:34:52 GMT

Honestly anything. I don’t really have much scripting experience so I’d have to learn more about any possible solution.

Sent from my iPhone

Re: Update attributes on a point after moving it inside a polygon

DarrenWiens2 — Wed, 12 Sep 2018 23:42:52 GMT

In Python, you would find the Point Geometry you moved, then cycle through the Polygon objects, checking if the polygon contains the point (using one of the polygon methods, like contains or not disjoint). The JS API would have similar objects/methods, but I'm not particularly familiar with it.

Re: Update attributes on a point after moving it inside a polygon

MatthewDobson — Thu, 13 Sep 2018 00:00:16 GMT

Steven, where does the data reside? If it is in a relational database (MS SQL Server, Oracle etc.) you could work something up at the database level.

Matthew

Re: Update attributes on a point after moving it inside a polygon

StevenBell2 — Thu, 13 Sep 2018 00:29:28 GMT

It resides in an sql database but the updates will be made through a web app.

Sent from my iPhone

Re: Update attributes on a point after moving it inside a polygon

MatthewDobson — Thu, 13 Sep 2018 00:55:40 GMT

Yea, that's okay. I'll have a crack at a little SQL trigger that will do the update within the database once the point is moved via the WebMap. You might need to do some finessing as I don't know your data structure.

Matthew

Re: Update attributes on a point after moving it inside a polygon

MatthewDobson — Thu, 13 Sep 2018 01:28:09 GMT

You'll need to update the attached with your database, schema and featureclass names, as well as the names of the fields in your point and polygon featureclasses.

The trigger will:
1. get the geometry for the moved point feature
2. find the polygon that the point intersects with and gets the 'name' of that area.
3. updates the point attribute with the 'name' of that area

Let me know how you get on.

Re: Update attributes on a point after moving it inside a polygon

StevenBell2 — Thu, 13 Sep 2018 15:10:09 GMT

Thank you for trying to help. I'm not seeing anything attached to your post.

Re: Update attributes on a point after moving it inside a polygon

MatthewDobson — Thu, 13 Sep 2018 22:27:30 GMT

Second try ....

Re: Update attributes on a point after moving it inside a polygon

MatthewDobson — Mon, 17 Sep 2018 23:57:23 GMT

Hey Steven, how did you get on?

Re: Update attributes on a point after moving it inside a polygon

StevenBell2 — Tue, 18 Sep 2018 13:08:20 GMT

Sorry. I have been pulled over to a different project and haven’t had a chance to work on that yet.