摘要
基于Surpac矿山管理系统,对某矿山铅锌矿床钻探数据进行了"映射式"Surpac数据库创建及数据库应用。通过分析Surpac数据库特征,在Microsoft Access系统中创建具有Surpac数据库特征的Access数据库;通过应用Surpac数据库映射功能,建立Access数据库与Surpac数据库之间的映射关系,实现Surpac地质数据库创建。与"导入式"Surpac数据库创建方式相比,有效提高了创建效率,且做到原始数据管理与软件应用系统分离,便于原始数据维护。应用Surpac功能模块,获得矿区钻孔、铅锌矿体三维可视化分布图,从中可以清楚显示钻孔ZK585～596、ZK601～607为控矿钻孔;获得矿体块体模型、品位模型、吨品位模型;以及矿体储量332类别矿石量和铅锌金属量等。
Based on Surpac mine management system,this paper establishes and analyses the "mapping" Surpac database for drilling data of a lead-zinc deposit in an example mine.By analyzing the characteristics of Surpac database,an Access database with Surpac database characteristics is created in Microsoft Access system.By using Surpac database mapping function,the mapping relationship between Access database and Surpac database is established,by which Surpac geological database is created.Compared with the "imported"method of creating Surpac database,this method can effectively improve the efficiency of creating database,separate the original data management from the software application system,and facilitate the maintenance of the original data.Applying Surpac function module,the three-dimensional visualized distribution maps of boreholes and lead-zinc orebodies in mining area can be obtained,from which boreholes NZD585-596and NZD601-607can be clearly displayed as ore-controlling boreholes;ore block model, grade model,tonnage grade model can be obtained;and ore reserves of 332-category and lead-zinc metal content can be obtained.
作者
王学平
张晓军
刘颖
彭振
Wang Xueping;Zhang Xiaojun;Liu Ying;Peng Zhen(Faculty of Earth Resources ,China University of Geosciences(Wuhan),Wuhan 430074,China;National Demonstration Center for Experimental Mineral Exploration Education,China University of Geosciences(Wuhan),Wuhan 430074,China)
出处
《地质科技情报》
CSCD
北大核心
2018年第6期232-238,共7页
Geological Science and Technology Information
基金
中国地质大学(武汉)实验技术研究项目"Surpac矿体建模及储量估算功能开发及其课程设计"(SJ-201503)
中国地质大学(武汉)教学改革研究项目"矿体建模及储量估算设计类实验课程建设"(2015B1)
作者简介
王学平(1964-),女,副教授,主要从事数学地质、地球探测与信息技术的教学和科研工作。E-mail:952096439@qq.com
