Introduction

Increasing water demand globally, driven by agricultural, industrial activities, population growth, urbanization, and climate change, intensifies pressure on water resources (Kummu et al. 2016). About half of the global population faces severe water scarcity at least part of the year, with some regions experiencing year-round shortages (IPCC 2023) and as of 2022, 2.2 billion people were without access to safely managed drinking water (UN 2024). Pollution from fertilizers, pesticides, and wastewater further exacerbates water quality issues. In lower-income countries, inadequate wastewater treatment primarily contributes to poor ambient water quality, while in higher-income countries, agricultural runoff is the main concern. Evaluating water body status and sustainable water management are crucial to meet growing water demand and protect ecosystems. However, there is a lack of water quality data especially in many low- and lower-middle-income countries as ambient water quality data are not consistently gathered (UN 2023). This poses a risk to over 3 billion people, as their freshwater ecosystems may fall below acceptable standards (UNEP 2021).

Aquatic system monitoring programs are crucial for sustainable water quality management, yet complexities arise when handling vast amounts of data from numerous monitoring stations for many water quality parameters (Almeida et al. 2007). In many cases, water practitioners face difficulty to comprehend the monitoring results of a single water status/class due to the large amount of data obtained from monitoring studies which usually requires the need for advanced knowledge and expertise for evaluation (Zotou et al. 2020). However, water quality indices (WQIs) simplify interpretation by condensing data into a single value, aiding decision-making and assessing pollution impacts (Poonam et al. 2013). WQIs utilize diverse physicochemical, bacteriological, and metallic trace element data to generate final index values through subindices. WQIs are widely used globally for water quality assessment (Maansi Jindal and Wats 2021; Lopes et al. 2021; Uddin et al. 2021; Gupta and Gupta 2021; Al Falal et al. 2024). Moreover, WQIs are used to determine spatiotemporal variations in water quality (Noori et al. 2019), to analyze changes in water quality trends (Sun et al. 2016) and to compare water quality at different locations or geographical areas (Sun et al. 2016). Integration of WQIs with remote sensing and GIS enhances modeling (Mohammed et al. 2023, 2024; Muneer et al. 2021; Sattar et al. 2024).

WQIs can be categorized into four groups: general, specific, statistical, and planning/decision-making indices. General WQIs assess overall water quality, disregarding specific use designations, while specific WQIs target particular water uses (Abbasi and Abbasi 2012). Examples of general WQIs include the National Sanitation Foundation (NSF) (Brown et al. 1970), British Columbia WQI (Zandbergen and Hall 1998), Oregon WQI (Dunnette 1979), Overall Index of Pollution (OIP) (Sargaonkar and Deshpande 2003), River Pollution Index (Liou et al. 2004), Universal WQI (U-WQI) (Boyacioglu 2007), Canadian Council of Ministers of the Environment (CCME) WQI (CCME 2001a, b) and System for Evaluation of the Quality of rivers (SEQ-Eau) (SEQ-EAU 2003; SEEE 2008). The Aquatic Toxicity Index is an example of specific WQIs to evaluate the health of aquatic ecosystems (Wepener et al. 1992). The statistical WQIs apply statistical techniques, such as factor analysis and principal component analysis, to evaluate data instead of expert opinions and they identify the significance of important parameters in water quality assessment (Poonam et al. 2013). Harkin’s Index (Harkin 1974), Beta Function Index (Schaeffer and Janardan 1977), Mixed Aggregation Function (Liou et al. 2004), WQI based on multivariate techniques (Qian et al. 2007; Coletti et al. 2010) are some examples for the statistical WQIs. Starting with the study of Kung et al. (1992) artificial intelligence techniques were applied to develop WQIs often in conjunction with the statistical methods (Mahmood and Batool 2020; Elsayed et al. 2021a), spectral indices and multivariate modeling (Gad et al. 2020, 2022; Elsayed et al. 2021b). Planning/decision-making indices cover a wide range of applications including the impacts of ecoregional, hydrological and limnological factors, watershed quality and pollution assessment, irrigation water quality, reclaimed water for irrigation, drinking water adequacy, protection of stream corridor integrity and water quality buffers to control diffuse pollution (Abbasi and Abbasi 2012).

