Design and Implementation of Database for a webGIS-based Rice Diseases and Pests System

Rice pests and diseases could have significant negative effects on rice production around the world. There is a need for managing and displaying the characteristics and variability of crop diseases and pests for an agricultural region at both spatial and temporal scales. In the current study, geographic information system (GIS) and database management technologies are applied to store, manage, analyze and visualize massive long-term heterogeneous information related to rice diseases and pests in Chongqing. Spatial data including administrative district, rivers, roads, monitor locations were digitized and corrected using ArcGIS 9.2. Non-spatial data including weekly long-term (2003-) records of rice pests and diseases from monitor locations in Chongqing were collected and analyzed. The developed database could provide critical information for early warning for high-risk areas of rice production and for management decision making.