Pipe (Distribution) Data Fields

Pipe data can be edited on either the Pipe Grid Window of the Asset Grid or the Pipe Property Sheet.

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

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

Common Data Fields

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

Pipe Data

Database Table Name: wams_pipe

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

 

 

 

 

 

Asset ID

An optional reference - usually the asset database name for this network object (if applicable).

asset_id

Text

40

 

0

 

 

 

 

 

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

Area code

The zone ID in which the asset is contained (DA, WSZ, WOA, PMA).

area_code

Text

40

 

0

 

 

 

 

 

Operational status

The current functionality of the asset:

Database Value

Description

AB

Abandoned

STANDBY

Standby

INUSE

In Use

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

operational_status

Text

20

 

0

 

 

 

 

 

Planning status

The current situation of the asset in relation to construction.

planning_status

Text

20

 

0

 

 

 

 

 

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

Start node ID

Upstream node.

us_node_id

Text

40

 

0

 

 

 

 

 

End node ID

Downstream node.

ds_node_id

Text

40

 

0

 

 

 

 

 
Pipe class

Code indicating pipe specification details, such as material, pressure rating, wall thickness etc.

Used by Lifetime Estimator to calculate expected lifetime and likelihood of failure.

Default choices:

Database Value

Description
Class 1 Class 1
Class 2 Class 2

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

 pipe_class Text 64   0          

Type

The type of pipe:

Database Value

Description

PUMP

Pumped

RIS

Rising

PUMPGRAV

Pumped Gravity

GRAV

Gravity

AQUA

Aquaduct

TUNN

Tunnel

UNKNOWN

Unknown

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

type

Text

10

 

0

 

 

 

 

 

Manufacturer

The name of the company who fabricated the asset.

manufacturer

Text

20

 

0

 

 

 

 

 

Use

Database Value

Description

TRUNK

Trunk Main

DIST

Distribution Main

RAW

Raw Water Main

SERV

Service Pipe

COMM

Communication Pipe

SUPPLY

Supply Pipe

FIRE

Fire Main

SCOUR

Scour Main

BYPASS

Bypass

STORAGE

Storage

TRANS

Transmission Main

BRIDGE

Pipe Bridge

UNKNOWN

Unknown

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

use

Text

10

 

0

 

 

 

 

 

Joint type

Database Value

Description

LEAD

Lead

FLANGE

Flanged

PUSH

Rubber Push

BOLT

Rubber Bolt

GLAND

Screwed Gland

SOLVENT

Solvent Welded

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

joint_type

Text

10

 

0

 

 

 

 

 

Length

Pipe length.

length

Double

 

L

3

 

 

 

 

 

Internal diameter

Actual diameter measured between internal walls of pipe.

internal_diameter

Double

 

CAMS_PS

3

 

 

 

 

 

External diameter

Actual diameter measured between outside walls of pipe.

external_diameter

Double

 

CAMS_PS

3

 

 

 

 

 

Nominal diameter

Standard nominal pipe size.

nominal_diameter

Double

 

CAMS_PS

3

 

 

 

 

 

Pressure rating

Maximum design working pressure of pipe.

pressure_rating

Double

 

WN_P

0

 

 

 

 

 

Friction factor

Pipe roughness coefficient.

friction_factor

Double

 

 

3

 

 

 

 

 

Min velocity

Minimum velocity experienced in pipe under normal operating conditions.

min_velocity

Double

 

V

3

 

 

 

 

 

Max velocity

Maximum velocity experienced in pipe under normal operating conditions.

max_velocity

Double

 

V

3

 

 

 

 

 

Leakage

Rate of flow of unaccounted for water.

leakage

Double

 

IN_Q

3

 

 

 

 

 

Capacity

Capacity of the pipe flowing full.

capacity

Double

 

VO

0

 

 

 

 

 

Flow reversals

Information regarding change of direction of flow in pipe under normal operating conditions.

flow_reversals

Text

10

 

0

 

 

 

 

 

Cumulative sediment status

Information on the cumulative process in the pipe with regards to sedimentation. For example: deposition, suspension, re-suspension.

cum_sediment

Text

10

 

0

 

 

 

 

 

Depth of cover

Distance between crown of pipe and ground level.

depth_of_cover

Double

 

MANH_Y

0

 

 

 

 

 

Material

Database Value

Description

ALK

Alkathene

ASB

Asbestose Cement

CI

Cast Iron

CONC

Concrete

DI

Ductile Iron

HDPE

High Density Polyethylene

STEEL

Steel

SI

Spun Iron

GI

Galvanised Iron

MDPE

Medium Density Polyethylene

PE

Polyethylene

PP

Polypropylene

PVC

Poly Vinyl Chloride

UPVC

U Poly Vinyl Chloride

LEAD

Lead

CU

Copper

WOOD

Wood

UNKNOWN

Unknown

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

material

Text

10

 

0

 

 

 

 

 

Lining material

Database Value

Description

BIT

Bitumen

TAR

Tar

CEMENT

Cement Mortar

EPOXY

Epoxy Resin

PLASTIC

Plastic

NONE

None

UNKNOWN

Unknown

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

lining_material

Text

10

 

0

 

 

 

 

 

Lining type

Database Value

Description

STRUC

Structural

NONSTRUCT

Non-Structural

SWAGE

Swage

ROLL

Rolldown

CURED

Cured in Situ

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

lining_type

Text

10

 

0

 

 

 

 

 

Date lined

Date at which lining of the asset was carried out.

date_lined

Date / Time

 

 

0

 

 

 

 

 

External protection

Database Value

Description

POLY

Polythene Sleeve

