A GIS-Based Database Management Package for Fertilizer Recommendations in Paddy Fields

作     者：ZHOULian-Qing SHIZhou WANGRen-Chao J.BAILEY 

作者机构：InstituteofAgriculturalRemoteSensingandInformationSystemsZhejiangUniversityHangzhou310029（China） DepartmentofAgricultureandRuralDevelopmentforNorthernIrelandAgriculturalandEnvironmentalScienceDivisionNewforgeLaneBelfastBT95PX（UK） 

出 版 物：《Pedosphere》 (土壤圈（英文版）)

年 卷 期：2004年第14卷第3期

页      面：347-353页

核心收录：

学科分类：0818[工学-地质资源与地质工程] 09[农学] 0903[农学-农业资源与环境] 0901[农学-作物学] 

基　　金：Project supported by the National Natural Science Foundation of China (No. 40001008) the China-British Higher Education Links (No. SHA/992/297) 

主　　题：肥料选购 地理信息系统 稻场 农业现代化 

摘      要：Over-use of fertilizer in paddy fields could lead to agro-environmental pollution. Therefore, the Paddy Fertilizer Recommendation System (PFRS) application package was designed to aid in the dissemination of fertilizer recommendations for paddy fields. PFRS utilized geographical information system (GIS) ActiveX Controls, enabling the user to select a location of interest linked to a spatial database of paddy field soil characteristics. The application package also incorporated different soil fertilizer recommendation methods, forming a relational database. The application s structure consisted primarily of building database queries using Standard Query Language (SQL) constructed during run-time, based on user provided spatial parameters of a selected location, the type of soil desired and paddy production criteria. PFRS, which was comprised of five modules including: File, View, Edit, Layer and Fertilizer/Model, provided the user with map-based fertilizer recommendations based on selected soil nutrient P and K map layers as well as N characteristics and land use maps.