View topp.public.atn_deploy_rec_fgsg
This view creates a minimum dataset of fish and shark group deploy, recovery, processing and management metadata.

 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
eventid int4 10  √  null This is the basic ID number for a specific tag deployment. 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.
tagcode text 2147483647  √  null Serial number of tag with prefix identifying manufacturer and model.
tagnumber text 2147483647  √  null Serial number of tag from management table.
tagdate date 13  √  null Local date at deployment of tag.
end_date timestamp 29,6  √  null The earliest date of popup, recovery or modified popup - when a tag fails to identify the correct popup date.
tagmodel text 2147483647  √  null The model of tag from management table, e.g., miniPAT, SPOT5 or MK10.
commonname text 2147483647  √  null The common name value from toppspecies table.
genus text 2147483647  √  null The genus value from toppspecies table.
species text 2147483647  √  null The species value from toppspecies table.
lsdname text 2147483647  √  null The lsdname value from the toppspecies table. Should match speciesname in satdeployments.
toppid int4 10  √  null The basic ID number for a specific animal deployment. Matches the first 7 digits of eventid.
ptt int4 10  √  null The Argos ID number.
seriesname text 2147483647  √  null Simple geographic desciptor of deployment location including year.
dlatdd float8 17,17  √  null Deployment latitude in decimal degrees.
dlondd float8 17,17  √  null Deployment longitude in decimal degrees.
deplength text 2147483647  √  null Length of animal in centimeters at deployment.
deplen_type text 2147483647  √  null Type of length measurement, e.g., CFL, TL or PCL.
tagtype text 2147483647  √  null Generic tag descriptor, e.g., archival, satellite or acoustic.
reclon float8 17,17  √  null Longitude at tag recovery.
reclat float8 17,17  √  null Latitude at tag recovery.
poplon float8 17,17  √  null Longitude at tag popup.
poplat float8 17,17  √  null Latitude at tag popup.
modpoplon float8 17,17  √  null Longitude of modified popup date.
modpoplat float8 17,17  √  null Latitude of modified popup date.
rdateestimated text 2147483647  √  null Is the recovery date estimated? 0 for no and 1 for yes.
recpositionestimated text 2147483647  √  null Is the recovery position estimated? 0 for no and 1 for yes.
fish_recaptured text 2147483647  √  null Was the fish recaptured? 0 for no and 1 for yes.
reclength text 2147483647  √  null Length of animal in centimeters at recapture.
reclen_type text 2147483647  √  null Type of length measurement, e.g., CFL, TL or PCL.
geolocated text 2147483647  √  null Has the data been successfully run through findlats?.
ssm_complete text 2147483647  √  null Has the track data been successfully run through the state space model?.
ssm_version text 2147483647  √  null What version of the state space model was the track run through?.
findlats_outfile text 2147483647  √  null The name of the findlats output file.
wc_id text 2147483647  √  null ID number used for accessing tag data on Portal.

Analyzed at Wed Dec 27 13:25 PST 2017