Exploration · From raw collar/survey/assay/geology → clean desurveyed drillhole
Demo dataset · Queensland geoscience demo
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, at least 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 |
📋 Required CSV format:
Delimiter: Choose below (usually Semicolon (;) for data from Europe)
Example line:APKL01;572720.46;9,841,220;-26
⚠️ If the upload fails: pick the correct delimiter below before uploading again
Click, or drag and drop 4 CSV files
Collar.csv · Survey.csv · Assay.csv · Geology.csv
Override how numbers are read, and declare your coordinate system. Both are auto-detected — change them only if the import looks wrong.
The coordinate system is recorded in your project metadata and written into exports (satisfying the KCMI 2017 / JORC 2012 requirement that the CRS be stated). It also enables the satellite basemap on the spatial map.
Read CSV files from your Google Drive. The files stay in your browser — nothing is uploaded to any server.
Go back to the built-in Thalanga VMS data (717 holes, Thalanga prospect).
Use these as a template for uploading your own data.
Open a project you saved earlier, 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, not true 3D intersection. For holes with dip < 60° (highly inclined), positions may be inaccurate by up to 10% of deviation. For final interpretation, 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).
Optional preview only. Final length-weighted compositing and approval belong in Assay before Resource estimation.
Final output: master drillhole CSV ready for input into the EDA Suite (Assay) 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 stay 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.