Database containing harmonized datasets - FAIRWAY Project Deliverable 3.3

A database has been developed and delivered during the FAIRWAY project. This database was developed as a response to the need to harmonize datasets and assessment methods related to pressure and state indicators for water quality in the EU member states, in order to compare and assess indicators using a harmonized approach.

The dataset that is made available here provides two files:

a public version* of the Excel database, which contains all "tabular" (non-GIS) data related to the 13 case studies that was gathered for the purposes of FAIRWAY's Monitoring & Indicators research theme. It is structured as one "data sheet" and one "summary sheet" per case study. The data sheets contain various parameters (ideally time-dependent data series i.e. time series) that were used, wherever possible, to compute relevant Agri-drinking water quality indicators (ADWIs) such as "nitrogen budget" (a compound Pressure indicator) or "lag time" (a statistically-inferred Link indicator).

a ZIP folder containing all GIS data gathered for the FAIRWAY's Monitoring & Indicators research theme. The GIS files are grouped in subfolders, by case study, and then by keywords describing the nature of the spatial data.

The Excel database contains near 385,000 rows of data from the 13 case study sites, with more than 65 parameters and more than 500 sub-parameters. The dataset also contains spatial information in a GIS-data zipped folder. The spatial mapping information can be made visible using basic QGIS project files (.qgz), so that GIS data from each case study can be explored.

The indicators database can be used in several ways. It may be used to explore data or to calculate additional indicators. Depending of the case studies’ interests, the most commonly available State indicators are about nitrate and pesticides concentrations in water.

From a practical point of view based on its actual content, the database may notably be used to explore statistical relations (or Links) between related Pressure and State indicators. This database can also be used as a spatial mapping portal for other usages.

For more information on the database, follow this link.

* Note that this is a public version of the database, which means that all confidential data was removed from the data sheets.