Informations et ressources scientifiques
sur le développement des zones arides et semi-arides

Accueil du site → Master → Cameroun → Design of a geographic information supported database for the management of pressurized irrigation systems at the plantation du Haut Penja, Cameroon

University of Dschang (2009)

Design of a geographic information supported database for the management of pressurized irrigation systems at the plantation du Haut Penja, Cameroon

AZAH Chick Herman

Titre : Design of a geographic information supported database for the management of pressurized irrigation systems at the plantation du Haut Penja, Cameroon

Auteur : AZAH Chick Herman

Université de soutenance : University of Dschang

Grade : Agric engineer 2009

Résumé
Most of the data related to irrigation systems can now be characterized geographically. A study geared towards the creation of a geographic information supported database for the management of pressurized irrigation systems was carried out at the Plantation du Haut Penja ?. The irrigation system of this group is becoming very complex and diversified due to the increase in the number of hectares of banana cultivated each year. The putting in place of new systems, management and monitoring of this system is thus subjected to several constraints. The specific objectives of the study were to : develop a database for rapid access and orderly storage of information regarding the irrigation system ; develop thematic layers for the GIS, evaluate the water requirements in each plot ; evaluate the functioning of the networks and to spatially represent some aspects of the irrigation system. The database on the irrigation system was created using Microsoft Access 2003 while the various layers of the GIS were created using MapInfo 8.0 software. An Object Database Connection (ODBC) was created between the MS Access database and the MapInfo GIS to carry out multiple queries on the irrigation system and spatially represent some aspects of the irrigation system. A total of 35 tables, 10 forms and 17 queries were created for the database to enhance data entry and retrieval. The probability of satisfaction of crop water requirements for a 20 years climatic data was calculated. The crop water requirement for an effective root depth of 50 cm was 40 mm/week for the satisfaction of the crop water requirements 1 out of 20 years. Depending on the crop evapotranspiration and effective rainfall of the previous day, the crop water requirements will be adjusted in the database. Thematic layers for the GIS such as the crop varieties, spatial arrangement of the crops, soil types, type of irrigation system, plot of valves and others were created in the database. Some of these thematic layers were represented spatially using MapInfo 8.0 to demonstrate the use of the GIS when coupled to the database. Analysis of the flow rates, pressures, flow velocities and other hydraulic properties of the network showed these to be within the limits of hydraulic flow in pipes. This indicates that more emphasis should be laid on monitoring and management of this system ; hence, the necessity of the GIS database developed in this study in order to ameliorate the management of this system.

Mémoire on line

Page publiée le 2 juin 2014, mise à jour le 25 février 2020