CCTV Survey Data Fields

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

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

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

Common Data Fields

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

See Viewing CCTV Video Data for further information on using this page.

CCTV Survey Data

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

id

Text

40

 

0

 

 

 

 

 

Start manhole

Manhole ID at start of survey.

start_manhole

Text

40

 

0

 

 

 

 

 

Finish manhole

Manhole ID at end of survey.

finish_manhole

Text

40

 

0

 

 

 

 

 

When surveyed

Survey date.

when_surveyed

Date / Time

 

 

0

 

 

 

 

 

Direction

Direction in which the survey was carried out.

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.

direction

Text

1

 

0

 

 

 

 

 

Split survey

Check box indicating whether the CCTV survey has been split. See Splitting CCTV Surveys for more information.

splitsurvey

Boolean

 

 

0

 

 

 

 

 

Split survey reference

ID of the CCTV survey from which the survey was created.

This field is used to identify CCTV surveys that have been created by splitting data and the raw data from which they have been created. See Splitting CCTV Surveys for more information.

splitsurveyref

Text

40

 

0

 

 

 

 

 

Current

Shows which surveys have been used to update the network. On update of the network from CCTV Surveys, the most recent survey for a pipe 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

 

 

 

 

 

Ignore for pipe updates

Ignore this CCTV survey when updating pipe condition from CCTV surveys. See Updating Pipe Condition from CCTV Data for further details.

ignore_for_updates

Boolean

 

 

0

 

0

0

0

0
Pipe not mapped

Indicates whether the pipe 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          
Pipe not surveyed

Indicates why the pipe 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          

US node ID

ID of the node upstream of the pipe surveyed.

us_node_id

Text

40

 

0

 

 

 

 

 

DS node ID

ID of the node downstream of the pipe surveyed.

ds_node_id

Text

40

 

0

 

 

 

 

 

Link suffix

Suffix of the pipe surveyed.

link_suffix

Text

1

 

0

 

 

 

 

 
Connection pipe ID ID of associated connection pipe. connection_pipe_id Text 40   0          

Standard

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
WSAA4 Water Service of Australia v4.1

SCREAM

CH2M Hill

OTHER

Other
NZWWA NZ Pipe Inspection Manual 3rd Edition
NZWWA4 NZ Pipe Inspection Manual 4th Edition
EN 13508-2:2003+A1:2011 EN 13508-2:2003+A1:2011

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

standard

Text

18

 

0

 

 

 

 

 

Original code

Details of the original code and coding system, where the code has been translated from an earlier version or another system.

orig_coding

Text

20

 

0

 

 

 

 

 

Scoring method

Method used to calculate CCTV scores and grades:

Database Value

Description

PACP

NASSCO PACP

LACP

NASSCO LACP

SCREAM

CH2M Hill SCREAM

SRM4

Sewer Risk Management 4th Edition

SRM5

Sewer Risk Management 5th Edition

WSAA

Water Service of Australia
WSAA2 Water Service of Australia v2.2
WSAA3 Water Service of Australia v3.1
WSAA4 Water Service of Australia v4.1
NZWWA New Zealand Pipe Inspection Manual
NZWWA4 New Zealand Pipe Inspection Manual v4

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

scoring_method

Text

100

 

0

 

 

 

 

 

Name of inspector

The name of the surveyor and surveyor's company.

surveyed_by

Text

25

 

0

 

 

 

 

 
Camera operator The name of the person responsible for recording the video inspection of the pipeline. camera_operator Text 40   0          

Contract no / job ref

Contract reference code.

contract_no

Text

15

 

0

 

 

 

 

 

Certificate number

Certificate reference code.

certificate_number

Text

15

 

0

 

 

 

 

 

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

Customer

The employer's job reference code.

customer

Text

40

 

0

 

 

 

 

 

Job number

Job reference number.

job_number

Text

15

 

0

 

 

 

 

 
Survey stage

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

 survey_stage Text 15   0          

Project

Project reference.

project

Text

64

 

0

 

 

 

 

 

Method of inspection

Database Value

Description
A Direct inspection

B

 Remote inspection
C Inspection chamber 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

 

 

 

 

 

Reverse setup

Indication of whether inspection was carried out by reversing up the line.

