Granthaalayah

SOFTWARE FOR CALCULATING A WATER QUALITY INDICATOR SPECIFIC TO THE AMAZON REGION

 

A.M. F. de Souza *1Envelope, S. F. P. Pereira 2, 3Envelope, L. P. Santos 2, 4Envelope, C. S. e Silva 2, 5Envelope, R. M. Rocha 2, 3, 6Envelope, R. M. de Sousa 1Envelope, D. P. Nogueira 2Envelope

1 Center of Exact Sciences and Technology, University of Amazon, 66060-000, Belém-Pará, Brazil

2 Laboratory of Analytical and Environmental Chemistry, Federal University of Pará – University Campus José da Silveira Neto, Rua Augusto Corrêa S/N - 66075-900, Belém-Pará, Brazil

3 Chemistry Graduate Program, Federal University of Pará – University Campus José da Silveira Neto, Rua Augusto Corrêa S/N - 66075-900, Belém-Pará, Brazil

4 Federal Rural University of the Amazon, Avenida Perimetral 2501 - Terra Firme, 66077-830, Belém-Pará, Brazil

5 Federal Institute of Education, Science, and Technology of Pará, Av. Almirante Barroso, 1155 - Marco, 66093-020, Belém-Pará, Brazil

6 Central Laboratory of the Health Secretariat of Pará, Rodovia Augusto Montenegro, km 10 -  66823010, Distrito de Icoaraci - Belém-Pará, Brazil

 

DOI: https://doi.org/10.29121/granthaalayah.v9.i3.2021.3802

A drawing of a face

Description automatically generated


Article Type: Research Article

 

Article Citation: A.M. F. de Souza, S. F. P. Pereira, L. P. Santos, C. S. e Silva, R. M. Rocha, R. M. de Sousa, and D. P. Nogueira. (2021). SOFTWARE FOR CALCULATING A WATER QUALITY INDICATOR SPECIFIC TO THE AMAZON REGION. International Journal of Research -GRANTHAALAYAH, 9(3), 248-261. https://doi.org/10.29121/granthaalayah.v9.i3.2021.3802

 

Received Date: 15 March 2021

 

Accepted Date: 31 March 2021

 

Keywords:

Software

WQI

Amazon
ABSTRACT

The quality of the water in the Amazon's reservoirs is of fundamental importance for natural ecosystems, biota, and for the region's population. Maintaining the water quality involves long-term monitoring programs established by the requirements of Brazilian legislation. A web interface may facilitate the use of monitoring results routinely, which allows periodic insertion of previously selected water quality parameters results, to finally provide a simple and direct way to evaluate the water quality. The general objective of this study was to develop a software based on a water quality indicator (WQI) system considering chemical, physical-chemical, and biological parameters evaluated in four seasonal periods in Samuel dam. Multivariate analysis was used to select 10 significant variables (oxidation-reduction potential, dissolved oxygen, total dissolved solids, chlorophyll a, phosphate, Ba, Ca, Fe, Na, and Sn). The web software added innovation to the project, enabling to storage of data from analysis of field-collected samples in an organized and safe way in a database, in addition to speeding up the calculation of the WQI, making it possible to classify the water quality more quickly and accurately.



 

1.     INTRODUCTION

 

      Water is a vital resource, both to sustain life and for the global economy, being the rivers of the Amazon an important natural source for the planet. The water quality of these resources has been lost over time due to anthropic factors such as the lack of basic sanitation, mining, the use of pesticides in agriculture, industrial activity, among other factors (Cantonati et al., 2020).

Assessing water quality, i.e. its chemical, physical, and biological characteristics, for different purposes of use, such as domestic, irrigation, conservation, and industrial use, is an important strategy for food security and human health (Matta et al., 2020; Son et al., 2020).

Several chemical, biological, and physicochemical parameters have been used as water quality indicators with reference values varying according to each country legislation (Santos et al., 2020; Pereira et al., 2011), such as concentration of metals (chemical) (Mokarram et al., 2020; Miranda et al., 2009), coliforms (biological) (Manara & Clemente, 2011), and pH and DO (physicochemical) (Pereira et al., 2020). In the Amazon and other locations, water quality parameters have also been used to determine water quality indicators (WQI) (Maulud et al., 2021; Costa et al., 2020; Oliveira et al., 2017).

The water quality indicators (WQI) setting is essentially based on the formulation of a method for calculating a value to assess the usability of a waterbody for a given purpose, based on parameters of water samples previously analyzed and which must be within certain limits. The use of water quality indicators is a tool to improve communication between interested parties, which play a fundamental role as a facilitator for the protection of water sources.

