Exploration · From raw collar/survey/assay/geology → clean desurveyed drillhole
Built-in synthetic sample
The built-in example is a synthetic nickel laterite dataset. To work with your own drillholes, import the four matching tables and check the validation results before proceeding.
Click, or drag and drop 4 CSV files
Collar.csv · Survey.csv · Assay.csv · Geology.csv
📋 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
Drop all 4 CSV files at once (Collar + Survey + Assay + Geology). Files are classified by filename first - collar, survey, assay, geology or litho - then by header signature.
| 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 |
Override how numbers are read, and declare your coordinate system. Both are auto-detected — change them only if the import looks wrong.
Assign midpoint coordinates in Column Mapping when needed. This mode preserves supplied positions; it does not reconstruct or verify a directional survey. Empty coordinates remain missing.
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.
Return to the synthetic nickel example: 349 collars, with missing source links for review in Validation.
Use these as a template for uploading your own data.
Open a project you saved earlier, or import a .orebit bundle file.
One row per drillhole: hole_id, collar coordinates (X, Y, Z) and total depth. Click a cell to edit, or use Add Row.
Collar positions must be surveyed (GPS or local grid) per KCMI 2017 Ch1 1.1 and JORC 2012 1.15. The coordinate system must be stated. Collar elevation (Z/RL) should be surveyed, not estimated from topography.
Dip and azimuth at given depths per hole. Without a survey the hole is treated as vertical (dip −90, azimuth 0).
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 or deflected holes. The 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.
This screen exports the current merged intervals, with their recorded edits and analysis scope. Optional Core composites have a separate download in Composite. Continue in Assay sends merged intervals for EDA; final domain-constrained compositing is reviewed in Assay before Resource. Review export details →
Every transform applied this session (BDL, compositing, crop). Embedded in the PDF report, so the exported numbers stay traceable.
Single-file A4 PDF; pages expand with the current results and audit record. Generated here, 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.
Read-only preview of the drillhole intervals in plan, section and 3D, using the same desurveyed endpoints as Merge. Nothing here changes the tables or the exported CSV.