Table topp.public.tblfgsatdeployments
This table contains deployment metadata from all satellite and acoustic tagged fishgroup animals. Typically joins will be made to the fgsdkey, toppid or ptt fields. Important fields used as query filters are project, seriesname, successful, taggingdate, tagmodel, tagtype and releasetype. This can be a confusing table. 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
fgsdkey serial 10  √  nextval('tblfgsatdeployments_fgsdkey_seq'::regclass) This field should be called eventid. It joins to fgsdkey in tblfgsatrecovery, fgdkey in tblfgprocessingstatus and fgsdkey in tblfgmk10programming as well as any other place eventid works for satellite or acoustic tags. It breaks down into several components. The first 2 digits are species ID. Digits 3 and 4 represent deployment year. Digits 5 - 7 count from 1 and represent individual animal deployments for the year. Digits 8 and 9 count from 0 and represent individual tags from the individual animal deployment.
angler text 2147483647  √  null Who caught the fish to be tagged?
argosaccno text 2147483647  √  null Not used much. Duplicated in tbltmsat. The program number for owner of tag. Good candidate for deprecation.
baittype text 2147483647  √  null What type of bait was used to catch the fish?
capcomments text 2147483647  √  null For comments related to animal capture, e.g., "Associated with Dolphins.".
capturevessel text 2147483647  √  null What vessel was used to capture the fish?
correctedsstc text 2147483647  √  null The SST in celsius after applying sensor correction algorithm.
commonname text 2147483647  √  'unknown'::text Matches commonname in toppspecies table.
contag1number text 2147483647  √  null Serial number of first conventional tag.
contag1type text 2147483647  √  null Generally either floy or hallprint.
contag1position text 2147483647  √  null Where on the fish was conventional tag 1 applied.
contag2number text 2147483647  √  null Serial number of second conventional tag.
contag2type text 2147483647  √  null Generally either floy or hallprint.
contag2position text 2147483647  √  null Where on the fish was conventional tag 2 applied.
dlatdeg text 2147483647  √  null The latitude degree value of deployment location.
dlatmin text 2147483647  √  null The latitude minute value of deployment location. Generally in decimal minute format.
ns text 2147483647  √  null Deployment hemisphere where s is south and n is north.
dlondeg text 2147483647  √  null The longitude degree value of deployment location.
dlonmin text 2147483647  √  null The longitude minute value of deployment locations. Generally in decimal minute format.
darttype text 2147483647  √  null What type of dart was used, e.g., deck, nylon, OTS titanium.
deploycomment text 2147483647  √  null Generic comments field.
daystartlat text 2147483647  √  null Only rarely used by ABFT. Latitude at start of deployment day. Candidate for deprecation.
daystartlon text 2147483647  √  null Only rarely used by ABFT. Longitude at start of deployment day. Candidate for deprecation.
daystartsst text 2147483647  √  null Only rarely used by ABFT. SST at start of deployment day. Candidate for deprecation.
daystarttimelocal text 2147483647  √  null Only rarely used by ABFT. Local time at start of deployment day. Candidate for deprecation.
dnasamplelocation text 2147483647  √  null What part of the fish was sampled for DNA.
dnanumber text 2147483647  √  null What number is on the DNA vial.
ease2boat text 2147483647  √  null Very confusing field of limited use. Sometimes it has a value like "Easy" or sometimes it is "Medium", but often it is fight time which already has its own field. Candidate for deprecation.
ew text 2147483647  √  null Deployment hemisphere where e is east and w is west.
fishingdepth text 2147483647  √  null Another confusing field. Sometimes it gets bathymetric depth and sometimes depth of lure etc. Candidate for deprecation.
fighttime text 2147483647  √  null Time in minutes to land the fish.
fishmethod text 2147483647  √  null How the animal was caught.
fdcomment text 2147483647  √  null Hardly ever used. Not sure of definition. Good candidate for deprecation.
gpsused text 2147483647  √  null What GPS was used to generate deployment location?
halfgirth text 2147483647  √  null What is the half girth measurement in centimeters?
handlingtime text 2147483647  √  null Time in minutes from when the fish was brought to the boat until it was released.
hooktype text 2147483647  √  null What type of hook was used to catch the fish.
linetest text 2147483647  √  null Fishing line test in pounds.
leadertest text 2147483647  √  null The leader line test in pounds.
leadertype text 2147483647  √  null The material of the leader line.
injuries text 2147483647  √  null What injuries happened to the fish during capture and/or tagging.
irrigation text 2147483647  √  null Was the fish irrigated during tagging?
localendtime text 2147483647  √  null Rarely used. Candidate for deprecation.
localssttime text 2147483647  √  null Rarely used. Candidate for deprecation.
localstoptime text 2147483647  √  null Rarely usded. Candidate for deprecation.
localtaggingdate text 2147483647  √  null Rarely used. Duplicated by taggingdate. Candidate for deprecation.
localtaggingtime text 2147483647  √  null Rarely used. Duplicated by taggingtime. Candidate for deprecation.
leaderlength text 2147483647  √  null This is a confusing field. Can be interpreted as either the length of the fishing line leader or the tag leader. It has been used for both. Should only be for fishing line leader. Probably needs to be renamed for clarification.
leadtagger text 2147483647  √  null The person attaching the tag to the fish.
len1 text 2147483647  √  null The length of the fish in centimeters.
len1type text 2147483647  √  null How was the fish length measured, e.g., CFL, SFL or TL.
len2 text 2147483647  √  null A second length measurement of the fish in centimeters.
len2type text 2147483647  √  null Same as len1type but for second measurement.
mass text 2147483647  √  null The mass of the fish in kilograms.
masstype text 2147483647  √  null How was the mass measurement taken, e.g., estimated, measured, LMDerived.
numberofhooks text 2147483647  √  null Not used very often. If the fish was caught on a longline how many hooks were used?
penetrationdepth text 2147483647  √  null Depth of the tagging dart in centimeters.
pullstarttime text 2147483647  √  null Not used very often. If the fish was caught on a longline what time did they start pulling in the set?
tagreleasecomment text 2147483647  √  null For comments related to the release event, e.g., "Looked good going out the door.".
progdate text 2147483647  √  null Duplicated in programming table. The date the tag was programmed. Good candidate for deprecation.
popoffdate text 2147483647  √  null Duplicated in programming table. What date is the tag programmed to popoff?
psatleaderno text 2147483647  √  null Block lab specific number on tag leader.
releasetype text 2147483647  √  'unknown'::text Generally not too important except in the case of PBFT released from a pen or into a pen only, e.g., Pen2wild or Pen.
seastate text 2147483647  √  null Description of ocean conditions like wave height.
seriesname text 2147483647  √  'unknown'::text Simple geographic desciptor of deployment location including year.
sex text 2147483647  √  null Never used for fish. The sex of the fish where F = female, M = male and U = unknown.
setstarttime text 2147483647  √  null Not used very often. If the fish was caught on a longline what time was the line deployed?
soaktime text 2147483647  √  null Not used very often. If the fish was caught on a longline how long was the line left in the water?
species text 2147483647  √  'unknown'::text Matches genus and species from toppspecies table.
sst text 2147483647  √  null The sea surface temperature in degrees celsius.
sstdate text 2147483647  √  null The date the SST was measured.
sstprobe text 2147483647  √  null The instrument used to measure SST.
sstalgorithm text 2147483647  √  null The sensor correction algorithm applied to the raw SST reading.
successful text 2147483647  √  '1'::text Was the deployment successful? Almost always true but there are some PBFT that died in pen before release. Yes is 1 and no is 0.
surgeryboat text 2147483647  √  null What boat did the tagging take place on?
tag2code text 2147483647  √  null The tagcode of the second tag if the fish was double-tagged.
tag2ptt text 2147483647  √  null The Argos PTT number of the second tag if the fish was double-tagged.
tag2progdate text 2147483647  √  null Duplicated in programming table. The date the second tag was programmed if the fish was double-tagged. Good candidate for deprecation.
tag2position text 2147483647  √  null Where on the fish was the second tag placed?
tagteam text 2147483647  √  null Who was involved in the tagging event?
transferboat text 2147483647  √  null Was a boat used to transfer the fish to the tagging boat? If so what was the name of the boat?
transfercaptain text 2147483647  √  null Was a boat used to transfer the fish to the tagging boat? If so who was the captain of the boat?
tagposition text 2147483647  √  null Where on the fish was the tag placed?
tageventcomment text 2147483647  √  null For comments related to the tagging event, e.g., "Fish tagged itself. Beautiful implantation.".
tagapplocation text 2147483647  √  null Another confusing and unnecessary field. Candidate for deprecation.
taggingdate text 2147483647  √  null Local date at deployment of tag.
taggingtime text 2147483647  √  null Local time at deployment of tag.
tagcode text 2147483647  √  'unknown'::text Serial number of tag with prefix identifying manufacturer and model. The prefix matches tagcode in tbltopptags. This prefix is unnecessary given the tagmodel field and will be deprecated in future.
weather text 2147483647  √  null General description of temperature and cloud cover.
project text 2147483647  √  'unknown'::text The group responsible for tagging, e.g., TOPP, GTOPP, NonTOPP, IGFA or TAG. Not a seriously important field but can be useful in queries.
tagmodel text 2147483647  √  'unknown'::text Should match model name in tbltmsat.
datesstcorrected text 2147483647  √  null Why is this important? Should be in processing table if anywhere. Candidate for deprecation.
tagtype text 2147483647  √  'satellite'::text Generic description of tag type, e.g., satellite or acoustic.
dlatdd float8 17,17  √  null Deployment latitude in decimal degrees.
dlondd float8 17,17  √  null Deployment longitude in decimal degrees.
loops text 2147483647  √  null The Block lab creates loop darts out of conventional tags and uses these loops to hold PAT tags close to the body of the fish. How many loops were used?
ptt int4 10  √  null The Argos PTT number for satellite tags. The transmitter ID code for acoustic tags. This is one of the main tag identification fields.
chaffing text 2147483647  √  null Not used much. Refers to tag leader construction. Should be in programming table if anywhere. Candidate for deprecation.
mrna_number text 2147483647  √  null What number is on the mRNA vial?
toppid int4 10  √  null The basic ID number for a specific animal deployment. Matches the first 7 digits of eventid.
tether text 2147483647  √  null Not used much. Not entirely sure about this one. Could refer to how closely the tag is riding against the body. The currently used values are loose and tight.
animal_id serial 10  √   √  nextval('tblfgsatdeployments_animal_id_seq'::regclass) This is a unique integer ID value for each animal. It is most relevant for animals that are tagged on multiple occasions. These taggings will have different toppids so the only way to identify them as the same animal is with some kind of common ID.
paint text 2147483647  √  null Rarely used. Should be in programming table if anywhere. What anti-fouling paint was used on the tag? Candidate for deprecation.
fish_num int4 10  √  null Specific to IGFA marlin. What is the number assigned to this fish from its particular race?
sponsor text 2147483647  √  null Specific to IGFA marlin. Who sponsored the tag?
stableiso_num text 2147483647  √  null What number is on the container with the stable isotope sample?
wc_id text 2147483647  √  null ID number used for accessing tag data on Portal.
deployloc_estimated int4 10  √  0 A yes/no field indicating the deployment lat and lon are estimated positions.

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

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