Rutgers Cooperative Extension Integrated Pest Management Program

IPMD – Spatial Database

Where the Data comes from Database Description Database Design

Where the Data Comes From

Commercial growers contribute a participation fee to Rutgers Cooperative Extension. These funds are used to hire seasonal field technicians or scouts who make weekly visits and monitor orchards and blueberry fields for pest activity. Fertility levels are monitored with leaf tissue samples taken from mid-July through mid-August and soil samples taken during Late-September. Plant parasitic nematodes are also monitored with soil samples. A fulltime staff helps survey fruit quality for levels of pest damage and pesticide use records that are collected at the end of each season. These records are analyzed and compared with seasonal pest levels and fruit quality. Data is entered and analyzed with IPMD.

All fruit growers in New Jersey benefit from this IPM information. Growers who contribute participation fees get individual farm reports and recommendations. These Primary Participants realize the most direct benefits. Secondary Participants, or all other growers in the State receive summarized IPM information and recommendations through newsletters, broadcast faxes, articles, fact sheets, grower meetings, and the world wide web. Primary Participants currently manage roughly 50% of New Jersey tree fruit and blueberry acreage.

top

IPMD 2000 Project

Project Leader:  Dean Polk
Database Designer:  Peter Cottingham
GIS/Database Administrator:  Peter Winkler
Requirements Consultants:   Dave Schmidt, Gene Rizio, Meredith Peters, Peter Winkler

IPMD 2000 is a relational database (MS Access) employing spatial properties through linkage to GIS Software. IPMD 2000 is designed to specifically support the NJ Fruit IPM program.
Its goals are:

  • To be used as a decision support tool to assist growers for evaluating the effectiveness and cost of their pesticide usage through the    standardized grower reports.
  • With its report summaries, graphs and ad hoc query capability, IPMD is a research tool for identifying broad trends in pest populations and pesticide usage.
  • To evaluate and demonstrate the impact of various IPM practices.

IPMD features a four-level grower model (grower, farm, block, and trap station) allowing for the storage of data collection records on each level.  Currently there are eleven types of data records supported.

Incorporated in IPMD are several models that include:

  • A Material Model (with pricing and AI composition).
  • A Crop Model which includes phenology data as well as a master variety list of all apple, peach, pear, and blueberry varieties grown by NJ IPM practitioners.
  • An Observation Model comprising the pests under evaluation and the observation methods.

IPMD is linked to a GIS Mapping software (Arcview GIS) so that database elements can be readily geo-referenced in high-resolution grower maps. As well as overlayed with other data layers.

top

Database Design

Database Design
top

 

Back to Fruit IPM Project home page

Return to Precision Agriculture main page