300 likes | 480 Views
A DEVELOPING USER-ORIENTED DATABASE FOR PESTICIDES. Fengyou Jia 1,2 , Sonny Ramaswamy Gamage Dissanayake 3. jia@ksu.edu 1 Department of Entomology, Kansas State University 2 Department of Computing and Information Sciences, KSU 3 Department of Communications – IET, Kansas State University
E N D
A DEVELOPING USER-ORIENTED DATABASE FOR PESTICIDES Fengyou Jia1,2, Sonny Ramaswamy Gamage Dissanayake3 jia@ksu.edu 1Department of Entomology, Kansas State University 2Department of Computing and Information Sciences, KSU 3Department of Communications – IET, Kansas State University Manhattan, KS 66506, USA
As You Know: Pesticide application is one of the important practices in agricultural production.
Pesticide Usage In Kansas State, USA 6,136 Pests (insects, weeds, and plant diseases, …) in Kansas by 10/30/03 15,283 Pesticides (Products) registered in Kansas by 10/30/03. Source: http://nspirs.ceris.purdue.edu/htbin/PRLIST.COM
Pesticide Usage In Kansas (USA) • On average, it costs a farmer $10,000 annually in pest control in Kansas • 34,979 Farmers (Full time) in Kansas by 1997 • Multi-million dollars spent annually in pest control in Kansas • Growing business?
Paradox in plant protection • Applying pesticides, people can survive better from current pest stresses, but, at the unfortunate cost of • Deteriorating the environment we live Human may achieve a better quality living in sacrificing their descendant life
Why should we care about Environment? Critical point Number of poaple are deaf of heat waves Extreme temperature Time 50 Years? 100 Years? 1000 Years? Current Future
Advantages and disadvantages • Benefits …… • Problems • Is toxic to humans and domesticated animals • Kill non-targeted organisms • Disrupt eco-systems • Pollute the environment • ……
Pesticide Residuals In Apple 1) Combination effect??; 2) Interaction among pesticides?? Source: http://apps1.fao.org/servlet/org.fao.waicent.codex.PesticideServlet
Special warning Tumor related Alachor Aldrin amitraz arsenic arsenic acid captafol chlordane chlordimeform diclofop-methyl EDB formaldehyde heptachlor lindane linuron pentachlorophenol pronamide telone TPTH Birth defect related Brodifacoum Bromadiolone Chlorophacinone Cyanazine Dinocap Diphacinone Pindone Warfarin
To reduce and mitigate the negative influence of pesticides • Cultural practices • Biological controls • Genetic modified crops • …… • One easy way is to select relative safe pesticides in pest control
Lack of sophisticate tools To support the pesticides selection in pest management programs A query: Suppose a user intends to control ants around his house. Considering safety, the user prefers the pesticide products that have low toxicity to humans and animals because the applied sites are so close to the house-member and domesticated animals. The user may be an environmental conservator and expects the desired pesticide products having low toxicity to birds and other small invertebrates. Additionally, the user may expect the pesticides have a short persistent period in the soil.
Research Objective To design a user-oriented pesticide safety consultant system (tool) in guidance of pesticide selection and application in pest management program. Ultimately, we expect this consultant system would assist to reduce or minimize the use of certain pesticides that commit high hazardous potentials to humans, domestic animals, ecosystems, and the environment.
Potential Users Farmers Growers Extension Professions Government Agencies (e. g., EPA) Universities Private Consultants
Rationality(Fundamental basis to support our objective) Pesticides vary not only with target pests but with hazardous potentials to humans, ecosystems, and the environment as well.
Relative toxicity of pesticide to humans Pesticide Trade Name Acute Oral (Common name) LD50 Rats (mg/kg) ------------------------------------------------------------------------ Aldicarb Temik 1 Trichlorfon Dylox 150 Methoxychlor Marlate 6000
DT50 (Time required for 50% dissipation of the initial concentration of pesticide following application) Pesticide Trade Name DT50 (Common name) (in soil) ------------------------------------------------------------------------ Validamycin * <=5 hrs Oxadixyl * 2-3 months Fenarimol * >1 year
PLP (Pesticide Leach Potential) Pesticide Trade Name PLP(Common name) (index) ------------------------------------------------------------------ Mepiquat Pix 1 Daminozide Alar 50 Dalapon Dowpon 87
Project design (Pesticide Safety Consultant System) Project Design Pesticide Database Query Inputting Query Returning Pesticide Safety Consultant System (PSCS) Inputs Outputs Querying Results User
Domain Conceptual Model Crop grow People produce consume have Food drink apply Diseases infest Water reside Pesticide products Cause? pollute Pests contain control Ingredients carry Hazards
Object Model (PSCS) EPA represent mamtoxicity WHO represent Include FISH represent Include Pesticide products Hazards Ecotoxicity BIRD carry represent contain BEE represent Include Ingredients control Pests represent Environment _hazard DT50 represent FD50 represent PLP
ER Diagram for PSCS (Pesticide Safety Consultant System ) FORMULATION PRODUCT_NO MANUFACTURE Label PESTICIDE_EPA_NO n 1 Contain (ingredients) PESTICIDE_PRODUCT n PESTICIDE_NAME Control REGISTERED_STATE RESTRICTED_STATE n Pest_album Pest Ing_EPA_no Pest_description Pest_EPA_no Pest_group Pest_name multiple-valued attributes.
ER Diagram for PSCS (cont.) ING_EPA_NO Ingredient_proportion Ingredient_name WHO Product_no 1 Mamtoxicity Ing_EPA_no EPA Mam_effect CANCER_BIRTH_DEFECT 1 1 Ingredient ING_EPA_NO 1 Mode_action Eco_effect 1 HONEY BEE Ecotoxicity Env_effect n BIRD FISH 1 Environment__hazard PLP ING_EPA_NO DT50 FD50 Soil Half_life Field dissipation Half_life multiple-valued attributes.
Demo http://www.oznet.ksu.edu/pesticidedatabase/main.asp
Step 1 http://www.oznet.ksu.edu/pesticidedatabase/main.asp
Thanks • Comments • Suggestions