A GIS-based database management application for agroforestry planning and tree selection

E. A. Ellis, P. K.R. Nair, Peter Linehan, H. W. Beck, C. A. Blanche

Research output: Contribution to journalConference article

30 Citations (Scopus)

Abstract

Agroforestry (the deliberate growing of trees or shrubs in rural lands) is being promoted in the United States as an alternative resource management system that can bring landowners economic benefits and provide environmental services such as reduced soil erosion, improved water quality and wildlife habitat. Landowners, farmers and extension agents need to be better informed about different agroforestry opportunities and potential tree species. The Florida Agroforestry Decision Support System (FADSS) was designed to aid in the dissemination of such information. FADSS utilizes a geographical information system (GIS) enabling the user to select a location of interest which is linked to spatial data on climate and soils characteristics for the state of Florida. The application also incorporates a database of over 500 trees and 50 tree attributes, forming a relational database. The application structure consists primarily of building database queries using Standard Query Language (SQL). SQL queries are constructed during run-time based on spatial parameters of a selected location, the type of agroforestry system desired, and production and management criteria provided by the user. Experts were interviewed to help develop queries used to select trees and other agroforestry species. Being a prototype, the application is built with a modular and flexible framework in which spatial data of different scales and/or regions as well as plant data may be easily incorporated. Among the major limitations encountered during the development of FADSS with major implications on future agroforestry decision support systems was the current lack of tree information relevant to agroforestry and the lack of research involving the assessment of suitable trees and their characteristics. (C) 2000 Elsevier Science B.V.

Original languageEnglish (US)
Pages (from-to)41-55
Number of pages15
JournalComputers and Electronics in Agriculture
Volume27
Issue number1-3
DOIs
StatePublished - Jun 1 2000
EventThe Scientific Conference on 'The Application of Scientific Knowledge to Decisionmaking in Managing Forest Ecosystems' - Asheville, NC, USA
Duration: May 3 1999May 7 1999

Fingerprint

Forestry
agroforestry
Decision support systems
geographic information systems
Information systems
planning
GIS
Planning
Query languages
decision support systems
decision support system
Soils
spatial data
landowners
landowner
Water quality
Erosion
information dissemination
Economics
extension agents

All Science Journal Classification (ASJC) codes

  • Forestry
  • Agronomy and Crop Science
  • Computer Science Applications
  • Horticulture

Cite this

Ellis, E. A. ; Nair, P. K.R. ; Linehan, Peter ; Beck, H. W. ; Blanche, C. A. / A GIS-based database management application for agroforestry planning and tree selection. In: Computers and Electronics in Agriculture. 2000 ; Vol. 27, No. 1-3. pp. 41-55.
@article{1164c69e1896471a85cacc08d5679e76,
title = "A GIS-based database management application for agroforestry planning and tree selection",
abstract = "Agroforestry (the deliberate growing of trees or shrubs in rural lands) is being promoted in the United States as an alternative resource management system that can bring landowners economic benefits and provide environmental services such as reduced soil erosion, improved water quality and wildlife habitat. Landowners, farmers and extension agents need to be better informed about different agroforestry opportunities and potential tree species. The Florida Agroforestry Decision Support System (FADSS) was designed to aid in the dissemination of such information. FADSS utilizes a geographical information system (GIS) enabling the user to select a location of interest which is linked to spatial data on climate and soils characteristics for the state of Florida. The application also incorporates a database of over 500 trees and 50 tree attributes, forming a relational database. The application structure consists primarily of building database queries using Standard Query Language (SQL). SQL queries are constructed during run-time based on spatial parameters of a selected location, the type of agroforestry system desired, and production and management criteria provided by the user. Experts were interviewed to help develop queries used to select trees and other agroforestry species. Being a prototype, the application is built with a modular and flexible framework in which spatial data of different scales and/or regions as well as plant data may be easily incorporated. Among the major limitations encountered during the development of FADSS with major implications on future agroforestry decision support systems was the current lack of tree information relevant to agroforestry and the lack of research involving the assessment of suitable trees and their characteristics. (C) 2000 Elsevier Science B.V.",
author = "Ellis, {E. A.} and Nair, {P. K.R.} and Peter Linehan and Beck, {H. W.} and Blanche, {C. A.}",
year = "2000",
month = "6",
day = "1",
doi = "10.1016/S0168-1699(00)00095-8",
language = "English (US)",
volume = "27",
pages = "41--55",
journal = "Computers and Electronics in Agriculture",
issn = "0168-1699",
publisher = "Elsevier",
number = "1-3",

}

