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



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.


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.


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


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


The recommended database schema setup...more


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

User Access

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

Data Import & Validation


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


How the data may be validated...more

Laboratory QA/QC

Laboratory QA/QC features...more

Data Views and Reports


Useful reports from the data...more

PostGIS and Viewing Data in Quantum GIS


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


Useful Code


Personal tools