|
|
|
|
Research and IPMResearch Tools: California Pesticide Use SummariesUC IPM developed this database from data from the California Department of Pesticide Regulation. The database includes summaries of pesticides used on California crops datailed by commodity, pesticide, county, and month. The database has no information about a pesticide or its label.
About the ReportsCONTENTS:View ReportsBecause the Pesticide Use Summaries are often very large, we have separated the reports for viewing into manageable sizes and provided many ways for you to link to the various parts. Report HeadingsThe report heading, both a source of information and a navigational tool, includes:
Navigating and ButtonsFrom the report heading, you have navigational links as mentioned above. From any part of a report, you can link to:
At the bottom of each report, you can link to:
Report Contents and FormattingUnlike the reports you receive when you retrieve data, the order in which variables are displayed in the reports for viewing has been predetermined. All reports have common features, such as the information displayed at the top of the report, structure, and codes. Specific formatting conventions are used when multiple subtotals are requested. As the example below shows, vertical lines visually connect the subtotaled item name to the line displaying the subtotal figure, making the report easier to read. In this example, subtotals were requested for site, pesticide, county, and months in that sort order. Two sites (head lettuce and cotton), two pesticides (methomyl and aromatic petroleum distillates), and two counties (Fresno and Imperial) for January through December were the selection criteria. '*' indicates a subtotal value ----------------- ---------------
NUMBER
of APPLICATIONS POUNDS of AI
----------------- ---------------
cotton
| methomyl
| | Fresno County
| | | 1990 May 1 21.6000
| | | 1990 Jun 2 144.0000
| | | 1990 Jul 7 193.5000
| | | 1990 Aug 86 3,147.1176
| | | 1990 Sep 39 1,188.0000
| | | 1990 Oct 13 345.6450
| | | 1990 Nov 1 34.2000
| | | 1990 Unkn 2 19.6632
| | *Subtotal Fresno County 151 5,093.7258 *
| |
| | Imperial County
| | | 1990 Aug 1 5.4000
| | *Subtotal Imperial County 1 5.4000 *
| |
| *Subtotal methomyl 152 5,099.1258 *
|
| petroleum distillates, aromatic
| | Fresno County
| | | 1990 Mar 1 5.6179
| | | 1990 Apr 1 63.2016
| | | 1990 May 18 404.0192
| | | 1990 Jun 31 735.6125
| | | 1990 Jul 80 2,605.8678
| | | 1990 Aug 674 34,168.1586
| | | 1990 Sep 44 1,611.1397
| | | 1990 Oct 1 15.2555
| | | 1990 Unkn 4 289.8381
| | *Subtotal Fresno County 854 39,898.7109 *
| |
| | Imperial County
| | | 1990 Mar 6 16.4936
| | | 1990 Apr 14 280.8527
| | | 1990 May 7 113.2111
| | | 1990 Jun 17 122.1580
| | | 1990 Jul 140 1,501.0338
| | | 1990 Aug 159 2,136.4149
| | | 1990 Sep 50 1,678.1781
| | *Subtotal Imperial County 393 5,848.3422 *
| |
| *Subtotal petroleum distillates, aromatic 1,247 45,747.0531 *
|
*Subtotal cotton 1,399 50,846.1789 *
lettuce, head
| methomyl
| | Fresno County
| | | 1990 Feb 4 79.2000
| | | 1990 Mar 169 4,710.0150
| | | 1990 Apr 11 184.5000
| | | 1990 Aug 117 2,802.6000
| | | 1990 Sep 893 20,214.7308
| | | 1990 Oct 388 9,309.7824
| | | 1990 Nov 9 72.2400
| | | 1990 Unkn 21 473.4000
| | *Subtotal Fresno County 1,612 37,846.4682 *
| |
| | Imperial County
| | | 1990 Jan 145 4,947.7830
| | | 1990 Feb 64 2,050.2000
| | | 1990 Mar 2 52.2000
| | | 1990 Sep 33 853.5330
| | | 1990 Oct 572 14,063.2348
| | | 1990 Nov 592 16,234.5620
| | | 1990 Dec 192 5,381.4360
| | | 1990 Unkn 1 19.8000
| | *Subtotal Imperial County 1,601 43,602.7488 *
| |
| *Subtotal methomyl 3,213 81,449.2170 *
|
| petroleum distillates, aromatic
| | Fresno County
| | | 1990 Mar 3 22.8949
| | | 1990 Apr 1 15.3696
| | | 1990 Oct 1 17.9136
| | *Subtotal Fresno County 5 56.1781 *
| |
| | Imperial County
| | | 1990 Jan 2 134.4106
| | | 1990 Feb 4 214.5241
| | | 1990 Oct 3 183.3265
| | | 1990 Nov 13 1,160.0956
| | | 1990 Dec 6 558.5695
| | *Subtotal Imperial County 28 2,250.9263 *
| |
| *Subtotal petroleum distillates, aromatic 33 2,307.1044 *
|
*Subtotal lettuce, head 3,246 83,756.3214 *
Retrieve DataSteps Needed to Retrieve Pesticide Use Data
Selecting Output OptionsReportsAll reports have common features, such as the information displayed at the top of the report, structure, and codes. The top of the report displays the date and time the report was generated and the selection criteria you requested, including site, pesticide, and county names; use period; subtotal categories; sort order; and unit and method abbreviations, when applicable. Standard ReportThe standard report, shown below, displays number of applications and pounds of active ingredient by site, then pesticide. ** University of California, Division of Agriculture & Natural Resources **
California Pesticide Use Summaries report created: 14:45:17 29 JAN 1993.
2 sites requested:
cotton
lettuce, head
2 pesticides requested:
methomyl
petroleum distillates, aromatic
2 counties requested:
Fresno Imperial
Pesticide use period requested: Jan 1990 through Dec 1990
Subtotals requested:
Sites Pesticides
Report order:
Sites Pesticides Counties Months
******************************************************************************
# APPS POUNDS AI
cotton
| methomyl 152 5,099.1258
| petroleum distillates, aromatic 1,247 45,747.0531
*Subtotal cotton 1,399 50,846.1789 *
lettuce, head
| methomyl 3,213 81,449.2170
| petroleum distillates, aromatic 33 2,307.1044
*Subtotal lettuce, head 3,246 83,756.3214 *
# APPS POUNDS AI
---- --------
GRAND TOTAL 4,645 134,602.5003
Reports with a Customized FormatYou can request the summaries in various formats by choosing "Report with a customized format." The associated selections determine whether subtotals for site, pesticide, county, and month are reported and the order in which the subtotals are displayed. Additionally, you can choose to report amount treated and planted, and application method, which will greatly increase your report size and create large files. As shown below, the options are separated into three blocks, each used to determine your final report format. Make selections in the first block to indicate that you want subtotals of "# apps" and "pounds AI" by site, pesticide, county, and/or month. In the next block, select 1, 2, 3, or 4 for the order that you want the selected subtotals displayed. You must enter an order number for each option that you selected in the first block. Make selections in the third block to generate report totals for "Amount treated and planted" and "Application method" (these selections may greatly increase the size of your report). Grand totals only. A simple report of grand totals only, as shown below, can be produced by not marking any fields.
** University of California, Div. of Agriculture & Natural Resources **
California Pesticide Use Summaries report created: 11:48:08 17 DEC 1992.
2 sites requested:
tomato
tomato (processing/canning)
1 pesticide requested:
bacillus thuringiensis
1 county requested:
Yolo
Pesticide use period requested: Jan 1990 through Dec 1990.
Subtotals requested:
none
Sort-order:
Sites Pesticides Counties Months
******************************************************************************
#APPS POUNDS AI
----- ---------
GRAND TOTAL 38 95.4024
Subtotals by site, pesticide, county, and months in that sort order. Specific formatting conventions are used when multiple subtotals are requested. As the example below shows, vertical lines visually connect the subtotaled item name to the line displaying the subtotal figure, making the report easier to read. In the example below, subtotals were requested for site, pesticide, county, and months in that sort order. Two sites (head lettuce and cotton), two pesticides (methomyl and aromatic petroleum distillates), and two counties (Fresno and Imperial) for January through December 1990 were the selection criteria. ** University of California, Division of Agriculture & Natural Resources ** California Pesticide Use Summaries report created: 14:57:28 29 JAN 1993. 2 sites requested: cotton lettuce, head 2 pesticides requested: methomyl petroleum distillates, aromatic 2 counties requested: Fresno Imperial Pesticide use period requested: Jan 1990 through Dec 1990 Subtotals requested: Sites Pesticides Counties Months Report order: Sites Pesticides Counties Months ****************************************************************************** Subtotals for "amount treated and planted" and "application method." In the example below, the only options selected were "amount treated and planted" and "application method." Unit codes are used when reporting amount treated:
Abbreviations used when reporting method of application are: NPS (applied in a nonproduction situation); Grd (Ground); and Oth (other).
** University of California, Division of Agriculture & Natural Resources **
California Pesticide Use Summaries report created: 14:18:45 22 DEC 1992.
1 sites requested:
rice
2 pesticides requested:
methyl bromide
molinate
3 counties requested:
Butte Colusa Glenn
Pesticide use period requested: Mar 1990 through Aug 1990
Subtotals requested:
Treated/Planted Application Method
Report order:
Sites Pesticides Counties Months
UNIT Abbreviations:
A = Acres; K = Thousands of cubic feet; T = Tons; X = Misc.; O = Other
Method Abbreviations:
NPS = Applied in a nonproduction situation; GRD = Ground; Oth = Other
********************************************************************
METHOD #APPS POUNDS AI UNIT TREATED PLANTED
------------ ------------ ------ -------- --------
Air 3,084 932,266.7134 A 229,907.54 313,678.95
Ground 71 17,519.4386 A 3,715.07 5,733.94
Other 43 11,043.1103 A 2,748.33 4,254.43
NPS 6 1,448.6280 K 484.00
Ground 1 301.6789 X
All Air 3,084 932,266.7134 ALL
All Grd 72 17,821.1175 ALL
All Oth 43 11,043.1103 ALL
All NPS 6 1,448.6280 ALL
GRAND TOTAL 3,205 962,579.5692
Downloading Your Report or Data FileWhen you retrieve data, your request is submitted to the UC IPM computer for processing, which could take from seconds to hours to complete depending on the size and complexity of your request. When your request is fulfilled, you'll receive e-mail notifying you that your file is available. Your files will be retained for 7 days from date of completion, then deleted. All retrieval files are compressed and require a decompression application on your system to decompress them. Examples of decompression applications are PKZip (Windows), WinZip (Windows), and ZipIt (Macintosh). We've provided links from your mailbox Web page (Step 3, below) to sites where you can download these applications. The files have the filename extension ".zip" and are named in
the format "DD- hh:mm:ss"
Viewing Your Report File
|