Specifications include, but are not limited to: CT DEEP seeks to replace the AWQ database and the Access database with a cloud-based Ambient Water Quality
(“cAWQ”) solution that will have the capability to house all of CT DEEP’s water quality data, both historical and day
forward, and then also flow all of CT DEEP’s water quality data to EPA’s WQX data system. The proposed solution must
be COTS with a demonstrated implementation history by other Public Agencies. Specific requirements outside the
capabilities of the current COTS solution must be rated on a scale ranging from “minor modification required”, “major
customization required”, to “cannot meet the requirement”.
I. cAWQ Requirements
a. cAWQ must be a cloud-based system hosted and maintained by the contractor securely off site.
b. cAWQ must store physical, chemical, biological data and metrics related to water quality in rivers, lakes and
c. cAWQ must support importation, storage, maintenance (view, insert, update, delete), reporting and WQX
reporting of all water quality data. Examples of a subset of data files to be imported are provided in
d. cAWQ system must, via automated processes, flow data to STORET using the WQX XML schema (data flow)
through an Exchange Network Node (version 2.1 or most current version).
e. cAWQ must allow CT DEEP to view, insert, update, and delete all water quality data.