This index page is arranged in sections: Permanent and Transitory items.
- Permanent Items
- Pesticide Statistics, Trends, Miscellaneous
- Using Access Database: Audio-Video Tutorials
Excel for PPIS: A-V Tutorial- Access 2002, 2007: PPIS Template Databases
- Access 2002,2007: California (CDPR) Template Databases
Look for the
and 
flags to find recent updates or additions.
Permanent Items Pesticides Regulatory Authorities
. NPIRS at Purdue University offers free-of-charge searches. Links tab leads to useful sites for more information.
Australia.
Canada. (Product search page.)
United Kingdom. {Also has simplest place to find European Union links.}
United States of America.Compendium of Pesticide Common Names
The definitive source for names, structures, use types, and more. Courtesy of Alan Wood.U.S. Pesticide Product Labels
Greenbook. Industry sponsored searchable site. Also has news about the industry.
US-EPA. Environmental Protection Agrncy's searchable site.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.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 Statistics, Trends, Miscellaneous PPIS Chemical Dictionary New Entries: 06 May 2013
Added to PPIS files of 06 May 2013.
Many reasons for a Chemical to be added to the PPIS Dictionary. At the least "Chemical of interest to EPA-OPP". Perhaps a new to U.S. AI, or for an Import Tolerance or... In the file below I include Chemicals with PC Code =>600000. These are used by EPA-OPP for Metabolites or Test Substances.
Excel file ppisdict.xls has the PPIS entries for newest entries...(May 8)EPA. New (Sub)Registration Approvals: 06 May 2013
Added to PPIS files of 06 May 2013.
Newest Registration Approvals. Excel file appr1307.xls has: AIs and Pcts, Registrant, Product Name, EPA Reg. No.
Newest Transferred Registrations. Excel file xfer1307.xls
Newest SubRegistrations. Excel file subs1307.xls...(May 7)GOLF Label Sites: Who, How Many
Following up on the below entry. Who Has How Many Labels for *GOLF* Sites?
Excel file golfcomp.xlsx has the answers...(May 6)Label Site Names/Codes: How to Deconstruct (ala EPA, NPIRS)
Note: How I do EPA-OPP's Sites deconstruction, which might help you? Just how EPA-OPP, and NPIRS, do it? They (EPA-OPP, NPIRS) don't tell.
Note: Example Excel file below for my example has only 9 rows, so not tedious.
Example Site: Excel file sitename.xlsx has just 9 rows, but a bunch of columns.
Site Code: EPA-OPP's complete Site Code (always a 9 digit number)
Site Name: EPA-OPP's Name for this Site (they are ORNAMENTAL PERENNIAL GRASSES ).
S2: 1st two digits of the Site Code (EPA-OPP's Site Category)
S5: 1st five digits of the Site Code
S67: Digits 6 and 7 of the Site Code
S5 Name: My extracted name for this piece of the Code.
S67 Name: My extracted name for this piece of the Code.
GOLF sites? EPA-OPP would need more digits to Name each of the parenthetical qualifiers to Label Sites. So/But, in Access, or of course searching NPIRS, type "golf" and get back the 328 individual corresponding Sites. Well if interested they are: sitegolf.xlsx. For golfers: Balls and/or Bags. Yes, Sites...(May 6)Y2013: Registrations/Registrant or /Active Summaries
New means Registration Number in PPIS files of 08 April 2013 and NOT in PPIS files of 02 January 2013.
Excel file y13regco.xls has Count of Registrations for each Registrant. Data and graph.
Excel file y13regai.xls has Count of Registrations for each Active. Data and Graph...(April 28)EPA. New (Sub)Registration Approvals: 08 April 2013
Added to PPIS files of 08 April 2013.
Newest Registration Approvals. Excel file appr1306.xlsx has: AIs and Pcts, Registrant, Product Name, EPA Reg. No.
Newest Transferred Registrations. Excel file xfer1306.xlsx
Newest SubRegistrations. Excel file subs1306.xlsx...(April 11)
Using Access Database: Audio-Video Tutorials Playing A-V files. Read this first.
Access 2002 for EPA's PPIS (Product Information System) Files
(While these tutorials are for Access 2002, all versions of Access employ the same techniques, and all Access databases for any use employ the same techniques).Windows Media Video files.
WebEx files.Access 2007 for PPIS Files
Only two turorials. Only two additions of note after Access 2002. Otherwise, Microsoft changes, as for other Office Suite programs, the look/appearance.Windows Media Video Files
WebEx files
Using Access Database For EPA's PPLS (Pesticide Product Label System) Tutorial sessions move from finding EPA Reg. No. for latest label image additions to PPLS up to creating a browser-ready file such as this one, which has Registrant, Product, Actives information and with links to PPLS to get Label Images.
Windows Media Viewer files
WebEx Record Format files.
Excel for EPA's PPIS (Pesticide Product Information System)
Only one tutorial needed. Importing/Opening EPA's text files; what's in them.
Windows Media Viewer
WebEx Record Format
Access 2002, 2007: PPIS Template Databases Access database Templates.
Access 2002. Zip file PPIS2Tmp.zip extracts to PPIS2Tmp.mdb
Access 2007. Zip file PPIS7Tmp.zip extracts to PPIS7Tmp.accdb
Each Access Template database has 21 Tables. 18 Tables are Designed to receive EPA's PPIS Fixed-Width text (*.txt) files.
1 Table contains my PC Code - Common Name (AI Common Name) for converting EPA's PC (AI) Codes to a common name I use. You can use, and update, this table or make your own table.
1 Table (ActiveRegs) I use to hold ONLY those products which are currently registered by EPA.
1 Table (PPIS Date) I use to keep track of which EPA PPIS file set I'm using.Import Specifications. Excel file PPISimpt.xls tells you into which Access Table to Append each of the 18 EPA PPIS Fixed-width text files and which Import Specification to use.
Queries. Excel file PPIS_qry.xls tells you what each of the 8 Queries does. Do them in numerical order (else funny results or a dreaded ERROR message). I.e., qry01, qry02, qry03, etc.
Quick and Simple: 1 File Import. Download then Import PPIS product.txt file. Run (double-click) qry01, qry02, qry03. Voila! tblActiveRegs has the currently Active Registrations. (Well, ONLY qry03 is necessary, but why not see what the other 2 Queries do.)
Access 2002, 2007: California (CDPR) Template Databases Source. CDPR's data tables and descriptions of table contents is found at CDPR Database stuff.
Note: My Template databases have ONLY 8 Tables for CDPR data. There are many more, such as label Pests and Sites.
Note: CDPR's text data files are very much like EPA's for PPIS: Fixed-Width file format, except CDPR uses the 3 letter extension "dat" rather than EPA's "txt" file name extension. Importing data files and using Queries is the same as with PPIS files.Access Database Templates
Access 2002. Zip file CDPR2Tmp.zip extracts to CDPR_Tmp.mdb
Access 2007. Zip file CDPR7Tmp.zip extracts to CDPR_Tmp.accdbImport Specifications. Excel file CDPR_imp.xls tells you into which Access Table to Append each of the 8 CDPR Fixed-width text files and which Import Specification to use.
Queries. Excel file CDPR_qry.xls tells you what each of the 8 Queries does. Do them in numerical order (else funny results or a dreaded ERROR message). I.e., qry01, qry02, qry03, etc.
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 - 2011 by Bruce M. McKay, and all rights are reserved.
The URL for this page is http://www.bmckay.com
- Access 2002, 2007: PPIS Template Databases