Basic Pipe Data Fields

Basic pipe data fields can be edited on the Pipe Grid View of the Links Grid or the Pipe Property Sheet.

All the fields needed for a pipe are described in this topic.

Further information, including units details, about all the Network Object fields stored in the Master Database can be found in the data fields topics listed in the Network Data Fields topic.

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

The pages on the Property Sheet are listed below. When the network object has Control Data or Alternative Demand Data additional pages may be displayed on the property sheet. These pages are marked as follows:

- additional page displayed when Control Data is open

- additional page displayed when Alternative Demand Data is open

  1. Pipe Definition Page
  2. Customer Points Page (the customer points listed on this page are those attached to the pipes upstream and downstream nodes)
  3. Spatial Data Page
  4. User Page - see Common Data Fields topic for details of user fields
  5. Alternative Customer Points Page
  6. Pipe Control Page
  7. Pipe Closed Profile Page
  8. WQ Turbidity Page
  9. Hyperlinks Page - see Common Data Fields topic for details of hyperlinks fields
  10. BalanceNet Page - only displayed when the Show BalanceNet fields option is selected in the BalanceNet page of the Options dialog
  11. Control Notes Page
  12. Notes Page - see Common Data Fields topic for details of notes fields

Basic Pipe Data

Database Table Name: wn_pipe

Show Columns

Help Text

Visibility

Size, Type and Units

Database Names

Error Limits

Field Name

Help Text

Flag

Grid

Property Page

Size

Precision

Units

Database Field

Data Type

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

From Node ID

Name of the From Node for this pipe. You can select the name from the dropdown list of existing nodes, or type the name of a node you have yet to add to the model.

From and To represent the typical direction of flow for the pipe. Flow will not always be in this direction.

YES

YES

1

30

0

 

us_node_id

Text

 

 

 

 

 

To Node ID

Name of the To Node for this pipe.

From and To represent the typical direction of flow for the pipe. Flow will not always be in this direction.

YES

YES

1

30

0

 

ds_node_id

Text

 

 

 

 

 

Area Code

The Area Code parameter is used for closer spatial modelling of demand - each node is allocated to an area and demand can then be factored by area.

The factor is set using the Demand Scaling Editor.

YES

YES

1

30

0

 

area

Text

 

 

 

 

 

Asset ID

For reference only. Designed as a reference to an asset database, but could be used for anything.

YES

YES

1

30

0

 

asset_id

Text

 

 

 

 

 

Local Loss Coefficient

Local Headloss Coefficient used by the Darcy Weisbach roughness formula

YES

YES

1

 

4

 

local_loss

 

 

0

10000000000

 

 

Has Valve

When enabled, indicates the presence of an isolation valve in the pipe, therefore the pipe can be opened or closed.

YES

YES

YES

 

 

 

iwlive_can_be_closed

Boolean

 

 

 

 

 

Length

The length of the pipe.

YES

YES

1

 

2

L

length

 

 

0.1

1000000

 

 

Diameter

Internal diameter of the pipe

YES

YES

1

 

1

PS

diameter

 

 

10

20000

 

 

Friction Type

The formula used for roughness calculations. Can be Darcy Weisbach, Hazen Williams, or Colebrook White. See Pipe Calculations for more information.

Database Value

Description

CW

Colebrook-White (Moody diagram)

HW

Hazen-Williams

DW

Darcy-Weisbach (constant f)

YES

YES

1

2

1

 

roughness_type

Text

 

 

 

 

 

CW - k

The value for the friction coefficient appropriate to the chosen roughness type. Follow the links above for more details

YES

YES

1

 

6

WN_K

k

 

 

0.001

200

 

 

DW - f

The value for the friction coefficient appropriate to the chosen roughness type. Follow the links above for more details

YES

YES

1

 

6

 

darcy_weissbach

 

 

0.002

0.09

 

 

HW - c

The value for the friction coefficient appropriate to the chosen roughness type. Follow the links above for more details

YES

YES

1

 

1

 

hazen_williams

 

 

20

5000

50

200

Material

Link material. Used by the roughness formulae.

YES

YES

1

10

0

 

material

Text

 

 

 

 

 

Year

Year of installation. Used by the roughness formulae.

YES

YES

1

 

0

 

year

Integer

 

 

 

 

 

CO2 Material Cost

Carbon Dioxide equivalent cost of pipe materials.

