Surface Source Data Fields

ID

A unique name for the asset. Upper and lower case letters are treated as being the same.

The ID is the primary key in the database for all objects. This means that the ID field must be unique for all objects of the same object type.

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

0

0

0

Owner

The proprietor of the asset.

owner

Text

64

0

Area code

The zone ID in which the asset is contained.

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

area_code

Text

40

0

Operational status

The current functionality of the asset:

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

operational_status

Text

20

0

Planning status

The current situation of the asset in relation to construction.

planning_status

Text

20

0

Location

Address or description of site at which asset is located.

location

Text

100

0

Lateral pipe ID

The ID of the pipe to which the lateral is attached.

lat_pipe_id

Text

40

0

0

0

0

Lateral distance from start 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

Elevation

Elevation above datum level (usually sea level).

elevation

Double

Z

0

0

0

0

X coord

X coordinate of the object.

x

Double

XY

2

Y coord

Y coordinate of the object.

y

Double

XY

2

Type

Type of surface source:

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

type

Text

32

0

Intake type

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

intake_type

Text

32

0

Capacity

Total volume of surface source.

capacity

Double

VO

2

Useful capacity

Storage volume of surface source that can be withdrawn for water supply purposes.

useful_capacity

Double

VO

2

Water surface area

water_surface_area

Double

NA

2

Catchment area

Area draining into the surface source.

catchment_area

Double

NA

2

Surface area

surface_area

Double

NA

2

Top water level

Maximum water level of the surface source (above datum).

top_water_level

Double

Z

2

Bottom water level

Minimum water level of the surface source (above datum).

bottom_water_level

Double

Z

2

Top draw off level

Maximum level (above datum) from which water from the surface source may be drawn.

top_drawoff_level

Double

Z

2

Bottom draw off level

Minimum level (above datum) to which surface source may be drawn down.

bottom_drawoff_level

Double

Z

2

Yield available for supply

Rate of flow available from surface source for water supply purposes.

yield_for_supply

Double

IN_Q

2

Date yield calculated

Date at which Yield available for supply value was calculated.

date_yield_calculated

Date / Time

0

Average annual daily supply

Average daily volume of water supplied by the surface source.

ave_daily_supply

Double

IN_Q

2

Average annual peak supply

Average daily volume of water supplied by the surface source under peak demand conditions.

ave_peak_supply

Double

IN_Q

2

Statutory max compensation flow

The maximum residual flow to be discharged into the water course to maintain the viability of the river downstream.

max_compensation_flow

Double

IN_Q

2

Statutory min compensation flow

The minimum residual flow to be discharged into the water course to maintain the viability of the river downstream.

min_compensation_flow

Double

IN_Q

2

Dam height

Height of surface source dam.

dam_height

Double

Y

2

Dam material

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

dam_material

Text

32

0

Dam construction

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

dam_construction

Text

32

0

Supervising engineer

Name of engineer responsible for site.

supervising_engineer

Text

32

0

Abstraction restraint

Abstraction limit details.

restraint

Text

32

0

Reason for restraint

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

reason

Text

32

0

Problem

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

problem

Text

32

0

Water quality waivers

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

quality_waivers

Text

32

0

Surface water classification

Classification category of surface source water.

surface_water_class

Text

32

0

Natural conservation designation

Nature conservation designation, for example, SSSI (Site of Special Scientific Interest).

conservation_designation

Text

32

0

Other designations

Details of designations assigned to surface source site, other than Natural conservation designation.

other_designations

Text

32

0

Contains groundwater

Check box indicating whether the surface source contains ground water.

contains_groundwater

Boolean

0

Recreation

Check box indicating whether the surface source is used for recreational activities.

recreation

Boolean

0

Natural conservation interest

Check box indicating whether the surface source is a site of nature conservation interest.

conservation_interest

Boolean

0

Archaeological interest

Check box indicating whether the surface source is within a site of archaeological interest.

arch_interest

Boolean

0

Rainfall data available

Check box indicating whether rainfall data has been recorded and is available for surface source.

rainfall_data

Boolean

0

Sporting rights

sporting_rights

Boolean

0

Condition grade

A measure of asset condition.

condition_grade

Long Integer

0

Critical

A measure of the likely impact of asset failure.

criticality

Text

5

0

Security

The security of the asset from unauthorised access/tampering:

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

security

Text

10

0

Condition survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

0

GPS survey date

The date of the most recent GPS survey (DD/MM/YYYY).

gps_survey_date

Date / Time

0

Date installed

The date when the asset was installed (DD/MM/YYYY). Used in costing reports in conjunction with the cost index.

date_installed

Date / Time

0

Date cleaned

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

date_cleaned

Date / Time

0

Date renewed

The date the asset was last restored to its initial condition (replaced, relined).

date_renewed

Date / Time

0

Installation cost

The original installation cost of the asset. This generally includes all costs incurred (e.g. mantime, asset purchase costs etc). This information is used in depreciation reports.

install_cost

Double

WN_COST

0

Inspection cost

Estimated cost of asset inspection.

inspection_cost

Double

WN_COST

0

Expected lifetime

The expected lifetime of the asset. This is used in depreciation reports as the period over which installation costs may be depreciated.

lifetime

Long Integer

0

Rehabilitation cost

Rehabilitation costs to be incurred in bringing the asset to an acceptable condition. This is used in rehabilitation reports.

rehab_cost

Double

WN_COST

0

Replacement cost

The estimated cost for completely replacing an asset.

replace_cost

Double

WN_COST

0

Current value

Current value of the asset. This gives an indication of depreciation costs as depreciation cost = installation cost - current value.

current_value

Double

WN_COST

2

Soil type

A description of the material surrounding the asset that could influence condition grading and rehabilitation methods:

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

soil_type

Text

10

0

Surface type

A description of the ground use in close proximity to the asset that may influence access/costs for monitoring, maintenance or construction purposes:

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

surface_type

Text

10

0

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

See Attachments Editor and Common Data Fields for further details.

Click the button to display the Time Series Data Source Grid, which is used to specify or update the time series data streams that are linked to this object.