|
WUFMAS Database is designed to collect, store, and process data on investigating the use of irrigation water and management of agricultural objects, located in the five republics in the Aral Sea basin. The structure of the WUFMAS Database consists of the main WD information base, containing all database tables, and a range of control databases with forms, queries and reports. Working with the base begins from database “Start” file, which contains a form view with the menu of all database control files.
WUFMAS Database is divided into several functionally independent files such as WD.MDB, INPUT.MDB, VALIDAT.MDB, ANALIZ.MDB, ECONOMIC.MDB, and START.MDB with a view to rise information storage safety.
Hierarchical scheme of interaction between WUFMAS Project databases
In the initial stage of the WUFMAS Project, an information coding system was developed, which became the basis to create forms for field information collection that, in their turn, served as a prototype for developing database tables. The list of the main information groups used in “WUFMAS” Database is given in the table.
|
01
|
FARM CODES
|
|
02
|
FARM MACHINERY
|
|
03
|
FARM OPERATIONS
|
|
04
|
MANAGEMENT GRADES
|
|
05
|
SALINITY AND NATURAL SOIL DRAINAGE
|
|
06
|
CROP CODES
|
|
07
|
PRODUCTS FROM HARVEST
|
|
08
|
IRRIGATION EQUIPMENT AND SYSTEM
|
|
09
|
SEED TREATMENT
|
|
10
|
AGRO-CHEMICALS AND BIOLOGICAL CONTROL
|
|
11
|
TYPES OF FIELD WATER SUPPLY CANALS
|
Description of spatial and temporal levels of information
Farm level information:
Information, describing the characteristics of farm as a whole, pertains to farm level. For example, total area, irrigated area, number of houses on farm, farm demand for irrigation water and so on.
Field level information:
Information, describing events in concrete field, pertains to field level. For example, field area, planted crop, planting date, harvest date, applied pesticides and so on.
Registration plot level information:
To control data on field and conduct phenological observations in each field, registration (phenological) plots, located in four corners and center of field, were appointed. In these plots, harvest registration was conducted, groundwater level in the drilled wells was defined, soil and water sampling for chemical analyses was carried out, observations over plant development were conducted and so on.
Year level information:
Information collected under the WUFMAS Project along with spatial breakdown has also temporal scale. In particular, year level information describes observations, gathered once a year, as a rule, by April 1. For example, geographical coordinates of a farm, residents and number of houses, number and types of canals supplying water to farm and so on.
Month level information:
It is accepted to conduct part of agricultural production observations with monthly frequency. These are dynamics of manual labor use, pesticide and fertilizer application, and water use.
Current information:
Information collected by fact, i.e. with indication of registration date is of an operative value. As a rule, such information is bound to field or registration plot, and describes agricultural production process in a real time scale. For example, sowing, harvesting, applying pesticides and fertilizers and so on.
WUFMAS presentation: download [MS PowerPoint, 340 kB]
|
