Usage

Working with the database directly

Users who have direct access to the database can retrieve retrieve data directly using Psql or PgadminIII, or from programming environments such as Matlab or R. The data in the database is stored in different tables to reduce redundancy. To get useful information, tables can be combined ('joined' in database terms) in queries. This section contains information of how to connect to the database, and when connected, how to combine tables in queries.

• Connecting to the UvA-BiTS database

• Connecting to the Flysafe database

• Useful Queries

• Queries for linking bird tracks to wind and flow data

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