National regulations and regional water quality directives are commonly developed and applied to set environmental objectives, guide monitoring, and propose pollution control measures, such as The European Water Framework Directive (WFD) (EC 2000). However, national regulations or directives lack standardized methods for water quality classification, leading to compatibility issues (Trikoilidou et al. 2017; Zotou et al. 2020). Due to the involvement of different national and international agencies in water quality assessment globally, different indicator parameters are considered as water quality criteria for different beneficial uses of water, which complicates the comparison of final water status (Mogane et al. 2023). Additionally, water practitioners and researchers face difficulty to choose the best approach, national/international regulations, or alternative tools/methods, for the evaluation and classification of water quality (Gupta and Gupta 2021; Lukhabi et al. 2023). While previous research has explored the use of individual WQIs (Hamlat et al. 2017) or focused on specific geographic areas (Sener et al. 2017; Gikas et al. 2023), there is limited understanding of how different WQIs perform in assessing water quality dynamics in complex environmental settings (Syeed et al. 2023). Consequenly, there is a need for comparative studies of water quality classification using different methods and tools to test their accuracy and reliability (Chidiac et al. 2023). Therefore, this study aims to evaluate the effectiveness of three internationally well-known and mostly applied WQIs (CCME, NSF and SEQ-Eau) and a national water quality regulation in assessing water quality dynamics using the capabilities of the GIS, and to highlight the importance of methodological considerations in WQIs (parameter selection, sub-index calculation, and aggregation methods) which can significantly impact the accuracy of water quality assessments. The novelty of this study lies in its comprehensive comparative analysis of spatiotemporal variations in surface water quality using different WQIs and a national water quality regulation to provide a robust assessment of water quality dynamics. The study area of Acısu Creek in Antalya, Turkey, presents a good case study due to its specific environmental challenges. By conducting an intensive monitoring study involving on-site measurements and analysis of numerous physicochemical and bacteriological parameters, this research offers a comprehensive understanding of water quality in a region facing multiple sources of pollution (Muhammetoglu et al. 2022a). The comparison of WQIs allows for an in-depth evaluation of their strengths and limitations in assessing water quality, providing valuable insights for future research and water management practices.

Materials and methods

Study area

The pilot study area (PSA) of the Acısu Creek is about 40 km away from Antalya city center and it is located between Aksu and Koprucay Streams, in the south of Turkey, between the northern latitudes of 36°48’-37°9’ and the eastern longitudes of 30°57’-31°12’ (Muhammetoglu 2022b). The creek is within the Antalya River Basin and discharges to the Mediterranean Sea. The location of the PSA in Turkey and in Antalya province is depicted in Fig. 1 with the districts of Antalya. The whole length of the Acısu Creek is approximately 40 km and the total basin area is 37,818 ha. Approximately 71% of the basin consists of agricultural areas (26,710 ha) and 21% is covered by forests (7891 ha). In the northern part of the basin, the majority of the area is used or covered by forests and agricultural lands (Fig. 2a). Intense agricultural activities are carried out in the Acısu Creek Basin which is also an important tourism destination for local and international tourists.

Fig. 1
figure 1

Location of the study area in Turkey, Antalya province, and the districts

Fig. 2
figure 2

a Land-use and land cover in the Acısu Creek Basin and (b) locations of water quality monitoring stations

The Mediterranean climate is dominant in the PSA, with high precipitation in winter and high evaporation rates in summer. The mean annual air temperature, total annual precipitation, and surface evaporation rates were 19 °C, 782 mm/year, and 1392.5 mm, respectively, for the year 2021. The land elevations in the basin range from sea level to 1464 m above sea level where the elevation increases towards the northern part of the basin. The study area is located in the Antalya Neogene basin, encompassing Miocene and Pliocene basins. Geological units include the Miocene Karpuzçay Formation and Quaternary alluvial deposits. Erosion surfaces dating back to the Late Pliocene-Early Pleistocene are the oldest features, with elevations of about 100–120 m. Karpuzçay is the dominant formation, characterized by deltaic features and consisting of sandstone, mudstone, and siltstones. Rivers incise the terrain, forming steep valleys and wide delta plains. The Kızılot delta plain is formed by alluvium from Karpuzçay and Acısu Creek. The region features salty-alkaline areas and wetlands. A lagoon has formed behind the coastal barrier at the mouth of Acısu Creek. Wind transport inland has formed dunes reaching 5–10 m in elevation (Ozcelik 2017).

Between October 2020 and September 2021, the average flow rates at the upstream and downstream sections of the Acısu Creek were reported as 0.05 and 6.32 m3/s, respectively (Muhammetoglu 2022b). The upstream section of the creek has an average water depth of 0.15 m, while the midstream ranges from 1.2 to 2.7 m, with a maximum depth of 2.7 m. Downstream depths range from 1.0 to 2.5 m, with urban settlements and tourism concentrated in this area. Three wastewater treatment plants (WWTPs) discharge directly into the creek near the coast. These discharges, along with agricultural activities, are major sources of both point and diffuse pollution, leading to water quality deterioration. Excessive irrigation and reduced summer precipitation often lead to stagnation or drying of the upstream section (Muhammetoglu 2022b).

Water quality monitoring study

The monthly water quality monitoring study of the Acısu Creek was carried out at 12 sampling and monitoring stations (nine stations on the mainstem, and three stations on the tributaries (YK), see Fig. 2b) from September 2020 to September 2021. The coordinates of all monitoring stations are given in Table S1 in the Supplementary Material. The locations of the monitoring stations were selected considering several criteria such as geographical coverage, hydrological conditions, land use/cover, topography and geology, accessibility, hydrological connectivity and regulatory requirements to have a good representation of the spatial variability of water quality in the PSA.

