Every environmental consultant and geotechnical engineer knows the pain of a disorganized drilling program. It starts with field notebooks, shifts to disjointed standalone cameras, and ends with a geologist spending days manually copying handwritten notes into spreadsheet templates.

When the laboratory results finally arrive days later, the manual data consolidation starts all over again. And then the final work begins to filter, organize and transcribe all this information into a 1-page pictorial borehole log representation. 

This fragmented workflow isn't just inefficient. It introduces transcription errors, delays client reporting, and increases regulatory compliance risks.

To demonstrate how aQRate by Roshan Water closes the loop between field chaos and engineering-ready intelligence, we’ve published our latest demo use case: The High-Resolution Subsurface & Compliance Study.

The Core Pillars of a Modern Borehole Log

Built around a rigorous, 1.5-meter sampling framework across 4 distinct boreholes, this case study tracks a complete data lifecycle from the drill bit to an executive web dashboard. It highlights how aQRate replaces legacy paperwork with automated, data-driven guardrails:

  • Integrated Geotechnical Validation: The platform seamlessly links qualitative field data (such as USCS soil classification, color, and moisture dropdowns) with real-time quantitative tests like Standard Penetration Test (SPT) N-values.

  • Unbreakable Chain of Custody (CoC): As soon as a sample is logged at a specific depth, aQRate uses the Sample ID (e.g., BH01-15), instantly building a digital CoC to streamline lab handoffs and eliminate mixed-up samples.

  • Automated Lab Handoff & Quality Control: Once the physical soil cores are processed, quantitative field and laboratory data—including Water Content (%), Recovery (%), and detailed Grain Size Analysis—are mapped directly back to the original field log.

  • 1-Click Borehole Logs Visuals: Backed by aQRate's powerful AI Generator, the Visualizations module creates custom made visual borehole logs alongside all the required charts and graphs.

Instant Compliance Alerting

The true power of a unified data ecosystem lies in its ability to protect public health and project timelines. In this use case, as soon as the groundwater laboratory data is imported, aQRate's automatic compliance engine evaluates the results against local regulations (such as Health Canada's GCDWQ standards).

Instead of an engineer manually cross-referencing a 100-page regulation PDF, the system instantly catches and flags toxic thresholds—such as a dangerous 45.0 mg/L Nitrate exceedance or elevated Iron concentrations—the exact moment they hit the system.

Stop fighting with manual spreadsheet macros and disconnected field tools. It’s time to empower your hydrogeologists, compliance officers, and stakeholders with automated, high-resolution subsurface analytics. Here are two custom made Visualizations reports from the same set of borehole log data:

🔗👉Detailed Visualization Report

 

Important Notes: While the Visualizations above is an example of the end goal for any project, this level of detailed 1-click report generation would have been impossible without aQRate’s infrastructure in seamless end to end data collection & management. Here is a 🔗👉quick video showing how different components of aQRate play a role in projects like the one above.

Scale Efficiency, Not Headaches

Whether you are managing a smaller projects with a limited number of boreholes, or running a large scale assessment with multiple boreholes,  the administrative bottleneck is the same. By bridging the gap between field collection, laboratory analysis, and final reporting, aQRate cuts reporting turnaround times by up to 50% while completely removing the risk of human error.

Ready to see how aQRate can modernize your team's data workflows? 🔗👉Book a brief 15-minute demo today.