UvA-BiTS Tracking Data - Revision history

Stacy shinneman: /* Data processing and filtering */

2021-01-22T09:35:49Z

‎Data processing and filtering

2021-01-22T09:06:49Z

‎gps.ee_tracking_speed_limited

2021-01-21T16:57:21Z

‎gps.ee_track_session_limited

2021-01-21T16:56:59Z

‎gps.ee_nest_limited

2021-01-21T16:56:33Z

‎gps.ee_tracking_speed_limited

2021-01-21T15:55:03Z

‎gps.ee_track_session_limited

2021-01-21T15:53:41Z

‎gps.ee_tracking_speed_limited

2018-02-20T14:14:00Z

2018-02-20T14:13:34Z

‎Tracking data

2018-02-09T15:14:30Z

‎Sharings

@@ Line 709: / Line 709: @@
 . If the data has an invalid signature. For example, if a certain data format (eg numeric) or number of values (eg 4 digits) is expected but not returned, this record is not stored in the database.
-When a line is deleted, the log file name, line number and the type of error is stored in the table gps.uva_warning102
+When a line is deleted, the log file name, line number and the type of error is stored in the table gps.uva_warning102.
 == Information about GPS receivers ==

@@ Line 7: / Line 7: @@
 Shows the tracking data that your projects allow you to see.
-Each row represents a GPS fix as it is interpreted from the data that comes via the GPS tracker, plus it adds speeds.
+Each row represents a GPS fix as it is interpreted from the data that comes via the GPS tracker, plus it adds speeds. See [[Reference systems for GPS coordinates and altitudes]] for further details.
 It replaces old views gps.uva_tracking_limited, gps.uva_tracking_speed_3d_limited and gps.uva_tracking_speed. This table structure has ''not'' changed with respect to our previous database.

@@ Line 328: / Line 328: @@
 |remarks||text||YES||Free text for comments
 |-
-|start_latitude||numeric(11,8)||NO||Latitude where the bird was tagged, decimal degrees (WGS1984 Ellipsoid)
+|start_latitude||numeric(11,8)||NO||Latitude where the bird was tagged, decimal degrees (WGS84 datum)
 |-
-|start_longitude||numeric(11,8)||NO||Longitude where the bird was tagged, decimal degrees (WGS1984 Ellipsoid)
+|start_longitude||numeric(11,8)||NO||Longitude where the bird was tagged, decimal degrees (WGS84 datum)
 |-
 |project_id||int8||NO||Reference to the project this track session belongs to. Included just to enable joins.

@@ Line 194: / Line 194: @@
 |reference_name||varchar||NO||A string with a useful reference for you. We recommend its being unique for each nest in a project, but the system does NOT enforce it.
 |-
-|latitude||numeric||YES||Latitude of the coordinates where the nest was found, decimal degrees.
+|latitude||numeric||YES||Latitude of the coordinates where the nest was found, decimal degrees (WGS84 datum)
 |-
-|longitude||numeric||YES||Longitude of the coordinates where the nest was found, decimal degrees.
+|longitude||numeric||YES||Longitude of the coordinates where the nest was found, decimal degrees (WGS84 datum)
 |-
 |start_date_time||timestamp||NO||When the nest was spotted.

@@ Line 21: / Line 21: @@
 |date_time||timestamp||NO||Time when the fix was taken. UTC (i.e.: no timezone). Part of the unique identifier of the GPS fix.
 |-
-|latitude||float8||YES||Latitude of the GPS fix, decimal degrees (WGS1984 Ellipsoid)
+|latitude||float8||YES||Latitude of the GPS fix, decimal degrees (WGS84 datum)
 |-
-|longitude||float8||YES||Longitude of the GPS fix, decimal degrees (WGS1984 Ellipsoid)
+|longitude||float8||YES||Longitude of the GPS fix, decimal degrees (WGS84 datum)
 |-
-|altitude||int4||YES||Altitude above sea level measured by GPS tag in meters (WGS1984 Ellipsoid)
+|altitude||int4||YES||Altitude above sea level measured by GPS tag in meters (WGS84 datum)
 |-
 |pressure||int4||YES||Pressure measured by GPS tag sensor in Pascals

← Older revision	Revision as of 14:14, 20 February 2018
(No difference)

← Older revision		Revision as of 14:13, 20 February 2018
Line 1:		Line 1:
−	== Tracking ~~data~~ ==	+	== UvA-BiTS Tracking Data ==

	'''Note:''' These views will show no rows for trackers not yet attached to birds.		'''Note:''' These views will show no rows for trackers not yet attached to birds.

@@ Line 677: / Line 677: @@
 ** ''gps.''ee_shared_acc_start_limited: acceleration start information, during the shared period, for trackers shared
 ** ''gps.''ee_shared_acceleration_limited: acceleration information for trackers shared
-* ''Meta'' data
+* Metadata
 ** ''gps.''ee_shared_tracker_limited: information about each shared tracker
 ** ''gps.''ee_shared_individual_limited: information about birds with shared trackers