System and method for creating agricultural decision and application maps for automated agricultural machines

[0002] This application is a continuation-in-part of application Ser. No. 08/452,894 filed May 30, 1995, abandoned, entitled System and Method for Creating Agricultural Decision and Application Maps for Automated Agricultural Machines.

[0003] This invention relates generally to a system and method for creating variable rate application maps for applying dispensing materials to a field. In particular, the present invention relates to a system for creating variable rate application maps which allow the user to vary the dispensing rate of dispensing materials at various field locations depending upon different field conditions at different field locations. In particular, the present invention relates to a geographic information system for maintaining geographic field data and other data for site specific farming applications.

[0004] Typically, dispensing apparatus for dispensing materials (such as fertilizer, seeds, etc.) to a field have applied such materials uniformly across a field irrespective of varying field conditions across the field. Such application of materials at a constant rate without consideration to varying field conditions may not provide optimal efficiency or yield. Accordingly, it is desirable to vary the dispensing rates of materials depending upon varied field conditions. Various field conditions, such as soil characteristics and nutrient levels, affect plant growth. Accordingly, it is desirable to provide varying application rates of dispensing materials to accommodate for varied field conditions.

[0005] Systems are already known which are capable of evaluating soil nutrient levels and other field conditions. Thus, it is desirable to use such field characteristics to determine optimum or desired dispensing levels at varied locations. The criteria for determining desired dispensing rates and data available may vary. Thus, it is desirable to have a dynamic system for generating variable rate application maps for use with a controller with the flexibility to evaluate dispensing rates depending upon selected data and varied criteria. Additionally, it is desirable to have a system for creating application maps which may consider varied available data for the purpose of achieving optimum dispensing rates for various materials.

[0006] The present invention relates to a dynamic system for creating application maps for use with a controller for a dispensing apparatus for dispensing materials to a field. The application maps determine variable rates for application of dispensing materials depending upon varied field conditions. Thus, dispensing materials are dispensed at variable rates across the field depending upon the particular field conditions at a particular field location. Preferably, the system includes a geographic information system for storing field data relative to data type and a georeferenced field location. Preferably, spatial field data is georeferenced relative to longitudinal and latitude coordinates for storage, access and manipulation of said data for creating georeferenced application maps in one embodiment of the invention. The system also includes a means for storing field boundary data for correlating spatial data relative to a specific field.

[0007] Preferably, the system includes user interface means for selectively defining various application rate equations for determining rates of application for a particular dispensing material based upon particular field data desired for various field locations. The application rate equations are selectively defined by a user relative to desired relationships between selected data and desired output. A processor is operably associated with the stored field data and the user interface means for defining various application rate equations for use in determining varied application rates for a particular field for a particular dispensing material. The application rate equation correlate selected data and desired output to produce a variable rate application map for a field.

[0008] Other features of the present invention and many of the attendant advantages of the present invention will be readily appreciated as the same becomes better understood by reference to the detailed description when considered in connection with the accompanying drawings in which like reference numerals designate like parts throughout the figures thereof and wherein:

[0009] FIG. 1 is a block diagram of one preferred embodiment for the present inventive geographical information system for creating agricultural decision and application maps for automated cultural machines;

[0010] FIG. 2 is a flow chart depicting one preferred embodiment for the present inventive geographical information system software for creating application maps for controlling automated arcultural machines;

[0011] FIG. 3 is a more detailed flow chart illustrating a preferred embodiment for the present inventive geopahical information system software;

[0012] FIG. 3A is an illustration of a system for identifying field regions having varied field characteristic for analysis for creating application maps;

[0013] FIG. 4 is a block diagram illustrating one preferred embodiment for monitoring and controlling particular vehicle controls for an automated agricultural machine via a variable rate application map;

[0014] FIG. 5 is a block diagram illustrating one application of the application maps generated by the inventive geographical information system interfacing with controller hardware to calculate and control the desired product dispersion rates based on ground speed, soil characteristics and/or numerous additional vehicle configuration factors;

[0015] FIG. 6 is a diagram illustrating one embodiment of a controlling rate equation which is used to control the hardware depicted in FIG. 5;

[0016] FIG. 7 is a diagram illustrating the manner in which the present inventive geographical information system functions to combine field treatment recommendation data with commercially available products and pre-blended materials to create output data necessary to formulate product application maps and/or reports;

[0017] FIG. 8 is a block diagram illustrating the manner in which the present inventive geographical information system functions to allow system users access to agronomic recommendation equations or application rate equations in a database to add and modify equations and data relationships for agricultural data;

[0018] FIG. 9 is a diagram illustrating one manner in which geographical information system may store agronomic recommendation equations or application rate equations;

[0019] FIG. 10 is a diagram illustrating the manner in which the present inventive geographical information system stores recommendation equations or application rate equations as data in a database;

[0020] FIG. 11 is a simplified block diagram illustrating the present inventive system equipped with spatial database software as an information center capable of storing all the spatial information required to manage a field;

[0021] FIG. 12 is a simplified block diagram illustrating the relationship between the user interface, the spatial database, a conventional database management system and a record manager or custom software for one embodiment of the present invention;

[0022] FIG. 13 diagrammatically illustrates one embodiment for performing field spatial data conversion for the present invention;

[0023] FIG. 14 illustrates a field spatial database in which samples are stored relative to a particular field;

[0024] FIG. 15 illustrates one embodiment of a field spatial database for retrieving spatial field data for the sent invention; and

[0025] FIG. 16 illustrates one embodiment for a method of storing yield monitor data in a field spatial database for the present invention.

