AnsweredAssumed Answered

End Point Attributes to Line

Question asked by decaturilgis on Oct 3, 2012
Latest reply on Apr 11, 2019 by leedanielley
Hi All,

I've got the following problem:

I have two datasets: "sewer_lines" and "manholes". Each sewer_line needs a unique ID based on the two manholes that make up it's end points.

The manholes dataset has the following attributes: manhole_id, manhole_elevation.

The sewer_line id needs to be in the following format: "upstream_manhole_id"-"downstream_manhole_id".

So, for example, there is a sewer_line that lacks an ID. It has a manhole at one end point with an ID of 221 and an elevation of 65.5 and a manhole at the other endpoint with an ID of 367 and an elevation of 60.3. The ID for the sewer_line needs to be: 221-367.

I've looked at a few different tools to try to automate the population of the sewer_line IDs, but am coming up empty handed. I've got about 15,000 sewer_lines that need these IDs. Can anyone offer any help/suggestions?