For a large number of feature types, the Water module provides model driven attributes. You use model tables (*_MODEL) to fill the model driven attributes. Model tables describe several types (models) of a particular network item and can be grouped by manufacturer. Create models for water network items to simplify data acquisition.
For example, in a water utility network with five kinds of valves, you would fill the model driven attributes using a predefined record from the WA_VALVE_MODEL table. In the Valve feature class form, you use the Model Selector control to fill in the model field easily.
In the Model input field, the value Choose Model indicates that you can apply a model. It does not store the model that has been applied, because at any time you can modify the model driven attributes. The attributes are stored in the main feature class, and you use the model feature class to insert a set of attributes. You can use the model table to store reference values.
In the feature class form, use the Model table, to search for an appropriate model. Use the model list, if you are sure which model to use. In the Form Designer, modify the model table form to hide or show model attributes, or to modify the order in the grid. Modify the main feature class form to move the Model selector to another location.
Usually the model information is created either at the beginning of the project or during data acquisition.
The following table is an example of a pipe model table.
| Table name |
WA_PIPE_MODEL |
|
CERTIFICATE |
Description of DIN/ISO/DVGW/TUEV value. |
|
DATE_CREATION |
Date when the item was created. |
|
DIAMETER_INSIDE |
Inside diameter of the pipe. |
|
DIAMETER_NOMINAL |
The manufacturer's designated size, or nominal diameter, such as 1" gas hydrant, 2" meter, 6" pipe. |
|
DIAMETER_OUTSIDE |
Outside diameter of the pipe. |
|
FID_MANUFACTURER |
WA_MANUFACTURER Manufacturer of this item. |
|
HYDRAULIC_FRICTION |
Hydraulic friction or kind of roughness inside the pipe; what causes a decrease in pressure relative to the pipeline length. |
|
ID_COATING_INSIDE |
WA_COATING_TBD |
|
ID_COATING_OUTSIDE |
WA_COATING_TBD |
|
ID_MATERIAL |
WA_MATERIAL_TBD |
|
MODEL_NUMBER |
Model name or number. |
|
NARRATIVE |
A description or other unique information concerning the item. |
|
PRESSURE_MAX |
The manufacturer's or industry standard's maximum pressure rating. |
|
THICKNESS |
Thickness of the pipe wall. |
|
USER_FLAG |
An operator-defined work area. This attribute can be used by the operator for user-defined system processes. It does not affect the subject item's data integrity and should not be used to store the subject item's data. |
|
VALUE |
Short description of the model. This value is used for the domain table representation of the model. |
The following table is an example of a valve model table.
| Table name |
WA_VALVE_MODEL |
|
ANGULAR_DESIGN |
1 = is shaped angular. |
|
CERTIFICATE |
Description of DIN/ISO/DVGW/TUEV value. |
|
CONTINUOUS_ADJUSTMENT |
Item can be adjusted continuously (yes/no). |
|
DATE_CREATION |
Date when the item was created. |
|
FID_MANUFACTURER |
WA_MANUFACTURER |
|
ID_COATING_INSIDE |
WA_COATING_TBD |
|
ID_COATING_OUTSIDE |
WA_COATING_TBD |
|
ID_MATERIAL |
WA_MATERIAL_TBD |
|
ID_TYPE |
WA_VALVE_TYPE_TBD Particular kind, class, or group of valve, such as gate, or check. |
|
LOCKABLE |
Item is lockable (yes/no). |
|
MODEL_NUMBER |
Model name or number. |
|
NARRATIVE |
A description or other unique information. |
|
PRESSURE_MAX |
The manufacturer's or industry standard's maximum pressure rating. |
|
USER_FLAG |
An operator-defined work area. This attribute can be used by the operator for user-defined system processes. It does not affect the subject item's data integrity and should not be used to store the subject item's data. |
|
VALUE |
Short description of the model. This value is used for the domain table representation of the model. |
|
VALVE_LENGTH |
Length. |