Pipe Sample Data Fields

Information relating to a Pipe Sample can be viewed and edited on the Pipe Sample Grid Window of the Survey Grid or the Pipe Sample Property Sheet.

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

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

Common Data Fields

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

Tip

The Data Fields currently used in InfoAsset Manager are based on the procedures for inspecting pipes on site described in the WRc Water Mains Rehabilitation Manual - Assessing the Condition of Cast Iron Pipes.

Pipe Sample Data

Database Table Name: wams_pipe_sample

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

 

 

 

 

 

Date sampled

Date that sample was taken.

date

Date / Time

 

 

0

 

 

 

 

 

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

Job number

Job reference number.

job_number

Text

15

 

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

40

 

0

 

 

 

 

 

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

40

 

0

 

 

 

 

 

Surface material

A description of the type of material in close proximity to the sampled pipe:

Database Value

Description

SOIL

Soil

CLAY

Clayey Soil

HCLAY

Heavy Clay

SAND

Sand or Gravel

FILL

Make Up Fill

HROCK

Hard Rock

SROCK

Soft Rock

OTHER

Other

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

surface_material

Text

40

 

0

 

 

 

 

 

Traffic disruption

Assessment of disruption to traffic during mains repair / inspection:

Database Value

Description

NONE

None

SLIGHT

Slight

BAD

Bad

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

traffic_disruption

Text

40

 

0

 

 

 

 

 

Start length

Location along pipe where sample starts, relative to start node of pipe.

Default is 0.000

start_length

Double

 

L

3

 

 

 

 

 

Sample length

Length of sample.

Default is associated Pipe Length - Sample Start length.

sample_length

Double

 

L

3

 

 

 

 

 

Supply cut off period

Length of time that supply was cut off due to repair / inspection work.

supply_cut_off_period

Double

 

TS

0

 

 

 

 

 

Pipe ID

ID of pipe from which sample was taken.

pipe_id

Text

40

 

0

 

 

 

 

 

Diameter

Diameter of sampled pipe as measured on site.

diameter

Double

 

CAMS_PS

0

 

 

 

 

 

Depth of cover

Depth to top of sampled pipe from ground level.

depth_of_cover

Double

 

Y

0

 

 

 

 

 

Pipe material

Material from which sampled pipe is constructed:

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.

pipe_material

Text

40

 

0

 

 

 

 

 

Joint type

Description of type of joint connecting pipe segments:

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

40

 

0

 

 

 

 

 

Bedding

Description of bedding material surrounding sampled pipe:

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

Text

40

 

0

 

 

 

 

 

External protection

Description of type of external protection observed on sampled pipe:

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

40

 

0

 

 

 

 

 

Internal protection

Description of type of internal protection observed on sampled pipe:

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.

internal_protection

Text

40

 

0

 

 

 

 

 

Failure type

Description of type of failure observed on sampled pipe:

Database Value

Description

CIRC

Circular Fracture

LONG

Long Fracture

S_HOLE

Small Hole

L_HOLE

Large Hole

JOINT

Pipe Joint

REPAIR

Joint (Previous repair)

TAPPING

Tapping Point

OTHER

Other

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

failure_type

Text

40

 

0

 

 

 

 

 

Failure location

Description of the part of the sampled pipe that the failure occurred on:

Database Value

Description

PIPE

Pipe

BEND

Bend

TEE

Tee

OTHER

Other

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

failure_location

Text

40

 

0

 

 

 

 

 

Failure position

Description of the position of the failure at the Failure location:

Database Value

Description

CROWN

Crown

INVERT

Invert

SIDE

Side

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

failure_position

Text

40

 

0

 

 

 

 

 

Leakage rate

Rate of leakage due to pipe failure.

leakage_rate

Double

 

IN_Q

0

 

 

 

 

 

External protection status

Assessment of how much of the external surface of the pipe sample has intact protection:

Database Value

Description

WHOLE

Whole surface

MOST

Most of the surface

SOME

Some of the surface

NONE

None of the surface

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

external_protection_status

Text

40

 

0

 

 

 

 

 

Encrustation

Assessment of how much of the external surface of the pipe sample has a build-up of encrustation:

Database Value

Description

WHOLE

Whole surface

MOST

Most of the surface

SOME

Some of the surface

NONE

None of the surface

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

encrustation

Text

40

 

0

 

 

 

 

 

