Using advanced spreadsheet features for agricultural GIS applications

• Main Author: Halbleib, Michael D.
• Other Authors: Righetti, Tim L.
• Language: en_US
• Published: 2012
• Subjects: Geographic information programs > Computer programs; Information storage and retrieval systems > Agriculture; Electronic spreadsheets
• Online Access: http://hdl.handle.net/1957/31441

A GIS analysis procedure was developed to explore relationships between imagery, yield data, soil information, and other assessments of a field or orchard. A set of conversion utilities, a spreadsheet, and an inexpensive shape file viewer were used to manipulate, plot, and display data. Specific features described include procedures used to: 1) display automated yield monitoring and aerial imagery data as surface maps for visual analysis, 2) generate maps from gridded soil sampling schemes that display either the collected soil data values or management information derived from further manipulation of the sample values, 3) evaluate relationships among data layers such as yield monitor, imagery, and soil data, 4) conduct an upper boundary line evaluation of potential yield-limiting factors. The analysis process is demonstrated on wheat, meadowfoam, and hazelnut data, from crops grown in Oregon. === Graduation date: 2002