Need help working from home with your Bentley software? We're here to help - click here
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.
In reply to your comments above, the node at (POINT-35) is connected to the rising main and is independent of the downstream pipeline hence, therefore, creating an overlap.The network was functional as it is.I didn't want to connect all the pipelines on the same junction as it would have required use of a Non-Return Valve.
Regarding your article on how to track cumulative length along a very long pipeline, I have gone through the process but I find it quite tiresome and very lengthy when exporting data to excel and importing it back again to waterCad.I would suggest adding a cumulative length column on the Flex table will simply sort the problem for easier tracking.
And Last but not least, In regard to sorting elements from upstream to downstream on a branched network, as at now I will try and serialize my elements in a specific order then sort them according to this order.In the software, if you can come up with a way to sort pipelines from specific Junctions to end of pipelines it will be of great help.(To elaborate more I will say maybe on a branched T-network, the sort order on the flex table to be: Reservoir 1 to Junction 1(J1), then J1 to end of branch 1 to follow and finally J1 to end of branch 2.Please take note that only junctions but not all nodes should be included in the sorting order but instead should be covered in within the distribution pipelines.)
You can use the same HGL approach mentioned in my previous reply to sort a junction flextable by upstream/downstream order. Add the HGL field to the junction flextable and sort descending or ascending.
Jesse DringoliTechnical Support Manager, OpenFlows ProductsBentley Communities Site AdministratorBentley Systems, Inc.
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.
The sort order is not done as I expect Jesse.HGL results arent in order