Tablename: trips
Electronic tag deployments and associated animal trip information is stored in this table.
| Field name | Field type | Field length | Field description |
|---|---|---|---|
| trip_id | integer | None | Unique record id number. | departure_datetime | timestamp without time zone | None | Date and time animal was first observed to leave tagging site after tagging, local time at tagging location. | departure_observation_type_id | integer | None | Link to observation_types table. | return_datetime | timestamp without time zone | None | Date and time animal was observed to return to recovery location, local time at recovery location. | return_observation_type_id | integer | None | Link to observation_types table. | start_gps_datetime | timestamp without time zone | None | Date and time to begin satellite tracking of PTTs. This field is not used anymore, the information is stored within etags table instead. | stop_gps_datetime | timestamp without time zone | None | Date and time to end satellite tracking of PTTs.This field is not used anymore, the information is stored within etags table instead. | tagging_start_sighting_id | integer | None | Animal sighting at the trip beginning. Link to sightings table. | tagging_recovery_sighting_id | integer | None | Animal sighting at the trip ending. Link to sightings table. | departure_location_id | character varying | 4 | Link to the locations table. Location of the tagging site. | return_location_id | character varying | 4 | Link to the locations table. Location of the tag recovery site if the animal have returned. | tagging_lat | double precision | None | Decimal latitude of tagging location. (May be more accurate than position of location in table locations if GPS was used in field.) | tagging_lon | double precision | None | Decimal longitude of tagging location. (May be more accurate than position of location in table locations if GPS was used in field.) | recovery_lat | double precision | None | Decimal latitude of tag recovery location. (May be more accurate than position of location in table locations if GPS was used in field.) | recovery_lon | double precision | None | Decimal longitude of tag recovery location. (May be more accurate than position of location in table locations if GPS was used in field.) | release_to_topp | boolean | None | “True” if this is a TOPP deployment, and metadata and tag data are to be released for access on TOPP web site. | ended | boolean | None | “True” if the trip has ended, regardless of whether tags were recovered. | deploy_id | character varying | 12 | Costa lab deployment code unique to this trip. 12 characters: 4 character species code(see table species column species_code), 4 digit serial number, 4 character deployment location code (see table locations column location_id). | topp_id | bigint | None | TOPP project deployment code unique to this trip, if applicable. 7 digit integer: 2 digit species code (see table species column topp_id_prefix), 2 digit deployment year, 3 digit serial number. | recovery_datetime | timestamp without time zone | None | Date and time of tags recovery. | recovery_location_id | character varying | 4 | Link to the locations table. | comments | character varying | 254 | Comments |