Weir Data Fields

Weirs are used for overflow structures and for outlets to storage ponds. Weir data can be edited on either the Weir Grid Window of the Asset Grid or the Weir Property Sheet.

To view and edit all weir data, use the Property Sheet.

The following describes all the data which can be used to define a weir.

Common Data Fields

Fields that are common to the majority of objects can be found in the Common Fields topic.

Weir Data

Database Table Name: cams_weir

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Field Name

Help Text

Database Field

Data Type

Size

Units

Precision

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

ID

The name of the object.

The ID is the primary key in the database for the network object. This means that the ID field of each object must be unique for all objects of the same object type.

id

Text

40

 

0

 

 

 

 

 

US node ID

Upstream node.

us_node_id

Text

40

 

0

 

 

 

 

 

DS node ID

Downstream node.

ds_node_id

Text

40

 

0

 

 

 

 

 

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

System type

System type:

Database Value

Description

F

Foul

S

Surface

C

Combined

T

Transition

O

Overflow

U

Unspecified

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

system_type

Text

10

 

0

 

 

 

 

 

Type

The type of ancillary structure:

Database Value

Description

S

Standard

VC

Variable Crest

VW

Variable Width

CO

Contracted Rectangular

VN

Vee Notch

TR

Trapezoidal Notch

BR

Broad Crested

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

type

Text

10

 

0

 

 

 

 

 

Operational status

Current operational status:

Database Value

Description

AB Abandoned
INUSE In Use
STANDBY Standby

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

status

Text

10

 

1

 

 

 

 

 

X coord

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coord

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Branch ID

Numeric field used to identify to which long section the link is associated. (See Defining Branches for further information).

branch_id

Long Integer

 

 

0

 

 

 

 

 

Level

The level at which the weir first comes into operation.

For vee and trapezoidal notch weirs, and contracted rectangular weirs, this is the height of the base of the notch.

level

Double

 

Z

3

 

 

 

 

 

Width

The width of the rectangular weir.

width

Double

 

MANH_DIM

1

 

 

 

 

 

Length

The distance across the flat part of the top of the weir measured parallel to the direction of flow. The distance does not include the round noses of the weir

Broad Crested Weir only.

length

Double

 

L

3

 

 

 

 

 

Height

Roof Height for the weir. If you enter a value here, the weir behaves as a sluice gate when the water level is above the roof height. If you do not give a value here, it is assumed that the weir does not have a roof.

Standard Rectangular Weir types only.

height

Double

 

MANH_DIM

1

 

 

 

 

 

Notch height

The vertical distance from the base (apex) of the notch to the top of the weir plate.

Vee and Trapezoidal Notch Weirs only.

notch_height

Double

 

MANH_DIM

1

 

 

 

 

 

Notch width

For Contracted Rectangular Weirs, this is the width of the single notch.

For Trapezoidal Notch Weirs this is the width of the base of one notch. The weir may have more than one notch. The side slope of all notches is assumed to be 14 degrees.

Contracted Rectangular and Trapezoidal Notch Weirs only.

notch_width

Double

 

MANH_DIM

1

 

 

 

 

 

Notch angle

The angle at the base (apex) of the notch in degrees. This means the full angle, not the angle of side slope.

Vee Notch Weir only.

notch_angle

Double

 

 

1

 

 

 

 

 

Num notches

You can have more than one vee or trapezoidal shaped notch in a weir. Enter the number here. All the notches are identical.

Vee and Trapezoidal Notch Weirs only.

num_notches

Long Integer

 

 

1

 

 

 

 

 

Condition grade

A measure of asset condition for ancillary assets. By analogy with pipe condition grades, this is usually a number in the range 1-5. Unlike pipe condition grade, there is no distinction between structural and service condition for ancillary assets.

condition_grade

Long Integer

 

 

0

 

 

 

 

 

Critical

A measure of the likely impact of asset failure. The WRC SRM uses the codes A, B, C to represent "A" sewers where failures would be expensive to "C" where failures would be relatively cheap.

criticality

Text

5

 

0

 

 

 

 

 

Security

The security of the asset from unauthorised access/tampering:

Database Value

Description

A

Vulnerable

B

Moderate Risk

C

Secure

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

security

Text

10

 

0

 

 

 

 

 

Construction date

Construction or installation date. This is date from which depreciation costs will be incurred for depreciation reports.

constr_date

Date / Time

 

 

0

 

 

 

 

 

Condition survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

 

 

0

 

 

 

 

 

Installation cost

The original installation cost of the asset. This generally includes all costs incurred (e.g. mantime, asset purchase costs etc). This information is used in depreciation reports.

install_cost

Double

 

WN_COST

2

 

 

 

 

 

Inspection cost

Estimated cost of asset inspection.

inspection_cost

Double

 

WN_COST

2

 

 

 

 

 

Expected lifetime

The expected lifetime of the asset. This is used in depreciation reports as the period over which installation costs may be depreciated.

lifetime

Long Integer

 

 

0

 

 

 

 

 

Rehabilitation cost

Rehabilitation costs to be incurred in bringing the asset to an acceptable condition. This is used in rehabilitation reports.

rehab_cost

Double

 

WN_COST

2

 

 

 

 

 

Replacement cost

The estimated cost for completely replacing an asset.

replace_cost

Double

 

WN_COST

2

 

 

 

 

 

Attachments

Click the button to display the Attachments Editor, used to attach and manage photos, sketches and other files associated with the network object.

See Attachments Editor and Common Data Fields for further details.

attachments Array                
General properties fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties fields See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.                    
Time series links

Click the button to display the Time Series Data Source Grid, which is used to specify or update the time series data streams that are linked to this weir.

tsdb_links                  
Network Data Fields

Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.

Weirs

Asset Grid