Node Data Fields

Information relating to a node can be viewed and edited on the Node Grid Window of the Asset Grid or on the Node Property Sheet.

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

Manhole Survey

If you are using the EU manhole standard, you can choose to have a streamlined version of the node 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.

Node Data

Database Table Name: cams_manhole

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

A unique name for the manhole, up to 40 letters, numbers and underscore characters. Upper and lower case letters are treated as being the same.

node_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

 

 

 

 

 

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

System type

Database Value

Description

F

Foul

S

Surface

C

Combined

T

Transition

O

Overflow

U

Unspecified

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

system_type

Text

10

 

0

 

 

 

 

 

Date installed

Date of installation.

year_laid

Date / Time

 

 

1

 

 

 

 

 

Year renewed

Year sewer was 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

Drainage code

Drainage area 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 of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of the object.

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:

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 which coding standard is being used. See the Standards and Choice Lists dialog for further information.

status

Text

10

 

1

 

 

 

 

 

Street

MACP Coding Standard field

Manhole location description.

street

Text

64

 

0

 

0

0

0

0

City

MACP Coding Standard field

Location of manhole.

city

Text

64

 

0

 

0

0

0

0

Coordinate system

MACP Coding Standard field

System used for GPS coordinates.

coordinate_system

Text

50

 

0

 

0

0

0

0

Location details

MACP Coding Standard field

Manhole location description.

location_details

Text

255

 

0

 

0

0

0

0

Access type

MACP Coding Standard field

access_type

Text

50

 

0

 

0

0

0

0

Location code

MACP Coding Standard field

Ground cover description.

location_code

Text

30

 

0

 

0

0

0

0

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

Site managed by

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

 

 

 

 

 
PO number

MACP Coding Standard field

Customer purchase order number.

 po_number Text 15   0   0 0 0 0

Inspection status

MACP Coding Standard field

inspection_status

Text

50

 

0

 

0

0

0

0

Category

MACP Coding Standard field

Indicates importance of sewer.

category

Text

2

 

0

 

0

0

0

0

Structural condition

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

 

 

 

0

5

Shaft condition

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

shaft_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

Maintenance condition

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

maintenance_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

Leveler condition

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

leveler_condition

Text

40

 

0

 

 

 

 

 

Site condition

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.

site_condition

Text

40

 

0

 

 

 

 

 

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

Surcharge height

Surcharge height in manhole.

surcharge_height

Double

 

MANH_Y

0

 

 

 

0

9999

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

 

 

 

 

 

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:

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

 

 

 

 

 

Gas type

Database Value

Description

A

CH4

B

H2S

C

Explosive

O

Other

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

gas_type

Text

40

 

0

 

 

 

 

 

Attend to cover

Check box indicating whether manhole cover requires repair.

attend_to_cover

Boolean

 

 

0

 

 

 

 

 

Attend to step

Check box indicating whether manhole steps require repair.

attend_to_step

Boolean

 

 

0

 

 

 

 

 

Attend to shaft

Check box indicating whether manhole shaft requires repair.

attend_to_shaft

Boolean

 

 

0

 

 

 

 

 

Attend to chamber

Check box indicating whether manhole chamber requires repair.

attend_to_chamber

Boolean

 

 

0

 

 

 

 

 

Attend to bench

Check box indicating whether manhole bench requires repair.

attend_to_bench

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 there are hazardous gases in the atmosphere.

toxic_atmosphere

Boolean

 

 

0

 

 

 

 

 

Evidence of vermin

Check box indicating whether the presence of vermin has been detected.

vermin

Boolean

 

 

3

 

 

 

 

 

Overall infiltration/ inflow grade

Overall Infiltration/Inflow grade using the CH2M HILL SCREAM™ manhole scoring standard. May be updated automatically from Manhole Survey Data.

CH2MHill_overall_ii_grade

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. May be updated automatically from Manhole Survey Data.

CH2MHill_overall_sii_grade

Long Integer

 

 

0

 

 

 

0

5

Overall total grade

Overall Total grade using the CH2M HILL SCREAM™ manhole scoring standard. May be updated automatically from Manhole Survey Data.

CH2MHill_overall_total_grad

Long Integer

 

 

0

 

 

 

0

5

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

10

 

1

 

 

 

 

 

Cover duty

Database Value

Description

L

Light

M

Medium

H

Heavy

U

Unspecified

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

Database Value

Description

FIBRE

Fibre Glass

CEMENT

Cement

POLY

Polyethylene

O

Other

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

cover_material

Text

40

 

