Manhole Survey Data Fields (Collection)

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.

The diagram below illustrates how the InfoAsset Manager Manhole Survey Dimensions fields relate to a manhole cross-section.

Manhole Standard

If you are using the EU manhole standard, you can choose to have a streamlined version of the manhole survey Property Window containing only the fields relevant to this standard (Refer to Standards and Choice Lists Dialog topic for further details). In this case, please note that the layout of some tabs (mainly Cover, Interior and Condition) may not contain all the fields described below and that some other tabs such as Cover 2 and Interior 2 may not exist.

Manhole Survey Data

Database Table Name: cams_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

ID

Unique identifier for the survey.

When using MACP Coding Standard, corresponds to MACP Manhole_Number field.

id

Text

40

 

0

 

 

 

 

 

Node ID

Node to which survey is associated.

node_id

Text

40

 

0

 

 

 

 

 

Node reference

Reference name of node.

node_ref

Text

32

 

0

 

 

 

 

 

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

Used in network

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

used_in_network

Boolean

 

 

0

 

 

 

 

 

Survey date

Date of the most recent condition survey of the asset.

When using MACP Coding Standard, corresponds to MACP Date field.

survey_date

Date / Time

 

 

0

 

 

 

 

 

Current

Shows which surveys have been used to update the network to its current state. On update of the network from manhole surveys, the most recent survey for a manhole will be used. The Current field of the most recent survey will be checked. The Current field of earlier surveys previously used to update the network will be unchecked.

current

Boolean

 

 

0

 

 

 

 

 

Incoming pipes

Incoming links connected to manhole surveyed.

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Database Table Name: cams_pipe_survey

Position in Data Structure

Field Name

Help Text

Database Field

Data Type

Size

Units

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Lower Limit

1

Node reference

Upstream node reference for incoming link

downstream node reference for outgoing link

node_ref

Text

32

 

 

0

 

 

 

2

Depth from cover

Distance between cover level and pipe invert level.

depth_from_cover

Double

 

Y

 

 

 

 

 

3

Shape

Shape of incoming/outgoing link:

Database Value

Description

A

Arch

B

Barrel

C

Circular

E

Egg

H

Horseshoe

K

Kerb Block

O

Oval

R

Rectangular

S

Square

T

Trapezoidal

U

U-Shaped with Flat Top

Z

Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

shape

Text

10

 

 

0

 

 

 

4

Width

Link dimension.

width

Double

 

CAMS_PS

 

 

 

 

 

5

Height

Link dimension.

height

Double

 

CAMS_PS

 

 

 

 

 

6

Material

Database Value

Description

AC

Asbestos Cement

AK

Alkathene

BL

Bitumen (Lining)

BR

Brick

CC

Concrete Box Culvert

CI

Cast Iron

CL

Cement Mortar (Lining)

CO

Concrete

CSB

Concrete Segments Bolted

CSU

Concrete Segments Unbolted

DI

Ductile Iron

EP

Epoxy

FC

Fibre Cement

FRP

Fibre Reinforced Plastics

GI

Grey Cast Iron

GRC

Glass Reinforced Concrete

GRP

Glass Reinforced Plastic

MAC

Masonry, Coursed

MAR

Masonry, Random

PE

Polyethylene

PF

Pitch Fibre

PP

Polypropylene

PS

Polyester

PSC

Plastic/Steel Composite

PVC

Polyvinyl Chloride

RC

Reinforced Concrete

RPM

Reinforced Plastic Matrix

SI

Spun Iron

SPC

Sprayed Concrete

ST

Steel

U

Unspecified

VC

Vitrified Clay

X

Unidentified Material

XI

Unidentified Type of Iron/Steel

XP

Unidentified type of Plastics

Z

Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

pipe_material

Text

64

 

 

0

 

 

 

7

Lining material

Database Value

Description

AC

Asbestos Cement

AK

Alkathene

BL

Bitumen (Lining)

BR

Brick

CC

Concrete Box Culvert

CI

Cast Iron

CL

Cement Mortar (Lining)

CO

Concrete

CSB

Concrete Segments Bolted

CSU

Concrete Segments Unbolted

DI

Ductile Iron

EP

Epoxy

FC

Fibre Cement

FRP

Fibre Reinforced Plastics

GI

Grey Cast Iron

GRC

Glass Reinforced Concrete

GRP

Glass Reinforced Plastic

MAC

Masonry, Coursed

MAR

Masonry, Random

PE

Polyethylene

PF

Pitch Fibre

PP

Polypropylene

PS

Polyester

PSC

Plastic/Steel Composite

PVC

Polyvinyl Chloride

RC

Reinforced Concrete

RPM

Reinforced Plastic Matrix

SI

Spun Iron

SPC

Sprayed Concrete

ST

Steel

U

Unspecified

VC

Vitrified Clay

X

Unidentified Material

XI

Unidentified Type of Iron/Steel

XP

Unidentified type of Plastics

Z

Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

lining_material

Text

10

 

 

0

 

 

 

8

Backdrop diameter

Diameter of backdrop pipe.

backdrop_diam

Double

 

CAMS_PS

 

 

 

 

 

9

Criticality

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

 

 

 

10

Condition code

Indication of asset condition.

condition_code

Text

5

 

 

0

 

 

 

11

Direction

Direction of pipe from manhole.

direction

Text

10

 

 

 

 

 

 

12

Rim to invert

Distance from rim to invert of manhole.

rim_to_invert

Double

 

MANH_DIM

 

 

 

 

 

13

Seal condition

Indication of seal condition.

seal_condition

Text

40

 

 

 

 

 

 

14

Special condition

 

special_condition

Text

40

 

 

 

 

 

 

15

Pipe line ref

 

pipe_line_reference

Text

40

 

 

 

 

 

 

16

Remarks

Any additional notes.

remarks

Text

255

 

 

 

 

 

 
17 Link type

