About Wastewater Feature Classes and Types

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.

Feature Class Types

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.

Note:

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.

BestPractice:

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.