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

Query about updating waterGEMS model with new demands.

Here is what I have currently: 

  1. A working model with 5-year-old demands. Demands were present as customer meters(instead of directly allocating to nodes).
  2. Received customer billing data in Excel. Geocoded it in GIS and hence have a shapefile for it now. Data includes a unique customer meter number
  3. A lot of addresses are new. Hence, instead of updating old customer meters, prefer bringing it in from scratch.
  4. Diurnal demand patterns already exist in the model. I also have an idea of which new customer should get what kind of pattern.

Here is what I tried and why it does not work for me : 

  1. Initially tried doing thiessen polygon, but then realized that we won't be able to use demand patterns accurately for each customer.
  2. Then tried using LoadBuilder Data and used the point load data (Nearest Node) to import demands and allocate the demand patterns. Worked beautifully, but realized that I now cannot track which customer meter number got allocated to which node.

So, now my question is :

How do I import demands such that I can track the meter numbers also. I have tried doing the customer meter load data method (nearest node) and somehow the new demand is not showing up, even though the modelbuilder says that the customer meters have been created and loadbuilder says that the customer meters have been assigned. Also, if the demand does show up how do I allocate the demand patterns?

Thankyou.

  • Hello Varenya, 

    If you already imported demands on customer meters, then you can assign those customer meters to adjacent junctions using Customer meter load data > Nearest node, this will assign the customer meters to nearest nodes and also will add demands of customer meters to that connected junctions. Demands of customer meters can be seen in associated customer meter demands field in junction properties as seen below.

    Check below wiki if you are still having trouble seeing assigned customer meters after Loadbuilder run. It should like in above screenshot. 

    New demands or customer meter assignments not showing up after running LoadBuilder

    You can assign the demand patterns directly to customer meters, since you have demands associated to customer meters itself. Demand patterns can be associated in bulk, select customer meters which should have same pattern, right click > group edit > customer meter flex table > right click on pattern column > Global edit the pattern.

    Please let us know if this helps or not. 

    Regards,

    Sushma Choure

    Bentley Technical Suppport

  • Hello Varenya,

    In addition to my colleague, Sushma's response I would like to confirm the workflow you adopted. If you have the customer meter data with unique customer meters in a GIS (shapefile) format then you can simply use ModelBuilder to bring that data in. When you did bring the data in was is aligned with your network? When you geocoded the Excel data did you confirm (overlay) with existing network that it matches up? I am asking this because it could be that you used a different projection system and now the data is not in alignment with your network. If your Excel sheet had X, Y coordinates then this should be aligned with the existing data.

    If you have successfully imported the customer meters then see the solution Sushma provided about checking out the correct alternative or the source shapefile units.


    Regards,

    Yashodhan Joshi

  • Varenya, 

    If you already had older/outdated customer meter demands in your model, one approach to consider is:

    1) Delete all customer meters. (and taps) You can use the select by element feature in the Home tab to select them all at once and press the delete key.
    2) If you have not done so already, add a column to your shapefile that has the pattern names (matching the label seen in the pattern manager in WaterGEMS)
    3) Import the customer meters with ModelBuilder and map the pattern field so that the patterns get assigned.
    4) Use LoadBuilder to assign them to the nearest elements and create taps and laterals. Ensure that the correct demand alternative is used and consider the articles previously provided.

    If you cannot get the demand patterns added to your shapefile, you may be able to do it using another method. For example 


    Regards,

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