Type of incoming/outgoing link:

Database Value

Description
cams_pipe Pipe
cams_connection_pipe Connection pipe
cams_ancillary User ancillary
cams_channel Channel
cams_flume Flume
cams_orifice Orifice
cams_pump Pump
cams_screen Screen
cams_siphon Siphon
cams_valve Valve
cams_vortex Vortex
cams_weir Weir

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

 link_type Text 32            

pipes_in

Array

 

 

0

 

 

 

0

0

Outgoing pipes

Outgoing links connected to manhole surveyed.

See Incoming pipes for details.

pipes_out

Array

 

 

0

 

 

 

 

 

Drainage code

Drainage code.

drainage_code

Text

10

 

0

 

 

 

 

 

Drainage area

MACP Coding Standard field

Drainage area name.

drainage_area

Text

15

 

0

 

0

0

0

0

X coordinate

X coordinate.

When using MACP Coding Standard, corresponds to MACP Easting field.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate.

When using MACP Coding Standard, corresponds to MACP Northing field.

y

Double

 

XY

2

 

 

 

 

 

Type

Database Value

Description

M

Manhole

J

Junction (Saddle)

L

Lamphole

H

Hatchbox

R

Rodding Eye

F

Outfall

V

Storm Overflow

P

Pumping Station

S

Soakaway

D

Dual Function

W

Treatment Works

G

Ghost (Bend)

Z

Ghost (Rising Main)

C

Cascade

Y

Gulley

E

Ejector

O

Oil Interceptor

I

Inlet

B

Hydrobrake

T

Vent Column

U

Unspecified

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

node_type

Text

10

 

0

 

 

 

 

 

Status

The current status of the manhole being surveyed:

Database Value

Description

PU

Public

PR

Private

24

Section 24

HD

Highway Drain

WC

Watercourse

TR

Trunk

17

Section 17

18

Section 18

AB

Abandoned

TC

To Be Constructed

HC

Housing Committee

U

Unspecified

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

status

Text

10

 

1

 

 

 

 

 

System type

When using MACP Coding Standard, corresponds to MACP MH_Use field.

Database Value

Description

F

Foul

S

Surface

C

Combined

T

Transition

O

Overflow

U

Unspecified

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

system_type

Text

10

 

0

 

 

 

 

 

Date installed

Date of installation.

When using MACP Coding Standard, corresponds to MACP Year_Built field.

year_laid

Date / Time

 

 

1

 

 

 

 

 

Year renewed

MACP Coding Standard field

Year sewer was last renewed.

year_renewed

Long Integer

 

 

0

 

0

0

0

0

Ground level

Height above datum of ground surface.

ground_level

Double

 

Z

3

 

 

 

-99.99

999.99

Street

MACP Coding Standard field

Manhole location.

street

Text

64

 

0

 

0

0

0

0

City

MACP Coding Standard field

Location of sewer.

city

Text

64

 

0

 

0

0

0

0

Location code

MACP Coding Standard field

Describes ground cover.

location_code

Text

30

 

0

 

0

0

0

0

Location details

MACP Coding Standard field

Manhole location description

location_details

Text

255

 

0

 

0

0

0

0

Coordinate system

MACP Coding Standard field

Datum or reference system used for GPS coordinates.

coordinate_system

Text

50

 

0

 

0

0

0

0

Vertical datum

MACP Coding Standard field

A specific geodetic system used for the GPS vertical or Z coordinate.

If specified, then Cover level must also be specified.

vertical_datum

Text

50

 

0

 

0

0

0

0

GPS accuracy

MACP Coding Standard field

Degree of accuracy of GPS survey:

Database Value

Description
N Nearest meter
M Sub-meter
L Survey Level

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

gps_accuracy

Text

50

 

0

 

0

0

0

0

Access type

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

access_type

Text

50

 

0

 

0

0

0

0
Road material

The type of material that the road is constructed from.

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

 road_material Text 64   0          
Circumferential reference point

EU2011 Coding Standard field

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

 circumferential_reference_point Text 20   0          

Surveyed by

MACP Coding Standard field

Name of surveyor.

surveyed_by

Text

25

 

0

 

0

0

0

0

Certificate number

MACP Coding Standard field

certificate_number

Text

15

 

0

 

0

0

0

0

Owner

MACP Coding Standard field

Collection system owner.

owner

Text

30

 

0

 

0

0

0

0

Customer

MACP Coding Standard field

Customer commissioning the survey.

customer

Text

30

 

0

 

0

0

0

0

Site managed by

The name or type of organisation that manges the site:

Database Value

Description

C

City

M

Military

P

Private

O

Other

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

site_managed_by

Text

40

 

0

 

 

 

 

 

Reviewed by

The name of the person responsible for reviewing the survey.

reviewed_by

Text

60

 

0

 

0

0

0

0

Reviewer certificate number

The certificate number of the reviewer.

reviewer_certificate_number

Text

15

 

0

 

0

0

0

0

Purpose

MACP Coding Standard field

Reason for survey:

Database Value

Description
G Capital Improvement Program Assessment
B Infiltration and Inflow Investigation
A Maintenance related
Z Not known
C Post rehabilitation survey
E Pre acceptance - new sewers
D Pre rehabilitation survey
H Resurvey for any reason
F Routine assessment
I Sewer System Evaluation Survey

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

purpose

Text

64

 

0

 

0

0

0

0

Sheet number

MACP Coding Standard field

Number to identify individual surveys within a group.

sheet_number

Long Integer

 

 

0

 

0

0

0

0

Category

MACP Coding Standard field

Indicates importance of sewer.

category

Text

2

 

0

 

0

0

0

0

Contract no

Work order number.

contract_no

Text

100

 

0

 

0

0

0

0
Inspection level

MACP Coding Standard field

Database Value

Description
1 Level 1
2 Level 2

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

 inspection_level Text 40   0          

Inspection status

MACP Coding Standard field

