I am trying to create the appropriate schema for data collection in GIS so that my client can collect water and sewer data and easily import to SewerGems/WaterGems using the model builder. Is there anywhere that lists the schema, or even just the different Gems objecst/attributes that we can use?
It's good to be thinking about issues before you start building the GIS. Does the GIS already exist or are you building it along with the model?
The most basic question is "What is a pipe?" For a typical city block, do you have one pipe element from intersection to intersection or do you start a new pipe element at each gate valve or hydrant lateral. You can have one pipe per block or six depending on this decision.
Is a pump station a single point element in the GIS or do you capture each pump and its associated piping in the GIS. If you treat it as a single point in the GIS, how will you account for the individual pumps?
What is the nature of the data you will be using for demands? Are you going to account for each customer meter or will your data be aggregated in some way?
There are a lot of these kinds of decisions and you need to consider the implications of each. It's good to think these thorough at the start. A lot will depend on you expected use of the model and availability/format of your data.
Thanks, we do understand the type of considers needed in the model, but are really just looking for the example schema (i.e. the list of each object used in the models and their specific attributes) to use in the data collection step that will be occurring soon. The data exists in part, but the client is having a full data collection effort coordinated. If we could use the information needed for the Gems models as a template for the GIS schema, we can get as much as possible of the correct data field collected in this effort. I thought that list would exist on the site somewhere, but I have not been able to track it down.
Alison,
Here is the email I sent to Marla which we believe gives you the best list that exists for the attributes carried by our Water and Sewer products. Please let me know if this doesn't answer your questions and I'll dig further.
Marla,
Development sent me these Document links:WaterGEMS:
https://docs.bentley.com/LiveContent/web/Bentley%20WaterGEMS%20SS6-v1/en/GUID-5B14E934-4EC2-400A-B827-1B7B337B3111.html
SewerGEMS:
https://docs.bentley.com/LiveContent/web/Bentley%20StormCAD%20SS5-v1/en/GUID-1D0A973F-8ABF-4C4C-8D0A-2873828A7CBF.html
They describe every attribute we carry on all of our elements in our Water and Sewer products. You don’t need to have ALL of the attributes in your GIS, only the ones you really need as part of the hydraulic model based on the output you want to derive from your model. But, we don’t really have a list of the “important” ones since that’s going to be different for every user. I will mention the main ones like elevations (invert, rim), diameter/size, roughness, age/install year...
Please let me know if this answers your questions.
Thank-you,Larry