I am trying to build a workflow for capturing data about flow meters deployed in sewer manholes. The requirements are to capture the GPS coordinates of the manhole, capture the manhole ID and pipe ID where the meter was installed, and record the diameter of the pipe.
I am trying to figure out how to do this. One idea I have is to create a point feature from the GPS location. Then, I am hoping there is a way to use Arcade to query the nearby manholes and create a picklist from which the user can choose the manhole. The manholes would be labeled on the map. The precision of the GPS coordinates, the manholes, and the pipes wouldn't be so great that you could just choose the nearest manhole automatically. A buffer would be required. Then, once the manhole is picked, I want to use Arcade to create another pick list of the connected pipes using a related table.
I'm not sure if this is possible or what this would be called.
