Portal de Periódicos da CAPES

Agricultural chemicals use data access using coldfusion markup language and a relational database

2003; Elsevier BV; Volume: 38; Issue: 3 Linguagem: Inglês

10.1016/s0168-1699(03)00003-6

1872-7107

Yulu Xia, R. E. Stinner, Daryl Brinkman, Norman R. Bennett,

Analytical Chemistry and Chromatography

A relational database was developed for the agricultural chemical use data collected by the US Department of Agriculture, National Agricultural Statistics Service since 1990. coldfusion Markup Language was used for the client-side interface and server side process programming. The database is accessible from the Web at URL: http://www.pestmanagement.info/nass. Users can obtain information about agricultural chemical use in the database by search of crop, year, region, and active ingredient. Various agricultural chemical usage statistics are provided as Web tables, dynamically generated US maps, charts and graphs, and downloadable Excel files. We used a centralized software architecture in this project, which is suitable for projects with moderate programming complexity. A distributed approach might be more appropriate for the more complex projects. The current database information, spanning 1990–2001, will be augmented in the future, possibly using an automated updating scheme.