Drill Hole CSV Cleaner

Verileri bir sunucuya göndermeden önce tarayıcıda delme CSV'lerini inceleyin.

Yaka, anket, analiz ve litoloji tablolarını birlikte yükleyin, eşleşmeleri inceleyin ve verileri bir sunucuya göndermeden temiz CSV'ler dışa aktarın.

No signup / Ücretsiz Browser-only processing Checks four tables together

How to use

  1. Yaka, anket, analiz ve litoloji CSV'lerini yükleyin veya yapıştırın.
  2. Confirm the detected headers and adjust the field mapping if needed.
  3. Kaynak dosyalarla eşleşen birimleri ve temizleme ayarlarını seçin.
  4. Run validation, then review the issue list and suggestions.
  5. Güvenli düzeltmeler uygulayın ve temiz CSV'leri sorun raporuyla birlikte indirin.

Sample

Mixed drillhole QA sample

The sample includes a depth reversal, an overlap, and a missing collar depth.

Girdi
# 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

Expected çıktı

The sample includes a depth reversal, an overlap, and a missing collar depth.

Expected çıktı
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

SSS

Can I use it çevrimdışı?

Evet. İşleme tarayıcınızda kalır ve CSV içeriği bir sunucuya yüklenmez.

Do I need all four tables?

Hayır, ancak yaka, anket, analiz ve litoloji birlikte yüklendiğinde çapraz tablo kontrolleri en güçlüsüdür.

Will it change my original file?

No. The source text stays as-is until you export a cleaned CSV after choosing fixes.

Can it detect feet-versus-meters mistakes?

It flags suspicious ratios, but the unit assumption is still yours to confirm before release.

What if my header names are different?

Use the field mapping controls. The tool also tries common aliases such as hole_id, BHID, from_m, and to_m.

Glossary

Collar

Genellikle koordinatlar ve toplam derinlik ile birlikte delme başlangıç noktası ve yaka konumu.

Survey

A downhole station table with depth, azimuth, and dip values.

Assay

Not veya kimya sonuçları içeren bir numune aralığı tablosu.

Lithokayıty

A kayıtged geokayıty interval table describing rock types or codes.

Overlap

Two intervals that claim the same depth range.

Gap

A missing depth range between two adjacent intervals.

Dogleg

A sharp change in drillhole direction between survey stations.

Depth reversal

When a later row has a smaller depth than the previous row.