Sampling of water was carried out in accordance with the national and international standards (ISO 5667-6 1990; ISO 5667-2 1991; ISO 5667-3 1994). Composite water samples (approx. 10 L) representing the entire width and water column were manually collected at each monitoring station and 2.5 L of this sample was transferred to polypropylene containers in the field and stored in cooled transport bags. For bacteriological analysis, 100 mL amber-colored glass bottles, previously sterilized, were submerged directly in the water at the mid-section of the creek. In stations without direct water access, samples were collected using a water sampling device and filled into sterilized bottles. A small volume (2 mL) was acidified with concentrated hydrochloric acid and stored under pH = 2 conditions. Measurements of dissolved oxygen (DO) concentration and percent saturation, pH, temperature, salinity, electrical conductivity (EC) and chlorophyll-a were carried out at the field using a multiparametric measurement probe (YSI EXO2). The color parameter was measured as true color at different wavelengths (436, 525, and 620 nm) using UV/VIS spectrophotometer (ISO 7887 2011). The analyses of suspended solids (SS), total alkalinity, bicarbonate, chemical oxygen demand (COD), and 5-day biochemical oxygen demand (BOD5) were conducted according to the standard methods (APHA 1998). Anion (nitrite, nitrate, phosphate, sulfate, fluoride, bromide and chloride) and cation (ammonium, calcium, magnesium, potassium, lithium and sodium) groups were analyzed by an ion chromatography system (Thermo Scientific Dionex ICS-3000 Reagent-Free Ion Ion Chromatography). The device comprises Dionex IonPac AS18 anion exchange and CS12A cation exchange columns, along with CSRS 300 cation suppressor and 300 anion suppressor conductivity detector. Total organic carbon (TOC) and total nitrogen (TN) parameters were analyzed simultaneously with a TOC/TN analyzer (HACH IL550 TOC/TN) according to the high-temperature catalytic combustion method. Total phosphorus (TP) was determined spectrophotometrically using the ascorbic acid method and persulfate digestion (APHA 1998). Total coliform, fecal coliform (FC), Escherichia coli (E.coli), and fecal streptococcus analyzes were conducted by membrane filtration method (APHA 1998; Myers and Sylvester 1997). Total dissolved solids (TDS) values were computed from EC values using the basic relationship of TDS (mg/L) = EC (µS/cm)*0.65. Quality control and quality assurance standards were met by regular calibration of instruments and equipment, use of certified reference materials and standard solutions, adherence to standard operating procedures for sample collection, preservation, storage, and analysis, including quality control samples in each batch. Instruments were maintained per manufacturer guidelines, lab personnel were trained in proper techniques and procedures, and data validation procedures were implemented to review for outliers, inconsistencies, and errors, documenting and investigating any deviations from expected results.

Regulatory approach for water quality classification

The classification of inland surface water bodies in Turkey is primarily determined by physicochemical parameters and follows the guidelines outlined in the Turkish Surface Water Quality Regulation (SWQR). This regulation encompasses rivers, lakes, as well as coastal and transitional waters (SWQR 2021). The determination of the overall physicochemical water quality class is based on the lowest class assigned to any of the parameters. There are three distinct quality classes: Class-I (indicated by a blue color, representing very good quality), Class-II (indicated by a green color, representing good quality), and Class-III (indicated by a yellow color, representing moderate quality). The water quality criteria of inland surface water resources are presented in Table S2 for general chemical and physicochemical parameters. Similar to the European WFD technique, the attained water quality class is further evaluated by additional quality components of biological, hydro-morphological, and chemical groups (for specific contaminants).

Water Quality Indices (WQIs)

In this study, the CCME, the NSF, and the SEQ-Eau WQIs were used for the comparative assessment of spatiotemporal water quality variations at the Acısu Creek. The CCME index is based on a formula developed by the British Columbia Ministry of Environment and modified by Alberta Environment (CCME 2001a, b). This index is one of the most widely used indices for assessing water quality (Tyagi et al. 2013; Sutadian et al. 2016; Regmi et al. 2017; van den Doel et al. 2023). The advantages of the index could be listed as; easy to calculate, tolerance to missing data, compatibility with different legal requirements and different water uses, and flexibility in the selection of input parameters and objectives (Terrado et al. 2010; Abbasi and Abbasi 2012; Tyagi et al. 2013). The index contains 3 factors: scope (F1), frequency (F2), and amplitude (F3). Scope (F1) refers to the number of variables that do not meet water quality goals. Frequency (F2) corresponds to the percentage of individual tests that do not meet objectives (failed tests) whereas amplitude (F3) represents the amount by which failed test values do not meet their objectives (CCME 2001a, b; Terrado et al. 2010; Hu et al. 2022). The CCME index value is calculated using the formula given in Eq. (1) where the divider 1.732 normalizes the resultant values to a range between 0 and 100. Water quality is classified according to the final index value into one of the following categories: 0–44 poor, 45–64 marginal, 65–79 fair, 80–94 good, 95–100 excellent (CCME 2001a, b). For the application of CCME WQI to the Acısu Creek, 27 water quality parameters were selected. Table 1 presents the selected water quality parameters with their target values (objectives) to sustain a good level of water quality for the protection of the ecosystem and the beneficial uses (suitable for water supply, irrigation water and aquaculture production) according to the relevant Turkish regulations and standards (SWQR 2021; WPCR 2004; RDWQ 2019) and international Blue Flag water quality criteria for microbiological parameters.

