Manhole Data Fields

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

Manhole type

The type of ancillary structure:

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

Current status:

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

Elevation

Elevation above datum level (Usually sea level).

elevation

Double

Z

0

X coord

X coordinate of the object.

x

Double

XY

2

Y coord

Y coordinate of the object.

y

Double

XY

0

Chamber construction

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

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

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

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

Condition grade

A measure of asset condition for ancillary assets. By analogy with pipe condition grades, this is usually a number in the range 1-5. Unlike pipe condition grade, there is no distinction between structural and service condition for ancillary assets.

condition_grade

Long Integer

0

Critical

A measure of the likely impact of asset failure. The WRC SRM uses the codes A, B, C to represent "A" sewers where failures would be expensive to "C" where failures would be relatively cheap.

criticality

Text

5

0

Security

The security of the asset from unauthorised access/tampering:

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

security

Text

10

0

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:

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:

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

surface_type

Text

10

0

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.

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