Development of Pesticide Residue Database System in Rice Production from the Four Pilot Provinces

Abstract

Nowadays, the application of pesticides is widely used to prevent plant diseases and pests in Thailand. However, inappropriate use of pesticides could lead to a high risk of residue contamination in agricultural products which may affect consumers’ health and environment. This research aims to develop a database system to store pesticide residue in rice, soil, and water which can easily search and display through a web application. The Rice Pesticide Residue in Rice Production Database (Rice-PRdb) is developed on Windows Server 2019 with the MariaDB used as the database management system. The web application is built using PHP, CSS, HTML, and JavaScript and runs on an Apache HTTP server. In addition, pesticide residue data in rice, soil, and water samples from the central and western regions, i.e., Suphan Buri, Kanchanaburi, Chai Nat, and Phra Nakhon Si Ayutthaya provinces are collected in the database. The developed web application displays the information in maps and charts of detected area forms. The detected pesticides and concentrations are also reported and compared to the maximum residue limits (MRLs) from the National Bureau of Agricultural Commodity and Food Standards (ACFS) and Codex. Moreover, a dashboard is installed to display the link between the use of pesticides during rice cultivation and the residues found in rice products, soil, and water. The problem of rice pests in each cultivated area was also included. This web application shows high satisfaction and acceptability from users which can be accessed at http://trsi-app.ricethailand.go.th/dcrpr/. Therefore, this system can be used as a tool to monitor pesticide residues in risk areas and a guideline for further recommendations on pesticide application in rice production. The further study is extended to monitor in other rice production areas.