0

 

 

 

 

 

Hole diameter

MACP Coding Standard field

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

Size of manhole cover.

cover_dim

Double

 

MANH_DIM

0

 

 

 

0

9999

Cover dimension 2

Size of manhole cover.

cover_dim_2

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

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 manhole cover is hinged.

cover_hinged

Boolean

 

 

1

 

 

 

 

 

Cover locked

Check box indicating whether 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

 

 

 

 

 

Cover type solid

MACP Coding Standard field

cover_type_solid

Boolean

 

 

0

 

0

0

0

0

Cover type vented

MACP Coding Standard field

cover_type_vented

Boolean

 

 

0

 

0

0

0

0

Cover type gasketed

MACP Coding Standard field

cover_type_gasketed

Boolean

 

 

0

 

0

0

0

0

Cover type bolted

MACP Coding Standard field

cover_type_bolted

Boolean

 

 

0

 

0

0

0

0

Cover type inner cover

MACP Coding Standard field

cover_type_inner_cover

Boolean

 

 

0

 

0

0

0

0

Cover type locking

MACP Coding Standard field

cover_type_locking

Boolean

 

 

0

 

0

0

0

0
Cover type lamphole MACP Coding Standard field cover_type_lamphole Boolean     0          
Cover type hatch single MACP Coding Standard field cover_type_hatch_single Boolean     0          
Cover type hatch double MACP Coding Standard field cover_type_hatch_double Boolean     0          

Cover condition sound

MACP Coding Standard field

cover_condition_sound

Boolean

 

 

0

 

0

0

0

0

Cover condition cracked

MACP Coding Standard field

cover_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Cover condition broken

MACP Coding Standard field

cover_condition_broken

Boolean

 

 

0

 

0

0

0

0

Cover condition corroded

MACP Coding Standard field

cover_condition_corroded

Boolean

 

 

0

 

0

0

0

0

Cover condition bolts missing

MACP Coding Standard field

cover_condition_boltsmissing

Boolean

 

 

0

 

0

0

0

0

Cover condition missing

MACP Coding Standard field

cover_condition_missing

Boolean

 

 

0

 

0

0

0

0
Cover condition restraint missing MACP Coding Standard field cover_condition_restraint_miss Boolean     0          
Cover condition restraint defective MACP Coding Standard field cover_condition_restraint_defect Boolean     0          

Cover insert type

MACP Coding Standard field

cover_insert_type

Text

50

 

0

 

0

0

0

0

Insert condition sound

MACP Coding Standard field

insert_condition_sound

Boolean

 

 

0

 

0

0

0

0

Insert condition poorly fitting

MACP Coding Standard field

insert_condition_poorlyfitting

Boolean

 

 

0

 

0

0

0

0

Insert condition cracked

MACP Coding Standard field

insert_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Insert condition leaking

MACP Coding Standard field

insert_condition_leaking

Boolean

 

 

0

 

0

0

0

0

Insert condition insert fell

MACP Coding Standard field

insert_condition_insertfell

Boolean

 

 

0

 

0

0

0

0
Insert condition corroded MACP Coding Standard field insert_condition_corroded Boolean     0          

Adjustment ring type

MACP Coding Standard field

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 Polyethylene
PSC Plastic/Steel Composite
PVC Polyvinyl Chloride
S Steel
XXX Not Known
ZZZ 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.

 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

ring_condition_sound

Boolean

 

 

0

 

0

0

0

0

Ring condition broken

MACP Coding Standard field

ring_condition_broken

Boolean

 

 

0

 

0

0

0

0

Ring condition corroded

MACP Coding Standard field

ring_condition_corroded

Boolean

 

 

0

 

0

0

0

0

Ring condition cracked

MACP Coding Standard field

ring_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Ring condition leaking

MACP Coding Standard field

ring_condition_leaking

Boolean

 

 

0

 

0

0

0

0

Ring condition poor install

MACP Coding Standard field

ring_condition_poorinstall

Boolean

 

 

0

 

0

0

0

0

Seal condition sound

MACP Coding Standard field

seal_condition_sound

Boolean

 

 

0

 

0

0

0

0

Seal condition cracked

MACP Coding Standard field

seal_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Seal condition loose

MACP Coding Standard field

seal_condition_loose

Boolean

 

 

0

 

0

0

0

0

Seal condition offset

MACP Coding Standard field

seal_condition_offset

Boolean

 

 

0

 

0

0

0

0
Seal condition missing MACP Coding Standard field seal_condition_missing Boolean     0          

Frame material

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_DIM

