topic Automatically populate field with values from another layer in ArcGIS Server with JavaScript API Questions

Automatically populate field with values from another layer

EduardoD__Cuesta — Wed, 02 Mar 2016 10:11:04 GMT

Hi all,

I would like how I could do to autopopulate some fields in a Feature Server according to spatial values from another layers. For instance, if I add a point and has a Distict field, I want to fill that field automatically with the name of the district where the point is, from a district layer.

Tha aim of this is to be used in an application.

Thanks in advance.

Re: Automatically populate field with values from another layer

RobertScheitlin__GISP — Wed, 02 Mar 2016 14:35:45 GMT

Eduardo,

What you are wanting to do is possible but pretty complicated.

Here is my recommended workflow steps that you would have to do:

1. Use the edit toolbar inorder to add your new feature.

Edit without editor widget | ArcGIS API for JavaScript

2. In the draw-end function before the selectedTemplate.featureLayer.applyEdits you would need to query the districts layer to see if the point you placed intersects.

3. For that you would use a QueryTask and a Query class that would use the geometry from step two and the SPATIAL_REL_INTERSECTS

4. Once you have results from that query you can get the results[0].attributes.District and put that in a var.

5. Then update the newAttributes array to replace the existing District value with the new on retrieved.

6. Then you can finally the selectedTemplate.featureLayer.applyEdits.

If you can not comprehend this workflow then this is probably something you will need to hire a developer/consultant company for as I mentioned this is possible but is not something that is easy.

Re: Automatically populate field with values from another layer

JacobTodd1 — Wed, 02 Mar 2016 19:19:10 GMT

Hi Eduardo,

Where is this data hosted? Is it hosted on ArcGIS Online or on your own local ArcGIS for Server server?

Thanks

Re: Automatically populate field with values from another layer

EduardoD__Cuesta — Thu, 03 Mar 2016 04:48:06 GMT

Hi Jacob,

The data are in a sde Oracle database, it is Feature Server in ArcGIS server.

Thanks in advance.

Re: Automatically populate field with values from another layer

JacobTodd1 — Thu, 03 Mar 2016 13:33:09 GMT

Hi Eduardo,

Thanks for your response. Since you are utilizing an SDE Oracle geodatabase as well as ArcGIS for Server, I would suggest that you do some research into database triggers. I have included a few resources regarding this topic below. Please keep in mind that configuring these triggers will not be supported by Esri Technical Support. I hope these resources will at least get you on the right track!

34972 - Use an Oracle trigger on a table to update an st_geometry attribute

Feature classes in a geodatabase in Oracle—Help | ArcGIS for Desktop

Re: Automatically populate field with values from another layer

EduardoD__Cuesta — Sun, 06 Mar 2016 04:35:42 GMT

Thank you so much, I will have a look.