Can be set from lookup tables. See Setting CO2 Cost of Material.

YES

YES

1

 

1

PIPE_CO2TOT

CO2cost

Single

         

WQ Bulk Coefficient

The bulk coefficient, kb, is a reaction rate parameter used to calculate the change in concentration of a substance as it reacts with material in the bulk flow. The bulk coefficient has a positive value if the concentration of the substance grows over time, and a negative value if the concentration decays over time.

Please Note

Source dependent bulk coefficient values may be specified at individual nodes which may override or scale the pipe Bulk Coefficient value when calculating reaction rates for water that entered the system at the node.

YES

YES

1

 

2

 

bulk_coeff

 

-0.5

-10

10

 

 

WQ Wall Coefficient

The wall coefficient, kw, is a reaction rate parameter used to calculate the change in concentration of a substance as it reacts with material along the pipe walls. The wall coefficient has a positive value if the concentration of the substance grows in time, and a negative value if the concentration decays in time.

YES

YES

1

 

2

 

wall_coeff

 

-0.3

-10

10

 

 

System Type

For information. Type in a system type or select an option from the dropdown list:

Database Value

Description

Help Text

POTABLE

Potable

System used to transport water of a quality suitable for drinking.

RAW

Raw

System used to transport water used as a source supply for potable water before it has been treated.

RECYCLED

Recycled

System used to transport wastewater effluent that has been treated to provide a non-potable supply suitable for uses such as irrigation.

YES

YES

1

40

0

 

system_type

Text

 

 

 

 

 

Isolation Area

Area identifier used to identify groups of objects to be closed when carrying out a Critical Link Analysis.

YES

YES

1

30

0

 

isolation_area

Text

 

 

 

 

 

Suffix

A suffix added by InfoWorks to ensure that all link Ids are unique

YES

YES

NO

1

0

 

link_suffix

Text

 

 

 

 

 

Criticality

The criticality grade of the link. This provides an indication of the significance of the effect on the network if the link fails.

This field may be updated from a Critical Link Analysis simulation.

YES

YES

1

 

0

 

criticality

Integer

 

 

 

 

 

Criticality Count

Number of items (Nodes, Properties, Customer Points or Connections) assessed as critical in the event of link failure.

This field may be updated from a Critical Link Analysis simulation.

YES

YES

1

 

0

 

criticality_count

Integer

 

 

 

 

 

Wave Celerity

Velocity of propagation of pressure waves caused by sudden increase or decrease in flow rate.

See Transients Advisor for more details.

YES

YES

1

 

 

V

wave_celerity

 

1400

 

 

 

 

Pressure Rating

Maximum design working pressure of link

YES

YES

1

 

 

WN_P

pressure_rating

 

 

 

 

 

 

Bends

This field defines the geometry of the link. The underlying data consists of a series of (x,y) pairs defining the vertices of the link. Each link is made up of a series of straight lines between the defined (x,y) points.

This data is not displayed on the grid or property sheet.

Link vertices are included when you export link data to CSV files. There are two options available for exporting link vertices. These are selected on the Select CSV Export Options dialog using the Coordinate Arrays Format dropdown list. The options are:

  • Packed - The data is exported as a series of x,y pairs. {644362.99966,263102.99717,643599.42660,263312.948517}

  • Separately - the data is appended to the end of the row containing the link data. Each x and y value is in a separate (comma separated) field.

NO

YES

NO

 

0

XY

bends

Array

 

 

 

 

 

InfoNet Unique ID

The InfoNet Unique ID and InfoNet Network ID are unique identifiers associated with the corresponding object and network in an InfoNet database. When importing from InfoNet, these identifiers can be copied from the InfoNet database in order to maintain links between the two networks.

YES

YES

NO

 

0

 

asset_uid

GUID

 

 

 

 

 

InfoNet Network ID

See InfoNet Unique ID

NO

YES

NO

 

0

 

asset_network_uid

GUID

 

 

 

 

 

Basic Pipe Alternative Demand Data

The Alternative Customer Points Page is displayed when an Alternative Demand is associated with the Network.

For details of alternative demand data fields, see the Alternative Demand Data Fields topic.

Basic Pipe Control Data

Database Table Name: wn_ctl_pipe

Show Columns

Help Text

Visibility

Size, Type and Units

Database Names

Error Limits

Field Name