[0026] The present invention relates to a system for evaluating characteristics, (such as topography, and soil data, etc.), for a particular field for precision farming and site specific farming applications. In particular, the present invention relates to a system for creating application maps for variable rate application of various dispensing materials based upon varied field characteristics or conditions. The application maps comprise dispensing rate data for varying amounts of a dispensing material based upon both geographic and attribute data. The preferred embodiment of the present invention described as follows, is used for controlling and monitoring automated agricultural machines for variable rate application including, but not limited to equipment utilizing the FALCON™ controller manufactured by Soil Teq, Inc. of Minnetonka, Minn.

[0027] FIG. 1 illustrates the simplest embodiment 100 of the present invention capable of creating maps or reports for real time monitoring and control of automated agricultural machines or dispensing apparatus 108. As shown, the system for creating and using application maps 100 generally includes an input device 102 for inputting field data (such as attribute or geographical data 202 and 204, and a geographic information system (“GIS”) 104. The GIS 104 comprises computer hardware and software that is used to produce application maps or reports 106 which may be used for controlling a dispensing apparatus for agricultural equipment 108. The system for creating application maps 100 uses information from various sources about an agricultural field to determine what agricultural treatments are necessary throughout the field. Preferably, these treatments are either in report or map form on hard copy (paper), a display, or electronic or magnetic media 106. As stated hereinbefore, the reports or maps are then used in an automated agricultural machine or dispensing apparatus 108 such as the FALCON™ controller by Soil Teq, Inc., to control the agricultural treatments applied to a field.

[0028] The system 104 contains GIS software, which provides a system for handling spatial data for use in creating application maps 106, thereby enabling the system to input data, manipulate the input data, and perform mathematical and spatial calculations along and through different types of data based on an embedded expert system's or user's recommendations for producing application treatment maps as will be described in further detail herein.

[0029] FIG. 2 illustrates a flow chart depicting one preferred embodiment for the present inventive GIS software of a system 200 for creating application maps 106 for controlling agricultural equipment 108. It is preferable that system 200 utilize a combination of attribute data 202 and geographical data 204 in combination with specific user data 208 (i.e. application rate equations). The user inputs instructions to the system for creating a particular map via user input 208. The geographical data 204 preferably includes field boundary data 212 and soil sample data 210. Soil sample data 210 may include soil test data in either systematic or random form of soil nutrient levels, soil pH, soil texture and characteristics, organic matter, etc. Attribute data 202 may include future crops data 214, cost data, dealer information, farmer information, and account information, and also agricultural products and treatment data 224.

[0030] The GIS system 104 provides data storage 206 for spatial field data (such as geographical data 204) and other field or characteristics data (such as attribute data 202.) The data storage 206 function of the GIS system 104 stores geographic data (which may also be called spatial field data) 204 based upon geographic location as will be described in further detail herein. Attribute and geographic data 202 and 204 such as field boundary data 212, future crops 214, and soil sample data 210 may be retrieved as illustrated at 222 for producing agricultural products and treatment maps and reports (application maps) 106 based upon user inputted instructions and data 208. The system for generating maps 104 may include agricultural product information data 224 which may be used as shown in FIG. 2 for creating application maps or reports for a particular agricultural product which may be dispensed. Various agricultural products comprise blends of nutrients or other field treatment materials. Agricultural product information data 224 includes information, such as the composition of various commercial agricultural products.

[0031] The system for creating application maps 200 includes a processor or expert system 216 which is used to generate the application maps 106 based upon field data or other data and desired relationship between the specific field data and desired output. The processor or expert system 216 creates application maps illustrated by block 106 of FIG. 2 based upon one or more relationships between one or more factors relating to crop production. These relationships are preferably mathematical, spatial, and may be user defined and/or other relationships which would be beneficial to those skilled in the art to establish such relationships relating to crop production emanating from attribute data and geographical data.

[0032] The system for creating application maps 104 preferably formulates agricultural products and treatments reports and maps, as illustrated in block 106 in FIG. 2. As stated hereinbefore, the maps and reports 106 can preferably be generated either in electronic or paper form for providing the necessary input data required to control the computer controlled agricultural equipment 108, e.g. applicator or a manual applicator such that at least one agricultural product is dispersed from equipment 108 in conformance with the maps and/or reports 106. The relationships between the factors relating to crop production establish boundary conditions or limits which optimize and restrict the map formulation process such that product application errors may often be eliminated, e.g. accidental misuse of a restricted chemical for example. However, the present invention is not so limited, and those skilled in the art will readily appreciate the multitude of additional advantages provided by using such a system to control generation of application maps for controlling automated agricultural equipment 108.

[0033] The input device 102 of the system of creating application maps 100 embodied in FIG. 1 may be a mouse, digitizing tablet, or keyboard, for inputting data, such as, attribute data 202, geographical data 204, user defined data 208 and agricultural products and treatments data 224 into GIS computer 104. This data is then stored in the GIS computer 104 in a temporary storage device such as a random access memory (RAM) while it is waiting for access by a CPU, e.g. Intel 80X86 series of microprocessors as will be explained. It will be appreciated by those skilled in the art that other CPU devices and memory types, both volatile and non-volatile may just as well be utilized for the present application. Subsequent to accessing the aforementioned data, the CPU stores the data on a media used for a long term data storage, e.g. hard disk drive, floppy disk, etc. in a manner well known to those skilled in the art.

[0034] Preferably, the data is stored in layers based on data type and geographical location and may include commercially available database files and tables or a record manager specifically for a predetermined application, for example. The data storage is depicted in block 206 in FIG. 2. Georeferenced location or global coordinates may be based upon latitude and longitude coordinates as well as other coordinate systems such as radians or UTM coordinates. Geographic based data may be incorporated into the present GIS system in a variety of formats not limited to a coordinate based system and may include boundary based data which is processed for input into the field spatial database for use in creating application maps as will be described. As stated hereinbefore, each data layer can be manipulated mathematically or spatially within itself or another data layer as the data flows through the GIS system 104 in conformance with the data flow depicted in FIG. 2. Most preferably, the data is compressed to reduce GIS computer 104 storage requirements and to allow fast access to data stored in the database as depicted by block 222. Georeferenced mapped information may be recalled by state, county, township section and field.

[0035] Preferably, the GIS system 104, at a minimum, utilizes attribute data 202 and geographical data 204 to formulate maps and reports including agricultural products and treatments maps and reports 106. Additional user defined input data 208 may also be combined with attribute data 202 and geographical data 204 to generate and further refine the detail of the desired maps and reports. FIG. 3 is more detailed embodiment of the system for creating and using application maps 300 incorporating a geographical information system in accordance with the present invention. As stated hereinbefore, GIS technology has several advantages for the agricultural industry. Particularly, the present inventive application of GIS technology deals with field management and precision farming.

[0036] For purposes of clarity and understanding regarding operation of the present inventive GIS, a list of definitions applicable to the embodiments of the present invention depicted in FIGS. 2 and 3 are as follows:

[0037] Attribute Data—data type that is not specifically tied to a geocoordinate; examples including input costs, dealer and farmer information, such as name, address, account identification, etc.

[0038] Geographical Data—data type including all types of information that is associated with geographical locations; examples including field boundaries; waterways, well heads, soil type data, yield monitor data, etc.

[0039] User Input I—The user will specify which field she is interested in and what report and map she wishes to generate; possible maps including economic, past practices, land ownership, planned farm operation, etc.

[0040] Soil Sample Data—may consist of laboratory tested soil samples taken from a field of interest in either a systematic or random pattern. The laboratory tests these samples for the current condition of the soil in a field as it relates to crop growth. These tests may include soil nutrient levels, soil pH, soil texture, organic matter and others that are important for a given crop. This data is used to build a soil profile through various mathematical modeling techniques for use by an expert system.

[0041] Field Boundary Data—consists of data that describes a field outline; may be obtained by tracing or scanning a photograph or drawing of a field or using a vehicle equipped with sensors that surmise the field boundary while operating in the field.

[0042] Future Crop Data—consists of types of crops that may be planted in a field; used by an expert system to perform its calculations.

[0043] Expert System—a system defined by the use of one or more relationships between one or more factors that relate to crop production. The relationships may be mathematical, spatial, user defined or other; including recommendation equations for a given nutrient and crop as published by most state universities.

[0044] Agriculture Products and Treatments Data—data type including all types of agricultural products chemical compositions and their legally prescribed use; data used by an expert system to prevent the accidental misuse of a restricted chemical. This data is also used by the Map Based Formulation System.

[0045] Agricultural Products and Treatments Maps and Reports—The maps and reports can either be in electronic or paper form. The maps contain information that define where in a field a certain rate and location within a field a farm input or action will be applied. The map could be used either by a computer controlled applicator or a manual applicator.

[0046] Computer Controlled Agricultural Equipment—This machinery may include equipment such as Soil Teq, Inc.'s FALCON™ control system.

[0047] Map Based Formulation System—The formulation routing formulates, zone by zone, commercial or custom fertilizer to match the nutrient recommendation from the expert system based on input costs, product availability and suitability for the crop and applicator.

[0048] Agricultural Nutrient Application Map and Report—This map and report can either be in electronic or paper form. The map contain geocoordinates that define where in a field a certain nutrient requirement exists for a given crop(s). The primary use for this data is for historic purposes; however, other uses may be possible.

[0049] Machine Records and Maps—This data is either recorded by the applicator equipment itself or entered by the operator as to what actually happened during the field application. This information is used as historic data.

[0050] Previous Crops—Previous crops includes data as the type of crop, the seed variety, planting population and the yield received from the field. This data is important for tuning the expert system as part of the historical information. Previous crop is also used to determine which soil properties were affected by the crop and how they were affected. This information is also used by the expert system for determining which crop and field treatments to perform on the field in the fixture.

[0051] Field History—Field history contains both map and textual data. The map data may include information about field ownership and others. The textual data may include attribute data for the map data and other information that was gathered about the field before GIS technology was used to store this data.

[0052] Past Farming Practices—This information would include data about manure management, land leveling, deforestation, tillage and others. This data would be used in the expert system as part of the field history data.

[0053] Field Elevation and Slope—This information is used by the expert system for determining water run-off and leaching potential for applying farm chemicals and products. It is also used in determining plant population. This data will be used by the expert system.

[0054] Hydrology—This data is used for several purposes, e.g. water table studies, proximity of a field application to a well or waterway and irrigation. This data is used by the expert system.

[0055] Future Farming Practices—This data would be the planned tillage, irrigation and others and how they would affect crop production. This information is used by the expert system.

[0056] Farm Input Costs and Crop Selling Price—This data contains all of the costs associated with crop production and its expected selling price. This data could be used for determining gross margin maps and reports as well as determining the best economic treatment for a field. This data is used by the expert system.

[0057] User Input 2—This interface allows the user to see what the expert system is recommending for a field and override the system before the maps are created for the applicator.

[0058] Recommendation Equations—the mathematical formulas that express the relationships between existing field conditions and the desired crop yield. These formulas can either be derived from empirical data sources or determined by an expert in the field of agriculture.

[0059] Data Compression and Retrieval Routines—Data compression is necessary to reduce computer system data storage requirements and to allow fast access to data stored in the database. One possible adaptation of this is using quadtree data storage.

[0060] Database—The term database is used for the actual computer file(s) and table(s) that store the information in the GIS.

[0061] Field History Maps and Reports—represents the data and reports that are necessary for professionals in the agricultural industry to study past practices and learn how different conditions affected past crops. This data is used for tuning and redefining the expert system.

[0062] Soil Type Properties—include a measure of how well a given area of a field can sustain a given crop. This information may include a soil's ability to hold water, its susceptibility to erosion, its susceptibility to leaching farm products such as fertilizer and chemicals, as well as others. This data is used to build a soil profile through various mathematical modeling techniques for the expert system.

[0063] Weather Data—This data may consist of historical and real time data. The historical data is used for making predictions for anticipated weather conditions as it relates to farm planning. It is also used for historical data analysis on fields to help determine what effects weather had on previous crops. This information would be used in the expert system. Real time weather is used by the farm chemical applicator to determine wind speed and direction, precipitation and others for deciding when to apply certain chemicals or inputs to a field.

[0064] Additional aspects or the present invention can be better understood with reference to the flow chart depicted in FIG. 3. FIG. 3 shows attribute data 202, recommendation equations 226, and geographic data 204. A data compression routine 230 is used to compress the attribute data 202, recommendation equations 226, and geographical data 204 for storage in database 206. A data base retrieval routine 222 can be used to retrieve the data in the form of soil sample data 210, field boundary data 212, field elevation and slope data 234, soil type properties data 236, field history data 238, hydrology data 240, weather data 242, past farming practices 244, future farming practices 246, previous crops data 218, future crops data 214, and farm input costs and crop selling price 250.

[0065] FIG. 3 illustrates a preferred method of applying GIS technology in precision agriculture and provides a tool for all aspects of converting agronomic data intp georeferenced mapped information for producing georeferenced application maps for varied rate application of dispensing material at various field locations. Maps are the visual basis for locating specific spots, defining soil needs and initiating automatic application control. Such application of GIS technology to formulate and generate maps used to control automated agricultural equipment has been heretobefore unknown in the agricultural industry or to those skilled in the art of agronomics.

[0066] Looking now at FIG. 3, the process begins by inputting attribute data 202 and geographical data 204 into the present inventive GIS system for use in determining optimum treatment systems. Attribute data 202 may include input costs, dealer and farmer information such as name, address, account identification, etc. Geographical or field data 204 may include field boundaries, waterways, well heads, soil data, yield monitor data, etc. It is preferable that the input data also include recommendation equations as illustrated in block 226. Field data may be spatial data such as soil property data 236, soil sample data 210, field elevation and slope data 234, hydrology data 240, field history data 238 (including yield data). Other map type data and non-spatial field data may include weather data 242, previous and future crop information 248, 214, and farm input costs and crop selling price 250.

[0067] Recommendation equations 226 are the mathematical formulas that express the relationship between existing field conditions and the desired crop yield (i.e., relate field data to desired output) for determining the amount of dispensing material, and may be derived from the empirical data sources or determined by an expert in the field of agricultural, as defined hereinbefore. Additionally, these recommendations equations 226 preferably are tailored to match the characteristics of the automated agricultural equipment 108, e.g. implemented in a manner such that the specific equipment of interest is capable of accurately responding to and meeting the characteristics specified by the recommendation equation(s) 226.

[0068] Because the quantity, complexity and diversity of agronomic data used in the present inventive application must be stored in a database for later retrieval as necessary dependent upon the desired end results and type of machine control desired, the present invention is equipped with spatial database software as an information center as will be explained more fully herein. The inventive system can store all of the information required to manage a field (i.e. field data), including geographical data 204 and attribute data 202 as referenced hereinbefore. Certain spatial data may be stored in a field spatial database (FSBD) 206. The data is compressed as illustrated by block 230 for storage 206, and retrieval 222 as will be described herein. The data which may be stored in the field spatial database (FSBD) 206 includes spatial field data maps such as geographical data 204, as well as maps (for example 218, 232, 254, 256 and 258) generated by the GIS system 104 for various dispensing applications or a map recorded by a controller for agricultural equipment which includes a historical description of the application of dispensing materials to a field 228 as illustrated on the flow chart of FIG. 3 by feedback lines 260aand 260brespectively. This map information may be stored for later use and analysis for field treatment. Maps 218, 254, 232, 256 and 258 illustrate the various georeferenced mapped information which may be produced for the aid of precision farming.

[0069] Looking again at FIG. 3, various combinations of desired data are retrieved 222 from database 206 based upon user input 208a. This desired data is then optionally combined with any desired user defined data 208bas well as any desired agricultural products and treatments data 224 for processing by the expert system 216. As stated hereinbefore, expert system 216 is responsible for correlating desired data to create maps for prescription treatment. As previously explained, recommendation equations or application rate equations are formulas which express the relationship between existing field conditions and desired output. The expert system 216 may utilize pre-defined recommendation equations as illustrated by block 226 or user specific recommendation equations as indicated by block 208bfor correlating desired data relative to desired output for the purpose of generating an application map for a particular dispensing material. These records and maps allow the computer controlled agricultural equipment 108 operator to see what actually happened during the field application and also can be used to control a computer controlled applicator or a manual applicator 108.

[0070] Recommendation equations 226 may determine dispensing rates for materials based upon soil sample data 210 and defined yield potential or productivity for a particular crop based upon field characteristics or conditions. Desired yield potential varies depending upon the soil characteristics by location. Thus, the expert system may calculate dispensing rates by location based upon the desired recommendation equation which incorporates a yield goal map based upon soil properties, or alternatively the recommendation equation may use a constant yield goal for a field. Preferably, a soil characteristic map is inputted to the system to construct a yield goal map for creating an application map based upon site specific yield goals. The soil characteristic map may be a commercially available digital soil characteristic map and predefined yield goals may be assigned to each soil characteristics area based upon a particular crop.

[0071] The GIS system of the present invention also includes a system for displaying via an output device 107 (FIG. 4) a polygon type boundary map, such as a boundary map of areas of different yield goal based upon a spatial soil characteristic map, or areas of different field characteristics based upon a spatial field characteristic map, as shown in FIG. 3A. As shown, different regions 290a-dhave different field characteristics which may be incorporated by a recommendation equation for determining dispensing rates by location. Preferably, the GIS system 104 of the present invention includes a user interface system designed to allow a user to modify a predefined boundary map, such as a yield goal map based upon soil properties, or create an input map. Preferably the interface system allows the user to define or change different yield goal values or attribute values for different field characteristic areas, or draw or reconfigure boundaries for different field characteristic regions or areas. Thus, the boundaries for areas 290a-dmay be drawn or changed and the areas or regions 290a-dmay be assigned different yield goals via the user interface. The drawing capabilities of the system for defining regions of similar field characteristics or attributes for creating input maps for use in generating an application map may be accomplished by available drawing software such as drawing software available from MapInfo Corporation of Troy, N.Y.

[0072] FIGS. 4 and 5 illustrate use of the present GIS system for controlling a dispensing apparatus of an agricultural vehicle 108. FIG. 4 is a block diagram illustrating use of the present inventive GIS system for controlling agricultural equipment 108. The GIS system 104 is typically located in an office off-site from the targeted field, so that the application maps and reports 106 are taken from the office to the computer controlled agricultural equipment 108 in, for instance, electronic or magnetic media form as described hereinbefore. Application maps and reports 106 of the GIS system interface with computer controlled agricultural equipment 108.

[0073] The computer controlled agricultural equipment 108 comprises a Global Positioning System (“GPS”) 350, a central control system 320, a vehicle control system 330, a user interface system 340, as well as a source of power 290, main power switch 292, and power converter 294. The GPS 350 may comprise a GPS antenna 352, a radio modem 354, and a radio modem antenna 356. The user interface system 340 may include a monitor 107, keyboard 109, or touch pad 111.

[0074] The central control system 320 is typically an on-board computer capable of operating software, specifically the application maps 106 created by the GIS system 104. The central control system 320 is coupled to the GPS 350, the vehicle control system 330, and the user interface 340. GPS 350 uses satellites to determine a georeferenced position of the vehicle 108 in a field. The central control system 320 receives information from the GPS system 350 to coordinate the position of the vehicle 108 with the application maps 106 so that the proper amount or rate of dispensing material is spread at the proper field location.

[0075] The vehicle control system 330 for the dispensing apparatus includes a controller 404, junction box 403, and vehicle controls 402, such as hydraulic valve, electronic motors, rate sensors, empty/full sensors, and/or radar gun. The controller 404 controls the mechanical operation of the vehicle controls 402 of the dispensing apparatus. The central control system 320 communicates instructions of the application maps and reports 106 created by the GIS system 104 to the vehicle control system 330 (i.e., the controller 404 which operates the vehicle controls for effecting variable rate application.) Controller firmware 404 handshakes with the application maps and reports 106 formulated by GIS software 104 to control vehicle controls 402.

[0076] The controller 404 is coupled to vehicle controls 402 to thereby effectuate the variable rate dispensing of material based upon an application map 106 generated by the GIS system 104. The controller firmware 404 interfaces with the central control system 320 (including application maps) by an RS-232 interface 406. It will be appreciated by those skilled in the art that the present invention is not so limited however, and that other types of interfaces could also be utilized. As illustrated in FIG. 4, a user 340 may interface with control software 320 to control the vehicle control system 330 and override the application prescription of the GIS system 104. The user may interface with monitor 107 to view the proposed prescription plan generated by the GIS system 104 and modify the prescription application plan if desired.

[0077] Looking now at FIG. 5, one embodiment for a control loop is illustrated which depicts in detail hardware devices used for controlling miscellaneous portions of the computer controlled agricultural equipment 108 dispensing apparatus. FIG. 5 is a more detailed illustration of the interface of the application maps 106 of the GIS System 104, the central control system 320 and the controller 404 for the vehicle controls 402 for the dispensing apparatus of the computer controlled agricultural equipment 108. As shown in FIG. 5, the vehicle controls 402 for the dispensing apparatus may include a radar gun 405, a fan speed sensor 406 and a control loop 410 for sensing vehicle speed and fan speed. The central control system 320 (i.e. application maps 106) interfaces with radar gun 405, fan speed sensor 406 and other equipment device control loops 410 via interface boards 407, 409 of controller 404. As shown in FIG. 5, the desired rate obtained from the application map 106 for a particular location is transferred to the controller 404 for effecting variable rate control. As also shown in FIG. 5, the controller returns to the central control system 320 spread data including radar rate from radar gun 405, actual rates, and empty sensor status and fan speed from fan speed sensor 406 for use in generating a field treatment map for incorporation into the GIS system 104.

[0078] One preferred embodiment depicting use of specific individual computer controlled equipment devices to determine and control the desired rates of product dispersion from an applicator via an application map is shown in FIG. 6. Rate equation 500 comprises desired rate (“DR”) 501, Desired Quantity 502, Pulses per cubic foot 504, Density 506, Speed 508, Path Width 510, Calibration Factor 512, and Constant 514. DR 501 is the desired rate expressed as a frequency (Hz, or pulse/sec). Desired Quantity 502 is the amount of product to be applied in terms of pounds per acre. Pulses per cubic foot 504 is the number of pulses from a rate sensor required to dispense one cubic foot of product. Density 506 is the product density in pounds per cubic foot. Speed 508 is the vehicle speed in miles per hour. Path Width 510 is the application spread width in feet. Calibration Factor 512 is the rate calibration factor normalized to 500 (no units). The Constant 514 is a constant units conversion factor to match the units of speed, path width, and time base.

[0079] The desired quantity data 502 is obtained from an application map, data representing the number of pulses from a sensor to dispense one cubic foot of desired product 504 may be obtained from the vehicle setup parameters, product density data 506 may also be obtained from an assignment map, vehicle speed data 508 may be obtained from a radar gun 405, path width data 510 may be obtained from the vehicle setup parameters, and a calibration factor 512 may be obtained from the vehicle setup parameters unique to the specific equipment in use. The preferred embodiment illustrated in FIG. 6 multiplies the aforementioned data to realize a desired rate 501 which is then scaled by a scaling factor to match the units of speed, path, width, and time base to achieve a desired rate of product dispersion from the computer controlled agricultural equipment 108 of interest.

[0080] Likewise, the same method may be employed to reconstruct the actual quantity of product spread by location based upon spread data from the various rate sensors and other sensors, including the radar gun 405 recorded by the controller 404 and transferred to the central control system 320. Thus, spread data based upon data collected from the various rate sensors coupled to various valves, motors, or other dispensing devices is coupled with location data to construct an “as spread” map. Preferably, the controller 404 software records the actual spread rate, the geographic position, and the time. As previously explained in relation to FIG. 3, spread data may be inputted into the GIS system 104 for use of precision farming and/or may be displayed electronically or in paper form as a report or map 106. The “as spread” map is georeferenced relative to the spread rate to correspond to the georeferenced spatial data of the GIS system 104.

[0081] In the agricultural industry, recommendations for field treatments are generally given for as set of nutrients and are uniform across the field. Commercially available materials (“commercial products”) are typically blended to match the recommended treatments and then uniformly applied across the field. The process of determining the commercially available material blend is called formulation. In precision agricultural, the recommended field treatments are not necessarily uniform, so the blend of commercially available materials and its application are not necessarily uniform. Precision agriculture uses variable rate application. The present inventive GIS system 104 will take one or more field treatments or application maps for a particular dispensing material and create one or more application prescriptions or product application maps for dispensing a commercial product based upon product information 224 of the GIS system 104.

[0082] This process of adapting treatment data for commercial products can more readily be understood and appreciated by reference to FIG. 7. The process utilized by the present invention combines recommendations for each predetermined/desired input and the chemical analysis for each commercially available product spatially and mathematically to output product application data. The output data format may be either in report or map form on paper or digital media, for example. The present inventions is not so limited, however, and it will be appreciated by those skilled in the art that other types of media also be utilized.

[0083] Looking now at FIG. 7, a diagram of the routine is illustrated. The recommendation data or application map 806 and 808 for treatment materials 802 or 804 represents the recommended amount of a field treatment determined by the system for a particular treatment material 802 or 804. This application data of the application maps 806 and 808 for the treatment materials 802 and 804 may vary across the field to reflect changes in soil properties and conditions that will affect crop growth. There are two input data sets or application maps 806 and 808 for treatment materials 802 or 804 depicted in FIG. 7, however, it shall be understood that there may be one or more input sets used in the present invention.

[0084] The commercially available products 224 include both commercially available products and pre-blended materials. Examples of these products would include, but not be limited to, diamonium phosphate (DAP), potash or urea. Each of these products contain a percentage of one or more field nutrients or treatment materials. The formulation software 252 contains routines necessary to read the recommended input data 806 and 808 for treatment materials 802, 804 and the commercially available agricultural product list 224. It also contains the mathematical and spatial routines to combine the input data 806 and 808 for treatment materials 802, 804 and product list 224 based on a set of instructions or rules given by an expert system 216 or user input 208.

[0085] This software 252 also has the routines to create product application maps 814 and 816 for controlling a dispensing apparatus of computer controlled agricultural equipment 108 in map or report form on paper or electronic media 106 as stated hereinbefore. As an example, the formulation software 252 may determine application rates for commercial product 810 and commercial product 812 based upon application maps 806 and 808 for treatment materials 802 and 804, respectively. In particular, the recommendation application data 814 and 816 for commercial product 810 and commercial product 812 represents the recommended amount and blend of products that are required for a given field treatment based on the instructions contained in the formulation software 252. The formulation software 252 formulates for each dispensing position commercial product dispensing rates based upon desired dispensing rates of the component nutrients as well as based upon cost and suitability for the crop and applicator. There are two product recommendation application maps 814 and 816 depicted in FIG. 7; however, it shall be understood that the present invention may include one or more such product application maps.

[0086] FIG. 8 illustrates storage and execution of recommendation equations 226. Recommendation equations 226 are stored in a database 206 and retrieved as illustrated by block 222 for execution. Recommendation equations 226 may be predefined equations or may be user inputted or defined as illustrated by block 208. The recommendation equations 226 are not stored compiled and accordingly, are compiled (i.e. parsed) as illustrated by block 902 for execution at block 216. Equations 226 are parsed at the time of creating precision farming application maps with the parsing module 1102 depicted in FIG. 10, derived from compiler theory of computer science known to those skilled in the art.

[0087] Generally, computer calculated agronomic recommendation equations may be coded into a software system before the software is compiled in a manner well known to those skilled in the art. Equations 226 are translated 225 into a programming language such as C or COBOL 227, for example, and linked to be part of the delivered software system 229. FIG. 9 illustrates this well known software system 1000. As shown in FIG. 9, recommendation equations 226 are pre-compiled prior to execution to create application maps 106 from input data 203 (i.e. attribute and geographic data 202 and 204). However, agronomic recommendations are irregular, complex and dynamic. Users often need to alter an existing equation(s) or even create their own, e.g. to match the characteristics of the particular machine or equipment of interest, as stated hereinbefore. Current methods, known to those skilled in the art, do not meet these needs. Since the recommendation equations 226 are pre-compiled users cannot alter the equations without recompiling the equations for execution. Thus, this restricts the flexibility of the system.

[0088] The present invention overcomes the shortcomings of prior art systems by providing a system and method of use which stores recommendation equations 226 as data in a database 206. One preferred embodiment illustrating the present inventive method allowing a user access to alter an existing recommendation equation(s) 226 or to create their own is illustrated by block 208 of FIG. 8. The stored recommendation equation data 226 is actually the knowledge of agronomists, which will hereinafter be referred to as knowledge-base. FIG. 10 illustrates the preferred system of the present invention. In the embodiment shown in FIG. 10, expert system 216 embodied within the system includes a parser module 1102 to understand the grammar of the equations 226, an interpreter module 1104 to drive the map making system, and a knowledge-base 206 to store user equations 226. The parser module 1102 splits the equation 226 text into a list of instructions 1106 similar to assembly language code known to those skilled in the art. This instruction set 1106 commands the operation of the interpreter module 1104 to generate the final output data or application maps 106 from input data 203 (such as attribute and geographic data 202 and 204). Typical functions of the instructions set 1106 include, but are not so limited to, getting data values from input data 203, performing mathematical operations on data value(s), storing results, and controlling flow commands for the present inventive processes illustrated in FIGS. 2 and 3.

[0089] The construction of the expert system 216 utilized by the present inventive GIS system 104 has some key components, which will now be described in detail. Preferably, a recommendation equation 226 is expressed in LL (1) grammar or its subset. In this way, the correctness is insured by the theory of compilers known to those skilled in the art of computer science. For example, a recommendation equation 226 could be expressed as:

[0090] P[0,17]+:

[0091] 300+(28.4−p)*4+(yield−150)*0.5+(21.4−p)*4−10+(17.5−p)*20;  1.

[0092] [17,max]+:

[0093] 300+(28.4−p)*4+(yield−150)*0.5+(21.4−p)*4−10  2.

[0094] This means that if the soil phosphorus test level is greater than 0 and less than 17, the output location specific instruction (i.e., for application map) 106 is based on the first equation, but not less than 0; and if the test level is equal to or greater than 17, the output 106 is based on the second equation but not less than 0.

[0095] The LL(1) grammar representative of the above recommendation equations could be expressed as:

[0096] The interpreter module 1104 is capable of using multiple input data sets 202 and 204. Preferably, actual user input data 202 and 204 is derived directly from the equation input variable set 226. Typical user input data 202 and 204 may include, by way of example, but is not so limited to, input maps such as yield goal maps based on soil properties or previous yield history, soil test nutrient level maps, and other soil and crop properties. The interpreter module 1104 repeatedly executes the instruction set throughout every data point in the input data set 202 and 204 to create application maps 106. It will be appreciated by those skilled in the art that the present invention is not so limited however, and that the recommendations may just as well be expressed with grammar other than LL(1) grammar or its subset, such that correctness is insured by the theory of compilers known to those skilled in such art.

[0097] FIG. 11 illustrates the data storage process illustrated generally in FIG. 3. As shown, agricultural data such as attribute data 202 and geographic data 204 is inputted at 102 and compressed 230 for data storage 206. The data may be retrieved at 222 for analysis or for manipulation by the expert system 216 as shown in FIG. 10 to produce output data 106 preferably in the form of application maps and reports. As shown in FIG. 11, these output maps 106 may be stored at 206 as illustrated by line 260 for further processing and use.

[0098] FIG. 12 illustrates a preferred embodiment of data storage for the GIS system of the present invention. Shown in FIG. 12 is the computer operator 1306, user interface 102, FSDB 1302, DBMS 1304, data storage 1307, CPU 1308, and RAM 1309. Geographic or spatial based data is preferably stored in a field spatial database 1302. A database management system 1304 interfaces with the field spatial database 1302 for data management based upon data attributes. FIG. 12 illustrates one preferred relationship between a user interface 102, a field spatial database (FSBD) 1302, and a conventional database management system (DBMS) 1304 such as a relational database, ISAM record manager or custom software for the present invention. User interface 102 allows communication between the computer system 104 and the user 1306. The FSBD 1302 is responsible for performing the spatial data management and all the spatial queries, e.g. depicted in FIG. 7. The DBMS 1304 is responsible for creating the database tables and the data attribute searches.

[0099] FIG. 13 illustrates one preferred method for reducing the time required for the GIS system computer 104 to access data as well as reducing the storage requirements for the data. Specifically, the FSBD 1302 has utilities to translate between an external standard format and an internal quad format for storing data. FSBD 1302 converts locations of geographical or spatial field data, such as sample points, field boundaries, and soil survey maps, from floating point type numbers into internal integer type numbers, preferably a linear quadtree, or quad format such as that presented in detail immediately hereinbelow.

[0100] Given a georeferenced point location in the form of a spherical coordinate system, expressed as a pair of floating point type numbers, e.g. (longitude and latitude) the first step in the method requires converting the floating point pair into an integer pair, e.g (x, y). Subsequently, the integer pair is converted into a single integer having doubled length via a bit-wise zip routine, for example. This results in a quad. Those skilled in the art will readily recognize and appreciate that the preferred conversion routine is a variation of the Morton running codes routine. This process can better be described and understood with reference to FIG. 13 by way of example as follows:

[0101] Given the point (45.1, 94.2) is a point on the earth, the integer pair can be represented simply as (451, 942) 1402. Following the conversion to integer pair 1402 format, the quad of the point is calculated as shown in FIG. 13, resulting in quad (0x7e45) 1404. Those skilled in the art will readily recognize and appreciate that the original floating point values can be calculated and reclaimed, if so desired, by performing the inverse of the aforementioned steps, e.g. a quad is un-zipped into two integers, one for latitude and one for longitude. These integers are then de-normalized into floating point type actual values of latitude and longitude.

[0102] FIG. 14 illustrates one embodiment for a method of using a field spatial database for retrieving soil samples for the present invention. As illustrated in FIG. 14 field data 1502a-nand 1504a-nrepresents geographical type mapped data 204 (i.e., spatial data) for a particular field based upon a field location. Each field attribute 1502a-n, 1504a-nis typically stored as shown relative to a particular field 1506, 1508 to which the data relates. In contrast with these known systems, FIG. 15 illustrates the field spatial database utilized by the present invention. As shown in FIG. 15, spatial field data 1602a-nand 1604a-nis not explicitly associated with a field 1506 and 1508. Instead, fields 1506 and 1508 and data 1602a-nand 1604a-nare stored in separate layers. The FSDB uses the field boundary data 212 to determine which samples are contained inside the field of interest based upon the quad format location information for the geographic data 1602a-nand 1604a-n.

[0103] The FSDB structure utilized by the present invention as illustrated in FIG. 15, has several advantages over the structures utilized by other precision agriculture database systems known in the art. These advantages support the other capabilities of the present invention to formulate reports and maps which can be used as inputs to control computer controlled agricultural equipment 108 and include, but are not necessarily limited to: 1) Soil sample records or spatial field data 1602a-n, 1604a-nneed not be renamed or regrouped when a field 1506 and 1508 is merged or subdivided; 2) Soil sample or spatial field data 1602a-n, 1604a-nwill continuously be valid even after a field 1506 and 1508 is removed; and 3) it is easy and flexible to analyze and to create reports on any combination of soil samples or spatial field data 1602a-n, 1604a-n.

