Planning, Implementation and Introduction of Information Management ...
2013 Esri Europe, Middle East and Africa User Conference October 23-25, 2013 | Munich, Germany
Planning, Implementation and Introduction of Information Management Systems (IMS) in the Geological Survey of Ghana Kwame O. Boamah, Sven Etzold
Esri E Esri Esr EMEAUC13 MEAUC1 MEA ME E UC EA UC UC1 C13
Background Project Partners
•
Financed by 8th EDF Fund, SYSMIN Programme (European Union)
•
Participating Authorities: -
Ministry of Lands and Natural Resources Geological Survey Department (GSD) Minerals Commission (MC) Inspectorate Division of the Minerals Commission Precious Minerals Marketing Company Ltd. (PMMC)
Planning, Implementation and Introduction of Information Management Systems ms in the Esri EMEAUC13 Geological Survey of Ghana
Background Project Partners
•
Realized by: -
-
-
Beak Consultants GmbH Freiberg Design, Implementation, Training IBIS Chemnitz Technical infrastructure Accelon Accra Local partner for infrastructure
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Background Geological Survey Department (GSD)
The GSD was founded in 1913 The vision of the GSD is to be an internationally recognised organization contributing to the development agenda of the country through the provision of geoscientific data GSD is the principal curator of the national geoscientific data, and has the main task to continuously generate, collect, store and archive relevant geoscientific data, and to disseminate data and information in a user-friendly way to the government, industry and the public at large. The department has the responsibility to advice the nation to make informed decision on geoscientific issues concerning mineral and groundwater resources, environment, geohazards and land use planning Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Background Significance of Ghana Mining Sector
•
Mining in Ghana: 39 % of total export value
•
Mining sector employs directly > 36.000 people
•
Mining accounts for 5% of Ghana’s GDP
•
Main commodities: Gold, Manganese, Bauxite, Diamonds
•
Known reserves have depleted rapidly •
Effective mining techniques
•
Lack of exploration funds
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Background Significance of Ghana geoscientific data
•
Demand for data management to make exploration and licensing procedures more effective for investors -
Efficient provision of geoscientific data Up-to-date information about licences
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Background Main tasks
•
The IMS project provides the Mining Sector of the MLNR and its agencies with -
a new IT infrastructure, a common web portal, a powerful customized database / GIS software.
The IMS project is essential for the further development of one of the most promising economic sectors in Ghana. Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Implementation of the System Database
Systematic storage, handling and provision of data: •
mineral licence data,
•
mineral deposit data,
•
geoscientific maps,
•
geoscientific primary data,
•
drillhole data,
•
analytical data, …
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Implementation of the System Functions
•
Data entry,
•
Inquiries,
•
Import and export (flat tables for further processing),
•
Compilation of reports, statistics and maps for frequent data evaluations,
•
Fast and easy printing of user defined maps,
•
Alert functions for selected important events (e.g. expiry of licences).
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Implementation of the System General Database Structure Reports & Documents
Factual Data & Metadata
Spatial Data Geometrical data with relationship to the database 1)
g fb ID_GFB GFB_Name GFB_Bemerk g fb_g uelt GFB_erh GFB_erf
ID_rf_flstk flstk flstk_bemer Name Ort PLZ Str Tel sst_in_flst k
UTA ID_UTA UTA_Name UTA_Abmess UTA_Beschr_kurz HNmin HNmax UTA_erh UTA_erf UTA_beschr_lang
sst_in_uta
san_arb ID_san_arb san_arb_erh san_arb_erf san_arb_besc hr san_arb_von san_arb_bis
File System
rf_flstk
sst_in_gfb sst_in_bsg
gfbb_ueber_uta
Deposits • Drill holes • Geology • … •
BSA_Gebiete ID_BSG BSG_Name
ss t ID_ss t SST_name SST_Nr Dat_ersterh sst_hat_vrw_zst Dat_ersterf vrw_zs t Hoch ID_vrw_zs t Rechts vrw_zs t_bemer HN Dat_erh ss t_basisbeschr Dat_erf
ss t_beschr ID_ss tbesc hr beschr_kurz Ntzng _ist Ntzng _pln sc haeden bse sst_hat_san_arb erh_dat erf_dat sst_hat_sstbeschr foto beschr_lang san_bed
Database
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Topographical base data 1) Topographic maps • Satellite images • … •
Other spatial data 2) Scanned maps from reports • … •
Database 1) / File System
2)
Implementation of the System Functions Start form
Module forms: Licences
GIS
Mine data Drill holes Deposits Reports Spatial Data Administration Frontend
Bibliography Geol. field data Geochemistry
View Documents
Pers.& comp. Geophysics Documents
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Map printing
Implementation of the System Technical background
•
GIS: -
•
Database: -
•
ArcGIS MS SQL Server ArcGIS Server
Programming languages/libraries: -
VB.net ArcObjects
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Workflow: Example mineral deposits Mineral deposit module
Filter function
Setting of conditions Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Workflow: GIS GIS
9 deposits match the conditions
Addition of background data
Customised map printing
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Workflow: GIS Remove the filter
Display their properties in the database
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Pick up some deposits
Workflow: database functions
Export data to EXCEL
Jump to literature
view selected record Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Read the report
Thank you for your attention
Kwame O. Boamah Geological Survey Department of Ghana, Accra [email protected]
Sven Etzold Beak Consultants GmbH, Freiberg, Germany [email protected]
Æ Booth No. 51 Esri EMEAUC13
Planning, Implementation and Introduction of Information Management Systems (IMS) in the Geological Survey of Ghana Kwame O. Boamah, Sven Etzold
Esri E Esri Esr EMEAUC13 MEAUC1 MEA ME E UC EA UC UC1 C13
Background Project Partners
•
Financed by 8th EDF Fund, SYSMIN Programme (European Union)
•
Participating Authorities: -
Ministry of Lands and Natural Resources Geological Survey Department (GSD) Minerals Commission (MC) Inspectorate Division of the Minerals Commission Precious Minerals Marketing Company Ltd. (PMMC)
Planning, Implementation and Introduction of Information Management Systems ms in the Esri EMEAUC13 Geological Survey of Ghana
Background Project Partners
•
Realized by: -
-
-
Beak Consultants GmbH Freiberg Design, Implementation, Training IBIS Chemnitz Technical infrastructure Accelon Accra Local partner for infrastructure
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Background Geological Survey Department (GSD)
The GSD was founded in 1913 The vision of the GSD is to be an internationally recognised organization contributing to the development agenda of the country through the provision of geoscientific data GSD is the principal curator of the national geoscientific data, and has the main task to continuously generate, collect, store and archive relevant geoscientific data, and to disseminate data and information in a user-friendly way to the government, industry and the public at large. The department has the responsibility to advice the nation to make informed decision on geoscientific issues concerning mineral and groundwater resources, environment, geohazards and land use planning Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Background Significance of Ghana Mining Sector
•
Mining in Ghana: 39 % of total export value
•
Mining sector employs directly > 36.000 people
•
Mining accounts for 5% of Ghana’s GDP
•
Main commodities: Gold, Manganese, Bauxite, Diamonds
•
Known reserves have depleted rapidly •
Effective mining techniques
•
Lack of exploration funds
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Background Significance of Ghana geoscientific data
•
Demand for data management to make exploration and licensing procedures more effective for investors -
Efficient provision of geoscientific data Up-to-date information about licences
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Background Main tasks
•
The IMS project provides the Mining Sector of the MLNR and its agencies with -
a new IT infrastructure, a common web portal, a powerful customized database / GIS software.
The IMS project is essential for the further development of one of the most promising economic sectors in Ghana. Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Implementation of the System Database
Systematic storage, handling and provision of data: •
mineral licence data,
•
mineral deposit data,
•
geoscientific maps,
•
geoscientific primary data,
•
drillhole data,
•
analytical data, …
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Implementation of the System Functions
•
Data entry,
•
Inquiries,
•
Import and export (flat tables for further processing),
•
Compilation of reports, statistics and maps for frequent data evaluations,
•
Fast and easy printing of user defined maps,
•
Alert functions for selected important events (e.g. expiry of licences).
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Implementation of the System General Database Structure Reports & Documents
Factual Data & Metadata
Spatial Data Geometrical data with relationship to the database 1)
g fb ID_GFB GFB_Name GFB_Bemerk g fb_g uelt GFB_erh GFB_erf
ID_rf_flstk flstk flstk_bemer Name Ort PLZ Str Tel sst_in_flst k
UTA ID_UTA UTA_Name UTA_Abmess UTA_Beschr_kurz HNmin HNmax UTA_erh UTA_erf UTA_beschr_lang
sst_in_uta
san_arb ID_san_arb san_arb_erh san_arb_erf san_arb_besc hr san_arb_von san_arb_bis
File System
rf_flstk
sst_in_gfb sst_in_bsg
gfbb_ueber_uta
Deposits • Drill holes • Geology • … •
BSA_Gebiete ID_BSG BSG_Name
ss t ID_ss t SST_name SST_Nr Dat_ersterh sst_hat_vrw_zst Dat_ersterf vrw_zs t Hoch ID_vrw_zs t Rechts vrw_zs t_bemer HN Dat_erh ss t_basisbeschr Dat_erf
ss t_beschr ID_ss tbesc hr beschr_kurz Ntzng _ist Ntzng _pln sc haeden bse sst_hat_san_arb erh_dat erf_dat sst_hat_sstbeschr foto beschr_lang san_bed
Database
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Topographical base data 1) Topographic maps • Satellite images • … •
Other spatial data 2) Scanned maps from reports • … •
Database 1) / File System
2)
Implementation of the System Functions Start form
Module forms: Licences
GIS
Mine data Drill holes Deposits Reports Spatial Data Administration Frontend
Bibliography Geol. field data Geochemistry
View Documents
Pers.& comp. Geophysics Documents
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Map printing
Implementation of the System Technical background
•
GIS: -
•
Database: -
•
ArcGIS MS SQL Server ArcGIS Server
Programming languages/libraries: -
VB.net ArcObjects
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Workflow: Example mineral deposits Mineral deposit module
Filter function
Setting of conditions Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Workflow: GIS GIS
9 deposits match the conditions
Addition of background data
Customised map printing
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Workflow: GIS Remove the filter
Display their properties in the database
Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Pick up some deposits
Workflow: database functions
Export data to EXCEL
Jump to literature
view selected record Planning, Implementation and Introduction of Information Management Systems in the Esri EMEAUC13 Geological Survey of Ghana
Read the report
Thank you for your attention
Kwame O. Boamah Geological Survey Department of Ghana, Accra [email protected]
Sven Etzold Beak Consultants GmbH, Freiberg, Germany [email protected]
Æ Booth No. 51 Esri EMEAUC13
