Source: CORNELL UNIVERSITY submitted to NRP
DEVELOPMENT OF A PESTICIDE SALES AND USE REPORTING COMPUTERIZED DATABASE
Sponsoring Institution
State Agricultural Experiment Station
Project Status
COMPLETE
Funding Source
Reporting Frequency
Annual
Accession No.
0188018
Grant No.
(N/A)
Cumulative Award Amt.
(N/A)
Proposal No.
(N/A)
Multistate No.
(N/A)
Project Start Date
Oct 1, 2000
Project End Date
Sep 30, 2009
Grant Year
(N/A)
Program Code
[(N/A)]- (N/A)
Recipient Organization
CORNELL UNIVERSITY
(N/A)
ITHACA,NY 14853
Performing Department
ENTOMOLOGY
Non Technical Summary
Cornell University will assist the NYS Department of Environmental Conservation in the development of a Pesticide Sale and Use Reporting Database.
Animal Health Component
(N/A)
Research Effort Categories
Basic
100%
Applied
(N/A)
Developmental
(N/A)
Classification

Knowledge Area (KA)Subject of Investigation (SOI)Field of Science (FOS)Percent
90152202080100%
Goals / Objectives
1. Develop a pesticide sales and use reporting database. 2. Develop satellite databases for state lead agency's Bureau of Pesticide Management. 3. Develop imaging/scanning technology for displaying pesticide labels. 4. Assist state lead agency with decisions for carrying out a Pesticide Reporting Law Statute in NYS.
Project Methods
Using the most modern and current technology, a Pesticide Sales and Use Reporting Database will be developed, including related databases using the following: Unix/Informix platforms; Filemaker Pro database; web creation/access; Sybase Powerbuilder; related databases; imaging software (Alchemy).

Progress 10/01/08 to 09/30/09

Outputs
OUTPUTS: Approximately five (5) million New York State pesticide sales and use records were processed during the year per the Pesticide Reporting Law of 1996. Similar data for previous years were updated and posted to the Pesticide Management Education Program (PMEP) website, http//:pmep.cce.cornell.edu/psur for the public to access. Cornell University researchers were provided with confidential data relative to pesticide applications made in New York as part of their on-going groundwater/pesticide research-monitoring program. Pesticide application and sales data were converted to pounds of active ingredient so that reviewers can assess the data in an easier format. A pesticide certification administrative database and a pesticide product registration database, with currently registered pesticide label images (pdf format), continue to be updated for the New York State Department of Environmental Conservation (NYSDEC) and for access by the regulated community and the public. A separate active ingredient application website using MS SharePoint technology interfaces with the pesticide sales and use data application and the Business Registration and Commercial permits database. The NYSDEC registration documents and pesticide active ingredient information are continually posted on the PMEP website for access by the public. Updates and enhancements to the electronic reporting application are ongoing and allow for ease-of-use reporting for the regulated community. PARTICIPANTS: The following program staff have worked on developing database applications: Robert Warfield, programmer for the pesticide sales and use application; Chet Brion, programmer for the pesticide product registration system; Frank Smith, programmer for the aquatic permitting system, the business registration and commercial business application, and electronic reporting system; Thornton Martin, advisor/consultant for networking and service bureau activities; David Lane, programmer for the active ingredient conversion application and electronic reporting system; and Art Samplaski, website programmer. In addition, we work closely with the New York State Department of Environmental Conservation (Margaret O'Neil and other bureau staff members) and the New York State Department of Health (Nancy Kim and Carol Ju). Cornell University researchers (Brian Richards and Tammo Steenhuis) have been provided with pesticide application data for Cortland and Schenectady Counties. Pesticide product registration data and label images have been provided to the National Pesticide Information Retrieval System at Purdue University (Vicki Cassens).Microsoft Sharepoint technology has been provided by William Parken from the Cornell Pesticide Management Education Program and from Raj Smith, Department of Natural Resources, Cornell University. TARGET AUDIENCES: Our database applications are developed primarily for the New York State Department of Environmental Conservation (pesticide regulation responsibilities) and the New York State Department of Health (human exposure assessments) per the New York State Pesticide Reporting Law of 1996. An additional feature of our efforts is that we are able to provide the regulated community -- commercial and private applicators and pesticide businesses -- with Internet access to those pesticide products and label images currently registered in New York State. We also provide networking capabilities and a service bureau for the regulated community to report their applications and sales electronically to us and to obtain assistance respectively. Finally, we provide a website, http://pmep.cce.cornell.edu/psur, that can be accessed by anyone interested in pesticide data reporting, pesticide active ingredient information, pesticide safety and use information, and links to other pesticide resources. A collaborative website using Microsoft Sharepoint has been created to replace our chemical information library; this will allow for multiple authoring and project staff updating. This will also allow for easier access by the user and greater diversity for information outputs (fact sheets, print-on-demand). PROJECT MODIFICATIONS: A collaborative website using Microsoft Sharepoint has been created to replace our chemical information library; this will allow for multiple authoring and project staff updating. This will also allow for easier access by the user and greater diversity for information outputs (fact sheets, print-on-demand). Also, continual updates and enhancements have been made to the electronic reporting application for those applicators that were required to report their pesticide applications during 2009.

