Home > Geospatial Application Papers > Agriculture & Soil > Crop Production

Overview | Crop Production | Crop Pattern | Crop Yield | Irrigation | Soil Management | Precision Farming | Relevant Products | Relevant Links




Agricultural Management through Web GIS: The Catalan Vineyard Register



The key: a vineyard database integrated with cartography
The new geodatabase was build on Oracle 9i/ArcSDE, and included the following layers of cartographic information:
  • A catalogue of orthophotographs in ECW format of the entire Catalan region, at scales of 1:5,000 (colour), 1:5,000 (black and white) and 1:25,000 (colour).
  • Topographic cartography, at scales of 1:50,000 and 1:250,000, of the entire Catalan region, including hydrography, toponymy, roads and contours.
  • 20x20, 100x100 and 200x200 digital land models.
  • Cadastral plots with their respective coding.
  • Vine-growing plots, obtained on the basis of a bulk digitalisation process.
Alongside the cartography, the GIS also maintains all the attribute data related to the vineyard sector in the region. This inventory, with more than 90.000 elements new CVR manages and maintains a unified, redundancy-free vineyard database, the main nucleus of information of which is the inventory of vine-growing plots. Each and every one of the vine-growing plots that exists in Catalonia (approximately 90,000) is registered in this inventory, along with its corresponding administrative data (e.g. land ownership, vineyard ownership, tenancy system, ownership of rights, etc.), its agronomic characteristics (e.g. variety, type of irrigation, year of plantation, stock, planting distance, type of piping, number of vines, soil type, condition, etc.) and its geographical attributes (declared surface areas and measurements on the cartography, perimeter of the plot, linked land register plots, etc).

In addition to vine-growing plots, the vineyard register also holds information on currently applicable and historical rights, linked people and institutions (such as plant owners (vine growers), land owners, holders of rights, cooperatives, wine cellars and regulatory councils) and the grape quantities declared by each vine grower on the basis of a register of the results of weighing. All details are updated on the basis of operations resulting from the requests made by vine growers in regional centres or via the internet. This information is thus dynamic in time, a property that gives the new CVR one of its main added values, namely the possibility of quickly consulting and analysing historical information as regards both vine-growing plots and transfers of rights. The historical record offers the possibility of retrieving the geometry of a vine-growing plot on a given date in the past, which enables a plot’s cartographic evolution to be recreated on a time line.

When GIS helps
The GIS is a transverse information system that allow the DARP technical staff (approximately 1,000) to view, consult and perform simple analyses on the cartography of any type of agricultural information. The main functions to which users have access in relation to the vineyard register are as follows:
  • Instantaneously locating vine-growing plots in the Catalan region.
  • Obtaining measurements of the perimetric lengths and surface areas of vine-growing plots.
  • Drawing new vine-growing plots, in a manner that is integrated with the making of requests and declarations.
  • Performing of editing operations on existing vine-growing plots (aggregation, segregation, modification of vertices, etc.).
  • Accompanying of requests with a map showing the location of the plot affected by vineyard uprooting or plantation.
  • Performing of comparative studies of the plots in a specific area, based on their variety, year planting or condition. Groups with similar characteristics are visually identified by means of different colours.
  • Restoring a plot’s outline, as registered during fieldwork by means of GPS terminals, directly on the cartography.
The attribute data is maintained trough a set of guided workflows, that permit to update information related to vineyard inventories (vine-growing plots, rights, grape-weighing results, linked people and institutions, etc.) but also for the straightforward management of requests, integrated with the cartography.


Figure 2: Searching a municipality with vineyard plots

A helpful system for the vineyard sector
The CVR integrated with GIS has different type of user profiles:
  • Technicians from regional centres of the DARP, who may process vine-growing plots, draw them on the cartography and provide information on their attributes. They can also control is surfaces declared by the vine growers, matching them with orthoimages.
  • Vine growers, who may consult information related to the vine-growing plots that they own and/or in which they have plants. They may also print out a detailed vineyard file for each plot, along with a map showing its location. Most of all, vine growers can declare through the internet how many vineyard acres they are going to plant or uproot, and to confirm whenever the work has been carried out.
  • Technicians from regulatory councils, who may begin proceedings corresponding to requests for uprooting, new plantations, modifications, transfers of rights, etc. for the vine-growing plots in their area, in addition to making the cartographic modifications associated with such plots.

Figure 3: the GIS viewer of the Catalan Vineyard Register

Conclusions
During its first year of operation, the CVR had a monthly average of 2.000 requests for updating information (uprooting, plantation, transfer of rights, etc.). Aside from the benefits in terms of improved management referred to above, the aspects that users value most highly are the standardisation of data and the possibility of obtaining statistics and reports, along with the management of historical records. The integration of the register with the GIS has made it possible to locate and view any vine-growing plot on the cartography, on the basis of the plot’s code, owner, vine grower or associated proceedings, as well as to check declared surface areas during edition.

Page 2 of 2
| Previous |