Hi,
I have a billing meter database which compromises properties with two or three kinds of consumption (e.g., residential, commercial and irrigation for an individual property). I imported these duplicate demands by individual LoadBulider run through Nearest Node method. Now, I wonder what is the best approach to be ensure about correct allocation of duplicate demands to those properties in WaterGEMS (connection Edition)?
Regards,
Ryan
Hello Ryan,
Please see below link that shall guide you to check demands allocated after Loadbuilder run.
How to view demand or load allocation after a Loadbuilder run?
Sushma Choure
Bentley Technical Suppport
Is this billing meter database stored separately for each of the consumption types? I.e. separate for residential, commercial and irrigation? Is this why you have to do each operation separately? Is it possible to combine the data so that you can identify consumption types and assign the loads in one LoadBuilder run?
I am sharing an article which discusses how the different LoadBuilder methods works for your reference;
How do each of the LoadBuilder methods work?
Let me know if this helps.
Yashodhan Joshi
Hi Yashodhan,
Thanks for your response. Yes, they are separate demands. I am aware on your proposed approach. However, the main issue is that when I try to join the combined data set of demands (Excel file) to an existing shape file of Property IDs in ArcGIS (to create the final demand layer as an input file for LoadBuilder), for those properties that have multiple demands, the joint values are represented as Null values. For this reason, I used two LoadBuilder file, one for properties with unique demand and the other one for those with multiple demands. If you know any other handy method, please inform me.
Hi Sushma,
Thanks for your quick response. I have applied another method. I used the Demand Control Center and copy the Label of all Junctions and paste them in an Excel file. Then I sorted them ascending and by writing the IF function, I have found the nodes that have multiple demands in the network.
However, currently I found an amazing issue on demand allocation procedure that some of the demands have been assigned to the nodes directly at the downstream/ or upstream of a tank (nearest node in the shortest distance) which I believe that should not be correct. How can I verify the model for those demands and why this issue happen? I should mention that I used the Thiessen Polygons and LoadBuilder ,nearest node method for demand allocation.
If you are using the Nearest Node method, you would choose a node layer. For instance, if you want to apply this to junctions, you can choose "Junctions\All Elements." If you do this, you should not see demands applied to tanks.
How were the Thiessen Polygons applied? The Nearest Node method uses a node layer by way of the either all of a given element (like junctioins) or a selection set within a node layer. The usage layer is typically your demand data from GIS.
You also mention using Excel. You can use an Excel file to add demand data using ModelBuilder. The steps to do this can be found in this link.
Scott