Submitted:
05 February 2023
Posted:
06 February 2023
Read the latest preprint version here
Abstract
Keywords:
1. Introduction
- Development of a predictive linear model for Dissolved Oxygen of unknown lake water using basic water quality parameters.
- Accessing water health conditions, an insight into protected urban Hatirjheel lake, Dhaka, Bangladesh.
2. Materials and Methods
2.1. Study area

2.2. Data collection and sampling procedure
2.3. Description of the materials

2.4. Data Cleaning
2.5. Data Analysis
2.6. Multivariate Statistical Analysis
2.7. Correlation Heat map

2.8. Correlation Analysis
| Variables used | R-score | RMSE |
| pH, Salinity, Conductivity, Temperature | 0.687 | 0.834 |
| pH, ORP, Salinity, Conductivity, Temperature | 0.680 | 0.843 |
| pH, Conductivity, Temperature | 0.591 | 0.954 |
| pH, Temperature | 0.544 | 1.007 |
| pH, ORP, Salinity, Conductivity | 0.4368 | 1.119 |
| Sl. | Temp. (⁰C) | ORP (mV) | Salinity (g/l) | EC (mS/cm) | pH | DO (mg/l) | ||||||
| Mean | SD | Mean | SD | Mean | SD | Mean | SD | Mean | SD | Mean | SD | |
| 1 | 28.72 | 0.14 | 115.47 | 1.23 | 0.24 | 0.00 | 0.49 | 0.00 | 7.43 | 0.02 | 0.00 | 0.00 |
| 2 | 28.72 | 0.15 | 138.71 | 2.23 | 0.19 | 0.02 | 0.37 | 0.04 | 7.75 | 0.03 | 1.03 | 0.40 |
| 3 | 28.37 | 0.08 | 138.89 | 4.72 | 0.20 | 0.01 | 0.39 | 0.02 | 7.70 | 0.02 | 1.48 | 0.24 |
| 4 | 28.02 | 0.07 | 153.93 | 3.48 | 0.19 | 0.01 | 0.37 | 0.03 | 7.67 | 0.02 | 1.34 | 0.19 |
| 5 | 27.77 | 0.04 | 168.56 | 1.12 | 0.18 | 0.03 | 0.35 | 0.06 | 7.62 | 0.02 | 0.81 | 0.08 |
| 6 | 28.28 | 0.03 | 141.44 | 4.96 | 0.19 | 0.00 | 0.39 | 0.00 | 7.80 | 0.01 | 2.44 | 0.08 |
| 7 | 28.31 | 0.08 | 137.13 | 5.19 | 0.20 | 0.01 | 0.39 | 0.02 | 7.70 | 0.02 | 1.67 | 0.30 |
| 8 | 28.19 | 0.09 | 127.39 | 5.00 | 0.20 | 0.01 | 0.40 | 0.02 | 7.63 | 0.02 | 1.52 | 0.60 |
| 9 | 26.74 | 0.09 | 72.70 | 19.20 | 0.18 | 0.00 | 0.36 | 0.00 | 7.41 | 0.01 | 2.78 | 1.65 |
| 10 | 28.43 | 0.09 | 130.43 | 4.20 | 0.20 | 0.01 | 0.41 | 0.02 | 7.63 | 0.02 | 1.15 | 0.39 |
| 11 | 27.77 | 0.07 | 138.08 | 8.22 | 0.19 | 0.01 | 0.37 | 0.02 | 7.74 | 0.02 | 3.50 | 0.72 |
| 12 | 28.28 | 0.06 | 172.43 | 2.48 | 0.19 | 0.00 | 0.38 | 0.00 | 7.92 | 0.02 | 4.18 | 0.10 |
| 13 | 27.74 | 0.06 | 147.62 | 4.65 | 0.18 | 0.01 | 0.36 | 0.03 | 7.76 | 0.02 | 3.44 | 0.05 |
| 14 | 27.15 | 0.04 | 124.26 | 1.08 | 0.17 | 0.03 | 0.33 | 0.06 | 7.57 | 0.02 | 2.11 | 0.16 |
| 15 | 27.42 | 0.03 | 143.90 | 4.97 | 0.18 | 0.02 | 0.35 | 0.03 | 7.73 | 0.03 | 3.54 | 0.13 |
| 16 | 27.66 | 0.09 | 113.54 | 6.27 | 0.19 | 0.01 | 0.38 | 0.02 | 7.58 | 0.02 | 2.25 | 0.82 |
| 17 | 27.38 | 0.08 | 101.01 | 9.99 | 0.19 | 0.01 | 0.38 | 0.02 | 7.53 | 0.02 | 2.41 | 1.10 |
| 18 | 28.43 | 0.10 | 124.86 | 4.04 | 0.21 | 0.01 | 0.43 | 0.02 | 7.58 | 0.02 | 0.97 | 0.39 |
| 19 | 28.60 | 0.10 | 128.02 | 3.03 | 0.21 | 0.01 | 0.43 | 0.02 | 7.60 | 0.02 | 0.75 | 0.29 |
| 20 | 28.63 | 0.10 | 123.35 | 3.14 | 0.22 | 0.01 | 0.45 | 0.02 | 7.54 | 0.02 | 0.50 | 0.15 |
3. Result and Discussion
3.1. Mean and Standard Deviation table
3.2. Interpolation Study

