Supporting Community Based Wildlife Conservation in Africa with a GIS Enabled Relational Database

Andrew Lyons
Dale Lewis

Abstract

The ADMADE conservation program in Zambia has over ten years of experience using GIS technology to support rural communities in managing their natural resources. Through this government program, communities living in Game Management Areas become partners with government and private industry to sustainably manage their wildlife resources, striving to achieve both conservation and community development. GIS tools have proven invaluable for analyzing issues and providing feedback to communities on the effectiveness of their resource management activities and developing land use plans. ADMADE recently upgraded its GIS to a truly integrated relational database, building upon years of data collection and experience in analyzing monitoring data. The new database was developed using MS Access in conjunction with Esri MapObjects, and offers exciting new capabilities for multi-scale analyses, improving data quality, automating outputs, and reducing turnaround time. This user-friendly application has also opened new possibilities for sharing monitoring results, and is being used at new locations in the program.

Introduction

A peaceful country landlocked in south-central Africa, Zambia is richly endowed with wildlife, with over 240 species of wild mammals recorded including most of the large game animals associated with classic wild Africa (Aspinwall, Bingham, Chundama, Jeffery, & Sinkamba, 1996). Almost 1/3 of Zambia is under some kind of conservation status either in strictly protected national parks or multiple use zones called Game Management Areas (GMAs) which generally border the national parks (see Figure 1 below). ADMADE (Administrative Management Design) is a program of the Zambia Wildlife Authority (formerly known as the National Parks and Wildlife Services) for wildlife conservation and community development in the GMAs of Zambia. ADMADE is the official management strategy for all GMAs in Zambia, but has an active program in only about half of the 34 GMAs.


Figure 1. Map of Game Management Areas

Operationally, ADMADE achieves its twin goals of wildlife conservation and community development by channeling a portion of the revenue from commercial trophy hunting back to communities for resource management and community development. Although the community-based approach to conservation is today widely embraced by governments and donors alike, when ADMADE was formally established in 1988, it represented a radical paradigm shift from the traditional centralized wildlife management approaches of the 1970s and 80s. These approaches tended to exclude rural communities from any input into planning, managing, or benefit from wildlife resources, which eventually led to an epidemic in poaching in many African countries including Zambia. Although sport trophy hunting may at first seem antithetical to wildlife conservation, when practiced on a controlled basis it can provide a substantial amount of revenue for conservation programs for minimal impact. Trophy hunting has far less impact on habitat and land cover than agriculture, and requires less infrastructure development and client volume than photographic tourism.

Organizationally, the primary unit of management in ADMADE is the GMA. Management of the GMA is implemented through a cooperative effort of government officers and community residents. Representing the Zambia Wildlife Authority (ZWA) in the GMA is a Unit Leader, one or more deputies, and several civil servant scouts. These officers work side-by-side with village scouts, who have comparable responsibilities and training but are local residents and paid from community revenue. The primary role of both civil servant and village scouts is law enforcement, but they also play critical roles in resource monitoring and to a lesser extent public education.

Representing the community in management of the GMA is the Community Resource Board (CRB), an elected body composed of local residents with a mandate to prioritize development needs, manage the revenue from safari hunting, and oversee resource management activities. Traditional chiefs, who remain very influential in the rural areas of Zambia, serve as an honorary patron of the CRBs. Backing up the CRB are three technical committees, all comprised of local residents, which advise the board on issues of resource management, community development, and financial management. To ensure the all areas of the GMA are equally represented on both the technical committees and CRB, GMAs are divided into Village Area Groups (VAGs) which are demarcated based on geography and demography.


Figure 2. ADMADE Unit Organization

Supporting the different community structures at the GMA level is ADMADE's training and research center, the African College of Community Based Resource Management. Formerly known as Nyamaluma Institute, the College is located in a remote area of the Luangwa Valley on the eastern side of the country, and provides support to communities through a variety of educational programs, most of which are delivered as residential courses based at the College itself. The College also has an active extension program and provides in-situ technical support, monitoring, and facilitation services to the ADMADE communities.

Monitoring in ADMADE

Monitoring is an integral component of resource management, and has always been an important focus in ADMADE. Due to a chronically inadequate operational budget for resources such as vehicles and aerial surveys, ADMADE has made a long-term investment in developing a large-scale community-based monitoring system. Although not as rigorous as more traditional methods of wildlife monitoring, the system collects enough data to base management decisions on and in an extremely cost-effective manner. Community-based monitoring has the added bonus of serving as a tool to build the capacity of community organizations for wildlife monitoring (National Parks and Wildlife Services, 1993b).

Datasets