Impacts
Development and completion of pesticide databases and reporting applications are essential for the state lead agency to meet federal and state mandates (i.e. pesticide reporting laws). Also, the data are utilized by the New York State Department of Health and university researchers to assess human exposure to pesticides and for monitoring potential pesticide impacts on groundwater/surface waters in New York State. Funding from The New York State Department of Environmental Conservation (NYSDEC) has allowed the Cornell Pesticide Management Education Program (PMEP) to work in conjunction with the NYSDEC to assess pesticide use and sales on a county-by-county, zip code, and a statewide basis. Pesticide use and sales are being reviewed (single and multiple years) in major agricultural areas of the state, as well as on Long Island where residents and businesses depend on ground water for drinking. The NYSDEC has been able to use the data to regulate use of certain pesticides within the state and to restrict those products that pose a problem to humans and the environment. Also, the regulated community has access to the current pesticide products and label images registered in the state, thus allowing them to remain in legal compliance when making applications.

Publications

  • Smith, F. and W. Smith. 2009. PIMS user survey. Pesticide Management Education Program, Cornell University, Ithaca, New York. July. 6 pp.
  • Smith, W. 2009. Pesticide sales and use reporting (PSUR) quarterly reports. Pesticide Management Education Program, Cornell University, Ithaca, New York. April/August/November.
  • Smith, W. (Editor) 2009. Pesticide sales and use reporting projects: OSP project number 54025/A001. Pesticide Management Education Program, Cornell University, Ithaca, New York. January


Progress 10/01/07 to 09/30/08