[0104] One feature of the FSDB retrieves soil sample data or other geographic field data, as stated hereinbefore. The FSDB uses spatial queries keyed by the geometry of the field to get all samples or data inside a field of interest (i.e., 1506 and 1508). In one preferred embodiment 1600, this is accomplished by first retrieving the field perimeter from the DBMS 1304, either by name or other identifier. The DBMS 1304 passes the field perimeter name or identifier (i.e., 1506 or 1508) to the FSDB 1302 as a spatial key, or cookie-cutter, to acquire all the point records 1602a-nor 1604a-nthat fall within the field of interest 1506 or 1508. Finally, some sample or data points may be excluded from the return list based on the qualifiers specified by user(s), such as between the time and date the samples were taken.

[0105] FIG. 16 illustrates one preferred embodiment showing one method for storing yield monitor data 1702 in a field spatial database for the present invention. Yield monitor data 1702 relates to crop production data based upon field location as recorded by a yield monitor device after harvest. Yield data is helpful to assess future treatment plans. It is generally known in the art of precision agriculture, that yield monitor data 1702 can be voluminous and noisy. Storing such data directly into a database can be costly in terms of storage space and access time. The present invention utilizes the data storage method illustrated in FIG. 17 to improve the performance of yield monitor data 1702. The method includes processing the yield monitor data 1702 by smoothing it to remove noise and mathematically modeling 1704 the data into area coverage yield data 1706. Other routines known to those skilled in the art of programming and mathematically modeling can further break the modeled data 1706 into control points 1708. The control points 1708 can be stored in data storage 1709 such that the original yield data area coverage 1712 can be reproduced by retrieving 1711 the control points 1708 from storage 1709 and statistically modeling 1710 the control points 1708. According to one preferred embodiment for the present invention, either the yield data area coverage or the control points may be stored by the field spatial database (FSBD).

