Subscribe to the CHEMICAL INVESTIGATIONS PROGRaMME - Data ACCESS PORTAL
Search and extract the measurements from 600 Wastewater Treatment Sites owned and operated by UK Water Companies and part of the Chemical Investigations Programme (CIP2).
This UKWIR Tool is available to all-comers who have created an account with UKWIR, subscribed to the Tool and confirmed acceptance of the Terms and Conditions of Use.
Using the tool, the logged in user may view;
- The list of contributing Companies
- The list of Sewage Treatment Works included
- The Determinands included in the data collection
There are 3 million determinand readings in total. So, the tool has been developed to enable users to filter and extract the specific information they are seeking, rather than downloading all 3 million records each time.
To assist you to find what you are after, we have provided the following methods;
- Search by Determinand – Filter the database to find specific determinands
- Search by Sewage Treatment Works – Locate and view all determinands for a particular works
- Search by Company – Filter all the determinand data for a particular Companies contributing Sewage Treatment Plant.
You are guided though the process of building your filter, at the end of which we;
- run the filter
- Store your settings
- return to your list of data Filters
- store your data extract
On the list of your date filters we include buttons, to;
- Access and modify your filter
- Access the data you have gathered. Clicking this will open the data in a viewer, so you can inspect it. The viewer includes a button, in its top toolbar, where you can download an Excel spreadsheet of it.
- View your extracted data in a chart, together with a tool to export the chart as a picture.
You can modify your filter and / or create as many filters as you require.
- CIP2 data files, as reported by the participating water companies in England and Wales, are held as an archive containing all effluent, influent and environmental data that relate to elements of the programme that are complete . Work in progress is not included.
- Each CIP site (relating to a wastewater treatment works) may include river quality upstream and downstream of the sewage effluent discharge, together with effluent and (in some cases) influent quality at the treatment works.
- Sites were selected to reflect the highest risk of potential failure to comply with Environmental Quality Standards, primarily as defined in the Water Framework Directive. This corresponded in the main to sites where the available dilution in the receiving water was lowest – though some sites were chosen on the basis that a number of discharges in a given river catchment might pose risk where a single one might not.
- Effluents and influents were sampled on 20 occasions over a two-year period. Riverine samples were taken on 36 occasions over approximately the same period.