Popular Links
Featured Links
- Community Guide to Recognizing and Reporting Pesticide Problems
- Complaints
- Compliance assistance for employers
- Decisions pending and opportunities for public participation
- Environmental Justice
- How to get a license or product registration
- Information for physicians
- School IPM
- West Nile virus
Reference Links
California Product/Label Data Tables
These data tables contain a full set of product information including; product name, registration status (active/canceled), formulation, approval/inactivation dates, registration type, registered use sites, restricted use information, etc. They are structured in an ASCII, fixed width format to enable interested parties to access them using a variety of database and spreadsheet software. Please read the table formats and data dictionary documents for a complete description of the data.
Information on:- Table Formats 05/15/06 (PDF, 23k)
- Simple Entity Relationship Diagram (ERD) (PDF, 19k)
- Data Dictionary - Product, Chemical, Company (Excel, 62k)
The 38 individual tables can be found on DPR’s File Transfer Protocol (FTP) site, at: ftp://pestreg.cdpr.ca.gov/pub/outgoing/product/. In addtion, a single file containing all 38 tables, productdb.zip (6.6 mb), can be downloaded by right-clicking on this link, saving the file to your computer, then using a standard windows unzip utility to extract the tables.
The FTP site is being used to facilitate users who wish to set up automatic downloads of the data. New data tables overwrite the existing files, on the FTP site, at approximately 6:30 p.m. PST Mon-Fri.
For content questions contact:
John Stutz
phone: (916) 324-3906
email: jstutz@cdpr.ca.gov