Pitting

Assessment of how much of the external surface of the pipe sample is pitted (carried out after encrustation has been removed):

Database Value

Description

WHOLE

Whole surface

MOST

Most of the surface

SOME

Some of the surface

NONE

None of the surface

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

pitting

Text

40

 

0

 

 

 

 

 

Graphitisation

Assessment of the nature of graphitisation on the external surface of the pipe sample:

Database Value

Description

NONE

None Visible

VIS

Visible

CRAZE

Crazed

SOFT

Soft

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

graphitisation

Text

40

 

0

 

 

 

 

 

Casting defects

Assessment of presence of casting features on the external surface of the pipe sample:

Database Value

Description

BLOW

Blowholes

MOULD

Moulding Marks

UNEVEN

Uneven Casting

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

casting_defects

Text

40

 

0

 

 

 

 

 

Max pit depth

Maximum pit depth on external surface of pipe sample after encrustation has been removed.

max_pit_depth

Double

 

CAMS_PS

0

 

 

 

 

 

External diameter

Outside Diameter of the pipe sample.

external_diameter

Double

 

CAMS_PS

0

 

 

 

 

 

Comments (Ext Inspection)

Any other comments or observations from inspection of external surface of pipe sample.

ext_comments

Text

100

 

0

 

 

 

 

 

Internal protection status

Assessment of how much of the internal surface of the pipe sample has intact protection:

Database Value

Description

WHOLE

Whole surface

MOST

Most of the surface

SOME

Some of the surface

NONE

None of the surface

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

internal_protection_status

Text

40

 

0

 

 

 

 

 

Tuberculation

Assessment of how much of the internal surface of the pipe sample is covered with tuberculation:

Database Value

Description

WHOLE

Whole surface

MOST

Most of the surface

SOME

Some of the surface

NONE

None of the surface

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

tuberculation

Text

40

 

0

 

 

 

 

 

Tuberculation removal

Assessment of the ease with which tuberculation is dislodged from the pipe:

Database Value

Description

EASY

Easy

HARD

Hard

IMP

Impossible

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

tuberculation_removal

Text

40

 

0

 

 

 

 

 

Max tuberculation height

Estimate of the maximum height of tuberculation.

max_tuberculation_height

Double

 

CAMS_PS

0

 

 

 

 

 

Remaining clear bore

Estimate of the maximum pipe size (outside diameter) that can be passed through the tuberculated bore.

remaining_clear_bore

Double

 

CAMS_PS

0

 

 

 

 

 

Comments (Int. Inspection)

Any other comments or observations from inspection of internal surface of pipe sample.

int_comments

Text

100

 

0

 

 

 

 

 

Max wall thickness

Largest measurement of wall thickness at cut edges of sample.

max_wall_thickness

Double

 

CAMS_PS

0

 

 

 

 

 

Min wall thickness

Smallest measurement of wall thickness at cut edges of sample.

min_wall_thickness

Double

 

CAMS_PS

0

 

 

 

 

 

Graphitisation/Pits

Assessment of the presence of graphitisation at cut edges of sample:

Database Value

Description

NONE

None

EXT

Some External

INT

Some Internal

FULL

Full Wall Graph

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

graphitisation_pits

Text

40

 

0

 

 

 

 

 

Graphitisation status

Assessment of the nature of graphitisation at cut edges of sample:

Database Value

Description

HARD

Hard

ADH

Adherent

SOFT

Soft

DET

Easily Detached

CRAZE

Crazed

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

graphitisation_status

Text

100

 

0

 

 

 

 

 

Max int pit depth (Cut edge)

Maximum depth of graphitisation (or pit depth if graphitisation is dislodged) on internal surface of pipe at cut edges of sample.

max_ext_cut_edge_pit_depth

Double

 

CAMS_PS

0

 

 

 

 

 

Max ext pit depth (Cut edge)

Maximum depth of graphitisation (or pit depth if graphitisation is dislodged) on external surface of pipe at cut edges of sample.

max_int_cut_edge_pit_depth

Double

 

CAMS_PS

0

 

 

 

 

 
Scheduled Task fields See Common Data Fields - Scheduled Task fields for details of all fields in the Schedule Info, Progress Info and Resources sections of the property sheet.                    
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 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.                    

Survey Grid

Creating a Pipe Sample

Network Data Fields

Common Data Fields