Table topp.public.tblsharkdeployment
This table contains deployment metadata from all satellite and acoustic tagged sharkgroup animals. Typically joins will be made to the sgdepkey, toppid or ptt fields. Important fields used as query filters are project, seriesname, taggingdate, and tagtype. 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
sgdepkey serial 10  √  nextval('tblsharkdeployment_sgdepkey_seq'::regclass) This field should be called eventid. It joins to sgdepkey in tblsharkrecovery, sgdkey in tblsgprocessingstatus and sgdepkey in tblsgmk10programming 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 representdeployment 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.
actpopdate text 2147483647  √  null I think this is the same as actpopdate in the recovery table. Completely unnecessary. Candidate for deprecation.
angler text 2147483647  √  null Who caught the shark to be tagged?
baittype text 2147483647  √  null What type of bait was used to catch the shark?
commonname text 2147483647  √  'unknown'::text Matches commonname in toppspecies table.
contag1number text 2147483647  √  null Serial number of first conventional tag.
contag1position text 2147483647  √  null Where on the shark was conventional tag 1 applied.
contag1type text 2147483647  √  null Generally either floy or hallprint.
contag2number text 2147483647  √  null Serial number of second conventional tag.
contag2position text 2147483647  √  null Where on the shark was conventional tag 2 applied.
contag2type text 2147483647  √  null Generally either floy or hallprint.
correctedsst text 2147483647  √  null The SST in celsius after applying sensor correction algorithm.
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.
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.
dnanumber text 2147483647  √  null What number is on the DNA vial.
dnasamplelocation text 2147483647  √  null What part of the shark was sampled for DNA.
darttype text 2147483647  √  null What type of dart was used, e.g., deck, nylon, OTS titanium.
deploycomment text 2147483647  √  null Generic comments field.
ew text 2147483647  √  null Deployment hemisphere where e is east and w is west.
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.
famename text 2147483647  √  null Looks like a duplicate of nickname. They should be merged and one of them deprecated.
fighttime text 2147483647  √  null Time in minutes to land the shark.
fishmethod text 2147483647  √  null How the animal was caught.
fishingdepth text 2147483647  √  null Another confusing field. Sometimes it gets bathymetric depth and sometimes depth of lure etc. 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?
handlingcomments text 2147483647  √  null How was the animal handled?
handlingtime text 2147483647  √  null Time in minutes from when the shark was brought to the boat until it was released.
hooktype text 2147483647  √  null What type of hook was used to catch the shark.
injuries text 2147483647  √  null What injuries happened to the shark during capture and/or tagging.
irrigation text 2147483647  √  null Was the shark irrigated during tagging?
leadtagger text 2147483647  √  null The person attaching the tag to the shark.
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.
leadertest text 2147483647  √  null The leader line test in pounds.
leadertype text 2147483647  √  null The material of the leader line.
len1 text 2147483647  √  null The length of the shark in centimeters.
len1type text 2147483647  √  null How was the shark length measured, e.g., CFL, SFL or TL.
len2 text 2147483647  √  null A second length measurement of the shark in centimeters.
len2type text 2147483647  √  null Same as len1type but for second measurement.
linetest text 2147483647  √  null Fishing line test in pounds.
loopnum 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 shark. What number is on the loop dart?
loopposition text 2147483647  √  null Where was the loop dart placed on the animal?
masstype text 2147483647  √  null How was the mass measurement taken, e.g., estimated, measured, LMDerived.
masskg text 2147483647  √  null The mass of the shark in kilograms.
ns text 2147483647  √  null Deployment hemisphere where s is south and n is north.
numberhooks text 2147483647  √  null Not used very often. If the shark was caught on a longline how many hooks were used?
prboattack text 2147483647  √  null This is white shark specific. Not sure but possibly a reference to a PRBO witnessed attack.
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.
psatleadernumber text 2147483647  √  null Block lab specific number on tag leader.
penetrationdepth text 2147483647  √  null Depth of the tagging dart in centimeters.
probe text 2147483647  √  null What probe was used to measure SST?
progdate text 2147483647  √  null Duplicated in programming table. The date the tag was programmed. Good candidate for deprecation.
progpopdate text 2147483647  √  null Duplicated in programming table. The date the tag was programmed to popup. Good candidate for deprecation.
pulltime text 2147483647  √  null Not used very often. If the shark was caught on a longline what time was the set pulled?
releasecomment text 2147483647  √  null For comments related to the release event, e.g., "Looked good going out the door.".
releasedevice text 2147483647  √  null This is a programming field. If the tag was equiped with a Wildlife Computers release device what model is it? Candidate for deprecation.
sst text 2147483647  √  null The sea surface temperature in degrees celsius.
seastate text 2147483647  √  null Description of ocean conditions like wave height.
seriesname text 2147483647  √  'unknown'::text Simple geographic desciptor of deployment locationincluding year.
setnumber text 2147483647  √  null Not sure about this field. Probably related to longlining.
setstarttime text 2147483647  √  null Not used very often. If the shark was caught on a longline what time was the line deployed?
settime text 2147483647  √  null Not sure about this field. Possibly the same as soaktime in tblsharkdeployment - how long was the longline left in the water?
sex text 2147483647  √  null Never used for shark. The sex of the shark where F = female, M = male and U = unknown.
sexmaturity text 2147483647  √  null Level of sexual maturity.
species text 2147483647  √  'unknown'::text Matches genus and species from toppspecies table.
tag2code text 2147483647  √  null The tagcode of the second tag if the shark was double-tagged.
tagapplocation text 2147483647  √  null Another confusing and unnecessary field. Candidate for deprecation.
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.
tageventcomment text 2147483647  √  null For comments related to the tagging event, e.g., "shark tagged itself. Beautiful implantation.".
tagposition text 2147483647  √  null Where on the shark was the tag placed?
tagteam text 2147483647  √  null Who was involved in the tagging event?
taggingdate text 2147483647  √  null Local date at deployment of tag.
taggingtime text 2147483647  √  null Local time at deployment of tag.
taggingvessel text 2147483647  √  null What boat did the tagging take place on?
transfercaptain text 2147483647  √  null Was a boat used to transfer the shark to the tagging boat? If so who was the captain of the boat?
weather text 2147483647  √  null General description of temperature and cloud cover.
tagnumber text 2147483647  √  'unknown'::text Manufacturer serial number of tag.
tag2ptt text 2147483647  √  null The Argos PTT number of the second tag if the shark was double-tagged.
tag2progdate text 2147483647  √  null Duplicated in programming table. The date the second tag was programmed if the shark was double-tagged. Good candidate for deprecation.
tag1side text 2147483647  √  null Similar to tagposition. Seems unnecessary. What side of the animal is tag 1 on?
tag2side text 2147483647  √  null Similar to tagposition. Seems unnecessary. What side of the animal is tag 2 on?
popup_comment text 2147483647  √  null This should be in the recovery table. Candidate for deprecation.
argosaccno text 2147483647  √  null Not used much. Duplicated in tbltmsat. The program number for owner of tag. Good candidate for deprecation.
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 shark. How many loops were used?
tagtype text 2147483647  √  'unknown'::text Generic description of tag type, e.g., satellite or acoustic.
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.
toppid int4 10  √  null The basic ID number for a specific animal deployment.Matches the first 7 digits of eventid.
animal_id serial 10  √  nextval('tblsharkdeployment_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.
nickname text 2147483647  √  'unknown'::text Specific to white sharks. Duplicated by famename. They should be combined and one deprecated.
fin_id text 2147483647  √  'unknown'::text Specific to white sharks. Identifies the best photo identification for the specific animal.
waterdepth text 2147483647  √  null The bathymetric depth of the water at deployment location.
sharkapp text 2147483647  √  null Specific to white sharks. Was this animal included in the Block lab shark app?
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.
bertarelli_name text 2147483647  √  null Specific to Chagos deploys. Nickname given to animal by the Bertarelli family.
stableiso_num text 2147483647  √  null What number is on the container with the stable isotope sample?
claspers text 2147483647  √  null Measurement of the claspers in centimeters.
len3 text 2147483647  √  null A third length measurement of the shark in centimeters.
len3type text 2147483647  √  null Same as len1type but for third measurement.
edna text 2147483647  √  null Was eDNA collected?
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,639 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
sgdepkey Primary key Asc tblsharkdeployment_pkey