3.5 The CONSTRUCTION_ACTIVITY entity
|
A construction_activity is
|
During construction of a groundwater_feature such as a production bore, drilling fluids invade the surrounding aquifer resulting in reduced permeability and changes to groundwater chemistry. Bore development is a construction_activity undertaken to remove drilling mud and aquifer fines to optimise bore efficiency, stabilise the aquifer around the inlet and to control suspended solids. During the history of a groundwater_feature, both the volume of supply and groundwater quality may deteriorate. This may be due to blockages by chemical deposits or bacterial slime, or an accumulation of fines near the inlet. The bore may be reconditioned in an attempt to return groundwater supply or quality to normal. These episodes of bore rehabilitation are also construction_activities.
Table 3.6 Attributes of the construction_activity entity
|
Name |
Data Type |
Description |
|
feature_ identifier |
character |
unique identifier for groundwater_feature |
|
activity_number |
integer |
sequential number to uniquely define construction_activity for groundwater_feature in combination with feature_identifier |
|
person |
character |
name of person who undertook activity in format last name, first name middle name |
|
license |
character |
license identifier of person who undertook activity eg. driller license number |
|
organisation |
character |
name of organisation/company who undertook activity eg. drilling company |
|
start_date |
date |
date/time that activity started on groundwater_feature |
|
code |
reliability attached to date/time that activity started on groundwater_feature |
|
|
finish_date |
date |
date/time that activity was completed on groundwater_feature |
|
code |
reliability attached to date/time that activity finished on groundwater_feature |
|
|
duration |
character |
duration of construction activity in days:hours:minutes:seconds format |
|
code |
problem causing sub optimal groundwater supply or quality eg. scaling |
|
|
code |
method(s) used to treat problem eg. acid treatment |
|
|
success |
character |
indication of level of success of activity in improving groundwater supply |
|
comments |
character |
comments about construction_activity |
Each episode of works on a groundwater_feature is uniquely defined by the combination of feature_identifier and activity_number. Who completed the task is detailed by the attributes person, license and organisation, with when it was undertaken defined by the start_date and the finish_date. A method of treatment is applied to the problem with some indication of success.
|