3.3. Regression model
| r2 | 0.9636419890515832 |
| MAE | 0.15244809592781455 |
| MSE | 0.04297761323587285 |
| RMSE | 0.20731042722418197 |
| Intercept | -3.243182537397614 |
| Temperature coef. | -3.50012194 |
| pH coef. | 12.43320371 |
| Salinity coef. | -315.35944705 |
| Conductivity coef. | 179.27832613 |

3.4. Model Validation
| r2 | 0.9830437024851376 |
| MAE | 0.12126691975959207 |
| MSE | 0.028476917606881477 |
| RMSE | 0.16875105216525754 |

3.5. Water quality standard
| Parameters | Standard (WHO) | Standard (DoE) |
| DO | 6.5-8 mg/L | 6 mg/L |
| ORP | 300-500 mV | - |
| Salinity | < 0.5 ppt | 0.6 ppt |
| pH | 7-8 | 6.5-8.5 |
| EC | 500-1400 µ/cm | 1200 µ/cm |
| Temp. | 12-25°C | - |
3.6. DO importance in a protected urban lake
3.7. Limitations of the study and further scope
4. Conclusions
Credit Authorship Contribution Statement
Declaration of Competing Interest
Acknowledgments
References
- (DPHE), D. o. (2019, May 15). dphe.gov.bd/. Retrieved from Bangladesh National Portal: http://dphe.gov.bd/site/page/15fa0d7b-11f1-45c0-a684-10a543376873/Water-Quality-Parameters-.
- Brönmark, C. H. (2002). Environmental issues in lakes and ponds: current state. Environmental Conservation, 29 (3), 290–306. [CrossRef]
- Cansu Filik Iscen, Ö. E. (2007). Application of multivariate statistical techniques in the assessment of surface water quality in Uluabat Lake, Turkey. Environmental Monitoring and Assessment, 144, 269–276. [CrossRef]
- Department of Environment, (. (2003). Water Quality Standard, A Compilation of environmentallaws of Bangladesh. (M. E. Huq, Ed.) administered by Department ofEnvironment (DoE), Govt. of Bangladesh.
- Fabliha Anber, N. A. (2020). Restoration of Hatirjheel Lake by designing submerged aeration system and settling zone. IOP Conference Series: Earth and Environmental Science (p. 476). IOP Publishing Ltd.
- Icaga, Y. (2007). Fuzzy evaluation of water quality classification. Ecological Indicators, 7(3), 710-718. [CrossRef]
- J.C.Chena, N. W. (2003). Assessing wastewater reclamation potential by neural network model. Engineering Applications of Artificial Intelligence, 6(2), 149-157.
- Kalimur Rahman, S. B. (2021). Assessment of water quality and apportionment of pollution sources of an urban lake using multivariate statistical analysis. Cleaner Engineering and Technology, 9. [CrossRef]
- Kunwar P.Singh, A. B. (2009). Artificial neural network modeling of the river water quality—A case study. Ecological Modelling, 220(6), 888-895.
- L. Giridharan, T. V. (2010). Identification and evaluation of hydrogeochemical processes on river Cooum, South India. Environmental Monitoring and Assessment, 162, pages277–289.
- MAA Mokaddes, B. N. (2013). Status of Heavy Metal Contaminations of Drain Water of Dhaka Metropolitan City. Journal of Environmental Science and Natural Resources, 5(2), 345-348. [CrossRef]
- Ouyang, Y. (2005). Evaluation of river water quality monitoring stations by principal component analysis. Department of Water Resources. Florida, USA: St. Johns River Water Management District. [CrossRef]
- P. J. Puri, M. K. (2011). Surface water (Lakes) quality assessment in Nagpur city (India) based on Water quality index (WQI). IRJET Journal, Vol.4, 43-48.
- P. Simeonova, V. S. (2003). Water quality study of the Struma river basin, Bulgaria (1989–1998). Celtran European Science Journal, 1, 136–212.
- Patrick Debels, R. F. (2005). Evaluation of Water Quality in the Chillán River (Central Chile) Using Physicochemical Parameters and a Modified Water Quality Index. Environmental Monitoring and Assessment, 110, 301–322.
- Pesce, S. a. (2000). Use of Water Quality Indices to Verify the Impact of Córdoba City (Argentina) on Suquía River. Water Research, 34, 2915-2926. [CrossRef]
- Prakash Raj Kannel, S. L.-S. (2007). Application of Water Quality Indices and Dissolved Oxygen as Indicators for River Water Classification and Urban Impact Assessment. Environmental Monitoring and Assessment, 132, 93–110.
- Rajesh Reghunath, T. R. (2002). The utility of multivariate statistical techniques in hydrogeochemical studies: an example from Karnataka, India. Water Research, 36(10), 2437-2442. [CrossRef]
- S. Afrin, M. M. (2015). Development of IDF Curve for Dhaka City Based on Scaling Theory under Future Precipitation Variability Due to Climate Change. International Journal of Environmental Science and Development, 6(5), 332-335.
- S. R. Carpenter, N. F. (1998). NONPOINT POLLUTION OF SURFACE WATERS WITH PHOSPHORUS AND NITROGEN. the Ecological Society of America, Volume8(Issue3), Pages 559-568.
- Saffran, K. C. (2001). Canadian water quality guidelines for the protection of aquatic life. CCME water quality Index, 1, 34-31.
- Sarasota County, U. W. (2023, January 0). sarasota county wateratlas. Retrieved from wateratlas.org: https://sarasota.wateratlas.usf.edu/library/learn-more/learnmore.aspx?toolsection=lm_dissolvedox#:~:text=Dissolved%20oxygen%20(DO)%20is%20one,byproduct%20of%20aquatic%20plant%20photosynthesis.
- Shobhana Ramteke, V. V. (2016). Pit Lake Water Quality of Central India. Journal of Geographic Information System, 8.
- T. Subramani, N. R. (2009). Groundwater geochemistry and identification of hydrogeochemical processes in a hard rock region, Southern India. Environmental Monitoring and Assessment, 162, 123–137.
- WHO. (1996). Guidelines for drinking-water quality. In W. H. Organization, Health criteria and other supporting information (2 ed., Vol. 2). Geneva, Switzerland.
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2023 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (http://creativecommons.org/licenses/by/4.0/).