The process of building a water quality indicator is complex, and there is no clear rule for such a process (Zuffo et al., 2013; Medeiros, 2012). However, a set of parameters that measure the characteristics considered important should be selected in the indicator construction. These characteristics can be physical, chemical, and even microbiological. After defining the characteristics, the next phase consists of determining a rule that reduces all the information related to the parameters of interest in a single number, i.e. in the water quality indicator.

Different methods have been proposed: from deterministic processes, such as those proposed by the National Sanitation Foundation of the United States of America (Brown et al., 1970) and by Provencher and Lamontage (1977), to the use of more sophisticated techniques related to computational intelligence, such as, for example, the fuzzy logic (Gharibi et al., 2012) and the Artificial Neural Networks (Gazzaz et al., 2012).

To automate the WQI calculation process, it is necessary to develop a software to register the parameter values of the water collection samples in a database and use this data to perform the WQI calculations according to a pre-established method, and later enabling to visualize this information. The Surface Water Quality Assessment Tool (SWQAT) is a software developed by Sharma et al. (2013) to calculate the Overall Index of Pollution (OIP), which employ physical-chemical, toxicological, and bacteriological parameters to classify water quality as 'Excellent', 'Acceptable', ‘Slightly Polluted', 'Polluted', and 'Heavily Polluted'. In addition, Nabizadeh et al. (2013) developed a software for calculating the WQI named Iranian Water Quality Index Software (IWQIS), which, like SWQAT, is based on the three fundamental functions of data inclusion, data processing, and visualization of results. However, the IWQIS allows the user to select the parameters that should participate in the WQI calculation, along with dynamically assigning the weight, unlike SWQAT.

The software development process requires different steps that are based mainly on a well-defined understanding of the user's needs, database construction, and development of the program that will perform the functions of data entry, processing, and output. The database construction process involves the development of a data model (Elmasri & Navathe, 2015) that contemplates the entities and their respective attributes, which are of interest within the scope of the system, which in this study is aimed to assess the water quality. After defining the database, the software proceeds to the developed phase, using a programming language.

This study aimed to develop a software to calculate the water quality index (WQI) using multivariate statistics in the treatment of the water quality parameters obtained in Samuel dam, state of Rondônia in the Brazilian Amazon, in four seasonal periods.

 

2.     MATERIALS AND METHODS

 

This study was conducted by researchers from the Laboratory of Analytical and Environmental Chemistry (LAQUANAM) at UFPA, Eletronorte Environmental Protection Center, LACEN-SESPA (Pará State Health Secretariat), IFPA, and UFRA, at the Samuel hydroelectric plant reservoir, between 2015 and 2016, in the seasonal periods of greater and lesser rainfall (Rainy – March, and Drought - September) and two intermediate periods (Intermediate 1 – June, and Intermediate 2 - December).

2.1. LOCATION

 

Samuel hydroelectric dam is located on the Jamari River in the municipality of Candeias do Jamari, 50 km from the city of Porto Velho, in the state of Rondônia, in the Amazon region - Brazil, at 08º 45' 04” south latitude and 63º 27' 14” west longitude (Fig. 1). The facility initiated its activities in 1989, with an installed capacity of 216 MW (Santos et al., 2015).

The hydrographic basin of the Jamari River is relatively small compared to other basins in the Amazon, with 15,280 km2, only 26 times larger than the area of the 585 km² reservoir with a length of 120 km (Santos et al., 2015).

For the development of the area map, the free QGIS program found on the site https://qgis.org/downloads/QGIS-OSGeo4W-3.10.7-1-Setup-x86_64.exe (public domain) was employed.

 

2.2. SAMPLE COLLECTION AND ANALYTICAL METHODOLOGY

 

The water samples were collected from the surface according to the national guidelines for the collection and preservation of water, sediment, aquatic communities, and liquid effluents of the Brazilian National Water Agency (ANA, 2011) in 11 sampling stations and georeferenced through a global positioning system (GPS) (Table 1).

The evaluated parameters were chloride, chlorophyll a, conductivity, apparent color, true color, COD (chemical oxygen demand), oxidation-reduction potential (ORP), phosphate, NH4+, nitrate, dissolved oxygen (DO), pH, total dissolved solids (TDS), temperature, transparency, turbidity, and metals (Ag, Ba, Be, Ca, Cd, Co, Cr, Cu, Fe, K, Mg, Mn, Na, Ni, Pb, Sn, Sr, Ti, V, and Zn).

The variables conductivity, DO, pH, ORP, TDS, temperature, transparency, and turbidity were analyzed at the collection site using field equipment. The equipment employed was calibrated before use (Table 2).

 

Figure 1: Samuel dam location map - Rondonia - Brazil

Table 1: Location of sampling stations in the Samuel dam.

Code

Sampling station

Latitude (S)

Longitude (O)

SA-M1

