The Spatial Database’s Establishment And Applying Research Of The Intelligent Prescription To Flertilize Orienting To Farmers

At present, our country cultivated land resource is nervous and the land productive potential decline, because blind fertilization, not only ratio imbalance, and containing higher heavy metal pollution, the physicochemical properties of soil is destroyed. Nations hope that we can through the scientific method to alleviate this problem, so start the Soil testing for formulated fertilization project and the farmland productivity evaluation project. The two projects get a large number of outcome data witch provide technical support to help farmers to be scientific fertilization and protecting the cultivated land quality, but many farmers lack the knowledge and they can’t apply the data to the actual production, that make the outcome of the project is limited..Based on the GIS technology and the characteristics of the farmer group, combined with the project outcome data, designed and constructed the spatial database for the intelligent prescription to fertilize which oriented towards the farmers,that has realized the target that applied the outcome data in the actual production of the farmersThis paper adopted the Geodatabase data model to define and organize the spatial data, SQL Sever2008database management system to manage and store the data, and ArcSDE as channel to store and access the data to design the management model which could store the field survey data and outcome data of GaoQiao town uniformly. Meanwhile, use ArcGIS for Desktop platform for data processing and analysis to carry out structure design of spatial database and data loading to complete the spatial database’s establishment of the intelligent prescription to fertilize which oriented towards the farmers.This study was on the foundation of Arc Engine components of the GIS software platform and programming language C#to achieve the development of the spatial database application system of the intelligent prescription to fertilize which oriented towards the farmers. The system had the function such as data accessing and loading, the map operation, information querying and displaying, providing formula fertilizer recommendations and measuring tools. The establishment of this system has realized the target that applied the outcome data of the soil testing for formulated fertilization and the farmland productivity evaluation effectively in the actual production of the farmers, and provided a reliable basis for scientific fertilization for farmers.This paper mainly included the following works: 1. By collecting and analyzing the survey data and outcome data of formulated fertilization result data and the data of the farmland productivity evaluation in Gaoqiao town, and completed the data classification effectively.2. According to the characteristics of the Geodatabase data model and Arc Engine technology, do system configuration and data preprocessing, to provide technical support for the design and construction of the spatial database in the late.3. Use Geodatabase data model and ArcSDE technology to design and construct the spatial database for the intelligent prescription to fertilize which oriented towards the farmers, which realized the effective storage and management of the data.4. Based on Arc Engine and VS2010as the development platform, and using C#language, explorate and develop the spatial database applied system for the intelligent prescription to fertilize which oriented towards the farmers.