Outputs
OUTPUTS: Approximately three (3) million New York State pesticide sales and use records were processed during the year per the Pesticide Reporting Law of 1996. Similar data for previous years were updated and posted to the Pesticide Management Education Program (PMEP) website, http//:pmep.cce.cornell.edu/psur for the public to access. Cornell University researchers were provided with confidential data relative to pesticide applications made in New York as part of their on-going groundwater/pesticide research-monitoring program. Pesticide application and sales data were converted to pounds of active ingredient so that reviewers can assess the data in an easier format. A pesticide certification administrative database and a pesticide product registration database with currently registered pesticide label images (pdf format) continue to be updated for the New York State Department of Environmental Conservation (NYSDEC). A separate active ingredient application website using MS SharePoint technology has been created to interface with the pesticide sales and use data application and phase one for two new applications--Business Registration and Commercial permits-- has been completed. NYSDEC registration documents and pesticide active ingredient information are continually posted on the PMEP website for access by the public. PARTICIPANTS: The following program staff have worked on developing database applications: Robert Warfield, programmer for the pesticide sales and use application; Chet Brion, programmer for the pesticide product registration system; Frank Smith, programmer for the aquatic permitting system, the business registration and commercial business application, and electronic reporting system; Thornton Martin, advisor/consultant for networking and service bureau activities; David Lane, programmer for the active ingredient conversion application and electronic reporting system; and Art Samplaski, website programmer. In addition, we work closely with the New York State Department of Environmental Conservation (Margaret O'Neil and other bureau staff members) and the New York State Department of Health (Nancy Kim and Carol Ju). Cornell University researchers (Brian Richards and Tammo Steenhuis) have been provided with pesticide application data for Cortland and Schenectady Counties. Pesticide product registration data and label images have been provided to the National Pesticide Information Retrieval System at Purdue University (Vicki Cassens). TARGET AUDIENCES: Our database applications are developed primarily for the New York State Department of Environmental Conservation (pesticide regulation responsibilities) and the New York State Department of Health (human exposure assessments) per the New York State Pesticide Reporting Law of 1996. An additional feature of our efforts is that we are able to provide the regulated community -- commercial and private applicators and pesticide businesses -- with Internet access to those pesticide products and label images currently registered in New York State. We also provide networking capabilities and a service bureau for the regulated community to report their applications and sales electronically to us and to obtain assistance respectively. Finally, we provide a website, http://pmep.cce.cornell.edu/psur, that can be accessed by anyone interested in pesticide data reporting, pesticide active ingredient information, pesticide safety and use information, and links to other pesticide resources. PROJECT MODIFICATIONS: Nothing significant to report during this reporting period.

Impacts
Development and completion of pesticide databases and reporting applications are essential for the state lead agency to meet federal and state mandates (i.e. pesticide reporting laws). Also, the data are utilized by the New York State Department of Health and university researchers to assess human exposure to pesticides and for monitoring potential pesticide impacts on groundwater/surface waters in New York State. Funding from The New York State Department of Environmental Conservation (NYSDEC) has allowed the Cornell Pesticide Management Education Program (PMEP) to work in conjunction with the NYSDEC to assess pesticide use and sales on a county-by-county, zip code, and a statewide basis. Pesticide use and sales are being reviewed (single and multiple years) in major agricultural areas of the state, as well as on Long Island where residents and businesses depend on ground water for drinking. The NYSDEC has been able to use the data to regulate use of certain pesticides within the state and to restrict those products that pose a problem to humans and the environment. Also, the regulated community has access to the current pesticide products and label images registered in the state, thus allowing them to remain in legal compliance when making applications.

Publications

  • Smith, W. G. 2008. New York State pesticide sales and use reporting quarterly report: October 2007 - December 2007. Pesticide Management Education Program. Cornell University, Ithaca, NY. 13 pp.
  • Smith, W. G. 2008. New York State pesticide sales and use reporting quarterly report: January 2008 - March 2008. Pesticide Management Education Program. Cornell University, Ithaca, NY. 9 pp.
  • Smith, W. G. 2008. New York State pesticide sales and use reporting quarterly report: April 2008 - June 2008. Pesticide Management Education Program. Cornell University, Ithaca, NY. 50 pp.
  • Smith, W. G. 2008. New York State pesticide sales and use reporting quarterly report: July 2008 - September 2008. Pesticide Management Education Program. Cornell University, Ithaca, NY. 43 pp.


Progress 10/01/06 to 09/30/07

