Search Help for the PICOL Label Database


General Information

The PICOL label database is a searchable Web-based database containing specific pesticide label information for all pesticide products registered in Oregon and Washington. For Washington this includes spray adjuvants and many pest control products that are exempt (25[b]s) from federal regulation but that are defined as pesticides within the state. SLNs (24[c]s) for both Oregon and Washington are also included in the PICOL label database; however, Section 18s, because of the short duration of these exemptions, are not in the database. Electronic copies of Section 18 labels and many SLNs can be found on the Pesticide Notification Network (PNN) Web page.


Both the PICOL label and tolerance databases are operated by Washington State University's Pest Management Resource Service. The operation of the databases is funded by four entities: Washington State Department of Agriculture (WSDA), Oregon Department of Agriculture (ODA), Washington State University (WSU), and Oregon State University (OSU).


No. The PICOL label and tolerance databases are free to the public.


Users may search the database by any of the criteria in the following list. The most common searches are by crop, pest, ingredient, or product name. Items with asterisks are those that have on-screen dictionary help available. (See additional information about the dictionaries below.)


Electronic labels - Electronic copies of labels are not included in the PICOL label database. Electronic copies of some pesticide labels are available on line at either Greenbook or CDMS.

In addition, many of the major pesticide manufacturers have label copies available on their individual Web sites. These copies should be used for information only; it is not legal in Washington State to use label copies from the Web for application purposes.

Section 18s - Information on Section 18 emergency and crisis exemptions is not entered in the PICOL label database. Washington Section 18 information, including electronic copies of Section 18 labels, can be found on the PNN Web page. Information on Oregon Section 18s is available via ODA's newsletter, Pesticide Quarterly.

Oregon adjuvants and exempt products - The PICOL label database contains no information on adjuvants or 25(b) federally exempt pesticides registered exclusively in Oregon.

Use Directions - Use directions, including use rates, maximum number of applications per season, Pre Harvest Intervals (PHIs), Re-Entry Intervals (REIs), precautions, and restrictions, are not included in the label database information.

Non-PNW Crop Information - The PICOL label database only includes information on crops grown in the PNW. Although a label registered in Washington may include directions for use on crops such as rice, peanuts, or tobacco, this information is not entered in the PICOL label database.

The PICOL dictionaries provide information on the terminology that is used in the database, and on how these terms are defined. Before beginning a search you should check the dictionaries to verify that you are using the correct terminology. One example is the ingredient glyphosate. There are many different formulations of glyphosate. The label might give the active ingredient as: Glyphosate; Glyphosate, Ammonium Salt; Glyphosate, Isopropylamine Salt; or Glyphosate, Sesquisodium Salt. In order to run a search and retrieve all of the glyphosate labels, you need to run an Advanced Search for Ingredient LIKE Glyphosate. Running the search Ingredient EQ Glyphosate will bring up only those labels that are coded simply Glyphosate.


In a typical year, most agricultural pesticides are entered into the PICOL database and are available for user viewing by June or July of the year in which the registrations become effective. Homeowner products and other non-agricultural pesticides (e.g., pool chemicals, disinfectants) are input into the database after the agricultural products are entered. All data entry is complete by the end of the calendar year. The database is being continually updated throughout the year. Because the PICOL label database is now Web-based, as changes are made to the data, they are immediately available to database users.


Manufacturers supply registration paperwork to the state departments of agriculture at the end of a calendar year for registrations effective the next year. ODA and WSDA process the registrations and label changes and then forward these materials to WSU. WSU processes first the registrations for products intended for use in agriculture, as these are the labels for which we receive the vast majority of inquiries. The next labels processed are pesticides for use by homeowners and the other items mentioned above. Throughout the year ODA and WSDA continue to receive and process revised labels. As these are processed they are forwarded to WSU, where they enter the data processing queue.


To keep the PICOL label database a reasonable size, only limited archival information is available. At the end of each registration cycle, when WSU has complete the data entry for the year, unregistered labels are deleted from the database. For example, in 2002, the oldest labels in the database are those last registered in 1999.


Yes. The label database contains information on those products where a pesticidal claim is made on the label. In most cases the data entry for these labels is somewhat abbreviated. Five primary crop/site codes are reserved for disinfectants; they are described within the crop dictionary.


The Simple Search uses pop-up menus, limiting the user’s choices. Further, the search operator is limited to either equals, EQ, or not equals, NE. (More information on the use of the NE operator is included below.) In other words, you may choose Crop EQ Apricot, but not Crop LIKE Apricot. The database defaults to the Simple Search mode. The Advanced Search has greater flexibility. The Advanced Search allows the database user to type in the search parameter and choose the LIKE operator in addition to the EQ and NE operators. LIKE is the default operator in Advanced Search.


How to Run a Search

