The wastewater data model is comprised of feature classes that are specific to the design, implementation, and maintenance of wastewater networks.
Feature classes are the basic class for objects. For example, a section or manhole is a feature class. In a database, each feature class corresponds to one Oracle table. A feature class can have any number of attributes (Oracle columns), one of which can be of type "geometry".
The WW_POINT and WW_LINE feature classes represent the points and lines that make up the wastewater network. WW_POINT features are wastewater features such as manholes, house connectors, valves, meters and other wastewater devices. WW_LINE features are the linestring geometries that represent sections. These features carry the wastewater and control its flow.
WW_CONN is the table that stores connectivity and flow information. We strongly recommend that you do not modify this table.
Each topic in the wastewater data model contains multiple types of feature classes.
Feature Class Type | Description |
---|---|
Attribute |
An attribute is a feature class that has no geometry. For more information, see Feature Class Type: Attribute. |
Line String |
The line string feature class is normally comprised of geometry and has one attribute that can be used for stylization by means of the Display Manager. For more information, see Feature Class Type: Line String. |
Collection |
A collection is a feature class for objects that can be either points, lines, or polygons. For more information, see Feature Class Type: Collection. |
Point |
The point feature class is made up of points that indicate the location of feetures, such as manholes, fittings, valves, etc. For more information, see Feature Class Type: Point. |
Polygon |
The polygon feature class is made up of line segments that form a closed region. The line segments that form the polygon have the same line attributes. Examples of the polygon feature class include the Drain Area and Sub-Drain Area. For more information, see Feature Class Type: Polygon. |
Dimension |
A dimension feature class (parent attribute feature class) is related to several child feature classes that store the geometry components, such as points (symbols) and lines, and labels. Dimensioning is stored in feature classes with the suffixes, _L (lines), _P (points), and _HL (help lines). For more information, see Feature Class Type: Dimension. |
For a number of feature classes, the Wastewater module provides model driven attributes. Use specific model tables (*_MODEL) to fill the model driven attributes:
See also Data Model: Model Tables.
They are used to collect several types (models) of a particular network item and can be grouped by manufacturer.
For example, in a wastewater network with several kinds of covers, you would fill the model driven attributes using a predifined record from the WW_COVER_MODEL table. In the Cover feature class form, you use the Model Selector control to fill in the model driven attributes more quickly.
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.
The following tables show sample cover and section models.
Table name |
WW_COVER_MODEL |
FID_MANUFACTURER |
-> WW_MANUFACTURER |
DIMENSION_1 and DIMENSION_2 |
First and second dimension |
ID_AERATION |
-> WW_COVER_AER_TBD To define the aeration type of the cover. |
ID_COVER_SHAPE |
-> WW_COVER_SHAPE_TBD |
ID_LOAD_CLASS |
-> WW_COVER_LOAD_TBD |
ID_MATERIAL |
-> WW_COVER_MAT_TBD |
LOAD_LIMIT |
Maximum load accepted by the cover. |
NAME_NUMBER |
Name or number. |
NARRATIVE |
A description or other unique information concerning the item. |
USER_FLAG |
An operator-defined work area. This attribute can be used by the operator for user-defined system processes. It does not effect the subject item's data integrity and should not be used to store the subject item's data. |
Topic |
Administration |
Table name |
WW_SECTION_MODEL |
DIAMETER_INSIDE |
Inside diameter of the pipe. |
DIAMETER_OUTSIDE |
Outside diameter of the pipe. |
DIMENSION_1 |
First dimension. |
DIMENSION_2 |
Second dimension. |
FID_MANUFACTURER |
WW_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_MATERIAL |
-> WW_MATERIAL_TBD |
ID_PROFILE |
-> WW_PROFILE_TBD |
NAME_NUMBER |
Model name or number. |
NARRATIVE |
A description or other unique information concerning the item. |
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 effect the subject item's data integrity and should not be used to store the subject item's data. |