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

How to manually make changes to assign Property Connection laterals after using LoadBuilder?

So I have imported geolocated water meters (and associated flow data) as Property Connections using the ModelBuilder tool. Then I used LoadBuilder to assign those Property Connections to the nearest link. However, some of the laterals were assigned to incorrect pipes or manholes. Is there a way I can manually assign the laterals to the correct location after they have already been assigned via LoadBuilder?

Parents
  • Hello Jose,

    Which product are you using? SewerGEMS or WaterGEMS?

    If using Property Connections with taps and laterals you can change the "referenced link" property of the tap to change to the correct pipe after your LoadBuilder run.

    In the Tap properties look for the property "referenced link and change it as per your requirement. However this will not change the location of the tap, but it will reference the pipe you have selected. See the article below for details on assigning property connections;

    Modeling Property Connections in the Storm-Sewer products

    If you are using WaterGEMS, they are called as "Customer Meters". However, the same concept can be applied there too.

    Let me know if this helps.


    Regards,

    Yashodhan Joshi

  • Yashodhan,

    Thank you for your reply.

    I am using SewerGEMS with taps and laterals. Ok, so lets assume I change the referenced link to the correct conduit, will the Base Flow associated with each Property Connection be applied to the referenced link? It also sounds like I cannot manually change the location of the taps and laterals though. The issue I have with changing all the referenced link is that it will make my model start to get confusing, as I will have the taps and laterals connected to one conduit, but the actual reference link is another. Is there any way to change the tap and laterals to the correct locations?

  • Hello Jose,

    See my responses below;

    Ok, so lets assume I change the referenced link to the correct conduit, will the Base Flow associated with each Property Connection be applied to the referenced link?

    Yes.

    It also sounds like I cannot manually change the location of the taps and laterals though.

    Not true. Yes you can change the physical location of the taps and laterals like you would move any other element. However, after changing the location you should ensure that the taps are referencing the correct link.

    The issue I have with changing all the referenced link is that it will make my model start to get confusing, as I will have the taps and laterals connected to one conduit, but the actual reference link is another. Is there any way to change the tap and laterals to the correct locations?

    If after a LoadBuilder run you have a bunch of Property Connections with taps and laterals referring to the incorrect conduit then you can follow this workflow;

    1. Create an table in a spreadsheet application (like Excel) with columns of tap connection label and referenced link

    2. List all the tap connection labels for whom the referenced link is incorrect under the "label" column and set the correct referenced link in the "referenced link" column. For example if "Tap-1" has "Referenced Link" as "CO-1" but in reality it should be "CO-15"; then type in "CO-15" next to the label "Tap-1" in the spreadsheet.

    3. Likewise do this for the entire model.

    4. Using ModelBuilder update the Tap flextable using this spreadsheet as source. See the below article for reference on this;

    Using ModelBuilder to Import External Data

    In the above article check out the sub-topic "Updating an existing model using ModelBuilder".

    5. This way all your "Referenced Links" would be updated with the correct element. 

    The alternative to this would be to manually change the referenced link for every tap connection.

    Hope this helps.


    Regards,

    Yashodhan Joshi

Reply
  • Hello Jose,

    See my responses below;

    Ok, so lets assume I change the referenced link to the correct conduit, will the Base Flow associated with each Property Connection be applied to the referenced link?

    Yes.

    It also sounds like I cannot manually change the location of the taps and laterals though.

    Not true. Yes you can change the physical location of the taps and laterals like you would move any other element. However, after changing the location you should ensure that the taps are referencing the correct link.

    The issue I have with changing all the referenced link is that it will make my model start to get confusing, as I will have the taps and laterals connected to one conduit, but the actual reference link is another. Is there any way to change the tap and laterals to the correct locations?

    If after a LoadBuilder run you have a bunch of Property Connections with taps and laterals referring to the incorrect conduit then you can follow this workflow;

    1. Create an table in a spreadsheet application (like Excel) with columns of tap connection label and referenced link

    2. List all the tap connection labels for whom the referenced link is incorrect under the "label" column and set the correct referenced link in the "referenced link" column. For example if "Tap-1" has "Referenced Link" as "CO-1" but in reality it should be "CO-15"; then type in "CO-15" next to the label "Tap-1" in the spreadsheet.

    3. Likewise do this for the entire model.

    4. Using ModelBuilder update the Tap flextable using this spreadsheet as source. See the below article for reference on this;

    Using ModelBuilder to Import External Data

    In the above article check out the sub-topic "Updating an existing model using ModelBuilder".

    5. This way all your "Referenced Links" would be updated with the correct element. 

    The alternative to this would be to manually change the referenced link for every tap connection.

    Hope this helps.


    Regards,

    Yashodhan Joshi

Children
  • Thanks, Yashodhan. Your answer makes sense.

    What about if the laterals were assigned to a manhole and not a conduit (so there was no Tap created)? It appears I cannot change the "Stop Node" for a particular lateral via flex table or the properties. The only way I have been able to change it is to delete the existing lateral and create a new lateral from the Layout Tab and draw it in manually. This is very tedious since I have potentially dozens of laterals to change. Will the method you described above work for changing the "Stop Nodes"?

  • Jose, you can re-assign the end of a lateral to another manhole by right clicking on the end of the lateral nearest to the manhole, choose "reconnect" and then click on the other manhole. There is an animation in the following article that demonstrates: Is there a way to reconnect a pipe to another element without deleting it ?

    Also see the part in this article that talks about the "assign taps to links" tool for the cases where property connections connect to a conduit via a tap. You can manually move the tap location as needed for all of the locations, then run this tool with the box checked for "also process taps that already have an associated link".


    Regards,

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

  • Thank you, Jesse.

    So is it true that I have to reconnect laterals to new manholes manually, one-by-one? Is there a way to create a selection set of multiple laterals and assign them to a different manhole in one step?

  • It would probably take more work to come up with a spreadsheet of the new lateral assignments and then update via ModelBuilder, compared to simply reconnecting them manually per previous suggestions. 

    Ideally LoadBuilder should properly assign the vast majority of property connections to the correct pipe/node, after which you would manually review and make what should be a small number of manual corrections. 

    If you are finding that you need to fix a large number of cases, then there could be a problem with the way the initial assignment was set up. Perhaps you can share an illustration to help us better understand your situation? (and why so many need to be re-assigned?)


    Regards,

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

  • No that's ok. The LoadBuilder did do a great job assigning to correct pipes/nodes. There are just a couple groups of 20 or so property connections (out of 10,000) that need to be reassigned. I just wanted to make sure I was doing it the most efficient way possible. Thanks for your help.