Lesson 6.2: SEAMLESS Database

Icône de l'outil pédagogique Authors

Erling Andersen, Berien Elbersen

Icône de l'outil pédagogique Introduction

The final integrated database of SEAMLESS will contain all data used in the project including model input and output data, contextual data and spatial information for assessment and visualization of indicators. The database is implemented and managed in the open source object-relational database management system Postgres with an extension to handle geographical data using PostGIS and Geoserver[1]. It is expected that a Web Feature Service (WFS) will be used in the final version of the database to visualize model results.

In SEAMLESS the database is only planned to be accessed through the Graphical User Interface (GUI) of the SEAMLESS-IF. However, there will also be a stand-alone version of the database, which can be used for applications with specific components outside of SEAMLESS-IF. It is not foreseen to develop new tools for the stand-alone version of the database. Manuals on how to access the database, explore data and export data to other file formats will be based on existing tools such as PGadmin (free) of SQLmanager[2] (available at low cost).

Icône de l'outil pédagogique Database structure and content

The structure of the SEAMLESS database is based on different components: Schema, tables, fields, data types, primary keys, indexes, relations and constraints. The content of the SEAMLESS database is differentiated in parts of the database such as biophysical data, farm-type data etc. and the linkages between these. These data are collected at different scales within the EU27. An illustration of such a partial database schema is given underneath (Figure 1) and shows what type of information is available on subsidies, prices etc. at the regional and Member State level and what relations between the different data are included.

Icône de l'outil pédagogique Accessing the database and extracting data

To access the stand-alone database and extract data, knowledge of basic sql language is required. The SEAMLESS database has been used for several applications, but can in principle be used for a wide variety of experiments in the EU27 with the modelling framework of SEAMLESS-IF. Data can be stored in external formats such as text or excel files.

Figure 1. A partial database schema.

Régi par la licence Creative Commons Attribution Non-commercial Share Alike 3.0 License

copyright Seamless 2009