This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

COLUMN FOR CUMULATIVE LENGTH ON THE FLEX TABLE and HOW TO SORT HGL FROM UPSTREAM TO DOWNSTREAM ON T-BRANCHED NETWORKS

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.

Parents
  • Hello Allan,

    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.

    Regards,

    Yashodhan Joshi

    Technical Support Engineer 


    Regards,

    Yashodhan Joshi

  • 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

  • Hey Jesse,

    Please take note that sorting HGL from upstream to downstream will display mixed results from two different branched networks

  • 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.


    Regards,

    Jesse Dringoli
    Technical Support Manager, OpenFlows
    Bentley Communities Site Administrator
    Bentley Systems, Inc.

  • Hello Jesse,

    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.


    Regards,

    Jesse Dringoli
    Technical Support Manager, OpenFlows
    Bentley Communities Site Administrator
    Bentley Systems, Inc.

  • 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

    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.

    check attachedWATERCAD.rar

    Can results for one branch be displayed first then results for the next branch to follow?

Reply
  • 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

    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.

    check attachedWATERCAD.rar

    Can results for one branch be displayed first then results for the next branch to follow?

Children
  • 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.


    Regards,

    Jesse Dringoli
    Technical Support Manager, OpenFlows
    Bentley Communities Site Administrator
    Bentley Systems, Inc.