Help Text

Flag

Grid

Property Page

Size

Precision

Units

Database Field

Data Type

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

Live Data Point ID

Name of the associated Live Data Point

YES

YES

6

100

0

 

live_data_point_id

Text

 

 

 

 

 

PoW Unit Cost (from - to)

Cost per cubic metre, in user defined currency units, of transferring water between the From Node and To Node.

Prices can be negative to allow for exports or bulk water sale.

YES

YES

6

 

2

WN_VCOST

usds_pow_cost

 

 

 

 

 

 

PoW Category (from - to)

The category into which this cost falls, for flow between the From Node and To Node.

Database Value

Description

Treatment

Treatment

Pumping

Pumping

Transport

Transport

Import

Import

Export

Export

Extraction

Extraction

Chlorination

Chlorination

Chem. Treatment

Chem. Treatment

Other

Other

YES

YES

6

16

0

 

usds_pow_cat

Text

 

 

 

 

 

PoW Unit Cost (to - from)

Cost per cubic metre, in user defined currency units, of transferring water between the To Node and From Node.

Prices can be negative to allow for exports or bulk water sale.

YES

YES

6

 

2

WN_VCOST

dsus_pow_cost

 

 

 

 

 

 

PoW Category (to - from)

The category into which this cost falls, for flow between the To Node and From Node.

Database Value

Description

Treatment

Treatment

Pumping

Pumping

Transport

Transport

Import

Import

Export

Export

Extraction

Extraction

Chlorination

Chlorination

Chem. Treatment

Chem. Treatment

Other

Other

YES

YES

6

16

0

 

dsus_pow_cat

Text

 

 

 

 

 

Pipe Status

You can set a time-varying profile for the pipe closed state in the grid. See Closed Pipes for more information

The data in this grid is only used if the Pipe Closed checkbox is un-checked.

Database Table Name: wn_ctl_pipe_status

Show Columns

Help Text

Size, Type and Units

Database Names

Error Limits

Position in Data Structure

Field Name

Help Text

Flag

Size

Units

Database Table

Database Field

Type

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

1

Date Time

Date and time at which the Pipe Closed setting comes into effect

NO

 

 

wn_ctl_pipe_status

ps_date_time

 

 

 

 

 

 

2

Pipe Closed

Check box showing if the pipe is closed or open starting from this date and time

NO

 

 

wn_ctl_pipe_status

ps_closed

Boolean

 

 

 

 

 

YES

YES

7

 

0

 

status

Array

 

 

 

 

 

Pipe Closed

The pipe is permanently closed if the box is checked

YES

YES

7

 

0

 

pipe_closed

Boolean

 

 

 

 

 

Repeat Period

Profile period which will be repeated throughout simulation, if the Repeat Profile box is checked.

Database Value

Description

Help Text

0

1 day

Repeat Period

1

1 week

Repeat Period

2

2 weeks

Repeat Period

YES

YES

7

 

0

 

repeat_status_period

Integer

0

 

 

 

 

Repeat Profile

Check the Repeat Profile box to repeat a profile (from 00:00 for the selected Repeat Period) for the duration of the simulation.

IMPORTANT

When using the Repeat Profile option; if the defined profile spans over the selected Repeat Period, the profile will not be repeated.

YES

YES

7

 

0

 

repeat_status

Boolean

1

 

 

 

 

Maximum Shear Strength

The maximum value for the corrosion layer shear strength on the pipe wall.

The maximum value for which the hydraulic shear strength will result in material being eroded from the pipe wall.

See Water Quality - Turbidity Analysis for further information.

YES YES 8     WN_STRESS wq_max_shear_strength Double          
Initial Shear Strength

The initial value for the corrosion layer shear strength on the pipe wall.

The hydraulic shear strength must rise above this initial value to begin the erosion of material from the pipe wall.

See Water Quality - Turbidity Analysis for further information.

YES YES 8     WN_STRESS wq_init_shear_strength Double          
Erosion Coefficient

Parameter used to calculate the quantity of material eroded from the pipe wall when the hydraulic shear stress exceeds the corrosion layer shear strength; the excess shear.

See Water Quality - Turbidity Analysis for further information.

YES YES 8     WN_RATE wq_erosion_coefficient Double          
Erosion Exponent

The power to which the ratio of excess shear to maximum shear strength is raised when calculating the quantity of material released from the pipe wall.

