Get ID from closest feature in different layer

Question

ArcGIS Collector (Android)

ArcGIS Online

---

Scenario:

Users create and update features in a point FC via Collector.

Upon creation/update, I want Collector to:

1. Automatically get the ASSET_ID value from the closest feature in a line FC.
2. Insert the value from the line FC into an ASSET_ID field in the points FC.

What would it take to configure ArcGIS Collector to automatically perform a spatial operation like this?

Answer 1

Since you can't extend or customize Collector itself:

1. Maybe using a SOI (Server Object Interceptor) to intercept the point feature add/update event, then execute some custom code such as the Near() geoprocessing method to return the closest line feature.
2. Have some sort of SQL trigger, to calculate the nearest line using the built-in spatial functions of the database.

Answer 2

Use Smart Edit Widget in ArcGIS Online Web Application builder