1. Summary
  2. Files
  3. Support
  4. Report Spam
  5. Create account
  6. Log in

Main Page

From xplordb

Jump to: navigation, search

xplordb documentation wiki

Open mineral exploration database system

Contents

Summary

xplordb an open source mineral exploration database template for PostgreSQL/ PostGIS. xplordb is designed to store drilling, surface sampling, assay, geology, and QAQC details and more. Customisation is also possible.

Geographic information systems (GIS) data/ layers can be directly imported to the main database. This integrated storage allows ease of access and sophisticated spatial SQL interrogation for better decision making.

xplordb is self-documented, i.e. the documentation of the template is stored in the database. An outline of how the recommended software can be installed and an overview is documented in this wiki.

Software

On Linux/GNU and BSD operating systems all software used is open source, on other systems the main components used to interface with the xplordb template are open source and are;

  • PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. (PostgreSQL website)
  • PostGIS adds support for geographic objects to the PostgreSQL database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for GIS. (PostGIS website)
  • Perl scripts convert flat assay data spreadsheets into the assay database table.
  • pgAdmin is the suggested GUI front-end for xplordb and Quantum GIS can be used to directly display the stored spatial layers.


Various proprietary GIS and 3D mining packages can also interface with xplordb via the PostgreSQL odbc drivers.

Flow Chart

File:Xdb flowchart-0.83.png

Supported Operating Systems

All the software can be run on the major operating systems including GNU/ Linux, BSD, OS X, Windows NT, Windows XP, Windows Vista and Windows 7.

User Pre-requisites

Knowledge of SQL, perl, GIS, exploration drilling/ sampling/ assaying techniques and geology. Also knowledge of the operating system of choice.

License

The xplordb project including all code, documentation and the information in this wiki is copyleft and released under the GNU General Public License, version 3

Installation

Linux/ BSD

The steps to install the required software on Unix like operating systems, Linux and BSD are specifically covered....more

Microsoft Windows

The steps to install the required software on the Windows operating system...more

Database setup

Schema

The recommended database schema setup...more

Tables

Description of the tables in the xplordb database...more

User Access

Some hints on how to setup user access...more

Data Import & Validation

Import

The various methods of importing drilling and assay data...more

Validation

How the data may be validated...more

Laboratory QA/QC

Laboratory QA/QC features...more

Data Views and Reports

Reports

Useful reports from the data...more

PostGIS and Viewing Data in Quantum GIS

PostGIS

Adding a spatial column to a table and viewing in Quantum GIS...more

Data Backup & Export

Backup/ Export

Ways of backing up and exporting data...more

Other

Useful Code

...more

Personal tools