Usage - Revision history

Lyklev: /* Uploading UvAGPS log files using the Irods interface */

2012-06-29T13:15:29Z

‎Uploading UvAGPS log files using the Irods interface

2012-02-06T17:13:42Z

‎Working with the database directly

2011-11-03T08:19:18Z

‎General

2011-11-03T08:18:56Z

‎Website Issues

2011-11-03T08:18:37Z

‎Various

2011-11-02T09:19:10Z

‎Working with the database directly

2011-10-24T15:46:56Z

‎Working with the database directly

2011-10-24T15:44:21Z

‎Database Issues

2011-10-20T09:55:20Z

‎Database Issues

2010-12-09T12:36:29Z

‎Uploading UvAGPS log files

← Older revision		Revision as of 13:15, 29 June 2012
Line 12:		Line 12:

	* [[ Annotation tables ]] for uploading GPS anntotation data into your own schema		* [[ 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/~ 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'''.

← Older revision		Revision as of 17:13, 6 February 2012
Line 2:		Line 2:

	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.		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 ]]		* [[ Connecting to the Flysafe database ]]

← Older revision		Revision as of 08:19, 3 November 2011
Line 1:		Line 1:
−	~~== General ==~~
−
−
	== Working with the database directly ==		== Working with the database directly ==

← Older revision		Revision as of 08:18, 3 November 2011
Line 13:		Line 13:

	* [[ Annotation tables ]] for uploading GPS anntotation data into your own schema		* [[ Annotation tables ]] for uploading GPS anntotation data into your own schema
−
−	~~== Website Issues ==~~
−

	== Uploading UvAGPS log files using the Irods interface ==		== Uploading UvAGPS log files using the Irods interface ==

← Older revision		Revision as of 08:18, 3 November 2011
Line 16:		Line 16:
	== Website Issues ==		== Website Issues ==

−	~~== Various ==~~

−	=== Uploading UvAGPS log files ===	+	== Uploading UvAGPS log files using the Irods interface ==

← Older revision		Revision as of 09:19, 2 November 2011
Line 3:		Line 3:

	== Working with the database directly ==		== 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 ]]		* [[ Connecting to the Flysafe database ]]

← Older revision		Revision as of 15:46, 24 October 2011
Line 9:		Line 9:

	* [[ Queries for linking bird tracks to wind and flow data ]]		* [[ Queries for linking bird tracks to wind and flow data ]]
		+
		+	* [[ Annotation tables ]] for uploading GPS anntotation data into your own schema

	== Website Issues ==		== Website Issues ==

@@ Line 2: / Line 2: @@
-== Database Issues ==
+== Working with the database directly ==
 * [[ Connecting to the Flysafe database ]]
 * [[ Useful Queries ]]

@@ Line 25: / Line 25: @@
 * 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 nothing happens within an hour check that the uploaded files (and the ~/uvagps directory) are 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 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'''.