$$\text{CCME-WQI}=100-\left(\frac{\sqrt{{F1}^{2}+{F2}^{2}+{F3}^{2}}}{1.732}\right)$$
(1)
Table 1 The target values (objectives) of the selected water quality parameters for the CCME

The NSF index, developed by the National Sanitation Foundation in 1970, is one of the most widely applied WQIs in the literature and was proposed to compare the water quality of various water sources (Brown et al. 1970; Sutadian et al. 2016). Summarizing data in a single index value in an objective, rapid and reproducible manner, comparison of water quality for different areas, and identifying changes in water quality are the reported advantages of the NSF index (Tyagi et al. 2013). The calculation steps of the NSF index are summarized in detail in Fig. 3. In this study, NSF-WQI online calculator (WRC 2023) was used for the determination of the sub-index values. The website is open-access and provides a water quality report to the user. This report also includes the NSF index value, the number of parameters considered in the calculation, and the weighting factors assigned to these parameters. Water quality is classified according to the final NSF index value into one of the following categories: 0–25 very bad, 26–50 bad, 51–70 medium, 71–90 good, and 91–100 excellent (Brown et al. 1970).

Fig. 3
figure 3

Calculation steps of the NSF

The SEQ-Eau, developed by the French watershed agencies (SEEE 2008), is a tool to evaluate the physicochemical and microbiological quality of surface/groundwater and also identifies the parameters that cause deterioration in water quality. There are four steps to apply this index and in the first one, the alteration types and parameters are selected. In the second step, the weighted index of the analyzed parameters (IPpa) is determined for each monitoring station. The IPpa is obtained by considering the importance of the analyzed parameters on the deterioration of water quality, where the weight values usually range from 0 to 100. The weighted index for the analyzed parameter is calculated as shown in Eq. (2). In the third step, the weighted index for each alteration is determined by averaging the values of the weighted indices of the parameters that characterize the selected alteration. In the final step, the overall quality index is determined by selecting the lowest index value obtained from all considered alterations (Table 2). In this study, SEQ-Eau index values were calculated by the SEQ-Eau calculator which was developed by the authors using the Python programming language.

$$IP_{pa}=I_i+\left[\left(I_s-I_i\right)/\left(b_s-b_i\right)\right]\ast\left(b_s-p_a\right)$$
(2)

where IPp.a.: weighted index for the parameter analyzed, Ii: lower index, Is: upper index, bi: lower limit, bs: upper limit; and pa: analyzed parameter value. Water quality is classified into five categories as follows: 0–20 very poor, 20–40 poor, 40–60 average, 60–80 good, 80–100 excellent.

Table 2 Classification of surface water quality according to the SEQ-Eau index (SEEE 2008)

The water quality classes obtained for the Acısu Creek from both the regulatory approach and the applied WQIs were presented by the GIS maps to show the spatiotemporal variations of water quality. Additionally, correlation analysis was conducted to find similarities and differences between the assessment results obtained from the WQIs and the regulatory approach.

Results and discusssion

Water quality assessment according to the regulatory approach

Initially the water quality assessment results according to the relevant Turkish regulation, based on only general physicochemical water quality parameters, is presented as an example of a regulatory approach. To give brief background information about the water quality at the PSA, a statistical summary of the monitored water quality parameters is presented in Table S3 (in the Supplementary Material) for the upstream (Acısu-6) and downstream (Acısu-0) monitoring stations. Acısu-6 was chosen as the upstream station as the two stations upstream of Acısu-6 (Acısu-7 and Acısu-8) were frequently dry or stagnant during sampling sessions. Due to point and diffuse pollution sources, the water quality was gradually impaired in the downstream direction. Significant increases in EC and the main ions were caused by the mixing of creek water and seawater at the point of stream discharge into the Mediterranean Sea. The concentrations of nutrients (NH4-N, NO3-N, TN, PO4-P, and TP) and indicators of organic pollution (COD, BOD5, and TOC) were much higher at downstream in comparison to upstream sites. Additionally, the effluent discharges from three municipal WWTPs, located at the downstream section of the basin, adversely affected the bacteriological quality in the Acısu Creek.

