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
Allan, you'll need to filter the flextable first on the correct branch, similar to the workaround from the wiki article I linked to. You can use the "find shortest path" query to select the elements on a particular branch, then open the junction flextable on selection and sort by HGL.
Jesse DringoliTechnical Support Manager, OpenFlows ProductsBentley Communities Site AdministratorBentley Systems, Inc.
The sort order is not done as I expect Jesse.HGL results arent in order
Please elaborate on the steps you have taken and what you are seeing, so that I may clearly understand and provide a solution.
I have added new columns for HGL(START) and HGL(STOP) to the flex table then sort the HGL(START) in a descending order and HGL(STOP) in descending order too.What I don't want is results from one branch to mix with those ones from the other but instead to be sorted one branch after the other.Please refer to my previous question
ALLAN MULONGO WAFULA said: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.
Can results for one branch be displayed first then results for the next branch to follow?
Hello Allan - Yes, this is what I meant by using queries to select one branch at a time, then filtering on the flextable. This is also the method I used to populate cumulative distance.
For example, in Network Navigator, choose Network Trace > Find Shortest Path, select your pump as the Start Node, then select the end of the first branch as the Stop Node (for example "(Point)-156"). Click Ok, then click the Select In Drawing button at the top. With the elements selected, right click in the drawing, choose Edit Group, then double click the junction table. This will open a table filtered to show only junctions along that first path. You can then short on HGL to order them from upstream to downstream.
The above steps are mentioned in the wiki article I had previously linked to.