December 2010-Present: ​California Department of Food & Agriculture (CDFA) Statewide Project

Blankinship & Associates’ staff have been part of a team that has helped the California Department of Food and Agriculture (CDFA) prepare their Final Program Environmental Impact Report (PEIR) to provide an up-to-date, transparent, and comprehensive evaluation of CDFA’s activities throughout the state of California. Our analysis included one of the largest scale pesticide Human Health and Ecological Risk Assessment ever produced. It included eight (8) pesticide programs designed to protect California’s agriculture from damage caused by invasive plant pests. These programs include:

  • Pierce’s Disease Control Program
  • Asian Citrus Psyllid
  • Fruit Fly
  • Pest/Detection/Emergency Projects – Eradication (PD/EP-E)
  • Pest Detection/Emergency Projects – Detection (PD/EP-D)
  • Integrated Pest Control
  • Light Brown Apple Moth
  • European Grapevine Moth

The analysis included:

  • TWENTY-NINE (29) Pesticide Active Ingredients
  • FIFTY-ONE (51) Pesticide Inert Ingredients (including additives, adjuvants, lures, etc.)
  • SIXTY-NINE (69) products (includes pesticide, adjuvant, & trapping products)
  • TEN (10) human receptors including occupational, residential, and bystander exposures
  • FIFTY-ONE (51) terrestrial and aquatic ecological receptors
  • TWO-HUNDRED-THIRTEEN (213) scenarios for the human risk assessment
  • ONE-HUNDRED-EIGHTY-SEVEN (187) scenarios for the ecological risk assessment

To manage this colossal project, we constructed two very powerful tools: the CRANK and the DASHBOARD.

Process illustration

The Comprehensive Risk ANalysis Kalculator (CRANK) is a comprehensive integrated Microsoft Excel workbook that combines numerous state and federal agency Excel-based pesticide risk assessment models, in-house developed models, and output from external models together to form a consolidated tool used to estimate pesticide risk. The CRANK allows for rapid evaluation of risk under different scenarios to assess and formulate risk management strategies. Because the volume and detail of data generated by the CRANK is highly detailed, a user-friendly tool was developed to access this data called “The Dashboard.”

The Dashboard Database (DASHBOARD) is a Microsoft Access based database that houses all of the inputs and scenario details required to run the CRANK in addition to all results generated by the CRANK. Additionally, the DASHBOARD was constructed to automate the process of inputting data into the CRANK and extracting the results back into the database itself. Once inside the Dashboard Database, results can be accessed through intuitive, interactive user-interfaces. What would otherwise require parsing through millions of results printed on paper tables stretching for hundreds of miles is now just a few clicks away! Below is an introduction and explanatory video to the DASHBOARD: