Turn Drinking Water Quality Data Into One Connected Record
Connect field sampling, laboratory results, sampling locations, QA/QC information, and historical records in one field-to-report workflow — so water teams can move from fragmented spreadsheets to organized, traceable water quality data.
Drinking Water Data Is Collected Everywhere. Managing It Shouldn't Be Fragmented.
Drinking water quality monitoring can involve field operators collecting samples across distributed systems, laboratory teams performing different tests, and compliance or water-quality staff consolidating the results into reports and dashboards.
The challenge is not simply collecting data. The challenge is keeping the information connected.
Field Sampling
01Sample IDs
02Laboratory Results
03Spreadsheets
04QA/QC Review
05Reporting
06
Field records may live in separate forms or spreadsheets.
Laboratory results may arrive as PDF or Excel files.
Sample IDs must be matched correctly between field records and laboratory results.
Sampling locations are distributed geographically.
Historical records become difficult to search and compare.
Reviewing large datasets manually can require significant spreadsheet work.
One Connected Workflow From Water Sampling to Water Quality Insight
Capture Structured Field Data
Field operators collect water quality and sampling information directly in the mobile app — at the sampling point, not back at the office.
Sampling location
Sample ID
Date and time
Operator
GPS/location
Field measurements
Chlorine/residual measurements
Turbidity
Observations
Notes
Photos or supporting evidence where required
Keep the Sampling Record Traceable
Every collection event can retain the context behind the result, so a value found in a report can always be traced back to the sampling event that produced it.
Connect Laboratory Results
Laboratory information can be provided through sources such as PDF or Excel files and associated with the corresponding field records using sample identifiers.
The field record and the laboratory result should not become two disconnected datasets.
Turn the Unified Dataset Into Useful Outputs
Once field and laboratory information are connected, the same underlying dataset can support the different views and outputs your team needs.
The Water Quality Record Starts in the Field
The Drinking Water Distribution System starter template ships with the CRD Drinking Water Distribution System sampling form and 500 sample records to explore.
CRD Drinking Water Distribution System
Water System*
SP Code*
SP Descriptions
SP Location*
Sample ID*
Date*
Time*
Water Temp (°C)*
Total CL2 Res (mg/L)*
Total Coliforms
E. coli
Turbidity
CRD Drinking Water Distribution System
Central Saanich Distribution System
CES-BR-09
Grieg Ave @ Grieg Pl (QC1 in meter box)
48.56701, -123.45209
SAM-2025-04757
2025-06-26T00:00:00.0000000Z
13:00:00
16.5
1.23
—
—
—
Report ready: Water Distribution Compliance Record
Collect the information needed to understand not only the result, but where, when, and how that result was generated.
From Water Quality Records to Operational Visibility
Three sequential views of one connected dataset — the same records your crews collect, reviewed the way each part of your team needs them.
See the Water Quality Dataset and Where It Occurs
Combine high-level water quality indicators with geographic context to understand the monitoring program and where sampling activity occurs.
Dataset KPIs and spatial context, viewed together. View in the aQRate portalCompare Water Systems and Their Results
Compare monitoring information across water systems to make differences, patterns, and records requiring further review easier to identify — supporting your review, not replacing it.
Benchmarks help identify patterns and records requiring attention. View in the aQRate portalConnect Water Quality Data With Operational Context
Bring operational and logistics information into the same connected dataset so teams can review water quality information alongside the context surrounding field activities.
Field activity context, connected to the same dataset. View in the aQRate portalOne Dataset. Multiple Views.
The goal is not another dashboard. The goal is a connected dataset that can support the different views water teams need.
See a Drinking Water Quality Workflow in Action
Our demonstration — From Spreadsheet Chaos to Audit-Ready Insights: A Drinking Water Quality Data Unification Case Study — shows how fragmented drinking water information can be brought together into a unified dataset, then reviewed, filtered and visualized.
12
distinct water systems
191
unique sampling points
9,885
sampling events
~150,000
data points
52
weeks of 2025 data
Built for Teams Managing Drinking Water Data at Scale
Municipal Water Providers
Connect field sampling, laboratory results, locations, and historical water-quality records.
Regional Water Districts
Manage monitoring information across multiple water systems and geographically distributed sampling points.
Water Quality & Compliance Teams
Search, filter, review, and visualize large volumes of monitoring data.
Environmental & Water Consultants
Build structured field-to-report workflows for drinking water monitoring programs.
Field Operations Teams
Collect consistent water-quality and sampling information directly in the field, including offline workflows where required.
From Signup to Connected Water Quality Data in Six Steps
Step 1 — Create Your Free Account
Sign up on the aQRate portal and start with the Drinking Water Distribution System template in one click.
Step 2 — Download the Mobile App
Get the aQRate field app for iOS and Android — it works offline and syncs when a connection returns.
Step 3 — Build or Choose Your Sampling Form
Configure the fields, sampling information, parameters, and evidence your workflow requires — water system, sampling point, sample ID, chlorine residual, turbidity and more.
Step 4 — Collect Data in the Field
Operators collect structured sampling records using the mobile app, with GPS, photos and notes captured at the sampling point.
Step 5 — Connect and Review the Data
Bring together field records and laboratory results, then review and manage the unified dataset with configurable QA/QC information.
Step 6 — Generate Reports and Visualizations
Turn connected records into maps, dashboards, filtered views, and reporting outputs such as the Water Distribution Compliance Record.
Turn Drinking Water Data Into a Connected, Traceable Workflow
Stop moving water quality data between disconnected forms, spreadsheets, laboratory files, and reports. Build a workflow that keeps the field record, laboratory result, location, QA/QC context, and final output connected.