Flume Data Fields
Flumes are effectively constrictions in a channel or pipe. They are usually used to allow you to make accurate flow measurements.
Flume data can be edited on either the Flume Grid Window of the Asset Grid or the Flume Property Sheet.
To view and edit all flume data, use the Property Sheet.
The following describes all the data which can be used to define a flume.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Flume Data
Database Table Name: cams_flume
|
Field Name |
Help Text |
Database Field |
Size |
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:
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.
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:
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 Invert Level is the level above datum of the top of the hump (assuming the flume has a hump in the throat). Hump height is then calculated as Invert Level minus Upstream Invert. If the flume has no hump it is the level above datum of the centre of the throat. |
level |
Double |
|
Z |
3 |
|
|
|
|
|
||||||||||||||
|
Width |
The width across the narrow part of the flume. For trapezoidal flumes, the bed width should be used. The width of a U-shaped flume is also the diameter of the semi-circular invert. |
width |
Double |
|
MANH_DIM |
1 |
|
|
|
|
|
||||||||||||||
|
Length |
The length of the straight sided part of the throat. |
length |
Double |
|
L |
3 |
|
|
|
|
|
||||||||||||||
|
Side slope |
Only relevant for trapezoidal flumes. The two sides of the flume are assumed to have equal slopes. The Side Slope is the ratio of the horizontal distance over the vertical distance. This means that a vertical side has a Side Slope of zero. As the side approaches horizontal, the Side Slope value approaches infinity. |
side_slope |
Double |
|
|
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:
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 |
|
|
|
|
|
||||||||||||||
|
Replacement cost |
The estimated cost for completely replacing an asset. |
replace_cost |
Double |
|
WN_COST |
2 |
|
|
|
|
|
||||||||||||||
|
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 |
|
|
|
|
|
||||||||||||||
|
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 |
|
|
|
|
|
||||||||||||||
| Attachments |
Click the See Attachments Editor and Common Data Fields for further details. |
attachments | |||||||||||||||||||||||
| 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 |
tsdb_links |
button to display the Network Data Fields Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.
