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

Demand Assigning based on Household Survey

I have collected the Field questionnaire survey details with Geo-coordinates. The Details comprises of No. of Persons, Commerical or Residential, 

I need to assign the demand (per capita) based on the population and type of Connection details to the near node or pipeline.

How do i do ? and run the model 

  • Hello Naresh,

    What format is this field questionnaire in? Do you have a spreadsheet (like in Excel) with all the data? Or is it in a GIS format like a shapefile?

    Here is the workflow I propose to assign demands in case of such data;

    I am assuming that you have the network setup in WaterGEMS or WaterCAD at this point and you want to bring in this data into your model.

    1. Create the Commercial and Residential patterns and demand rates in your WaterGEMS or WaterCAD model. This will help in assigning the same then importing the data.

    2. Use the ModelBuilder tool to import the data into your hydraulic model. You can use Customer Meter elements to assign data such as the number of persons, type of demand (commercial or residential). Using Customer Meters you can assign the X and Y coordinates (since you have the coordinate data) and bring in all the associated attributes as the customer meter properties (no. of persons, commercial or residential type pattern).

    Note: Depending on the data you have, you might need to do this operation once again. For example if you only have number of people and the demand rate (for commercial or residential in lpcd) then the above step is enough. However, if you have base flow and actual demands then you would have to do a separate ModelBuilder run to assign these flows. See this article for that: Importing Demands From A Spreadsheet

    3. Finish ModelBuilder import process. Now you will have the Customer meters imported in your model as per the coordinates given.

    4. Use the LoadBuilder tool and select "Customer Meter load data" option. Now choose "Nearest Node" or "Nearest Pipe" options and proceed. This will create taps and laterals connecting your customer meters to your existing hydraulic network.

    5. This way the demands associated with the field survey are now imported in your hydraulic model.

    Let me know if this helps.


    Regards,

    Yashodhan Joshi

  • If you have polygon information that can be converted (if not already) to Shapefile format, you can use LoadBuilder directly to allocate demands to junctions.

    The Details comprises of No. of Persons, Commerical or Residential


    Based on this description, the process in the following article may suit your needs: Import loads from shapefile containing polygons with land use type and total population


    Regards,

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

    Answer Verified By: Naresh V 

  • Dear Joshi, 

    Thanks for your support, Will work out the steps and reach you if I couldn't. 

    And, I have my details in excel format with X & Y Coordinates; Which i can assign data based on your steps.. 

    Thank you