According to the regulatory approach, initially, the water quality classes were determined for each monitoring session/station using the monthly measurement/analysis results of the physicochemical parameters (color measurements at three different wavelengths, pH, EC, COD, BOD5, NH4-N, NO3-N, TN, PO4-P, TP, F) according to the Turkish SWQR. The resultant water quality classes of the Acısu Creek are presented in Table 3 for all stations and sessions for the monitoring period between September 2020 to October 2021.

Table 3 Water quality classes (II: good, III: moderate) of the Acısu Creek for each monitoring session/station according to the Turkish SWQR

The monitoring results show the spatiotemporal variation of water quality for the investigated physicochemical parameters. As a result, water quality was classified as good for three monitoring stations, namely Acısu-3, Acısu-4, and Acısu-5, for all monitoring sessions, which are located in the mid-section of the creek. Additionally, the water quality class was moderate for two mainstem stations (Acısu-0 and Acısu-1) and two tributaries (YK-1 and YK-2) located at the downstream section of the Acısu Creek for all monitoring sessions. Two upstream monitoring stations (Acısu-8 and Acısu-7) were mostly dry during the monitoring period due to reduced precipitation and the water quality class was either good or moderate. The water quality of the YK-3 tributary showed a significant temporal variation as this sampling station was under the effect of drainage water from the agricultural lands and its quality was subject to frequent changes. The water quality of the remaining monitoring stations (Acısu-2 and Acısu-6) was either good or moderate depending on the monitoring sessions. Very good (Class I) water quality was not achieved at any monitoring station or session. The yearly average water quality classes of the Acısu Creek were also determined according to the Turkish SWQR using the yearly average values of the monitored parameters, as presented in Table 4 and Fig. 4a.

Table 4 The yearly average water quality values and classes (blue: very good, green: good, yellow: moderate) of the Acısu Creek
Fig. 4
figure 4

Water quality classes of the Acısu Creek monitoring stations according to (a) the Turkish SWQR as the regulatory approach, and (b) the CCME index

The resultant water quality class was moderate for four mainstem monitoring stations (Acısu-0, Acısu-1, Acısu-2, and Acısu-7) and two tributaries (YK-1 and YK-2) where the water quality was classified as good for the remaining stations.

The parameters that cause impairment of the water quality at the tributaries (YK-1 and YK-2) were EC, BOD5, NH4-N, PO4-P, TP, and DO. The water quality of the downstream monitoring stations (Acısu-0 and Acısu-1) was impaired due to increased concentrations of PO4-P and TP and very high values of EC due to mixing with seawater. The water quality was classified as very good for only color and fluoride parameters for all monitoring sessions. In general, the downstream section of the Acısu Creek, which extends from Acısu-2 till the discharge point to the Mediterranean Sea at Acısu-0, exhibited the lowest water quality for all monitoring sessions which causes an adverse impact on the coastal water quality as well. The discharges of the three municipal WWTPs were also effective in the deterioration of the water quality at the downstream monitoring station Acısu-0.

Results of the applied WQIs

In the CCME WQI application, 27 water quality parameters were selected and the water quality criteria ​​specified for Class II-good level was considered in determining the target values, in line with the goal of achieving good water status in surface water resources (RDWQ 2019; SWQR 2021; WPCR 2004). The CCME index values ​​were calculated using the monitoring data of 12 monitoring sessions and the results are presented on the GIS map (Fig. 4b). Table S4 (in the Supplementary Material) presents the number of failed parameters, failed test numbers, F1, F2, F3, the final index results, and water quality class. The CCME index results revealed that the water quality was excellent at the upstream station (Acısu-8) and it was gradually degraded to a very poor class towards the downstream point (Acısu-0). The degradation of water quality at Acısu-1, Acısu-0 monitoring stations and the two tributaries (YK-1 and YK-2) were due to exceedance of the target values ​​for many parameters including EC, TSS, TDS, DOsat, major ions, nutrients (NH4-N, TN, PO4-P, TP), indicators of organic pollution (BOD5, COD, TOC) and bacteriological parameters. The water quality was impaired at the YK-1 tributary due to drainage flow from agricultural lands whereas the other tributary, YK-2, receives the wastewater discharges of a municipal WWTP and diffuse pollution sources from the agricultural lands. The water quality was classified as good for two mainstem stations (Acısu-7 and Acısu-6) at the upstream and fair for the mid-section of the creek. The total test numbers were the lowest (107 tests) for the upstream monitoring stations (Acısu-8 and Acısu-7) as they were dry at most of the monitoring sessions. The downstream stations (Acısu-1 and Acısu-0) showed the worst water quality which failed to comply with the target values of the highest number of parameters (21 and 19 parameters, respectively, out of 27 total parameters) and failed tests (136 and 129 tests, out of 312 and 316 tests, respectively). The impairment of the water quality downstream is mainly due to diffuse sources of pollution from the upstream agricultural fields, the discharge of treated wastewater effluents, and the mixing of stream water with seawater.