reverse_setup

Long Integer

 

 

0

 

 

 

 

 

Sheet number

Log sheet number.

sheet_number

Long Integer

 

 

0

 

 

 

 

 

Reviewer

The name of the person responsible for reviewing the survey.

reviewed_by

Text

60

 

0

 

 

 

 

 

Reviewer certificate number

The certificate number of the reviewer.

 reviewer_certificate_number

Text

15

 

0

 

 

 

 

 

Catchment / sewer name

The name of the sewer system of sewer system reference.

catchment

Text

20

 

0

 

 

 

 

 

Road name

Sewer location information.

road_name

Text

64

 

0

 

 

 

 

 

Place name

Sewer location information.

place_name

Text

64

 

0

 

 

 

 

 

Division / Land ownership

Ownership status of the land in which the sewer is located; e.g. public, private, unknown.

division

Text

255

 

0

 

 

 

 

 

PLR / asset ID

Pipe or asset reference code.

plr

Text

25

 

0

 

 

 

 

 

District

The name of the district in which sewer is located.

district

Text

20

 

0

 

 

 

 

 
Sewer name The name or identifier of the sewer. sewer_name Text 425   0          

Height

Pipe size.

size_1

Double

 

CAMS_PS

0

 

 

 

 

 

Width

Pipe size.

size_2

Double

 

CAMS_PS

0

 

 

 

 

 

Total length

Actual pipe length.

total_length

Double

 

L

3

 

 

 

 

 

US pipe unit length

The length of the construction units used in the pipe. (Also referred to as pipe joint length)

pipe_unit_length

Double

 

L

2

 

 

 

 

 

Pipe length

The length of the construction units used in the pipe. (Also referred to as pipe joint length)

pipe_length

Double

 

L

2

 

 

 

 

 
Parallel line

Identifier used to differentiate between two pipelines laid parallel between two consecutive manholes where pipeline assets are identified by the same manhole numbers.

 parallel_line Text 100   0          

Start depth

Depth of start manhole.

start_depth

Double

 

Y

2

 

 

 

 

 

Start cover

Cover level of start manhole.

start_cover

Double

 

Z

2

 

 

 

 

 

Start invert

Pipe invert at start of survey.

start_invert

Double

 

Z

2

 

 

 

 

 
Start asset type Type of asset at start of survey. start_asset_type Text 40   0          

US rim to invert

Distance between cover level and pipe invert level at upstream manhole.

rim_to_invert_U

Double

 

L

2

 

 

 

 

 

US grade to invert

Distance between ground level and pipe invert at upstream manhole.

grade_to_invert_U

Double

 

L

2

 

 

 

 

 

Longitudinal location

Longitudinal reference point.

long_location

Double

 

L

2

 

 

 

 

 

Longitudinal reference point

Method for longitudinal referencing

Database Value

Description
A

Inside face of start node wall where drain/sewer passes thro'
B

Soffit of end of pipeline length inside start node
C

Centre of start manhole or inspection chamber
D

Midpoint of in and outgoing pipes measured along channel
Z

Other

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

longitudinal_reference_point

Text

 

  

0

 

 

 

 

 

Finish depth

Depth of end manhole.

finish_depth

Double

 

Y

2

 

 

 

 

 

Finish cover

Cover level of end manhole.

finish_cover

Double

 

Z

2

 

 

 

 

 

Finish invert

Pipe invert at end of survey.

finish_invert

Double

 

Z

2

 

 

 

 

 
Finish asset type Type of asset at end of survey. finish_asset_type Text 40   0          

DS rim to invert

Distance between cover level and pipe invert level at downstream manhole.

rim_to_invert_D

Double

 

L

2

 

 

 

 

 

DS grade to invert

Distance between ground level and pipe invert at downstream manhole.

grade_to_invert_D

Double

 

L

2

 

 

 

 

 

Shape

Pipe shape

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

15

 

0

 

 

 

 

 

Material

Pipe material

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.

material

Text

64

 

0

 

 

 

 

 

Lining type

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_type

Text

30

 

0

 

 

 

 

 

Lining

Lining material of pipe

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

Text

10

 

0

 

 

 

 

 

Coating method

