Table topp.public.tblfgprocessingstatus
This table contains data for tracking the status of recovered and/or popup tag data. Typically joins will be made to the fgdkey and toppid fields. The most common fields used to filter queries are med_fish, gom_fish, breedingstatus, qc_track, geolocated, ssm_complete, date_last_depth, date_last_etemp, date_last_itemp, date_last_light, no_pdt, no_tad, and no_tat. 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
fgdkey serial 10  √  nextval('tblfgprocessingstatus_fgdkey_seq'::regclass) This field should be called eventid. It is the same as the eventid field in all other tables.
tagnum text 2147483647  √  'unknown'::text
downloadedby text 2147483647  √  null If the tag was recovered, who downloaded the data.
download_date text 2147483647  √  null The date the tag was downloaded.
clockdrift_bb text 2147483647  √  null Difference in time between tag time and internet synchronized computer in seconds. Recorded during tag download. This field and clockdrift_other are duplicates and should be merged.
clockdrift_other text 2147483647  √  null Same as clockdrift_bb.
timezone_correction text 2147483647  √  null Time correction applied to UTC time series data when running CleanFirst.
depthcorrection_eq text 2147483647  √  null The equation applied to times series data for depth correction. Generally run on time corrected data.
date_last_light text 2147483647  √  null The last date of good time series light data if there was sensor or battery failure.
date_last_itemp text 2147483647  √  null The last date of good time series internal temperature data if there was sensor or battery failure.
date_last_etemp text 2147483647  √  null The last date of good time series external temperature data if there was sensor or battery failure.
date_last_depth text 2147483647  √  null The last date of good time series depth data if there was sensor or battery failure.
lonfilter_deg text 2147483647  √  null No longer used. The longitude filter parameter from the official lab findlats output for the tag. Candidate for deprecation.
findlats_params text 2147483647  √  null No longer used. Generally the longitude and latitude movement values, the search size and surface depth parameters from the official lab findlats output for the tag. These values need to be tracked somehow.
geolocated text 2147483647  √  '0'::text Has the data been run through findlats and a final/official version accepted? Yes = 1, no = 0, and will not be = 2.
gf_file text 2147483647  √  null No longer used. A reformatted version of the findlats output file. Candidate for deprecation.
comments text 2147483647  √  null General comments.
bindownloaded text 2147483647  √  '0'::text Not generally used anymore. Was the tag successfully downloaded by the lab?
dataavailable text 2147483647  √  '0'::text Not generally used anymore but potentially useful.
dayslatitude text 2147483647  √  null Not used anymore. Basically the same as geolocation_days. Candidate for deprecation.
recv_battvolt text 2147483647  √  null The battery voltage at recovery or failure if the battery died during deployment. Generally only noted for archival tags. We hardly ever use this data.
breedingstatus text 2147483647  √  'unknown'::text Atlantic bluefin breeding status classification. The values are Block lab specific. Gulf of Mexico = 1, neutral = 2, the Mediterranean = 3, and The Bahamas/West Atlantic = 4. Can be based on deployment, recovery or geolocation data.
breedingstatus_bb text 2147483647  √  'unknown'::text Not used anymore. Same as breedingstatus but subjectively created by Barb. Briefly used for qa/qc of breedingstatus. Candidate for deprecation.
qc_breed text 2147483647  √  'unknown'::text Not used anymore. Atlantic bluefin quality control for breedingstatus field. Who chose the classification? Candidate for deprecation.
qc_track text 2147483647  √  'unknown'::text Originally for Atlantic bluefin track quality control. Who approved the final/official track? Currently using a value of 2 to indicate the track should not be used in satellite tag report. This is currently Marlin specific.
mem_full_date text 2147483647  √  null Not currently used. It used to be common for archival tags to fill their memory during deployment. What date did this occur on?
tagging_mortality text 2147483647  √  '0'::text Does the data show the tag went to the bottom soon, probably less than 2 weeks, after deployment? Yes = 1 and no = 0.
spawn_behavior text 2147483647  √  '0'::text Atlantic bluefin specific but could potentially apply to many species. Does the data show spawning behavior? Yes = 1 and no = 0.
findlats_outfile text 2147483647  √  null The name of the final/official findlats output file.
naturalmortality text 2147483647  √  '0'::text Does the data show the animal likely died at some point after deployment? This could be from predatory behavior or any other reason. Yes = 1 and no = 0.
pat_lon_cnt int4 10  √  null How many light level longitudes did the tag produce within the deployment period?
ssm_complete text 2147483647  √  '0'::text Has a Block lab SSM output been generated for this tag? Yes = 1 and no = 0, and will not be = 2.
transmit_days int4 10  √  0 Satellite tag specific. How many days did the tag transmit after popup?
ssm_tracklen_km int4 10  √  null Track length in kilometers of the SSM output.
ssm_tracklen_nm int4 10  √  null Track length in nautical miles of the SSM output.
gom_fish text 2147483647  √  '0'::text Atlantic bluefine specific. Did the fish ever enter the Gulf of Mexico, passing west of 80 west longitude (Block lab standard)? Could be based on deployment, recovery or geolocation position. Almost duplicated by breedingstatus except this classification is meant to be more absolute. Yes = 1 and no = 0.
med_fish text 2147483647  √  '0'::text Atlantic bluefine specific. Did the fish ever enter the Mediterranean, passing east of 6 west longitude (Block lab standard)? Could be based on deployment, recovery or geolocation position. Almost duplicated by breedingstatus except this classification is meant to be more absolute. Yes = 1 and no = 0.
spawn_location text 2147483647  √  'unknown'::text Atlantic bluefin specific but could potentially apply to many species. General description of location, e.g., Eastern GOM or Western GOM, where data displays spawning behavior.
spawn_dates text 2147483647  √  'unknown'::text One or more date/date ranges when data displays spawning behavior.
toppid int4 10  √  null Same as toppid field in all other tables.
ssm_version text 2147483647  √  'unknown'::text What version of the SSM produced the final/official track for this tag?
geo_daterange_days int4 10  √  0 The number of days between the first and last findlats geolocation positions.
arch_lon_cnt int4 10  √  0 Same as pat_lon_cnt but for archival tags. Should probably combine into something like ll_lon_cnt.
writeup text 2147483647  √  'unknown'::text Not used much. Intended to track which papers a tag has been written up in.
battfail_date text 2147483647  √  null If the battery failed before recovery what was the date?
gom_entry_date text 2147483647  √  null Atlantic bluefin specific. Not fully populated or used much. What date did the fish enter the Gulf of Mexico?.
gom_exit_date text 2147483647  √  null Same as gom_entry_date except applies to exit.
gsl_exit_date text 2147483647  √  null Same as gom_exit_date except applies to Gulf of St Lawrence.
gsl_entry_date text 2147483647  √  null Same as gom_entry_date except applies to Gulf of St Lawrence.
transpac text 2147483647  √  '0'::text Pacific bluefin specific but could potentially apply to other species. Did the fish cross the Pacific ocean? Yes = 1 and no = 0.
minipat_ts_percent text 2147483647  √  null MiniPAT transmitted data specific. What percentage of the deployment has both depth and temperature time series data?
race_rank text 2147483647  √  null Marlin specific. What position in the race did the fish come in?
straight_distance int4 10  √  null Marlin specific. What is the straight distance in nautical miles between the deployment and popup/recovery position?
no_pdt text 2147483647  √  '0'::text PAT tag specific. Is PDT data missing or corrupt? Yes = 1 and no = 0.
no_tad text 2147483647  √  '0'::text PAT tag specific. Is time at depth data missing or corrupt? Yes = 1 and no = 0.
no_tat text 2147483647  √  '0'::text PAT tag specific. Is time at temperature data missing or corrupt? Yes = 1 and no = 0.
geolocation_days int4 10  √  0 A count of the number of days in the final/official findlats output.
tkey serial 10  √  nextval('tblfgprocessingstatus_tkey_seq'::regclass)
date_last_lon text 2147483647  √  null The last date of good light level longitude data if there was sensor or battery failure.

Table contained 2,040 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
fgdkey Primary key Asc tblfgprocessingstatus_pkey