Problem

How to apply conduit start/stop elevations (eg. ground & invert) to adjacent nodes.

For example, the only data available for an existing network is a Shapefile containing conduits. The conduits contain start/stop ground and invert elevations that need to be applied at the start/stop nodes.

Solution

If your node ground elevations have been imported, but you only have conduit start and stop inverts, with the node inverts set to zero, you could potentially perform an constraint based design run to "pull" the inverts up to the conduit invert. Set the desired sump depth to zero and configure the conduits so that the inverts and sizes are not designed.

However, if both the inverts and the ground elevation are only stored in the conduits, in the source external file, a process such as the following will be necessary:

Import manhole ground elevations from the conduits.

1. Using ModelBuilder, import the conduit ground elevations as the start and stop inverts.

2. Create a conduit FlexTable which includes the fields Label, Start Node, Invert (Start), Stop node and Invert (Stop).

3. Export the FlexTable to a CSV file.

4. Open the CSV file in Excel and save as an XLSX file.

5. Open ModelBuilder and create a new connection.

a. Select the Excel XLSX file.

b. Set the "Table Type" to Manhole.

c. Set "Key Fields" to Start Node.

d. Map the start elevation to the ground.

Import outfall ground elevations from the conduits.

6. Select all outfalls: Go to the Home tab, click Select By Element and select Outfall.

7. Select pipes next to the outfalls: Go to the View tab, click Queries and double-click on "Find Adjacent Links".

8. Open the conduit FlexTable for the selection: Right-click, choose Edit Group, select the conduit table created in step 2.

9. Open ModelBuilder and create a new connection.

a. Select the XLSX file created in step 4.

b. Set the "Table Type" to Outfall.

c. Set "Key Fields" to Stop Node.

d. Map the "Invert (Stop)" field to the outfall's "Elevation (Ground)" field.

Correct the conduit invert elevations

10. Using ModelBuilder, select the file containing the conduit data, and update the model so the conduits use the correct invert elevations.

Import manhole inverts from the conduits

11. Open the FlexTable created in step 2 and confirm the invert elevations were updated.

12. Export the FlexTable to a new CSV file.

13. Open that CSV file in Excel and save as an XLSX file.

14. Open ModelBuilder and create a new connection.

a. Select the Excel XLSX file.

b. Set the "Table Type" to Manhole.

c. Set "Key Fields" to Start Node.

d. Map the conduit invert elevations to the manhole invert elevations.

See Also

Importing external data using ModelBuilder - Building and updating