JGIS  Vol.5 No.5 , October 2013
Implementation of GIS and Geographic RDBMS Prototype for Water Resources Management. Zeuss-Koutine Basin (South of Tunisia)
ABSTRACT
The scarcity of shallow water, which is a delicate matter in southern Tunisia, is relatively compensated by groundwater resources. Indeed, the South contains 25% of water reserves of the country whom 10% are superficial water. The different hydrogeological studies show that the Zeuss-Koutine region is composed of several aquifer systems, which may be subdivided into two distinct levels; a superficial and a deep one. Such water resources show signs of localized over- exploitation which has a serious effect on the change of the hydrosystem characteristics in this region. Recently, Tunisia proves to be very interested in the contribution of new technology in particular Geographic Information System (GIS) to resolve the problem of water resources deficit in Tunisia essentially in semiarid southern part, in addition to the increased exploitation of groundwater resources, not renewable basically in last years. Hence, preserving water resources in the short and long term is a must. This fact might be achieved by the geographical information system (GIS). To respond to this object, detailed hydrological and hydrogeological studies are efficient, and a Geographic Relational Data Base Management System (RDBMS) by MERISE model was created in this study for organization of all these data in a structured way (method) and was easily exploitable under it. In addition, a lithostratigraphic correlation by the GIS is very important for understanding of the aquifer geometry and hydrodynamic interactions. The correlation among multi data shows a high degradation increasing from the South to the North (both quality and quantity of the Zeuss-Koutine groundwater). That is why another study of the water quality (salinity) and exploitation is considered crucial.

Cite this paper
K. Sami, M. Safa, K. Afef and Z. Fouad, "Implementation of GIS and Geographic RDBMS Prototype for Water Resources Management. Zeuss-Koutine Basin (South of Tunisia)," Journal of Geographic Information System, Vol. 5 No. 5, 2013, pp. 429-445. doi: 10.4236/jgis.2013.55041.
References
[1]   P. P. Adhikary, H. Chandrasekharan, D. Chakraborty and K. Kamble, “Assessment of Groundwater Pollution in West Delhi, India Using Geostatistical Approach,” Environmental Monitoring and Assessment, Vol. 167, No. 1-4, 2010, pp. 599-615. http://dx.doi.org/10.1007/s10661-009-1076-5

[2]   B. Ben Baccar, “Contribution to the Hydrogeologic Study of the Multi-Layer Aquifer of Southern Gabes Thesis of third Cycle Doctorate,” University of Southern Paris, Paris, 1982, pp. 132-154.

[3]   A. C. Kokaram, C. Bill and R. Simon, “Automated Rig Removal with Bayesian Motion Interpolation The Foundry,” IEE Proceedings—Vision, Image and Signal Processing, London, Vol. 152, No. 4, August 2005, pp. 407-414.

[4]   A. Sarangi, C. A. Madramootoo and P. Enright, “Comparison of Spatial Variability Techniques for Runoff Estimation from a Canadian Watershed,” Biosystems Engineering, Vol. 95, No. 2, 2006, pp. 295-308. http://dx.doi.org/10.1016/j.biosystemseng.2006.06.002

[5]   APHA, “Standard Methods for the Examination of Water and Wastewater,” 20th Edition, American Public Health Association, Washington DC, 1998.

[6]   B. Helena, R. Pardo, M. Vega, E. Barrado, J. M. Fernandez and L. Fernandez, “Temporal Evaluation of Ground Water Composition in an Alluvial Acquifer (Pisuerga River, Spain) by Principal Component Analysis,” Water Research, Vol. 34, No. 3, 2000, pp. 807-816. http://dx.doi.org/10.1016/S0043-1354(99)00225-0

[7]   B. Zhang, X. Song, Y. Zhang, D. Han, C. Tang, Y. Yu and Y. Ma, “Hydrochemical Characteristics and Water Quality Assessment of Surface Water and Groundwater in Songnen Plain, Northeast China,” Water Research, Vol. 46, No. 8, 2012, pp. 2737-2748.
http://dx.doi.org/10.1016/j.watres.2012.02.033

