Automatically assign downstream Node IDs to upstream pipes

[blendt]

I was wondering if there was a tool in which you can assign the ID of a manhole to all manholes (or pipes) that connect upstream. To illustrate, I have have a backbone representation of a sewer network for hydraulic modeling purposes. I would like to automatically assign the IDs of modeled manholes along the backbone network to non-modeled manholes that connect downstream to a modeled manhole. Hopefully the attached image illustrates my question.

Thanks in advance!

Brian

[Atkuster]

Did you ever get this figured out? I'd like to do the same with our Stormwater dataset (assign upstream and downstream id's to pipes).

[Woodwa]

Attribute assitant can do this if they participate in a geometric network.. Atrribute Asistant takes a while to set up but it does provide some great data-model support.

the FROM_JUNCTION_FIELD and TO_JUNCTION_FIELD functions are the ones you are looking for

[blendt]

I found a great tool in ArcHydro 2.0 for ArcGIS 10 called "Accumulate Attributes". Basically you select the downstream nodes that you want to assign the cumulative upstream information to, select the source field / target fields and run the tool. It doesn't populate the downstream ID to upstream nodes, but the function that it performs is exactly what I needed in the end.

[pmoulden]

Its also possible to do this by dissolving the lines in your sewer network, executing two separate Features Vertices to Point functions (one for upstream points and one for downstream nodes), at this point if your nodes represent features that are matched in another layer (such as Manholes) you can use a spatial join to import those structure IDs into your new upstream and downstream nodes layers. Once your upstream and downstream features have IDs you can use another series of joins to add the ID's to your original (un-dissolved) sewers layer.

It could look something like this

Note that this model is not a working version of what we came up as a solution, the final version was much more complicated and had to be completed with python to be flexible with incomplete data sets and poorly interconnected sewer features.