Surpac ids block software#

Survey tableThe survey table stores the drill hole survey information used to calculate the drill hole tracecoordinates. Themandatory fields in a collar table are shown as follows: For example, date drilled, type of drillhole, or project name. Optional collar data can also be stored for each drill hole. Surpac requires twomandatory tables within a database: collar and survey.Р”В¬ollar tableThe information stored in the collar table describes the location of the drill hole collar, themaximumdepth of the hole, and whether a linear or curved hole trace will be calculated when retrieving thehole. A database can contain up to 50 tables and each tablecan have a maximum of 60 fields. Surpac also supports Open Database Connectivity (ODBC) andcan connect to databases across networks. Surpac uses a relational databasemodel and supports several different types of databases, includingOracle, Paradox and Microsoft Access. Each table also has many records, with each recordcontaining the data fields. Geological database conceptsThe Geological Databasemodule in Surpac is an important area of functionality when you areconducting feasibility studies, or want to perform estimations fromdrillhole data.Р”Р„ geological database consists of a number of tables, each of which contains different types of data.Each table contains a number of fields. Note: This workflow demonstrates the steps in this tutorial. L Surpac 6.1 or later installed on your computerl the data set accompanying this tutorial L basic knowledge of SurpacIt is recommended that you understand the procedures and concepts from theIntroduction tutorial. RequirementsBefore you begin this tutorial, you must have: OverviewThis document introduces the theory behind geological database processes and provides detailedexamples using the geological databasemodelling functions in Surpac.By working through thistutorial you will gain skills in the creation, use, and modification of geological databases. Task: Extract data with a domain in Surpac 121 Task: Perform composite downhole constrained by intercept table 109Р”В®xtracting data with a domain in Surpac 121 Task: Createmultiple section plots with a title block 97Р”В¬ompositing downhole constrained by intercept table 109 Task: Create a title block for multiple section plots 95Р”В¬reating multiple section plots with title blocks 97 Task: Create and plot an oblique section of drillhole data 82Р”В¬reating a title block for multiple section plots 95 Task: Create a section plot with a plan strip 79Р”В¬reating and plotting oblique sections of drillhole data 82 Task: Determine the grade of a digitised segment 70Р”В¬reating a section plot with a plan strip 79 Task: Create sections including DTMs and 3DMs 58Р”Вetermining the grade of a digitised segment 70 Task: Display colour-filled bar graphs of gold assays on the left-hand side 52Р”Вrillhole investigation and interrogation 53 Task: Display assays on the left-hand side 51 Task: Display lithological codes on the right-hand side 49 Task: View data in a table with constraints 41 Task: Map tables from the exiting to the new database 30 Task: Create a DTM using breaklines and spot heights 21 Task: Create a DTM from spot height data 18 Task: Create a DTM graphics-based method 13

Surpac ids block software#

Gemcom Software International Inc., Gemcom, the Gemcom logo, combinations thereof, andGEMS, Surpac, Minex, MineSched, Whittle, PCBC, Gemcom InSite, and Gemcom Hub aretrademarks of Gemcom Software International Inc. Neither will be held liable for any damagescaused or alleged to be caused from the use of the information contained herein. While every precaution has been taken in the preparation of this manual, neither the authors norGemcom assumes responsibility for errors or omissions. Changes may bemade in products or services atany timewithout notice. For such permission, or to obtain extra copies please contact yourlocal Gemcom office, or visit This software and documentation is proprietary to Gemcom and, except where expressly providedotherwise, does not form part of any contract. Without written permission, you may not sell, reproduce, store in a retrieval system, or transmitany part of this documentation. Gemcom publishes this documentation for the sole use of Gemcom licensees. Copyright 2012Gemcom Software International Inc.