0

 

0

0

0

0

Frame seal inflow

MACP Coding Standard field

frame_seal_inflow

Text

50

 

0

 

0

0

0

0

Frame condition sound

MACP Coding Standard field

frame_condition_sound

Boolean

 

 

0

 

0

0

0

0

Frame condition cracked

MACP Coding Standard field

frame_condition_cracked

Boolean

 

 

0

 

0

0

0

0

Frame condition broken

MACP Coding Standard field

frame_condition_broken

Boolean

 

 

0

 

0

0

0

0

Frame condition missing

MACP Coding Standard field

frame_condition_missing

Boolean

 

 

0

 

0

0

0

0

Frame condition corroded

MACP Coding Standard field

frame_condition_corroded

Boolean

 

 

0

 

0

0

0

0

Frame condition coated

MACP Coding Standard field

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 the choices defined in the Standards and Choice Lists dialog.

shaft_material

Text

40

 

0

 

 

 

 

 

Chimney material 1

MACP Coding Standard field

The options available in the dropdown list depend on which coding standard is being used for this network. 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 for this network. 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

9999

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

The options available in the dropdown list depend on which coding standard is being used for this network. 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 for this network. 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

cone_lining_interior

Text

50

 

0

 

0

0

0

0

Cone lining exterior

MACP Coding Standard field

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 for this network. 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 for this network. 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

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

wall_lining_exterior

Text

50

 

0

 

0

0

0

0

Number of steps

Number of steps installed in manhole.

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 the choices defined in the Standards and Choice Lists dialog.

step_material

Text

50

 

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

Grade to invert

MACP Coding Standard field

Distance or from average grade to invert of outgoing invert.

grade_to_invert

Double

 

MANH_DIM

0

 

0

0

0

0

Rim to grade

MACP Coding Standard field

Distance or from rim to average grade of outgoing invert.

rim_to_grade

Double

 

MANH_DIM

0

 

0

0

0

0

Channel installed

MACP Coding Standard field

channel_installed

Boolean

 

 

0

 

0

0

0

0

Channel material

MACP Coding Standard field

channel_material

Text

50

 

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 for this network. See the Standards and Choice Lists dialog for further information.

channel_type

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 for this network. 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 for this network. 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 for this network. 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 for this network. 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

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.

 manhole_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

surface_type_asphalt

Boolean

 

 

0

 

0

0

0

0

Surface type concrete pavement

MACP Coding Standard field

surface_type_concretepavement

Boolean

 

 

0

 

0

0

0

0

Surface type concrete collar

MACP Coding Standard field

surface_type_concretecollar

Boolean

 

 

0

 

0

0

0

0

Surface type grass dirt

MACP Coding Standard field

surface_type_grassdirt

Boolean

 

 

0

 

0

0

0

0

Surface type gravel

MACP Coding Standard field

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

Type of flow restriction used.

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

potential_for_runoff

Text

50

 

0

 

0

0

0

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

 

 

 

 

 

Main comment

Comment on condition of manhole.

main_comment

Text

40

 

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

2

 

 

 

 

 

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

2

 

 

 

 

 

Inspection cost

Estimated cost of asset inspection.

inspection_cost

Double

 

WN_COST

2

 

 

 

 

 

Replacement cost

The estimated cost for completely replacing an asset.

replace_cost

Double

 

WN_COST

2

 

 

 

 

 

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

 

 

 

 

999

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

 

 

 

 

 

Lateral US node ID

Reference ID of upstream node of pipe to which node is laterally connected.

lat_us_node_id

Text

40

 

0

 

0

0

0

0

Lateral DS node ID

Reference ID of downstream node of pipe to which node is laterally connected.

lat_ds_node_id

Text

40

 

0

 

0

0

0

0

Lateral link suffix

Link suffix of pipe to which node is laterally connected.

lat_link_suffix

Text

1

 

0

 

0

0

0

0
Lateral channel ID ID of channel to which node is laterally connected. lat_channel_id Text 40   0   0 0 0 0

Lateral distance from US node

The distance along a pipe from the start node of the pipe to the location of the lateral (hydrant, fitting etc.).

lat_distance

Double

 

L

2

 

0

0

0

0

Lateral circumferential location

Clock reference of position of node on pipe to which node is laterally connected.

lat_circ_location

Integer

 

 

0

 

0

0

0

0
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 Array                

Has photos

Check box indicating whether photos are associated with the node.

has_photos

Boolean

 

 

0

 

 

 

 

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

 tsdb_links                  

Nodes

Asset Grid