Basic Pipe Data Fields

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

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

Further information, including units details, about all the Network Object fields stored in the 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. Control Notes Page
11. Notes Page - see Common Data Fields topic for details of notes fields

Note: Use the scroll bar at the bottom of the table to view its entire content.

Basic Pipe Data

Database Table Name: wn_pipe

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. 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

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, Live Data Feed, or Live Data Composite Feed. Note: Duplicate IDs are shown once.	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 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. Note: 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
Fire Flow Maximum Velocity	For hydrant testing. The maximum allowed velocity for each pipe.	NO	YES	NO
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.