Table topp.public.tblfgsatrecovery
This table contains recovery metadata from all satellite and acoustic tagged fishgroup animals. Typically joins will be made to the fgsdkey or toppid fields. Important fields are actpopdate, rdate, lab_recdate, tagrecovered, fish_recaptured, rdateestimated, and recpositionestimated. There are probably some unnecessary fields. In particular there seem to be too many comment 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
fgsdkey serial 10  √  nextval('tblfgsatrecovery_fgsdkey_seq'::regclass) This field should be called eventid. It joins to fgsdkey in tblfgsatdeployments, fgdkey in tblfgprocessingstatus as well as any other place eventid works for satellite or acoustic tags.
rtagnumber text 2147483647  √  'unknown'::text The manufacturer serial number of the recovered tag. Not really necessary since it is duplicated in the deployment table.
actpopdate text 2147483647  √  null The popup date of the tag.
actns text 2147483647  √  null Popup hemisphere where s is south and n is north.
actew text 2147483647  √  null Recovery hemisphere where e is east and w is west.
rdate text 2147483647  √  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.
paid text 2147483647  √  '0'::text Was the reward paid? Yes is 1 and no is 0.
rewardperson text 2147483647  √  null The name of the person who recovered the tag and receives the reward.
rlength text 2147483647  √  null The length of the fish in centimeters. Why is the name different than the archival recovery version?
rlentype text 2147483647  √  null The type of length measurement, e.g., CFL, SFL or TL.
rmass text 2147483647  √  null The mass of the fish in kilograms. Why is the name different than the archival recovery version?
rmasstype text 2147483647  √  null What condition was the fish, e.g., whole, round, dressed.
rgirth text 2147483647  √  null The girth of the fish in centimeters. Why is the name different than the archival recovery version?
rinjuries text 2147483647  √  null Any injuries noted on the fish 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.
rcomments text 2147483647  √  null Not used much. Unsure about this field. Candidate for deprecation.
recvctag1 text 2147483647  √  null First recovered conventional tag.
rct1type text 2147483647  √  null First conventional tag type.
recvctag2 text 2147483647  √  null Second recovered conventional tag.
rct2type text 2147483647  √  null Second conventional tag type.
addrecvtags text 2147483647  √  null Any recovered tags that do not fit in other tag fields.
tagrecovered text 2147483647  √  '0'::text Was the tag returned to the Block lab or another location where the data could be downloaded?
recvlat text 2147483647  √  null Recovery latitude. Should be an integer.
recvlon text 2147483647  √  null Recovery longitude. Should be an integer.
ns text 2147483647  √  null Recovery hemisphere where s is south and n is north.
ew text 2147483647  √  null Recovery hemisphere where e is east and w is west.
recvsourcetype text 2147483647  √  'unknown'::text Will generally be what type of fishing vessel caught the fish 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?
poppositiontype text 2147483647  √  'unknown'::text Either geolocation or popoff. A tag gets a value of geolocation when it floats at the surface failing to recognize popup. All other tags are labeled popoff. This field is not necessary. Field popdate_geoloc achieves the same thing.
popdate_geoloc 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.
fish_recaptured text 2147483647  √  '0'::text Was the fish recaptured as part of the recovery?
actpoplat float8 17,17  √  null The decimal degree popup latitude.
actpoplon float8 17,17  √  null The decimal degree popup longitude.
rlatdd float8 17,17  √  null The decimal degree recovery latitude.
rlondd float8 17,17  √  null The decimal degree recovery longitude.
rdateestimated text 2147483647  √  '0'::text Is the recovery date an estimate?
recpositionestimated text 2147483647  √  '0'::text Is the recovery position estimated?
unknowndeploy text 2147483647  √  '0'::text There are some old ABFT recoveries where we never received the tag or tag number. We guessed at the possible deployment tags and gave them a value of 1 for this field.
lab_recdate text 2147483647  √  null What date did we learn about the recovery? Could also be ingestion date or record creation date.
rcon_phone text 2147483647  √  null Telephone number of the recovery contact person.
rcon_email text 2147483647  √  null The email address of the recovery contact person.
paid_comment text 2147483647  √  null Comments related to the reward payment.
rewardaddress text 2147483647  √  null The address of the person who recovered the tag and received the reward.
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 recovered the tag and received the reward.
paid_amount text 2147483647  √  null The dollar amount of the reward.
poplat_geoloc float8 17,17  √  null The decimal degree latitude of geolocation from popdate_geoloc.
poplon_geoloc float8 17,17  √  null The decimal degree longitude of geolocation from popdate_geoloc.
pin_broken text 2147483647  √  '0'::text Did the leader retaining pin on the popup tag break?
toppid int4 10  √  null Same as toppid in deployment table.
tkey serial 10  √  nextval('tblfgsatrecovery_tkey_seq'::regclass)
popup_lc text 2147483647  √  null The Argos location quality of the popup location.

Table contained 1,073 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
fgsdkey Primary key Asc tblfgsatrecovery_pkey