CalPIP Navigation Menu

Data Sources
Selected Datasource
Pesticide Use Report
Search by Data Category
Other Criteria
California Pesticide Information Portal (CalPIP) Application

CalPIP Terms and Definitions

Help/User Guide Contents

Pesticide Use Report Data Fields

Active ingredient(s): The ingredient(s) of a pesticide that prevent, destroy, repel, or mitigate a pest. In the case of a plant growth regulator, an ingredient which, through physiological or biochemical action, accelerates or retards the growth rate of maturation or otherwise alters the behavior of plants. In the case of a desiccant, an ingredient which artificially accelerates the drying of plant tissue.

Aerial/ground indicator: Also known as the Air/Ground Application Flag, or Method of Application. Indicates whether a product was applied by 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.

CAS number: The number assigned by the Chemical Abstract Service (CAS) to identify specific chemical compounds. A chemical may have more than one CAS number. Not all chemicals have an assigned CAS number.

Commodity: Indicates the target site to which a pesticide was applied. "Commodity" and "site" are used synonymously.

Formulation type: a general description of the product’s physical properties. For example: granular, pressurized liquid, emulsifiable concentrate, etc.

Inert ingredient: Ingredient which does not have pesticidal activity in a pesticide product, but which is intentionally added as part of the formulated product. Examples include wetting and spreading agents, solvents, baits such as sugar, starches, dust carriers such as talc and clay, fillers, propellants in aerosol dispensers, and emulsifiers.

Institutional use: Pesticide applications in or around property that serves the general public or private organizations. This includes buildings such as hospitals, schools, libraries, sports facilities, and office complexes.

Label data: Information about a product’s name, registration number, active ingredients, formulation, application sites, etc.

Label database: The purpose of this database is to collect and make available information concerning the registration of pesticide products in California.

Outlier: A probable error in the data fields for acres treated and the pounds of pesticide used. To improve data quality, DPR developed a statistical method to detect probable errors in the database. Called the outlier program, this method calculates pesticide use rates (pounds of active ingredient applied divided by acres treated) that are then examined using a variety of statistical methods. The records with highly unlikely use rates (outliers) are identified, thereby serving to flag suspect pesticide use records.

Errors occur, for example, when those reporting pesticide use shift decimal points during data entry. We used three different criteria to identify outliers by comparing each use rate with an estimate of the maximum rate for that type of use.

Pesticide: A pesticide includes the following: A substance, or mixture of substances, intended to defoliate plants, regulate plant growth, or prevent, destroy, repel, or mitigate any insects, fungi, bacteria, weeds, rodents, predatory animal, or any other form of plant or animal life declared to be a pest detrimental to vegetation, man, animal, or households, or any environment.

Pesticide type: Indicates the general pesticide type of the product. e.g.. chemical, microbial, or both chemical and microbial

Pesticide use data: The information in the Pesticide Use Data section comes from the Use Report Transaction Record and various other data sets maintained by DPR. The use report transaction record contains information submitted by the grower or applicator about an instance of pesticide use. On an agricultural application, this includes what product was used, who used it, where the application was made, the commodity to which the application was made, when the application was made, and how much product was applied. When a use report transaction record is processed, information such as the chemical codes, chemical percent, and product information is retrieved from

Registration number: Each pesticide product is identified by a four-part California Registration Number. The fields making up this number are: manufacturer firm number (MFG_FIRMNO), label sequence number (LABEL_SEQ_NO), revision number (REVISION_NO), and registrant firm number (REG_FIRMNO). 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. When one company manufactures the product and another registers it as a subordinate seller, it is considered a ’sub-registration’’. Approximately 25% of the products registered in California are sub-registrations.

Residue database: The purpose of this database is to collect and make available information concerning the pesticide residue analysis from individual lots of domestic and imported produce.

Signal word: The signal word corresponds to: Danger (Poison), Danger (Only), Warning, Caution, None

Surface water database: The purpose of this database is to collect and make available information concerning the presence of pesticides in California surface waters. The database contains data from a wide variety of environmental monitoring studies, all designed to test for the presence or absence of pesticides in California surface waters.

Well inventory database: The purpose of this database is to collect and make available information concerning the presence of pesticides in California ground waters. The database contains data from a wide variety of monitoring studies.

Version 2020.01 (2018 PUR Data Update)