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.
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.
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
The steps to install the required software on Unix like operating systems, Linux and BSD are specifically covered....more
The steps to install the required software on the Windows operating system...more
The recommended database schema setup...more
Description of the tables in the xplordb database...more
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 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
Ways of backing up and exporting data...more