The coating method can be specified by the user or selected from a dropdown list:

  • Cement Mortar
  • Coal Tar or Bituminous
  • Epoxy
  • Polyethylene
  • Polyurethane
  • Polyurea
  • Polyvinyl Chloride
  • Not Known
  • Other

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

coating_method

Text

40

 

0

 

 

 

 

 
Jointing method

WSAA4 coding standard field.

A description of the conduit jointing method.

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.

 jointing_method Text 50   0          
X coord

PACP/LACP coding standard field.

Easting - longitude at the centre point of the starting access point.

 x Double   XY 2          
Y coord

PACP/LACP coding standard field.

Northing - latitude at the centre point of the starting access point.

 y Double   XY 2          
Elevation

PACP/LAPC coding standard field.

Height at the centre point of the starting access point.

 elevation Double   Z 2          

Access point

PACP/LACP coding standard field.

A description or identifier of the starting access point.

access_point

Text

37

 

0

 

 

 

 

 
Inspection techology used cctv

A check box indicating that CCTV was used for inspection.

inspection_tech_used_cctv Boolean  

 

0

 

 

 

 

 
Inspection techology used laser A check box indicating that lasers were used as a method of inspection. inspection_tech_used_laser Boolean  

 

0

 

 

 

 

 
Inspection techology used sonar A check box indicating that acoustics were used as a method of inspection. inspection_tech_used_sonar Boolean  

 

0

 

 

 

 

 
Inspection techology used sidewall A check box indicating that sidewall technology was used as a method of inspection. inspection_tech_used_sidewall Boolean  

 

0

 

 

 

 

 
Inspection techology used zoom A check box indicating that a zoom inspection camera was used as a method of inspection. inspection_tech_used_zoom Boolean  

 

0

 

 

 

 

 
Inspection techology used other A check box indicating that another inspection method was used. inspection_tech_used_other Boolean  

 

0

 

 

 

 

 
Inspection status

The status of the inspection can be input by the user or selected from a list:

  • Buried and Marked
  • Complete Inspection
  • No Access
  • Does Not Exist
  • Not Found
  • Traffic
  • Not Opened
  • Surcharged/Debris

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

 inspection_status

Text

40

 

0

 

 

 

 

 
Consequence of failure

The consequence of CCTV inspection failure can be selected from a dropdown list or input by the user.

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

 

 

 

 

 
Upstream X coord Longitude at the center point of the Upstream Access Point (X Coordinate ). If specified, the Upstream Y coord and Coordinate system also be specified. us_x Double  

XY

2

 

 

 

 

 
Upstream Y coord Latitude at the center point of the Upstream Access Point (Y Coordinate). If specified, the Upstream X coord and Coordinate system must also be specified. us_y Double  

XY

2

 

 

 

 

 
Upstream elevation Height at the center point of the Upstream Access Point (Z Coordinate ). If a height is specified, the Vertical datum must also be specified. us_elevation Double  

Z

2

 

 

 

 

 
Downstream X coord Longitude at the center point of the Downstream Access Point (X Coordinate ). If specified, the Downstream Y coord and Coordinate system also be specified. ds_x Double  

XY

2

 

 

 

 

 
Downstream Y coord Latitude at the center point of the Downstream Access Point (Y Coordinate). If specified, the Downstream X coord and Coordinate system must also be specified. ds_y Double  

XY

2

 

 

 

 

 
Downstream elevation Height at the center point of the Downstream Access Point (Z Coordinate ). If a height is specified, the Vertical datum must also be specified. ds_elevation Double  

Z

2

 

 

 

 

 
Coordinate system Datum or reference system used for the gps coordinates. coordinate_system Text 50   0          
Vertical datum A specific geodetic system used for the gps vertical or Z coordinate. If a system is specified then the Upstream Elevation or Downstream Elevation fields must also be specified. vertical_datum Text 50

 

0

 

 

 

 

 
GPS accuracy