Upstream 1

08o 45’ 02.0”

63o 26’ 26.5”

SA-M4

Upstream 4

08o 50’ 48.8”

63o 19’ 56.8”

SA-M4E

Upstream 4, left margin

08o 51’17.9”

63o 20’ 25.6”

SA-M5

Upstream 5

08o 55’ 09.2”

63o 16’ 51.8”

SA-M8

Upstream 8

09o 04’ 46.4”

63o 18’ 15.7”

SA-M9

Upstream 9

09o13’ 51.5”

63o 11’ 34.9”

SA-M11

Upstream 11

9°42'57.92"

63° 7'18.12"

SA-J1

Downstream 1 – Jamari River

08º 45' 04.4"

63º 27' 20.0"

SA-J2

Downstream 2 - Jamari River

08º 39' 14.6"

63º 31' 46.2"

SA-J3

Downstream 3 - Candeias River

08º 38' 06.8"

63º 32' 14.7"

SA-J4

Downstream 4 - Jamari River

08º 37' 39.6"

63º 31' 17.7"

 

Table 2: Equipment used in the analysis of the parameters

Parameter

Equipment

Transparency

Secchi disc

Temperature, pH, ORP, DO, TDS, and conductivity

Multiparameter probe Hanna HI98194

Turbidity

Turbidimeter Policontrol AP2000

Chloride, nitrate, and NH4+

Ion-selective analyzer Hanna

Chlorophyll a

Spectrophotometer UV-Vis Even

Phosphate, apparent and true color

Colorimeters Hanna

COD

Digestion with K2Cr2O7 and titration

Metals (Ag, Ba, Be, Ca, Cd, Co, Cr, Cu, Fe, K, Mg, Mn, Na, Ni, Pb, Sn, Sr, Ti, V, and Zn)

Optical emission spectrometer with inductively coupled plasma (ICP-OES), Varian, Vista Pro model

 

The analytical methods adopted followed the standards of the Standard Methods for the Examination of Water and Wastewater (APHA, 2005), and other technical standards. All analyzes were performed in triplicate. The operating conditions of the ICP-OES are shown in Table 3.

Samples for the analysis of chloride, chlorophyll, apparent color, true color, chemical oxygen demand (COD), phosphate, ammonium ion (NH4+),  metals (Ag, Ba, Be, Ca, Cd, Co, Cr, Cu, Fe, K, Mg, Mn, Na, Ni, Pb, Sn, Sr, Ti, V, and Zn), and nitrate, were packed in 1-liter polyethylene bottles, previously decontaminated with 10% nitric acid solution, washed with deionized water, dried, and then washed with water from the collection station (environment) and labeled.

 

Table 3: Operating conditions of optical emission spectrometer with inductively coupled plasma (ICP-OES).

Parameters

Conditions

RF power (kW)

1.0

Nebulizer pressure (kPa)

200

Plasma argon flow rate (L/min)

15

Auxiliary argon flow rate(L/min)

1,5

Sample introduction (s)

17

Washing time (s)

25

Stabilization time (s)

10

Reading time (s)

1

Peristaltic pump speed (RPM)

15

 

 

After collection, the samples were transported in thermal boxes at 4°C to Tucuruí and Belém. In partner laboratories, the samples were subjected to filtration with GFF-type membranes (Millipore 0.45 m) using a vacuum filtration system, except for the analysis of apparent color. Only the samples intended for metals testing were acidified to pH <2 with supra-pure concentrated nitric acid for further analysis at the ICP-OES.

 

2.3. ANALYTICAL QUALITY

 

The analytical quality was performed for the metal analysis methodology using the ICP-OES. The accuracy study was carried out with a standard river water sample (NIST SRM 1640) showing a recovery between 92.36 and 108.00% for the metals evaluated. In the study of repeatability, a coefficient of variation of 1.54 and 4.66% was found. The method was linear in the range of 0.00 to 15.00 mg L-1 for macro-elements and 0.00 to 1.00 mg L-1 for micro and trace elements, with a linear correlation coefficient from 0.9958 to 0.99998. The detection limit (3s), for all the elements surveyed, was calculated according to the reading deviation of 15 whites and was in the range of 0.0001 to 0.0271 mg L-1. The limit of quantification (10s) was between 0.0002 to 0.0826 mg L-1.

 

2.4. STATISTICAL METHODS

 

Statistical calculations were performed using Excel, Minitab, and Statistica programs.

The WQI determination followed three steps as proposed by Sahu and Sikdar (2008). In the first step, a weight (wi) was assigned to each of the parameters according to their relative importance in the general quality of the water. The maximum weight of five (5) was attributed to the parameters with great importance in water quality evaluation. The minimum weight of one (1) was assigned to parameters that play a less significant role in assessing water quality. In the second step, the relative weight (Wi) was calculated as in Equation 1, where Wi is the relative weight, wi is the weight that was assigned to each parameter, and n is the number of parameters.

 

                                                                                                                                       (Equation 1)

     

