Effective Earth Science Data Management

guideflannelServers

Dec 4, 2013 (3 years and 6 months ago)

207 views

VIEWLOG Overview

Dirk Kassenaar

VIEWLOG Systems


VIEWLOG Systems

2

CAD/GIS

BH logs

Sample Results

Geophysical Data

Data Management System

Laboratory

Drill Site

Field
Crew

Mapping
Data

Reporting

Mapping
Data

Drill Site

Laboratory

Field Crew

Analysis

Analysis

Analysis

Analysis

Analysis

Reporting

Traditional Data Handling


Isolated data analysis


limited error trapping


duplicate data storage

DMS



integrated

data analysis


automated error trapping


single copy data storage

Merits of One Copy Storage

3

VIEWLOG DMS Component Overview

Open, SQL
-
based Relational Database

Log Editor

Mapping

Cross Sections

X
-
t Graphing

SQL Queries for Filtering, Processing and Analysis

Meta
-
Data

(contouring parameters, colors, etc.)

Data entry and
Reporting

3
-
D

4

DMS User Groups


Data Entry


Technicians


Scientists


Managers


Clients


VIEWLOG


Reporting
Module

Data Entry
Module

Open, SQL
-
based Relational Database

Component:

Web
Browser

5

VIEWLOG

Geologic Data Management System

6

VIEWLOG Design Goals


Integrated display and interpretation tools


GIS, with intelligent, geo
-
science based, data objects


Not just display,
but meaningful interaction with the
data


Scalable interpretation tools, from a single fracture to
an entire watershed


Open, flexible, database design, with dynamic
interaction with any table or query


Designed as a GIS/CAD companion tool


VIEWLOG Systems

7

Integrated Visualization & Analysis


VIEWLOG provides integrated
data management,
visualization and analysis

functions through the following
tools:


Well Editor


Map/Drawing Editor


Cross Section Editor


Real
-
time 3
-
D Visualization Module

8

Borehole Data Editor


Well Editor

used to dynamically integrate well
measurements, such as:


geology


geophysics


interval measurements


packer test results


fluid sample data


core photographs


Templates

ensure consistent standard presentations

9

Example Composite Borehole Log

Well Name: 34C
Elevation: 192.939 Reference: top of casing
Metres
Stratigraphy
Styolites
BPF
Vert. Fract.
Core Break
Dip
(degrees)
20
50
Borehole Dia.
(mm)
70
90
Temp
(Deg C.)
10.3
10.7
Gamma
(cps)
0
120
Cond.
(mS/m)
0
1
16 in Res
(Ohm-m)
0
10000
52 in Res
(Ohm-m)
0
10000
T - 0.5 m
(m^2/s)
1E-11
0.1
T - 2m
(m^2/s)
1E-11
0.1
190
180
170
160
150
Overburden
Eramosa
Vinemount Unit 2
Vinemount Unit 1
Goat Island(Marker Bed)
Goat Island
Gasport
Decew
Rochester
Stratigraphy

filtered from Major
Geology table in
database

Core Features

filtered from Minor
Geology table in
database

Geophysical Traces

filtered from geophysical
data files

K Data


filtered from Well Test table
in database

10

Assembly of Well Log Data

Minor Geology table

Major Geology table

Well Tests table

Geophysical Data files

Query A:

select corebreaks and
fractures

Query B:

select conductivity data

Query C:

select
stratigraphy

VIEWLOG