Database Value

Description
BM Buried or Marked
DI Descent Inspection
NI NI Traffic
NA No Access
NF Not Found
NO Not Opened
RI Remote Inspection
SD Surcharged/Debris
SI Surface Inspection

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

inspection_status

Text

50

 

0

 

0

0

0

0

Additional info

MACP Coding Standard field

Additional information regarding survey.

additional_info

Text

255

 

0

 

0

0

0

0
Additional component info

MACP Coding Standard field

Additional component information.

 additional_component_info Text 255   0          

PO number

MACP Coding Standard field

Purchase order number.

po_number

Text

15

 

0

 

0

0

0

0

Project

Project reference.

project

Text

64

 

0

 

0

0

0

0
Survey stage

An EU2011 Coding Standard field.

A description of the stage of the survey:

Database Value

Description
A From the employing authority to the inspector
B From the inspector to the employing authority for review
C Within the employing authority following review
z Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

 survey_stage Text 10   0          
Standard

The type of standard used:

Database Value

Description

MSCC3

MSCC3

MSCC4

MSCC4

EN 13508-2:2003

EN 13508-2:2003

EN 13508-2:2004

EN 13508-2:2004

PACP

NASSCO PACP

LACP

NASSCO LACP

WSAA

Water Service of Australia
WSAA2 Water Service of Australia v2.2
WSAA3 Water Service of Australia v3.1

SCREAM

CH2M Hill

OTHER

Other
NZWWA NZ Pipe Inspection Manual 3rd Edition
NZWWA4 NZ Pipe Inspection Manual 4th Edition
standard Text 100   0          
Original code The original code. orig_coding Text 20   0          

Structural condition

A measure of asset condition. Usually a number in the range 1-5

structural_condition

Long Integer

 

 

0

 

 

 

0

5

Maintenance condition

A measure of asset condition. Usually a number in the range 1-5

maintenance_condition

Long Integer

 

 

0

 

 

 

0

5

Shaft condition

A measure of asset condition. Usually a number in the range 1-5

shaft_condition

Long Integer

 

 

0

 

 

 

0

5

Chamber condition

A measure of asset condition. Usually a number in the range 1-5

chamber_condition

Long Integer

 

 

0

 

 

 

0

5

Cover condition

A measure of asset condition. Usually a number in the range 1-5

cover_condition

Long Integer

 

 

0

 

 

 

0

5

Leveler condition

A measure of asset condition. Usually a number in the range 1-5

leveler_condition

Text

40

 

0

 

 

 

 

 

Site condition

The type of site.

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

site_condition

Text

40

 

0

 

 

 

 

 
Chimney condition

A measure of asset condition. Usually a number in the range 1-5

 chimney_condition Text 1   0

 

 

 

0

9999
Cone condition

A measure of asset condition. Usually a number in the range 1-5

 cone_condition Text 1   0

 

 

 

0

9999
Wall condition

A measure of asset condition. Usually a number in the range 1-5

 wall_condition Text 1   0

 

 

 

0

9999
Channel condition

A measure of asset condition. Usually a number in the range 1-5

 channel_condition Text 1   0

 

 

 

0

9999

Surcharge height

Surcharge height in manhole.

surcharge_height

Double

 

MANH_Y

0

 

 

 

0

9999

Depth of flow

Depth of flow in manhole.

flow_depth

Double

 

MANH_Y

0

 

 

 

0

9999

Silt depth

Depth of silt in manhole.

silt_depth

Double

 

MANH_Y

0

 

 

 

0

9999

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

 

 

 

 

 

Attend to bench

Check box indicating whether manhole bench requires repair.

attend_to_bench

Boolean

 

 

0

 

 

 

 

 

Attend to step

Check box indicating whether manhole steps require repair.

attend_to_step

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

 

 

 

 

 

Toxic atmosphere

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

toxic_atmosphere

Boolean

 

 

0

 

 

 

 

 

Gas type

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

gas_type

Text

40

 

0

 

 

 

 

 

Evidence surcharge

MACP Coding Standard field

evidence_surcharge

Boolean

 

 

0

 

0

0

0

0

Evidence of vermin

Check box indicating whether the presence of vermin was detected during the survey.

vermin

Boolean

 

 

3

 

 

 

 

 

Pre-cleaning

Type of cleaning carried out prior to survey.

The options displayed in this choice list depends on the Manhole survey standard being used.

See the Standards and Choice Lists dialog for further information.

pre_cleaning

Text

15

 

0

 

0

0

0

0

Date cleaned

MACP Coding Standard field

Most recent date prior to the survey when the sewer was cleaned.

date_cleaned

Date / Time

 

 

0

 

0

0

0

0

Overall infiltration/inflow grade

Overall infiltration/inflow grade using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_overall_ii_grade

Long Integer

 

 

0

 

 

 

0

5

Overall total grade

Overall total grade using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_overall_total_grad

Long Integer

 

 

0

 

 

 

0

5

Overall structural and infiltration/inflow grade

Overall structural and infiltration/inflow grade using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_overall_sii_grade

Long Integer

 

 

0

 

 

 

0

5

Cover shape

The shape of the manhole cover.

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

cover_shape

Text

10

 

1

 

 

 

 

 

Cover duty

A description of the duty, eg light or heavy, of the manhole cover.

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

cover_duty

Text

10

 

1

 

 

 

 

 

Cover material

The material which the manhole cover is made from.

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

cover_material

Text

40

 

0

 

 

 

 

 

Hole diameter

The diameter of the hole for the manhole cover.

MACP Coding Standard field.

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

hole_diameter

Text

50

 

0

 

0

0

0

0

Hole number

MACP Coding Standard field

hole_number

Long Integer

 

 

0

 

0

0

0

0

Cover dimension

Dimension of manhole cover.

When using MACP Coding Standard, corresponds to MACP cover_size field.

cover_dim

Double

 