A value of zero will be interpreted as meaning the erosion is independent of the excess shear.

See Water Quality - Turbidity Analysis for further information.

YES YES 8       wq_erosion_exponent Double          
Release Coefficient

Parameter used to calculate the increase in turbidity as a result of material eroded from the pipe wall.

See Water Quality - Turbidity Analysis for further information.

YES YES 8     WN_TURBLEN wq_release_coefficient Double          

Cost Management

Check the Cost Management box to include the Flow volume constraints for use in a BalanceNet Simulation.

NO

YES

10

 

0

 

optimise

Boolean

 

 

 

 

 

Fire Flow Maximum Velocity For hydrant testing. The maximum allowed velocity for each pipe. NO YES NO                    

Volume (Max)

Note

This field is obsolete and is not displayed in the interface. This data is now entered in the Flow Volume Constraints Grid.

A BalanceNet simulation constraint.

Target maximum volume of water to flow through the pipe over the Period (Max) measured from Period Start (Max) and taking into account Initial Volume (Max).

YES

YES

10

 

 

WN_DVO

opt_MaxFlowVolume

Double

 

 

 

 

 

Period (Max)

Note

This field is obsolete and is not displayed in the interface. This data is now entered in the Flow Volume Constraints Grid.

A BalanceNet simulation constraint.

Length of time over which Volume (Max) is considered.

YES

YES

10

 

 

DUR

opt_MaxFlowVolumePeriod

Long Integer

 

 

 

 

 

Period Start (Max)

Note

This field is obsolete and is not displayed in the interface. This data is now entered in the Flow Volume Constraints Grid.

A BalanceNet simulation constraint.

Start Date / Time of the period for assessing whether Volume (Max) through the pipe has been reached.

Used in conjunction with Initial Volume (Max) if the period start is before the start of the simulation.

YES

YES

10

 

0

 

opt_MaxVolStart_Dtime

Date / Time

 

 

 

 

 

Initial Volume (Max)

Note

This field is obsolete and is not displayed in the interface. This data is now entered in the Flow Volume Constraints Grid.

A BalanceNet simulation constraint.

Volume of water that has already passed through the pipe at the start of the simulation.

Used in conjunction with Period Start (Max).

YES

YES

10

 

1

WN_DVO

opt_MaxVolInit_litre

Double

 

 

 

 

 

Volume (Min)

Note

This field is obsolete and is not displayed in the interface. This data is now entered in the Flow Volume Constraints Grid.

A BalanceNet simulation constraint.

Target minimum volume of water to flow through the pipe over the Period (Min) measured from Period Start (Min) and taking into account Initial Volume (Min).

YES

YES

10

 

 

WN_DVO

opt_MinFlowVolume

Double

 

 

 

 

 

Period (Min)

Note

This field is obsolete and is not displayed in the interface. This data is now entered in the Flow Volume Constraints Grid.

A BalanceNet simulation constraint.

Length of time over which Volume (Min) is considered.

YES

YES

10

 

 

DUR

opt_MinFlowVolumePeriod

Long Integer

 

 

 

 

 

Period Start (Min)

Note

This field is obsolete and is not displayed in the interface. This data is now entered in the Flow Volume Constraints Grid.

A BalanceNet simulation constraint.

Start Date / Time of the period for assessing whether Volume (Min) through the pipe has been reached.

Used in conjunction with Initial Volume (Min) if the period start is before the start of the simulation.

YES

YES

10

 

 

 

opt_MinVolStart_Dtime

Date / Time

 

 

 

 

 

Initial Volume (Min)

Note

This field is obsolete and is not displayed in the interface. This data is now entered in the Flow Volume Constraints Grid.

A BalanceNet simulation constraint.

Volume of water that has already passed through the pipe at the start of the simulation.

Used in conjunction with Period Start (Min).

YES

YES

10

 

1

WN_DVO

opt_MinVolInit_litre

Double

 

 

 

 

 

Flow Volume Constraints

BalanceNet Simulation constraints.

Database Table Name: wn_ctl_balancenet_volume

Show Columns

Help Text

Size, Type and Units

Database Names

Error Limits

Position in Data Structure

Field Name

Help Text

Flag

Size

Units

Database Table

Database Field

Type

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

1

Name

Unique identifier for the constraint.

NO

30

 

wn_ctl_balancenet_volume