In the third step, a quality assessment scale (qi) was assigned to each parameter, dividing the concentration of each water sample by its standard according to the respective guidance established in CONAMA resolution 357/2005, then the result was multiplied by 100 as shown in Equation 2, where qi is the quality assessment, Ci is the concentration of each chemical parameter in each water sample in mg L-1, and Si is the water quality standard for each chemical parameter in mg L-1.           

 

                                                                                                                                                                (Equation 2)

 

To calculate the WQI, SIi was first determined for each chemical parameter (Equation 3), and then this value was used to determine the WQI by Equation 4 where SIi is the sub-index of parameter i.

 

                                                                                                                                                                        (Equation 3)

 

                                                                                                                                                                         (Equation 4)

 

The calculated values of the water quality index (WQI) were based on the classification of five categories as shown in Table 4.

 

Table 4: Classification of water quality as Sahu and Sikdar (2008).

WQI

Water quality

< 50

Excellent

50-100

Good

100-200

Regular

200-300

Poor

> 300

Very poor

 

It was necessary to understand the user's needs to start building the web system to calculate the water quality indicator (WQI). Therefore, the first stage of the process was the survey and analysis of the functional and non-functional requirements of the system. Techniques such as interviews, meetings, and inspection of spreadsheets and other documents already known by the user before the system were considered in this step.

The system was then documented using the following UML (Unified Modeling Language) diagrams: use case, sequence, and activity diagrams. In addition, the complete description of the use cases was provided to facilitate the understanding of what should be built, resolving doubts concerning the real needs of the user, increasing the chances of developing a system that solves the user's premises. Table 5 shows an example of the model used to describe the use cases.

The next step was to perform conceptual modeling of the database, making it possible to enumerate the entities, with their respective attributes, and understand the relationship between the various entities that compose the database. Then, the conceptual modeling was converted to logical modeling, allowing a lower-level view of the database. Fig. 2 shows an entity-relationship model (ER Modeling) for logical modeling. From the logical model, the physical model was conceived, which uses the SQL (Structured Query Language) programming language to create the database in the relational database management system (RDBMS) known as MySQL version 8.

 

Table 5: Model to describe a use case.

Use

Action

Functionality

Perform authentication on the system

Actor

User

Description

This functionality must control access to the system through an email and a valid password.

Pre-conditions

Access the authentication screen and have an account registered in the system.

Postcondition

Be redirected to the system's home screen.

Main flow

1)     The user accesses the authentication screen

2)     Inform their e-mail and password previously registered by the system administrator;

3)     If the e-mail and password are in accordance with the data registered in the database, then the user is redirected to the system's home page.

Validation

Email and password fields are required.

 

Figure 2: ER Modeling of the system database.

With the system requirements defined and the database created, the system development stage was initiated using the programming language PHP version 7.2 to implement its logic. To develop the user interface, HTML5, CSS3, Javascript, and Bootstrap version 4 technologies were used. The development environment used to program the software was Eclipse version Oxygen.

 

3.     RESULTS AND DISCUSSIONS

 

3.1. PHYSICAL-CHEMICAL, BIOLOGICAL, AND CHEMICAL RESULTS

 

The average values found for the parameters evaluated at Samuel dam were compared with the values recommended by Resolution 357/05 of the Brazilian National Environment Council (CONAMA, 2005).

Among all the physical-chemical and biological parameters evaluated, in terms of average, only the DO was in non-compliance with Brazilian legislation in the dry season (4.82±1.79 mg L-1) and intermediate 2 (3.46 ±0.59 mg L-1).

The OD varied from 1.03 mg L-1 to 7.46 mg L-1 with an average of 4.99 mg L-1 for all periods studied. The variation coefficient for DO was 19.74%, showing high variability between seasonal periods. In the dry and intermediate 2 periods, minimum levels equal to 1.03 mg L-1 were found in the SAM4E station and 1.66 mg L-1 in the SAM5 station. In the first two evaluations, lower values were also found than those recommended in Brazilian legislation (2.89 mg L-1 at the SAM5 station during the rainy season, and 4.68 mg L-1 at the SAM8 station during intermediate 1). For maximum levels, all seasonal periods were in accordance with CONAMA resolution 357/2005, except for intermediate period 2, which presented the value of 4.74 mg L-1 at station SAM4.

