Publication information

Geological Survey of Canada
Open File 7764

World Sediment-hosted Copper Deposit Database

Kirkham, R.V., Carrière, J.J., Rafer, A.B., and Born, P.

© Her Majesty the Queen in Right of Canada, as represented by the Minister of Natural Resources Canada, 2015

doi:10.4095/296422

Publications in this series have not been edited; they are released as submitted by the author.

View the licence agreement at http://data.gc.ca/eng/open-government-licence-canada

Recommended citation

Kirkham, R.V., Carrière, J.J., Rafer, A.B., and Born, P., 2015. World sediment-hosted copper deposit database; Geological Survey of Canada, Open File 7764, 1 .zip file. doi:10.4095/296422

Getting started

This Open File must be unzipped to be fully useable.  It contains a complex relational database, which comes with its own data management application interfaces referred to collectively as GlobalDB System.  Users are advised to first extract the folder Documentation locally, maintaining its folder structure. Click on default.htm to open a local web page in an Internet browser, which will provide a table of contents, an overview of the database, and links to documentation of each component of GlobalDBSystem.  If a suitable computer system is available (see System requirements below), the user can simply copy Data321 and GlobalDBSystem321 to a chosen location and follow the directions in HowtoADO.rtf or the  “Defining database aliases” link in the \Documentation\default.htm for setting up a link to the database in the GlobalSystem321 folder.

Contents

This Open File contains the World sediment-hosted copper deposit database in Microsoft® Access® format, which is a relational database that conforms to the schema developed by the World Minerals Geoscience Database Project (WMGDP: 1998-2004). This schema was enhanced after the WMGDP to include extra tables required for compilations under the Northern Resource Development and Northern Mineral Resource Development Programs, bringing it up to version 3.21.  Because this database is complex, covering a wide variety of subject matter and containing sets of tables with different roles, users are advised to first refer to the documentation and then to make use of the application interfaces in the folder GlobalDBSystem321 to explore, query and export data from the database.  For the reader’s convenience the web-style documentation is included in the standalone folder \Documentation, which must be extracted from the zipped download before it can be used.  The same documentation is found in the Documentation folder inside GlobalDBSystem321.  When consulting or moving either version of the documentation, please keep its internal folder and file structure intact.  To get started, navigate into either Documentation folder and click on default.htm, which will give you web-style access to all of the other files in this folder.

In addition to the World sediment-hosted copper deposit database, an empty Access database conforming to the WMGDP, version 3.21 schema is also provided for the convenience of users who wish to build and manage their own databases.  SQL scripts are provided that can be used to build and populate the databases on other SQL-enabled database management systems (DBMS).  This should be performed by personnel with database administration skills because minor DBMS-specific modifications will be needed to build the schema. Each DBMS will have its own set of tools to load scripts.  This Open File lists the steps the WMGDP used to load databases into InterBase and PostgreSQL.

This publication also contains the following derivative geospatial data sets:  Index level ESRI® shape files (minimal attributes) for the deposit and deposit group entities, and a KMZ file for deposits which can be opened with Google Earth™ or other internet earth browsers. Both shape files contain an attribute field (URL) which can be used to hotlink to full deposit (dp) and deposit group (dg) reports.   As an alternative to a paper text listing of all of the deposits and deposit groups in the World sediment-hosted copper deposit database, a user can navigate into the dp or dg folder and click on index.html in either folder to view a Table of Contents using an internet browser.  Deposits or deposit groups are sorted alphabetically by country and province, state or territory in brackets and then by name.   Clicking on the DEPNO or DGNO values will open individual reports.

To use the data and software, copy the Data321 folder and GlobalDBSystem321 folder over to a chosen location, and follow the directions in the GlobalDBSystem321 subfolder Documentation as suggested above. System requirements (below) should be consulted to see if the utilities can be used on available computer platforms.

The folder GlobalDBSystem321 is specifically labelled for version 3.21 so that it will not clash with the folder GlobalDBSystem which may have been installed by users who have downloaded the following publications:

Gosselin, P. and Dubé, B., 2005a. Gold deposits of the world: distribution, geological parameters and gold content; Geological Survey of Canada, Open File 4895, 271 p., 1 CD-ROM, doi:10.4095/220379

Gosselin, P. and Dubé, B., 2005b. Gold deposits of Canada: distribution, geological parameters and gold content; Geological Survey of Canada, Open File 4896, 105 p., 1 CD-ROM, doi:10.4095/220380

These 2005 publications are in schema 3.19.  Database management interfaces customized for this schema were automatically installed in a folder called GlobalDBSystem under Program Files by running the setup program extracted from cdrom.zip, which was included in the publication.   

Directory structure

