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:Harmonized Test Guidelines For Pesticide Studies
Link to the index page for access to all OPPTS Guidelines.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 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.Pesticide 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 EPA-OPP Pesticide Product Use Types: Regs/Registrant
EPA-OPP assigns from 1 to 10 Use Types to each pesticide product.
6373 row Excel file, reg_type.xls, has : Count of Registrations for each Registrant for each EPA-OPP product use type.
E.g., HERBICIDE AQUATIC? Scroll to. See that Sepro is #1 and Nufarm (as 228) is #2...(September 2)EPA-OPP's Names for Pests-On-Labels. Look/Search with Word!!
Way below I have Access 2002 tutorials for PPIS data files. Here, I use Word97, to show nothing tricky, strange, difficult about the PPIS files.
This Word97 document, comes from UnZipping the PPIS file pestname.zip. Extraction of gets pestname.txt (a plain vanilla text file).
Open pestname.txt with Word97 (no need to do anything else). To show a feature I turned on Word's Paragraph Symbol (i.e., end-of-a-line entry). One line for each Pest Name.
1. PPIS Fixed-width format. Every line starts with a letter, followed by a combination of letters and digits. Starting at the 10th character: VOILA! a Pest Name shows up. When the name is complete, a bunch of spaces until the end-of-line with the Paragraph Symbol. Fixed-width is a UNIVERSAL standard so that ANYONE using ANY Spreadsheet or Database program can tell the program "Here is How-To stuff pieces into columns".
2. In Word. Edit | Find. Try: glass as what to Find. Oh, the popular GLASSY-WINGED SHARPSHOOTER.
3. 1st letter on each line tells the Pest Type. Want to skip to Insects/Invertebrates? No problem. Don't even need Word's "Special" since Microsoft dare not change Universal standards. Edit | Find. Find: ^pI
Say what? Oh, ^p is the Universal code for End-of-Line. It just tells Word "Find the 1st instance of an End-of-Line followed by the letter I"...(September 2)Access 2002: Registrations By EPA Y2010. Ready-to-Use
Below is an Access 2002 database with 1 Table and 7 Ready-to-Run Queries.
EPA-OPP selected pesticide product registrations in Y2010 as of web-posted PPIS files of 5 August 2010.
Zip file, y2010reg.zip, extracts to the Access 2002 file, y2010reg.mdb. 337 row Table has Y2010 approvals for products with a Sole (1) Active Ingredient (convenience to keep it short).
PDF file, y2010reg.pdf, explains about each of the 7 Ready-to-Run Queries. Each Query will, when Run, Make a permanent Table of Results/ Answers. The 1 data Table ought be self expanatory (what, who, when) . {My mistyping/misspelling in the PDF file I've not bothered to correct} ...(August 31)Cemeteries/Cemetaries: Pesticide Label Site Information ex PPIS
EPA-OPP mostly uses "cemeteries". One Excel file with Complete Site Information?
An example extract from web posted PPIS. This 1208 row Excel file, cemeters.xls, has: Year Approved (sorting down from 2010), All AIs (combinations on one line), Percentage AI(s), Complete Site Name and Code Number, Registrant Name and Company Number, RegNr...(August 20)Not Glyphosate Herbicides: You vs. Loveland and All Others
Herbicides other than Glyphosate. Label Site SubCategories.
2069 row Excel file, s2s5max1.xls, has: Site Category (S2) code and name; Site SubCategory (S5) code and name; Maximum registrations by any Registrant for the Site SubCategory; Number of Loveland's (34704) Registrations; column for your company's registrations.
3046 row Excel file, s2s5max2.xls, has for each Site SubCategory the Maximum number of Registrations and who is the Registrant.
31695 row Excel file, s2s5max3.xls, has S2 and S5 codes, all Company Numbers, how many Registrations for the S5 Site SubCategory ...(August 17)
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