First select the state or states that are the subject of your search and check Current Year or All Years to define which pool of label information the database will search. Note that the database defaults to Washington pesticide registration information and Current Year. Click on the arrow on the right side of the Item To Search On box. This box defaults to Crop. Select the parameter that you wish to search. The page default is set to equals, EQ. Click on the arrow in the Operator box if you wish to run a not equals, NE, search. Click on the arrow in the Common Name box and select the specific item that you wish to search on. Scroll down to the bottom of the screen and click on Submit Query. Note that if you select something like EPA Number or Product Name for the Item to Search On, where the database must build a list of essentially all of the labels in the database, there will be a delay while this information is compiled and the list loads. (See further explanation below.)


Most likely you have refined your query with a second parameter that has eliminated all the labels in the pool from your initial search. For example, if you run the following Simple Search, you will get the message "0 matching labels:"

This is because atrazine is an ingredient in herbicides and is not found in any fungicides.
(See the directions for refining a query below.) First check your query logic and then try the search again. If you continue to have problems, call us at 509-372-7492.


The database opens to the Simple Search screen. To switch to Advance Search, click on the Advanced Search button located to the right of the screen title. As with the Simple Search, first select either Oregon or Washington or both and then check Current Year or All Years to define which pool of label information the database will search. Click on the arrow in the left box and select the desired Item to Search On. The Operator will default to LIKE but you may also select either equals, EQ, or not equals, NE. The Advance Search screen also defaults to using the common name for the search parameter but if you would prefer to search using the PICOL codes, use the radio button to select Code Name. (See additional information below on using codes for searches.) Next type in your search parameter in the empty right box. Scroll down to the bottom of the screen and click on Submit Query.


The most likely reason is that you have spelled a crop, pest, or registrant name incorrectly, or that you are using a search term that PICOL does not recognize (e.g., Apples versus Apple). Check the dictionaries and try your search again. If you continue to have problems with your search, try using the Simple Search pop-up menus. If you continue to have problems, call us at 509-372-7492.


In the PICOL label database you can run an initial search on one criteria (Crop EQ Apple) and then using the refine query feature you can add one or more search criteria. For example in the query Crop EQ Apple, the database will first find all the labels that allow for use on apples. If you refine the query with AND Pest EQ Codling Moth, the database will search in the pool of apple labels and will pull up only those labels that list codling moth as a pest. Alternately, if you refine your query of Crop EQ Apple with OR Pest EQ Codling Moth, the database will go back out to the main pool of labels and will pull up any label that mentions codling moth, along with all the labels for apple use. In this way an OR search will always expand your pool of labels, while an AND search will narrow the pool. If you are going to be doing multiple query searches (say, for example, you wanted to find products that could be used on either apples or cherries that could be aerially applied), you should structure your searches with the OR searches first, followed by the AND searches. To find a list of products for use on either apples or cherries to control San Jose scale that could be aerially applied, set up the search as follows:


Yes. This is one of the strengths of the revised PICOL database. For example, if you are running a search looking for products containing glyphosate that can be used along fence lines you might set the search up as follows:


Once you have completed your search and are ready to view the results, scroll to the bottom of the search screen and click on the button marked Format Labels. Note that output results are always sorted by whatever information is contained in the first column of information. If the first field contains Product Name the output will be sorted alphabetically. If the first field contains EPA # (as might be the case if you are using the Tabular Output option) the results will be sorted numerically. You have 6 options for viewing the search result. Each is described below. Once you have selected the desired output type, simply click on the View Labels button at the bottom of the screen to view the results.


Yes. PICOL output can easily be copied, cut, and pasted into an Excel spreadsheet to make it easier to manipulate and print the data. The easiest way to copy all of the PICOL output is to use the Control A (“Select All”) keystroke to select everything on the screen and then use Control C to copy. Once in Excel use the Control V (“Paste”) keystroke to paste the data into the spreadsheet. You will need to delete some rows at both the top and bottom of the spreadsheet to get rid of the unnecessary text.


When you are running a search on registration year, either Oregon or Washington, the database will ignore the radio buttons for Year of Registration (Current Year, All Years) located at the top of the search page. Because the registration year field is a number and not text, the LIKE Operator doesn’t work the same as when searching for text. The LIKE Operator functions as the operator "greater than or equal to" (≥ ). Both the EQ Operator and the NE Operator function as you would expect.


Often it is easier to look up the 6-digit numeric code for an ingredient (using the ingredient dictionary) and use this rather than typing a long chemical name into the search box. For example, the code for Calcium Oxytetracycline is 006321. Using the 6-digit code for this chemical will both reduce keystrokes and reduce the likelihood of a typographical error that would cause the search to return no results.


The NE Operator is very useful if you are trying to exclude information from a search. For example, if you wanted to compile a list of all the pesticide labels that have glyphosate as the ingredient but you didn't want to include those that contain the ammonium salt formulation you would run the following Advanced Search:

The NE Operator is useful is if you are trying to compile a list of supplemental labels and SLNs currently registered in Washington. In this case, because the SLN field is used to house identification numbers for both SLNs and supplemental labels, this is a very easy search:

Yet another example of the usefulness of the NE operator involves the active ingredient chlorpyrifos. If you want to compile a list of all the products that are currently registered containing chlorpyrifos but you are not interested in flea and tick collars, run the following search:


