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

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

The descriptions below will help you decide which columns to select from the Available Data Columns list on the Format Output page. The columns are shown in the same order as in the Available Data Columns list.

PUR database column definitions
COLUMN DESCRIPTION
AERIAL_GROUND_ABBREVIATION Also known as the Air/Ground Application Flag, or Method of Application. A code of A, G, F, or O indicates that the pesticide was an aerial application, a ground application, a fumigant, or an other method of application.
AERIAL_GROUND_DESCRIPTION Also known as the Air/Ground Application Flag, or Method of Application. Indicates whether a product was applied by aerial air or ground equipment: A - Aerially applied; B - Ground (ground-based equipment) applied; O - Other application methods. Other application methods (O) may include: paint, ear tag, injection, chemigation, etc.; F – Fumigant – since 2008, an F is required for fumigant applications in five ‘non-attainment’ areas (areas that do not meet air quality standards for pesticide volatile organic compounds (VOCs) : San Joaquin Valley NAA, Sacramento Metro NAA, South Coast NAA, Southeast Desert NAA, and Ventura NAA (see maps http://www.cdpr.ca.gov/docs/emon/vocs/vocproj/em_region.htm)). Note that some counties outside of the non-attainment areas also use the F code to track fumigants for their own record-keeping, although they are not legally required to do so.
AG_NONAG Pesticide use reports are classified as Ag or NonAg based on both the site or situation of use and the user. The classification is based on California’s legal definitions of production agriculture, non-production agriculture, and non-agriculture. However, for pesticide use report purposes, these three categories are grouped into two: production agriculture is labeled as Ag, while non-production agriculture and non-agriculture pesticide use reports are labeled as NonAg. The reason for these groupings are due to the types of information that are collected:
Ag pesticide use reports (production agriculture) include very detailed information, including the date, time, and 1x1 square mile section (COMTRS) where the application took place. Each pesticide use record equals a single application.
NonAg pesticide use reports (non-production agriculture and non-agricultural applications) are monthly summaries of all the applications of a single pesticide product. They only include the month and county where the applications took place. They often do not include any measure of area, such as acreage.
Examples of pesticide use reports classified as Ag (production agriculture): crop production (orchards, groves, fields), crops grown for seed, feed and forage, flowers (cut and sold), forests/timber production, greenhouse / nursery / mushroom production, livestock production (meat), milk production, post-harvest commodity treatment on the farm, poultry production (meat/eggs), preplant soil treatments, rangeland and pasture, field fumigation, turf (grown for sod)
Examples of pesticide use reports classified as NonAg (non-production agriculture and non-agriculture): post-harvest commodity treatments that take place off the farm, landscape maintenance, structural applications, cemeteries , parks, golf courses, green belts, recreation areas, ditches and ditch banks (may appear as crop name), drip lines, field borders and headlands, greenhouse / nursery / mushroom operations (outside general weeds and pests, as well as pest control within alley ways and other interior areas), ground water recharge ponds, irrigation canals, railroad shoulders, highway medians, farm roads, public health – vector control
AMOUNT_AREA_PLANTED The numerical value of the area of an entire field, site, or ranch upon which some portion received a pesticide application. May not be reported for NonAg (non-production-agricultural or non-agricultural) monthly summary pesticide use reports. Always check a description or abbreviation UNIT_PLANTED column before summing AMOUNT_PLANTED values in order to prevent summing across different units.
AMOUNT_PRODUCT_APPLIED Numeric amount of product applied, as reported in the original pesticide use report. Always check a description or abbreviation UNITS_PRODUCT_APPLIED column before summing AMOUNT_PRODUCT_APPLIED values in order to prevent summing across different units of volume or weight.
AMOUNT_AREA_TREATED The numerical value of the area of a field or site to which a pesticide was applied. If 100 percent of the field or site was treated, then AMOUNT_TREATED will be the same value as AMOUNT_PLANTED. If only a portion of a field was treated (for example spot treatments or alternate row treatments) then AMOUNT_TREATED will be less than AMOUNT_PLANTED. AMOUNT_TREATED should always be less than or equal to AMOUNT_PLANTED. May not be reported for NonAg (non-production-agricultural or non-agricultural) monthly summary pesticide use reports. Always check a description or abbreviation UNIT_TREATED column before summing AMOUNT_TREATED values in order to prevent summing across different units.
APPLICATION_MONTH_DESCRIPTION Month when the pesticide application was made. Formatted as text (e.g. JANUARY, DECEMBER).
APPLICATION_MONTH_ABBREVIATION Month when the pesticide application was made. Formatted as a number (e.g. 1, 2, 3...12) This column is best used to sort the data by application month.
CHEMICAL_CODE A unique number assigned to each chemical active ingredient in a pesticide product. The chemical_code is a proprietary code created by DPR. It is not necessarily analogous to the US EPA Shaughnessy number (now called PC code). (Chemical formulations of adjuvant products are confidential so adjuvant chemical codes, names, and amounts are not available)
CHEMICAL_NAME The common chemical name for each active ingredient, usually as listed on the product label. (Chemical formulations of adjuvant products are confidential so adjuvant chemical codes, names, and amounts are not available)
COMTRS An identification code for the approximately 1x1 square mile sections from the Public Land Survey System. COMTRS stands for County Code, Base Line & Meridian, Township, Range, and Section. Only Ag (production agricultural) use report records have a COMTRS value. Note that DPR does not receive exact addresses or locations of pesticide applications - COMTRS is the finest spatial resolution available for locating Ag pesticide use. NonAg (Non-production-agricultural and non-agricultural) pesticide use reports do not have a COMTRS value as they are only required to include the county where the applications took place. Only the county code will appear under COMTRS. The county is the finest spatial resolution for locating NonAg pesticide use.
COUNTY_CODE County code established by numbering an alphabetized list of California's 58 counties (01, 02, 03, … 58).
COUNTY_NAME Name of the county where the pesticide application was made.
DATE Calendar day, month, and year of the pesticide application. Note that NonAg pesticide use reports (non-production-agricultural and non-agricultural applications) are summaries of all applications of a single product over an entire month. They have a default date of the 1st or the 28th, which is not necessarily the actual date of an application. In contrast, the day listed in the date of Ag pesticide use reports (production agricultural applications) is the date a single application was completed.
GROWER_ID Number assigned to a grower or property operator by DPR based on information from the County Agricultural Commissioner (CAC). It is an expansion of the permit number or operator identification number assigned by the CAC. The number is composed of: (a) reporting county code: two digits representing the county where the pesticide application occurred; (b) permit year: the last two digits of the year when the permit was issued or expires, depending on how the county chooses report in this data field. See column PERMIT_YEAR. (c) permitting county code: two digits representing the county that originally issued the permit. See column PERMITTING_COUNTY_NAME (d) permit number: an arbitrary five-digit number assigned to the permit by the CAC. See column PERMIT_NUMBER. The last seven digits of the grower_id are unaffected by changing permit year values and may therefore be more useful than the full Grower ID for tracking pesticide use reports of an individual across years. DPR does not collect names and addresses of growers or permittees; that information is only available from the County Agricultural Commissioner. The GROWER_ID + SITE_LOCATION_ID may identify unique agricultural parcels or fields.
LICENSE_NUMBER PCO (pest control operator) license number. (Required for NonAg pesticide use reports with record identification code “C”)
OUTLIER A "Yes" in this column indicates that the pesticide use reported in the record has been identified as a statistically high outlier compared to other similar applications.
PERMIT_NUMBER An arbitrary five-digit number assigned to the restricted materials permit by the CAC.
PERMIT_YEAR Either the calendar year when the restricted materials permit or operator id was issued, or the year the permit expires. Contact counties to see how each defines this value.
PERMITTING_COUNTY_NAME County name of the county that originally issued the restricted materials permit.
POUNDS_CHEMICAL_APPLIED Pounds of chemical active ingredient applied. This value is calculated using the pounds of product applied and the percentage of chemical active ingredient in the product. (Chemical formulations of adjuvant products are confidential so adjuvant chemical codes, names, and amounts are not available)
POUNDS_PRODUCT_APPLIED The POUNDS_PRODUCT_APPLIED values are the reported product amounts converted into a single unit (pounds) for ease of calculation. Pounds are computed based on the product's formulation (liquid or dry), specific gravity (if applicable), unit of measure (UNITS_PRODUCT_APPLIED), and reported product amount (AMOUNT_PRODUCT_APPLIED).
PRODUCT_CHEMICAL_PERCENT The percentage of active ingredient found in the product as shown on the product label. (Chemical formulations of adjuvant products are confidential so adjuvant chemical codes, names, and amounts are not available)
PRODUCT_NAME The name of the pesticide product as shown on the label. The name on the label may be modified by DPR Registration Branch to ensure uniqueness.
PRODUCT_NUMBER The DPR product number is a numeric code assigned sequentially to products when registered. It has a one-to-one relationship with its California Registration Number.
AERIAL_GROUND_INDICATOR Also known as the Air/Ground Application Flag, or Method of Application. Code (A or G) indicates whether the product was applied by air or ground equipment.
REGISTRATION_NUMBER Each pesticide product is identified by a four-part California Registration Number. The fields making up this number are the manufacturer’s firm number, the label sequence number, the revision number, and the registrant’s firm number. Registration numbers on product labels may only have the manufacturer’s firm number and the label sequence number, both of which are assigned at the federal level by the US EPA. California may append a revision number to identify any modifications to product labels throughout the span of the product’s registration, and a registrant number in order to identify the firm actually registering the product in California.
SITE_CODE Site code from a list established by US EPA and modified for use by DPR. Indicates the target crop or site to which a pesticide was applied. Also known as commodity code or crop code.
SITE_LOCATION_ID A code assigned by the County Agricultural Commissioner (CAC) on the use permit that indicates a particular location (field) where an application may occur. It was designed to uniquely identify geographic field locations, but is currently assigned at the discretion of individual CACs and growers. The GROWER_ID + SITE_LOCATION_ID may identify unique agricultural parcels or fields.
SITE_NAME Identifies the site or commodity where a pesticide product was applied (i.e. strawberries, tomatoes, landscape maintenance, etc.).
UNIT_PLANTED_ABBREVIATION Abbreviated unit of measure of the amount planted. This column (or the unit planted description column) should be selected with the AMOUNT_AREA_PLANTED column to show the unit planted. Units include: A (acres), S (square feet), C (cubic feet), K (thousand cubic feet) and U (miscellaneous: such as bins, tree holes, bunches, etc.).
UNIT_PLANTED_DESCRIPTION Descriptive unit of measure of the amount planted. This column (or the unit planted abbreviation column) should be selected with the AMOUNT_AREA_PLANTED column to show the unit planted. Units include acres, square feet, cubic feet, thousand cubic feet and miscellaneous: such as bins, tree holes, bunches, etc.
UNIT_TREATED_ABBREVIATION Abbreviated unit of measure of the amount treated. This column (or the unit treated description column) should be selected with the AMOUNT_AREA_TREATED column to show the unit treated. Units include: A (acres), S (square feet), C (cubic feet), K (thousand cubic feet), P (pounds), T (tons), and U (miscellaneous: such as bins, tree holes, bunches, etc.).
UNIT_TREATED_DESCRIPTION Descriptive unit of measure of the amount treated. This column (or the unit treated abbreviation column) should be selected with the AMOUNT_AREA_TREATED column to show the unit treated. Units include acres, square feet, cubic feet, thousand cubic feet , pounds, tons, and miscellaneous: such as bins, tree holes, bunches, etc.
UNIT_PRODUCT_APPLIED_ABBREVIATION Abbreviated unit of measure of amount product applied. This column (or the UNIT_PRODUCT_APPLIED_DESCRIPTION column) should be selected with the AMOUNT_PRODUCT_APPLIED column to show the unit of measure. Units include OZ (ounces), LB (pounds), PT (pints), QT (quarts), GA (gallons), ML (milliliters), LI (liters), GR (grams), or KG (kilograms)
UNIT_PRODUCT_APPLIED_DESCRIPTION Descriptive unit of measure of amount product applied. This column (or the UNIT_PRODUCT_APPLIED_ABBREVIATION column) should be selected with the AMOUNT_PRODUCT_APPLIED column to show the unit of measure. Units include ounces, pounds, pints, quarts, gallons, milliliters, liters, grams, or kilograms)
USE_NUMBER System assigned sequential number to uniquely identify a pesticide use record within a year. The year and the use_no can be used together to identify individual pesticide use reports.
PERMIT_NUMBER An arbitrary five-digit number assigned to the restricted materials permit.
YEAR Calendar year when the pesticide application was made.

Summarize 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.

Summable columns include:

  • POUNDS_CHEMICAL_APPLIED
  • POUNDS_PRODUCT_APPLIED
  • AMOUNT_PRODUCT_APPLIED
  • 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
If you would like the columns to be in a certain order, you can use the Sort-By Columns box 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 the Sort-By Columns box is empty, columns will be sorted in the order of fields listed in the Available Data Columns box.

Click on the ’Reset Page’ button to reset the page to default selections again.

Output Format

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.





Version 2020.01 (2018 PUR Data Update)