UvA-BiTS Tracking Data

gps.ee_project_limited

Each row represents a project.

COLUMN_NAME	TYPE_NAME	IS_NULLABLE	DESCRIPTION
key_name	varchar	NO	Unique key name, with the form <species>_<place>
station_name	varchar	NO	Where the receiving station is
start_date	timestamp	NO	Project start date
end_date	timestamp	NO	Date at which the project is not relevant any more
description	text	YES	String for free description. Updatable by the user.
project_id	int8	NO	Project unique id. Included just to enable joins.
parent_id	int8	YES	Reference to the parent project in the hierarchy.

gps.ee_tracker_limited

Each row shows tracker details for all trackers that your projects allow you to see.

This view replaces the old gps.uva_device_limited.

COLUMN_NAME	TYPE_NAME	IS_NULLABLE	DESCRIPTION
device_info_serial	int8	NO	Serial number of the tracker
firmware_version	varchar	YES	String for firmware version
mass	numeric(4,2)	YES	Mass (in grams)
start_date	timestamp	NO	Date before which the device is not relevant
end_date	timestamp	NO	Date at which the device is not relevant any more
x_o	numeric(30,6)	YES	Accelerometer calibration: offset on the x (or surge) axis
x_s	numeric(30,6)	YES	Accelerometer calibration: sensitivity on the x (or surge) axis
y_o	numeric(30,6)	YES	Accelerometer calibration: offset on the y (or sway) axis
y_s	numeric(30,6)	YES	Accelerometer calibration: sensitivity on the y (or sway) axis
z_o	numeric(30,6)	YES	Accelerometer calibration: offset on the z (or heave) axis
z_s	numeric(30,6)	YES	Accelerometer calibration: sensitivity on the y (or heave) axis
tracker_id	int8	NO	Tracker unique id. Included just to enable joins.

gps.ee_individual_limited

Each row shows bird's details for all birds that your projects allow you to see.

This view replaces the old gps.uva_individual_limited.

COLUMN_NAME	TYPE_NAME	IS_NULLABLE	DESCRIPTION
ring_number	varchar	NO	Ring number.
species_latin_name	varchar	NO	Latin name of the species of the bird.
colour_ring	varchar	YES	String for ring colour.
sex	varchar	NO	Sex (M=male, F=female, X=unknown/unspecified)
mass	numeric(5,0)	YES	Mass (grams)
start_date	timestamp	NO	Date before which the bird is not relevant.
end_date	timestamp	NO	Date at which the bird is no longer relevant.
remarks	text	YES	Text for user remarks
individual_id	int8	NO	Bird unique id. Included just to enable joins.

gps.ee_track_session_limited

Each row shows track session's information for all track sessions that your projects allow you to see.

COLUMN_NAME	TYPE_NAME	IS_NULLABLE	DESCRIPTION
key_name	varchar	NO	The project that the track session belongs to.
device_info_serial	int8	NO	Serial number of the tracker this track session involves.
ring_number	varchar	NO	Ring number of the bird that this track session involves.
start_date	timestamp	NO	Date before which the track session is not relevant
end_date	timestamp	NO	Date at which the track session is not relevant any more
remarks	text	YES	Free text for comments
start_latitude	numeric(11,8)	NO	Latitude where the bird was tagged
start_longitude	numeric(11,8)	NO	Longitude where the bird was tagged
project_id	int8	NO	Reference to the project this track session belongs to. Included just to enable joins.
tracker_id	int8	NO	Reference to the tracker this track session involves. Included just to enable joins.
individual_id	int8	NO	Reference to the individual this track session involves. Included just to enable joins.
track_session_id	int8	NO	Unique identifier of the track session. Included just to enable joins.