Attachment_F_Pesticide_Use_Report_Form.xlsx
XLSX spreadsheet 57 KB Posted
- Attached to
- Landscaping and Grounds Maintenance Services
- Solicitation number
- 2026-RFP-00070
- Issued by
- San Mateo County, California
About this file
The document is a detailed Excel spreadsheet titled "Attachment_F_Pesticide_Use_Report_Form.xlsx" from the County of San Mateo, specifically designed for tracking pesticide product applications by city staff and contractors. The spreadsheet provides a comprehensive system for documenting pesticide use, with multiple tabs including a tracking sheet, product list, summary table, and lookup lists for recording details such as application date, product name, EPA registration number, quantity used, target pests, and IPM strategies. The file is part of a larger landscaping and grounds maintenance contract opportunity for the San Mateo County Department of Public Works, which seeks a landscaping firm to maintain over 50 county-owned locations.
The contract opportunity involves general horticultural maintenance, irrigation maintenance, grounds maintenance, and green infrastructure work, with an anticipated five-year contract term and an additional $500,000 allocated for as-needed work. The contractor will be required to bring county sites up to quality standards within 90 days of the agreement, including tasks like irrigation repair, plant replacement, and necessary pruning. The pesticide tracking spreadsheet serves as a critical tool for environmental monitoring, with specific focus on Municipal Regional Permit (MRP) pesticides of concern and detailed instructions for documenting pesticide applications, product registration, and annual reporting requirements.
View the file
Other files
Show all 24
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Metadata
| SMCWPPP Pesticide Product Application Tracking Sheet | |
| Tab | Description |
| Tracking | Data entry sheet for pesticide applicators |
| ProductList | List of all pesticide products currently applied by City staff and contractors |
| Subset of the DPR list copied and pasted by City Staff | |
| Automatically calculates the total amount of product used from the Tracking tab | |
| Summary | Summary table for Annual Reporting - Total amount of each pesticide (active ingredient) used by units |
| The MRP pesticides of concern are listed. Add additional active ingredients to the list as needed. | |
| LookupLists | Add agency specific values to the drop down lists for applicator, location, targeted pests and IPM tactics. |
| These drop down lists appear on the Tracking tab. | |
| DPR_LookupList | Complete list of active products registered with DPR or that expired less than 2 years ago |
| DO NOT resort the table. Sorting may change variables on other sheets | |
| The DPR product database is available at | |
| http://www.cdpr.ca.gov/docs/label/m4.htm | |
| ***While there is no SMCWPPP list of approved pesticides, staff/contractors may use this list to determine which products to avoid (i.e., those with pesticides of concern). Column H indicates whether a product is mentioned as a pesticide of concern within the Municipal Regional Permit. To find a product, press Ctrl+F and type the product name. | |
| DuplicateNames | List of product names associated with more than one EPA registration number |
| Notes | |
| Column headings in gray on the Tracking, ProductList, and Summary tabs indicate these fields will be autopopulated and contain formulas |
| Step 1 |
| From the DPR_LookupList, find the name(s) of the products that are used in your municipality by staff or contractors. |
| Confirm each product's EPA registration number in the table with the number on the product's packaging |
| Check for duplicate product names on the DuplicateNames sheet |
| Copy each Product Name and EPA Registration Number (from Columns A and B of the DPR_LookupList) |
| Paste each Product Name and EPA Registration Number into Columns A and B of the ProductList |
| Up to three active ingredients will autopopulate the table. |
| If a product contains an MRP tracked pesticide, it will appear as the first active ingredient |
| Active ingredients that are not tracked by the MRP are ordered by their percentage (largest % first) |
| ***Note - alternatively, users can copy their ProductList from the previous FY's workbook into this sheet and then add new products |
| Step 2 |
| Add applicable values to the LookupLists sheet. |
| Lists are for City Staff/Contractor (applicator) name, Application Location, Targeted Pest(s), and IPM tactics utilized |
| Step 3 |
| Fill in applicable fields on the Tracking sheet |
| The EPA registration number will autopopulate and does not need to be completed |
| Several fields are pull-down lists ensure consistency: |
| The Name of Product Applied is a pull-down list from the ProductList tab |
| The Applicator, Application Location, Targeted Pest(s), and IPM tactics are pull-down lists from the LookupLists tab |
| The amount of product used may be entered as fluid ounces, ounces, gallons, milligrams, or pounds |
| If packets are used, multiply the weight/volume on the package by the number of packages used |
| If the applicator diluted the product for application, only enter the amount of product used, not the diluted amount |
| Step 4 |
| The ProductList sheet will automatically calculate the total amount of each product used |
| The Summary sheet will automatically calculate the total amount of each pesticide used for the listed MRP pesticides of concern |
| To track active ingredients that are not MRP pesticides of concern |
| Copy the names of the active ingredients from the ProductList tab |
| Paste the names on the Summary sheet in the Active Ingredients column |
| Last Updated | |
| 7/3/17 | Updated DPR_LookupList & DuplicateNames |
| 7/26/17 | Fixed ProductList Formulas |
| 7/9/18 | Removed Dilution Tab; Updated DPR_LookupList & DuplicateNames to include new products (as of 7/1/18) and removed those that expired before 7/1/16 |
| 8/14/18 | Added Pentra-Bark |
| 7/16/19 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/17 |
| 7/2/20 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/18 |
| 8/5/20 | Fixed ProductList Formulas & references to DPR_LookupList |
| 7/7/21 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/19. |
Changed "MRP tracked pesticide category" to "Pesticide of Concern"
| 6/2/22 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/20. Added the three neonicotinoids referenced in MRP to the list of pollutants of concern on Summary tab. |
| 6/26/23 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/21. |
| 6/5/24 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/22. |
8/6/24 Corrected error which resulted in missing products from DPR_LookupList http://www.cdpr.ca.gov/docs/label/m4.htm Tracking
| City of | |
| Pesticide Products Tracking Sheet | *Only report the amount of product actually used NOT the amount of diluted product* |
| Date of Application | Applicator | Location of | Area (Acres or units) | Name of Product Applied | EPA Registration # | Total Product Used | Target | IPM | Comments | ||||
| (City Staff/Contractor) | Application | Treated | fl oz | oz | gal | mg | lbs | Pest(s) | Strategies |
to add more rows, copy the row above and insert above this row
ProductList
| County of San Mateo |
| Landscaping Contractor |
| List of Pesticide Products |
| Total Product Used | Active Ingredient 1 | Active Ingredient 2 | Active Ingredient 3 | ||||||||||||||||||||||||
| Product Name | EPA Registration # | fl oz | oz | gal | mg | lbs | Name | % | fl oz | oz | gal | mg | lbs | Name | % | fl oz | oz | gal | mg | lbs | Name | % | fl oz | oz | gal | mg | lbs |
to add more rows, copy the row above and insert above this row
File details come from the government source that posted it. Updated .