I have been digitizing a drainage network and now have been supplied attribute fields to add to the features I have digitized.
Two of the fields for the pipe features are 'upstream manhole ID' and 'Downstream manhole ID'. All pipe lines have direction. Most pipes are snapped to a manhole at some point, but not directly. This is due to each line of pipe being a separate segment. For example a pipe segment ends when it reaches a manhole, same for when it reaches an inlet from a gully.
How could I populate the two manhole ID fields in the pipe feature?
I have considered dissolving the pipe network completely and then splitting the result by the manhole points but this hasn't been successful so far.