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)

PUR Database Column Definitions

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.

COLUMN
DESCRIPTION
YEAR Calendar year when the pesticide application was made.
APPLICATION_MONTH Month when the pesticide application was made. Formatted as text (e.g. JANUARY, DECEMBER).
MONTH_IN_YEAR 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.
DATE Calendar date of the pesticide application.
COUNTY_NAME Name of the county where the pesticide application was made; UNKNOWN is used for missing values or reporting errors.
COMTRS County, meridian, township, range, section of the Public Lands Survey mapping system. Production agriculture use report records have a COMTRS value; Non-agricultural pesticide use reports do not have this data because they are reported on a county basis. This column can be chosen to show application information on the finest spatial scale.
SITE_NAME Identifies the site or commodity where a pesticide product was applied (i.e. strawberries, tomatoes, landscape maintenance, etc.).
CHEMICAL_NAME The preferred common chemical name. Usually the name is assigned by the USEPA, or another accepted name is used.
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.
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.
REGISTRATION_NUMBER Use this column to correlate data with DPR’s label database or USEPA’s product registration information. Each pesticide product is identified by a four-part California Registration Number. The fields making up this number are:
MFG_FIRMNO ( Manufacturer_firmno) , LABEL_SEQ_NO (label_sequence_number ), REVISION_NO (revision_number), and REG_FIRMNO (registration_firm_number). The product registration number usually does not appear on the product label in this format; it may appear only as the first two of the four parts. The first two (MFG_FIRMNO, LABEL_SEQ_NO) are usually assigned by the US EPA. These fields represent the US EPA number for the company (MFG_FIRMNO) and a product sequence within the company (LABEL_SEQ_NO). California appends a revision code (REVISION_NO) to the EPA code to identify modifications to product labels throughout the span of the product’s registration. An additional field (REG_FIRMNO) is used to identify the firm actually registering the product in California.
PRODUCT_NUMBER System assigned product number, used internally in the database and by DPR staff. The number is sequentially assigned during new product registration. The product_number has a one-to-one relationship to the four-part key composed of: Manufacturer_firmno + label_sequence_number + revision_number + registration_firm_number (AKA California Registration Number) as reported.
POUNDS_PRODUCT_APPLIED Pounds of product applied. See Known Issues.
PRODUCT_CHEMICAL_PERCENT   The percentage of active ingredient found in the product as shown on the product label.
AMOUNT_PRODUCT_APPLIED Numeric value of the amount product applied (e.g. 5) If this column is selected you should also select the unit_product_applied column to get the appropriate units. Note, this value has not been standardized or converted to pounds of product applied. See Known Issues.
UNITS_PRODUCT_APPLIED Descriptive unit of measure of amount product applied. (e.g. ounces) This column should be selected with the amount_product_applied column to show the unit of measure.
UNIT_PRODUCT_APPLIED Abbreviated / coded unit of measure of amount product applied. (e.g. OZ, GA) This column may be selected instead of the units_product_applied column if you are familiar with DPR's abbreviations.
AMOUNT_PLANTED Numeric value of the amount of commodity planted (e.g. 100). If this column is selected, you should also select the unit_planted column to get the appropriate units.
UNIT_PLANTED_DESCRIPTION Descriptive unit of measure of the amount planted (e.g. acres, square feet, etc.) This column should be selected with the amount_planted column to show the unit of measure.
UNIT_PLANTED Abbreviated / coded unit of measure of the amount planted (e.g. A, S, etc.) This column may be selected instead of the unit_planted_description column if you are familiar with DPR's abbreviations.
AMOUNT_TREATED Numeric value of the amount treated (e.g. 50). If this column is selected, you should also select the unit_treated column to get the appropriate units.
UNIT_TREATED_DESCRIPTION Descriptive unit of measure of the amount treated (e.g. acres, tons, cubic feet, etc). This column should be selected with the amount_treated to show the unit of measure.
UNIT_TREATED Abbreviated / coded unit of measure of the amount treated (e.g. A, T, C, etc) This column may be selected instead of the unit_treated_description column if you are familiar with DPR's abbreviations.
OUTLIER Flag = YES if the record has been identified as a statistical outlier. Methods for identifying statistical outliers (PDF, 12 kb)
AERIAL_GROUND_DESCRIPTION Also known as the Air/Ground Application Flag, or Method of Application. Description (AERIAL, GROUND) indicates whether the product was applied by air or ground equipment.
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.
AG_NONAG Production agricultural / Non-agricultural use description. Production agricultural (ag.) reports include applications of pesticides to growing crops, agricultural fields, and most applications to forest trees and ornamental turf. These reports include the application date and location to the section (MTRS). Non-agricultural (non-ag) reports include applications or pesticides to post-harvest commodity treatments, rights of ways, landscapes, structural use, and other non-agricultural uses by commercial applicators. These reports include an application month and application county. There is no application date or section (MTRS) for non-ag data.
USE_NUMBER Sequential number to uniquely identify a pesticide product use record within a year. Use this number to identify all records associated with a single application of a product.
QUALIFY_CODE The qualifier code modifies or limits the meaning of the site code upon which the product was used. Example: a qualify_code of <04> indicates "grown for seed". Some counties use this code to keep more detailed records of crop types or varieties, but it is not a required field on the pesticide use report.
COUNTY_CODE Numeric code for alphabetized list of counties (e.g. 01, 02, 03...56); includes codes for unknown or error values.
SITE_CODE Site code from a list established by USEPA and modified for use by DPR. Indicates the target site to which a pesticide was applied. Also known as Commodity Code, crop code, use code. This code does not refer to the spatial location of a pesticide application (e.g. a field). The Site Code is shortened, meaning less than the USEPA code. Sometimes the Site Code is a specific pest or type of use if a "special" registration is involved.
CHEMICAL_CODE A unique number assigned to each chemical in the DPR Chemical dictionary. Chemicals do NOT have to be active ingredients in products, they may be inerts, degradation products, or others as requested by any branch in the department. The chemical_code is a proprietary code created by DPR. It is not necessarily analogous to the USEPA Shaughnessy number (now called PC code.)
   
