Difference between revisions of "Usage"

From ecology
Jump to: navigation, search
(Uploading UvAGPS log files)
(Uploading UvAGPS log files using the Irods interface)
 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
== General ==
+
== 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.
  
== Database Issues ==
+
* [[ Connecting to the UvA-BiTS database ]]
  
 
* [[ Connecting to the Flysafe database ]]
 
* [[ Connecting to the Flysafe database ]]
Line 8: Line 9:
 
* [[ Useful Queries ]]
 
* [[ Useful Queries ]]
  
== Website Issues ==
+
* [[ Queries for linking bird tracks to wind and flow data ]]
  
== Various ==
+
* [[ Annotation tables ]] for uploading GPS anntotation data into your own schema
 
 
=== Uploading UvAGPS log files ===
 
 
 
 
 
* Goto [https://irods.grid.sara.nl/~ 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 our check that the uploaded files (and the ~/uvagps directory) alre also owned by the '''uvagps_parser''' user.
 
 
 
 
 
If the files have been processed data is loaded in the master database at '''services.flysafe.sara.nl'''. That database is not accessible for everyone.
 
 
 
The Mirror database on '''public.flysafe.sara.nl''' is being copied every night at 2:30 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'''.
 

Latest revision as of 13:15, 29 June 2012

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.