International pesticide use information system for exporting vegetables and fruit

• Published in: International journal of pest management 2005-10, Vol.51 (4), p.225-230
• Main Authors: Xia, Y, Stinner, R.E, Tryon, E, Tutini, P
• Format: Article
• Language: English
• Subjects: application; Biological and medical sciences; exports; Food industries; Fruit and vegetable industries; fruits (food); Fundamental and applied biological sciences. Psychology; information systems; Internet resource; maximum residue limits; MRL; Pesticide; pesticide application; pesticide application restriction information; pesticide registration; pesticide residues; pesticides; Phytopathology. Animal pests. Plant and forest protection; programming; residue; vegetables
• ISSN: 0967-0874; 1366-5863
• DOI: 10.1080/09670870500396417

An online information system was developed to allow US growers to search pesticide application information for export of vegetables and fruits. By entering an export country, a crop name, pesticide type, and post harvest interval, a user can obtain a list of pesticides labeled for the crop, the pesticides suitable for use with export, and the associated pesticide application restriction (PAR) information for each pesticide in the recommended list. A relational database (Microsoft SQL Server 2000) was used to house the PAR data, pesticide labels, and pesticide maximum residue limit information (MRL). These data were obtained from governmental agencies and international organizations. The data were then entered into the system using an online data entry system developed using ColdFusion programming language. The database currently contains the registration information for over 1,100 pesticides, 20,000 MRL data entries, and 20,000 PAR entries. New data are updated frequently. The project web site is http://cipm.ncsu.edu/exportMRL .