You are here: Tutorials > Geological Database > Geological database tutorial
GEOVIA Surpac

Geological database tutorial

Introduction

Overview

Requirements

Workflow

Geological database concepts

Setting up for this tutorial

Task: Set the work directory

Task: Display the menu bar and toolbar

Creating a DTM

Task: Create a DTM - graphics-based method

Task: Create a DTM - file-based method

Task: Create a DTM from spot height data

Task: Create a DTM using breaklines and spot heights

Creating a Surpac geological database

Creating a new database

Task: Create a database

Connecting to an existing database

Task: Connect to an existing database

Task: Map tables from the existing to the new database

Connecting to a Surpac database

Task: Connect to a Surpac database

Importing and viewing data

Task: Import data from text files

Task: View data in a table with constraints

Display drillholes

Task: Display drillholes

Task: Apply styles to drillholes

Manipulate drillholes

Task: Display cylinders

Task: Display lithological codes on the right-hand side

Task: Display assays on the left-hand side

Task: Display colour-filled bar graphs of gold assays on the left-hand side

Drillhole investigation and interrogation

Identify drillhole

Task: Run identify drillhole

Graphically edit drillhole

Task: Run edit drillhole

Drillhole sections

Creating sections graphically

Task: Create sections graphically

Advanced cross-sectional viewing

Task: Create sections including DTMs and 3DMs

Creating regular sections

Task: Create regular sections

Digitising an ore outline

Task: Digitise an ore outline

Flagging an interval table

Task: Flag an interval table

Determining the grade of a digitised segment

Task: Determine the grade of a digitised segment

Section plotting

Creating a simple section plot

Task: Create a simple section plot

Creating a section plot with a plan strip

Task: Create a section plot with a plan strip

Creating and plotting oblique sections of drillhole data

Task: Create and plot an oblique section of drillhole data

Creating multiple section plots

Task:  Create multiple section plots

Creating a title block for multiple section plots

Task: Create a title block for multiple section plots

Creating multiple section plots with title blocks

Task:  Create multiple section plots with a title block

Creating and plotting a sectional fence diagram

Task: Create a plot using a sectional fence diagram

Compositing

Compositing by elevation

Task: Perform composite by elevation

Compositing downhole

Task: Perform composite downhole

Compositing downhole constrained by intercept table

Task: Perform composite downhole constrained by intercept table

Compositing graphical

Task: Perform composite graphical

Creating a composite report

Task: Create a composite report

Domains

A Simple Example

Task: View Domains in Surpac

Extracting Data with a Domain in Surpac

Task: Extract Data with a Domain in Surpac

Basic Statistics

The Histogram

Bimodal Distributions

Outliers

Displaying Histograms in Surpac

Task: Display Histogram

Removing Outliers in Surpac

Task: Remove Outliers