The concentration of dissolved oxygen (DO) in any waterbody is controlled by several factors, such as the oxygen solubility in water and the temperature. The lower DO concentration recorded during the summer may be due to the higher temperature which has a stronger effect on organic matter decomposition and increased photosynthetic activity, in addition to the fact that hot water retains relatively less oxygen than cold water (Lone et al., 2021).

At the end of 2015 and beginning of 2016, there was a temperature increase in the region with higher evaporation and lesser volume in the water bodies due to the El Niño phenomenon that influenced the beginning of the rainy season throughout the Amazon region (MOURA et al., 2019).

The elements Cd, Co, Cr, Ni, Pb, Sr, and V showed results below the Limit of Quantification (LOQ) of the chosen method for all seasonal periods, indicating the preservation of the water bodies evaluated concerning carcinogenic elements such as Cd, Cr, Ni, and Pb. Therefore, these elements were not considered for this study.

The Ag in the rainy season (0.027±0.039 mg L-1) and intermediate 1 (0.013±0.028 mg L-1), Cu in the rainy season (0.02±0.032 mg L-1), and Fe in the rainy season (0.37±0.16 mg L-1), intermediate 1 (0.37 ± 0.15 mg L-1) and intermediate 2 (0.90±1.92 mg L-1) were in non-compliance with Brazilian legislation. The presence of Fe is a common characteristic of rivers in the Amazon and is not necessarily a non-conformity, as demonstrated in other studies carried out in rivers in the region (Pereira et al., 2020; Miranda et al., 2009).

Considering the average values found in the rainy season, the largest elements K, Ca, and Mg predominated in the following order: K>Ca>Mg>Fe>Na>Sn>Ag>Cu>Ba>Zn>Be. In the intermediate period 1, the order was: K>Ca>Mg>Na>Fe>Sn>Ag>Ba>Zn>Be, also with the predominance of the major elements K, Ca, and Mg. In the dry season the order was: Ca>K>Na>Mg>Fe>Mn>Ti>Ba>Zn. In intermediate period 2, the order was: Ca>Fe>Na>K>Mg>Ti>Mn>Ba.

 

3.2. CALCULATION OF WQI

 

Many significant correlations (p<0.0500) were found between the parameters evaluated in each seasonal period. These preliminary statistical tests were used to verify the results obtained and to select the most significant parameters for the elaboration of a water quality index (WQI).

The correlation matrix of the eigenvalues, the variance, and the accumulated variance of the principal components with all the evaluated parameters totaled 71.40% of statistical information in the first two components (PC1 and PC2) in the rainy season, 79.30% in the intermediate period 1, 75.70% in the dry season, and 87.7% in the intermediate period 2.

After correlation analysis, the principal component analysis (PCA) was applied to all parameters evaluated in the surface water samples from the Samuel dam. The parameters with weights >0.500, which represent those with the greatest statistical importance, were selected and evaluated given the assigned weights and the environmental importance of each parameter in water quality evaluation. The extraction of factor loading (not rotated) was performed and the principal components (PC1 + PC2) >0.500 per seasonal period are shown in Table 6.

 

Table 6: Extraction of factor loading (not rotated) per seasonal period.

Variable

Factor 1

Factor 2

Variable

Factor 1

Factor 2

Rainy

Dry

Transparency (m)

-0.429

-0.177

Transparency (m)

-0.406

0.171

Temperature (°C)

-0.409

0.172

Temperature (°C)

-0.299

0.428

ORP (mv)

0.070

-0.493

Turbidity (UNT)

0.417

-0.044

OD (mg/L)

-0.076

-0.425

TDS (mg/L)

-0.211

-0.555

Turbidity (UNT)

0.469

0.050

Conductivity (mS/cm)

-0.229

-0.527

TDS (mg/L)

-0.046

0.487

Phisphate (mg/L)

0.238

0.003

Chlorophyl a (mg/L)

-0.151

0.365

Apparent color

0.391

-0.141

Phosphate (mg/L)

0.318

-0.214

 

 

 

Apparent color

0.462

0.138

 

 

 

Intermediate 1

Intermediate 2

Transparency (m)

-0.414

0.111

Transparência (m)

-0.339

-0.300

Temperature (°C)

-0.424

0.075

Temperatura (°C)

-0.168

-0.431

Turbidity (UNT)

0.440

-0.141

ORP (mv)

0.292

-0.353

Nitrate (mg/L)

0.384

0.220

Turbidity (UNT)

0.353

0.296

Chlorophyl a (mg/L)

0.206

0.332

TDS (mg/L)

0.336

-0.291

Apparent color

0.446

-0.097

Conductivity (mS/cm)

0.324

-0.336

 

 

 

Phosphate (mg/L)

0.213

0.441

 

