DATA SOURCE: 
Question mark

 Pesticide Use Report 

Search by Data Category:

Date
Date category information
Location
Location categories information
Site/Crop
Site category information
Product
Product category information
Chemical
Chemical category information
Other Criteria
Information about other pesticide use criteria
DPR logo

California Pesticide Information Portal (CalPIP)

Format Output Information

Format Output

After selecting your search criteria, you can customize the output format, or allow CalPIP to use the default settings. CalPIP offers you the choice of detail or summarized data formatted as HTML tables or tab-delimited text. If you opt for summarized data, CalPIP also allows you to set the grouping and sorting order for your output.

Available Data Columns
If you want detail data records, all you need to do is select data columns (see column definitions) from the Available Data Fields and then click on the Submit Query button at the bottom of the page. The Format Output page allows you to specify the type of information based on the query selections you’ve made. By default, a set of output data columns is pre-chosen. They return all data records without any summary.

Summarize Data
If you want your data summarized, click on the Summarize data checkbox. The summary will be generated in the following manner. Numeric data columns that can be added, such as pounds_product_applied, pounds_chemical_applied, amount_treated, amount_planted, etc., will be summarized (added) and a single record with the totals for each of these columns will be generated for each unique combination of the non-addable columns that have been selected.

Summable columns include:
  • POUNDS_CHEMICAL_APPLIED
  • POUNDS_PRODUCT_APPLIED   (See known issues.)
  • AMOUNT_PRODUCT_APPLIED   (See known issues.)
  • AMOUNT_PLANTED
  • AMOUNT_TREATED
Non-summable columns include:  
  • YEAR
  • APPLICATION_MONTH
  • MONTH_IN_YEAR
  • DATE
  • COUNTY_NAME
  • COMTRS
  • SITE_NAME
  • PRODUCT_NAME
  • REGISTRATION_NUMBER
  • PRODUCT_CHEMICAL_PERCENT
  • UNITS_PRODUCT_APPLIED
  • UNIT_PRODUCT_APPLIED
  • UNIT_PLANTED_DESCRIPTION
  • UNIT_PLANTED
  • UNIT_TREATED_DESCRIPTION
  • UNIT_TREATED
  • OUTLIER
  • AERIAL_GROUND_DESCRIPTION
  • AERIAL_GROUND_INDICATOR
  • AG_NONAG
  • USE_NUMBER
  • QUALIFY_CODE
  • COUNTY_CODE
  • SITE_CODE
  • CHEMICAL_CODE
  • RECORD_ID
  • GROWER_ID
  • LICENSE_NUMBER
  • PERMITTING_COUNTY_NAME
  • PERMIT_YEAR
  • PERMIT_NUMBER
  • PLANTING_SEQUENCE
  • SITE_LOCATION_ID

    For example, if you selected the output columns
YEAR, COUNTY_NAME, CHEMICAL_NAME, POUNDS_CHEMICAL_APPLIED
and you check the Summarize the Data box, a results record will be generated for each unique combination of
YEAR, COUNTY_NAME, CHEMICAL_NAME.
The results would have the following columns:
YEAR, COUNTY_NAME, CHEMICAL_NAME, SUM_POUNDS_CHEMICAL_APPLIED
Similarly, if you selected the output columns
YEAR, COUNTY_NAME, COMTRS, CHEMICAL_NAME, POUNDS_CHEMICAL_APPLIED
and you check the Summarize the Data box, a results record will be generated for each unique combination of
YEAR, COUNTY_NAME, COMTRS, CHEMICAL_NAME. Note in this case, there may be many COMTRS values for a given county, so the data will be summarized to that level.
The results would have the following columns:
YEAR, COUNTY_NAME, COMTRS, CHEMICAL_NAME, SUM_POUNDS_CHEMICAL_APPLIED

Columns to Sort By
Make selections from the Columns to Sort By list after selecting your output columns from the Available Data Fields list. The Columns to Sort By box will automatically list the fields that can be sorted from the Output Columns Selected. The order of your sorting selections will affect the way the data is summarized. In general, output columns follows the order of fields listed in the Output Columns Selected box.

Click on the ’<<’ (Clear All Selection) button or the ’Reset Page’ button to reset the page to default selections again.

Version 2017.04 {2015 PUR Data Update)