Difference between revisions of "UvA-BiTS Tracking Data"
From ecology
(→gps.ee_individual_limited) |
(→gps.ee_individual_limited) |
||
| Line 65: | Line 65: | ||
|- | |- | ||
|individual_id||int8||NO||Bird unique id. Included just to enable joins. | |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. | ||
| + | |||
| + | {| class="wikitable" | ||
| + | ! 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. | ||
|} | |} | ||
Revision as of 17:09, 6 November 2014
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. |