[0106] This invention has been described herein in considerable detail in order to comply with the Patent Statutes and to provide those skilled in the art with the information needed to apply the novel principles and to construct and use such specialized components as are required. However, while particular embodiments of the present invention have been described herein in detail, it is to be understood that various alterations, modifications and substitutions can be made therein without departing from the spirit and scope of the present invention, as defined in the claims which follow. For example, it will be appreciated that although the present invention will provide an optimum recommendation for a particular field, such a recommendation may be more costly than desired by an equipment user or group of users. In such instances, it would be desirable to reduce the recommendation cost by a desired percentage. The present invention will allow an economic balancing process to be performed on zones for a given field. The balancing process will show which pixels generate a higher return rate so that those zones having a poor return rate can be ignored or treated differently than those zones having the higher rate of return. In this way, it will be possible to utilize the optimum recommendation at a more desirable cost because the user(s) can reduce or alter the recommendations for pixels having poor return rates without harming the remaining field areas. This process will allow the equipment user(s) to regain what would have resulted in a higher cost to the user(s) from utilizing the optimum recommendations.

[0107] It will also be appreciated by those skilled the art that the present invention may find further useful application to spreading and application of products and chemicals in other industrial settings, e.g. on golf courses and roadways, as well as for various forestation purposes, for example.

[0108] It will further be appreciated by those skilled in the art that the present invention will be useful in spreading and application of all types of agricultural products, whether in liquid gaseous or solid form, and may include, but is not so limited to fertilizers, insecticides, herbicides and seeds, for example.

[0109] H:\PATFILE\A773-12.5\cleanspec2.wpd