Geological Data Management Software Development

Drill hole database structured around your project's hole types -- exploration diamond, RC, RAB, geotechnical, hydrological, blast hole -- each with the collar, survey, and downhole data tables required for that hole type. Collar data capturing hole ID, project, prospect, coordinates, RL, azimuth, dip, total depth, drilled date, and drilling contractor, with coordinate system management supporting multiple survey datums across project areas. Survey data management for both down-hole survey instruments -- single shot, gyro, MEMS -- with survey interval validation and deviation plots. Lithology and geological logging tables configured to your company's logging codes and pick conventions, with code library management so geologists use consistent terminology across all projects. Data validation rules applied at entry -- coordinate bounds checking, depth consistency, survey continuity, code list validation -- so data errors are caught at the time of entry rather than discovered when the data is used for resource estimation.

Assay results import from laboratory LIMS systems -- ALS, SGS, Bureau Veritas, Intertek -- in the laboratory's standard dispatch format, with automated parsing and field mapping so import does not require manual reformatting. Assay table management supporting multiple assay suites for different mineralisation types -- gold fire assay, multi-element ICP, geotechnical index tests -- linked to the correct interval in the drill hole record. Duplicate interval detection at import, flagging cases where results have been submitted twice or where interval depths overlap with existing data, for geologist review before acceptance. Result validation against expected detection limits and upper bound values, flagging anomalous results for geologist review rather than accepting them silently. Certificate of analysis storage linked to each assay result set so the original laboratory document is accessible from the database record without searching email or shared drives.

QAQC sample management tracking the insertion of certified reference materials, blanks, and field duplicates into the sample submission sequence, with the insertion frequency and type configured to match your QAQC protocol. CRM performance reporting comparing returned assay values against the certified value and acceptable precision limits, flagging CRM failures for geologist investigation before the batch results are accepted. Blank contamination checking identifying returned blank assay values that exceed the contamination threshold, triggering a review of the sample preparation procedure for that batch. Field duplicate precision reporting showing the relative percentage difference between primary and duplicate samples, identifying areas of high sample variance that may indicate nugget effect or sample preparation issues. QAQC pass/fail status applied to each sample batch, controlling which assay data can be included in resource estimation exports -- failed batches excluded automatically until the geologist overrides after investigation.

Sample tracking from submission dispatch through laboratory receipt, preparation, analysis, and result delivery -- each stage recorded in the system so geologists know the current status of every sample without calling the laboratory. Barcode or QR code label generation for sample bags and trays, linked to the drill hole and interval record so the physical sample can be matched to the database record throughout the chain of custody. Laboratory receipt confirmation imported from the laboratory's manifest or entered by the laboratory contact, so the team knows immediately if samples are missing on arrival. Dispatch batch management grouping samples by laboratory, submission date, and requested turnaround -- the dispatch manifest generated from the system for the laboratory and stored against the batch record. Turnaround time monitoring comparing actual result delivery against the requested turnaround, with alerts when batches are approaching overdue status without results having been received.

Domain and zone assignment linking drill hole intervals to the geological and mineralisation domains used in resource estimation -- the domain assignments updated as geological interpretation evolves without overwriting the original logging data. Wireframe and geological model reference data stored alongside the drill hole data, providing context for geologists querying the database about which intervals fall within or outside the current interpretation. Composite interval creation from the raw sample data -- fixed length, geological contact, or grade-based compositing -- stored as a derived data set linked to the original raw data for traceability. Cross-section and plan data extract generating drill hole traces and interval data in the format required for section viewing in Leapfrog, Micromine, or Datamine, without manual data preparation. Geological summary reporting by hole, by prospect, and by period -- the number of metres drilled, the assay results received, and the QAQC status -- for inclusion in technical reports and investor communications.

Data export to resource estimation software -- Leapfrog Geo, Micromine, Datamine Studio, Surpac -- in the required format, with QAQC filters applied automatically so only QAQC-passed data is included in the export. Export configuration management allowing geologists to define different export specifications for different resource domains, commodity types, or estimation methods, and to re-run the same export configuration when new data is added without redefining the parameters. Data freeze for resource updates -- locking the data set used for a specific resource estimate so that subsequent drilling and assay data additions don't silently change the data set the estimate was based on. Version comparison between data freeze snapshots showing what new data was added between resource updates and how it changed the available sample count and grade distribution. Compliance data package generation for JORC, NI 43-101, or PERC reporting -- the drill hole data, QAQC statistics, and sample chain of custody documentation packaged for inclusion in the competent person's report.