The SISE-Eaux database of water intended for human consumption, archived by the French Regional Health Agency (ARS) since 1990, is a rich source of information. However, more or less regular monitoring over almost 30 years and the multiplication of parameters lead to a sparse matrix (observations × parameters) and a large dimension of the hyperspace of data. These characteristics make it difficult to exploit this database for a synthetic mapping of water quality, and to identify of the processes responsible for its diversity in a complex geological context and anthropized environment. A 10-year period (2006–2016) was selected from the Provence-Alpes- Côte d’Azur region database (PACA, southeastern France). We extracted 5,295 water samples, each with 15 parameters. A treatment by principal component analysis (PCA) followed with orthomax rotation allows for identifying and ranking six principal components (PCs) totaling 75% of the initial information. The association of the parameters with the principal components, and the regional distribution of the PCs make it possible to identify water-rock interactions, bacteriological contamination, redox processes and arsenic occurrence as the main sources of variability. However, the results also highlight a decrease of useful information, a constraint linked to the vast size and diversity of the study area. The development of a relevant tool for the protecting and managing of water resources will require identifying of subsets based on functional landscape units or the grouping of groundwater bodies.

Defining homogeneous units to optimize the monitoring and management of groundwater is a key challenge for organizations responsible for the protection of water for human consumption. However, the number of groundwater bodies (GWBs) is too large for targeted monitoring and recommendations. This study, carried out in the Provence-Alpes-Côte d’Azur region of France, is based on the intersection of two databases, one grouping together the physicochemical and bacteriological analyses of water and the other delimiting the boundaries of groundwater bodies. The extracted dataset contains 8627 measurements from 1143 observation points distributed over 63 GWB. Data conditioning through logarithmic transformation, dimensional reduction through principal component analysis, and hierarchical classification allows the grouping of GWBs into 11 homogeneous clusters. The fractions of unexplained variance (FUV) and ANOVA R² were calculated to assess the performance of the method at each scale. For example, for the total dissolved load (TDS) parameter, the temporal variance was quantified at 0.36 and the clustering causes a loss of information with an R² going from 0.63 to 0.4 from the scale of the sampling point to that of the GWB cluster. The results show that the logarithmic transformation reduces the effect of outliers and improves the quality of the GWB clustering. The groups of GWBs are homogeneous and clearly distinguishable from each other. The results can be used to define specific management and protection strategies for each group. The study also highlights the need to take into account the temporal variability of groundwater quality when implementing monitoring and management programs.

In France, the data resulting from monitoring water intended for human consumption are integrated into a national database called SISE-Eaux, a useful and relevant tool for studying the quality of raw and distributed water. A previous study carried out on all the data from the Provence-Alpes-Côte d’Azur (PACA) region in south-eastern France (1061 sampling points, 5295 analyses and 15 parameters) revealed that the dilution of the information in a heterogeneous environment constitutes an obstacle to the analysis of ongoing processes that are sources of variability. In this article, cross-referencing this information with the compartmentalization into groundwater bodies (MESO) provides a hydrogeological constraint on the dataset that can help to better define more homogeneous subsets and improve the interpretation. The approach involves three steps: (1) A principal component analysis conducted on the whole dataset aimed at eliminating information redundancy; (2) an unsupervised grouping of groundwater bodies having similar sources of variability; (3) a principal component analysis carried out within the main groups and sub-groups identified, aiming to define and prioritize the sources of variability and the associated processes. The results supported by discriminant analysis and machine learning show that the grouping of MESO is the best-suited scale to study ongoing processes due to greater homogeneity. One of the eight main groups identified in PACA, corresponding to the accompanying aquifers of the main rivers, is analyzed by way of illustration. Water–rock interactions, redox processes and their effects on the release of metals, arsenic and fecal contamination along different pathways were specifically identified with varying impacts according to the subgroups. We discussed both the significance of the principal components and the mean values of the bacteriological parameters, which provide information on the causes and on the state of contamination, respectively. Based on the results from two different groups of MESO, some guidelines in terms of a strategy for resource quality monitoring are proposed.

The main landfill in the city of Rabat (Morocco) is based on sandy material containing the shallow Mio-Pliocene aquifer. The presence of a pollution plume is likely, but its extent is not known. Measurements of spontaneous potential (SP) from the soil surface were cross-referenced with direct measurements of the water table and leachates (pH, redox potential, electrical conductivity) according to the available accesses, as well as with an analysis of the landscape and the water table flows. With a few precautions during data acquisition on this resistive terrain, the results made it possible to separate the electrokinetic (~30%) and electrochemical (~70%) components responsible for the range of potentials observed (70 mV). The plume is detected in the hydrogeological downstream of the discharge, but is captured by the natural drainage network and does not extend further under the hills.

When studying large multiparametric databases with very heterogeneous parameters (microbiological, chemical, and physicochemical), covering a wide and heterogeneous area, the probability of observing extreme values (Z-score > 2.5) is high. The information carried by these few samples monopolizes a large part of the information conveyed by the entire database. The study of the spatial structure of the data and the identification of the mechanisms responsible for the water quality are then strongly degraded. Data transformation can be proposed to overcome these problems. This study deals with a database of 8110 groundwater analyses (Occitanie region, France), on which the bacteriological load was measured in Escherichia coli and Enterococci, in addition to electrical conductivity, major ions, Mn, Fe, As and pH. Three modes of data conditioning were tested and compared to the treatment with raw data. The results show that log transformation is the best option, revealing a relationship between E. coli content and all the other parameters. By reducing the impact of extreme values without eliminating them, it allowed a concentration of information on the first factorial axes of the PCA, and consequently a better definition of the associated processes. The spatial structure of the principal components and their cartographic representation is improved. The conditioning of the data with the square root function led to an intermediate improvement between the logarithmic transformation and the absence of conditioning. The application of these results should allow a targeted, more efficient, and therefore, less expensive monitoring of water quality by Regional Health Agencies.