Hello guys, I have a very long water distribution network imported via model builder from a GIS-based data.My questions are;-
1. Is there a way to create a new column on the "pipe" flex table to show the cumulative length of the length of pipes available?Its quite tiresome to input certain varying parameters like the size/type of pipes along the total length of pipe at certain specified distances(Let us say in 3000m, the pipe diameter varies as follows,1200m=16",800m=12" then the rest 1000m=8").How can I easily achieve this?Creating a flex table cumulative column looks like the best method for me.
You can also assist by defining a new user data extension.
2. On a dense network model or a branched /T-network, how can I easily sort my HGL from upstream to downstream along one branch then finish up with HGL data from the junction to the 2nd branch lets say on a T-network.(R1 to J 1,then J1 to node 1 and J 1 to node 2: How can I sort my HGL data on the flex table from upstream to downstream from R 1 to node 1 through J 1 then the rest of the network HGL data from J 1 to node 2 to follow right below.
The cumulative length of a water supply line denotes the total distance between the source till the end demand node. For a large distribution network there are typically multiple sources and many demand nodes. To create a cumulative length the upstream length must be added to the downstream length to get a cumulative length. This feature cannot be created in a Pipe Flex Table or a new User Data Extension as these upstream & downstream lengths are not available separately. However you can export the Pipe Flex Table to Excel and edit as required.
As far as arranging the data upstream to downstream, you can rename the pipes and junctions from the source to your demand end point serially and sort in an ascending order to get the elements sorted in an upstream to downstream fashion.
Please share the product name and version that you are using so that we can help you better. You can find out the current version number you are using by going in the Help Menu and clicking on "About". The version will be at the bottom left corner. The following article explains how to find out your version number.
How to find version of my product?
Hope this helps.
Technical Support Engineer
Bentley Technical Support
Hello Yashodhan Joshi,
It's so sad that WaterCad doesn't have these simple commands(CUMULATIVE LENGTH) in the flex table.
Please have a look at the attached file.I am using Bentley WaterCad series 6 V8i.I need a cumulative length column.If someone was to tell me to change the pipe sizes 800m from a distance lets say 300m from the start of the tank how could I easily do that?3414.WATERCAD.zip
Can youplease elaborate more on how to sort upstream to downstream on a branched network with one pipeline branch following the other on the flex table
Please send me your contact and company details by messaging me privately so that I can file an enhancement for this feature.
I can understand that this may be useful for rural, branched systems, but most WaterCAD/WaterGEMS models would not be able to use such a feature as they tend to be more complicated, with looping and flow direction that changes (for example a tank filling or draining).
For a branched system, you can accomplish this using the workflow in the following article I have just published to our Wiki:
Tracking cumulative length (stationing) for a branched water network
As a side note, in the model you sent, it looks like junction "(Point)-35" is overlapping a pipe but not connected. If you click and drag it away, you will see, and you may want to fix the topology if needed. (you can right click > split if needed)
I have split this pipe and followed the above procedure in your model, then saved it in case you need it for reference. Note that you'll need to be using the latest version in order to open this copy. You can read more about what has been added in the CONNECT Edition and CONNECT Edition Update 1 releases here and here.
Cumulative length update.zip
Regarding sorting upstream/downstream - in WaterCAD and WaterGEMS, this can be done by sorting on hydraulic grade (which is also involved in the above process). See the following article from our Wiki: Sorting and relabeling a flextable based on upstream-downstream order
Jesse DringoliTechnical Support Manager, OpenFlows ProductsBentley Communities Site AdministratorBentley Systems, Inc.
I have sent you a request.Thanks for your concern