Implementing a Groundwater Monitoring System in the Jukskei River Catchment: a TypeScript and MySQL Approach

The Jukskei River population has since grown to nearly 400,000 people. The Jukskei catchment water resources are therefore pressured to serve. Several challenges concerning groundwater management have been identified in South Africa's Jukskei Catchment. The results showed that there are gaps in the data records. Since there is no access to regulation terms (such as meters), official accreditation of monitoring capabilities and apparatus (such as apps) is required. There is a need to build many groundwater level monitoring stations with systems in TypeScript and MySQL, considering demands and human requirements as per normal densities in distinct locations of South Africa. Groundwater level raw data should be transformed into marketable products, such as concise reports on sensitive locations (such as dolomite compartments, wetlands, aquifers, and solitary sources, using apps in TypeScript and MySQL). Groundwater monitoring infrastructure has been vandalized and stolen during the rising civil turmoil. In this research, a big data-based technology/app was designed for predictive analytics and visualisation of groundwater monitoring in pretested on boreholes in the Jukskei catchment of South Africa. Using TypeScript ad SQL programming, a program / an algorithm was designed for the necessary groundwater and river water flow from the gauging station/site. Selection/identification of a suitable mobile phone / smart phone solution was done. Various steps were linked as a system using, (IoT /wireless/ thinking to enable the researcher to test the linked steps/system. i.e., Collect water levels from 18 boreholes. The contribution of this research is the development of an application for an improved groundwater monitoring framework that redress the highlighted gaps.