Description of accuracy obtained from coordinates:

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          
Parent CCTV Inspection ID LACP coding standard field. parent_cctv_survey_id Text 40   0

 

 

 

 

 
Lateral segment reference LACP coding standard field. lateral_ segment_ reference Text 40   0

 

 

 

 

 
Property line LACP coding standard field. property_line Double   L 2

 

 

 

 

 
Clean out LACP coding standard field. clean_out Text 40   0

 

 

 

 

 
Clean out rim invert LACP coding standard field. clean_out_rim_invert Double   L 2

 

 

 

 

 
Tap location LACP coding standard field. tap_location Double   L 1

 

 

 

 

 
Building address Address of the building. building-address Text 255   0

 

 

 

 

 
Lateral clock position

The lateral pipe connection described as a position on a clock face.

The outer edge of the main pipe is represented by a 12 hour clock face, where 12 is a soffit position and 6 an invert position.

 lateral_clock_loc Text 30   0          
Lateral node reference A reference or description of the lateral node. lateral_node_ref Text 225   0          
Lateral node X coord The X coordinate for the lateral node. lateral_node_x Double   XY 2          
Lateral node Y coord The Y coordinate for the lateral node. lateral_node_y Double   XY 2          
Lateral start position

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.

 lateral_start_point Text 30   0          

Year laid

Approximate year of pipe installation.

year_laid

Text

9

 

0

 

 

 

 

 

Year renewed

Approximate year of pipe renewal.

year_renewed

Long Integer

 

 

0

 

 

 

 

 

Category code / sewer type

Sewer category. Usually A, B or C for sewer criticality.

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.

category_code

Text

3

 

0

 

 

 

 

 

Sewer use

The type of drain or sewer system.

use

Text

15

 

0

 

 

 

 

 

Surveyed length

Distance traversed along pipe by survey camera.

surveyed_length

Double

 

L

3

 

 

 

 

 
Anticipated length Distance that the survey camera is expected to traversed along the pipe. anticipated_length Double   L 3          

Strategic

Code or description of how strategic the pipeline is to the system.

strategic

Text

5

 

0

 

 

 

 

 

Flow control

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

 

 

 

 

 

Pipe type

Type of pipe.

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

 

 

 

 

 

Pressure value

MACP coding standard field.

Grouting pressure value.

pressure_value

Double

 

 

3

 

 

 

 

 

Inspection purpose

The purpose of the 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.

purpose

Text

64

 

0

 

 

 

 

 

Location type

Location of surveyed pipe.

location

Text

100

 

0

 

 

 

 

 

Location details

Additional information about the location.

location_details

Text

50

 

0

 

 

 

 

 

Comments

Any additional comments.

comments

Text

255

 

0

 

 

 

 

 
Pipe status

Description of status of pipe:

Database Value

Description
OC Original condition
RC Rehabilitated condition

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

 pipe_status Text 40              
Wall thickness Thickness of the pipe wall. wall_thickness Double   PS 0          
Connector type

The type of connector.

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

 connector_type Text                

Gas detected

Check box indicating whether a potentially hazardous atmosphere was detected.

gas_detected

Boolean

 

 

0

 

 

 

 

 

Pre-clean

Check box indicating whether the drain or sewer was cleaned prior to the survey.

preclean

Boolean

 

 

0

 

 

 

 

 

Pre-clean choice

Method of cleaning undertaken prior to time of 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.

preclean_choice

Text

15

 

0

 

 

 

 

 

Weather

Weather conditions at the time of the 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.

weather

Text

12

 

0

 

 

 

 

 

Temperature

Temperature or temperature code at time of survey.

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

temperature

Text

3

 

0

 

 

 

 

 
Road material

The main type of material used for the road.

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

 road_material Text 64   0          

Date cleaned

The date the asset last underwent maintenance to improve performance (swabbing, scouring).

date_cleaned

Date / Time

 

 

0

 

 

 

 

 
Location risk factor

WSAA4 coding standard field.

The risk factors associated with the location of the conduit.

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.

 location_risk_factor Text 50   0          
Tidal influence

WSAA4 coding standard field.

The influence that the tidal level may have on the conduit.

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.

 tidal_influence Text 50   0          

Photo storage

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

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.

photo_storage

Text

1

 

0

 

 

 

 

 

Photo reference

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

photo_reference

Text

10

 

0

 

 

 

 

 

Video storage

Type of media used for storing CCTV video images.

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.

video_recorder

Text

255

 

0

 

 

 

 

 

