Questions about this article, topic, or product? Click here.

Required Input properties for using a Bentley Hydraulics and Hydrology application integrated with ArcGIS (ie. Data Model)

Product(s):	WaterGEMS, SewerGEMS, HAMMER
Version(s):	08.11.XX.XX and 10.00.XX.XX
Area:	Modeling

Problem

When using a Bentley Hydraulics and Hydrology application integrated with ArcMap, which input properties are required?

How to match data from GIS to the model?

Background

A "data model" is standard GIS terminology. It defines what attributes are stored and in what tables.

All element types are listed in the Help documentation, but the properties for each element type are not.

Solution

If you are interested in the ArcGIS Data Model (for Bentley Hydraulics and Hydrology geodatabase), then it is pretty simple.

There is one FeatureClass per Bentley Hydraulics and Hydrology model element type.
There are three fields on each FeatureClass (OBJECTID, ElementTypeId, ElementId).
The rest of the fields dynamically appear when running the Bentley Hydraulics and Hydrology application integrated with ArcGIS, but they are not in the geodatabase.

Note:

The standard ESRI data model can be used and then the fields are mapped across to WaterGEMS in ModelBuilder.
The Bentley Hydraulics and Hydrology model data is not stored in the GIS (at least not the data store users are concerned with), so the data model shouldn't matter.

The full list of available attributes for an element type can be found by opening the FlexTable for the element type and selecting the Edit button.

The list of attributes for each element depends on the version of the Bentley Hydraulic and Hydrology application being used. There are a many available attributes, not all of which are required.

The demand for a junction is nested within the demand collection so it can’t be imported directly to the node.

Here is an example list of the properties associated with each model element type.

These properties can be mapped to using ModelBuilder to match the data model you want to use in ArcGIS.

For WaterGEMS Models:

Data	Units
	US	SI
Pipes:
Label	n/a
Length	feet	m
Diameter	inches	mm
Roughness	n/a
Upstream Node	n/a
Downstream Node	n/a
Material ⁽¹⁾	n/a

Junctions:
Label	n/a
Demands	gal/min	L/min
Elevation	ft	m
Pressure Zone	n/a
X coordinate	ft	m
Y coordinate	ft	m

Valves:
Label	n/a
Elevation	ft	m
Type?⁽²⁾	n/a
Downstream Pipe	n/a
X coordinate	ft	m
Y coordinate	ft	m

Pumps:
Label	n/a
Elevation	ft	m
Pump Curve⁽³⁾	ft	m
X coordinate	ft	m
Y coordinate	ft	m
Downstream Pipe Label
variable speed pump?	boolean

Tanks:
Label	n/a
Ground Elevation	ft	m
Tank Base Elevation	ft	m
Minimum Elevation/Level	ft	m
Initial Elevation/Level	ft	m
Maximum Elevation/Level	ft	m
Tank Diameter	ft	m
Inactive Volume	ft²	m²
X coordinate	ft	m
Y coordinate	ft	m

Reservoirs:
Label	n/a
Elevation	ft	m
Zone	n/a
X coordinate	ft	m
Y coordinate	ft	m

Isolation Valves:
Label	n/a
X coordinate	ft	m
Y coordinate	ft	m
Status (Initial)	Open/Closed
Is Operable?	Yes/No
Minor Loss Coefficient	n/a
Diameter	in	mm
Elevation	ft	m

Hydrants:
Label	n/a
X coordinate	ft	m
Y coordinate	ft	m
Demand	gal/min	L/min
Elevation	ft	m
Emitter Coefficient	gal/min/psi^n	L/sec/(m H20)^n
Include Lateral Loss?	Yes/No
Hydrant Status	Open/Closed

(1) Needs to match Material Library inside of WaterGEMS
(2) Dependent on type pressure or flow settings may be needed.
(3) Three point or multiple point pump curves are needed. Can be acquired by pump manufacturer.

For SewerGEMS Models:

Data:	Units:
	US	SI
Gravity Pipes / Conduits:
Label	n/a
Length	ft	m
Diameter	inches	mm
Roughness	n/a
Upstream Node	n/a
Downstream Node	n/a
Material	n/a
Upstream Node Invert	ft	m
Downstream Node Invert	ft	m

Manholes:
Label	n/a
Ground Elevation	ft	m
Invert Elevation	ft	m
X coordinate	ft	m
Y coordinate	ft	m
Diameter	in	mm
Sanitary Loads	gal/min	L/min

Wet Well:
Label	n/a
Ground Elevation	ft	m
Invert/Base Elevation	ft	m
X coordinate	ft	m
Y coordinate	ft	m
Sanitary Loads	gal/min	L/min
Minimum Elevation/Level	ft	m
Initial Elevation/Level	ft	m
Alarm Elevation	ft	m
Maximum Elevation/Level	ft	m
Average Area	ft²	m²
Inactive Volume	gal	L

Pumps:
Label	n/a
Elevation	ft	m
Pump Curve**	ft	m
X coordinate	ft	m
Y coordinate	ft	m
Downstream pipe	n/a

Pressure Pipes:
Label	n/a
Length	ft	mm
Diameter	in	mm
Roughness	n/a
Upstream Node	n/a
Downstream Node	n/a
Material	n/a

Pressure Junctions:
Label	n/a
Sanitary Loads	gal/min	L/min
Elevation	ft	m
Pressure Zone	n/a
X coordinate	ft	m
Y coordinate	ft	m

Outfall:
Label	n/a
X coordinate	n/a
Y coordinate	n/a
Ground Elevation	ft	m
Sump Elevation	ft	m
Tailwater Condition	n/a
Tailwater Elevation(s)	ft	m

Cross Section:

Open Channel Cross Section:
Label	n/a
X coordinate	ft	m
Y coordinate	ft	m
Roughness Type	n/a
Material	n/a
Roughness Coefficient	n/a
Section Type	n/a

Trapezoidal Cross Section Data:
Invert Elevation	ft	m
Botton Width	ft	m
Left Side Slope	ft/ft	m/m
Right Side Slope	ft/ft	m/m
Height	ft	m

Irregular Cross Section Data:
Station(s)	ft	m
Elevation(s)	ft	m

Channel:
Label	n/a
Length	ft	m
Upstream Node	n/a
Downstream Node	n/a

Pond:
Label	n/a
Volume Type	n/a
Volume Data for Type	n/a
Geometry	n/a
Initial Elevation	ft	m

Catchment:
Label	n/a
Outflow Node	n/a
Runoff Method	n/a
Runoff Hydrograph or Storm Data	n/a
Tc	hours
Area	ft²	m²
CN or C	n/a

Catchbasin (Inlet):
Label	n/a
X coordinate	ft	m
Y coordinate	ft	m
Ground Elevation	ft	m
Sump Elevation	ft	m
Headloss Method	n/a
Inlet Type	n/a
Diameter	in	mm
Structure Shape	n/a