Pedosphere 14(3): 347--353, 2004
ISSN 1002-0160/CN 32-1315/P
©2004 Soil Science Society of China
Published by Elsevier B.V. and Science Press
| A GIS-based database management application package for fertilizer recommendations in paddy fields |
| ZHOU Lian-Qing1, SHI Zhou1, WANG Ren-Chao1 and J. BAILEY2 |
1 Institute of Agricultural Remote Sensing and Information Systems, Zhejiang University, Hangzhou 310029 (China). E-mail: saintsing@zju.edu.cn;
2 Department of Agriculture and Rural Development for Northern Ireland, Agricultural and Environmental Science Division, Newforge Lane, Belfast BT9 5PX(UK) |
| ABSTRACT |
| 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. |
| Key Words: ActiveX Control, fertilizer recommendation, geographic information system (GIS), paddy field |
| Citation: Zhou, L. Q., Shi, Z., Wang, R. C. and Bailey, J. 2004. A GIS-based database management application package for fertilizer recommendations in paddy fields. Pedosphere. 14(3): 347-353. |
|
View Full Text
|
|
|
|
