| field |
comment |
| whole table |
This table contains recovery metadata from all satellite and acoustic tagged sharkgroup animals. Typically joins will be made to the sgdepkey or toppid fields. Important fields are actpopdate, rdate, lab_recdate, tagrecovered, fish_recaptured, rdateestimated, and recpositionestimated. There are probably some unnecessary fields. All of the yes/no fields use 1 and 0 as their values and should be changed from type text to integer. All date fields should be converted from type text to date or timestamp. |
| actew |
Recovery hemisphere where e is east and w is west. |
| actns |
Popup hemisphere where s is south and n is north. |
| actpopdate |
The popup date of the tag. |
| actpoplat |
The decimal degree popup latitude. |
| actpoplon |
The decimal degree popup longitude. |
| auto_depth_released |
Did the tag release at a programmed max depth?True is 1, and false is 0. |
| fish_recaptured |
Was the animal recaptured as part of the recovery? |
| gender |
The sex of the recovered animal. Why is the name different than the archival recovery version? |
| lab_recdate |
What date did we learn about the recovery? Could also be ingestion date or record creation date. |
| mod_popdate |
This is the correct popoff date identified with tag data. Necessary when a tag floats at the surface failing to recognize popup. |
| mod_poplat |
The decimal degree latitude of geolocation from popdate_geoloc. |
| mod_poplon |
The decimal degree longitude of geolocation from popdate_geoloc. |
| pin_broken |
Did the leader retaining pin on the popup tag break? |
| poppositiontype |
Initially used to differentiate geolocation/modified popups from standard ones. Now also used to label tags that transmitted a date but 3 or less positions (possibly none). These are not real popups but have enough meaning for Barb that she wants them accounted for. These failed popups will be labeled as ghosts. |
| popup_lc |
The Argos location quality of the popup location. |
| popup_sst |
The SST at time of popup within 3 days or less. |
| prematurerelease |
Did the tag popup more than 7 days prior to the programmed popup date? |
| rconaddress |
Address of the recovery contact person. |
| rcontact |
Who informed us of the recovery? |
| rcontcomments |
Any additional information about the recovery contact. |
| rdate |
The date the animal is recaptured or tag is recovered. |
| rdateestimated |
Is the recovery date an estimate? |
| reclocation |
Generic geographic location of recovery. Not very useful. Possible candidate for deprecation. |
| recpositionestimated |
Is the recovery position estimated? |
| recvcomment |
General comments. |
| recvsourcename |
Name of the fishing vessel. |
| recvsourcetype |
Will generally be what type of fishing vessel caught the animal but can also be beachcomber, trap etc. |
| release_depth |
Depth in meters at tag release. |
| returnedtags |
A list of all recovered tags from this event. Not sure this is a good way to list individual tags. |
| reward_email |
The email address of the person who recoveredthe tag and received the reward. |
| reward_phone |
The phone number of the person who recovered the tag and received the reward. |
| rgirth |
The girth of the animal in centimeters. Why is the name different than the archival recovery version? |
| rinjuries |
Any injuries noted on the animal at the time of recapture. |
| rlatdd |
The decimal degree recovery latitude. |
| rlength |
The length of the animal in centimeters. |
| rlentype |
The type of length measurement, e.g., CFL, SFL or TL. |
| rlondd |
The decimal degree recovery longitude. |
| rmass |
The mass of the animal in kilograms. Why is the name different than the archival recovery version? |
| rmasstype |
What condition was the animal, e.g., whole, round, dressed. |
| rpaid |
Was the reward paid? Yes is 1 and no is 0. |
| rpaidto |
The name of the person who recovered the tag and receives the reward. |
| rsex |
The sex of the recovered animal. Duplicated by gender. These fields should be combined and one deprecated. |
| rsource |
Not used much. Unsure about this field. Candidate for deprecation. |
| rtagcomments |
Not used much. Unsure about this field. Candidate for deprecation. |
| rtagnumber |
The manufacturer serial number of the recovered tag. Not really necessary since it is duplicated in the deployment table. |
| ruemail |
Not sure about this field. Related to ruser. |
| ruphone |
Not sure about this field. Related to ruser. |
| ruser |
Not sure about this field. Not used much. |
| sgdepkey |
This field should be called eventid. It joins to sgdepkey in tblsharkdeployment, sgdkey in tblsgprocessingstatus as well as any other place eventid works for satellite or acoustic tags. |
| tagrecovered |
Was the tag returned to the Block lab or another location where the data could be downloaded? |
| toppid |
Same as toppid in deployment table. |