Video location

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

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.

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

 

 

 

 

 

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 CCTV 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 CCTV surveys. (See Viewing CCTV Video Data.)

video_file_in

Text

255

 

0

 

 

 

 

 
Video start time Video record run time at start of inspection. video_start_time Text 20              
Video end time Video record run time at end of inspection. video_end_time Text 20              
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          
Cleaning activity

The type of cleaning.

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

 cleaning_activity 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              
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          
Client present

Indicates whether or not the client was present during the cleaning operation.

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

Indicates the quality of the cleaning operation.

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

 cleaning_checked Text 255   0          
Landfill reference A description of any landfill used. landfill_ref Text 255   0          
Access for cleaning at start node

The options displayed in the dropdown list may be used to indicate accessibility.

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

 cleaning_access_start Text 255   0          
Access for cleaning at finish node The options displayed in the dropdown list may be used to indicate accessibility.

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

 cleaning_access_finish Text 255   0          

Details

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Click the button to display the Defects section.

Database Table Name: cams_cctv_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 Upper Limit

1

Video No

Time (in seconds) from start of video

video_no

Double

 

 

 

0

 

 

 

2

Photo No

External reference to photo

photo_no

Text

64

 

 

0

 

 

 

3

Distance

Distance along pipe

distance

Double

 

L

 

0

 

 

 

4

CD

Continuous Defect code

cd

Text

3

 

 

0

 

 

 

5

Code

Defect code

The options displayed in the defect code choice list will depend on the CCTV standard being used.

See the Standards and Choice Lists dialog for further information.

code

Text

12

 

 

0

 

 

 

6

Video File

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

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

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

    or

  • InfoAsset Video File field of the survey

See Viewing CCTV Video Data.

video_file

Text

255

 

 

0

 

 

 

7

Dimension 1

Defect size

diameter

Double

 

 

 

0

 

 

 

8

Joint

Check box indicating whether defect occurs at a joint

Joint

Boolean

 

 

 

 

 

 

 

9

Clock At

Defect location

clock_at

Long Integer

 

 

 

0

12

 

 

10

Clock To

Defect location

clock_to

Long Integer

 

 

 

0

12

 

 

11

%

Intrusion fraction

percentage

Double

 

 

 

0

 

 

 

12

Dimension 2

Intrusion distance

intrusion

Double

 

 

 

0

 

 

 

13

Remarks

Further details describing defect

remarks

Text

255

 

 

0

 

 

 

14

Band

Characterisation code to further describe defect

characterisation1

Text

3

 

 

0

 

 

 

15

Material

Characterisation code to further describe defect

characterisation2

Text

3

 

 

0

 

 

 

17

Video Time

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

video_no2

Text

12

 

 

0

 

 

 

18

Service Score/O M Grade

Service condition index for defect. Calculated when calculating manhole scores using the applicable manhole scoring standard

service_score

Double

 

 

 

0

 

 

 

19

Structural Score

Structural condition index for defect

structural_score

Double

 

 

 

0

 

 

 

20

Char 3

A characterisation code used in the RibX standard

characterisation3

Text

20

 

 

0

 

 

 

details

Array

 

 

0

 

 

 

 

 
Pipe repairs Click the button to display the Repairs editor, used to view repairs associated with the CCTV survey.                    

Structural override grade

Structural condition index used to override calculated grades based on engineering expertise. If set, this field is used when updating pipe condition.

structural_override_grade

Text

1

 

0

 

 

 

 

 

Service override grade

Service condition index used to override calculated grades based on engineering expertise. If set, this field is used when updating pipe condition.

service_override_grade

Text

1

 

0

 

 

 

 

 

Structural total score

Sum of structural defect indices along the surveyed pipe

total_score

Double

 

 

1

 

 

 

 

 

Structural peak score

Peak structural condition index.

peak_score

Double

 

 

1

 

 

 

 

 

Structural mean score

Mean structural condition index.

mean_score

Double

 

 

2

 

 

 

 

 

Structural grade

Structural condition index on a scale of 1-5.

hard_wired_structural_grade

Text

1

 

0

 

 

 

 

 

Service total score

Sum of service defect indices along the surveyed pipe.

service_total_score

Double

 

 