In the NSF index, nine water quality parameters (DO, FC, pH, BOD5, NO3, PO4-P, temperature variation, turbidity, and total solids) are used to determine the water quality class and these parameters were all included in the NSF WQI application for the Acısu Creek. The NSF index results obtained for each monitoring session and station are presented in Table 5. For the 1st monitoring session in Sep 2020, the water quality class was good at all monitoring stations, and a good water quality class was determined for the upstream monitoring stations (Acısu-8 and Acısu-7) for all monitoring sessions. The water quality was gradually impaired at the mid-section of the Acısu Creek (starting from Acısu-6 and flowing downstream till the tributary YK-2) and exhibited both medium and good water quality classes during the whole monitoring period. The tributary, YK-2, exhibited the worst water quality among all monitoring stations and it was the only monitoring station where the water quality was classified as bad. This tributary also deteriorated the water quality at the downstream stations (Acısu-1 and Acısu-0) and the water quality class was mostly medium. The water quality class of the YK-1 tributary, which was either stagnant or dry during half of the monitoring sessions, was also medium and it was also effective to impair the water quality at the Acısu-0 monitoring station. The water quality was mostly impaired due to comparatively low sub-index values of FC, BOD5, nitrate, and total solids. The NSF index could clearly indicate the worst quality for the tributary YK-2 but it was not accurate to show the impairment of the water quality at the downstream section of the Acısu Creek. Among all monitoring sessions, the lowest NSF index scores and the worst water quality classes were obtained for the winter monitoring session in January 2021 and the resultant GIS map for this session is presented in Fig. 5a.

Table 5 The NSF index values and water quality classes (G: good, M: medium, B: bad) for the Acısu Creek for 12 monitoring sessions
Fig. 5
figure 5

Water quality classes of the Acısu Creek monitoring stations according to (a) the NSF index, (b) the SEQ-Eau index

Eight alteration groups containing 13 water quality parameters were considered for the SEQ-Eau index application to the Acısu Creek. The SEQ-Eau index results obtained for each monitoring session and station are presented in Table 6. Excellent water quality was observed only for a few monitoring stations and sessions whereas the mid-section of the Acısu Creek (starting from Acısu-6 and flowing downstream till the tributary YK-2) exhibited both medium and good water quality classes during the whole monitoring period. For the tributary YK-2, the water quality was mostly classified as poor due to Alteration No:4 Phosphorus which contains PO43− and TP. The SEQ-Eau index considers the lowest sub-index value from all alterations for the classification of water quality. As an example, the sub-index values of Alteration No:5 Mineralization were very low and the water quality was classified as very poor for all monitoring sessions due to very high EC values at the two downstream monitoring stations (Acısu-1 and Acısu-0).

Table 6 The SEQ-Eau index values and water quality classes (E: excellent, G: good, A: average, P: poor, V: very poor) for the Acısu Creek

Among all monitoring sessions, the lowest SEQ-Eau index scores and the worst water quality classes were obtained for the winter monitoring session in January 2021 for all monitoring stations, and the resultant GIS map for this session is presented in Fig. 5b.

Comparison of the applied WQI results and the regulatory approach

The comparison of the annual average WQI values of the NSF, CCME, SEQ-Eau indices and the regulatory approach are presented in Fig. 6. According to the SEQ-Eau index methodology, the lowest sub-index value obtained from all alterations is considered to determine the resultant index result. Therefore, the lowest WQI values ​​were obtained by the SEQ-Eau index, and the alteration which gave the lowest sub-index value was Alteration No:5 Mineralization which contains the EC parameter. In general, all the applied WQIs were consistent to evaluate the best state of the water quality at the upstream monitoring stations (Acısu-8 and Acısu-7) and the worst state of water quality at the downstream section of the Acısu Creek including two tributaries (YK-2 and YK-1) and two mainstem monitoring stations (Acısu-1 and Acısu-0). The good quality class of the upstream water was gradually impaired to medium quality class at the mid-section of the Acısu Creek. With the influence of the YK-2 tributary, the downstream water quality was evaluated to be bad/poor and even very poor. The temporal variation of the water quality was clearly shown by the NSF and the SEQ-Eau indices, as these WQIs could be applied for each monitoring session. As the CCME index requires to use at least four sessions of water quality monitoring results, this index is not suitable for the evaluation of short-term temporal variations of water quality. It was interesting to observe that nearly equal or very close yearly average index values were obtained from the three WQIs for the mid-section of the Acısu Creek, which covers the monitoring stations of Acısu-6, Acısu-5, Acısu-4, Acısu-3, Acısu-2, and YK-3 tributary. The water quality of the Acısu Creek was noticeably impaired by the influence of the tributary YK-2 that carries the effluents from a municipal WWTP and the diffuse pollution from the upstream agricultural lands. However, the NSF index was not successful to show the distinct impairment of the water quality at the downstream monitoring stations (mainly Acısu-0 and Acısu-1) because there are only nine fixed water quality parameters in the NSF index and they were not enough to present water quality variations due to mineralization and bacteriological pollution. The water quality evaluation results of the regulatory approach were included in Fig. 6 with the representative values of 80 for good (II) and 60 for moderate (III) water quality classes. The regulatory approach was not accurate and could not represent the spatial water quality variation.