RECORD_ID Identifies the agency that input a use record, and whether the record is for an individual application or is summarized data. Input agencies are DPR, county agricultural commissioner’s (CAC) office, and Prison Industries Authority (PIA). The record_id is available in CalPIP for compatibility with previously requested data sets. Uncoded information about the use record can be found in the reporting_type column. The input agency data is not currently available through CalPIP.
   
GROWER_ID Number assigned to a grower or operator by the County Agricultural Commissioner. The value has significance to the restricted materials permit program, and 100% Use Reporting. Also known as the permit number, or operator identification number. The number is composed of: (a) reporting county_cd, 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; (c) permitting county_cd, two digits representing the county that originally issued the permit; and (d) permit number, an arbitrary five-digit number assigned to the permit. The last seven digits of the grower_id may be used to identify individual permittees. 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. The reporting county_cd (a) and the permit_year (b) are available as separate data columns, permitting_county_name and permit_year, respectively (see below).
   
LICENSE_NUMBER PCO (pest control operator) license number. (Required for type "C" records only...needed if GROWER_ID field is blank.)
   
PERMITTING_COUNTY_NAME County name of the county that originally issued the restricted materials permit.
   
PERMIT_YEAR Either the calendar year when the restricted materials permit or operator id was issued, or the year the permit expires. Inconsistently used among the counties.
   
PERMIT_NUMBER An arbitrary five-digit number assigned to the restricted materials permit.
   
PLANTING_SEQUENCE Number to indicate multiple plantings of the same crop or commodity at the same site location_id. Not uniformly used.
   
SITE_LOCATION_ID A code assigned by the County Agricultural Commissioner (CAC) on the use permit which 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.

Version 2017.04 {2015 PUR Data Update)