|
|
FACULTY OF
AGRONOMY AND
AGRICULTURAL
DEPARTMENT OF
AGRICULTURAL
ENGINEERING
|
|
FACULTE
D`AGRONOMIE
ET DES SCIENCES
AGRICOLES
DEPARTEMENT DE
GENIE RURAL
|
DESIGN OF A GEOGRAPHIC INFROMATION
SUPPORTED
DATABASE FOR THE MANAGEMENT OF
PRESSURIZED IRRIGATION SYSTEMS AT
THE
«PLANTATION DU HAUT PENJA» (PHP),
NJOMBE
(CAMEROON)
By
CHICK Herman AZAH
Registration N°: 04A012
Major: Agricultural
Engineering
Thesis presented in partial fulfillment of the requirement
for the award of the «Ingénieur
Agronome» Diploma
CO-SUPERVISOR:
Mr. Njila Roger,
MSc
Assistant Lecturer, Dep`t of
Agric. Engineering
FACULTY OF
AGRONOMY AND
AGRICULTURAL
SCIENCES
|
DEPARTMENT OF
AGRICULTURAL
ENGINEERING
|
|
FACULTE
D`AGRONOMIE
ET DES SCIENCES
AGRICOLES
DEPARTEMENT DE
GENIE RURAL
|
DESIGN OF A GEOGRAPHIC INFORMATION
SUPPORTED
DATABASE FOR THE MANAGEMENT OF
PRESSURIZED IRRIGATION SYSTEMS AT
THE
«PLANTATION DU HAUT PENJA» (PHP),
NJOMBE
(CAMEROON)
By
CHICK Herman AZAH
Thesis presented in partial fulfillment of the requirement
for the award oi lIKE ,« gpnilAr
SRRnRPH El iSCRPa
ACADEMIC SUPERVISOR: Prof. Mathias Fru Fonteh,
PhD
Associate Professor, Dep`t of
Agric. Engineering
FIELD SUPERVISOR:
Mr. Boa Appolinaire,
Eng
Irrigation Department,
PHP Njombé
CERTIFICATION OF ORIGINALITY OF THE WORK
This is to testify that, the work in this thesis was carried
out by CHICK Herman AZAH at the Plantation du Haut
Penja (PHP) under the field supervision of Mr. Boa
Appolinnaire and academic supervision of Prof. FONTEH Mathias
Fru and Mr. Njila Roger. The work is original and has not been
presented for the acquisition of a university degree or diploma elsewhere.
Names and Signatures of supervisors Name and Signature
of author
Prof. FONTEH Mathias Fru CHICK Herman AZAH
Date: Date:
Mr. NJILA Roger
Date:
CERTIFICATION OF CORRECTION OF THESIS
This thesis has been revised and corrected in conformity to the
modifications suggested by the examination panel of
Signature of Supervisor Signature of
Candidate
Date Date
Signature of Member of Jury Signature of Member of
Jury
Date Date
Signature of Member of Jury Signature of President of
Jury
Date Date
Signature of Head of Department
Date
ABSTRACT
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.
| 
