This index page is arranged in sections: Permanent and Transitory items.
- Permanent Items
- Pesticide Statistics, Trends, Miscellaneous
- PPIS At Your Desk. Access Ready-to-Use
- Access 2002 and PPIS. Tutorials Ready-to-Run/Use
Look for the
and
flags to find recent updates or additions.
Permanent Items EPA-OPP. Pesticides Home Page
EPA's new format, as of 2003. For a detailed list of links go to the A-Z Index page.Regulatory, Registration, and Industry News
Here is a list, with links, to useful Web sitesLabel Review Manual,3rd Edition. And Q&A About Labels
EPA's instructions to its reviewers of pesticide labels. 19 Chapters. View/Download as HTML (chapter-by-chapter) or PDF (entire manual).
In addition, link to, among others, Questions to EPA-OPP and the Agency's responses.Confidential Statement of Formula (CSF): Preparation Hints
EPA help site about Biochemicals, but many hints for avoiding problems are applicable to all pesticide products.Electronic Submission of Labels and Studies for Pesticide Registation
How-to, hints, formatting, etc., etc. Updated by EPA June 2008. Now includes forms, instructions on converting other formats to PDF, etc.
Just in case. Australia's APVMA documents for electronic submissions.Pesticide Models
EPA site with links to individual sites for models.EPA/USDA/FDA Test Methods And Related
- Index to EPA Test Methods . If EPA has a method it is supposed to be referenced here.
- Pesticide Analytical Manuals vol. I, II. Plus: Metals, Chemical Contaminants, and Natural Toxins.
- PAM Technical References; Pesticide Residue Reports. Same site as above.
- Index of Residue Analytical Methods. Methods (760+) by chemical, commodity, method source, method ID, method date, instrument, and LOQ (ppm). Methods are published as TIF/TIFF (text image file format), same as labels in PPLS.
- Environmental Test Methods and Guidelines. General, Air, Pesticides and Toxic Substances, Solid Waste, and Water.
- Index of Environmental
Chemistry Methods/Pesticide Analytical Methods and Procedures. Now a general
site, with links to pages for specific areas.
Also see separate site for only Environmental Chemistry Methods. Index to ECM. - BenchMark Dose Software. Many links to Environmental Information Management System (EIMS) pages.
- Analytical Methods for Drinking Water
- Antimicrobial Testing Methods and Procedures (also a variety of SOPs used by EPA and applicable to all types of labs)
- Antimicrobial/Disinfectant Science Policies. From EPA's Antimicrobial Division. "How to" documents. Other useful links.
- FDA Pestrak. Pestdata. Chemical compound information; behavior in analytical methods; more. Stuff of interest to FDA in re use on foods.
- Exposure Assessment Models. One page with links and descriptions for each model.
- Surface and ground water pesticide concentration, simulation models. PRZM, EXAMS, etc.
- AQUATOX 1.1. Aquatic ecosystem process model
- Persistent, Bioaccumulative Toxic Substances. Entry to EPA's PBT Profiler methodology.
- Acute Oral Toxicity Up-And-Down Procedure. Documentation and computer program files.
- Dietary Exposure Potential Model. A huge, downloadable database program. Read EPA's introduction to see what all the program can do.
- Pesticide Fate Database. Active ingredients and degradates with summaries of environmental fate studies. Has link to Alan Wood's site for ISO naming information, structural formula, etc.
- EPA Exposure Assessment Modeling. Extrapolate(?) from some known factors to potential/probable outcomes.
EPA Dockets
Information about regulatory actions.- E-DOCKETS. EPA regulatory actions which are in progress and about which comments can be submitted to EPA.
- Major program dockets . Links to sites for information about regulatory and non-regulatory Agency activities.
- OPP Regulatory docket. Organophosphates plus Special Review and Special Docket monthly entries. Haphazardly updated but worth an occasional look.
EPA's Risk Assessment Portal
Agency site with collection of Guidance documents, models, etc.EPA-OECD Harmonized Test Guidelines
Link to the index page for access to all OPPTS Guidelines. Links to various OPPTS sites.EPA's GLP and SOP Guidelines
- GLP advisories 1-77 are titled and indexed by the University of Georgia
- EPA Quality System. Information and instructions for its environmental data collectors.
- Antimicrobial Testing Methods and Procedures (also a variety of SOPs used by EPA and applicable to all types of labs)
EPA Compliance And Enforcement
Starting point for actions and documents.Child-Resistant Packaging For Pesticides
EPA-OPP Web site which has all the Who, What, When, Where, and Why.Plant Incorporated Protectants: Current EUPs
U.S. EPA's consolidated list of currently active PIP EUPs.CDPR. Toxicology Review Summaries On-Line
California provides a succinct summary of tox studies for pesticidal active ingredients. Saves rummaging Federal Register pesticide petition notices, etc. Updated on a regular basis.EPA Guidance/Interpretive Documents
Select by any of several criteria (e.g., OPPTS) and get back a list of non-binding guidance documents issued by EPA since Jan. 1, 1999. Check it outPesticide Product Labels And MSDSs
2 sites with a variety.
Labels: http://www.greenbook.net
MSDSs: http://ilpi.com/msds/index.htmlEPA's Pesticide Label Site
Eventually every label for every product ever registered and every significant label change will appear on the EPA site. Be certain to read about limitations of the collection.State Registrations
NPIRS (National Pesticide Information Retrieval System) at Purdue University has a free-of-charge site which offers searching for pesticide products registered by individual States. Very useful.ISO Approved Common Names
Alan Wood publishes an invaluable site, "Compendium of Pesticide Common Names". Much more than just names. Updated often, and you can receive e-mail notices. Make use of. Go to: Compendium.
ISO has published a revised version, ISO 257:2004, of its rules and procedures for "Pesticides and other agrochemicals - Principles for the selection of common names"
List Of Common Names
January 2010. Alan's site has 1550 entries. Here is an Excel file of the Common Names. cpcnname.xls. {Note: Characters inside < > are HTML codes. E.g. i means make Italicized.}
Alan's site also separately lists esters and salts, with name of the parent. Excel file, derivs.xls.Active Ingredients: ISO Common Name and Chemical Class
Note: Not all common names are ISO Approved, and not every chemical is an Active Ingredient. Below is my best effort at extracting information from Alan Wood's "Compendium of Pesticide Common Names" web site. Any errors are mine.
1900+ row Excel file, cpcnsumm.xls, has: Name, CAS Registry Number (if available), activity/use type, chemical classification, and EPA-OPP PC Code number where I can do matching...(28 April 2009)Crop And Non-Crop Chemical Companies On The WWW
Links to (some) pesticide product company sites.International Sites On The WWW
A selected, but I trust useful, list of sites for information on pesticides and agriculture outside the United States. Updated and revised irregularly, so you'll just have to look.International Maximum Residue Limits
Link to USDA's Foreign Agricultural Service (FAS) site with a searchable database of MRLs. Also check out the FAS Home Page for potentially other interesting stuff.Registration/Regulatory Affairs Consultants
Information, supplied by the principals, about individuals and companies conducting registration and regulatory affairs consulting services on a contract basis.Pesticide Formulation Devlopment Labs & Consultants
Information about individuals and facilities offering their services for development and/or evaluation of pesticide product formulations (added: Focus Formulation and Consulting).Pesticide Process Chemistry/Engineering. Consultants
Need help with pesticide AI production, or related? Here are consultants I've found. Know of others(?), send them my way for a free listing.Pesticide Chemical Usage and Crop Statistics
Links to federal and state sites containing reports about amounts of pesticides used in the United States, and about other crop statistics.Pesticide Contract Formulators/Packagers On The WWW
Companies I've found with Internet sites.Federally Registered Pesticides. PAN Database
PANNA (Pesticide Action Network North America) offers an excellent on-line database for identifying products using multiple criteria. In addition PANNA provides toxicology and environmental information for active ingredients.Anti-Pesticide Action Groups
Every company involved with pesticide products should be aware of what is being said and done outside the industry. Plus, they often have the first scoop on what's new in the industry. Here are several source links.Resistance Action Committees
RACs do more than track developing resistance to insecticides, herbicides, and fungicides. One of their services is classification of pesticidal actives by chemical type and mode of action. {In the event you're worried: RACs are sponsored and promoted by major pesticide registrants.}Pesticide Product Inert Ingredients
NCAP (Northwest Coalitionfor Alternatives to Pesticides) site. Inerts in products, obtained via FOIA requests. Arranged by product active ingredient.
Pesticide Statistics, Trends, Miscellaneous Insecticide Labels: Count RegNr For Registrant And Site
PPIS web files of 6 July.
Insecticide/Invertebraticide Labels. Zip file, iallsite.zip, when extracted returns the delimited text file (column names in header row) iallsite.txt.
Columns are: Count of Registrations, EPA-OPP Complete Site Name, Registrant Name, Registrant Company Number, EPA-OPP/NPIRS Site Code.
For any Site(s) or Registrant(s) extract (in a spreadsheet or database) ...(July 30)Fungicide Label Sites: 2 Ways
PPIS files of 6 July. Item below has gruesome details about Fungicide Pests. Here, for Sites, simplication (for my sanity if not your edification).
Note: I'm using EPA-OPP's Site SubCatrgories. Way fewer than Complete Sites but with enough detail, I believe, to be useful.
The Industry. Excel file, f_site_1.xls, has Count of All Registrations, Count of All Registrants for each Fungicide Site SubCategory.
Most Sites. Excel file, f_site_2.xls, has for each Site SubCategory a Registrant with most Labels. Note: In case of ties I list only 1 Registrant...(July 28)Fungicide Pests/Labels/Companies: 4 Ways to Rank
PPIS files of 6 July (other Pests, Sites: Eventually).
The Industry. Excel file, f_pest_1.xls, has: for each Fungus: Total All Labels, Total All Registrants, Rank by Number of Labels, Rank by Number of Registrants.
Labels To Be Top 5 For a Fungus. Excel file, f_pest_2.xls, has How Many Labels by a Registrant to be in Top 5 for the Fungus.
Most Labels for Pest. Excel file, f_pest_3.xls, has Fungus, Registrant with most labels. Note: In case of a tie I've listed only 1 Registrant.
Most Pests In Top 5. Excel file, f_pest_4.xls, has for each Registrant How Many Fungus does it have where Registrant ranks among Top 5 Registrants. To see Big Rank 1, scroll to Syngenta...(July 28)RIGHTS-OF-WAY: Herbicide Competitors?
I don't know who directly competes with whom. I can, however, ask about likely places for competition. Registrants below can be compared for Labels about Golf Course and Grain Crops, as examples.
RIGHTS-OF-WAY. 4 of as Site SubCategory: HIGHWAY, RAILROAD, UTILITY, UNSPECIFIED, where Label Pest is a Weed (mostly).
149 row Excel file, row_herb.xls, has How Many Regs for Each R-O-W for each Registrant...(July 27)DuPont's Indoxacarb: 1 Excel File
Excel file, indox.xls, is an Example ex PPIS web-posted files. Find What. DuPont's Indoxacarb insecticide.
Excel file has: EPA Reg. No., Label Sites, Label Pests, Product Name, Formulation Type, Year Approved...(July 26)PPIS Web Files: Find With One (1) Known Fact?
EPA-OPP's 18 PPIS web-posted files might seem daunting. But really simple AND ORGANIZED.
32 row Excel file, ppisfind.xls, has Names of Major Items in PPIS files.
Want... Choose an item. E.g., an EPA Reg. No., or a Company Number or Name, a Site, a Pest. FIND? EVERYTHING about that item.
all you NEED is type 1 Name or Number for 1 Item. EVERYTHING is then FINDABLE, thanks to EPA-OPP's excellently formatted PPIS files.
FYI. My 9 year old Dell laptop (running way old Access version 2 database) with a whopping 512MB of RAM, and a 35GB hard drive, just took less than 2 seconds to return the Table: Count of EPA Reg. No. for each Registrant Name, Registrant Company Number...(July 26)Fungicides: Registrants, Labels, Pests, Industry Ranks
4508 row Excel file, fungrank.xls, has: How Many Labels by Registrant (Name, CoNr), for Fungicide Pest (Name and EPA-OPP Code), Rank of Pest by All Registrations, Rank of Pest by All Registrants...(July 23)Combinations Y2010: 1st AI Use By Registrant
PPIS. 6 July. Combination products registered in Y2010, and Combo has 2 or 3 or 4 Actives Ingredients.
1st Use of AI by Registrant. Who has registered a Combination in Y2010 where one or more the AIs has NOT previously been used by the Registrant in ANY Combination.
Sort 1. 82 row file, comb1sta.xls, has Registrant, Name of 1st used AI in any Combination, All AIs in the Combination.
Sort 2. 47 row file, comb1stb.xls, has Registrant, Names of 1st used AI in separate columns (if more than 1 AI), All AIs.
Other sorts obviously possible, perhaps even more useful.
Example. Loveland does Bifenthrin 1st ever in Bifenthrin / Imidacloprid. Loveland has done other Combinations with Imidacloprid...(July 22)Registrants, AIs: TGAI, MUP, End-Use. July 2010
PPIS. 6 July. Each Excel file below has: Number of Registrations, AI Name and Code, Registrant Name and Code.
eu_0710.xls. End-Use (PPIS Form Code >2)
mup_0710.xls. MUP (PPIS Form Code 2)
tgai0710.xls. TGAI (PPIS Form Code 1)
unkn0710.xls. No PPIS Form Code, yet...(July 21)
PPIS. Your Desktop. Access Ready-to-Use
Note: This ready-to-use Access database will not be updated. Intended solely as a What and How-To example.
This version. (1) Access 2002, which ought work with newer versions.
0. Downloading and Importing PPIS Data files:
i. Download the Zipped database and data files. UnZip/Extract. {New files posted each month at http://www.epa.gov/opppmsd1/PPISdata/index.html and also read the explanatory text files for file structure, field names, what's in the file.}
ii. Open the database, then do File | Get External Data | Import
iii. Go find the data text file (*.txt). Double-click its name
iv. Import Wizard window. If the "Fixed-width" button is not selected click on it
v. Click the "Advanced" bar. Click the "Specs" bar
vi. Double-click the "ImportSpecification..." name which matches the text file name, or highlight the name and click the "Open" bar
Click the "OK" bar
Click the "Next" bar until Access asks where to put the data. Select "In an existing table" and browse to find and double-click the desired table name
"Next" and "Finish". Access should report successful Import.1. Import the PPIS product.txt file (basic information), Run a few Queries, Find All currently Active Registrations.
This Zip file, ppisimp1.zip, extracts to ppisimp1.mdb. This Zip file, product.zip, extracts to the PPIS data Fixed-width file product.txt.
ppisimp1.mdb is all set up to Get the 90,451 entries for all 90,451 products in product.txt. Everything, nominally, ever registered with EPA-OPP. How to Get after Opening/Starting Access 2002 (if your newer version looks different give a shout and perhaps I can help)? Ready-to-Run queries will fill a Table with January's 17,096 active registrations.
Importing Data Text File: Go to the top of this section and follow the instructions. If any problem send me a message.
Time to Run Queries. They're all written ready-to-go. Look at them, and/or Tables in Design view if interested. Double-click a Query name to Run/execute the query. First one extracts CO_NR and PROD_NR from REG_NR, adding them to the named fields in the table. Second Query combines CO_NR and PROD_NR and puts that into the EPA REG NR field. The third Query Finds Active Registrations and puts them into the Active Registrations table. The fourth Query Finds TGAI registrations. You can change this Temporary Results Query to a Make Table, permanent, one.2. Import the PPIS company.txt (registrant/subregistrant information) file. Run Queries. Count Products By Registrant Name
Zip file ppisimp2.zip extracts to ppisimp2.mdb. Zip file company.zip extracts to company.txt.
Access database has the previous data Tables and Queries and Import Specifications. Plus one new table for (Sub)Registrant identification and address information, with a ready-to-use Import Specification. Plus two new Queries: Count active products (as EPA Reg Nr) for each of the 1693 Registrant Names and Company Numbers; combine City State Zip Code information in one field as for mailing and/or report writing. Important! To use the Counting Query you must Import the product.txt file (see 1. above) and run the Queries to Find Active Registrations.
Note: Company file has the field CO_NAME2 which is invariably empty (hold over from pre-2004 versions of PPIS).3. Copy tbl_Product, with data, to another database.
i. You imported product.txt into tbl_Product in ppisimp1.mdb. You want to try importing company.txt into ppisimp2.mdb, but hate redoing the import of product.txt.
ii. No problem. (a)Open ppisimp2.mdb. (b)Do "File | Get External Data | Import". (c) The default choice is an Access database. Go find where you've stored ppisimp1.mdb and double-click its name. (d) Access shows you everything in the database and gives you options. (e) Highlight the tbl_Product name and click the Options bar. You ought see under Import Tables that the "Definition and Data" button is selected. (f) Click on "OK". You will be back to the ppisimp2.mdb screen and will see tbl_Product (the original table) and tbl_Product1. Look in tbl_Product1 to be assured it contains all 90,000+ products information. (g) Delete tbl_Product (the original, empty table). Highlight then Rename tbl_PRODUCT1 to tbl_PRODUCT (Edit | Rename). The now renamed tbl_Product1 has become a PERMANENT part of ppisimp2.mdb.
{FYI: The "File | Get External Data | Link..." choice is how you can TEMPORARILY attach a piece (e.g., a table) of one database to another database.}4. Import All 18 PPIS Data Text Files
Zip file, ppisimp3.zip, extracts to ppisimp3.mdb. This Access 2002 database is set up with Tables and Specs (Import Specifications) for each of the 18 data files (after extract *.txt from *.zip) posted each month on EPA-OPP's PPIS Web site. You need know nothing other than as described above "How to Import". Import as many or as few as might be of interest.
Note #1: EPA-OPP says REG_NR are "Numeric file type". My database is set up (Tables and Specs) to import REG_NR as "Text file type". For now, but you could ask for details, just accept and use what I've done.
Note #2: I've named Table and Import Specifications (Specs) just as are in EPA-OPP's PPIS Web site explanatory notes. The Access database I use for PPIS has entirely different names because I find them easier to remember.
Note #3: Should you import the agent.txt file. Table is exactly the same as for company.txt, so tell Access to use the "COMPANY IMPORT SPECIFICATION" for stuffing text file into tbl_AGENT.
Note #4: formula.txt is where you find Percentage of each AI in each product. EPA-OPP's text file has percentage as a 4-decimal place, 7 digit number (e.g., 0441500). To convert this to a number with decimal point (e.g., 44.15) just divide by 10000 (using of course the Access Build function). ?? Ask and ye shall receive instruction/example.
Note #5: You've imported some *.txt files. You want to ask for example "What are the SITES and/or PESTS for EPA Reg NR 279-3133". tbl_PRODSITE and tbl_PRODPEST come up with: REG_NR and SITE_CODE or PEST_CODE. Say what? Access is a RELATIONAL DATABASE program (nominally). About one-half of the PPIS files are DICTIONARIES/CONVERTERS. Don't ask why (there are excellent reasons). The DICTIONARIES/CONVERTERS translate CODE to a NAME. A simple drag-and-drop Query.
Note #6: Did I mistype something when doing all the Table and Import Specification Designs? Do you have a question? Just ask.5. Using Access: Nicosulfuron and zeta-Cypermethrin
Zip file, cypznico.zip, extracts to the 890KB Access 2002 database file,cypznico.mdb. Only the 2 Actives, to keep the file small but the examples apply to everything in PPIS. How To Find Out About Specific Products. In this tutorial you can see how to find out about Nicosulfuron (do zeta- Cypermethrin on your own).
The database is populated with Data Tables and ready-to-run Queries. Here are the Tables and Queries: cypznico0.pdf shows the Data Tables; cypznico1.pdf shows the Queries.. Table Design are those I use in my Access version 2 for PPIS. The Queries begin by selecting Nicosulfuron products, continuing on to ask questions about Registrants, Sites, Pests, Percentage AI(s), etc.
Note #1: You ought look at each Query in Design View. You should Run each Query (double-click on Query name or in Design View click on the Run, !, icon) as several require a Table Made from a previous Query.
Note #2: Data is as appears in EPA-OPP's March 2009 web-posted files. Caveat Lector!!
Note #3: An Access 2002 "enhancement" (hah). Design for the Query which finds End-Use products. Criterion for FORM (Formulation Type Code) I typed as: not 1 and not 2. In Saving the Make Table Query Access converted "not" to the Formal Logic symbol "< >", i.e., Not Equal To. This, I believe, merely makes the Query look more confusing to the new or occasional user of Access.
Note #4: Two of the Tables (AI Common Name and All AIs) are my doing. AI Common Name I use to convert PC Code Number to my preferred name. All AIs (on one line) is from another of my Access databases (simple, quick 4 Queries) using PPIS files.
For further information, or to discuss a specific project, contact Bruce McKay:
e-mail your request to bmckay@ix.netcom.com (that's bmckay@ix.netcom.com).All original materials are copyright © 1996 - 2008 by Bruce M. McKay, and all rights are reserved.
The URL for this page is http://www.bmckay.com