Keywords
gis, data warehouse, data analysis
Start Date
1-7-2012 12:00 AM
Abstract
The Swiss Feed Data Warehouse is a public service for companies, farmersand research institutions that provides detailed and up-to-date information about the concentrationof nutrients in animal feed from all across Switzerland. The core of the SwissFeed Data Warehouse is a carefully curated data warehouse with more than 2 millionchemical analyses of 600 feed types and 400 nutrients. The nutrient measurements areenriched with geographical (as postal code and altitude), temporal (as harvesting andanalyses dates), biological (as variety and botanical composition) and technical information(as conservation and production methods). We propose a solution that offers tousers a fast, effective and intuitive approach to query and analyze large amounts of highdimensional feed data. An interactive web-application enables dynamic query constructionand offers multiple charts to visualize feed data. Techniques such as radius searchand charts allow non-expert users to detect local correlations and trends in the feeddata. Historical information makes it possible for advanced users to analyze changes inthe feed quality and determine the balance of nutrients in feed mixes that minimizes theload of severe nutrients from animal excreta into ecosystems.
A GIS-based Data Analysis Platform for Analyzing the Time-Varying Quality of Animal Feed and its Impact on the Environment
The Swiss Feed Data Warehouse is a public service for companies, farmersand research institutions that provides detailed and up-to-date information about the concentrationof nutrients in animal feed from all across Switzerland. The core of the SwissFeed Data Warehouse is a carefully curated data warehouse with more than 2 millionchemical analyses of 600 feed types and 400 nutrients. The nutrient measurements areenriched with geographical (as postal code and altitude), temporal (as harvesting andanalyses dates), biological (as variety and botanical composition) and technical information(as conservation and production methods). We propose a solution that offers tousers a fast, effective and intuitive approach to query and analyze large amounts of highdimensional feed data. An interactive web-application enables dynamic query constructionand offers multiple charts to visualize feed data. Techniques such as radius searchand charts allow non-expert users to detect local correlations and trends in the feeddata. Historical information makes it possible for advanced users to analyze changes inthe feed quality and determine the balance of nutrients in feed mixes that minimizes theload of severe nutrients from animal excreta into ecosystems.
