This is a Water Distribution Model for a city of 1,800 population. I'm in the process of building a new model for the City.
We decided to use Customer Meter Info to allocated demands. Instead of X, Y-coordinates for each customer, the data provided contains Property ID (PID) for each customer so that each customer demand can be allocated to a parcel in the map.
What is the best way to marge this data into the model?
I am not familiar with ArcGIS, so I searched if there is a way to convert PID into x, y coordinates - I have not found anything yet.
Do I need to import the data into ArcGIS and somehow find the x, y coordinates first before importing the customer meter info into WaterGEM? Or, is there an easier way around? The PID consists of thirteen numbers such as 2511722220007.
I'd appreciate your comments and advice on this. Thank you.
Yoko
Mark
Answer Verified By: Sushma Choure
Regarding assigning of the customer elements to junctions - there's also a new option in Loadbuilder (Tools > Loadbuilder) for assigning them based on spatial proximity. This is done after the customer meter nodes are imported into the model.
You can allocate based on nearest node, nearest pipe, or aggregate based on service area polygons (which you can generate using the Thiessen Polygon tool):
If you haven't done so already, I recommend watching this free webinar on Customer Element workflow.
Regards,
Jesse DringoliTechnical Support Manager, OpenFlowsBentley Communities Site AdministratorBentley Systems, Inc.
Mal,
Thank you for your reply.
I did watch the webinar a few weeks ago and that is why we decided to go with the customer meter. It seems that it has good information after successfully importing the customer meter data using Model Builder. But, I'm still stuck at the data importing process using the Model Builder. Here is the warming I got today when I was trying to import the customer meter data again.
Could someone look at the customer meter data file together with the model to see what is wrong with the importing procedure? I cannot share the data file here since it is highly confidential. Thanks again for your continuous support.