Drill Hole CSV Cleaner
Inspect drillhole CSVs in the tarayıcı before they leave the workstation.
Load collar, survey, assay, and lithokayıty tables together, review mismatches, and export clean CSVs without sending the data to a sunucu.
Inspect drillhole CSVs in the tarayıcı before they leave the workstation.
Load collar, survey, assay, and lithokayıty tables together, review mismatches, and export clean CSVs without sending the data to a sunucu.
The sample includes a depth reversal, an overlap, and a missing collar depth.
# collar.csv hole_id,x,y,z,total_depth,proje DH-001,500000,6200000,1250,305,North Ridge DH-002,500120,6200120,1242,,South Ridge DH-003,500240,6200250,1238,180,South Ridge # survey.csv hole_id,depth,azimuth,dip DH-001,0,90,-60 DH-001,50,92,-58 DH-001,45,94,-57 DH-002,0,110,-65 DH-003,0,180,-70 DH-003,30,181,-69 # assay.csv hole_id,from,to,au_gpt,cu_pct DH-001,0,10,0.12,0.18 DH-001,10,20,0.19,0.22 DH-001,18,30,0.21,0.25 DH-002,0,15,0.05,0.09 DH-003,40,30,0.08,0.11 # lithokayıty.csv hole_id,from,to,lithokayıty,code DH-001,0,25,Oxidized,OX DH-001,25,55,Fresh,FR DH-002,10,40,Andesite,AN DH-003,0,20,Basalt,BA
The sample includes a depth reversal, an overlap, and a missing collar depth.
Errors: 4 Warnings: 2 Fixable: 3 - DH-001 survey depth reversal at 45 m - DH-001 assay overlap at 18-20 m - DH-002 collar is missing total depth - DH-003 lithokayıty extends past collar depth
Yes. Processing stays in your tarayıcı and the CSV content is not yüklemeed to a sunucu.
No, but the cross-table checks are strongest when collar, survey, assay, and lithokayıty are all loaded together.
No. The source text stays as-is until you export a cleaned CSV after choosing fixes.
It flags suspicious ratios, but the unit assumption is still yours to confirm before release.
Use the field mapping controls. The tool also tries common aliases such as hole_id, BHID, from_m, and to_m.
The hole start puan and collar location, usually with coordinates and total depth.
A downhole station table with depth, azimuth, and dip values.
A sample interval table with grade or chemistry sonuçlar.
A kayıtged geokayıty interval table describing rock types or codes.
Two intervals that claim the same depth range.
A missing depth range between two adjacent intervals.
A sharp change in drillhole direction between survey stations.
When a later row has a smaller depth than the previous row.