E-Ecology Documentation and Guidance

The e-Ecology Virtual Laboratories represent a collaborative effort between the University of Amsterdam Institute for Biodiversity and Ecosystem Dynamics and SARA Computing to manage bird tracking data and develop tools for data exploration, analysis and visualization. This wiki is designed to facilitate access to the data and tools within the Virtual Laboratories and to provide a forum for collaboration.

Changes in the Database in 2014

Important In the summer of 2014 we have re-arranged the administrative part of UvA-BiTS (and e-Ecology) in the database. End users may have to adapt their programs the following way:

• The uva_*_limited views that used to exist in the gps schema are gone. Each of them should have been replaced with an equivalent ee_*_limited counterpart.
• The new ee_*_limited views show a superset of the same information as before, but enhanced with new project information.
• Some column names in the ee_*_limited views may differ from the previous views.
• There are new limited views:
  • gps.ee_project_limited: shows your projects' information
  • gps.ee_shared_*_limited: set of data you are able to see related to trackers that a project is sharing with a project you belong to
• Special attention: gps.uva_device_limited is now replaced by gps.ee_tracker_limited. For each tracker, you now see which project provides you access to that tracker.

Datasets

UvA-BiTS

Bird data collected with the UvA-BiTS Bird Tracking System

Note: We are continually working on improving UvA-BiTS services, including data processing and Virtual Lab functionality. In some cases, this has enabled us to extract more information from old GPS log files which is then incorporated into the database. These changes may result in slight differences when you reprocess historic data.

• e-Ecology data model
• UvA-BiTS Data Model - OLD
• Connecting to the UvA-BiTS database
• Useful Queries
• Queries for linking bird tracks to wind and flow data

FLYSAFE

Bird data created from weather radar data and bird migration models. Financed by the Royal Netherlands Air Force.

• Connecting to the Flysafe database
• Flysafe GPS Data Model
• Radar Data Model
• Wind Profile Data Model
• Fino1 Data Model

ENVIRONMENTAL DATA

• Weather Forecast Data (ECMWF)
• Elevation Data

Services

• Visualization Tools

UvA-BiTS KMZ Generator:

Produces kmz files of UvA-BiTS bird tracking data to be viewed in Google Earth.

BirdView:

Access meterological and radar data and overlay with GPS bird tracking data.

BirdSim:

More dynamic version of BirdView that allows the user to scroll through weather data in time and space.

FlySafe GPS Bird Track Generator:

Produce kmz files of ARGOS/GPS bird tracking data from the FlySafe project to be viewed in Google Earth.

• Annotation tables for uploading GPS annotation data into your own schema

• Dashboard: These web pages allow UvA-BiTS users to get an overview of the raw data files of GPS bird tracking devices.

Tracker files dashboard

• Bookkeeping: Description of tables related to FlySafe data processing and archiving.

Administration: Information about user rights and data processing tasks.

ToDo