The parameters were selected based on the principal components of all seasonal periods. The parameters that showed the greatest significance (highest percentage of variance) were transparency, temperature, ORP, DO, turbidity, TDS, conductivity, chlorophyll-a, phosphate, and apparent color. These parameters were considered of greater statistical importance and, therefore, received a relative weight of 0.0495 for the calculation of the WQI. It is important to note that all parameters evaluated were also used in the calculation, but with a lower relative weight.

 

3.3. SOFTWARE DEVELOPMENT

 

The system was divided into two profiles: administrator and field specialist. The difference between the profiles was that the administrator can change, remove or add new users with an administrator or specialist profile; whereas the specialist cannot perform user management operations on the system.

The first screen of the system, shown in Fig. 3a is for authentication. The field specialist must be registered to log in to the system, guaranteeing security. If the user forgets their password, they can recover it as shown in Fig. 3b

 

(a)

(b)

Figure 3: (a) Authentication screen, (b) Password recovery screen.

User management takes place through the functionality represented by the screen in Fig. 4. This screen is accessed through the "Manage Users" option in the menu, which is only shown for users with an administrator profile account.

 

Figure 4: User management screen.

 

One of the main reasons to develop this system is to facilitate the data import to generate results that will be visualized and interpreted by a field specialist, as the WQI calculation is carried out from collected experimental data. In this sense, instead of the user having to enter the value of each parameter collected on a system screen, the data entry is done through an electronic spreadsheet that has two tabs: the first contains all the data necessary for WQI calculation (Fig. 5), and the second the parameters for the calculations (limit established in the legislation and its respective weight) (Fig. 6).

 

Figure 5: First tab of the spreadsheet containing all collected data.

 

It is important to note that spreadsheet validation rules have been implemented in the system to generate consistent results. Therefore, after transferring the spreadsheet to the system (upload) and before performing the calculations, the system performs the following validations:

•        Checks whether the extension of the transferred file is .xls or .xlsx;

•        Checks whether the order of variables in tab 1 is the same as in tab 2.

 

The validation of variables order considers that the names of the variables are the same. For example, if the variable in tab 1 has the name "Temperature (ºC)" and in tab 2 it has "temperature (ºC)", then the system will report an error, due to the difference in the letter "t".

The set of spreadsheet management features represents the core of the system. The screen that the user must operate to inform the year of data collection, the state, and the municipality where the data was collected, select the spreadsheet file, assign a name, describe the spreadsheet, and define their status (private or public) is presented in Fig. 7. Also, at the beginning of this screen, it is possible to list the spreadsheets already registered by the user and the public spreadsheets, through the “List Spreadsheets” option; download a spreadsheet template and have access to help to learn how the spreadsheet structure works (options "Download the template here" and "Understand the structure", respectively).

Figure 6: Second tab of the spreadsheet containing all parameters for WQI calculation.

 

Figure 7: Screen for registration and upload of the spreadsheet containing the data.

 

Still on the screen shown in Fig. 7, after the user clicks on the button “Import and View Results”, the system will execute the validation rules mentioned above, check if all fields identified with an asterisk (*) have been filled and, if these restrictions are met, the system records the information and the spreadsheet in a database. After this procedure, the user will be able to view the results on the next screen. Then, the results of the qi (Fig. 8) and si (Fig. 9) calculations are displayed to the user.

 

Figure 8: Screen for qi results.

Figure 9: Screen for si results.

 

Still on the results screen, the WQI values per sample/season are displayed in a table, as well as the category to which the value fits. Fig. 10 presents an example.

In this section, one can see the average WQI of all samples/stations. Furthermore, an interesting feature was developed, which is the calculation of the mean WQI considering samples/stations selected by the user in the first column of the table by clicking on the button “Calculate Average of Selected Values”. The functioning of this system function is presented in Fig. 11.

Fig. 12 shows a graph of the WQIs calculated by sample/station, which allows the user to summarize the results.

From the screen that lists the spreadsheets, one can see the spreadsheets that have already been imported into the system. The screen shown in Fig. 13 shows the table that displays the spreadsheets registered by the user and the public spreadsheets, i.e. those that were defined by other users with a “public” status. There is a button entitled “Download” (dark blue color) that allows the user to download the spreadsheet to his computer and another option “View results” (green color) that directs the user to the screen that shows the results. spreadsheet WQI results. Therefore, through this functionality, the system works like a repository of spreadsheets with experimental data that can be shared with other users.

 

Figure 10: WQI result screen.

 

Figure 11: Functionality to calculate the average WQI per sample/season.

Figure 12: Bar graph generated by the system from the calculated WQIs.

 

Figure 13: Screen for registered spreadsheets.

 

4.     CONCLUSIONS AND RECOMMENDATIONS

 

