Manhole Survey Data Fields (Distribution)

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

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

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

Common Data Fields

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

Manhole Survey Data

Database Table Name: wams_manhole_survey

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

Survey 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

 

 

 

 

 

Manhole ID

The identifier of the manhole surveyed.

manhole_id

Text

40

 

0

 

 

 

 

 

Manhole type

The type of manhole surveyed:

Database Value

Description

MB

Meter Box

HB

Hydrant Box

VB

Valve Box

C

Chamber

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

type

Text

32

 

0

 

 

 

 

 

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

Surveyor

Name of surveyor or contractor that carried out survey work.

surveyor

Text

20

 

0

 

 

 

 

 

Survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

 

 

0

 

 

 

 

 

Used in network

Check box indicating whether survey has been used to update the network.

used_in_network

Boolean

 

 

0

 

 

 

 

 

Elevation

Elevation above datum level (usually sea level).

elevation

Double

 

Z

0

 

 

 

 

 

X Coord

X coordinate of the manhole surveyed.

x

Double

 

XY

2

 

 

 

 

 

Y Coord

Y coordinate of the manhole surveyed.

y

Double

 

XY

2

 

 

 

 

 

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

 

 

 

 

 

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

 

 

 

 

 

Chamber construction

Database Value

Description

B

Brick

C

Concrete

CR

Concrete Rings

CS

Concrete Segments

M

Masonry

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

chamber_construction

Text

32

 

0

 

 

 

 

 

Number of steps

Number of steps installed in manhole.

num_steps

Integer

 

 

0

 

 

 

 

 

Number of ladders

Number of ladders installed in manhole.

num_ladders

Integer

 

 

0

 

 

 

 

 

Number of landings

Number of landings installed in manhole.

num_landings

Integer

 

 

0

 

 

 

 

 

Confined spaces classification

Code or description indicating severity of risks associated with carrying out work at the asset due to confined spaces.

confined_spaces

Text

32

 

0

 

 

 

 

 

Cover shape

Database Value

Description

S

Square

R

Rectangular

T

Triangular

D

Double Triangle

C

Circular

O

Oval

L

Clover Leaf

U

Unspecified

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

cover_shape

Text

32

 

0

 

 

 

 

 

Cover duty

Database Value

Description

L

Light

M

Medium

H

Heavy

S

Super Heavy

HYD

Hydraulic

U

Unknown

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

cover_duty

Text

32

 

0

 

 

 

 

 

Cover level

Height above datum of manhole cover.

cover_level

Double

 

Z

0

 

 

 

 

 

Cover dimension

Dimension of manhole cover.

cover_dim

Double

 

MANH_DIM

0

 

 

 

 

 

Cover dimension 2

Dimension of manhole cover.

cover_dim_2

Double

 

MANH_DIM

0

 

 

 

 

 

Cover hinged

Check box indicating whether the manhole cover is hinged.

cover_hinged

Boolean

 

 

0

 

 

 

 

 

Cover locked

Check box indicating whether the manhole cover is locked.

cover_locked

Boolean

 

 

0

 

 

 

 

 

Side entry

Check box indicating whether the manhole is a side entry manhole.

side_entry

Boolean

 

 

0

 

 

 

 

 

Shaft depth

Depth of manhole shaft.

shaft_depth

Double

 

MANH_Y

0

 

 

 

 

 

Shaft dimension

Dimension of manhole shaft.

shaft_dim

Double

 

MANH_DIM

0

 

 

 

 

 

Shaft dimension 2

Dimension of manhole shaft.

shaft_dim_2

Double

 

MANH_DIM

0

 

 

 

 

 

Chamber floor depth from cover

Distance between chamber floor and manhole cover level.

chamber_floor_depth

Double

 

MANH_Y

0

 

 

 

 

 

Chamber dimension

Dimension of manhole chamber.

chamber_dim

Double

 

MANH_DIM

0

 

 

 

 

 

Chamber dimension 2

Dimension of manhole chamber.

chamber_dim_2

Double

 

MANH_DIM

0

 

 

 

 

 

Accessibility

Details of manhole location accessibility.

accessibility

Text

40

 

0

 

 

 

 

 

Access restrictions

Database Value

Description

NOTIFY

Private-Notification Required

PRIVATE

Private-No Notification Required

PUBLIC

Public Property

CLIENT

Client Property

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

restrictions

Text

40

 

0

 

 

 

 

 

Parking distance

Vehicle parking distance from manhole location.

parking_distance

Double

 

XY

0

 

 

 

 

 

Keys required

Check box indicating whether keys are required to access site.

keys_required

Boolean

 

 

0

 

 

 

 

 

Work order required

Check box indicating whether works order is required to access site.

works_order_required

Boolean

 

 

0

 

 

 

 

 

Attend to chamber

Check box indicating whether manhole chamber requires repair.

attend_to_chamber

Boolean

 

 

0

 

 

 

 

 

Attend to other

Check box indicating whether repair is required to area not already specified.

attend_to_other

Boolean

 

 

0

 

 

 

 

 

Attend to step

Check box indicating whether manhole steps require repair.

attend_to_step

Boolean

 

 

0

 

 

 

 

 

Attend to cover

Check box indicating whether manhole cover requires repair.

attend_to_cover

Boolean

 

 

0

 

 

 

 

 

Attend to shaft

Check box indicating whether manhole shaft requires repair.

attend_to_shaft

Boolean

 

 

0

 

 

 

 

 

Sediment depth

Depth of sediment in chamber.

sediment_depth

Double

 

MANH_Y

0

 

 

 

 

 

Condition grade

A measure of the condition of surveyed asset.

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

 

 

 

 

 

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

 

 

 

 

 

Chamber flooded

Check box indicating whether manhole chamber was flooded at time of survey.

chamber_flooded

Boolean

 

 

0

 

 

 

 

 

Chamber collapsed

Check box indicating whether manhole chamber has collapsed.

chamber_collapsed

Boolean

 

 

0

 

 

 

 

 

Toxic atmosphere

Check box indicating whether a hazardous atmosphere was detected at the time of the survey.

toxic_atmosphere

Boolean

 

 

0

 

 

 

 

 

Vandalism

Check box indicating whether manhole has been subject to vandalism.

vandalism

Boolean

 

 

0

 

 

 

 

 

Pipework leaking

Check box indicating whether a leak was detected at the time of the survey.

pipework_leaking

Boolean

 

 

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 Array                
General properties fields See Common Data Fields for details of the fields 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.                    

Creating a Manhole Survey

Survey Grid

Network Data Fields

Common Data Fields