Outputs
OUTPUTS: Approximately six (6) million New York State pesticide sales and use records were processed during the year per the Pesticide Reporting Law of 1996. Similar data for previous years were updated and posted to the Pesticide Management Education Program (PMEP) website, http//:pmep.cce.cornell.edu/psur for the public to access. Cornell University researchers were provided with confidential data relative to pesticide applications made in New York as part of their on-going groundwater/pesticide research-monitoring program. Pesticide application and sales data are now being converted to pounds of active ingredient so that reviewers can assess the data in an easier format. A pesticide certification administrative database and a pesticide product registration database with currently registered pesticide label images (pdf format) continue to be updated for the New York State Department of Environmental Conservation (NYSDEC). An aquatic permitting application for tracking pesticide applications to New York State surface waters is near completion and phase one for two new applications--Business Registration and Commercial permits-- is completed. NYSDEC registration documents and pesticide active ingredient information are continually posted on the PMEP website for access by the public. PARTICIPANTS: The following program staff have worked on developing database applications: Robert Warfield, programmer for the pesticide sales and use application; Chet Brion, programmer for the pesticide product registration system; Frank Smith, programmer for the aquatic permitting system and the business registration and commercial business applications; Joe Gosselin, advisor/consultant for networking and service bureau activities; David Lane, programmer for the active ingredient conversion application; and Art Samplaski, website programmer. In addition, we work closely with the New York State Department of Environmental Conservation (Margaret O'Neil and Sam Jackling) and the New York State Department of Health (Nancy Kim and Carol Ju). Cornell University researchers (Brian Richards and Tammo Steenhuis) have been provided with pesticide application data for Cortland and Schenectady Counties. Pesticide product registration data and label images have been provided to the National Pesticide Information Retrieval System at Purdue University (Vicki Cassens). TARGET AUDIENCES: Our database applications are developed primarily for the New York State Department of Environmental Conservation (pesticide regulation responsibilities) and the New York State Department of Health (human exposure assessments) per the New York State Pesticide Reporting Law of 1996. An additional feature of our efforts is that we are able to provide the regulated community -- commercial and private applicators -- with internet access to those pesticide products and label images currently registered in New York State. We also provide networking capabilities and a service bureau for the regulated community to report their applications and sales electronically and to obtain assistance respectively.

Impacts
Development and completion of pesticide databases are essential for the state lead agency to meet federal and state mandates (i.e. pesticide reporting laws). The data are utilized by health and university researchers to assess human exposure to pesticides and for monitoring potential pesticide impacts on groundwater/surface waters in New York State. Funding from The New York State Department of Environmental Conservation (NYSDEC) has allowed the Cornell Pesticide Management Education Program (PMEP) to work in conjunction with the NYSDEC to assess pesticide use and sales on a county-by-county and statewide basis. Pesticide use and sales are being reviewed (single and multiple years) in major agricultural areas of the state, as well as on Long Island where residents and businesses depend on ground water for drinking. The NYSDEC has been able to use the data to regulate use of certain pesticides within the state and to restrict those products that pose a problem to humans and the environment. Also, the regulated community has access to the current pesticide products and label images registered in the state, thus allowing them to remain in legal compliance when making applications.

Publications

  • New York State Department of Environmental Conservation. 2007. Final annual report for New York State pesticide sales and applications 2005. NYSDEC, Albany, NY. 31 pp.


Progress 01/01/06 to 12/31/06

Outputs
Approximately 5.3 million New York State pesticide sales and use records were processed during the year per the Pesticide Reporting Law of 1996. Similar data for previous years were updated and posted to the Pesticide Management Education Program (PMEP) website, http//:pmep.cce.cornell.edu/psur for the public to access. Cornell University researchers were provided with confidential data relative to pesticide applications made in New York as part of their on-going groundwater/pesticide research-monitoring program. Pesticide application and sales data are now being converted to pounds so that reviewers can assess the data in an easier format. A pesticide certification administrative database and a pesticide product registration database with currently registered pesticide label images (pdf format) continue to be updated for the New York State Department of Environmental Conservation (NYSDEC). An aquatic permitting application for tracking pesticide applications to surface waters is near completion and two new applications--Business Registration and Commercial permits-- are being developed. NYSDEC registration documents and pesticide active ingredient information are continually posted on the PMEP website.

Impacts
Development and completion of pesticide databases are essential for the state lead agency to meet federal and state mandates (i.e. pesticide reporting laws). The data are utilized by health and university researchers to assess human exposure to pesticides and pesticide monitoring for groundwater/surface waters respectively in New York State.

Publications

  • New York State Department of Environmental Conservation. 2006. Final annual report for New York State pesticide sales and applications 2004. NYSDEC, Albany, NY. 27 pp.


Progress 01/01/05 to 12/31/05

