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.
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
|
Field Name |
Help Text |
Database Field |
Size |
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:
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 |
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:
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:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
asset_category | Text | 30 | 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:
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, can be selected from a dropdown:
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 (a natural asset may have an asset management purpose), ie. a reason it was constructed, can be selected from a dropdown list. 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.
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 | Text | 25 | 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 |
|
|
|
|
|
||||||||||||||||||||||||||||||
|
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
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
|
tsdb_links |
button to display the
Network Data Fields: Further information about all the Network Object fields stored in the on-premise database can be found in the Network Data Fields section.