A GIS-based database management application for agroforestry planning and tree selection. / Ellis, E. A.; Nair, P. K.R.; Linehan, Peter; Beck, H. W.; Blanche, C. A.

In: Computers and Electronics in Agriculture, Vol. 27, No. 1-3, 01.06.2000, p. 41-55.

Research output: Contribution to journalConference article

TY - JOUR

T1 - A GIS-based database management application for agroforestry planning and tree selection

AU - Ellis, E. A.

AU - Nair, P. K.R.

AU - Linehan, Peter

AU - Beck, H. W.

AU - Blanche, C. A.

PY - 2000/6/1

Y1 - 2000/6/1

N2 - Agroforestry (the deliberate growing of trees or shrubs in rural lands) is being promoted in the United States as an alternative resource management system that can bring landowners economic benefits and provide environmental services such as reduced soil erosion, improved water quality and wildlife habitat. Landowners, farmers and extension agents need to be better informed about different agroforestry opportunities and potential tree species. The Florida Agroforestry Decision Support System (FADSS) was designed to aid in the dissemination of such information. FADSS utilizes a geographical information system (GIS) enabling the user to select a location of interest which is linked to spatial data on climate and soils characteristics for the state of Florida. The application also incorporates a database of over 500 trees and 50 tree attributes, forming a relational database. The application structure consists primarily of building database queries using Standard Query Language (SQL). SQL queries are constructed during run-time based on spatial parameters of a selected location, the type of agroforestry system desired, and production and management criteria provided by the user. Experts were interviewed to help develop queries used to select trees and other agroforestry species. Being a prototype, the application is built with a modular and flexible framework in which spatial data of different scales and/or regions as well as plant data may be easily incorporated. Among the major limitations encountered during the development of FADSS with major implications on future agroforestry decision support systems was the current lack of tree information relevant to agroforestry and the lack of research involving the assessment of suitable trees and their characteristics. (C) 2000 Elsevier Science B.V.

AB - Agroforestry (the deliberate growing of trees or shrubs in rural lands) is being promoted in the United States as an alternative resource management system that can bring landowners economic benefits and provide environmental services such as reduced soil erosion, improved water quality and wildlife habitat. Landowners, farmers and extension agents need to be better informed about different agroforestry opportunities and potential tree species. The Florida Agroforestry Decision Support System (FADSS) was designed to aid in the dissemination of such information. FADSS utilizes a geographical information system (GIS) enabling the user to select a location of interest which is linked to spatial data on climate and soils characteristics for the state of Florida. The application also incorporates a database of over 500 trees and 50 tree attributes, forming a relational database. The application structure consists primarily of building database queries using Standard Query Language (SQL). SQL queries are constructed during run-time based on spatial parameters of a selected location, the type of agroforestry system desired, and production and management criteria provided by the user. Experts were interviewed to help develop queries used to select trees and other agroforestry species. Being a prototype, the application is built with a modular and flexible framework in which spatial data of different scales and/or regions as well as plant data may be easily incorporated. Among the major limitations encountered during the development of FADSS with major implications on future agroforestry decision support systems was the current lack of tree information relevant to agroforestry and the lack of research involving the assessment of suitable trees and their characteristics. (C) 2000 Elsevier Science B.V.

UR - http://www.scopus.com/inward/record.url?scp=0034213236&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0034213236&partnerID=8YFLogxK

U2 - 10.1016/S0168-1699(00)00095-8

DO - 10.1016/S0168-1699(00)00095-8

M3 - Conference article

VL - 27

SP - 41

EP - 55

JO - Computers and Electronics in Agriculture

JF - Computers and Electronics in Agriculture

SN - 0168-1699

IS - 1-3

ER -