Design and implementation of Surface Irrigation Soil Loss (SISL) and Soil Condition Index (SCI), (SISL-SCI) database

Graduate Project

Public Deposited

Citeable URL: https://ir.library.oregonstate.edu/concern/graduate_projects/2b88qm83s

Descriptions

Attribute Name	Values
Creator	Nkansah, Alexander K.
Abstract	The Soil Conditioning Index (SCI) aids the conservationist in designing crop rotations and residue management practices when low organic matter, poor soil tilt, and crusting problems are identified. The Natural Resources and Conservation Services (NRCS) field staff and others use the SCI as a qualitative tool during conservation planning. In this project we implemented a relational database for the SCI application and integrated it with the Soil Loss by Surface Irrigation (SISL) application by creating one normalized relational database schema. These two agricultural applications possess some commonalities that make them fit well together in one database system. Calculations for all the three subfactors of SCI are performed via stored procedures. These are called from within the SCI triggers for automatic execution. We expect that SISL-SCI database will become a basis for integrating several other agricultural applications, e.g., Revised Universal Soil Loss Equation (RUSLE) and Wind Erosion Estimates model (RWEQ).
Resource Type	Capstone Project
Date Issued	2001-04-12
Degree Level	Master's
Degree Name	Master of Science (M.S.)
Degree Field	Computer Science
Degree Grantor	Oregon State University
Commencement Year	2001
Advisor	Minoura, Toshimi
Committee Member	Bose, Bella Cull, Paul
Academic Affiliation	Computer Science
Rights Statement	In Copyright
Publisher	Oregon State University
Peer Reviewed	No
Language	English [eng]

Thumbnail	Title	Date Uploaded	Visibility	Actions
	Nkansah_Alexander_2001_12_04.pdf	2022-11-30	Public	Download