Table topp.public.tblsharkrecovery
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.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
tkey serial 10  √  nextval('tblsharkrecovery_tkey_seq'::regclass)
sgdepkey int4 10 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.
toppid int4 10  √  null Same as toppid in deployment table.
rtagnumber text 2147483647  √  'unknown'::text The manufacturer serial number of the recovered tag. Not really necessary since it is duplicated in the deployment table.
actpoplat float4 8,8  √  null The decimal degree popup latitude.
actns text 2147483647  √  null Popup hemisphere where s is south and n is north.
actpoplon float4 8,8  √  null The decimal degree popup longitude.
actew text 2147483647  √  null Recovery hemisphere where e is east and w is west.
returnedtags text 2147483647  √  null A list of all recovered tags from this event. Not sure this is a good way to list individual tags.
rdate date 13  √  null The date the animal is recaptured or tag is recovered.
reclocation text 2147483647  √  null Generic geographic location of recovery. Not very useful. Possible candidate for deprecation.
recvcomment text 2147483647  √  null General comments.
rcontcomments text 2147483647  √  null Any additional information about the recovery contact.
rsource text 2147483647  √  null Not used much. Unsure about this field. Candidate for deprecation.
rcontact text 2147483647  √  null Who informed us of the recovery?
rconaddress text 2147483647  √  null Address of the recovery contact person.
rpaid text 2147483647  √  '0'::text Was the reward paid? Yes is 1 and no is 0.
rpaidto text 2147483647  √  null The name of the person who recovered the tag and receives the reward.
rlength float4 8,8  √  null The length of the animal in centimeters.
rlentype text 2147483647  √  null The type of length measurement, e.g., CFL, SFL or TL.
rmass float4 8,8  √  null The mass of the animal in kilograms. Why is the name different than the archival recovery version?
rmasstype text 2147483647  √  null What condition was the animal, e.g., whole, round, dressed.
rgirth float4 8,8  √  null The girth of the animal in centimeters. Why is the name different than the archival recovery version?
rinjuries text 2147483647  √  null Any injuries noted on the animal at the time of recapture.
gender text 2147483647  √  null The sex of the recovered animal. Why is the name different than the archival recovery version?
rtagcomments text 2147483647  √  null Not used much. Unsure about this field. Candidate for deprecation.
rlatdd float4 8,8  √  null The decimal degree recovery latitude.
rlondd float4 8,8  √  null The decimal degree recovery longitude.
recvsourcetype text 2147483647  √  'unknown'::text Will generally be what type of fishing vessel caught the animal but can also be beachcomber, trap etc.
recvsourcename text 2147483647  √  null Name of the fishing vessel.
prematurerelease text 2147483647  √  '0'::text Did the tag popup more than 7 days prior to the programmed popup date?
fish_recaptured text 2147483647  √  '0'::text Was the animal recaptured as part of the recovery?
rdateestimated text 2147483647  √  '0'::text Is the recovery date an estimate?
recpositionestimated text 2147483647  √  '0'::text Is the recovery position estimated?
rsex text 2147483647  √  null The sex of the recovered animal. Duplicated by gender. These fields should be combined and one deprecated.
ruser text 2147483647  √  null Not sure about this field. Not used much.
ruphone text 2147483647  √  null Not sure about this field. Related to ruser.
ruemail text 2147483647  √  null Not sure about this field. Related to ruser.
pin_broken text 2147483647  √  '0'::text Did the leader retaining pin on the popup tag break?
mod_popdate text 2147483647  √  null This is the correct popoff date identified with tag data. Necessary when a tag floats at the surface failing to recognize popup.
actpopdate text 2147483647  √  null The popup date of the tag.
mod_poplat float8 17,17  √  null The decimal degree latitude of geolocation from popdate_geoloc.
mod_poplon float8 17,17  √  null The decimal degree longitude of geolocation from popdate_geoloc.
lab_recdate text 2147483647  √  null What date did we learn about the recovery? Could also be ingestion date or record creation date.
reward_phone text 2147483647  √  null The phone number of the person who recovered the tag and received the reward.
reward_email text 2147483647  √  null The email address of the person who recoveredthe tag and received the reward.
tagrecovered text 2147483647  √  '0'::text Was the tag returned to the Block lab or another location where the data could be downloaded?
popup_lc text 2147483647  √  null The Argos location quality of the popup location.

Table contained 427 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
sgdepkey Primary key Asc tblsharkrecovery_pkey
sgdepkey Must be unique Asc sgdepkey_unique