CalPIP Navigation Menu

Data Sources
PUR
Selected Data Source
Pesticide Use Report
Search by Data Category
Date
Site/Crop
Product
Chemical
Other Criteria
California Pesticide Information Portal (CalPIP) Application

Query Pesticide Use Report

Format Output

Default selection: Year, Date, County_Name, COMTRS, Site_Name, Product_Name, Pounds_Product_Applied, Chemical_Name, Pounds_Chemical_Applied, Amount_Treated, Unit_Treated, Aerial_Ground_Indicator

To search for specific columns:

  • Enter full or partial words in the Search box to see matching columns or scroll through the Available Data Columns menu.
  • Click the ‘Clear Search’ button to clear your search and return the full list of columns.

To select columns:

  • Click on column names of interest in the Available Data Columns menu.
  • Hold the Shift key on your keyboard while clicking to select multiple adjacent columns or hold the Ctrl key to select multiple non-adjacent columns.
  • Once highlighted, click the ‘Add Selected’ button. Clicking on the ‘Add All’ button will add all columns currently listed in the menu.

Available Data Columns

Confirm that the columns of interest appear in the ‘Selected Items’ box below the menu. Highlight any columns to be removed and click ‘Remove Selected’. Click ‘Remove All’ to remove all columns.

Summarize Data

Summarize the Data 

If you would like pesticide use (amount_product_applied, amount_planted, amount_treated, pounds_chemical_applied, or pounds_product_applied) to be summed over your selected categories, click the Summarize the Data box. Be sure to include the corresponding UNIT column.

Checking this box will format your results as a summary report based on the columns in the Output Columns Selected box (above). Totals for all summable data colums are computed based on the level of detail determined by the non-summable columns.

Sort-By Columns

Arrange the data columns in the order you want the output to appear.

If you would like the columns to be in a certain order, you can use the Sort-By Columns menu to add each previously selected column in your preferred order. If you have chosen to summarize your data, the order of your sorting selections will affect the way the data is summarized. If you do not use the Sort-By Columns option, columns will be sorted based on the order of the columns as they appear.

Confirm that the columns of interest appear in the ‘Selected Items’ box below the menu. Highlight any columns to be removed and click ‘Remove Selected’. Click ‘Remove All’ to remove all columns.

Output File Format/Type

Tab-delimited text (default)  HTML table 

You can choose to have your data sent to you in either a tab-delimited text file, an HTML table file, or both. Text files can be opened in text editors such as Notepad, spreadsheets such as Excel, or loaded into databases and many types of software programs. An HTML table file opens as a webpage displayed by a web browser such as Chrome, Firefox, IE, Safari, etc.

To continue selecting query criteria, click on another category in the CalPIP Navigation Menu.




Version 2020.01 (2018 PUR Data Update)