Stage 01 · Exploration · From raw collar/survey/assay/geology → clean desurveyed drillhole
Thalanga VMS · Queensland geoscience demo dataset
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.
Output: composite-ready CSV with BHID, From, To, MidX, MidY, MidZ, grades, lithology — traceable to KCMI/JORC Section 1 standards
Tip: Start with the Tour button in the top-right header for a guided walkthrough.
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.
| 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 |
Click or drag & drop 4 CSV files
System auto-classifies based on detected columns
Override how numbers are read, and declare your coordinate system. Both are auto-detected — change only if the import looks wrong.
The coordinate system is recorded in your project metadata and written into exports (satisfies KCMI 2017 / JORC 2012 "CRS must be stated"). It also enables the satellite basemap on the spatial map.
Access CSV files from your Google Drive. Files stay in your browser — nothing uploaded to any server.
Revert to the embedded Thalanga VMS data (717 holes, prospect Thalanga).
Use as a template for uploading your own data.
Open a previously saved project from IndexedDB, or import a .orebit bundle file.
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 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 intervals with grade per element. Auto-validation: gap (intervals don't connect), overlap (intervals overlap each other), negative grade.
Geology intervals: primary & secondary lithology, weathering, description. Validation: lithology dictionary, interval continuity.
Verify linkage across all 4 tables. Holes in assay but not in collar → flagged. Holes without survey → flagged. Completeness summary per critical column.
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 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.
Compute (X, Y, Z) per assay/geology interval midpoint using the Minimum Curvature method. Output: 3D trace per hole + interval coordinates ready for merge.
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).
Composite raw assay intervals into uniform length intervals using length-weighted averaging of grades. Standard compositing method per KCMI 2017 Chapter 1 and JORC 2012 Section 1.
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.
Every transform applied this session (BDL, compositing, crop). Embedded in the PDF report so the exported numbers are always traceable.
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.
First 10 rows of the merged drillhole dataset that will be exported. Verify your data before downloading.
Audit trail of every download this session (max 20). Persists in your browser localStorage.