Sometimes pesticide labels, particularly herbicide labels, will provide ingredient information two different ways on the label. Under the ingredient statement a liquid herbicide label may say that the product contains 41% Glyphosate, Isopropylamine Salt and in a statement below it will say that this product contains 4# (pounds) of glyphosate in the form of its isopropylamine salt per gallon. In this case the ingredient is coded as Glyphosate, Isopropylamine Salt and the concentration is entered as 4#. On a label with the same ingredient and concentration that does not have the pounds per gallon statement, the information would be input as 41% Glyphosate, Isopropylamine Salt. Finally (still using the same label example), if the label goes on to say that the product contains the equivalent of 3# per gallon of the acid, Glyphosate, the ingredient is coded as Glyphosate and the concentration is given as 3#.

Things to Know

There are a few things about the way that the database operates that you need to be aware of when running searches.

Application: If you are trying to find a list of products that allow for seed treatment of barley and you run the following search (using either simple or advanced):

You will get labels that allow for seed treatment on something and that also allow for use on barley. The labels returned by this search will not necessarily allow for the seed treatment of barley. For example, using this search you might find a label that allows for seed treatment of radish seed and for aerial application to barley. This is because the information on application method is linked to the label as a whole and not to an individual crop. To find labels allowing for seed treatment of barley you would need to run the above search and then review the individual labels (from an alternate source) to find labels that meet your needs.

Pest: The pest searches present a similar but less complex problem. All crop and pest information in the database is linked in pairs. The problem is that the search looks at the data entry as a whole and does not recognize the linked data in the search. Say, for example, that you wanted to see if there was a label for the control of asparagus aphid on tomatoes. You might run the following search:

The database will come up with a number of labels that provide direction for controlling asparagus aphid. On these labels, however, this aphid is listed as a pest of asparagus, not tomato. The labels were returned with this query because the labels do provide directions for use on tomatoes; however, the products are labeled for the control of OTHER tomato-specific pests. Unlike the barley seed treatment example above, the desired information is available within the database. In order to view the information on specific crop and pest combinations, run the desired search and then, under Format Labels, select the output type All. The individual lists of pests for each crop are provided. Note that it is legal in Washington and Oregon to use a pesticide for the control of a pest not listed on the label, as long as the label provides directions for use on the specific crop or site.

Add Date: Typically the add date is the date that a specific label was first entered into the PICOL label database. Many labels, however, carry an add date of 11/1/95. This is the date of a prior database conversion. Labels that were in the original label database at the time of this conversion (and were thus registered for use prior to 1995) all carry the add date 11/1/95.

Crop - LIKE Searches: Searching for Crop LIKE Apple will result in a list of labels for use on Crabapple, and Non-Bearing Crabapple, as well as Apple, Non-Bearing Apple, and Post-Harvest Apple. In the same way, in searching for Crop LIKE Pea, the database will pull up a list including products for use on Pear (pea-r) and Peach (pea-ch) as well as the more obvious "pea" crops.

Simple Search: The Simple Search is "pick list" (pop-up menu) driven. Every time you select a different Item to Search On, the database must compile the pick list for that item. The Product Name and EPA Number lists have approximately ten times the number of entries than the other lists. For example, as of September 2002, the crop pick list has 420 values, the pest list contains 1500, and the SLN list has 643 while the EPA Number list has 11,133 and the Product Name list has 16,577 entries. If you choose to run a Simple Search on Product Name or EPA Number, the database will have a long delay while it compiles the appropriate pick list. If you are interested in running a search on either of these items it will be faster to run an Advanced search using the LIKE operator. Type in part (or all) of the Product Name or EPA Number, then view the results to find the label that you need.

Search Results - Ingredient: When viewing your search results using the Standard Output option, the database will use one row on the resulting table for each product except that, when products contain more than one ingredient, then there will be one row for each ingredient. These entries will be obvious because the Product Name, EPA #, SLN, and Registrant will be identical, only the ingredient name and concentration will differ.


Because the new version of the PICOL label database is completely Web based, the search feature is much faster to use. Also, previously there was a week's delay between new information being entered into the database and that information being available to users. Now as soon as a change is made to the data that change is visible to database users.

The new version of the PICOL label database now provides two different types of searches (Simple or Advanced) and also allows users to run searches using a combination of the two. The Simple Search screens allow users to set up their searches using pop-up menus or pick lists for the most commonly used search criteria such as: crops, pests, ingredient, registrant name, EPA number, and product name. Use of the Simple Search screens should cut down on the common errors such as searching for Crop EQ Apples when the database uses the term Apple. Simple Searches are limited to the use of the operator equals, EQ, or not equals, NE. The Advanced Search screens default to the LIKE operator, but also allow for using the EQ and NE operators. The Advanced Search also allows users to search using codes in addition to common names. This feature was retained to accommodate experienced database users. PICOL codes can be found in the dictionaries.

The new version of the PICOL label database also allows users to switch back and forth between the Simple and Advanced Search screens and to use a combination of the two when running a multi-step search.


We value your input on the information contained in the label database. If you find an error we could appreciate hearing from you. Please direct feedback to Dr. Catherine Daniels at 509-372-7495.