Fig. 6
figure 6

Comparison of WQI results according to the annual average index values ​​and the evaluation results of the Turkish regulation for the Acısu Creek

In general, there were differences between the applied three WQI results and the final water quality classes for some of the monitoring stations and sessions due to the involvement of different water quality parameters in the WQIs and the differences in their calculation methodologies. At the PSA, the downstream water quality was highly impaired by the point discharges of three municipal WWTP effluents, diffuse pollution of TN, TP, and total solids from the upstream agricultural lands, and the mixing of stream water with the seawater that caused high increases in EC values and major ions. In this study, the NSF index, which is one of the most widely applied general WQI in the literature, was not accurate to evaluate the water quality variations for the PSA for some monitoring sessions/stations. Therefore, water practitioners and researchers need to choose the most appropriate WQI considering the spatiotemporal variations of water quality in their research area. Another important aspect is to include the essential water quality parameters in the WQIs with acceptable water quality criteria as target values. In this respect, the CCME index is very advantageous as the users are free to choose any number of water quality parameters and their target water quality criteria according to their needs.

For a better presentation of the similarities and differences between the three WQIs and the regulatory assessment results, the correlation values are given in Table S5. As a result, the lowest correlation (0.48) was between the regulation assessment and the NSF index results, while the correlation between the NSF and the CCME index results was comparatively high (0.75). The highest correlation was achieved for the SEQ-Eau and CCME index results with a correlation value of 0.95, which is very close to the best correlation value of 1. This very high correlation value reveals that the SEQ-Eau and CCME indices gave very close/consistent results and these indices were successful for accurate spatiotemporal evaluation of the water quality for the PSA by including a large number of water quality parameters. Additionally, the NSF index had relatively low correlation values with the other index results and was not able to respond well to the spatiotemporal variations of the water quality due to limited number of parameters involved.

Discussion

WQIs provide several benefits such as estimation of critical water quality parameters, resource/fund allocation, comparison of water quality at different locations & geographical areas, enforcement of standards, trend analysis, public information, and scientific research. Therefore, the use of WQIs is common worldwide and they have been widely applied and showed a significant development over the past several decades (Mogane et al. 2023). To date, more than 35 WQIs were developed for surface water quality evaluation globally (Abbasi and Abbasi 2012) and they were applied in many countries so far. Although WQI applications cover different types of surface water bodies, such as lakes, rivers, and estuaries, more than 80% of the WQI applications were for rivers, and in about half of the studies the CCME and the NSF indices were applied (Uddin et al. 2021).

The majority of WQIs consist of four steps: parameter selection, parameter sub-index determination, parameter weight determination, and aggregation of the sub-indices to compute the overall WQI. Most of the WQIs in the literature employed 8 to 11 water quality parameters where the most commonly included parameters in the WQIs are temperature, turbidity, pH, suspended solids, TDS, FC, DO, BOD, and ammonium-N. Some WQIs offer flexibility in parameter selection such as the CCME, whereas in some WQIs, such as the NSF, the users can only consider the fixed parameters of the WQI. In some circumstances, the conventional WQIs, which do not consider biological parameters, heavy metals, or toxic organic material, may falsely ignore the major factors for the ecological deterioration of river ecosystems. Therefore, expert knowledge and experience are important for parameter selection and also the use of statistical analysis (correlation, principal component, cluster, or discriminant) is helpful to choose the critical/important water quality parameters (Chidiac et al. 2023; Mogane et al. 2023). The second stage of sub-index calculation and the third state of parameter weighting are crucial components of the WQI methodology and they have a direct effect on the final WQI result. However, some WQIs may omit these stages, such as the CCME. The weights used for the same parameters vary significantly between the WQIs and the use of advanced methods, such as the Analytical Hierarchical Process, is recommended to determine the significance of the parameters and reduce uncertainty. In general, the differences between the WQI results are primarily due to the selection of different water quality parameters, differences in the number of selected parameters, assigned weights to the parameters and the aggregation formulas to compute WQI results. Another important aspect of the use of WQIs is the general problems of ambiguity, eclipsing, rigidity, and uncertainty (Gupta and Gupta 2021; Syeed et al. 2023). The eclipsing effect is commonly reported as the main drawback of the many WQIs. Due to the eclipsing effect, one or more parameters that have values above permissible limits could be masked if the rest of the parameters are within the limits. The use of a minimum operator index aggregation function or automated aggregation function is recommended to minimize the eclipsing effect. Additionally, the aggregation function is shown as a major source of uncertainty, and the use of multiplicative aggregation function and statistical approaches are recommended to mitigate uncertainty in the selection and weighing process of parameters.