MANH_DIM

0

 

 

 

0

9999

Cover dimension 2

Dimension of manhole cover.

cover_dim_2

Double

 

MANH_DIM

0

 

 

 

0

9999

Centre cover size

Dimension of centre cover.

center_cover_size

Double

 

MANH_DIM

0

 

 

 

0

9999

Cover level

Height above datum of manhole cover.

cover_level

Double

 

Z

3

 

 

 

-99.99

999.99

Cover assembly

Database Value

Description

A

Assembled

S

Single

O

Other

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

cover_assembly

Text

40

 

0

 

 

 

 

 

Cover frame fit

MACP Coding Standard field

Database Value

Description
G Good
O Oversized
R Rocks/Wobbles
U Undersized

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

cover_frame_fit

Text

50

 

0

 

0

0

0

0

Cover bearing surface diameter

MACP Coding Standard field

cover_bearing_surface_dia

Double

 

MANH_DIM

0

 

0

0

0

0

Cover bearing surface diameter width

MACP Coding Standard field

cover_bearing_surface_dia_width

Double

 

MANH_DIM

0

 

0

0

0

0

Cover hinged

Check box indicating whether the manhole cover is hinged.

cover_hinged

Boolean

 

 

1

 

 

 

 

 

Cover locked

Check box indicating whether the manhole cover is locked.

cover_locked

Boolean

 

 

1

 

 

 

 

 

Side entry

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

side_entry

Boolean

 

 

0

 

 

 

 

 
Shape of access

A description of the shape of access.

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

 access_shape Text 10   0          
Width of access

EU2011 Coding Standard field

The measurement of the access width.

 access_width Text 10   0          
Breadth of access

EU2011 Coding Standard field

The measurement of the access breadth.

 access_breadth Text 10              

Cover type solid

MACP Coding Standard field

Check box indicating whether the manhole cover is solid.

cover_type_solid

Boolean

 

 

0

 

0

0

0

0

Cover type vented

MACP Coding Standard field

Check box indicating whether the manhole cover is vented.

cover_type_vented

Boolean

 

 

0

 

0

0

0

0

Cover type gasketed

MACP Coding Standard field

Check box indicating whether the manhole cover includes a gasket.

cover_type_gasketed

Boolean

 

 

0

 

0

0

0

0

Cover type bolted

MACP Coding Standard field

Check box indicating whether the manhole cover is bolted.

cover_type_bolted

Boolean

 

 

0

 

0

0

0

0

Cover type inner cover

MACP Coding Standard field

Check box indicating whether the manhole cover includes an inner cover

cover_type_inner_cover

Boolean

 

 

0

 

0

0

0

0

Cover type locking

MACP Coding Standard field

Check box indicating whether the manhole cover is lockable.

cover_type_locking

Boolean

 

 

0

 

0

0

0

0
Cover type lamphole

MACP Coding Standard field

Check box indicating whether the manhole cover includes a lamphole.

 cover_type_lamphole Boolean     0          
Cover type hatch single

MACP Coding Standard field.

Check box indicating whether the manhole cover is a single hatch.

 cover_type_hatch_single Boolean     0          
Cover type hatch double

MACP Coding Standard field

Check box indicating whether the manhole cover is a double hatch.

 cover_type_hatch_double Boolean     0          
Cover type removable center

MACP Coding Standard field

Check box indicating whether the manhole cover has a removal centre.

 cover_type_removable_center Boolean     0          

Cover condition sound

MACP Coding Standard field

Check box indicating whether the condition of the manhole cover is acceptable.

cover_condition_sound

Boolean

 

 

0

 

0

0

0

0

Cover condition cracked

MACP Coding Standard field

Check box indicating whether the condition of the manhole cover is cracked.

cover_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Cover condition broken

MACP Coding Standard field

Check box indicating whether the condition of the manhole cover is broken.

cover_condition_broken

Boolean

 

 

0

 

0

0

0

0

Cover condition corroded

MACP Coding Standard field

Check box indicating whether the condition of the manhole cover is corroded.

cover_condition_corroded

Boolean

 

 

0

 

0

0

0

0

Cover condition bolts missing

MACP Coding Standard field

Check box indicating whether bolts are missing from the manhole cover.

cover_condition_boltsmissing

Boolean

 

 

0

 

0

0

0

0

Cover condition missing

MACP Coding Standard field

Check box indicating whether the manhole cover is missing.

cover_condition_missing

Boolean

 

 

0

 

0

0

0

0
Cover condition restraint missing

MACP Coding Standard field

Check box indicating whether the restraint for the manhole cover is missing.

 cover_condition_restraing_miss Boolean     0          
Cover condition restraint defective

MACP Coding Standard field

Check box indicating whether the restraint for the manhole cover is defective.

 cover_condition_restraint_defect Boolean     0          

Cover insert type

MACP Coding Standard field

Database Value

Description
M Metal
N None
Z Other
P Plastic

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

cover_insert_type

Text

50

 

0

 

0

0

0

0

Insert condition sound

MACP Coding Standard field

Check box indicating whether the condition of the manhole cover insert is acceptable.

insert_condition_sound

Boolean

 

 

0

 

0

0

0

0

Insert condition poorly fitting

MACP Coding Standard field

Check box indicating whether the manhole cover insert is a poor fit

insert_condition_poorlyfitting

Boolean

 

 

0

 

0

0

0

0

Insert condition cracked

MACP Coding Standard field

Check box indicating whether the manhole cover insert is cracked.

insert_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Insert condition leaking

MACP Coding Standard field

Check box indicating whether the manhole cover insert is leaking.

insert_condition_leaking

Boolean

 

 

0

 

0

0

0

0

Insert condition insert fell

MACP Coding Standard field

Check box indicating whether the manhole cover insert is has fallen.

insert_condition_insertfell

Boolean

 

 

0

 

0

0

0

0
Insert condition corroded

