IMS was engaged to develop the requirements, architecture and data mart for a customer self-service website. The website provides water quality related measures to general consumers.

As the site is public facing, it was tested using our comprehensive testing methodology. Innovative features include the automatic withholding of unconfirmed test results and full operator audit-ability.

The solution was developed using SQL Server, utilising SSIS and spatial querying. You can visit the water quality website at:

The project automates the manual processes previously required to publish the daily lab results.

The data mart provides the data for the public website as well as supporting ad-hoc reporting.