Well Name: 34C
Elevation: 192.939 Reference: top of casing
Metres
Stratigraphy
Styolites
BPF
Vert. Fract.
Core Break
Dip
(degrees)
20
50
Borehole Dia.
(mm)
70
90
Temp
(Deg C.)
10.3
10.7
Gamma
(cps)
0
120
Cond.
(mS/m)
0
1
16 in Res
(Ohm-m)
0
10000
52 in Res
(Ohm-m)
0
10000
T - 0.5 m
(m^2/s)
1E-11
0.1
T - 2m
(m^2/s)
1E-11
0.1
190
180
170
160
150
Overburden
Eramosa
Vinemount Unit 2
Vinemount Unit 1
Goat Island(Marker Bed)
Goat Island
Gasport
Decew
Rochester
Well Name: 34C
Elevation: 192.939 Reference: top of casing
Metres
Stratigraphy
Styolites
BPF
Vert. Fract.
Core Break
Dip
(degrees)
20
50
Borehole Dia.
(mm)
70
90
Temp
(Deg C.)
10.3
10.7
Gamma
(cps)
0
120
Cond.
(mS/m)
0
1
16 in Res
(Ohm-m)
0
10000
52 in Res
(Ohm-m)
0
10000
T - 0.5 m
(m^2/s)
1E-11
0.1
T - 2m
(m^2/s)
1E-11
0.1
190
180
170
160
150
Overburden
Eramosa
Vinemount Unit 2
Vinemount Unit 1
Goat Island(Marker Bed)
Goat Island
Gasport
Decew
Rochester
Composite Well logs

11

Interpretation at Various Scales

Zoom for detailed image of core

12

VIEWLOG Map Editor


Geologic objects (boreholes, units) are stored
as high level “intelligent” objects, with
integrated data, processing and display
properties


GIS style multi
-
layer working environment


DXF/CAD compatible


Page view / world view coordinates for
enhanced printing “viewport” control

13

Intelligent Map Objects

High level
map objects,
including:


Boreholes


Grids


Surfaces

retain links to
the source
data in the
database

14

Object Layering


Layering allows
overlying of air
photos, CAD
drawings, posted data
and kriged contours
for rapid analysis


Dual coordinate
(page/world) mapping
system with easy
Viewport window
control

15

VIEWLOG for Windows
Sample Cross Section
Decew Dolostone
Clayey Silt
Vinemount Shale
Goat Island Shale
Eramosa Dolostone
Goat Island Dolostone
Upper Vinemount Shale
Fill
MW 4-I
metres
190
188
186
184
182
180
178
176
174
Conductivity
0
40
(mS/m)
Gamma Ray
0
200
(cps)
MW 7-I
metres
200
198
196
194
192
190
188
186
184
182
Conductivity
0
40
(mS/m)
Gamma Ray
0
200
(cps)
BH 8-I
metres
202
200
198
196
194
192
190
188
186
184
182
180
178
176
174
172
170
Conductivity
0
40
(mS/m)
Gamma Ray
0
200
(cps)
MW 5-I
metres
194
192
190
188
186
184
Conductivity
0
40
(mS/m)
Gamma Ray
0
200
(cps)
MW 6-I
metres
200
198
196
194
192
190
188
186
184
182
Conductivity
0
40
(mS/m)
Gamma Ray
0
200
(cps)
MW 9-I
metres
200
198
196
194
192
190
188
186
184
182
Conductivity
0
40
(mS/m)
Gamma Ray
0
200
(cps)
VIEWLOG Systems
Date: Nov. 1995
Figure 1
West-East Cross Section
Units: metres
Bedrock Remediation Program
Cross Sections


All interpretation performed in true x,y,z coordinates


Dynamically change vertical exaggeration


Direct links to data objects makes section updates easy


Includes drawing layer control and dual coordinate (page/world)
system

16

Cross Section with Water Levels

193.14
193.01
193.06
192.88
193.05
193.00
193.00
193.00
191.30
191.30
191.30
191.30
191.30
191.30
191.30
191.30
192.72
192.92
192.95
193.03
192.66
192.66
192.99
193.03
193.03
193.00
193.00
193.07
193.07
193.07
193.07
193.07
193.60
193.60
192.83
192.83
192.83
192.83
192.83
192.83
192.84
192.84
192.84
192.84
192.84
192.84
194.00
194.00
193.15
193.15
192.87
192.11
192.11
192.15
192.15
191.32
191.32
191.35
191.86
191.86
191.97
191.97
192.80
192.79
192.71
192.94
192.89
193.00
193.14
193.66
193.15
193.15
193.15
193.10
193.10
193.10
192.96
192.96
192.96
193.19
192.59
192.59
192.13
192.48
193.29
194.60
191.37
191.28
191.28
191.28
185.85
184.05
184.76
185.68
184.16
184.11
186.39
185.24
184.90
184.34
185.56
188.25
185.97
184.13
184.59
184.50
184.55
184.60
184.81
183.71
183.72
183.70
183.05
183.61
184.01
182.18
182.76
185.50
184.82
186.60
186.45
184.43
184.53
184.44
184.69
184.70
184.22
1
10
12
13
14
15
16
17
18
19
2
20
22
23
24
25
26
27
28
29
3
30
31
32
35
36
37
38
39
4
40
45
46
48
5
51
7
8
9
RWS1
RWS2
RWS3
RWS4
RWS5
RWS6
RWS7
RWS8
1
10
12
13
14
15
16
17
18
19
2
20
22
23
24
25
26
27
28
29
3
30
31
32
35
36
37
38
39
4
40
45
46
48
5
51
7
8
9
RWS1
RWS2
RWS3
RWS4
RWS5
RWS6
RWS7
RWS8
0
500
1000
150
175
200
Geologic
Structure
krigged and
contoured from
well data