Monitoring has been integrated into the daily operations of village scouts, whose job requirements put them in a good position to collect data on wildlife, habitat, and resource use. The primary datasets which are collected on a regular basis include:

Information Flow

The vast majority of monitoring data originates in the GMAs, usually recorded by village scouts. A series of dataforms has been developed and distributed for each of the main datasets. After the data is recorded, it is kept at the GMA headquarters. The Unit Leader and his staff at the GMA headquarters have some capacity to analyze raw data, however data analysis skills are still fairly rudimentary and remain a focus of capacity building efforts supported by the College.

Two to four times a year, monitoring dataforms are sent to the College for processing. Here they are entered into a master database, and summaries are prepared and returned to the GMAs for planning and evaluation exercises. The summaries are provided in tabular format, graphs, and maps created using the College's GIS (National Parks and Wildlife Services, 1995).

Role of GIS

ADMADE was one of the pioneers of applying GIS technology to support community-based wildlife management. Thanks in part to several short term volunteers and generous donations from the Esri conservation program, the research unit at the College has been able to digitize base maps for all the GMAs and set up a centralized monitoring database. All field observations are georeferenced by an overlaid 5 km2 grid. Although this scale compromises precision, it increases accuracy of the locations because scouts can confidently locate themselves on a base map to within 5 km. The scale is also adequate for the management decisions which are the focus of ADMADE's monitoring system, namely annual quota setting, planning law enforcement operations, and land-use planning (Lewis, 1995).

ADMADE uses GIS technology primarily as a means to display monitoring results and land use issues in a format that could be understood by the local residents of GMAs. The use of maps fit well into ADMADE's overall strategy of community empowerment, as they are an effective tool in focusing discussion and visualizing trends not easily communicated through text or numbers . Specifically, ADMADE uses maps to:

Early GIS Developments

The College's GIS was developed in the early 1990s, and like many low budget GIS's of that era, it was composed of several software applications working together. PC ArcInfo was the primary GIS package used for digitizing base maps and preparing spatial outputs. This was later supplemented with ArcView. Data entry was done primarily through Lotus 123, aided by a series of macros. dBase IV for DOS was used for data conservation and some data entry (National Parks and Wildlife Services, 1993a). Finally, ERDAS Imagine was used to analyze satellite imagery for a few of the GMAs.

As pioneering as the College's GIS was, it was also constrained by the software and hardware of the early 90's. In particular the GIS had the following limitations:

By 1998 the College had acquired newer software, hardware, and technical assistance in the form of a short-term consultant and visiting graduate student. The staff decided it was time to upgrade the GIS into a more flexible and user-friendly system.

Methodology

Objectives

The following objectives were identified for the new information system.

Software

Once the objectives were identified, the research unit set out to design the data structure for the new information system. A relational data model was chosen, based around a small number of key lookup tables and several details tables. To implement the new information system, MS Access was selected to handle the tabular data processing and analysis. MS Access, which is bundled with the widely used MS Office, was the natural choice as the main development environment for the database, because it is commonly available, relatively cheap, customizable, and quite powerful for small to medium sized databases. MapObjects, an ActiveX component from Esri, was selected as the tool for integrating mapping capabilities into the application. PowerPoint, which speaks the same programming language as both MS Access and MapObjects, was selected to automate the creation of the large format layouts - which mix tables, maps, and charts - needed for community meetings.

Once development objectives and data structure were more or less settled upon, the upgrade process began in earnest in November 1998. All of ADMADE's existing tabular data was first converted from spreadsheets to the relational data structure using a combination of VBA and Access queries, and data entry forms designed. The dozens of GIS coverages for separate GMAs were cleaned, converted into a common projection system, and merged into five nationwide coverages: GMA boundaries, 5 km2 grids, scout camps, roads, and rivers. Lastly, a menu system, filtering system, and mapping capabilities were added to the application. By May 1999, the new database was basically complete and became the working information system for ADMADE.

Results

The new database, dubbed the ADMADE Data Manager (ADM), is now the working information system at the College and is also being used at the ADMADE coordinating office in Lusaka. ADM uses a combination of built-in Access features and customized enhancements, explained below.

Built-In Access Features

CUSTOM DESIGNED FEATURES

User-friendly menu system
A database with as many different types of datasets and summaries as the ADM requires a menu system to navigate among the many different choices. ADM features a standard three-tiered point-and-click Main Menu, and a simple single document interface. Choices on the Main Menu can be easily expanded or modified using the Menu Manager, meaning the new summaries, graphs, or slide templates can be added to the menu system. The menu system also features integrated object filtering and documentation, described below.

