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.

Database Design