In the presented case study of the Acısu Creek, three WQIs were utilized, each employing different parameters, calculation methods, and parameter weights. This comparative analysis revealed the strengths and weaknesses of each index. The NSF index was not accurate for the evaluation of the water quality at the PSA for some monitoring stations/sessions due to eclipsing and rigidity issues while the CCME index demonstrated flexibility and efficiency in spatiotemporal evaluations. The SEQ-Eau index, commonly used in France, Morocco, Cameroon, and Algeria (Nyamsi et al. 2017; El Madani et al. 2019; El Hmaidi et al. 2022) also showed promising performance in assessing water quality variations. Overall, both the CCME and SEQ-Eau WQIs exhibited good efficiency and accuracy in evaluating water quality. To compare the findings of the presented research, three recent studies from the literature were taken into account, which examine the effectiveness of various WQIs across diverse geographical locations. In the study of Hamlat et al. (2017), ten WQIs were employed to evaluate trends of water quality in the Tafna basin in Algeria, and the researchers stated significant variations in results, with CCME and British Columbia WQI providing the most accurate assessments. Similarly, in the study of Gikas et al. (2023) the applicability of four WQIs were investigated to evaluate status of small rivers in Northern Greece. This study revealed the significant differences in quality classification among methodologies where CCME demonstrated superior capability in assesing spatiotemporal variations in river water quality. In the third study, WQI adaptations for monitoring water quality in Africa were compared and the researchers identified CCME as one of the most suitable indices and highlighted biases towards physicochemical parameters and recommended improvements, such as incorporating biological metrics and employing less subjective statistical methods (Lukhabi et al. 2023). Despite variations in geographical settings, all studies underscore the importance of tailoring WQIs to reflect the unique conditions of water bodies, emphasizing the need for adaptable methodologies to support effective environmental management globally.

This study serves as a notable example of comparative research on WQIs for water practitioners and researchers, offering insights into the spatiotemporal variations in surface water quality, the performance of different WQIs and evidence-based information to support their efforts in monitoring, protecting, and managing water resources effectively. The practical implications include improved assessment methods, informed decision-making, methodological guidance and capacity building to conduct comprehensive evaluation of water quality and implement effective management strategies.

Conclusions

Developing a tailored WQI for a water body, considering its unique conditions like geography, hydrology, discharge rate, and pollution sources, is crucial for accurately reflecting water quality and guiding environmental planners to design and implement effective pollution abatement strategies. While the previous research has explored the use of individual WQIs or focused on specific geographic areas, there is limited understanding of how different WQIs perform in assessing water quality dynamics in complex environmental settings. Therefore, this study evaluated the accuracy and reliability of the three internationally well-known and commonly applied WQIs (NSF, CCME, and SEQ-Eau) and a regulatory approach for assessing water quality dynamics using the capabilities of the GIS, and highlighted the importance of WQI methodologies for parameter selection, sub-index calculation, and aggregation methods. The pilot study area (PSA) of the Acısu Creek offered a good case study for comprehensive understanding and assessment of spatiotemporal variations of water quality in basins facing multiple sources of pollution. Consequently, the novelty of this study lies in its comprehensive comparative analysis of spatiotemporal variations in surface water quality using different WQIs and a national water quality regulation to provide a robust assessment of water quality dynamics. Although, the selected WQIs employed different numbers of water quality parameters, sub-index calculation and aggregation methods, the results of the two WQIs (CCME and the SEQ-Eau) showed a very high correlation and they were efficient and adequate to evaluate the spatiotemporal variations of the water quality at the PSA. The third WQI, NSF, was not accurate for the evaluation of the water quality at the PSA for some monitoring stations/sessions due to the eclipsing and rigidity problems. The presentation of the index results through GIS maps improved the interpretation of the results and provided a good visualization. Selecting the most appropriate WQI for spatiotemporal evaluation poses a challenge for both water practitioners and researchers. However, this study offers valuable insights for future investigations as follows: (i) the process of selecting the optimal WQI entails considering factors such as the specific water quality characteristics of the site, data availability, and the researcher’s expertise, (ii) maintaining flexibility in choosing water quality parameters and their target values enhances the spatiotemporal assessment, accommodating different water use designations, (iii) it is crucial to assess and quantify the uncertainty associated with WQIs for any given application, (iv) utilizing multiple WQIs facilitates comparison and aids in determining the most representative water quality evaluation. For future work, statistical analysis, multi-criteria decision-making methods, artificial intelligence, and fuzzy rules can be incorporated into the WQIs to overcome the general problems of eclipsing, rigidity, and uncertainty.