基于Surpac矿山地质数据库创建与应用
|
摘要
基于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-596 and NZD601-607 can 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.
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-596 and NZD601-607 can 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.
引文
[1]孟海东,盖泉贺.基于SURPAC的数据库及三维建模研究[J].内蒙古煤炭经济,2017(2):13-14.
[2] Sahoo M M,Pal B K.Geological modelling of a deposit and application using Surpac[J].Journal of Mines,Metals and Fuels,2017,65(7):417-422.
[3]王志亮,王继芳,李军.Surpac软件在归来庄金矿深部矿床资源量估算中的研究和应用[J].山东国土资源,2015,31(5):67-72.
[4] LiYingling,Gao Jianguo.Research and application of the 3D mathematic model of ore-body based on suppac software:Yunnan white cattle factory silver polymetallic mine[J].Advanced Materials Research,2014,868:84-87.
[5]张聪,程建忠,王润涛,等.基于Surpac的蒙古某铅锌矿地质数据研究[J].矿业工程,2013,11(3):62-63.
[6]朱未,赵廷严,王洋.基于Surpac软件的地质数据库研究[J].矿物学报,2013,33(增刊2):997-998.
[7]郭进,宦秉炼.基于Surpac的甘冲石灰石矿地质数据库研究及应用[J].云南冶金,2012,41(3):1-4.
[8] Huang Ping,Yang Peng,Liu Jie.Application of surpac vision software in Arhada lead and zinc mine[J].Advances in Information Sciences and Service Sciences,2012,4(8):178-186.
[9] Huang Ping,Yang Peng,Chen Yizhou,et al.Three-dimensional model of Cangshang gold mine based on surpac[J].International Journal of Advancements in Computing Technology,2011,3(11):299-306.
[10]GEMCOM SURPAC国际软件公司.Surpac地质数据库[R].北京:SURPAC中国办事处,2013:1-50.
[11]GEMCOM SURPAC国际软件公司.Surpac基础指南[R].北京:SURPAC中国办事处,2013:1-86
[12]GEMCOM SURPAC国际软件公司.Surpac块体模型[R].北京:SURPAC中国办事处,2013:10-55.
[13]侯景儒,黄竞先.地质统计学及其在矿产储量计算中的应用[M].北京:地质出版社,1982.
[14]张树泉.地质统计学矿体建模简明教材[EB/OL](2010-10-01)[2014-12-19].https:newpu.baidu.com/ee35c50b27d3240c8447efaa.html,2010:33-40.
[15]国家质量技术监督局.GBT 17766-1999固体矿产资源/储量分类[M].北京:中国标准出版社,1999.
[2] Sahoo M M,Pal B K.Geological modelling of a deposit and application using Surpac[J].Journal of Mines,Metals and Fuels,2017,65(7):417-422.
[3]王志亮,王继芳,李军.Surpac软件在归来庄金矿深部矿床资源量估算中的研究和应用[J].山东国土资源,2015,31(5):67-72.
[4] LiYingling,Gao Jianguo.Research and application of the 3D mathematic model of ore-body based on suppac software:Yunnan white cattle factory silver polymetallic mine[J].Advanced Materials Research,2014,868:84-87.
[5]张聪,程建忠,王润涛,等.基于Surpac的蒙古某铅锌矿地质数据研究[J].矿业工程,2013,11(3):62-63.
[6]朱未,赵廷严,王洋.基于Surpac软件的地质数据库研究[J].矿物学报,2013,33(增刊2):997-998.
[7]郭进,宦秉炼.基于Surpac的甘冲石灰石矿地质数据库研究及应用[J].云南冶金,2012,41(3):1-4.
[8] Huang Ping,Yang Peng,Liu Jie.Application of surpac vision software in Arhada lead and zinc mine[J].Advances in Information Sciences and Service Sciences,2012,4(8):178-186.
[9] Huang Ping,Yang Peng,Chen Yizhou,et al.Three-dimensional model of Cangshang gold mine based on surpac[J].International Journal of Advancements in Computing Technology,2011,3(11):299-306.
[10]GEMCOM SURPAC国际软件公司.Surpac地质数据库[R].北京:SURPAC中国办事处,2013:1-50.
[11]GEMCOM SURPAC国际软件公司.Surpac基础指南[R].北京:SURPAC中国办事处,2013:1-86
[12]GEMCOM SURPAC国际软件公司.Surpac块体模型[R].北京:SURPAC中国办事处,2013:10-55.
[13]侯景儒,黄竞先.地质统计学及其在矿产储量计算中的应用[M].北京:地质出版社,1982.
[14]张树泉.地质统计学矿体建模简明教材[EB/OL](2010-10-01)[2014-12-19].https:newpu.baidu.com/ee35c50b27d3240c8447efaa.html,2010:33-40.
[15]国家质量技术监督局.GBT 17766-1999固体矿产资源/储量分类[M].北京:中国标准出版社,1999.