Drillhole Data Preparation Suite
Stage 01 · Exploration · From raw collar/survey/assay/geology → clean desurveyed drillhole
Dashboard
Analysis Scope
Stage 01 — Drillhole Data Preparation
Validate, composite, desurvey, and export drillhole data (collar + survey + assay + geology) into composite-ready CSV for Stage 02, in accordance with KCMI 2017 Chapter 1 (Sampling and Data Collection), Chapter 2 (Geological Logging and Database Management), and JORC Code 2012 Section 1 (Sampling Techniques and Data).
Standards: JORC Code 2012, KCMI 2017, NI 43-101, industry best-practice.
- Upload 4 CSV files: Collar, Survey, Assay, Geology — per KCMI Ch1 sampling protocols
- Auto-validation: duplicates, gaps, mismatches, anomalies (JORC Table 1 §1 compliance)
- Collar surveys (GPS/local grid), downhole surveys (dip/azimuth) — JORC §1.15–1.16
- Sample intervals: uniform or variable length, no gaps or overlaps — KCMI Ch1 §1.3
- QAQC protocol checks: certified standards, blanks, field duplicates, umpire assays — JORC §1.20–1.24
- Minimum Curvature desurvey → real X/Y/Z per interval
- Export composite CSV → direct input for Stage 02 EDA
Output: composite-ready CSV with BHID, From, To, MidX, MidY, MidZ, grades, lithology — traceable to KCMI/JORC Section 1 standards
Quick Start Tutorial
- Import — Drag-drop 4 CSV files (or use Thalanga sample)
- Review — Check Collar, Survey, Assay, Geology tabs
- Validate — Run validation, fix errors until zero issues
- Desurvey — Calculate real XYZ per sample interval
- Export — Download composite CSV for Stage 02
Tip: Start with the Tour button in the top-right header for a guided walkthrough.
Workflow Progress
Quick Actions
Sample Data: Thalanga VMS — 40 holes, 1,521 intervals. Queensland Geoscience Data
Import — 4 CSV Files (auto-classify)
Drop all 4 CSV files at once (Collar + Survey + Assay + Geology). The system auto-classifies by filename first (looks for collar/survey/assay/geology|litho), falling back to header signature.
If you skip the upload, the system uses the embedded Thalanga VMS sample. If you upload only some files, the rest stay as sample data.
Column Format (auto-detected)
| File | Required | Optional |
|---|---|---|
| Collar | hole_id, x/easting/GDA94_E, y/northing/GDA94_N, z/RL, depth/final_depth | prospect, drill_type, comment |
| Survey | hole_id, depth, dip, azimuth | — |
| Assay | hole_id, from_m/from_depth, to_m/to_depth, ≥1 grade column | sample_id, multi-element (Au, Cu, Pb, Zn, ...) |
| Geology | hole_id, from_m, to_m, lith/lith1/lithology | weathering, lith2, color, lith_desc |
Upload Files
Click or drag & drop 4 CSV files
System auto-classifies based on detected columns
Reset to Sample Data
Revert to the embedded Thalanga VMS data (40 holes, prospect RGMWP).
Download Sample CSV
Use as a template for uploading your own data.
Project Folder
Open a previously saved project from IndexedDB, or import a .orebit bundle file.
Collar — Drillhole Header Data
The collar table contains one row per drillhole: hole_id (unique), collar coordinates (X, Y, Z), and total depth. Click a cell to edit, or "Add Row" to add a new hole.
Standards: Collar positions must be surveyed (GPS or local grid) per KCMI 2017 Ch1 §1.1 and JORC 2012 §1.15. Coordinate system (e.g., GDA94, UTM zone) must be stated. Collar elevation (Z/RL) should be surveyed, not topographic-estimated.
Survey — Downhole Deviation
Survey records: dip and azimuth at given depths per hole. At least one survey per hole is required (otherwise vertical is assumed: dip=-90, az=0). Multi-survey per hole for inclined holes with deflection.
Standards: Downhole surveys are required per JORC 2012 §1.16–1.17. Survey intervals should be regular (typically every 30 m for diamond drill, every 10 m for RC) per KCMI Ch1 §1.2. Minimum one survey per hole; multiple surveys for inclined/deflected holes. Survey method (single-shot, multi-shot, gyro) must be reported.
Assay — Geochemical Intervals
Assay intervals with grade per element. Auto-validation: gap (intervals don't connect), overlap (intervals overlap each other), negative grade.
Geology — Lithology Logging
Geology intervals: primary & secondary lithology, weathering, description. Validation: lithology dictionary, interval continuity.
Cross-Table Validation
Verify linkage across all 4 tables. Holes in assay but not in collar → flagged. Holes without survey → flagged. Completeness summary per critical column.
Strip Log — Well-Log Multi-Track Viewer
Industry-standard well-log view: depth axis on the left, multi-track (lithology, weathering, grade curves) side-by-side for one selected hole.
Select a hole from the dropdown or use the prev/next buttons. Hover a track for interval details.
Section — Multi-Hole Correlation
Section view: pick azimuth + origin + corridor half-width, and the system projects holes inside the corridor onto the section line. Each hole is drawn as a vertical strip (or tilted by dip) with lithology fill.
Limitation: section uses orthogonal projection to the section plane (vertical projection for Z), not true 3D intersection. For higher precision use commercial 3D modeling software.
Desurvey — Minimum Curvature
Compute (X, Y, Z) per assay/geology interval midpoint using the Minimum Curvature method. Output: 3D trace per hole + interval coordinates ready for merge.
Merge — Master Drillhole Table
Combine Assay × Geology × desurveyed coordinates into a single master table. Match by hole_id + depth overlap. Default: assay-driven (1 row per assay interval; geology & XYZ pulled by depth).
Export — drillhole-clean.csv
Final output: master drillhole CSV ready for input into the EDA Suite (Stage 02) or commercial estimation software. Format compatible with commercial 3D mining software.
PDF Report
Single-file PDF (4 A4 pages): cover, validation results, hole inventory, per-element stats + KCMI Section 1 manual checklist. Embedded in this artifact, no connection required.