MACP Coding Standard field

heck box indicating whether the manhole cover insert is corroded.

 insert_condition_corroded Boolean     0          

Adjustment ring type

MACP Coding Standard field

Database Value

Description

A

Adjustable
N None

S

Solid

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

adjustment_ring_type

Text

50

 

0

 

0

0

0

0

Adjustment ring height

MACP Coding Standard field

adjustment_ring_height

Double

 

MANH_DIM

0

 

0

0

0

0
Adjustment ring material

MACP Coding Standard field

Database Value

Description
CAS Cast Iron
CN Concrete (non-reinforced)
CR Concrete (reinforced)
DI Ductile Iron
FR Fiberglass Reinforced
PE Plyethylene
PSC Plastic/Steel Composite
PVC Polyvinyl Chloride
S Steel
XXX Not Known
ZZZ Other

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

 adjustment_ring_material Text 50   0   0 0 0 0
Chamber unit length Length of individual prefabricated manhole or inspection chamber ring units that comprise the manhole or inspection chamber. chamber_unit_length Double   MANH_Y         0 9999

Ring condition sound

MACP Coding Standard field

Check box indicating whether the condition of the adjustment ring is acceptable.

ring_condition_sound

Boolean

 

 

0

 

0

0

0

0

Ring condition broken

MACP Coding Standard field

Check box indicating whether the adjustment ring is broken.

ring_condition_broken

Boolean

 

 

0

 

0

0

0

0

Ring condition corroded

MACP Coding Standard field

Check box indicating whether the adjustment ring is corroded.

ring_condition_corroded

Boolean

 

 

0

 

0

0

0

0

Ring condition cracked

MACP Coding Standard field

Check box indicating whether the adjustment ring is cracked.

ring_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Ring condition leaking

MACP Coding Standard field

Check box indicating whether the adjustment ring is leaking.

ring_condition_leaking

Boolean

 

 

0

 

0

0

0

0

Ring condition poor install

MACP Coding Standard field

Check box indicating whether the installation of the adjustment ring is considered acceptable.

ring_condition_poorinstall

Boolean

 

 

0

 

0

0

0

0

Seal condition sound

MACP Coding Standard field

Check box indicating whether the condition of the cover seal is acceptable.

seal_condition_sound

Boolean

 

 

0

 

0

0

0

0

Seal condition cracked

MACP Coding Standard field

Check box indicating whether the cover seal is cracked.

seal_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Seal condition loose

MACP Coding Standard field

Check box indicating whether the cover seal is loose.

seal_condition_loose

Boolean

 

 

0

 

0

0

0

0

Seal condition offset

MACP Coding Standard field

Check box indicating whether the cover seal is offset.

seal_condition_offset

Boolean

 

 

0

 

0

0

0

0
Seal condition missing

MACP Coding Standard field

Check box indicating whether the cover seal is missing.

 seal_condition_missing Boolean     0          

Frame material

MACP Coding Standard field

Database Value

Description
CAS Cast Iron
CN Concrete (non-reinforced)
CR Concrete (reinforced)
DI Ductile Iron
FR Fiberglass Reinforced
PE Polyethylene
PSC Plastic/Steel Composite
PVC Polyvinyl Chloride
S Steel
XXX Not Known
ZZZ Other

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

frame_material

Text

50

 

0

 

0

0

0

0

Frame bearing surface width

MACP Coding Standard field

frame_bearing_surface_width

Double

 

MANH_DIM

0

 

0

0

0

0

Frame bearing surface depth

MACP Coding Standard field

frame_bearing_surface_depth

Double

 

MANH_Y

0

 

0

0

0

0

Frame depth

MACP Coding Standard field

frame_depth

Double

 

MANH_Y

0

 

0

0

0

0

Frame offset distance

MACP Coding Standard field

frame_offset_distance

Double

 

MANH_DIM

0

 

0

0

0

0

Frame clear open diameter

MACP Coding Standard field

frame_clear_open_diam

Double

 

MANH_DIM

0

 

0

0

0

0

Frame clear open width

MACP Coding Standard field

frame_clear_open_width

Double

 

MANH_Y

0

 

0

0

0

0

Frame seal inflow

MACP Coding Standard field

Database Value

Description
ID Infil Dripper
IG Infil Gusher
IR Infil Runner
IS Infil Stained
IW Infil Weeper
N None

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

frame_seal_inflow

Text

50

 

0

 

0

0

0

0

Frame condition sound

MACP Coding Standard field

Check box indicating whether the condition of the cover frame is acceptable.

frame_condition_sound

Boolean

 

 

0

 

0

0

0

0

Frame condition cracked

MACP Coding Standard field

Check box indicating whether the cover frame is cracked.

frame_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Frame condition broken

MACP Coding Standard field

Check box indicating whether the cover frame is broken.

frame_condition_broken

Boolean

 

 

0

 

0

0

0

0

Frame condition missing

MACP Coding Standard field

Check box indicating whether the cover frame is missing.

frame_condition_missing

Boolean

 

 

0

 

0

0

0

0

Frame condition corroded

MACP Coding Standard field

Check box indicating whether the cover frame is corroded.

frame_condition_corroded

Boolean

 

 

0

 

0

0

0

0

Frame condition coated

MACP Coding Standard field

Check box indicating whether a coating has been applied to the cover frame.

frame_condition_coated

Boolean

 

 

0

 

0

0

0

0

Shaft access

Database Value

Description

L

Ladder

S

Stairs

I

Iron Sticks

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

shaft_access

Text

40

 

0

 

 

 

 

 

Shaft depth

Depth of manhole shaft

shaft_depth

Double

 

MANH_Y

0

 

 

 

0

9999

Shaft dimension

Dimension of manhole shaft.

shaft_dim

Double

 

MANH_DIM

0

 

 

 

0

9999

Shaft dimension 2

Dimension of manhole shaft.

shaft_dim_2

