Defence Area Data Fields

Defence area objects are used to represent sea defence structures such as salt marshes, beaches or dunes.

Defence area data can be edited on either the Defence Area Grid Window of the Asset Grid or the Defence Area Property Sheet.

To view and edit all Defence Area data, use the Property Sheet.

The following describes all the data which can be used to define a defence area.

Common Data Fields

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

Defence Area Data

Database Table Name: cams_defence_area

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

The name of the object.

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

id

Text

40

 

0

 

 

 

 

 

Type

Type of area:

Database Value

Description

Salt Marsh

Salt Marsh

Beach

Beach

Dunes

Dunes

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

type Text 10   0          
Name Name of area. name Text 200   0          

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

Maintained by

Database Value

Description

Maintainer 1 Maintainer 1
Maintainer 2 Maintainer 2

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

maintained_by Text 64   0          

Operational status

Current operational status:

Database Value

Description

AB Abandoned
INUSE In Use
STANDBY Standby

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

status

Text

10

 

1

 

 

 

 

 

Location Description of location of area. location Text 100   0          

X coordinate

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Alternative asset reference Asset reference used by the inspecting organisation. asset_id Text 40   0          
Asset category

Category of asset as defined in AIMS, which can be selected from the dropdown list.

Database Value

Description

DEFENCE Defence

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

asset_category Text 40   0          
Height Height of defence area. height Double   Y 1          

Width

Width of defence area.

width

Double

 

XY

1

 

 

 

 

 

Depth

Depth of defence area.

depth

Double

 

Y

1

 

 

 

 

 

Material

Type of material:

Database Value

Description

Material 1 Material 1
Material 2 Material 2

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

material Text 64   0          
Area Area of defence area. area Double   NA 3          
Primary purpose

The main purpose of the asset, i.e. the main reason it was constructed (a natural asset may have an asset management purpose), can be selected from a dropdown.

Database Value

Description

BS Business Support
C Conservation
EM Environment Management
EP Erosion Protection
FISHERIES Fisheries
FLOODRISK Flood Risk Management
H&S Health and Safety
HIGHWAYS Highways
LEGAL Legal / Statutory
LEISURE Leisure and Amenity
NAVIGATION Navgation
POLLUTION Pollution Control
WATERLEVEL Water Level Management
WATERIES Water Resources

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

primary_purpose Text 40   0          
Alternative purpose An alternative purpose of the asset, ie. a reason it was constructed (a natural asset may have an asset management purpose), can be selected from a dropdown. See Primary purpose for the list of options. alternative_purpose Text 40   0          
Operator The organisation or private individual recognised to be the operator of the asset. operator Text 25   0          

Condition grade

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

condition_grade

Long Integer

 

 

0

 

 

 

 

 

Condition survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

 

 

0

 

 

 

 

 

Construction date

Construction or installation date. This is date from which depreciation costs will be incurred for depreciation reports.

constr_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

 

 

 

 

 

Manual override Used for altering the condition grade of an element in case of 'Element Not Inspected' (ENI) because a previous inspection grade is still valid. Alternatively, for downgrading the condition grade of the asset where a 9-weighted element is in poorer condition than the calculated condition. man_override Text 25   0          
Urgency of repair/maintenance works Urgency of work. repair_urgency                  

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

 

 

 

 

 

Inspection cost

Estimated cost of asset inspection.

inspection_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

 

 

 

 

 

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

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

tsdb_links                  
Network Data Fields

Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.

Defence Area

Asset Grid