[8]   A. Oketola, S. Adekolurejo and O. Osibanjo, “Water Quality Assessment of River Ogun Using Multivariate Statistical Techniques,” Journal of Environmental Protection, Vol. 4 No. 5, 2013, pp. 466-479. http://dx.doi.org/10.4236/jep.2013.45055

[9]   R. Derouiche and H. Chaib, “Study by Digital Model of the Impact of Installations on the Refill of the Groundwater of Zeuss Koutine,” Report, General direction of Water Resources, Vol. 65, No. 2, 1997, p. 38.

[10]   M. Fersi, “Hydrogeological Study of the River of Oum Ezassar in Koutine,” Report, General direction of Water Resources, Vol. 185, No. 5, 1985, p. 122.

[11]   H. Yahyaoui, “Updating Balances of the Deep Groundwaters in the Governorate of Medenine,” Report, General direction of Water Resources, Vol. 18, No. 3, 2000, pp. 56-66.

[12]   J. P. Dash, A. Sarangi and D. K. Singh, “Spatial Variability of Groundwater Depth and Quality Parameters in the National Capital Territory of Delhi,” Environmental Management, Vol. 45, No. 3, 2010, pp. 640-650. http://dx.doi.org/10.1007/s00267-010-9436-z

[13]   L. Browne, “Outgrowing the Earth: the Food Security Challenge in an Era of Falling Water Tables and Rising Temperatures,” Earthscan, London, 2005.

[14]   S. Ustin, “Manual of Remote Sensing: Remote Sensing for Natural Resource Management and Environmental Monitoring,” John Wiley and Sons, Chichester, 2004.

[15]   B. Khalil and T. M. B. Ouarda, “Statistical Approaches Used to Assess and Redesign Surface Water Quality Monitoring Networks,” Journal of Environmental Monitoring, Vol. 11, No. 11, 2009, pp. 1915-1929. http://dx.doi.org/10.1039/b909521g

[16]   M. Ben Youssef and B. Peybernes, “New Biostratigraphy of the lower Cretaceous of Southern Tunisia,” Newspaper of African Earth Sciences, Vol.5, No. 3, 1986, pp. 217-231.

[17]   A. Mamou, “Characteristics and Evolution of the Water Resources of the Southern Tunisia,” State Doctor Thesis, University of Southern Paris, Paris, 1990, p. 414.

[18]   H. Ben Ouezdou, “Morphological and Stratigraphic Study of the Quaternary Formations of the Gulf of Gabes,” Reviews of Groundwater Scienc, Vol. 5, 1987, p. 165.

[19]   S. Bouaziz, “Study of Breakable Tectonics in Punt Forms and the Saharian Atlas (Meridional Tunisi) Evolution of the Paleo Fields of Constraints and Geodynamic Implications,” Thesis of State FAC Sc Tunis, Tunis, 1995, p. 485.

[20]   F. Kamoun, “The Jurassic Level of the Pilot Tunisian South of the African Margin of the Tethys Stratigraphy, Sedimentology and Micropaleontology,” Specialty Thesis, University of Paul Sabatier Toulouse III, Toulouse, 1989.

[21]   DGRE and SONEDE, “Reports of Drillings of the Groundwater of Zeuss Koutine,” 2005-2011.

[22]   BABA SY M, “Hydrogéologie et Ressources en eau du Système Aquifer Sisseb El Alem. Mémoire de fin d’étude. faculté des Sciences de Tunis,” Université de Tunis El Manar, Tunis, 1996.

[23]   S. Bouaziz, “Elaboration d’un SIG Pour l’étude de la Cartographie Géologique de la Région d’AGAREB. Mémoire de Mastère Faculté des Sciences de Sfax,” Université de Tunis de sud, Tunis, 2002, p90.