Double

 

MANH_DIM

0

 

 

 

0

9999

Shaft material

Database Value

Description

FIBRE

Fibre Glass

CEMENT

Cement

POLY

Polyethylene

O

Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

shaft_material

Text

40

 

0

 

 

 

 

 

Chimney present

The presence of a chimney can be indicated by selecting Y (Yes) or N (No) from the drop-down list.

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

chimney_present

Text

50

 

0

 

0

0

0

0

Chimney material 1

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

chimney_material1

Text

50

 

0

 

0

0

0

0

Chimney material 2

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

chimney_material2

Text

50

 

0

 

0

0

0

0

Chimney lining interior

MACP Coding Standard field

chimney_lining_interior

Text

50

 

0

 

0

0

0

0

Chimney lining exterior

MACP Coding Standard field

chimney_lining_exterior

Text

50

 

0

 

0

0

0

0

Chimney inflow and infiltration

MACP Coding Standard field

chimney_ini

Text

50

 

0

 

0

0

0

0

Chimney clear opening

MACP Coding Standard field

chimney_clear_opening

Double

 

MANH_DIM

0

 

0

0

0

0

Chimney depth

MACP Coding Standard field

chimney_depth

Double

 

MANH_Y

0

 

0

0

0

0

Chamber construction

Database Value

Description

B

Brick

P

Precast Units

G

Glass Reinforced Plastic

I

In-Situ

S

Segmental

L

Plastic (Other)

R

Rendered

U

Unspecified

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

chamber_construction

Text

10

 

1

 

 

 

 

 

Chamber dimension

Dimension of manhole chamber.

chamber_dim

Double

 

MANH_DIM

0

 

 

 

0

9999

Chamber dimension 2

Dimension of manhole chamber.

chamber_dim_2

Double

 

MANH_DIM

0

 

 

 

0

9999

Chamber floor depth from cover

Distance between chamber floor and manhole cover level.

chamber_floor_depth

Double

 

MANH_Y

0

 

 

 

0

 

Chamber shape

Database Value

Description

C

Circular

E

Egg

R

Rectangular

S

Square

T

Trapezoidal

A

Arch

B

Barrel

H

Horseshoe

O

Oval

U

Unspecified

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

chamber_shape

Text

40

 

0

 

 

 

 

 

Soffit type

Database Value

Description

S

Reducing Slab

T

Taper

A

Arch

C

Corbel

N

None

U

Unspecified

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

soffit_type

Text

10

 

0

 

 

 

 

 

Cone type

MACP Coding Standard field

Database Value

Description
CC Conical centred
CO Conical off centred
FT Flattop

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

cone_type

Text

50

 

0

 

0

0

0

0

Cone material

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

cone_material

Text

50

 

0

 

0

0

0

0

Cone depth

MACP Coding Standard field

cone_depth

Double

 

MANH_Y

0

 

0

0

0

0

Cone lining interior

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

cone_lining_interior

Text

50

 

0

 

0

0

0

0

Cone lining exterior

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

cone_lining_exterior

Text

50

 

0

 

0

0

0

0

Wall diameter

MACP Coding Standard field

wall_diam

Double

 

MANH_DIM

0

 

0

0

0

0

Wall depth

MACP Coding Standard field

wall_depth

Double

 

MANH_Y

0

 

0

0

0

0

Wall by size

MACP Coding Standard field

wall_bysize

Double

 

MANH_DIM

0

 

0

0

0

0

Wall material

MACP Coding Standard field.

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

wall_material

Text

50

 

0

 

0

0

0

0

Wall lining interior

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

wall_lining_interior

Text

50

 

0

 

0

0

0

0

Wall lining exterior

MACP Coding Standard field

wall_lining_exterior

Text

50

 

0

 

0

0

0

0

Number of steps

Number of steps installed in manhole.

When using MACP Coding Standard, corresponds to MACP Step_Number field.

num_steps

Integer

 

 

0

 

 

 

0

99

Number of ladders

Number of ladders installed in manhole.

num_ladders

Integer

 

 

0

 

 

 

0

9

Number of landings

Number of landings installed in manhole.

num_landings

Long Integer

 

 

0

 

 

 

0

9

Number of regulating courses

 

num_regulating

Integer

 

 

0

 

 

 

0

9

Step material

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

step_material

Text

50

 

0

 

0

0

0

0

Grade to invert

MACP Coding Standard field

Distance from average grade to invert of outgoing invert.

grade_to_invert

Double

 

MANH_DIM

0

 

0

0

0

0

Rim to invert

MACP Coding Standard field

Distance from rim to invert of upstream manhole.

rim_to_invert

Double

 

MANH_DIM

0

 

0

0

0

0

Rim to grade

MACP Coding Standard field

Distance from rim to average grade of outgoing invert.

rim_to_grade

Double

 

MANH_DIM

0

 

0

0

0

0

Rim to grade exposed

MACP Coding Standard field

Depth between the rim of the manhole and the grade level at the lowest exposed point of the manhole exterior

rim_to_grade_exposed

Double

 

MANH_DIM

0

 

0

0

0

0

Channel installed

MACP Coding Standard field

Check box indicating whether a channel is installed.

channel_installed

Boolean

 

 

0

 

0

0

0

0

Channel type

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

channel_type

Text

50

 

0

 

0

0

0

0

Channel material

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

channel_material

Text

50

 

0

 

0

0

0

0

Channel exposure

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

channel_exposure

Text

50

 

0

 

0

0

0

0

Bench present

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

bench_present

Text

50

 

0

 

0

0

0

0

Bench material

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

bench_material

Text

50

 

0

 

0

0

0

0

Bench lining

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

bench_lining

Text

50

 

0

 

0

0

0

0

Leveler material

Database Value

Description

CEMENT

Cement

CONC

Concrete

O

Other

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

leveler_material

Text

40

 

0

 

 

 

 

 
Inlet type

