This index page is arranged in sections: Permanent and Transitory items.
- Permanent Items
- Pesticide Statistics and Trends
- Miscellaneous Facts and Information
- Access 2002 and PPIS. Tutorials Ready-to-Run/Use
- 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.
- 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.
- 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)
Look for the 
and
flags to find recent updates or additions.
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 sites
Label 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
EPA Dockets
Information about regulatory actions.
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
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 out
Pesticide Product Labels And MSDSs
Links to free-of-charge sites on the WWW.
EPA'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.
Registrants: Registrations By AI Use Type
Excel file, usecnt02.xls, has for Registrants current
Count of Registrations for AI Use Type.
I = Insecticide; H = Herbicide; F = Fungicide; PGR = Plant Regulator; Rep =
Repellent; D = Disinfectant; V = Vertebraticide...(February 7)
Y2009 Registrations Summary
Excel file, 09regsum.xls, has Registrants and their
AIs. File is sorted in Acsending order by Number of Individual AI in products, Name
of ALL AI, Registrant...(February 5)
Combinations Of 3 Active Ingredients: February
303 row file, 3ai_feb.xls. How Many RegNr for the
Combination. (You can pick out Herbicide, Insecticide, etc.).
An AI in the 3 AI combinations? How about Fluroxypyr 1-MHE?
26 row file, 3aifluor.xls, has RegNr, Combination,
Registrant...(February 4)
Combinations Of 2 Active Ingredients: February
677 row file, 2ai_feb.xls, has: How Many Registrations,
For the Combination, For the Use Type (Algaecide to Vertebraticide), Where the
Combination contains 2 Active Ingredients. Extraction of Only Herbicide or Insecticide
or... is perhaps NOT as trivial with Excel as with Access. C'est la program!!
...(February 4)
Registrations/Registrant/AI: February 2010
7007 row file, regaico.xls, has: How Many Registrations
, for the Active Ingredient, By the Registrant...(February 4)
Y2007-2009: New Actives (Sole Or Combination). Company, Pests
New Active means: a Sole AI or a Combination of Actives NOT Registered prior to
Y2006.
132 row file, 3yrnewai.xls, has How Many Registrations
for a New AI Y2007-2009 for Registrant.
2666 row file, 3yrpest.xls, has How Many New AI for the
named Pest-on-Label (hardly any surprises in ranks, except perhaps for CUTWORMS)
...(January 29)
Greenbook, Gowan, Nippon Soda: Acetamiprid
Greenbook e-mail notice "Gowan gets exclusive marketings rights for Intruder
on Cotton in the US".
Excel file, gowansub.xls, has all Nippon Soda's
subregistrations to Others. 803300024 is the Acetamiprid product given to Gowan
. From EPA-OPP's dist.txt file...(January 27)
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