Outputs
Approximately 5.9 million New York State pesticide sales and use records were processed during the year per the Pesticide Reporting Law of 1996. Similar data for previous years were updated and posted to the Pesticide Management Education Program (PMEP) website, http//:pmep.cce.cornell.edu/psur for the public to access. Cornell University researchers were provided with confidential data relative to pesticide applications made in Schenectady County as part of their on-going groundwater/pesticide research-monitoring program. Pesticide application and sales data are now being converted to pounds so that reviewers can assess the data in an easier format. A pesticide certification administrative database and a pesticide product registration database with currently registered pesticide label images (pdf format) continue to be updated for the New York State Department of Environmental Conservation (NYSDEC). An aquatic permitting application for tracking pesticide applications to surface waters in New York is being developed for the NYSDEC. NYSDEC registration documents and pesticide active ingredient information are continually posted on the PMEP website.

Impacts
Development and completion of pesticide databases are essential for the state lead agency to meet federal and state mandates (i.e. Pesticide Reporting Law). The information is also utilized by Cornell University researchers for their groundwater/surface water monitoring programs and by Cornell Cooperative Extension Educators in their pesticide applicator training programs. The regulated community, i.e. pesticide applicators and businesses, have the ability to stay up-to-date of currently registered pesticides via a website and stay informed of continually changing state pesticide regulations and statutes

Publications

  • New York State Department of Environmental Conservation. 2005. Final report for New York State pesticide sales and applications 2003. NYSDEC, Albany, NY. 27 pp.


Progress 01/01/04 to 12/31/04

Outputs
Approximately five million New York State pesticide sales and use reports were processed for 2003 per the Pesticide Reporting Law of 1996. Similar data for 2002 were posted to the program website for the public and entities desiring to access these data. University researchers and state officials were provided confidential data relative to applications made in Cortland County and pesticide applications near coastal waters respectively. Development continues for the deploymment of a pesticide certification administrative database and a pesticide product registration database including label images for use by the New York State Department of Environmental Conservation. A new database -- aquatic permitting -- is now underway for the Department.

Impacts
Development and completion of pesticide databases are essential for the state lead agency to meet federal and state mandates (i.e. Pesticide Reporting Law). The information is also utilized by Cornell Cooperative Extension Educators.

Publications

  • Smith, W. 2003. Pesticide labels. In Encyclopedia of Pest Management, 2004. Marcel Dekker, Inc., New York, NY. 4 pp.


Progress 01/01/03 to 12/31/03

Outputs
Cornell University processed pesticide sales and use reports submitted by pesticide applicators for 2001 and 2002. A report summarizing 2001 pesticide use and sales data were submitted to the NYS Dept. of Environmental Conservation and posted on the program website. Development continues for the deployment of pesticide certification, product registration, and label imaging databases for the state lead agency.

Impacts
Development and completion of pesticide databases are essential for the state lead agency to meet federal and state mandates (i.e. Pesticide Reporting Law). The information is also utilized by Cornell Cooperative Extension Educators.

Publications

  • No publications reported this period


Progress 01/01/02 to 12/31/02

Outputs
Pesticide sales and use information collected in New York State during 2001was processed in an Informix-based database platform and then massaged into a report generator for final submission to state agencies and the NYS legislature. A pesticide label imaging database was completed and deployed for the NYS Department of Environmental Conservation personnel; deployment for a similar database for the public is underway. A pesticide applicator certification database prototype was delivered for review. These databases assist the regulatory agency and regulated community in pesticide reporting requirements and knowing what pesticides are legally registered for use and sale in NYS.

Impacts
Development of a pesticide sales and use reporting database, including the development of associated databases (applicator certification, product registration tracking and label imaging) are essential for state/federal regulatory mandates. These databases assist the regulatory agency and regulated community in pesticide reporting requirements and knowing what pesticides are legally registered for use and sale in NYS.

Publications

  • Smith, W. editor. 2002. New York State pesticide sales & use database and recordkeeping & reporting: program update, September 1997 to April 2002. Pesticide Management and Education Program, Cornell University, Ithaca, NY