A GIS-based database management package for fertilizer recommendations in Paddy fields

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.