Managing data without the aid of a computational tool is laborious, unproductive, and unsafe. To solve these problems, the system described in this study was created. Moreover, the fact that the system works in a web environment adds several advantages, such as organization and data security; speed and accuracy of calculations; use of the system from anywhere via the internet, and adds an innovative character to the project, since the researched literature shows only similar systems of the stand-alone type (which are not web).

The web software to calculate the water quality indicator specific to the Amazon region was registered within the INPI (Brazilian National Institute of Industrial Property), in the category computer program, through the process BR512020001541-7, which confirms its innovative nature and highlights its importance.

 

SOURCES OF FUNDING

 

This research received no specific grant from any funding agency in the public, commercial, or not-for-profit sectors.

 

CONFLICT OF INTEREST

 

The author have declared that no competing interests exist.

 

ACKNOWLEDGMENT

 

The authors would like to thank Eletronorte through the R&D program of the Electric Energy Agency (ANEEL) (according to Law 9991/2000) for financing the project; the administrative R&D sector of Eletronorte, Brasília for the administration of part of the project; the Eletronorte Technology Center, laboratory of the Eletronorte Environmental Protection Center (CPA-ELN) in Tucuruí for support in project management, collection and laboratory support; to CNPq and CAPES, and LAQUANAM at UFPA.

REFERENCES

 

    [1]       ANA - Agência Nacional de Águas. Guia Nacional de Coleta e Preservação de Amostras Água, Sedimento, Comunidades Aquáticas e Efluentes Líquidos, (2011). 327 p. Available in: https://arquivos.ana.gov.br/institucional/sge/CEDOC/Catalogo/2012/GuiaNacionalDeColeta.pdf. Acessed on February 5 2021. 

    [2]       APHA, (2005). Standard Methods for the Examination of Water and Wastewaters, 21ST ed. American Public Health Association APHA, AWWA, WEF, Washington DC, p. 1368.

    [3]       Brown R M, N I Mcclelland, R A Deininger, R G Tozer, (1970). A water quality index: do we dare. Water and Sewage Works 117(10):339-343.

    [4]       Cantonati, M, S Poikane, C M Pringle, L E Stevens, E Turak, J Heino, J S Richardson, R Bolpagni, A Borrini, N Cid, M Cˇtvrtlíková, D M P Galassi, M Hájek, I Hawes, Z Levkov, L Naselli-Flores, A A Saber, M D Cicco, B Fiasca, P B Hamilton, J Kubeˇcka, S Segadelli, P Znachor, (2020). Characteristics, main impacts, and stewardship of natural and artificial freshwater environments: consequences for biodiversity conservation. Water 12(260):1-85.

    [5]       CONAMA, (2005). Resolução do Conselho Nacional do Meio Ambiente, nº 357 de 17 de março de 2005 alterada pelas resoluções CONAMA N° 393/2007, N° 397/2008, N° 410/2009 e N° 430/2011, p. 36. Available in: https://www.icmbio.gov.br/cepsul/images/stories/legislacao/Resolucao/2005/ res_conama_357_2005_classificacao_corpos_agua_rtfcda_altrd_res_393_2007_397_2008_410_2009_430_2011.pdf. Acessed on February 5 2021. 

    [6]       Costa, H C, S F P Pereira, L P Santos, A F S Oliveira, T M Silva, C S Silva, R M Rocha, K H G Freitas, D C Santos, E S Cruz, (2020). Chemometrics Applied in the Development of a Water Quality Indicator System for the Brazilian Amazon. ACS Omega 5(51):32899-32906.

    [7]       Elmasri, R., S B Navathe, (2015). Sistemas de banco de dados. Pearson, 6ª edição.

    [8]       Gazzaz, N M, M K Yusoff, A Z Aris, H Juahir, M F Ramli, (2012) Artificial neural network modeling of the water quality index for Kinta River(Malaysia) using water quality variables as predictors. Marine Pollution Bulletin 64(11):2409-2420.

    [9]       Gharibi, H, A H Mahvi, R Nabizadeh, H Arabalibeik, M Yunesian, M H A Sowlat, (2012). A novel approach in water quality assessment based on fuzzy logic. Journal of Environmental Management 112(15):87-95.

  [10]     Lone, S A, S U Bhat, A Hamid, F A Bhat, A Kumar, (2021). Quality assessment of springs for drinking water in the Himalaya of South Kashmir, India. Environmental Science and Pollution Research 28(2):2279-2300.

  [11]     Manara, A L G, A R Clemente, (2011). Qualidade d’água de microbacia urbana, córrego lavapés na cidade de Mogi Mirim-SP. Scientia Plena 7(8):1-15.

  [12]     Matta G, A Kumar, A Nayak, P Kumar, A Kumar, A K Tiwari, (2020) Determination of water quality of Ganga River System in Himalayan region, referencing indexing techniques. Arabian Journal of Geosciences 13:1-11.

  [13]     Maulud, K N A, A Fitri, W H M W Mohtar, W S W M Jaafar, N Z Zuhairi, M K A Kamarudin, (2021) A study of spatial and water quality index during dry and rainy seasons at Kelantan River Basin, Peninsular Malaysia. Arabian Journal of Geosciences 14(85):1-19.

  [14]     Medeiros, A C, (2012). Obtenção do WQI para avaliação da qualidade da água em rios dos municípios de Abaetetuba e Barcarena (PA). 2012. 130 f. Dissertação (Mestrado) - Universidade Federal do Pará, Instituto de Tecnologia, Belém, 2012.

  [15]     Miranda, R, S F P Pereira, D T V Alves, G R F Oliveira, (2009) Qualidade dos recursos hídricos da Amazônia - Rio Tapajós: avaliação de caso em relação aos elementos químicos e parâmetros físico-químicos. Revista Ambiente & Água 4(2):75-92. Doi:10.4136/1980-993X.

  [16]     Mokarram, M, A Saber, V Sheykhi, (2020) Effects of heavy metal contamination on river water quality due to release of industrial effluents. Journal of Cleaner Production 277(20):1-13.

  [17]     Moura, M M, A R Santos, J E M Pezzopane, R S Alexandre, S F Silva, S M Pimentel, M S S Andrade, F G R Silva, E R F Branco, T R Moreira, R G Silva, J R Carvalho, (2019) Relation of El Niño and La Niña phenomena to precipitation, evapotranspiration and temperature in the Amazon basin. Science of The Total Environment 651(1):1639-1651.

  [18]     Nabizadeh, R., M A Valadi, M Alimohammadi, K Naddafi, A H Mahvi, S Yousefzadeh, (2013). Development Of Innovative Computer Software To Facilitate The Setup And Computation Of Water Quality Index. Journal of Environment Health Science & Engineering 11(1):1.

  [19]     Oliveira, A F S, L D P Silva, T M Silva, L P Santos, R M Rocha, H G Freitas, S F P Pereira, (2017). Desenvolvimento do índice de qualidade da água bruta para fins de abastecimento público-IPA para Amazônia. Scientia Plena 13(1):1-9.

  [20]     Pereira, S F P, O O Pires, A C F Saraiva, G R Oliveira, P M Souza Junior, R G Miranda, C S Silva, R S Sales, (2011). Distribuição de elementos tóxicos no estuário do rio Amazonas. Eclética Química Journal 36(1):46-63.

  [21]     Pereira, S F P, D C Santos, C S Silva, E S Cruz, (2020). Contaminação de recursos hídricos da Amazônia: estudo de caso na represa de Tucuruí-PA. Sodebrás 15(169):135-140.

  [22]     Provencher, M, M P Lamontagne, (1977) Méthode de determination d’un indice d’appréciation de la qualité des eaux selon différentes utilisations, (Québec), Ministére des Richesses naturelles, Service de la qualit́e deseaux, pp.225.

  [23]     Sahu P, P K Sikdar, (2008). Hydrochemical framework of the aquifer in and around East Kolkata Wetlands, West Bengal, India. Environmental Geology 55:823-835.

  [24]     Santos, J B B, C T V Teza, H Sallum, (2015). UHE Samuel: delimitação dos limites municipais na área do reservatório. Anais XVII Simpósio Brasileiro de Sensoriamento Remoto, João Pessoal, 1-7.

  [25]     Santos, L P, S F P Pereira, P M Souza Junior, C S Silva, (2020). Avaliação da qualidade da água na Amazônia brasileira: estudo de caso na bacia do rio Peixe-Boi-PA. Sodebrás 15(180):69-75.

  [26]     Sharma, A, M Naidu, A Sargaonkar, (2013). Development of computer automated decision support system for surface water quality assessment. Computers & Geosciences 51:129-134.

  [27]     Son, C T, N T H Giang, T P Thao, N H Nui, N T Lam, V H Cong, (2020) Assessment of Cau River water quality assessment using a combination of water quality and pollution índices. Journal of Water Supply: Research and Technology-Aqua 69(2):160-172.

  [28]     Zuffo, C E, G F Nascimento, F A M Abreu, I N Cavalcante, (2013) Caracterização da qualidade de águas superficiais em Rondônia. Anuário do Instituto de Geociências, Rio de Janeiro, v. 36, n. 2, p. 25-39, 2013. Available in: <http://dx.doi.org/http://dx.doi.org/10.11137/2013_2_25_39>. Accessed on February 21 2021

Creative Commons Licence This work is licensed under a: Creative Commons Attribution 4.0 International License

© Granthaalayah 2014-2020. All Rights Reserved.