[24]   COTHA, “Note Préliminaire sur les Ressources en eaux Souterraines du Bled Sisseb El Alem,” DGRE, Tunis, 1965, 49p.

[25]   G. Castany, “Les Fosses d’Effondrement de Tunisie. Géologie et Hydrologie. Plaine de Grombalia et Cuvette de la Tunisie Orientale,” Annales des Mines et de la Géologie, 1948.

[26]   B. W. Hermant, D. Dibyendu, V. R. Desai, B. Klaus and A. Rafig, “Morphometric Analysis of the Upper Catchment of Kosi River, Using GIS Techniques,” Saudi Society for Geosciences, 2011, pp. 13-14.

[27]   UNICEF and World Health Organization, “A Snapshot of Drinking Water and Sanitation in Africa,” A Regional Perspective Based on New Data from the WHO/UNICEF Joint Monitoring Programme for Water Supply and Sanitation, Prepared for African Ministers’ Council on Water (AMCOM), Cairo, 2008.

[28]   M. Ross and P. Tara, “Integrated Hydrologic Modeling with Geographic Information Systems.” Journal of Water Resources Planning and Management, Vol. 119, No. 2, 1993, pp. 129-140. http://dx.doi.org/10.1061/(ASCE)0733-9496(1993)119:2(129)

[29]   N. Levin, “Fundamentals of Remote Sensing,” 1st Hydrographic Data Management Course, IMO—International Maritime Academy, Trieste, p.76.

[30]   D.-Q. Zhao, J.-N. Chen, H.-Z. Wang, Q.-Y. Tong, S.-B. Cao and S. Zheng, “GIS-Based Urban Rainfall-Runoff Modeling Using an Automatic Catchment-Discretization Approach: A Case Study in Macau,” Environmental Earth Sciences, Vol. 59, No. 2, 2009, pp. 465-472. http://dx.doi.org/10.1007/s12665-009-0045-1

[31]   E. Mihalik, “Watershed Characterization and Runoff Modelling of the Chapel Branch Creek, Orangeburg County, South Carolina,” MS.C Thesis, College of Charleston, Charleston, 2008.

[32]   P. Santra, U. K. Chopra and D. Chakraborty, “Spatial Variability of Soil Properties and Its Application in Predicting Surface Map of Hydraulic Parameters in an Agricultural Farm,” Current Science, Vol. 95, No. 7, 2008, pp. 937-945.

[33]   F. Monat, “Installation of a Geographical Information System (GIS) on the Basin of Merguellil (Tunisia) Training Course of Second Year Report,” Montpellier (FRA), Tunis ENSA, IRD, 2000, 99p.

[34]   A. Jasrotia and R. Singh, “Modeling Runoff and Soil Erosion in a Catchment Area, Using the GIS, in the Himalayan Region, India,” Environmental Geology, Vol. 51, No. 1, 2006, pp. 29-37.

[35]   H. Yahyaoui and Mr. Ouessar, “Abstraction and Recharge Impacts on the Ground Water in the Arid Regions of Tunisia Case of Zeuss-Koutine Water Table,” UNU Desertification Series, Vol. 2, 2000, pp. 72-78.

[36]   H. Yahyaoui, “Hydrogeologic Study of the Ground Water of the Catchment Area of the Rivers of Smar,” Rappt. Int. DGRE Tunis, Vol. 19, 1999.

[37]   E. Gaubi, “Study of the Piezometry and the Geochemistry of the Groundwater of Zeuss Koutine (Area of Medinine),” PFE, FAC Sc Tunis, Vol. 63, 1988.

[38]   H. Zammit, “Modeling of the Hydrogeology and the Salinity of the Groundwater of Zeuss Koutine,” Project of End Studies, National Ecole of Engineers of Tunis, Vol. 89, 2002, p. 125.

 
 
Top