<br/>California has the most comprehensive record of pesticide applications worldwide, in the form of the Department of Pesticide Regulation's Pesticide Use Reports (PUR) database. Since 1990, every application of a non-fertilizer chemical to agricultural lands has been recorded. Each record includes date and time of application, products used, the locations of the application occurred in, a grower ID and field ID that are consistent within a year, what crop the product was used on, how much product was applied, how many acres were treated, and how many acres were planted.  As uncompressed text files, the current size of the dataset is over 12 gigabytes representing 58,371,297 distinct applications.<br/>Large datasets can be powerful when they are integrated and synthesized to a more understandable form which can then be used by decision makers.  However, easy to navigate these large datasets is often a problem to limit the potential use to the fullest.  The goal of PURwebGIS is to not only implement an intuitive yet flexible web-based front end for PUR querying, mapping, tabling and charting, but also integrate other databases into the framework.  These databases include the Surface Water Protection (SURF) database (which has entries for all surface water tests California Department of Pesticide Regulation (CDPR) has conducted or collected from other agencies), the California Information Management Information System (CIMIS) weather database, and allow the user to visualize results from external models alongside with CDPR data. Results can be spatially mapped, plotted over time, tabularly summarized, and downloaded as raw PUR records or as summarized products as well as the summaries for other databases of SURF and CIMIS.<br/>To check out the current version of the tool, see http://ziram.lawr.ucdavis.edu/PURwebGIS.html

PURwebGIS: simplifying a large agro-environmental spatio-temporial dataset for quick assessment and decision making

254th National Meeting (2017)

The official archive and repository for all ACS Meetings & Expositions abstracts and select posters or presentations.