Database Value

Description

ContC

Continuous Combination

ContCO

Continuous Curb-Opening

ContG

Continuous Grate
SagC Sag Combination
SagCO Sag Curb-Opening
SagG Sag Grate

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

 inlet_type Text 30              
Clear opening area Clear area of grate or opening. clear_opening Double   NA 3          
Cross slope Rate of change of roadway elevation with respect to distance perpendicular to the direction of travel. Also known as transverse slope. cross_slope Double   S 3          
% Clogging Factor used to model the effect of clogging from debris. debris Double     0          
Grate length Grate dimension. grate_length Double   L 3          
Grate width Grate dimension. grate_width Double   L 3          
Gutter depression Depth of gutter depression for a depressed inlet. gutter_depression Double   L 3          
Lateral depression Lateral width of gutter depression for a depressed inlet. lateral_depression Double   L 3          
Opening height Height of curb opening. opening_height Double   L 3          
Opening length Length of curb opening. opening_length Double   L 3          

Surface type asphalt

MACP Coding Standard field

Check box indicating whether the surface type is asphalt.

surface_type_asphalt

Boolean

 

 

0

 

0

0

0

0

Surface type concrete pavement

MACP Coding Standard field

Check box indicating whether the surface type is a concrete pavement.

surface_type_concretepavement

Boolean

 

 

0

 

0

0

0

0

Surface type concrete collar

MACP Coding Standard field

Check box indicating whether the surface type is a concrete collar.

surface_type_concretecollar

Boolean

 

 

0

 

0

0

0

0

Surface type grass dirt

MACP Coding Standard field

Check box indicating whether the surface type is grass dirt.

surface_type_grassdirt

Boolean

 

 

0

 

0

0

0

0

Surface type gravel

MACP Coding Standard field

Check box indicating whether the surface type is gravel.

surface_type_gravel

Boolean

 

 

0

 

0

0

0

0

Surface type other

MACP Coding Standard field

surface_type_other

Boolean

 

 

0

 

0

0

0

0

Potential for runoff

MACP Coding Standard field

Flow restriction type used.

potential_for_runoff

Text

50

 

0

 

0

0

0

0

Weather

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

weather

Text

50

 

0

 

0

0

0

0
Cleaning activity

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

 cleaning_activity Text 255   0          
Cleaning method

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

 cleaning_method Text 255   0          
Access for cleaning

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

 cleaning_access Text 255   0          
Client present The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. client_present Text 255   0          
Cleaning checked

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

 cleaning_checked Text 255   0          
Cleaning pressure The pressure applied during the cleaning process, if applicable. cleaning_pressure Double   WN_P 2          
Pressure nozzle type A description or reference of any pressure nozzle used in the cleaning operation. pressure_nozzle_type Text 255   0          
Pressure unit reference A description or reference of any pressure cleaning unit used in the cleaning operation. pressure_unit_ref Text 255   0          
Vehicle reference An identifier or description of the vehicle, if any, used for the cleaning operation. vehicle_reference Text 255   0          
Driver name The name of the driver of the cleaning vehicle. driver_name Text 255              
Animal escape route

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

 animal_escape Text 255   0          
House numbering

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

 house_numbering Text 255   0          
Landfill reference A description of any landfill used. landfill_ref Text 255   0          

Access action

Database Value

Description

POL

Police Assistance

PARK

No Parking

KEYS

Keys Needed

O

Other

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

access_action

Text

40

 

0

 

 

 

 

 

Access time

Database Value

Description

A

Outside Working Hours

B

Outside Normal Hours

C

Outside Weekend Hours

O

Other

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

access_time

Text

40

 

0

 

 

 

 

 
Road material

The type of material that the road is constructed from.

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

 road_material Text 64   0          
Manhole not mapped

Indicates whether the manhole is included on a map.

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

 manhole_not_mapped Text 64   0          
Manhole not surveyed

Indicates why the manhole was not surveyed.

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

 manhole_not_surveyed Text 64   0          
Flow control

Database Value

Description
A No Measures

B

 Flow Blocked US
C Flow Partially Blocked US
Z

Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

 flow_control Text 25   0          
Step type

Database Value

Description
A Single width

B

 Double width
C Ladder
D Toe holes
E No provision
Z

Other

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

 step_type Text 50   0          
Method of inspection

Database Value

Description
A Direct Inspection

B

 Remote Inspection
C Inspection From Surface Only
Z

Other

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

 method Text 10   0          
Vertical reference point

Database Value

Description
A Lowest outgoing invert

B

 Cover
C National datum
D Local datum
Z

Other

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

 vertical_reference_point Text 20   0          
Temperature

Database Value

Description
A Above freezing

B

 Below freezing

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

 temperature Text 3   0          

Main comment

Additional comments field.

main_comment

Text

40

 

0

 

 

 

 

 
Consequence of failure

The consequence of a manhole inspection failure.

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

 consequence_of_failure

Text

40

 

0

 

0

0

0

0

Pressure value

MACP Coding Standard field

Grouting pressure value.

pressure_value

Double

 

3

0

 

 

 

 

 

Photo storage

The type of media used for storing photo images e.g. still photographs, computer images.

photo_storage

Text

1

 

0

 

 

 

 

 

Photo reference

The reference number of the film or CD on which the photos are stored.

photo_reference

Text

1

 

0

 

 

 

 

 

Video storage

Type of media used for storing CCTV video images.

video_recorder

Text

255

 

0

 

 

 

 

 

Video location

The method of recording the position of images on the tape or CD.

vt_no

Text

5

 

0

 

 

 

 

 

Video volume ref

The reference number of the volume, file, tape or CD on which the video images are stored.

video_image_loc

Text

255

 

0

 

 

 

 

 
Video file format

The type of file format used by the video.

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

 video_format Text 225   2          

InfoAsset Video file

Full path to the file containing the video images associated with the CCTV Survey

