Figure
5.2 Worked Example – Construction data using standard data model
Groundwater
Feature:
|
feature_
identifier
|
R99999
|
|
name
|
CENTRIC
AUSTRALIS NO 1 BORE
|
|
type
|
BOR
|
|
owner
|
SPRINGS,
ALICE
|
|
owner_type
|
PIN
|
|
owner_date
|
30-JUN-1998-00:00:00
|
|
owner_date_
reliability
|
DAY
|
|
locator
|
UNK
|
|
total_length
|
240.0
|
|
host_identifier
|
|
|
precursor_
identifier
|
|
|
comments
|
|
Site:
|
feature_
identifier
|
R99999
|
|
latitude
|
-25.610
|
|
longitude
|
134.355
|
|
method
|
MAP
|
|
error
|
100
|
|
bibliographic_source
|
NATMAP
1971, SHEET 5746, 1ST EDN. 1:100000 SCALE NATIONAL TOPOGRAPHIC SERIES.
DIVISION OF NATIONAL MAPPING
|
|
scale
|
100000
|
|
person
|
|
|
organisation
|
NORTHERN
TERRITORY DEPARTMENT LANDS PLANNING AND ENVIRONMENT
|
|
siting_date
|
30-JUN-1998-00:00:00
|
|
siting_date_
reliability
|
DAY
|
|
azimuth
|
|
|
dip
|
90
|
|
directions
|
ABOUT
250 METRES NORTHWEST OF THE ECHIDNA RETREAT HOMESTEAD, 15 KILOMETRES
ALONG THE OVERLAND TELEGRAPH ROAD FROM FINKE
|
|
comments
|
|
Datum
Planes:
|
feature_
identifier
|
R99999
|
|
datum_
number
|
1
|
|
type
|
NGS
|
|
elevation
|
260
|
|
error
|
10
|
|
method
|
MAP
|
|
datum_
to_ground
|
0
|
|
bibliographic_source
|
NATMAP
1971, SHEET 5746, 1ST EDN. 1:100000 SCALE NATIONAL TOPOGRAPHIC SERIES.
DIVISION OF NATIONAL MAPPING
|
|
scale
|
100000
|
|
contour_interval
|
20
|
|
contour_interval_unit
|
M
|
|
person
|
|
|
organisation
|
NORTHERN
TERRITORY DEPARTMENT LANDS PLANNING AND ENVIRONMENT
|
|
establish_date
|
05-MAR-1998-00:00:00
|
|
establish_date_reliability
|
DAY
|
|
measure_date
|
30-JUN-1998-00:00:00
|
|
measure_date_reliability
|
DAY
|
|
comments
|
|
Localities:
|
feature_
identifier
|
R99999
|
R99999
|
|
Locality_number
|
1
|
2
|
|
locality_identifier
|
5746
|
NT
|
|
type
|
100K
|
STA
|
|
bibliographic
_source
|
NATMAP
1971, SHEET 5746, 1ST EDN. 1:100000 SCALE NATIONAL TOPOGRAPHIC SERIES.
DIVISION OF NATIONAL MAPPING
|
|
|
locality
|
BEDDOME
|
NORTHERN
TERRITORY
|
|
relationship
|
IN
|
IN
|
|
azimuth
|
|
|
|
distance
|
|
|
|
organisation
|
NORTHERN
TERRITORY DEPARTMENT LANDS PLANNING AND ENVIRONMENT
|
NORTHERN
TERRITORY DEPARTMENT LANDS PLANNING AND ENVIRONMENT
|
|
locality_date
|
30-JUN-1998-00:00:00
|
30-JUN-1998-00:00:00
|
|
locality_date_reliability
|
DAY
|
DAY
|
|
comments
|
|
|
Construction
Elements:
|
feature_
identifier
|
R99999
|
|
person
|
MACDONNELL,
CHARLES
|
|
license
|
DR0001
|
|
organisation
|
EASIDRILL
|
|
start_date
|
05-MAR-1998-00:00:00
|
|
start_date_
reliability
|
ADAY
|
|
finish_date
|
15-MAR-1998-00:00:00
|
|
finish_date_
reliability
|
BDAY
|
|
construct_number
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
|
datum_number
|
1
|
1
|
1
|
1
|
1
|
1
|
1
|
|
interval_from
|
0
|
50
|
-0.3
|
-0.3
|
225
|
0
|
0
|
|
interval_to
|
50
|
240
|
50
|
240
|
238
|
50
|
200
|
|
type
|
VOID
|
VOID
|
CAS
|
CAS
|
SLC
|
SEAL
|
SEAL
|
|
cross_section
|
CIR
|
CIR
|
CIR
|
CIR
|
CIR
|
CIR
|
CIR
|
|
method
|
DRAG
|
CONE
|
|
|
|
|
|
|
material
|
|
|
STL
|
ABS
|
ABS
|
CMT
|
CMT
|
|
minimum_dimension
|
270
|
170
|
219
|
140
|
140
|
270
|
170
|
|
maximum_dimension
|
270
|
170
|
219
|
140
|
140
|
270
|
170
|
|
dimension_type
|
EXT
|
EXT
|
EXT
|
EXT
|
EXT
|
EXT
|
EXT
|
|
thickness
|
|
|
6.4
|
7.0
|
7.0
|
51
|
30
|
|
configuration
|
|
|
|
TEL
|
ILN
|
|
|
|
make
|
|
|
|
|
|
|
|
|
precursor_number(s)
|
|
|
|
|
4
|
|
|
|
comments
|
|
|
|
|
|
|
|
Construction
Element Properties:
|
feature_
identifier
|
R99999
|
R99999
|
R99999
|
R99999
|
R99999
|
|
construct_number
|
1
|
2
|
5
|
5
|
5
|
|
property
|
FLD
|
FLD
|
SLL
|
SLAP
|
SLD
|
|
value
|
|
|
150
|
5
|
8
|
|
description
|
MUD
|
MUD
|
|
|
|
|
qualifier
|
|
|
|
|
|
|
comments
|
|
|
|
|
|
Construction
Activities:
|
feature_
identifier
|
R99999
|
|
activity_number
|
1
|
|
person
|
MACDONNELL,
CHARLES
|
|
license
|
DR0001
|
|
organisation
|
EASIDRILL
|
|
start_date
|
05-MAR-1998-00:00:00
|
|
start_date_
reliability
|
ADAY
|
|
finish_date
|
15-MAR-1998-00:00:00
|
|
finish_date_reliability
|
BDAY
|
|
duration
|
0:1:30
|
|
problem
|
|
|
method
|
BWSH
|
|
success
|
|
|
comments
|
|
Status:
|
feature_
identifier
|
R99999
|
|
status_number
|
1
|
|
component
|
FET
|
|
component_number
|
|
|
type
|
PUR
|
|
status
|
DOM
|
|
reliability
|
INT
|
|
start_date
|
15-MAR-1998-00:00:00
|
|
start_date_
reliability
|
DAY
|
|
finish_date
|
|
|
finish_date_reliability
|
|
|
organisation
|
NORTHERN
TERRITORY DEPARTMENT LANDS PLANNING AND ENVIRONMENT
|
|
status
_date
|
30-JUN-1998
|
|
status_date_
reliability
|
DAY
|
|
comments
|
|
Groundwater
Sources:
|
feature_
identifier
|
R99999
|
R99999
|
R99999
|
|
source_number
|
1
|
2
|
3
|
|
datum_number
|
1
|
1
|
1
|
|
construct_number(s)
|
|
|
5
|
|
interval_from
|
70
|
226
|
225
|
|
interval_to
|
|
|
238
|
|
type
|
CUT
|
CUT
|
INL
|
|
aquifer(s)
|
|
|
|
|
comments
|
|
|
|
Events:
|
event_feature_
identifier
|
R99999
|
|
event_number
|
1
|
|
program
|
|
|
program_objective
|
|
|
activity_number
|
|
|
type
|
CONS
|
|
frequency
|
|
|
resolution
|
|
|
start_date
|
05-MAR-1998-00:00:00
|
|
start_date_
reliability
|
ADAY
|
|
finish
_date
|
15-MAR-1998-00:00:00
|
|
finish_date_reliability
|
BDAY
|
|
person
|
MACDONNELL,
CHARLES
|
|
organisation
|
EASIDRILL
|
|
client
|
SPRINGS,
ALICE
|
|
bibliographic_source
|
|
|
custodian
|
NORTHERN
TERRITORY DEPARTMENT LANDS PLANNING AND ENVIRONMENT
|
|
archive
|
PALMERSTON
NT 0831
|
|
format(s)
|
RDB
|
|
access
|
PUB
|
|
comments
|
|
Samples:
|
feature
_identifier
|
R99999
|
R99999
|
R99999
|
R99999
|
|
event_feature_identifier
|
R99999
|
R99999
|
R99999
|
R99999
|
|
event_number
|
1
|
1
|
1
|
1
|
|
sample_number
|
1
|
2
|
3
|
4
|
|
medium
|
CUT
|
GW
|
GW
|
GW
|
|
type
|
SITU
|
SITU
|
SITU
|
SITU
|
|
person
|
MACDONNELL,
CHARLES
|
MACDONNELL,
CHARLES
|
MACDONNELL,
CHARLES
|
MACDONNELL,
CHARLES
|
|
organisation
|
EASIDRILL
|
EASIDRILL
|
EASIDRILL
|
EASIDRILL
|
|
bibliographic_source
|
|
|
|
|
|
sample_method(s)
|
|
|
|
ARL
|
|
treatment(s)
|
|
|
|
|
|
sample_start_date
|
05-MAR-1998-00:00:00
|
05-MAR-1998-00:00:00
|
05-MAR-1998-00:00:00
|
05-MAR-1998-00:00:00
|
|
sample_start_date_reliability
|
ADAY
|
ADAY
|
ADAY
|
ADAY
|
|
sample_duration
|
|
|
|
0:1:30
|
|
datum_plane_
number
|
1
|
1
|
1
|
1
|
|
interval_from
|
0
|
|
|
|
|
interval_to
|
240
|
|
|
|
|
source_number
|
|
1
|
2
|
3
|
|
construct_number
|
|
|
|
|
|
comments
|
|
|
|
|
Parameters:
|
event_feature_
identifier
|
event_
number
|
parameter_
number
|
property
|
|
type
|
|
R99999
|
1
|
1
|
LTHD
|
LITHOLOGICAL
DESCRIPTION
|
FLD
|
|
R99999
|
1
|
2
|
SWL
|
STANDING
WATER LEVEL
|
FLD
|
|
R99999
|
1
|
3
|
DD
|
DRAW
DOWN
|
FLD
|
|
R99999
|
1
|
4
|
TASTE
|
TASTE
|
FLD
|
|
R99999
|
1
|
5
|
Q
|
DISCHARGE
|
FLD
|
|
R99999
|
1
|
6
|
COLOR
|
COLOUR
|
FLD
|
|
R99999
|
1
|
7
|
ROCK
|
ROCK
TYPE
|
FLD
|
|
R99999
|
1
|
8
|
SEDTX
|
SEDIMENTARY
TEXTURE
|
FLD
|
|
R99999
|
1
|
9
|
COMP
|
COMPOSITION
|
FLD
|
|
R99999
|
1
|
10
|
GRNS
|
GRAINSIZE
|
FLD
|
Results:
|
event_feature_
identifier
|
R99999
|
|
event_number
|
1
|
|
feature_
identifier
|
R99999
|
|
sample_
number
|
parameter_
number
|
result_
number
|
fraction_
number
|
interval_
from
|
interval_
to
|
value
|
description
|
|
1
|
1
|
1
|
|
0
|
7
|
|
WEATHERED
BROWN SHALE
|
|
1
|
1
|
2
|
|
7
|
27
|
|
BROWN
SHALE
|
|
1
|
1
|
3
|
|
27
|
60
|
|
BLUE-GREY
AND BROWN SHALE WITH BROWN PUGGY CLAY
|
|
1
|
1
|
4
|
|
60
|
85
|
|
BROWN
SHALE AND FERRUGINOUS SANDSTONE (SALINE WATER)
|
|
1
|
1
|
5
|
|
85
|
95
|
|
BROWN
AND BLUE GREY SHALE
|
|
1
|
1
|
6
|
|
95
|
157
|
|
BLUE
GREY SHALE
|
|
1
|
1
|
7
|
|
157
|
168
|
|
BLUE
GREY SHALE AND FINE GREY SILICEOUS SANDSTONE
|
|
1
|
1
|
8
|
|
168
|
225
|
|
BLUE
GREY SHALE
|
|
1
|
1
|
9
|
|
225
|
240
|
|
MEDIUM
TO COARSE BROWN QUARTZ SANDSTONE
|
|
4
|
2
|
10
|
|
|
|
13.5
|
|
|
4
|
3
|
11
|
|
|
|
1.5
|
|
|
2
|
4
|
12
|
|
|
|
|
SALT
|
|
3
|
4
|
13
|
|
|
|
|
FRES
|
|
4
|
4
|
14
|
|
|
|
|
FRES
|
|
4
|
5
|
15
|
|
|
|
6.3
|
|
|
sample_
number
|
parameter_
number
|
result_
number
|
fraction_
number
|
interval_
from
|
interval_
to
|
value
|
description
|
|
|
1
|
6
|
16
|
|
0
|
7
|
|
BR
|
BROWN
|
|
1
|
6
|
17
|
|
7
|
27
|
|
BR
|
BROWN
|
|
1
|
6
|
18
|
1
|
27
|
60
|
|
BL-GY+BR
|
BLUE-GREY
AND BROWN
|
|
1
|
6
|
19
|
2
|
27
|
60
|
|
BR
|
BROWN
|
|
1
|
6
|
20
|
1
|
60
|
85
|
|
BR
|
BROWN
|
|
1
|
6
|
21
|
|
85
|
95
|
|
BL-GY+BR
|
BLUE-GREY
AND BROWN
|
|
1
|
6
|
22
|
|
95
|
157
|
|
BL-GY
|
BLUE-GREY
|
|
1
|
6
|
23
|
1
|
157
|
168
|
|
BL-GY
|
BLUE-GREY
|
|
1
|
6
|
24
|
2
|
157
|
168
|
|
GY
|
GREY
|
|
1
|
6
|
25
|
|
168
|
225
|
|
BL-GY
|
BLUE-GREY
|
|
1
|
6
|
26
|
|
225
|
240
|
|
BR
|
BROWN
|
|
1
|
7
|
27
|
|
0
|
7
|
|
SHLE
|
SHALE
|
|
1
|
7
|
28
|
|
7
|
27
|
|
SHLE
|
SHALE
|
|
1
|
7
|
29
|
1
|
27
|
60
|
|
SHLE
|
SHALE
|
|
1
|
7
|
30
|
2
|
27
|
60
|
|
CLY
|
CLAY
|
|
1
|
7
|
31
|
1
|
60
|
85
|
|
SHLE
|
SHALE
|
|
1
|
7
|
32
|
2
|
60
|
85
|
|
SDST
|
SANDSTONE
|
|
1
|
7
|
33
|
|
85
|
95
|
|
SHLE
|
SHALE
|
|
1
|
7
|
34
|
|
95
|
157
|
|
SHLE
|
SHALE
|
|
1
|
7
|
35
|
1
|
157
|
168
|
|
SHLE
|
SHALE
|
|
1
|
7
|
36
|
2
|
157
|
168
|
|
SDST
|
SANDSTONE
|
|
1
|
7
|
37
|
|
168
|
225
|
|
SHLE
|
SHALE
|
|
1
|
7
|
38
|
|
225
|
240
|
|
SDST
|
SANDSTONE
|
|
1
|
8
|
39
|
2
|
27
|
60
|
|
PGGY
|
PUGGY
|
|
1
|
9
|
40
|
2
|
60
|
85
|
|
FER
|
FERRUGINOUS
|
|
1
|
9
|
41
|
2
|
157
|
168
|
|
SILI
|
SILICEOUS
|
|
1
|
9
|
42
|
|
225
|
240
|
|
QZ
|
QUARTZOSE
|
|
1
|
10
|
43
|
2
|
157
|
168
|
|
FS
|
FINE
SAND
|
|
1
|
10
|
44
|
|
225
|
240
|
|
MS-CS
|
MEDIUM
SAND-COARSE SAND
|
|