| field |
comment |
| whole table |
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. |
| arch_lon_cnt |
Same as pat_lon_cnt but for archival tags. Should probably combine into something like ll_lon_cnt. |
| argosloc_percent |
The percent of Argos satellite passes that resulted in a calculated Argos position. |
| battfail_date |
If the battery failed before recovery what was the date? |
| bindownloaded |
Not generally used anymore. Was the tag successfully downloaded by the lab? |
| breedingstatus |
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 |
Not used anymore. Same as breedingstatus but subjectively created by Barb. Briefly used for qa/qc of breedingstatus. Candidate for deprecation. |
| clockdrift_bb |
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 |
Same as clockdrift_bb. |
| comments |
General comments. |
| dataavailable |
Not generally used anymore but potentially useful. |
| date_last_depth |
The last date of good time series depth data if there was sensor or battery failure. |
| date_last_etemp |
The last date of good time series external temperature data if there was sensor or battery failure. |
| date_last_itemp |
The last date of good time series internal temperature data if there was sensor or battery failure. |
| date_last_light |
The last date of good time series light data if there was sensor or battery failure. |
| date_last_lon |
The last date of good light level longitude data if there was sensor or battery failure. |
| dayslatitude |
Not used anymore. Basically the same as geolocation_days. Candidate for deprecation. |
| depthcorrection_eq |
The equation applied to times series data for depth correction. Generally run on time corrected data. |
| download_date |
The date the tag was downloaded. |
| downloadedby |
If the tag was recovered, who downloaded the data. |
| fgdkey |
This field should be called eventid. It is the same as the eventid field in all other tables. |
| findlats_outfile |
The name of the final/official findlats output file. |
| findlats_params |
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. |
| geo_daterange_days |
The number of days between the first and last findlats geolocation positions. |
| geolocated |
Has the data been run through findlats and a final/official version accepted? Yes = 1, no = 0, and will not be = 2. |
| geolocation_days |
A count of the number of days in the final/official findlats output. |
| gf_file |
No longer used. A reformatted version of the findlats output file. Candidate for deprecation. |
| gom_entry_date |
Atlantic bluefin specific. Not fully populated or used much. What date did the fish enter the Gulf of Mexico?. |
| gom_exit_date |
Same as gom_entry_date except applies to exit. |
| gom_fish |
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. |
| gpe3_meters_per_sec |
The speed filter setting used in GPE3. |
| gpe3_score |
The average observation score for the entire track. |
| gsl_entry_date |
Same as gom_entry_date except applies to Gulf of St Lawrence. |
| gsl_exit_date |
Same as gom_exit_date except applies to Gulf of St Lawrence. |
| lonfilter_deg |
No longer used. The longitude filter parameter from the official lab findlats output for the tag. Candidate for deprecation. |
| med_fish |
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. |
| mem_full_date |
Not currently used. It used to be common for archival tags to fill their memory during deployment. What date did this occur on? |
| mess_per_pass |
The average number of messages received per Argos pass. |
| minipat_ts_percent |
MiniPAT transmitted data specific. What percentage of the deployment has both depth and temperature time series data? |
| naturalmortality |
Does the data show the animal likely died at some point after deployment? Yes = 1 and no = 0. |
| no_pdt |
PAT tag specific. Is PDT data missing or corrupt? Yes = 1 and no = 0. |
| no_tad |
PAT tag specific. Is time at depth data missing or corrupt? Yes = 1 and no = 0, and duplicate dates where the data might be okay = 2. |
| no_tat |
PAT tag specific. Is time at temperature data missing or corrupt? Yes = 1 and no = 0, and duplicate dates where the data might be okay = 2. |
| no_ts |
Is the tag missing time series data? Yes = 1 and no = 0. Intended for archival tags (sampling rate <= 120 seconds) so generally will not be populated for transmit only tags. An exception could be when a transmitted time series file is converted to a CL/DC file to benefit processing. Since the resolution will be very coarse it is considered to have limited use. This tag would be marked Yes/1. A very short duration tagging mortality might also get marked Yes/1. |
| pat_lon_cnt |
How many light level longitudes did the tag produce within the deployment period? |
| percent_decode |
The percentage of successfully decoded Argos messages. |
| qc_breed |
Not used anymore. Atlantic bluefin quality control for breedingstatus field. Who chose the classification? Candidate for deprecation. |
| qc_track |
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 Marlin specific. |
| race_rank |
Marlin specific. What position in the race did the fish come in? |
| recv_battvolt |
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. |
| sat_passes |
The number of Argos satellite passes that detected the tag transmitting. |
| slopesea_fish |
Atlantic bluefine specific. Was the fish in the Slope Sea during breeding months?. |
| spawn_behavior |
Atlantic bluefin specific but could potentially apply to many species. Does the data show spawning behavior? Yes = 1 and no = 0. |
| spawn_dates |
One or more date/date ranges when data displays spawning behavior. |
| spawn_location |
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. |
| ssm_complete |
Has a Block lab SSM output been generated for this tag? Yes = 1 and no = 0, and will not be = 2. |
| ssm_tracklen_km |
Track length in kilometers of the SSM output. |
| ssm_tracklen_nm |
Track length in nautical miles of the SSM output. |
| ssm_version |
What version of the SSM produced the final/official track for this tag? |
| stock_class_type |
For ABFT only. How was the tag classified as a GOM/Med fish? The values are recovery, popup, track, acoustic or some combination. |
| straight_distance |
Marlin specific. What is the straight distance in nautical miles between the deployment and popup/recovery position? |
| tag_eaten |
Does the data show the tag was likely ingested at some point in the deployment? Yes = 1 and no = 0. |
| tagging_mortality |
Does the data show the tag went to the bottom soon, probably less than 2 weeks, after deployment? Yes = 1 and no = 0. |
| timezone_correction |
Time correction applied to UTC time series data when running CleanFirst. |
| toppid |
Same as toppid field in all other tables. |
| total_messages |
Total messages received through Argos including corrupt and duplicates. |
| transmit_days |
Satellite tag specific. How many days did the tag transmit after popup? |
| transpac |
Pacific bluefin specific but could potentially apply to other species. Did the fish cross the Pacific ocean? Yes = 1 and no = 0. |
| ts_sample_rate |
The sampling rate of the processed dataset. |
| writeup |
Not used much. Intended to track which papers a tag has been written up in. |