When viewing images for a defect from the Defects Page, the images from the file selected in this field will be displayed if a defect specific video file has not been specified in the Video file field of the defect.

Note that a video file Attachment may also be used for manhole surveys (See Viewing Manhole Survey Video Data).

video_file_in

Text

255

 

0

 

 

 

 

 

Details

Click the button to display the Defects section.

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Database Table Name: cams_manhole_survey_details

Position in Data Structure

Field Name

Help Text

Database Field

Data Type

Size

Units

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Lower Limit

1

Vertical location

 

distance

Double

 

L

 

0

 

 

 

2

Code

Defect code

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

code

Text

12

 

 

0

 

 

 

3

CD

Continuous defect code

cd

Text

3

 

 

0

 

 

 

4

Char 1/ material

 

characterisation1

Text

3

 

 

0

 

 

 

5

Char 2/ band

 

characterisation2

Text

3

 

 

0

 

 

 

6

Quant/ dim 1

 

quant1

Double

 

 

 

0

 

 

 

7

Quant/ dim 2

 

quant2

Double

 

 

 

0

 

 

 

8

Clock at

Defect location

clock_at

Long Integer

 

 

 

0

12

 

 

9

Clock to

Defect location

clock_to

Long Integer

 

 

 

0

12

 

 

10

%

 

percentage

Double

 

 

 

0

 

 

 

11

Joint

Check box indicating whether defect occurs at a joint

Joint

Boolean

 

 

 

 

 

 

 

12

Step

Check box indicating whether defect occurs at a step

Step

Boolean

 

 

 

 

 

 

 

13

Desc loc

 

descriptive_location

Text

3

 

 

0

 

 

 

14

Video file

Full path to the file containing the video images associated with the defect

If a video file is not specified, the images from the file selected in the following will be displayed if available:

  • InfoAsset Video File field of the survey

    or

  • the first attachment in the Attachments Editor with Purpose set to CCTV video

See Viewing Manhole Survey Video Data.

video_file

Text

255

 

 

0

 

 

 

15

Video no

Time (in seconds) from start of video

video_no

Double

 

 

 

0

 

 

 

16

Video time

Time from start of video in HH:MM:SS format

video_no2

Text

12

 

 

0

 

 

 

17

Photo no

External reference to photo

photo_no

Text

64

 

 

0

 

 

 

18

Remarks

Further details describing defect

remarks

Text

255

 

 

0

 

 

 

19

Service score

Maintenance score for defect. Calculated when calculating manhole scores using the applicable manhole scoring standard

service_score

Double

 

 

 

0

 

 

 

20

Structural score

Structural score for defect. Calculated when calculating manhole scores using the applicable manhole scoring standard

structural_score

Double

 

 

 

0

 

 

 

21

Char 3

A characterisation code used in the RibX standard

characterisation3

Text

20

 

 

0

 

 

 

details

Array

 

 

0

 

 

 

 

 

O and M ratings index

Operation and maintenance index using MACP condition grading system.

macp_oandm_index_rating

Double

 

 

6

 

 

 

 

 

O and M quick rating

MACP quick operation and maintenance rating calculated from O and M defect grades.

macp_oandm_quick_rating

Text

6

 

0

 

 

 

 

 

O and M rating

Operation and maintenance rating score using MACP condition grading system.

macp_oandm_rating

Long Integer

 

 

0

 

 

 

 

 

Overall ratings index

Overall ratings index using MACP condition grading system.

macp_overall_index_rating

Double

 

 

6

 

 

 

 

 

Overall quick rating

MACP quick overall rating.

macp_overall_quick_rating

Text

6

 

0

 

 

 

 

 

Overall rating

Overall rating score using MACP condition grading system.

macp_overall_rating

Long Integer

 

 

0

 

 

 

 

 

Structure ratings index

Structural ratings index using MACP condition grading system.

macp_struct_index_rating

Double

 

 

6

 

 

 

 

 

Structure quick rating

MACP quick structural rating calculated from structural defect grades.

macp_struct_quick_rating

Text

6

 

0

 

 

 

 

 

Structure rating

Structural rating score using MACP condition grading system.

macp_struct_rating

Long Integer

 

 

0

 

 

 

 

 

Upper structural score

Upper structural condition score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_upper_struc_score

Double

 

 

2

 

 

 

 

 

Upper maintenance score

Upper maintenance score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_upper_maint_score

Double

 

 

2

 

 

 

 

 

Upper infiltration/ inflow score

Upper infiltration/inflow score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_upper_ii_score

Double

 

 

2

 

 

 

 

 

Upper total score

Upper total score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_upper_total_score

Double

 

 

2

 

 

 

 

 

Lower structural score

Lower structural condition score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_lower_struc_score

Double

 

 

2

 

 

 

 

 

Lower maintenance score

Lower maintenance score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_lower_maint_score

Double

 

 

2

 

 

 

 

 

Lower infiltration/ inflow score

Lower Infiltration/Inflow score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_lower_ii_score

Double

 

 

2

 

 

 

 

 

Lower total score

Lower total score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_lower_total_score

Double

 

 

2

 

 

 

 

 

Overall structural score

Overall structural condition score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_overall_struc_scre

Double

 

 

2

 

 

 

 

 

Overall maintenance score

Overall maintenance score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_overall_maint_scre

Double

 

 

2

 

 

 

 

 

Overall infiltration/ inflow score

Overall infiltration/inflow score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_overall_ii_score

Double

 

 

2

 

 

 

 

 

Overall total score

Overall total score using the CH2M HILL SCREAM™ manhole scoring standard.

CH2MHill_overall_total_scre

Double

 

 

2

 

 

 

 

 
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                

Has photos

Check box indicating whether photos are associated with the pipe.

has_photos

Boolean

 

 

0

 

 

 

 

 
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.                    

Creating a Manhole Survey

Survey Grid

Network Data Fields

Common Data Fields