1

 

 

 

 

 

Service peak score

Peak service condition index.

service_peak_score

Double

 

 

1

 

 

 

 

 

Service mean score

Mean service condition index.

service_mean_score

Double

 

 

2

 

 

 

 

 

Service grade

Condition index on a scale of 1-5.

hard_wired_service_grade

Text

1

 

0

 

 

 

 

 
Likelihood score

Estimated likelihood of failure. Calculated as part of the CCTV scoring process.

Score of 1-5, where 1 is low risk and 5 is high risk.

A linear interpolation that allows for a finer grain of the structural score, allowing users to see differences between many grade 4s, for example.

 likelihood_score Double     3          
Profile window size Window size for the condition grade profile. scoring_window_size Double                
Grade 1 percent Percentage of pipe rated at grade 1 due to defects. structural_grade_1_percent Double                
Grade 2 percent Percentage of pipe rated at grade 2 due to defects. structural_grade_2_percent Double                
Grade 3 percent Percentage of pipe rated at grade 3 due to defects. structural_grade_3_percent Double                
Grade 4 percent Percentage of pipe rated at grade 4 due to defects. structural_grade_4_percent Double                
Grade 5 percent Percentage of pipe rated at grade 5 due to defects. structural_grade_5_percent Double                

Overall rating

Overall rating score using PACP condition grading system.

pacp_overall_rating

Long Integer

 

 

0

 

 

 

 

 

Overall quick rating

PACP quick overall rating.

pacp_overall_quick_rating

Text

6

 

0

 

 

 

 

 

Overall ratings index

Overall ratings index using PACP condition grading system.

pacp_overall_index_rating

Double

 

 

6

 

 

 

 

 

Structure rating

Structural rating score using PACP condition grading system.

pacp_struct_rating

Long Integer

 

 

0

 

 

 

 

 

Structure quick rating

PACP quick structural rating calculated from structural defect grades.

pacp_struct_quick_rating

Text

6

 

0

 

 

 

 

 

Structure ratings index

Structural ratings index using PACP condition grading system.

pacp_struct_index_rating

Double

 

 

6

 

 

 

 

 

O and M rating

Operation and maintenance rating score using PACP condition grading system.

pacp_oandm_rating

Long Integer

 

 

0

 

 

 

 

 

O and M quick rating

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

pacp_oandm_quick_rating

Text

6

 

0

 

 

 

 

 

O and M ratings index

Operation and maintenance index using PACP condition grading system.

pacp_oandm_index_rating

Double

 

 

6

 

 

 

 

 

Pipe internal score

Pipe internal condition index using CH2M HILL SCREAM™ condition grading system.

CH2MHill_score

Double

 

 

2

 

 

 

 

 

Structural defect score

Structural condition score using CH2M HILL SCREAM™ condition grading system.

CH2MHill_struct_score

Double

 

 

2

 

 

 

 

 

Maintenance defect score

Maintenance condition score using CH2M HILL SCREAM™ condition grading system.

CH2MHill_maint_score

Double

 

 

2

 

 

 

 

 

Pipe internal grade

Pipe internal condition score using CH2M HILL SCREAM™ condition grading system.

CH2MHill_grade

Text

2

 

0

 

 

 

 

 

Structural grade

Structural condition index using CH2M HILL SCREAM™ condition grading system.

CH2MHill_struct_grade

Text

2

 

0

 

 

 

 

 

Maintenance grade

Maintenance condition index using CH2M HILL SCREAM™ condition grading system.

CH2MHill_maint_grade

Text

2

 

0

 

 

 

 

 
Scheduled Task fields See Common Data Fields - Scheduled Task fields for details of all fields in the Schedule Info, Progress Info and Resources sections of the property sheet.                    

Survey index

Number used to distinguish multiple surveys of the same pipe.

index

Long Integer

 

 

0

 

 

 

 

 
Attachments

Click the button to display the Attachments Editor, used to attach and manage photos, sketches and other files associated with the network object.

See Attachments Editor and Common Data Fields for further details.

 attachments                  
General properties fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties fields See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.                    

 

Renaming Additional User Fields

Survey Grid

Creating a CCTV Survey

Network Data Fields

Common Data Fields