Decision model menu
In addition to the Main Menu, which is structured around a thematic grouping of the datasets, ADM offers an alternative menu structured around decision making processes. The Decision Model Menu is an effort to merge the conceptual basis of decision making with the wealth of information stored in ADM. Each decision process is represented by a simplified flow chart model, with relevant data objects listed for each factor which affects the ultimate decision. Users can edit decision models or make new ones through a simple easy to use interface.

Object filtering
Because ADM stores monitoring data for all years and GMAs in the same tables, it needs a mechanism to allow the user to specify which year(s), GMA(s), species, village(s), etc. should be presented in the different summaries. This is achieved through a "Filter Manager", which is integrated into the menu system and pops up each time the user opens a new summary, chart, map, etc. The Filter Manager features an easy point-and-click interface, and offers several different ways users can select the data they're interested in. It is easy to build filtering into new queries, reports, graphs, maps, etc. just by including the primarily lookup tables in the record source.


Figure 4 - The ADM Filter Manager

Integrated object documentation
In addition to the users guide, which explains how to use and expand ADM as a whole, the menu system also features documentation for individual objects including data entry forms, tabular queries, interactive graphs, reports, and interactive maps. A user can quickly see in plain English who designed the object, when it was created, what it is trying to represent, and how it is calculated. This information is available both at the Main Menu and after an object has been opened. This feature is critical to enable summaries and analyses to be reused over and over, because often the purpose and methodology behind an analysis may not be readily apparent just by looking at it.


Figure 5 - The ADM About window - part of the integrated object documentation

Data logging
ADM is a true multi-user application, being used by multiple analysts at the College and other locations. ADM's data logging feature keeps track of which records are being added, deleted, or changed. The log saves information about when data was altered, which table and which records were changed, and who made the change. Subsequently, if there are any questions about records getting accidentally altered, duplicate data entry, or synchronization problems, the data log can be referenced and the problem investigated. The data log is primarily a precautionary feature, but has proven useful for problem-solving on several occasions.

Integrated mapping capability
Using MapObjects to serve as the link between the tabular and spatial data, ADM includes user-friendly Interactive Maps for visualizing the spatial element of monitoring data. These maps present spatial summaries of data, such as an annual summary of the grids which are used by safari clients, poaching activity has been observed, generate the most revenue, have been patrolled, etc. Interactive Maps have many of the same toolbar options as ArcView, including the ability to add labels, change display colors or the classification scheme, make additional layers visible, create a legend, pan and zoom, etc. New maps can be easily created and added to the menu system by entering a new map definition, which specifies properties such as the layers which should be added, data the map should be linked to, etc. All interactive maps can be printed, copied to the clipboard, or sent to PowerPoint, and all make use of the standard features of the menu system, including filtering with the Filter Manager and plain-English documentation. ADM's interactive maps use many of the spatial layers that have been digitized at the College, as well as a few others collected from various sources. All layers are national in scope, allowing maps to be produced of multiple GMAs.

Large format layouts
One of the most important outputs of ADMADE's database are the large poster-sized layouts of monitoring data, which are used in community meetings and workshops. ADM uses OLE automation to create new layouts programmatically using PowerPoint based on data and maps from Access. Layouts can contain any combination of maps, charts, text, or summary tables. New layouts can be designed by creating a "Slide Template" definition, which specifies the layout of different elements on the page. Users can use the Filter Manager to select which data should be summarized when creating the layout. PowerPoint contains a number of drawing tools and commands that allows users to edit layout, add other elements such as digital photography, explanatory text, or clipart. When complete the layout can finally be printed on a laser printer or the College's plotter. Although the large-format layouts produced by ADM don't eliminate the need for ArcView, they greatly reduce the workload required to create the most often needed map outputs.

.


Click the thumbnail to see a larger image

Import-Export Object wizards
ADM is already being used at different sites within Zambia, and may one day be used at sites on different continents. The Import-Export Object wizards make it possible for an ADM user at one site to design new summaries, data tables, maps, slide templates, etc., export those objects to a temporary file, email that temporary file to a different user, and then seamlessly import the objects into the ADM menu system at the other site. These wizards make it feasible to provide long-distance tech support for ADM users who may not have the technical experience or familiarity with Access, an important feature if monitoring data is to become a tool for decision makers some distance from the data entry point.

Documentation
A comprehensive Users Guide has been written describing how to use ADM (National Parks and Wildlife Services, 1999b). The Users Guide has sections both for novice users as well as technical staff who need to know how to maintain and expand the system. The Users Guide comes both in printed format as well as a context-sensitive Windows help file. In addition to the Users Guide, a shorter overview of the technical capabilities of the new database has been written (National Parks and Wildlife Services, 1999a). These documents can be downloaded from http://nersp.nerdc.ufl.edu/~alyons/zm/adm.html.