Boreholes along
cross section
line

Water table from
water level data
from all wells

Water
table
elevations

17

Geological Modelling

-7.0
-6.0
-6.0
-6.0
-5.0
-5.0
-5.0
-5.0
-4.0
-4.0
-4.0
-4.0
-4.0
-4.0
-3.0
-3.0
-3.0
-3.0
-3.0
-3.0
-2.0
-2.0
-2.0
6500233
6500242
6500255
6500261
6500264
6500266
6500270
6500279
6500282
6500287
6500288
6500319
6500320
6501434
6501537
6501554
6501570
6501611
6501669
6501672
6501673
6501674
6501675
6501676
6501677
6501678
6501679
6501680
6501681
6501682
6501683
6501688
6503042
6504005
6504313
6504869
6504870
6504871
6504872
6504873
6504874
6504877
6504878
6504879
6504880
6504881
6504883
6504884
6504956
6504957
6504993
6504994
6505087
1000405
1000473
1000474
1000476
1000512
1000589
1000590
1000591
1000592
1000593
1000594
1000595
1000596
1000597
1000655
6506923
6505923
6506435
6506726
6507189
6506079
6507027
6507028
6507029
6501690
6504959
6504882
6500299
6501652
6501612
6504149
6505078
6500263
6500283
5500005
5500006
5500007
5500008
5500009
5500010
5500012
5500017
5500020
5500022
5500024
5500025
5500026
5500030
East
West
Legend:
Aquifer Conductivity Contours
Earthfx Inc.
Date: Feb. 4, 1998
Figure
Geologic Modelling
Log Hydraulic Conductivity (m/s)
Log K = -1
Log K = -8
Unconfined Overburden Aquifer
Maryhill Clay Till Aquitard
Catfish Creek Till Aquifer (log K contoured)
Shale
Weathered Dolostone
Layers: (Top to Bottom)
0
5000
10000
15000
D is tance a long C ross Sec tion (m )
250
300
350
400
Elevation (mASL)
18

Krigging
Features

Contouring Controls



for map & cross section
views



contour intervals



colour formats



Grid / Krig Controls



grid construction



krigging order and
variogram slope control



19

3
-
D Visualization

20

3
-
D Transparent Layers

21

Interactive Cut
-
away Mode

22

Fence Diagrams

23

Integrated Flow Modelling

24

VIEWLOG Internet Server


A browser
independent,
VIEWLOG client


VIEWLOG runs as
an out
-
of process
ActiveX Server
using ASP and
Microsoft IIS 4.0

25

VIEWLOG Server: Sections


Web Server
includes full
support for cross
sections

26

VIEWLOG ActiveX Control


Control VIEWLOG as a programmable ActiveX object in other
applications

27

DMS Conclusions

28

Structure
:


Effective design of data storage structure


Tools:


Tools to merge all data streams for storage
and QA


Processing and analysis tools


Tools to retrieve, integrate and visualize
data

WHAT MAKES A DMS WORK?

29

Benefits of a VIEWLOG Data
Management System


One copy data storage for all users



Powerful searching tools to assemble data
sets for analysis and interpretation



Coordinated visualization tools necessary to
integrate

and interpret earth science data