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 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

Uploading UvAGPS log files using the Irods interface

• Goto https://irods.grid.sara.nl/~

• Goto the uvagps directory

• Upload your UvAGPS files logfiles or zipped logfiles directly in that directory

• If the files have been processed correctly they are moved to the ~/uvagps/processed directory

• If the processing failed they are moved to the ~/uvagps/failed directory, together with a error log.

• If nothing happens within an hour check that the uploaded files (and the ~/uvagps directory) are also owned by the uvagps_parser user.

The files should be processed every hour. If the files have been processed the data is loaded in the master database at services.flysafe.sara.nl. That database is not accessible for everyone.

The data is being copied to the mirror database on public.flysafe.sara.nl every night at 2:30 (Amsterdam time) if new files haven been processed, so it can take a day before the uploads of your files are visible on public.flysafe.sara.nl.