Discussion

At the time of writing, ADMADE has had approximately one full year to use the new GIS/database on a day-to-day basis, without any external tech support. The following strengths and weaknesses have been noted:

Strengths

Weaknesses

Future Directions

To date, the ADMADE monitoring database has been centralized at the College. In 2000, several extension outposts are being set up to provide better services to communities around the Kafue National Park, which has been less adequately served by the College's extension program due to the long distances involved. One of the roles of these outposts will to support monitoring in the GMAs buffering Kafue, an activity which will include processing dataforms and creating summaries using the new Data Manager. Computer equipment has already been procured for four of the outposts, and the new staff members have recently completed training. This is the first time ADMADE has experimented with decentralizing data processing, and if successful it will be a major step towards increasing the monitoring capacity of communities.

The development of a powerful, easy to use information system for use in rural communities is timely in ADMADE, as support for the Community Resource Boards is becoming stronger. Students from the University of Zambia have been assisting ADMADE areas and conducting applied research. Several Peace Corps volunteers are also based in ADMADE areas with the mandate to support the community based organizations. ADMADE is planning to pilot test in 2000 the use of computers in one of the Community Resource Boards. The experiment will initially focus on financial record keeping, but will grow to include processing of other monitoring datasets with the Data Manager. As community capacity continues to grow, the demand for information tools such as the Data Manager will only increase as well.

Another option being explored is putting some of the database on the web, either statically or interactively. Although this venture would not serve rural communities, who are the main beneficiaries of the database and the owners of the data, it could benefit other stakeholders including various units in ZWA and ADMADE's partners in the donor community. Putting data online interactively would require a fair amount of technical assistance and system development, however static summaries of monitoring data can be made available fairly easily with the current system.

Conclusion

Information tools including GIS play an important role in community-based resource management. Tools such as the ADMADE Data Manger add value to the much more difficult tasks of data collection for resource monitoring and law enforcement. Ideally information processing and analysis capabilities will one day exist in rural communities themselves, but in the meantime a well-designed information system can enable a small technical team to support the information processing needs of a large project area. GIS outputs help community based organizations plan development activities, evaluate management efforts, and focus interventions and dialog on the key resource issues. In the continuing experiment of community based natural resource management, the ability to use information for strategic planning may just turn out to be the one critical factor that differentiates those areas which are able to maintain vibrant human and wildlife populations, and those areas which follow the unfortunate history of depletion of Africa's unique wildlife.

Acknowledgements

The work described in this paper builds upon ten years of effort developing ADMADE's information system by numerous staff and volunteers. Thanks go first to the many ADMADE staff who have played a formative role in developing the information system, including Bill Muyawa, James Katumbi, Zachs Nyorongo, and Phillip Ngulube. Thanks also go to GIS volunteers Kai Snyder, Jody Hilty.

ADMADE has been a long-time beneficiary of the Esri conservation program, whose support has been critical for developing GIS capability at the College. The work reported on in this paper was also supported by the Wildlife Conservation Society of New York and USAID/Zambia.

References

Aspinwall, D., Bingham, M. G., Chundama, M., Jeffery, R. C. V., & Sinkamba, M. (1996). Zambia a natural resources profile. Lusaka: World Wide Fund for Nature (WWF).

Lewis, D. M. (1995). Importance of GIS to community-based management of wildlife: lessons from Zambia. Ecological-Applications, 5(4), 861-871.

National Parks and Wildlife Services. (1993a). The ADMADE Geographic Information Systems Staff Manual.

National Parks and Wildlife Services. (1993b). ADMADE monitoring designs and methodologies . Mfuwe: National Parks and Wildlife Services, Nyamaluma Community-Based Wildlife Management Centre.

National Parks and Wildlife Services. (1995). Safari Hunting Monitoring Manual . Mfuwe, Zambia: Nyamaluma Institute for Community Based Resource Management.

National Parks and Wildlife Services. (1996). A Portfolio Sample of Monitoring Results from Selected Units in the ADMADE Programme, 1996 . Nyamaluma: Nyamaluma Institute.

National Parks and Wildlife Services. (1999a). ADMADE Data Manager An Introduction. Mfuwe, Zambia: Nyamaluma Institute.

National Parks and Wildlife Services. (1999b). ADMADE Data Manager Users Guide. Mfuwe, Zambia: Nyamaluma Institute.

Author Info:

Andrew Lyons
Department of Wildlife Ecology and Conservation
University of Florida
P.O. Box 110430
Gainesville, FL 32611-0430
email: filijee@yahoo.com

Dale Lewis
African College for Community Based Natural Resources Management
P.O. Box 82
Mfuwe
Zambia
email: admade@compuserve.com