of_7764.pdf				(Open File 7764 Foreword: About this database in Adobe® format)
readme_of7764.rtf			(this readme document)
\Documentation				(Folder of GlobalDBSystem documentation, click on default.htm)
\Data321
	\ Database_Access
		WorldSedCu.mdb		(Sediment-hosted copper deposit database in Access® 2000)
		EmptyWMGDP_Picklists.mdb	(Empty database with picklists in Access® 2000)

	\Database_SQL
		\InterbaseSchema
1_OrderofSchemaLoading.txt		(directions for schema loading using IBConsole)
GlobalDBSchema_SummaryTables.sql 	(extra table script to be executed second)
GlobalDBSchema321.sql		(schema script to be executed first)
grant321.sql				(to be executed third)
sp_recordcount_all.sql			(to be executed last)
sp_recordcount01.sql through sp_recordcount10.sql 
(to be executed after grant321.sql and before sp_recordcount_all.sql)

		\PostgresqlSchema
1_OrderofSchemaLoading.txt		(command-line schema loading)
GlobalDBSchema321_gsc.sql		(schema script to be executed first)
templist.sql				(executed only for the custom GQuery 
					Chameleon widget used with UMN Mapserver)

		EmptyWMGDP_InsertData.sql		(scripts to populate an empty database)
		EmptyWMGDP_InsertData_&.txt	(lines with & characters)
		WorldSedcu_InsertData.sql	(scripts to populate database with sediment-hosted copper data)
		WorldSedcu_InsertData _&.txt	(lines with & characters)

	\Geospatial_Data
		\dp		(folder of deposit and linked mine reports with index.html as TOC)
		\dg		(folder of deposit group and linked deposit reports with index.html as TOC)
		WldSedCu.kmz	(zipped keyhole markup (KMZ) file of sediment-hosted copper deposits for Google Earth™)
		WldSedcu.mxd	(ArcMap 10.1 project file with html reports hot linked to deposits)
		WldSedcu.shp	(group of 7 files that make up an ESRI® shape file for sediment-hosted copper deposits)
		WldSedcu.lyr	(ESRI layer file for sediment-hosted copper deposit shape file)
		WldSedcuGrp.shp (group of 7 files that make up an ESRI® shape file for sediment-hosted copper deposit groups)
		
\GlobalDBSystem321
	\Databases
		EmptyWMGDP_Picklists.mdb	(Empty database with GlobalDB schema 321 in Access®2000)
	\Documentation
		\downloads	(folder traditionally used for downloads)
		\images		(folder of images used in the documentation)
aliases.htm
default.htm	(click on this file to access the complete documentation)                
download.htm
fmselref.htm
present.htm
require.htm
usingd.htm
usingg.htm
usingq.htm
Documenter.exe	(tool to check the definitions of contents, table by table and field by field)	
GDBSTools.exe		(tools to check integrity, time-stamp, and export data as SQL insert scripts)
Global_SedCu.udl	(example Microsoft Data Link which must be updated with path to database)
GlobalDBSystem321.pdf	(complete GlobalDB Schema diagram, version 3.21)
GQ_ADO_XtraTables.exe	(tool to create or recreate the summary tables used by GQuery)
GQueryADO.exe	(interface to filter data, extract spreadsheet, and create reports)
GShellADO.exe		(interface for data entry and record by record browsing)
GShellADO.tlb		(file that enabled direct access to coordinates from GIS)
GShellBrowser.exe	(interface for record by record browsing)
howtoADO.rtf		(how to create or edit an Microsoft Data Link)

Adobe®, Acrobat®, and Reader® are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.

ESRI®, ArcExplorer™ and ArcReader™ are trademarks, registered trademarks, or service marks of ESRI® in the United States, the European Community, or certain other jurisdictions.

Windows® 95, Windows® 98, Windows® 2000, Windows® XP, Windows® 7, and Microsoft® Office are trademarks, registered trademarks, or service marks of Microsoft® in the United States, the European Community, or certain other jurisdictions.

System requirements

Windows® PC with 486 or greater processor (32 bit) with a minimum of 32 Mb of RAM and a few hundred megabytes of free hard disk space; Adobe® Reader® v. 6.0 or later; video resolution of 1280 x 1024. 

Either Internet Explorer® 5 and up or Microsoft® Office 2000 and up, and Windows® XP or earlier are required for full use of the application interfaces provided.  Windows® 7 allows limited use of the software.  Microsoft® Access® is required for editing and querying the Access database without the use of the custom interfaces provided.

Primary contact information

Lesley B. Chorlton (Lesley.Chorlton@nrcan-rncan.gc.ca)
Geological Survey of Canada
601 Booth Street 
Ottawa, ON, K1A OE8
Tel. 613-996-9358

Availability information

This publication is available for free download through GEOSCAN (http://geoscan.nrcan.gc.ca/).