Database contents and structure

At present, edaphobase contains data on Chilopoda, Collembola, Diplopoda, Enchytraeidae, Gamasina, Lumbricidae, Nematoda, and Oribatida, with a focus of distribution on Germany and neighbouring countries, but data from other European countries can be incorporated in the future, as well as data from further soil organism taxa such as Isopoda or Araneae.

The data model used for edaphobase is a combination of a conventional relational model and a modern entity-attribute-value (EAV) concept-based information system, implemented in the database-management system PostgreSQL (see figure below). The information system is highly modularized, and the use of the EAV concept renders the model further flexibility, so that future additions or applications can be programmed without the necessity of major changes in the program code. A desktop client is used for data input and management, while queries and analyses are performed via a web portal; both modules use the same data basis of the edaphobase information system.

edaphobase pursues the following key objectives:
To combine collection data based on modern taxonomic thesauri with data on geographical references, ecological indices, soil composition, vegetation, meteorological data, sampling and extraction methods, quantities of collected organisms, methods of determination, preparation techniques and biological data of the species.
To allow simple data queries (e.g. distribution maps) as well as more sophisticated analyzes of different data groups with regard to, e. g. geographic distribution preferences and tolerances of individual species in relation to specific niche parameters, or the effects of anthropogenic disturbance.
To provide long-term study data for monitoring purposes.
To include additional partners in Germany and abroad and to integrate them into the data network.

Currently, prognostic tools are developed for evaluation of soil zoological reference values ​​for monitoring programs, or for identification of changes in soil animal communities in response to, e. g., changes in land-use systems and the effects of climate change.

For more information on the edaphobase

User Manual Query Portal (in German)
Quick Guidance Manual Query Portal (in English)
User Manual Input Client (in German)
Informational attributes
Selection lists

System requirements

System requirements Edaphobase client

Operating system that supports Java (eg. Microsoft Windows 2000/Windows Server 2003 or newer, Mac OS X, up-to-date Linux distribution) 32bit/64bit
Java (Java 6 or higher) runtime environment (can be supplied for Windows)
(Broadband) Internet connection (for connection to server)

System Requirements for Edaphobase portal

Up-to-date internet browser (Mozilla Firefox, Google Chrome, Opera, Apple Safari, Microsoft Internet Explorer, version 10 or newer)
(Broadband) Internet connection (for connection to server)

General information regarding data input

The display of individual information fields can be (de-)activated according to the specific user’s preferences and needs
Decimal numbers are written with a “comma” (German mode) or point (English mode)
Entry in numerical fields can be as an exact value, mean value, standard deviation, reference, minimum, maximum or text
Always give additional comments, changes or interpretations of entered Editor in square brackets
For text only: multiple inputs always separated by a semicolon “;”