CATH

Cathodic

ZINC

Zinc Coated

ZINCPOLY

Zinc Poly Sleeve

NONE

None

CEMENT

Cement/Mortar

EPOXY

Epoxy Resin

BITU

Bitumen/Tar

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

external_protection

Text

10

 

0

 

 

 

 

 

External protection date

Date at which external protection was applied.

external_protection_date

Date / Time

 

 

0

 

 

 

 

 

Bedding material

Database Value

Description

SAND

Sand

CONC

Concrete

GRAN

Granular

NONE

None

UNKNOWN

Unknown

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

bedding_material

Text

10

 

0

 

 

 

 

 

Rehabilitation method

Database Value

Description

FLUSH

Flush

SWAB

Swab

SCOUR

Air Scour

PPIG

Poly Pigging

RACLEUR

Racleur

JET

High Pressure Jetting

DOWNSIZE

Downsizing

UPSIZE

Upsizing

REPLACE

Replace

NEW

New

AB

Abandon

CLEAN

Clean

UNKNOWN

Unknown

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

rehab_method

Text

10

 

0

 

 

 

 

 

Construction method

Database Value

Description

BURST

Pipe Bursting

SLIP

Slip Lining

SWAGE

Swage Lining

ROLLDOWN

Rolldown

PALTERN

Paltem

THERMO

Thermopipe

OPEN

Open Cut

TRENCH

Narrow Trench

MOLE

Mole Ploughing

DRILL

Guided Drilling

RAM

Pipe Ramming

ROB

Rod Pushing

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

construction_method

Text

10

 

0

 

 

 

 

 

Condition grade

A measure of asset condition.

condition_grade

Long Integer

 

 

0

 

 

 

 

 

Critical

A measure of the likely impact of asset failure.

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

 

 

 

 

 

Condition survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

 

 

0

 

 

 

 

 

GPS survey date

The date of the most recent GPS survey (DD/MM/YYYY).

gps_survey_date

Date / Time

 

 

0

 

 

 

 

 

Date installed

The date when the asset was installed (DD/MM/YYYY). Used in costing reports in conjunction with the cost index.

date_installed

Date / Time

 

 

0

 

 

 

 

 

Date cleaned

The date the asset last underwent maintenance to improve performance (swabbing, scouring).

date_cleaned

Date / Time

 

 

0

 

 

 

 

 

Date renewed

The date the asset was last restored to its initial condition (replaced, relined).

date_renewed

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

0

 

 

 

 

 

Inspection cost

Estimated cost of asset inspection.

inspection_cost

Double

 

WN_COST

0

 

 

 

 

 

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

0

 

 

 

 

 

Replacement cost

The estimated cost for completely replacing an asset

replace_cost

Double

 

WN_COST

0

 

 

 

 

 

Current value

Current value of the asset. This gives an indication of depreciation costs as depreciation cost = installation cost - current value.

current_value

Double

 

WN_COST

2

 

 

 

 

 

Soil type

A description of the material surrounding the asset that could influence condition grading and rehabilitation methods:

Database Value

Description

PEAT

Peat

CHALK

Chalk

CLAY

Clay

SHALE

Shale

SAND

Sand

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

soil_type

Text

10

 

0

 

 

 

 

 

Surface type

A description of the ground use in close proximity to the asset that may influence access/costs for monitoring, maintenance or construction purposes.

Database Value

Description

Road

Road

Pavement

Pavement

Field

Field

Unpaved

Unpaved

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

surface_type

Text

10

 

0

 

 

 

 

 
Access restrictions

Restrictions in gaining access to land in which pipe is located.

Used when Calculating Consequence Scores.

Database Value

Description
Private land Private land
Limited access Limited access

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

 access_restrictions Text 64   0          
Traffic level An indication of the volume of traffic on routes located near this pipe. traffic_level Double     3          
Traffic divertable

Check this option to indicate that it is possible to divert any traffic on routes located near this pipe.

 traffic_divertable Boolean     0          
Under building

Check this option to indicate that pipe runs under a building.

Used when Calculating Consequence Scores.

 under_building Boolean     0          
Disruption risk

Risk associated with service interruption to rail, road, business, emergency services etc. in the event of pipe failure.

Score of 1-5, where 1 is low risk and 5 is high risk.

Used when Calculating Consequence Scores.

 rail_business_disruption_risk Double     3          
Criticality score

Risk associated with service interruption to customers.

Score of 1-5, where 1 is low risk and 5 is high risk.

May be calculated by the consequence calculation tool.

 criticality_score Double     3          
Consequence comments Additional comments regarding risk factors and scores. consequence_comments Text 255   0          
Consequence score

Overall consequence rating.

May be calculated by the consequence calculation tool.

 consequence_score Double     3          
Likelihood score

Score indicating the likelihood of failure of the pipe.

May be calculated by the Lifetime Estimator tool.

 likelihood_score Double     3          
Risk score

Overall risk of structural failure rating.

May be calculated by the Risk Assessment tool.

 risk_score Double     3          

Points

An array of X/Y values giving the geometry of a line feature.

point_array

Array

 

XY

0

 

 

 

 

 

Headloss

The maximum loss in pressure, caused by the asset, across its entire length (usually at peak flow).

headloss

Double

 

HEAD

2

 

0

 

 

 
Lateral nodes Click the button to display the Lateral Nodes editor, used to view lateral nodes on the pipe.                    
Name groups Click the button to display the Name Groups Editor, used to view and edit the Asset Name Groups to which the object belongs.                    
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                  
General properties data fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties data 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 pipe.

 tsdb_links                  

Asset Grid