name

Text

 

 

 

 

 

2

Time Period

Length of time over which the constraint is considered.

Permitted values are:

  • Day
  • Week
  • Month
  • Year

NO

 

 

wn_ctl_balancenet_volume

time_period

Integer

 

   

 

 

3

Reset Time

Indicates when the constraint is reset (for example every day at 3am).

NO

 

wn_ctl_balancenet_volume

reset_time

Date / Time

 

   

 

 

4

Reset Weekday

Only applies when Time Period is set to Week

Day of the week when the constraint is reset.

NO

 

wn_ctl_balancenet_volume

reset_weekday

Integer

 

   

 

 

5

Reset Day

Only applies to monthly and yearly constraints

Day of the month the constraint is reset.

NO

 

 

wn_ctl_balancenet_volume

reset_day

Integer

 

   

 

 

6

Reset Month

Only applies to yearly constraints

Month in which the constraint is reset.

NO

 

 

wn_ctl_balancenet_volume

reset_month

Integer

 

   

 

 

7

Initial Volume

Initial volume at the beginning of the BalanceNet simulation.

NO

 

WN_DVO

wn_ctl_balancenet_volume

initial_volume

Double

 

 

 

 

 

8

Min / Max

Indicates whether this is a minimum or maximum constraint.

NO     wn_ctl_balancenet_volume min_max Integer          
9

Min / Max Volume

Minimum or maximum volume constraint.

NO   WN_DVO wn_ctl_balancenet_volume min_max_volume Double          

NO

NO

10

 

 

 

wn_ctl_f_balancenet_volume

Array

 

 

 

 

 

Max Flow Rate

A BalanceNet Simulation constraint.

Upper instantaneous limit on flow.

YES

YES

10

 

 

WN_Q

opt_MaxFlowInstant

Double

 

 

 

 

 

Min Flow Rate

A BalanceNet Simulation constraint.

Lower instantaneous limit on flow.

YES

YES

10

 

 

WN_Q

opt_MinFlowInstant

Double

 

 

 

 

 

Notes

You can keep freeform notes about any object in your network. The notes field can be up to 64,000 characters in size, or about 10 pages of printed text.

NO

YES

12

 

0

 

notes

Memo

 

 

 

 

 

From Node ID

Name of the From Node for this pipe. You can select the name from the dropdown list of existing nodes, or type the name of a node you have yet to add to the model.

From and To represent the typical direction of flow for the pipe. Flow will not always be in this direction.

YES

YES

1

30

0

 

us_node_id

Text

 

 

 

 

 

To Node ID

Name of the To Node for this pipe.

From and To represent the typical direction of flow for the pipe. Flow will not always be in this direction.

YES

YES

1

30

0

 

ds_node_id

Text

 

 

 

 

 

Suffix

A suffix added by InfoWorks to ensure that all link Ids are unique

YES

YES

NO

1

0

 

link_suffix

Text

 

 

 

 

 

Asset ID

For reference only. Designed as a reference to an asset database, but could be used for anything.

YES

YES

1

30

 

 

asset_id

Text

 

 

 

 

 

PoW

Read only field that indicates if Price of Water data has been entered on the property sheet

NO

YES

NO

 

0

 

pow_selected

Boolean

 

 

 

 

 

Pipe Break
Break Enabled BreakEnabled Boolean Select the box to enable pipe break
Break Type BreakType Choice Leak, Rupture, Flow
Break Flow Type break_flow_type Text

Fixed, Pressure Related

Note: Applicable for Break Type set to Flow.

Break Flow BreakFlow Double WN_Q
Break Diameter BreakDiameter Double PS
Break Split Pipe Distance BreakSplitPipeDistance Double L (m from From Node to To Node)
Break Whole Simulation BreakWholeSimulation Boolean (override any set times to whole run)
Break Start BreakStartTime Date / Time Start date and time of the pipe break
Break End BreakEndTime Date / Time End date and time of the pipe break

The Pipe Break Controls are also applicable to Meters.

                         
                         

Pipe Results

All results fields are displayed on the grid when opened while viewing a replay of a simulation, and on a special results page placed at the front of Property Sheets displayed while viewing a simulation replay.

For details of results fields for links, see the Link Results Data Fields topic.


Pipe

Network Data Fields

Common Data Fields

Alternative Demand Data Fields

Link Results Data Fields