17218
AFSC/ABL: Longline Sablefish Survey
AFSC/ABL: Longline Sablefish Survey
Data Set
Published / External
12324
Auke Bay Laboratories
Project
In Work
Unknown
Data is available from annual bottom longline surveys conducted cooperatively by Japan (1979-1994) and the U.S. National Marine Fisheries Service, Alaska Fisheries Science Center (1988-present). Starting in 1988, the U.S. started conducting the survey, creating overlap between the two countries between1988-1994. Since 1994, the U.S. has conducted the survey independently. Stations are spaced systematically (~20-30 km apart) along the slope from the eastern Gulf of Alaska west to the Aleutian Islands and north into the eastern Bering Sea. At each station, depths from ~150-1000 meters are sampled. Each year the captain attempts to set the gear along the same path. The same stations are sampled each year except in the Aleutian Islands and the Bering Sea, which are sampled every other year at the beginning of the survey (last week of May-early June). Since 1995, in odd years the Bering Sea stations are sampled and in even years the Aleutian Islands are sampled. The status of each hook is recorded. Lengths are taken from major species including, sablefish, giant grenadier, Pacific grenadier, Greenland turbot, arrowtooth flounder, Pacific cod, shortspine thornyhead, and all rockfish caught.
This dataset contains the data from the longline sablefish survey from 1988 to present.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
The following FGDC sections are not currently supported in InPort, but were preserved and will be included in the FGDC export:
- Taxonomy (FGDC:taxonomy)
Theme
ISO 19115 Topic Category
biota
Theme
Groundfish
Theme
Sablefish
Theme
abundance
Theme
ages
Theme
lengths
Theme
longline survey
Auke Bay Laboratories
Juneau
AK
US
Data Set
Database
Annually
maps or data
The user is responsible for the results of any application of this data for other than its intended purpose.
Japan Fisheries Agency; AFSC
unknown
unknown
unknown
27265
Ages
Ages
Published / External
In Work
Since 1996 sablefish have been randomly sampled throughout each set for ageing. For samples from 1996-present, maturity, length, weight, and sex is available for all sampled fish. Specimen are then sub-sampled for age reading and so ages are available for only a subset of these fish. This tableincludes data from sablefish that had their otoliths sampled for aging, but were not always aged.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Since 1996 sablefish have been randomly sampled throughout each set for ageing. For samples from 1996-present, maturity, length, weight, and sex is available for all sampled fish. Specimen are then sub-sampled for age reading and so ages are available for only a subset of these fish. This tableincludes data from sablefish that had their otoliths sampled for aging, but were not always aged.
Age_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Cruise_Station_ID
Unknown
No
No
Active
Auto generated
No domain defined.
specimen_number
Unknown
No
No
Active
ID assigned to each specimen. Not unique (start at 1 every year).
No domain defined.
depth_stratum_id
Unknown
No
No
Active
Depth stratum code (1-8)
No domain defined.
species_code
Unknown
No
No
Active
RACE species codes
No domain defined.
sex
Unknown
No
No
Active
m or f
No domain defined.
age
Unknown
No
No
Active
age in years, subsampled from otoliths taken at each station
No domain defined.
maturity
Unknown
No
No
Active
maturity code (1-6)
No domain defined.
length
Unknown
No
No
Active
length in cm
No domain defined.
weight
Unknown
No
No
Active
round weight in kg
No domain defined.
error_flag
Unknown
No
No
Active
Numerical value described under ErrorDescription.
No domain defined.
notes
Unknown
No
No
Active
Incomplete specimen if missing length, weight, or sex; Above Standard or Below Standard if residual is larger or smaller than a threshold value indicating that the weight is out of the normal range for the sablefish length-weight relationship (selects ~ 2 specimen per year); No Error if there is no missing data and length-weight combination is reasonable.
No domain defined.
residual
Unknown
No
No
Active
Deviation from fit to sablefish length-weight data. See document on Flagging Specimen data for details.
No domain defined.
27266
AgesErrorFlags
AgesErrorFlags
Published / External
In Work
Lookup table that provides errorcode description for ages (used in Age View).
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table that provides errorcode description for ages (used in Age View).
ErrorCode
Unknown
No
No
Active
ID
No domain defined.
Description
Unknown
No
No
Active
description
No domain defined.
27267
area_stratum
area_stratum
Published / External
In Work
Lookup table for area size of each stratum.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for area size of each stratum.
area_stratum_id
Unknown
No
No
Active
Auto generated
No domain defined.
area_id
Unknown
No
No
Active
Auto generated
No domain defined.
depth_stratun_id
Unknown
No
No
Active
Auto generated
No domain defined.
size_km
Unknown
No
No
Active
stratum size in each geographic area in square km
No domain defined.
27268
AreaEfforts
AreaEfforts
Published / External
In Work
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. All data in this table is calculated from raw catch data. No data is overwritten with fixed values. Only data from strata 3-7 (201-1,000 m) is included.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. All data in this table is calculated from raw catch data. No data is overwritten with fixed values. Only data from strata 3-7 (201-1,000 m) is included.
Year
Unknown
No
No
Active
Year of survey
No domain defined.
Survey
Unknown
No
No
Active
Country that conducted survey (Japan or United States)
No domain defined.
Council_sablefish_management_area_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Smaller areas within the management areas dictated by depth and habitat
No domain defined.
area_code
Unknown
No
No
Active
Auto generated
No domain defined.
Species_Code
Unknown
No
No
Active
RACE species code
No domain defined.
species
Unknown
No
No
Active
Species common name
No domain defined.
area_size_km
Unknown
No
No
Active
size in square km of the each strata within a geographic area
No domain defined.
CPUE
Unknown
No
No
Active
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only. All values are calcualted; none are hard coded numbers prom previously publishe reports (see areaeffortsd fixed for that).
No domain defined.
RPN
Unknown
No
No
Active
RPW (relative population weight) for each strata in each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
RPW
Unknown
No
No
Active
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
mean_length
Unknown
No
No
Active
mean length (cm) for species which have lengths taken in each geographic area
No domain defined.
mean_weight
Unknown
No
No
Active
mean weight (kg) for species which have lengths taken in each geographic area
No domain defined.
LastModifiedDate
Unknown
No
No
Active
Last date where data was calcualted and the data in this table was updated.
No domain defined.
27269
AreaEfforts2b
AreaEfforts2b
Published / External
In Work
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. All data in this table is calculated from raw catch data. No data is overwritten with fixed values.Data from all strata with area sizes are included (including stratum 2b (151-200 m).
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. All data in this table is calculated from raw catch data. No data is overwritten with fixed values.Data from all strata with area sizes are included (including stratum 2b (151-200 m).
Year
Unknown
No
No
Active
Year of survey
No domain defined.
Survey
Unknown
No
No
Active
Country that conducted survey (Japan or United States)
No domain defined.
Council_sablefish_management_area_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Smaller areas within the management areas dictated by depth and habitat
No domain defined.
area_code
Unknown
No
No
Active
Auto generated
No domain defined.
Species_Code
Unknown
No
No
Active
RACE species code
No domain defined.
species
Unknown
No
No
Active
Species common name
No domain defined.
area_size_km
Unknown
No
No
Active
size in square km of the each strata within a geographic area
No domain defined.
CPUE
Unknown
No
No
Active
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only. All values are calcualted; none are hard coded numbers prom previously publishe reports (see areaeffortsd fixed for that).
No domain defined.
RPN
Unknown
No
No
Active
Relative population number (RPN) for each Geographic Area and stratum. RPN is an index of abundance and not an absolute estimate of the total number of fish. It is calculated for each stratum at each station by multiplying the CPUE for each stratum at each station by the area of the stratum in the Geographic Area. The RPN for a stratum in a Geographic Area is then calculated by averaging the RPNs for all stations within each stratum in a Geographic Area. A null value means there were no fish caught.
No domain defined.
RPW
Unknown
No
No
Active
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
mean_length
Unknown
No
No
Active
mean length (cm) for species which have lengths taken in each geographic area
No domain defined.
mean_weight
Unknown
No
No
Active
mean weight (kg) for species which have lengths taken in each geographic area
No domain defined.
LastModifiedDate
Unknown
No
No
Active
Last date where data was calcualted and the data in this table was updated.
No domain defined.
27270
AreaEffortsFixed
AreaEffortsFixed
Published / External
In Work
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. Only data from strata 3-7 (201-1,000 m) is included. Values for the Japanese surveys are fixed from values published in Japanese survey reports for sablefish only.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. Only data from strata 3-7 (201-1,000 m) is included. Values for the Japanese surveys are fixed from values published in Japanese survey reports for sablefish only.
Year
Unknown
No
No
Active
year
No domain defined.
Survey
Unknown
No
No
Active
Country, Japan or United States
No domain defined.
Council_sablefish_management_area_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Smaller areas within the management areas dictated by depth and habitat
No domain defined.
area_code
Unknown
No
No
Active
Auto generated
No domain defined.
Species_Code
Unknown
No
No
Active
RACE species code
No domain defined.
species
Unknown
No
No
Active
Species common name
No domain defined.
area_size_km
Unknown
No
No
Active
size in square km of the each strata within a geographic area
No domain defined.
CPUE
Unknown
No
No
Active
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area, values are hard coded for previously published values from Japanese surveys. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
RPN
Unknown
No
No
Active
RPN (relative population weight) for each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
RPW
Unknown
No
No
Active
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
mean_length
Unknown
No
No
Active
mean length (cm) for species which have lengths taken in each geographic area
No domain defined.
mean_weight
Unknown
No
No
Active
mean weight (kg) for species which have lengths taken in each geographic area
No domain defined.
LastModifiedDate
Unknown
No
No
Active
Last date where data was calcualted and the data in this table was updated.
No domain defined.
27271
Areas
Areas
Published / External
In Work
Every way an area can be categorized. The most basc unit is the geographic_area_name. All others encompass these areas.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Every way an area can be categorized. The most basc unit is the geographic_area_name. All others encompass these areas.
Area_ID
Unknown
No
No
Active
auto generated
No domain defined.
area_code
Unknown
No
No
Active
auto generated
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Geographic areas within management areas, defined by depth and habitat
No domain defined.
Habitat_type
Unknown
No
No
Active
slope, gully, shelf
No domain defined.
INPFC_area
Unknown
No
No
Active
Bering 1-5, East and West Aleutians, Shumagin, Chirikof, Kodiak, Yakutat, Southeast
No domain defined.
Council_management_area
Unknown
No
No
Active
Bering Sea, Aleutians, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, Eastern Gulf
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
Region
Unknown
No
No
Active
Eastern Bering Sea, Aleutians, Gulf of Alaska
No domain defined.
FMP_management_area
Unknown
No
No
Active
BSAI, GOA
No domain defined.
Exploitable
Unknown
No
No
Active
IS the geographic area used for RPN's
No domain defined.
Council_sablefish_management_area_ID
Unknown
No
No
Active
auto generated
No domain defined.
27272
AreaStratumEfforts
AreaStratumEfforts
Published / External
In Work
Calculated Relative Population Indices by depth stratum and small geographic areas.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Calculated Relative Population Indices by depth stratum and small geographic areas.
Year
Unknown
No
No
Active
Year of survey
No domain defined.
Survey
Unknown
No
No
Active
Country that conducted survey (Japan or United States)
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Smaller areas within the management areas dictated by depth and habitat
No domain defined.
area_code
Unknown
No
No
Active
Auto generated
No domain defined.
Council_sablefish_management_area_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
Species_Code
Unknown
No
No
Active
RACE species code
No domain defined.
species
Unknown
No
No
Active
Species common name
No domain defined.
web_reporting_flag
Unknown
No
No
Active
flagged station if catch and average length and weight data is available on the longline survey website
No domain defined.
depth_stratum_id2
Unknown
No
No
Active
Autogenerated code specific to stratum
No domain defined.
stratum2
Unknown
No
No
Active
Stratum code (1-8)
No domain defined.
StratumDescription
Unknown
No
No
Active
Depth range in m of each stratum (which is a code from 1-10, including 2a, 2b instead of just 2)
No domain defined.
size_km
Unknown
No
No
Active
stratum size in each geographic area in square km
No domain defined.
sumsta
Unknown
No
No
Active
Number of stations in each geographic area
No domain defined.
sumrpwsta
Unknown
No
No
Active
number of stations in each geographic area used for RPN, RPW, and CPUE calculations
No domain defined.
mean_length
Unknown
No
No
Active
mean length (cm) for species which have lengths taken in each geographic area
No domain defined.
mean_weight
Unknown
No
No
Active
mean weight (kg) for species which have lengths taken in each geographic area
No domain defined.
CPUE
Unknown
No
No
Active
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area, values are hard coded for previously published values from Japanese surveys. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
RPN
Unknown
No
No
Active
RPN (relative population weight) for each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
RPW
Unknown
No
No
Active
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
a_vonBert
Unknown
No
No
Active
Weight = aLb where a_vonBert = b
No domain defined.
b_vonBert
Unknown
No
No
Active
Weight = aLb where a_vonBert = b
No domain defined.
LastModifiedDate
Unknown
No
No
Active
none
No domain defined.
27273
BadCatches
BadCatches
Published / External
In Work
catch for each species
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
catch for each species
Catch_ID
Unknown
No
No
Active
Auto generated, primary key
No domain defined.
Haul_Position_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Vessel
Unknown
No
No
Active
vessel code
No domain defined.
cruise
Unknown
No
No
Active
cruise number, year + 01. e.g., 200101
No domain defined.
station
Unknown
No
No
Active
standard station number. >500 = experimental stations
No domain defined.
species_code
Unknown
No
No
Active
RACE species codes
No domain defined.
hachi
Unknown
No
No
Active
Skate number
No domain defined.
catch_freq
Unknown
No
No
Active
number of fish caught on each skate of 45 hooks by species
No domain defined.
create_date
Unknown
No
No
Active
date
No domain defined.
error_description
Unknown
No
No
Active
why the record could not be added to the catch table at import
No domain defined.
depredated_freq
Unknown
No
No
Active
number of fish caught per skate of 45 hooks by species that had evidence of mammal depredation (only part of a fish remaining)
No domain defined.
non_depredated_freq
Unknown
No
No
Active
number of fish caught per skate of 45 hooks that had no evidence of depredation by mammals
No domain defined.
27274
BadDepths
BadDepths
Published / External
In Work
Table than is populated during data import if there is data catch data that cannot be imported into the depths table.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Table than is populated during data import if there is data catch data that cannot be imported into the depths table.
Depth_ID
Unknown
No
No
Active
auto generated
No domain defined.
Haul_Position_ID
Unknown
No
No
Active
auto generated
No domain defined.
Vessel
Unknown
No
No
Active
vessel code
No domain defined.
cruise
Unknown
No
No
Active
cruise number, year + 01. e.g., 200101
No domain defined.
station
Unknown
No
No
Active
standard station number. >500 = experimental stations
No domain defined.
hachi
Unknown
No
No
Active
Hachi(also called skate) number. Each hachi gets a number at each station starting with 1 and numbered sequntially.
No domain defined.
depth_time
Unknown
No
No
Active
time at which hachi was hauled
No domain defined.
depth
Unknown
No
No
Active
depth taken at haul-back for every 5th skate and when there is a depth stratum change
No domain defined.
intrpdep
Unknown
No
No
Active
depth interpolated for hachi's where no depth was recorded (recorded for every 5th skate)
No domain defined.
stratum
Unknown
No
No
Active
depth interval used for summarizing lengths and catch. Increments range from 100-200 meters depending on the stratum
No domain defined.
baited
Unknown
No
No
Active
number of hooks with bait only at haul-back
No domain defined.
ineffective
Unknown
No
No
Active
number of hooks that were not fishing effectively at haul-back because they were snarled with other hooks, bent, broken, or missing
No domain defined.
create_date
Unknown
No
No
Active
date
No domain defined.
error_description
Unknown
No
No
Active
reason why depth information could not be added to the depths table at import
No domain defined.
27275
BadHauls
BadHauls
Published / External
In Work
Table than is populated during data import if there is data catch data that cannot be imported into the haul table.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Table than is populated during data import if there is data catch data that cannot be imported into the haul table.
Haul_Position_ID
Unknown
No
No
Active
autogenerated
No domain defined.
Cruise_Station_ID
Unknown
No
No
Active
autogenerated
No domain defined.
Vessel
Unknown
No
No
Active
vessel code
No domain defined.
cruise
Unknown
No
No
Active
cruise number, year + 01. e.g., 200101
No domain defined.
haul
Unknown
No
No
Active
haul number (start over every year)
No domain defined.
INPFC_area
Unknown
No
No
Active
Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, Esatern Gulf of Alaska
No domain defined.
station
Unknown
No
No
Active
standard station number. >500 = experimental stations
No domain defined.
haul_date
Unknown
No
No
Active
Date haul was set and hauled
No domain defined.
start_latitude
Unknown
No
No
Active
start latitude of haul (decimal degrees)
No domain defined.
start_hemi_ns
Unknown
No
No
Active
start hemisphere of the haul (north/south)
No domain defined.
start_longitude
Unknown
No
No
Active
start longitude of the haul (decimal degrees)
No domain defined.
start_hemi_ew
Unknown
No
No
Active
start hemisphere of the haul (east/west)
No domain defined.
end_latitude
Unknown
No
No
Active
end latitude of haul (decimal degrees)
No domain defined.
end_hemi_ns
Unknown
No
No
Active
end hemisphere of the haul (north/south)
No domain defined.
end_longitude
Unknown
No
No
Active
end longitude of the haul (decimal degrees)
No domain defined.
end_hemi_ew
Unknown
No
No
Active
end hemisphere of the haul (east/west)
No domain defined.
set_start_time
Unknown
No
No
Active
time when haul back starts
No domain defined.
set_end_time
Unknown
No
No
Active
time when gear set starts
No domain defined.
haul_start_time
Unknown
No
No
Active
time when haul back starts
No domain defined.
haul_end_time
Unknown
No
No
Active
time when haul back ends
No domain defined.
soak_time
Unknown
No
No
Active
time gear was soaking in minutes (set end time - haul start time)
No domain defined.
distance_fished
Unknown
No
No
Active
length of set in km (approximate)
No domain defined.
starting_depth
Unknown
No
No
Active
depth of first skate at haul back
No domain defined.
ending_depth
Unknown
No
No
Active
depth of last skate at haul back
No domain defined.
surface_temperature
Unknown
No
No
Active
temperatre at the surface at start of haul back
No domain defined.
gear_temperature
Unknown
No
No
Active
temperature at depth taken from a temperature-depth recorder
No domain defined.
tdr_depth
Unknown
No
No
Active
depth at which the gear_temperature is taken with a temperature-depth recorder
No domain defined.
gear_type
Unknown
No
No
Active
type of gear used, determined by specifics of hooks, bait, or any other differences
No domain defined.
bait_type
Unknown
No
No
Active
type of bait used, consistent in United states survey
No domain defined.
year
Unknown
No
No
Active
none
No domain defined.
create_date
Unknown
No
No
Active
used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.
No domain defined.
mammal_sighting
Unknown
No
No
Active
used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.
No domain defined.
Depredation_flag
Unknown
No
No
Active
Flag used to document if there was evidence of sperm whale depredation on the haul. Evidence is presence of head and lips or damamged fishing gear (broken hooks)
No domain defined.
error_description
Unknown
No
No
Active
none
No domain defined.
27276
BadLengths
BadLengths
Published / External
In Work
Table than is populated during data import if there is data catch data that cannot be imported into the lengths table.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Table than is populated during data import if there is data catch data that cannot be imported into the lengths table.
Length_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Cruise_Station_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Vessel
Unknown
No
No
Active
vessel code
No domain defined.
cruise
Unknown
No
No
Active
cruise number, year + 01. e.g., 200101
No domain defined.
station
Unknown
No
No
Active
standard station number. >500 = experimental stations
No domain defined.
length
Unknown
No
No
Active
length in cm
No domain defined.
frequency
Unknown
No
No
Active
number of fish lengthed by sex, species, stratum, station
No domain defined.
sex
Unknown
No
No
Active
m or f
No domain defined.
stratum
Unknown
No
No
Active
Depth stratum code (1-8)
No domain defined.
species_code
Unknown
No
No
Active
RACE species codes
No domain defined.
error_description
Unknown
No
No
Active
none
No domain defined.
27277
Bait_Types
Bait_Types
Published / External
In Work
Lookup table for bait type.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for bait type.
Bait_Type_ID
Unknown
No
No
Active
auto generated
No domain defined.
Bait_Type
Unknown
No
No
Active
type of bait code used on survey. we stick to 1 bait type
No domain defined.
Description
Unknown
No
No
Active
descritpion of bait type
No domain defined.
27278
Catches
Catches
Published / External
In Work
Every hook that is hauled is assigned one of four codes: a species code if it caught something, baited if a bait is still on the hook, unbaited if the hook was bare but effective, or ineffective if the hook was either snarled, bent or broken, missing, or otherwise unable to fish effectively. Although data is collected by hook, the catch data in the database is summarized by skate (45 hook groupings, also called hachi in the database).
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Every hook that is hauled is assigned one of four codes: a species code if it caught something, baited if a bait is still on the hook, unbaited if the hook was bare but effective, or ineffective if the hook was either snarled, bent or broken, missing, or otherwise unable to fish effectively. Although data is collected by hook, the catch data in the database is summarized by skate (45 hook groupings, also called hachi in the database).
Catch_ID
Unknown
No
No
Active
Auto generated, primary key
No domain defined.
Depth_ID
Unknown
No
No
Active
auto generated
No domain defined.
species_code
Unknown
No
No
Active
RACE species codes
No domain defined.
catch_freq
Unknown
No
No
Active
number of fish caught on each skate of 45 hooks by species
No domain defined.
depredated_freq
Unknown
No
No
Active
number of fish caught per skate of 45 hooks by species that had evidence of mammal depredation (only part of a fish remaining)
No domain defined.
non_depredated_freq
Unknown
No
No
Active
number of fish caught per skate of 45 hooks that had no evidence of depredation by mammals
No domain defined.
27279
Council_Management_Areas
Council_Management_Areas
Published / External
In Work
Lookup table for management area and an area description. Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, Eastern Gulf of Alaska.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for management area and an area description. Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, Eastern Gulf of Alaska.
Council_management_area_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Council_management_area
Unknown
No
No
Active
Bering Sea, Aleutians, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, Eastern Gulf
No domain defined.
Description
Unknown
No
No
Active
descritpion of area
No domain defined.
27280
Council_Sablefish_Management_Areas
Council_Sablefish_Management_Areas
Published / External
In Work
council sablefish management area definitions
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
council sablefish management area definitions
Council_sablefish_management_area_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
Description
Unknown
No
No
Active
descritpion of area
No domain defined.
27281
Cruise_Stations
Cruise_Stations
Published / External
In Work
table for linking other tables
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
table for linking other tables
Cruise_Station_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Cruise_ID
Unknown
No
No
Active
auto generated
No domain defined.
Station_ID
Unknown
No
No
Active
auto generated
No domain defined.
27282
Cruises
Cruises
Published / External
In Work
Lookp table that links together the stations, cruises, and haul tables. There are many stations per cruise and multiple hauls per station.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookp table that links together the stations, cruises, and haul tables. There are many stations per cruise and multiple hauls per station.
Cruise_ID
Unknown
No
No
Active
auto generated
No domain defined.
Cruise_Number
Unknown
No
No
Active
cruise number = year + 01
No domain defined.
Cruise_Description
Unknown
No
No
Active
none
No domain defined.
Vessel_Number
Unknown
No
No
Active
vessel number is 3 digits for Japan and 96 or 81 for United States
No domain defined.
Year
Unknown
No
No
Active
Year of survey
No domain defined.
27283
Depredation_Types
Depredation_Types
Published / External
In Work
Lookup table for a description of depredation types.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for a description of depredation types.
Depredation_Type
Unknown
No
No
Active
Code for the type of marine mammal depredation. For now, used for when there is evidence of sperm whale depredation (not killer whale, see rpn_filter).
No domain defined.
Description
Unknown
No
No
Active
type of mammal
No domain defined.
27284
Depth_Stratum
Depth_Stratum
Published / External
In Work
Lookup table for stratum information.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for stratum information.
Depth_Stratum_ID
Unknown
No
No
Active
auto generated
No domain defined.
Stratum
Unknown
No
No
Active
depth interval used for summarizing lengths and catch. Increments range from 100-200 meters depending on the stratum.
No domain defined.
Description
Unknown
No
No
Active
Depth interval of the stratum in meters
No domain defined.
StartDepth
Unknown
No
No
Active
start depth of each stratum
No domain defined.
EndDepth
Unknown
No
No
Active
end depth of each stratum
No domain defined.
27285
Depths
Depths
Published / External
In Work
Data specific to each hachi (segement of gear that is 45 hooks).
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Data specific to each hachi (segement of gear that is 45 hooks).
Depth_ID
Unknown
No
No
Active
auto generated
No domain defined.
Haul_Position_ID
Unknown
No
No
Active
auto generated
No domain defined.
hachi
Unknown
No
No
Active
Hachi(also called skate) number. Each hachi gets a number at each station starting with 1 and numbered sequntially.
No domain defined.
depth_time
Unknown
No
No
Active
time at which hachi was hauled
No domain defined.
depth
Unknown
No
No
Active
depth taken at haul-back for every 5th skate and when there is a depth stratum change
No domain defined.
intrpdep
Unknown
No
No
Active
depth interpolated for hachi's where no depth was recorded (recorded for every 5th skate)
No domain defined.
depth_stratum_id
Unknown
No
No
Active
Autogenerated ID
No domain defined.
baited
Unknown
No
No
Active
number of hooks with bait only at haul-back
No domain defined.
ineffective
Unknown
No
No
Active
number of hooks that were not fishing effectively at haul-back because they were snarled with other hooks, bent, broken, or missing
No domain defined.
rpn_filter
Unknown
No
No
Active
If there is a value here the hachi is not being used for RPN calculations. This is mainly used for filtering out hachi's when there was killer whale depredation.
No domain defined.
depth_stratum_id2
Unknown
No
No
Active
Autogenerated ID
No domain defined.
27286
FMP_Management_Areas
FMP_Management_Areas
Published / External
In Work
Lookup table
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table
FMP_Management_Area_ID
Unknown
No
No
Active
Auto generated
No domain defined.
FMP_Management_Area
Unknown
No
No
Active
GOA or BSAI
No domain defined.
Description
Unknown
No
No
Active
field is now null, description of FMP_management_area field
No domain defined.
27287
Gear_Types
Gear_Types
Published / External
In Work
Lookup table for gear types
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for gear types
Gear_Type_ID
Unknown
No
No
Active
auto generated
No domain defined.
Gear_Type
Unknown
No
No
Active
same gear type used on U.S. survey (code 915) Gear type code is used when anything changes on the gear (could potentially be bait, hook size, etc.)
No domain defined.
Description
Unknown
No
No
Active
description of the gear
No domain defined.
27288
Geographic_areas
Geographic_areas
Published / External
In Work
Lookup table for geographic areas (smallest area unit available)
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for geographic areas (smallest area unit available)
Geographic_area_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Smaller areas within the management areas dictated by depth and habitat
No domain defined.
Description
Unknown
No
No
Active
is null currently. Could be a description of the habitat and depth range of the area
No domain defined.
27289
Habitat_Types
Habitat_Types
Published / External
In Work
Lookup table for habitat types
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for habitat types
Habitat_Types_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Habitat_Types
Unknown
No
No
Active
Depp or shallow gully, or slope
No domain defined.
Description
Unknown
No
No
Active
currently null, could a description of Habitat_type field
No domain defined.
27290
Haul_positions
Haul_positions
Published / External
In Work
This table provides data related to each haul. There are generally 2 hauls per station except at gully stations.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
This table provides data related to each haul. There are generally 2 hauls per station except at gully stations.
Haul_Position_ID
Unknown
No
No
Active
autogenerated
No domain defined.
Cruise_Station_ID
Unknown
No
No
Active
autogenerated
No domain defined.
haul
Unknown
No
No
Active
haul number is sequential through the season, starting with 1. On most stations there are 2 hauls per day. The exception is the Bering Sea and gullies (where each station has 1 haul). In catch views the data is specific to the station and not the haul (as it is in this table).
No domain defined.
haul_date
Unknown
No
No
Active
Date haul was set and hauled
No domain defined.
start_latitude
Unknown
No
No
Active
start latitude of haul (decimal degrees)
No domain defined.
start_hemi_ns
Unknown
No
No
Active
start hemisphere of the haul (north/south)
No domain defined.
start_longitude
Unknown
No
No
Active
start longitude of the haul (decimal degrees)
No domain defined.
start_hemi_ew
Unknown
No
No
Active
start hemisphere of the haul (east/west)
No domain defined.
end_latitude
Unknown
No
No
Active
end latitude of haul (decimal degrees)
No domain defined.
end_hemi_ns
Unknown
No
No
Active
end hemisphere of the haul (north/south)
No domain defined.
end_longitude
Unknown
No
No
Active
end longitude of the haul (decimal degrees)
No domain defined.
end_hemi_ew
Unknown
No
No
Active
end hemisphere of the haul (east/west)
No domain defined.
set_start_time
Unknown
No
No
Active
time when haul back starts
No domain defined.
set_end_time
Unknown
No
No
Active
time when gear set starts
No domain defined.
haul_start_time
Unknown
No
No
Active
time when haul back starts
No domain defined.
haul_end_time
Unknown
No
No
Active
time when haul back ends
No domain defined.
soak_time
Unknown
No
No
Active
time gear was soaking in minutes (set end time - haul start time)
No domain defined.
distance_fished
Unknown
No
No
Active
length of set in km (approximate)
No domain defined.
starting_depth
Unknown
No
No
Active
depth of first skate at haul back
No domain defined.
ending_depth
Unknown
No
No
Active
depth of last skate at haul back
No domain defined.
surface_temperature
Unknown
No
No
Active
temperatre at the surface at start of haul back
No domain defined.
gear_temperature
Unknown
No
No
Active
temperature at depth taken from a temperature-depth recorder
No domain defined.
tdr_depth
Unknown
No
No
Active
depth at which the gear_temperature is taken with a temperature-depth recorder
No domain defined.
gear_type
Unknown
No
No
Active
type of gear used, determined by specifics of hooks, bait, or any other differences
No domain defined.
bait_type
Unknown
No
No
Active
type of bait used, consistent in United states survey
No domain defined.
mammal_sighting
Unknown
No
No
Active
used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.
No domain defined.
Depredation_flag
Unknown
No
No
Active
Flag used to document if there was evidence of sperm whale depredation on the haul. Evidence is presence of head and lips or damamged fishing gear (broken hooks)
No domain defined.
27291
INPFC_Areas
INPFC_Areas
Published / External
In Work
Lookup table with INPFC area descriptions
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table with INPFC area descriptions
INPFC_Area_ID
Unknown
No
No
Active
auto generated
No domain defined.
INPFC_Area
Unknown
No
No
Active
geo graphic area names defined by habitat. Same areas use by the trawl survey for random, e.g., Bering I, Kodiak, Shumagin, Yakutat...)
No domain defined.
Description
Unknown
No
No
Active
Currently null, could be a description of the INPFC_area
No domain defined.
27292
LengthFrequencies
LengthFrequencies
Published / External
In Work
This table extrapolates the length frequencies by species to relative population numbers (RPNs) (i.e., number of fish at each length in the population, where the population is in RPNs and so is only a relative index).
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
This table extrapolates the length frequencies by species to relative population numbers (RPNs) (i.e., number of fish at each length in the population, where the population is in RPNs and so is only a relative index).
Year
Unknown
No
No
Active
Year of survey
No domain defined.
Country
Unknown
No
No
Active
country
No domain defined.
Vessel_Number
Unknown
No
No
Active
vessel number is 3 digits for Japan and 96 or 81 for United States
No domain defined.
Vessel_name
Unknown
No
No
Active
Name of the fishing vessel.
No domain defined.
Cruise_Number
Unknown
No
No
Active
cruise number = year + 01
No domain defined.
area_code
Unknown
No
No
Active
Code specific to each Geographic_area_name.
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Smaller areas within the management areas dictated by depth and habitat (e.g., Kodiak, Bering I, Yakutat, Shumagin).
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside.
No domain defined.
Species_Code
Unknown
No
No
Active
RACE species code
No domain defined.
Common_Name
Unknown
No
No
Active
species common name
No domain defined.
sex
Unknown
No
No
Active
m or f
No domain defined.
length
Unknown
No
No
Active
length in cm
No domain defined.
length_frequency
Unknown
No
No
Active
area
No domain defined.
LastModifiedDate
Unknown
No
No
Active
Last date data was added or recalculated
No domain defined.
27293
LengthFrequenciesStrata3to7
LengthFrequenciesStrata3to7
Published / External
In Work
This table extrapolates the length frequencies by species to relative population numbers (RPNs) (i.e., number of fish at each length in the population, where the population is in RPNs and so is only a relative index). Lengthfrequenciesstrata3to7 has only data for strata 3-7 (201-1,000 m).
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
This table extrapolates the length frequencies by species to relative population numbers (RPNs) (i.e., number of fish at each length in the population, where the population is in RPNs and so is only a relative index). Lengthfrequenciesstrata3to7 has only data for strata 3-7 (201-1,000 m).
Year
Unknown
No
No
Active
Year of survey
No domain defined.
Country
Unknown
No
No
Active
country
No domain defined.
Vessel_Number
Unknown
No
No
Active
vessel number is 3 digits for Japan and 96 or 81 for United States
No domain defined.
Vessel_name
Unknown
No
No
Active
Name of the fishing vessel.
No domain defined.
Cruise_Number
Unknown
No
No
Active
cruise number = year + 01
No domain defined.
area_code
Unknown
No
No
Active
Code specific to each Geographic_area_name.
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Smaller areas within the management areas dictated by depth and habitat (e.g., Kodiak, Bering I, Yakutat, Shumagin).
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside.
No domain defined.
Species_Code
Unknown
No
No
Active
RACE species code
No domain defined.
Common_Name
Unknown
No
No
Active
species common name
No domain defined.
sex
Unknown
No
No
Active
m or f
No domain defined.
length
Unknown
No
No
Active
length in cm
No domain defined.
length_frequency
Unknown
No
No
Active
area
No domain defined.
LastModifiedDate
Unknown
No
No
Active
Last date data was added or recalculated
No domain defined.
27294
Lengths
Lengths
Published / External
In Work
Count of lengths by species, sex, length, cruise, station, and depth stratum.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Count of lengths by species, sex, length, cruise, station, and depth stratum.
Length_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Cruise_Station_ID
Unknown
No
No
Active
Auto generated
No domain defined.
depth_stratum_id
Unknown
No
No
Active
Depth stratum code (1-8)
No domain defined.
species_code
Unknown
No
No
Active
RACE species codes
No domain defined.
sex
Unknown
No
No
Active
m or f
No domain defined.
length
Unknown
No
No
Active
length in cm
No domain defined.
frequency
Unknown
No
No
Active
number of fish lengthed by sex, species, stratum, station
No domain defined.
27295
Maturity
Maturity
Published / External
In Work
maturity code descriptions
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
maturity code descriptions
Code
Unknown
No
No
Active
maturity code 1-6 used for sablefish
No domain defined.
Description
Unknown
No
No
Active
description of the sabelfish maturity code
No domain defined.
27296
MaxHachilnFirstHaul
MaxHachilnFirstHaul
Published / External
In Work
Used in calcualted process for RPNs and RPWs.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Used in calcualted process for RPNs and RPWs.
vessel
Unknown
No
No
Active
vessel number is 3 digits for Japan and 96 or 81 for United States
No domain defined.
cruise
Unknown
No
No
Active
cruise number = year + 01 (e.g., 201001 for 2010)
No domain defined.
station
Unknown
No
No
Active
Fixed station number which are sampled annually. Station numbers over 500 are experimental and were not sampled regularly. A few others were also not sampled through the entire time series.
No domain defined.
maxHachiFirstHaul
Unknown
No
No
Active
Last hachi on the first haul
No domain defined.
27297
Regions
Regions
Published / External
In Work
Region list (AI, BS, GOA)
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Region list (AI, BS, GOA)
Region_ID
Unknown
No
No
Active
autogenerated
No domain defined.
Region
Unknown
No
No
Active
AI, EBS, or GOA
No domain defined.
Description
Unknown
No
No
Active
Currently Null, but could describe Region
No domain defined.
27298
SablefishOtolith_import
SablefishOtolith_import
Published / External
In Work
Intermediary table used for importing sablefish speciment data into Ages. These are fish sampled for otoliths, maturity, lengths, and weights.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Intermediary table used for importing sablefish speciment data into Ages. These are fish sampled for otoliths, maturity, lengths, and weights.
vessel
Unknown
No
No
Active
vessel code
No domain defined.
cruise
Unknown
No
No
Active
cruise number = year + 01(e.g.,201001 for 2010)
No domain defined.
Station
Unknown
No
No
Active
Station number (same in all years)
No domain defined.
SpeciesCode
Unknown
No
No
Active
AFSC RACE trawl survey species code
No domain defined.
Sex
Unknown
No
No
Active
Sex (1 = male, 2 = female, 3= unknown)
No domain defined.
Maturity
Unknown
No
No
Active
Maturity code used for both males and females.
No domain defined.
Length
Unknown
No
No
Active
Total length in cm
No domain defined.
Specimen_Number
Unknown
No
No
Active
ID assigned to each specimen. Not unique (start at 1 every year).
No domain defined.
stratum
Unknown
No
No
Active
Depth stratum code
No domain defined.
age
Unknown
No
No
Active
age in years
No domain defined.
wt kg
Unknown
No
No
Active
weight in kg
No domain defined.
27299
Settings
Settings
Published / External
In Work
Unused
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Unused
ID
Unknown
No
No
Active
autogenerated
No domain defined.
cruise
Unknown
No
No
Active
cruise number = year + 01(e.g.,201001 for 2010)
No domain defined.
SurveyStartDate
Unknown
No
No
Active
Start date of survey
No domain defined.
SurveyEndDate
Unknown
No
No
Active
End date of survey
No domain defined.
27300
Sex
Sex
Published / External
In Work
Lookup table for sex (1, 2, or 3)
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for sex (1, 2, or 3)
Code
Unknown
No
No
Active
1, 2, or 3
No domain defined.
Description
Unknown
No
No
Active
male, female, or unknown
No domain defined.
27301
Specie_Catch_Codes
Specie_Catch_Codes
Published / External
In Work
Data specific to each species, including species codes, growth parameters, and western Aleutian Islands extraploation ratios.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Data specific to each species, including species codes, growth parameters, and western Aleutian Islands extraploation ratios.
Specie_catch_code_id
Unknown
No
No
Active
autogenerated
No domain defined.
Polycorder_Number
Unknown
No
No
Active
code used for each species when catch is tabulated as it is hauled on-baord
No domain defined.
Species_Code
Unknown
No
No
Active
RACEspecies code
No domain defined.
Common_Name
Unknown
No
No
Active
Species common name
No domain defined.
Scientific_name
Unknown
No
No
Active
Species scientific name
No domain defined.
a_vonBert
Unknown
No
No
Active
Von bertalanffy growth curve coeficient for species that are lengthed on the survey
No domain defined.
b_vonBert
Unknown
No
No
Active
Von bertalanffy growth curve coeficient for species that are lengthed on the survey
No domain defined.
process_type
Unknown
No
No
Active
null
No domain defined.
web_reporting_flag
Unknown
No
No
Active
Flag if data is available on teh AFSC website
No domain defined.
survey_species_flag
Unknown
No
No
Active
Flag is species have lenghts
No domain defined.
NW_AI_ratio
Unknown
No
No
Active
Species specific ratios of northeast and northwest Aleutian Islands (AI) RPNs from Japanese surveys (1985-1994) used to extrapolate northeastern AI RPNs, RPWs, and CPUEs for current surveys.
No domain defined.
SW_AI_ratio
Unknown
No
No
Active
Species specific ratios of southeast and southwest Aleutian Islands (AI) RPNs from Japanese surveys (1985-1994) used to extrapolate southeastern AI RPNs, RPWs, and CPUEs for current surveys.
No domain defined.
avg_weight
Unknown
No
No
Active
Average weight used to calculate total weight of fish caught on the survey if no lengths are taken during the survey. Data comes from longline fisheries in Alaska.
No domain defined.
27302
Sppcode_Catch
Sppcode_Catch
Published / External
In Work
Species codes and names
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Species codes and names
Polycorder_Number
Unknown
No
No
Active
Longline survey species code
No domain defined.
Species Code
Unknown
No
No
Active
AFSC RACE trawl survey species code
No domain defined.
Common_Name
Unknown
No
No
Active
None
No domain defined.
Scientific_Name
Unknown
No
No
Active
None
No domain defined.
27303
SRREStationRates
SRREStationRates
Published / External
In Work
Ratio of shortraker and rougheye caught by station. Used for separating catch where there were no lengths taken. (Catch cannot be differentiaed when being haul on-board, so ratios are used to separate out catch into two species when there are not lengths taken).
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Ratio of shortraker and rougheye caught by station. Used for separating catch where there were no lengths taken. (Catch cannot be differentiaed when being haul on-board, so ratios are used to separate out catch into two species when there are not lengths taken).
Shortraker_Rate
Unknown
No
No
Active
Proportion of shortraker/rougheye catch that was shortraker rockfish.
No domain defined.
Rougheye_Rate
Unknown
No
No
Active
Proportion of shortraker/rougheye catch that was rougheye rockfish.
No domain defined.
27304
Station_Types
Station_Types
Published / External
In Work
Lookup table for station type (either standard or experimental)
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Lookup table for station type (either standard or experimental)
Station_Type_ID
Unknown
No
No
Active
autogenerated
No domain defined.
Description
Unknown
No
No
Active
standard survey station or experimental (not done annually)
No domain defined.
27305
StationEfforts
StationEfforts
Published / External
In Work
Unions SRRECPUE and CPUE to produce all Station/Stratum-level CPUE, RPN, and RPW values. From here on when mean weight is calculated it is not averaged as length is, it is always calculated using the a and b parameters in specie_catch_codes. SRRE is short for shortraker and rougheye rockfish. In short, this is an intermediate table used for calculating CPUE and indices of abundance (RPNs and RPWs). It is catch and effort by depth strata.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Unions SRRECPUE and CPUE to produce all Station/Stratum-level CPUE, RPN, and RPW values. From here on when mean weight is calculated it is not averaged as length is, it is always calculated using the a and b parameters in specie_catch_codes. SRRE is short for shortraker and rougheye rockfish. In short, this is an intermediate table used for calculating CPUE and indices of abundance (RPNs and RPWs). It is catch and effort by depth strata.
Year
Unknown
No
No
Active
Year of survey
No domain defined.
Cruise_Station_ID
Unknown
No
No
Active
Auto generated
No domain defined.
Cruise_Number
Unknown
No
No
Active
cruise number = year + 01
No domain defined.
Vessel_Number
Unknown
No
No
Active
vessel number is 3 digits for Japan and 96 or 81 for United States
No domain defined.
Country
Unknown
No
No
Active
country
No domain defined.
Station_Number
Unknown
No
No
Active
Fixed station numbers. Numbers over 500 are experimental stations and are not standard
No domain defined.
RPW_Station_Number
Unknown
No
No
Active
Stations used for RPN's
No domain defined.
area_id
Unknown
No
No
Active
Auto generated
No domain defined.
area_code
Unknown
No
No
Active
Auto generated
No domain defined.
Geographic_area_name
Unknown
No
No
Active
Smaller areas within the management areas dictated by depth and habitat
No domain defined.
Council_sablefish_management_area_ID
Unknown
No
No
Active
auto generated
No domain defined.
Council_sablefish_management_area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
size_km
Unknown
No
No
Active
stratum size in each geographic area in square km
No domain defined.
depth_stratum_id2
Unknown
No
No
Active
Stratum code
No domain defined.
stratum2
Unknown
No
No
Active
Stratum in meters
No domain defined.
Species_Code
Unknown
No
No
Active
RACE species code
No domain defined.
Common_Name
Unknown
No
No
Active
Species common name
No domain defined.
web_reporting_flag
Unknown
No
No
Active
Species flagged if it is a major groundfish species caught and is therefore reported on the website (summarized catch, RPN's...)
No domain defined.
total_skates
Unknown
No
No
Active
number of skates set at each stratum, station
No domain defined.
total_catch
Unknown
No
No
Active
number of fish caught by species, depth stratum, station
No domain defined.
total_length_freq
Unknown
No
No
Active
-no description-
No domain defined.
CPUE
Unknown
No
No
Active
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only. All values are calcualted; none are hard coded numbers prom previously publishe reports (see areaeffortsd fixed for that).
No domain defined.
mean_length
Unknown
No
No
Active
mean length (cm) for species which have lengths taken in each geographic area
No domain defined.
mean_weight
Unknown
No
No
Active
mean weight (kg) for species which have lengths taken in each geographic area
No domain defined.
RPN
Unknown
No
No
Active
RPN (relative population weight) for each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
RPW
Unknown
No
No
Active
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
No domain defined.
a_vonBert
Unknown
No
No
Active
Weight = aLb where a_vonBert = b
No domain defined.
b_vonBert
Unknown
No
No
Active
Weight = aLb where a_vonBert = b
No domain defined.
LastModifiedDate
Unknown
No
No
Active
none
No domain defined.
27306
Stations
Stations
Published / External
In Work
Station specific information
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Station specific information
Station_ID
Unknown
No
No
Active
auto generated
No domain defined.
Area_ID
Unknown
No
No
Active
auto generated
No domain defined.
Station_Number
Unknown
No
No
Active
Fixed station numbers. Numbers over 500 are experimental stations and are not standard
No domain defined.
Description
Unknown
No
No
Active
describes experimental station
No domain defined.
Old_Station_Number
Unknown
No
No
Active
mostly null, station # may have had a different # in the past, go with sttaion_number
No domain defined.
Active
Unknown
No
No
Active
1 if we sample it regulrly since 1996, otherwise 0
No domain defined.
RPW_Flag
Unknown
No
No
Active
Flag for station if it is used in RPN/RPW/CPUE calcualtions
No domain defined.
Station_Type_ID
Unknown
No
No
Active
auto generated
No domain defined.
Longitude
Unknown
No
No
Active
standard station longitude
No domain defined.
Latitude
Unknown
No
No
Active
standard station latitude
No domain defined.
NMFS_Area_Code
Unknown
No
No
Active
NMFS management area code for that station.
No domain defined.
27307
TotalCatchWeight
TotalCatchWeight
Published / External
In Work
Total catch in numbers and weight for each station. Total weight is calculated from length frequencies for species that have lengths taken on the survey. For all others, and average weight from longline fishery data in Alaska is used.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Total catch in numbers and weight for each station. Total weight is calculated from length frequencies for species that have lengths taken on the survey. For all others, and average weight from longline fishery data in Alaska is used.
Year
Unknown
No
No
Active
vessel number is 3 digits for Japan and 96 or 81 for United States
No domain defined.
Country
Unknown
No
No
Active
Country that conducted the survey. Can be either Japan or United States.
No domain defined.
Station_Number
Unknown
No
No
Active
Station number (same in all years)
No domain defined.
NMFS_Area_Code
Unknown
No
No
Active
NMFS management area code for that station.
No domain defined.
Species_Code
Unknown
No
No
Active
AFSC RACE trawl survey species code
No domain defined.
Common_Name
Unknown
No
No
Active
Species common name or genera.
No domain defined.
Total_Catch
Unknown
No
No
Active
Number of fish caught by station and species.
No domain defined.
Ttoal_Weight_kg
Unknown
No
No
Active
Total estimated weight of each species by station.
No domain defined.
27308
Vessels
Vessels
Published / External
In Work
Look up tables for vessel information.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Look up tables for vessel information.
Vessel_Number
Unknown
No
No
Active
vessel number is 3 digits for Japan and 96 or 81 for United States
No domain defined.
Vessel_Name
Unknown
No
No
Active
-no description-
No domain defined.
Country
Unknown
No
No
Active
Country conducting survey, either Japan or United States
No domain defined.
27309
WebAreas
WebAreas
Published / External
In Work
Summarized CPUE and population indices provided on the AFSC website for the public by sablefish Council management areas.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Summarized CPUE and population indices provided on the AFSC website for the public by sablefish Council management areas.
year
Unknown
No
No
Active
year of survey
No domain defined.
survey
Unknown
No
No
Active
Country that conducted survey, either Japan or United States
No domain defined.
Area_ID
Unknown
No
No
Active
auto generated
No domain defined.
Area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
species_code
Unknown
No
No
Active
RACEspecies code
No domain defined.
species
Unknown
No
No
Active
species common name
No domain defined.
CPUE
Unknown
No
No
Active
CPUE for the area weighted by strata size
No domain defined.
RPN
Unknown
No
No
Active
RPN for the area for strata 3-7
No domain defined.
RPW
Unknown
No
No
Active
RPW for the area for strata 3-7
No domain defined.
27310
WebStations
WebStations
Published / External
In Work
Summarized CPUE and population indices provided on the AFSC website for the public by sablefish Council management areas.
Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08
Summarized CPUE and population indices provided on the AFSC website for the public by sablefish Council management areas.
Year
Unknown
No
No
Active
year of the survey
No domain defined.
Survey
Unknown
No
No
Active
either Japan or United States
No domain defined.
Station
Unknown
No
No
Active
Fixed station numbers. Numbers over 500 are experimental stations and are not standard
No domain defined.
Area_ID
Unknown
No
No
Active
autogenerated
No domain defined.
Area
Unknown
No
No
Active
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
No domain defined.
Species_Code
Unknown
No
No
Active
RACEspecies code
No domain defined.
Species
Unknown
No
No
Active
species common name
No domain defined.
Total Catch
Unknown
No
No
Active
catch at each station, rougheye and sortraker extrapolated from proportions from lengths taken at each strata
No domain defined.
Mean Length (mm)
Unknown
No
No
Active
mean length at each station
No domain defined.
Mean Weight (kg)
Unknown
No
No
Active
mean weight at each station
No domain defined.
Latitude
Unknown
No
No
Active
start latitude
No domain defined.
Longitude
Unknown
No
No
Active
start longitude
No domain defined.
Data Steward
2015-10-07
Person
Rodgveller, Cara
cara.rodgveller@noaa.gov
Distributor
2015-09-18
Person
Rodgveller, Cara
cara.rodgveller@noaa.gov
Metadata Contact
2015-09-18
Person
MC, Metadata Coordinators
AFSC.metadata@noaa.gov
Originator
2015-09-18
Person
Rodgveller, Cara
cara.rodgveller@noaa.gov
Point of Contact
2015-10-07
Person
Rodgveller, Cara
cara.rodgveller@noaa.gov
Ground Condition
-178
-132.838667
62
51
Aleutian Islands, Bering Sea, Gulf of Alaska
Range
1988
2015
Unclassified
N/A
There are no legal restrictions on access to the data. They reside in public domain and can be freely distributed.
User must read and fully comprehend the metadata prior to use. Data should not be used beyond the limits of the source scale. Acknowledgement of NOAA, as the source from which these data were obtained, in any publications and/or other representations of these data is suggested.
https://console.cloud.google.com/storage/browser/_details/nmfs_odp_afsc/ABL/Longline%20Sablefish%20Survey_ID_17218.csv
NCEI to be determined
Note: Dataset migrated by Dan Woodrich (AFSC data management coordinator) on 12/14/2021. Contact: Daniel.woodrich@noaa.gov
SQL
See introduction for year/location sampling periods.
All data is QA/QC'd after each field season.
Contact the dataset POC for full methodology
Yes
Unknown
Yes
No
yes
unknown
no delay
To Be Determined
unknown
IT Security and Contingency Plan for the system establishes procedures and applies to the functions, operations, and resources necessary to recover and restore data as hosted in the Western Regional Support Center in Seattle, Washington, following a disruption.
1
Request a copy of the scientific operations plan from distributor for complete process/methodology information
Person
Rodgveller, Cara
cara.rodgveller@noaa.gov
27265
Entity
Ages
27266
Entity
AgesErrorFlags
27268
Entity
AreaEfforts
27269
Entity
AreaEfforts2b
27270
Entity
AreaEffortsFixed
27272
Entity
AreaStratumEfforts
27271
Entity
Areas
27273
Entity
BadCatches
27274
Entity
BadDepths
27275
Entity
BadHauls
27276
Entity
BadLengths
27277
Entity
Bait_Types
27278
Entity
Catches
27279
Entity
Council_Management_Areas
27280
Entity
Council_Sablefish_Management_Areas
27281
Entity
Cruise_Stations
27282
Entity
Cruises
27283
Entity
Depredation_Types
27284
Entity
Depth_Stratum
27285
Entity
Depths
27286
Entity
FMP_Management_Areas
27287
Entity
Gear_Types
27288
Entity
Geographic_areas
27289
Entity
Habitat_Types
27290
Entity
Haul_positions
27291
Entity
INPFC_Areas
27292
Entity
LengthFrequencies
27293
Entity
LengthFrequenciesStrata3to7
27294
Entity
Lengths
27295
Entity
Maturity
27296
Entity
MaxHachilnFirstHaul
27297
Entity
Regions
27303
Entity
SRREStationRates
27298
Entity
SablefishOtolith_import
27299
Entity
Settings
27300
Entity
Sex
27301
Entity
Specie_Catch_Codes
27302
Entity
Sppcode_Catch
27305
Entity
StationEfforts
27304
Entity
Station_Types
27306
Entity
Stations
27307
Entity
TotalCatchWeight
27308
Entity
Vessels
27309
Entity
WebAreas
27310
Entity
WebStations
27267
Entity
area_stratum
gov.noaa.nmfs.inport:17218
Doug Turnbull
2012-12-12T19:50:03
SysAdmin InPortAdmin
2023-05-30T18:10:19
2016-05-18
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18
None
multiple species
vertebrates
Kingdom
Animalia
Phylum
Chordata
Subphylum
Vertebrata
Superclass
Osteichthyes
Class
Actinopterygii
Subclass
Neopterygii
Infraclass
Teleostei
Superorder
Acanthopterygii
Order
Scorpaeniformes
Suborder
Anoplopomatoidei
Family
Anoplopomatidae
Genus
Anoplopoma
Species
Anoplopoma fimbria
Sablefish
Ages
Since 1996 sablefish have been randomly sampled throughout each set for ageing. For samples from 1996-present, maturity, length, weight, and sex is available for all sampled fish. Specimen are then sub-sampled for age reading and so ages are available for only a subset of these fish. This tableincludes data from sablefish that had their otoliths sampled for aging, but were not always aged.
AFSC
Age_ID
Auto generated
database developer
No domain defined.
Cruise_Station_ID
Auto generated
database developer
No domain defined.
specimen_number
ID assigned to each specimen. Not unique (start at 1 every year).
database developer
No domain defined.
depth_stratum_id
Depth stratum code (1-8)
database developer
No domain defined.
species_code
RACE species codes
database developer
No domain defined.
sex
m or f
database developer
No domain defined.
age
age in years, subsampled from otoliths taken at each station
database developer
No domain defined.
maturity
maturity code (1-6)
database developer
No domain defined.
length
length in cm
database developer
No domain defined.
weight
round weight in kg
database developer
No domain defined.
error_flag
Numerical value described under ErrorDescription.
database developer
No domain defined.
notes
Incomplete specimen if missing length, weight, or sex; Above Standard or Below Standard if residual is larger or smaller than a threshold value indicating that the weight is out of the normal range for the sablefish length-weight relationship (selects ~ 2 specimen per year); No Error if there is no missing data and length-weight combination is reasonable.
database developer
No domain defined.
residual
Deviation from fit to sablefish length-weight data. See document on Flagging Specimen data for details.
database developer
No domain defined.
AgesErrorFlags
Lookup table that provides errorcode description for ages (used in Age View).
AFSC
ErrorCode
ID
database developer
No domain defined.
Description
description
database developer
No domain defined.
area_stratum
Lookup table for area size of each stratum.
AFSC
area_stratum_id
Auto generated
database developer
No domain defined.
area_id
Auto generated
database developer
No domain defined.
depth_stratun_id
Auto generated
database developer
No domain defined.
size_km
stratum size in each geographic area in square km
database developer
No domain defined.
AreaEfforts
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. All data in this table is calculated from raw catch data. No data is overwritten with fixed values. Only data from strata 3-7 (201-1,000 m) is included.
AFSC
Year
Year of survey
database developer
No domain defined.
Survey
Country that conducted survey (Japan or United States)
database developer
No domain defined.
Council_sablefish_management_area_ID
Auto generated
database developer
No domain defined.
Council_sablefish_management_area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
Geographic_area_name
Smaller areas within the management areas dictated by depth and habitat
database developer
No domain defined.
area_code
Auto generated
database developer
No domain defined.
Species_Code
RACE species code
database developer
No domain defined.
species
Species common name
database developer
No domain defined.
area_size_km
size in square km of the each strata within a geographic area
database developer
No domain defined.
CPUE
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only. All values are calcualted; none are hard coded numbers prom previously publishe reports (see areaeffortsd fixed for that).
database developer
No domain defined.
RPN
RPW (relative population weight) for each strata in each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
RPW
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
mean_length
mean length (cm) for species which have lengths taken in each geographic area
database developer
No domain defined.
mean_weight
mean weight (kg) for species which have lengths taken in each geographic area
database developer
No domain defined.
LastModifiedDate
Last date where data was calcualted and the data in this table was updated.
database developer
No domain defined.
AreaEfforts2b
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. All data in this table is calculated from raw catch data. No data is overwritten with fixed values.Data from all strata with area sizes are included (including stratum 2b (151-200 m).
AFSC
Year
Year of survey
database developer
No domain defined.
Survey
Country that conducted survey (Japan or United States)
database developer
No domain defined.
Council_sablefish_management_area_ID
Auto generated
database developer
No domain defined.
Council_sablefish_management_area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
Geographic_area_name
Smaller areas within the management areas dictated by depth and habitat
database developer
No domain defined.
area_code
Auto generated
database developer
No domain defined.
Species_Code
RACE species code
database developer
No domain defined.
species
Species common name
database developer
No domain defined.
area_size_km
size in square km of the each strata within a geographic area
database developer
No domain defined.
CPUE
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only. All values are calcualted; none are hard coded numbers prom previously publishe reports (see areaeffortsd fixed for that).
database developer
No domain defined.
RPN
Relative population number (RPN) for each Geographic Area and stratum. RPN is an index of abundance and not an absolute estimate of the total number of fish. It is calculated for each stratum at each station by multiplying the CPUE for each stratum at each station by the area of the stratum in the Geographic Area. The RPN for a stratum in a Geographic Area is then calculated by averaging the RPNs for all stations within each stratum in a Geographic Area. A null value means there were no fish caught.
database developer
No domain defined.
RPW
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
mean_length
mean length (cm) for species which have lengths taken in each geographic area
database developer
No domain defined.
mean_weight
mean weight (kg) for species which have lengths taken in each geographic area
database developer
No domain defined.
LastModifiedDate
Last date where data was calcualted and the data in this table was updated.
database developer
No domain defined.
AreaEffortsFixed
Relative population numbers and weights and catch per unit effort (CPUE) by geographic areas. Only data from strata 3-7 (201-1,000 m) is included. Values for the Japanese surveys are fixed from values published in Japanese survey reports for sablefish only.
AFSC
Year
year
database developer
No domain defined.
Survey
Country, Japan or United States
database developer
No domain defined.
Council_sablefish_management_area_ID
Auto generated
database developer
No domain defined.
Council_sablefish_management_area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
Geographic_area_name
Smaller areas within the management areas dictated by depth and habitat
database developer
No domain defined.
area_code
Auto generated
database developer
No domain defined.
Species_Code
RACE species code
database developer
No domain defined.
species
Species common name
database developer
No domain defined.
area_size_km
size in square km of the each strata within a geographic area
database developer
No domain defined.
CPUE
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area, values are hard coded for previously published values from Japanese surveys. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
RPN
RPN (relative population weight) for each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
RPW
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
mean_length
mean length (cm) for species which have lengths taken in each geographic area
database developer
No domain defined.
mean_weight
mean weight (kg) for species which have lengths taken in each geographic area
database developer
No domain defined.
LastModifiedDate
Last date where data was calcualted and the data in this table was updated.
database developer
No domain defined.
Areas
Every way an area can be categorized. The most basc unit is the geographic_area_name. All others encompass these areas.
AFSC
Area_ID
auto generated
database developer
No domain defined.
area_code
auto generated
database developer
No domain defined.
Geographic_area_name
Geographic areas within management areas, defined by depth and habitat
database developer
No domain defined.
Habitat_type
slope, gully, shelf
database developer
No domain defined.
INPFC_area
Bering 1-5, East and West Aleutians, Shumagin, Chirikof, Kodiak, Yakutat, Southeast
database developer
No domain defined.
Council_management_area
Bering Sea, Aleutians, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, Eastern Gulf
database developer
No domain defined.
Council_sablefish_management_area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
Region
Eastern Bering Sea, Aleutians, Gulf of Alaska
database developer
No domain defined.
FMP_management_area
BSAI, GOA
database developer
No domain defined.
Exploitable
IS the geographic area used for RPN's
database developer
No domain defined.
Council_sablefish_management_area_ID
auto generated
database developer
No domain defined.
AreaStratumEfforts
Calculated Relative Population Indices by depth stratum and small geographic areas.
AFSC
Year
Year of survey
database developer
No domain defined.
Survey
Country that conducted survey (Japan or United States)
database developer
No domain defined.
Geographic_area_name
Smaller areas within the management areas dictated by depth and habitat
database developer
No domain defined.
area_code
Auto generated
database developer
No domain defined.
Council_sablefish_management_area_ID
Auto generated
database developer
No domain defined.
Council_sablefish_management_area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
Species_Code
RACE species code
database developer
No domain defined.
species
Species common name
database developer
No domain defined.
web_reporting_flag
flagged station if catch and average length and weight data is available on the longline survey website
AFSC
No domain defined.
depth_stratum_id2
Autogenerated code specific to stratum
database developer
No domain defined.
stratum2
Stratum code (1-8)
database developer
No domain defined.
StratumDescription
Depth range in m of each stratum (which is a code from 1-10, including 2a, 2b instead of just 2)
database developer
No domain defined.
size_km
stratum size in each geographic area in square km
database developer
No domain defined.
sumsta
Number of stations in each geographic area
AFSC
No domain defined.
sumrpwsta
number of stations in each geographic area used for RPN, RPW, and CPUE calculations
AFSC
No domain defined.
mean_length
mean length (cm) for species which have lengths taken in each geographic area
database developer
No domain defined.
mean_weight
mean weight (kg) for species which have lengths taken in each geographic area
database developer
No domain defined.
CPUE
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area, values are hard coded for previously published values from Japanese surveys. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
RPN
RPN (relative population weight) for each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
RPW
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
a_vonBert
Weight = aLb where a_vonBert = b
database developer
No domain defined.
b_vonBert
Weight = aLb where a_vonBert = b
database developer
No domain defined.
LastModifiedDate
none
database developer
No domain defined.
BadCatches
catch for each species
AFSC
Catch_ID
Auto generated, primary key
AFSC
No domain defined.
Haul_Position_ID
Auto generated
AFSC
No domain defined.
Vessel
vessel code
AFSC
No domain defined.
cruise
cruise number, year + 01. e.g., 200101
AFSC
No domain defined.
station
standard station number. >500 = experimental stations
AFSC
No domain defined.
species_code
RACE species codes
database developer
No domain defined.
hachi
Skate number
AFSC
No domain defined.
catch_freq
number of fish caught on each skate of 45 hooks by species
AFSC
No domain defined.
create_date
date
AFSC
No domain defined.
error_description
why the record could not be added to the catch table at import
AFSC
No domain defined.
depredated_freq
number of fish caught per skate of 45 hooks by species that had evidence of mammal depredation (only part of a fish remaining)
AFSC
No domain defined.
non_depredated_freq
number of fish caught per skate of 45 hooks that had no evidence of depredation by mammals
AFSC
No domain defined.
BadDepths
Table than is populated during data import if there is data catch data that cannot be imported into the depths table.
AFSC
Depth_ID
auto generated
database developer
No domain defined.
Haul_Position_ID
auto generated
database developer
No domain defined.
Vessel
vessel code
AFSC
No domain defined.
cruise
cruise number, year + 01. e.g., 200101
AFSC
No domain defined.
station
standard station number. >500 = experimental stations
AFSC
No domain defined.
hachi
Hachi(also called skate) number. Each hachi gets a number at each station starting with 1 and numbered sequntially.
database developer
No domain defined.
depth_time
time at which hachi was hauled
database developer
No domain defined.
depth
depth taken at haul-back for every 5th skate and when there is a depth stratum change
database developer
No domain defined.
intrpdep
depth interpolated for hachi's where no depth was recorded (recorded for every 5th skate)
database developer
No domain defined.
stratum
depth interval used for summarizing lengths and catch. Increments range from 100-200 meters depending on the stratum
database developer
No domain defined.
baited
number of hooks with bait only at haul-back
database developer
No domain defined.
ineffective
number of hooks that were not fishing effectively at haul-back because they were snarled with other hooks, bent, broken, or missing
database developer
No domain defined.
create_date
date
database developer
No domain defined.
error_description
reason why depth information could not be added to the depths table at import
database developer
No domain defined.
BadHauls
Table than is populated during data import if there is data catch data that cannot be imported into the haul table.
AFSC
Haul_Position_ID
autogenerated
database developer
No domain defined.
Cruise_Station_ID
autogenerated
database developer
No domain defined.
Vessel
vessel code
AFSC
No domain defined.
cruise
cruise number, year + 01. e.g., 200101
AFSC
No domain defined.
haul
haul number (start over every year)
AFSC
No domain defined.
INPFC_area
Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, Esatern Gulf of Alaska
database developer
No domain defined.
station
standard station number. >500 = experimental stations
AFSC
No domain defined.
haul_date
Date haul was set and hauled
database developer
No domain defined.
start_latitude
start latitude of haul (decimal degrees)
database developer
No domain defined.
start_hemi_ns
start hemisphere of the haul (north/south)
database developer
No domain defined.
start_longitude
start longitude of the haul (decimal degrees)
database developer
No domain defined.
start_hemi_ew
start hemisphere of the haul (east/west)
database developer
No domain defined.
end_latitude
end latitude of haul (decimal degrees)
database developer
No domain defined.
end_hemi_ns
end hemisphere of the haul (north/south)
database developer
No domain defined.
end_longitude
end longitude of the haul (decimal degrees)
database developer
No domain defined.
end_hemi_ew
end hemisphere of the haul (east/west)
database developer
No domain defined.
set_start_time
time when haul back starts
database developer
No domain defined.
set_end_time
time when gear set starts
database developer
No domain defined.
haul_start_time
time when haul back starts
database developer
No domain defined.
haul_end_time
time when haul back ends
database developer
No domain defined.
soak_time
time gear was soaking in minutes (set end time - haul start time)
database developer
No domain defined.
distance_fished
length of set in km (approximate)
database developer
No domain defined.
starting_depth
depth of first skate at haul back
database developer
No domain defined.
ending_depth
depth of last skate at haul back
database developer
No domain defined.
surface_temperature
temperatre at the surface at start of haul back
database developer
No domain defined.
gear_temperature
temperature at depth taken from a temperature-depth recorder
database developer
No domain defined.
tdr_depth
depth at which the gear_temperature is taken with a temperature-depth recorder
database developer
No domain defined.
gear_type
type of gear used, determined by specifics of hooks, bait, or any other differences
database developer
No domain defined.
bait_type
type of bait used, consistent in United states survey
database developer
No domain defined.
year
none
database developer
No domain defined.
create_date
used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.
database developer
No domain defined.
mammal_sighting
used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.
database developer
No domain defined.
Depredation_flag
Flag used to document if there was evidence of sperm whale depredation on the haul. Evidence is presence of head and lips or damamged fishing gear (broken hooks)
database developer
No domain defined.
error_description
none
database developer
No domain defined.
BadLengths
Table than is populated during data import if there is data catch data that cannot be imported into the lengths table.
AFSC
Length_ID
Auto generated
database developer
No domain defined.
Cruise_Station_ID
Auto generated
database developer
No domain defined.
Vessel
vessel code
AFSC
No domain defined.
cruise
cruise number, year + 01. e.g., 200101
AFSC
No domain defined.
station
standard station number. >500 = experimental stations
AFSC
No domain defined.
length
length in cm
database developer
No domain defined.
frequency
number of fish lengthed by sex, species, stratum, station
database developer
No domain defined.
sex
m or f
database developer
No domain defined.
stratum
Depth stratum code (1-8)
database developer
No domain defined.
species_code
RACE species codes
database developer
No domain defined.
error_description
none
database developer
No domain defined.
Bait_Types
Lookup table for bait type.
AFSC
Bait_Type_ID
auto generated
AFSC
No domain defined.
Bait_Type
type of bait code used on survey. we stick to 1 bait type
AFSC
No domain defined.
Description
descritpion of bait type
AFSC
No domain defined.
Catches
Every hook that is hauled is assigned one of four codes: a species code if it caught something, baited if a bait is still on the hook, unbaited if the hook was bare but effective, or ineffective if the hook was either snarled, bent or broken, missing, or otherwise unable to fish effectively. Although data is collected by hook, the catch data in the database is summarized by skate (45 hook groupings, also called hachi in the database).
AFSC
Catch_ID
Auto generated, primary key
AFSC
No domain defined.
Depth_ID
auto generated
AFSC
No domain defined.
species_code
RACE species codes
database developer
No domain defined.
catch_freq
number of fish caught on each skate of 45 hooks by species
AFSC
No domain defined.
depredated_freq
number of fish caught per skate of 45 hooks by species that had evidence of mammal depredation (only part of a fish remaining)
AFSC
No domain defined.
non_depredated_freq
number of fish caught per skate of 45 hooks that had no evidence of depredation by mammals
AFSC
No domain defined.
Council_Management_Areas
Lookup table for management area and an area description. Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, Eastern Gulf of Alaska.
AFSC
Council_management_area_ID
Auto generated
database developer
No domain defined.
Council_management_area
Bering Sea, Aleutians, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, Eastern Gulf
database developer
No domain defined.
Description
descritpion of area
AFSC
No domain defined.
Council_Sablefish_Management_Areas
council sablefish management area definitions
AFSC
Council_sablefish_management_area_ID
Auto generated
database developer
No domain defined.
Council_sablefish_management_area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
Description
descritpion of area
AFSC
No domain defined.
Cruise_Stations
table for linking other tables
AFSC
Cruise_Station_ID
Auto generated
database developer
No domain defined.
Cruise_ID
auto generated
AFSC
No domain defined.
Station_ID
auto generated
AFSC
No domain defined.
Cruises
Lookp table that links together the stations, cruises, and haul tables. There are many stations per cruise and multiple hauls per station.
AFSC
Cruise_ID
auto generated
AFSC
No domain defined.
Cruise_Number
cruise number = year + 01
AFSC
No domain defined.
Cruise_Description
none
AFSC
No domain defined.
Vessel_Number
vessel number is 3 digits for Japan and 96 or 81 for United States
AFSC
No domain defined.
Year
Year of survey
database developer
No domain defined.
Depredation_Types
Lookup table for a description of depredation types.
AFSC
Depredation_Type
Code for the type of marine mammal depredation. For now, used for when there is evidence of sperm whale depredation (not killer whale, see rpn_filter).
AFSC
No domain defined.
Description
type of mammal
AFSC
No domain defined.
Depth_Stratum
Lookup table for stratum information.
AFSC
Depth_Stratum_ID
auto generated
database developer
No domain defined.
Stratum
depth interval used for summarizing lengths and catch. Increments range from 100-200 meters depending on the stratum.
database developer
No domain defined.
Description
Depth interval of the stratum in meters
database developer
No domain defined.
StartDepth
start depth of each stratum
database developer
No domain defined.
EndDepth
end depth of each stratum
database developer
No domain defined.
Depths
Data specific to each hachi (segement of gear that is 45 hooks).
AFSC
Depth_ID
auto generated
database developer
No domain defined.
Haul_Position_ID
auto generated
database developer
No domain defined.
hachi
Hachi(also called skate) number. Each hachi gets a number at each station starting with 1 and numbered sequntially.
database developer
No domain defined.
depth_time
time at which hachi was hauled
database developer
No domain defined.
depth
depth taken at haul-back for every 5th skate and when there is a depth stratum change
database developer
No domain defined.
intrpdep
depth interpolated for hachi's where no depth was recorded (recorded for every 5th skate)
database developer
No domain defined.
depth_stratum_id
Autogenerated ID
database developer
No domain defined.
baited
number of hooks with bait only at haul-back
database developer
No domain defined.
ineffective
number of hooks that were not fishing effectively at haul-back because they were snarled with other hooks, bent, broken, or missing
database developer
No domain defined.
rpn_filter
If there is a value here the hachi is not being used for RPN calculations. This is mainly used for filtering out hachi's when there was killer whale depredation.
database developer
No domain defined.
depth_stratum_id2
Autogenerated ID
database developer
No domain defined.
FMP_Management_Areas
Lookup table
AFSC
FMP_Management_Area_ID
Auto generated
database developer
No domain defined.
FMP_Management_Area
GOA or BSAI
database developer
No domain defined.
Description
field is now null, description of FMP_management_area field
database developer
No domain defined.
Gear_Types
Lookup table for gear types
AFSC
Gear_Type_ID
auto generated
database developer
No domain defined.
Gear_Type
same gear type used on U.S. survey (code 915) Gear type code is used when anything changes on the gear (could potentially be bait, hook size, etc.)
database developer
No domain defined.
Description
description of the gear
database developer
No domain defined.
Geographic_areas
Lookup table for geographic areas (smallest area unit available)
AFSC
Geographic_area_ID
Auto generated
database developer
No domain defined.
Geographic_area_name
Smaller areas within the management areas dictated by depth and habitat
database developer
No domain defined.
Description
is null currently. Could be a description of the habitat and depth range of the area
database developer
No domain defined.
Habitat_Types
Lookup table for habitat types
AFSC
Habitat_Types_ID
Auto generated
database developer
No domain defined.
Habitat_Types
Depp or shallow gully, or slope
database developer
No domain defined.
Description
currently null, could a description of Habitat_type field
database developer
No domain defined.
Haul_positions
This table provides data related to each haul. There are generally 2 hauls per station except at gully stations.
AFSC
Haul_Position_ID
autogenerated
database developer
No domain defined.
Cruise_Station_ID
autogenerated
database developer
No domain defined.
haul
haul number is sequential through the season, starting with 1. On most stations there are 2 hauls per day. The exception is the Bering Sea and gullies (where each station has 1 haul). In catch views the data is specific to the station and not the haul (as it is in this table).
database developer
No domain defined.
haul_date
Date haul was set and hauled
database developer
No domain defined.
start_latitude
start latitude of haul (decimal degrees)
database developer
No domain defined.
start_hemi_ns
start hemisphere of the haul (north/south)
database developer
No domain defined.
start_longitude
start longitude of the haul (decimal degrees)
database developer
No domain defined.
start_hemi_ew
start hemisphere of the haul (east/west)
database developer
No domain defined.
end_latitude
end latitude of haul (decimal degrees)
database developer
No domain defined.
end_hemi_ns
end hemisphere of the haul (north/south)
database developer
No domain defined.
end_longitude
end longitude of the haul (decimal degrees)
database developer
No domain defined.
end_hemi_ew
end hemisphere of the haul (east/west)
database developer
No domain defined.
set_start_time
time when haul back starts
database developer
No domain defined.
set_end_time
time when gear set starts
database developer
No domain defined.
haul_start_time
time when haul back starts
database developer
No domain defined.
haul_end_time
time when haul back ends
database developer
No domain defined.
soak_time
time gear was soaking in minutes (set end time - haul start time)
database developer
No domain defined.
distance_fished
length of set in km (approximate)
database developer
No domain defined.
starting_depth
depth of first skate at haul back
database developer
No domain defined.
ending_depth
depth of last skate at haul back
database developer
No domain defined.
surface_temperature
temperatre at the surface at start of haul back
database developer
No domain defined.
gear_temperature
temperature at depth taken from a temperature-depth recorder
database developer
No domain defined.
tdr_depth
depth at which the gear_temperature is taken with a temperature-depth recorder
database developer
No domain defined.
gear_type
type of gear used, determined by specifics of hooks, bait, or any other differences
database developer
No domain defined.
bait_type
type of bait used, consistent in United states survey
database developer
No domain defined.
mammal_sighting
used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.
database developer
No domain defined.
Depredation_flag
Flag used to document if there was evidence of sperm whale depredation on the haul. Evidence is presence of head and lips or damamged fishing gear (broken hooks)
database developer
No domain defined.
INPFC_Areas
Lookup table with INPFC area descriptions
AFSC
INPFC_Area_ID
auto generated
database developer
No domain defined.
INPFC_Area
geo graphic area names defined by habitat. Same areas use by the trawl survey for random, e.g., Bering I, Kodiak, Shumagin, Yakutat...)
database developer
No domain defined.
Description
Currently null, could be a description of the INPFC_area
database developer
No domain defined.
LengthFrequencies
This table extrapolates the length frequencies by species to relative population numbers (RPNs) (i.e., number of fish at each length in the population, where the population is in RPNs and so is only a relative index).
AFSC
Year
Year of survey
database developer
No domain defined.
Country
country
AFSC
No domain defined.
Vessel_Number
vessel number is 3 digits for Japan and 96 or 81 for United States
AFSC
No domain defined.
Vessel_name
Name of the fishing vessel.
AFSC
No domain defined.
Cruise_Number
cruise number = year + 01
AFSC
No domain defined.
area_code
Code specific to each Geographic_area_name.
database developer
No domain defined.
Geographic_area_name
Smaller areas within the management areas dictated by depth and habitat (e.g., Kodiak, Bering I, Yakutat, Shumagin).
database developer
No domain defined.
Council_sablefish_management_area
Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside.
database developer
No domain defined.
Species_Code
RACE species code
database developer
No domain defined.
Common_Name
species common name
database developer
No domain defined.
sex
m or f
database developer
No domain defined.
length
length in cm
database developer
No domain defined.
length_frequency
area
AFSC
No domain defined.
LastModifiedDate
Last date data was added or recalculated
AFSC
No domain defined.
LengthFrequenciesStrata3to7
This table extrapolates the length frequencies by species to relative population numbers (RPNs) (i.e., number of fish at each length in the population, where the population is in RPNs and so is only a relative index). Lengthfrequenciesstrata3to7 has only data for strata 3-7 (201-1,000 m).
AFSC
Year
Year of survey
database developer
No domain defined.
Country
country
AFSC
No domain defined.
Vessel_Number
vessel number is 3 digits for Japan and 96 or 81 for United States
AFSC
No domain defined.
Vessel_name
Name of the fishing vessel.
AFSC
No domain defined.
Cruise_Number
cruise number = year + 01
AFSC
No domain defined.
area_code
Code specific to each Geographic_area_name.
database developer
No domain defined.
Geographic_area_name
Smaller areas within the management areas dictated by depth and habitat (e.g., Kodiak, Bering I, Yakutat, Shumagin).
database developer
No domain defined.
Council_sablefish_management_area
Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside.
database developer
No domain defined.
Species_Code
RACE species code
database developer
No domain defined.
Common_Name
species common name
database developer
No domain defined.
sex
m or f
database developer
No domain defined.
length
length in cm
database developer
No domain defined.
length_frequency
area
AFSC
No domain defined.
LastModifiedDate
Last date data was added or recalculated
AFSC
No domain defined.
Lengths
Count of lengths by species, sex, length, cruise, station, and depth stratum.
AFSC
Length_ID
Auto generated
database developer
No domain defined.
Cruise_Station_ID
Auto generated
database developer
No domain defined.
depth_stratum_id
Depth stratum code (1-8)
database developer
No domain defined.
species_code
RACE species codes
database developer
No domain defined.
sex
m or f
database developer
No domain defined.
length
length in cm
database developer
No domain defined.
frequency
number of fish lengthed by sex, species, stratum, station
database developer
No domain defined.
Maturity
maturity code descriptions
AFSC
Code
maturity code 1-6 used for sablefish
database developer
No domain defined.
Description
description of the sabelfish maturity code
database developer
No domain defined.
MaxHachilnFirstHaul
Used in calcualted process for RPNs and RPWs.
AFSC
vessel
vessel number is 3 digits for Japan and 96 or 81 for United States
database developer
No domain defined.
cruise
cruise number = year + 01 (e.g., 201001 for 2010)
database developer
No domain defined.
station
Fixed station number which are sampled annually. Station numbers over 500 are experimental and were not sampled regularly. A few others were also not sampled through the entire time series.
database developer
No domain defined.
maxHachiFirstHaul
Last hachi on the first haul
database developer
No domain defined.
Regions
Region list (AI, BS, GOA)
AFSC
Region_ID
autogenerated
database developer
No domain defined.
Region
AI, EBS, or GOA
database developer
No domain defined.
Description
Currently Null, but could describe Region
database developer
No domain defined.
SablefishOtolith_import
Intermediary table used for importing sablefish speciment data into Ages. These are fish sampled for otoliths, maturity, lengths, and weights.
AFSC
vessel
vessel code
database developer
No domain defined.
cruise
cruise number = year + 01(e.g.,201001 for 2010)
database developer
No domain defined.
Station
Station number (same in all years)
database developer
No domain defined.
SpeciesCode
AFSC RACE trawl survey species code
database developer
No domain defined.
Sex
Sex (1 = male, 2 = female, 3= unknown)
database developer
No domain defined.
Maturity
Maturity code used for both males and females.
database developer
No domain defined.
Length
Total length in cm
database developer
No domain defined.
Specimen_Number
ID assigned to each specimen. Not unique (start at 1 every year).
database developer
No domain defined.
stratum
Depth stratum code
database developer
No domain defined.
age
age in years
database developer
No domain defined.
wt kg
weight in kg
database developer
No domain defined.
Settings
Unused
AFSC
ID
autogenerated
database developer
No domain defined.
cruise
cruise number = year + 01(e.g.,201001 for 2010)
database developer
No domain defined.
SurveyStartDate
Start date of survey
database developer
No domain defined.
SurveyEndDate
End date of survey
database developer
No domain defined.
Sex
Lookup table for sex (1, 2, or 3)
AFSC
Code
1, 2, or 3
database developer
No domain defined.
Description
male, female, or unknown
database developer
No domain defined.
Specie_Catch_Codes
Data specific to each species, including species codes, growth parameters, and western Aleutian Islands extraploation ratios.
AFSC
Specie_catch_code_id
autogenerated
database developer
No domain defined.
Polycorder_Number
code used for each species when catch is tabulated as it is hauled on-baord
database developer
No domain defined.
Species_Code
RACEspecies code
database developer
No domain defined.
Common_Name
Species common name
database developer
No domain defined.
Scientific_name
Species scientific name
database developer
No domain defined.
a_vonBert
Von bertalanffy growth curve coeficient for species that are lengthed on the survey
database developer
No domain defined.
b_vonBert
Von bertalanffy growth curve coeficient for species that are lengthed on the survey
database developer
No domain defined.
process_type
null
database developer
No domain defined.
web_reporting_flag
Flag if data is available on teh AFSC website
database developer
No domain defined.
survey_species_flag
Flag is species have lenghts
database developer
No domain defined.
NW_AI_ratio
Species specific ratios of northeast and northwest Aleutian Islands (AI) RPNs from Japanese surveys (1985-1994) used to extrapolate northeastern AI RPNs, RPWs, and CPUEs for current surveys.
database developer
No domain defined.
SW_AI_ratio
Species specific ratios of southeast and southwest Aleutian Islands (AI) RPNs from Japanese surveys (1985-1994) used to extrapolate southeastern AI RPNs, RPWs, and CPUEs for current surveys.
database developer
No domain defined.
avg_weight
Average weight used to calculate total weight of fish caught on the survey if no lengths are taken during the survey. Data comes from longline fisheries in Alaska.
database developer
No domain defined.
Sppcode_Catch
Species codes and names
AFSC
Polycorder_Number
Longline survey species code
database developer
No domain defined.
Species Code
AFSC RACE trawl survey species code
database developer
No domain defined.
Common_Name
None
database developer
No domain defined.
Scientific_Name
None
database developer
No domain defined.
SRREStationRates
Ratio of shortraker and rougheye caught by station. Used for separating catch where there were no lengths taken. (Catch cannot be differentiaed when being haul on-board, so ratios are used to separate out catch into two species when there are not lengths taken).
AFSC
Shortraker_Rate
Proportion of shortraker/rougheye catch that was shortraker rockfish.
database developer
No domain defined.
Rougheye_Rate
Proportion of shortraker/rougheye catch that was rougheye rockfish.
database developer
No domain defined.
Station_Types
Lookup table for station type (either standard or experimental)
AFSC
Station_Type_ID
autogenerated
database developer
No domain defined.
Description
standard survey station or experimental (not done annually)
database developer
No domain defined.
StationEfforts
Unions SRRECPUE and CPUE to produce all Station/Stratum-level CPUE, RPN, and RPW values. From here on when mean weight is calculated it is not averaged as length is, it is always calculated using the a and b parameters in specie_catch_codes. SRRE is short for shortraker and rougheye rockfish. In short, this is an intermediate table used for calculating CPUE and indices of abundance (RPNs and RPWs). It is catch and effort by depth strata.
AFSC
Year
Year of survey
database developer
No domain defined.
Cruise_Station_ID
Auto generated
database developer
No domain defined.
Cruise_Number
cruise number = year + 01
AFSC
No domain defined.
Vessel_Number
vessel number is 3 digits for Japan and 96 or 81 for United States
AFSC
No domain defined.
Country
country
AFSC
No domain defined.
Station_Number
Fixed station numbers. Numbers over 500 are experimental stations and are not standard
AFSC
No domain defined.
RPW_Station_Number
Stations used for RPN's
AFSC
No domain defined.
area_id
Auto generated
database developer
No domain defined.
area_code
Auto generated
database developer
No domain defined.
Geographic_area_name
Smaller areas within the management areas dictated by depth and habitat
database developer
No domain defined.
Council_sablefish_management_area_ID
auto generated
database developer
No domain defined.
Council_sablefish_management_area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
size_km
stratum size in each geographic area in square km
database developer
No domain defined.
depth_stratum_id2
Stratum code
database developer
No domain defined.
stratum2
Stratum in meters
database developer
No domain defined.
Species_Code
RACE species code
database developer
No domain defined.
Common_Name
Species common name
database developer
No domain defined.
web_reporting_flag
Species flagged if it is a major groundfish species caught and is therefore reported on the website (summarized catch, RPN's...)
database developer
No domain defined.
total_skates
number of skates set at each stratum, station
AFSC
No domain defined.
total_catch
number of fish caught by species, depth stratum, station
AFSC
No domain defined.
total_length_freq
-no description-
AFSC
No domain defined.
CPUE
Average CPUE (catch in number per skate of 45 hooks) scaled to each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only. All values are calcualted; none are hard coded numbers prom previously publishe reports (see areaeffortsd fixed for that).
database developer
No domain defined.
mean_length
mean length (cm) for species which have lengths taken in each geographic area
database developer
No domain defined.
mean_weight
mean weight (kg) for species which have lengths taken in each geographic area
database developer
No domain defined.
RPN
RPN (relative population weight) for each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
RPW
RPW (relative population number) for each strata in each geographic area, values are hard coded for previously published values from Japanese surveys for each geographic area. Western Aleutian Islands are extrapolated with hard-coded ratios of historic survey catch for the Western and eastern Aleutians for sablefish only, for United States only.
database developer
No domain defined.
a_vonBert
Weight = aLb where a_vonBert = b
database developer
No domain defined.
b_vonBert
Weight = aLb where a_vonBert = b
database developer
No domain defined.
LastModifiedDate
none
database developer
No domain defined.
Stations
Station specific information
AFSC
Station_ID
auto generated
database developer
No domain defined.
Area_ID
auto generated
database developer
No domain defined.
Station_Number
Fixed station numbers. Numbers over 500 are experimental stations and are not standard
database developer
No domain defined.
Description
describes experimental station
database developer
No domain defined.
Old_Station_Number
mostly null, station # may have had a different # in the past, go with sttaion_number
database developer
No domain defined.
Active
1 if we sample it regulrly since 1996, otherwise 0
database developer
No domain defined.
RPW_Flag
Flag for station if it is used in RPN/RPW/CPUE calcualtions
database developer
No domain defined.
Station_Type_ID
auto generated
database developer
No domain defined.
Longitude
standard station longitude
database developer
No domain defined.
Latitude
standard station latitude
database developer
No domain defined.
NMFS_Area_Code
NMFS management area code for that station.
database developer
No domain defined.
TotalCatchWeight
Total catch in numbers and weight for each station. Total weight is calculated from length frequencies for species that have lengths taken on the survey. For all others, and average weight from longline fishery data in Alaska is used.
AFSC
Year
vessel number is 3 digits for Japan and 96 or 81 for United States
database developer
No domain defined.
Country
Country that conducted the survey. Can be either Japan or United States.
database developer
No domain defined.
Station_Number
Station number (same in all years)
database developer
No domain defined.
NMFS_Area_Code
NMFS management area code for that station.
database developer
No domain defined.
Species_Code
AFSC RACE trawl survey species code
database developer
No domain defined.
Common_Name
Species common name or genera.
database developer
No domain defined.
Total_Catch
Number of fish caught by station and species.
database developer
No domain defined.
Ttoal_Weight_kg
Total estimated weight of each species by station.
database developer
No domain defined.
Vessels
Look up tables for vessel information.
AFSC
Vessel_Number
vessel number is 3 digits for Japan and 96 or 81 for United States
database developer
No domain defined.
Vessel_Name
-no description-
database developer
No domain defined.
Country
Country conducting survey, either Japan or United States
database developer
No domain defined.
WebAreas
Summarized CPUE and population indices provided on the AFSC website for the public by sablefish Council management areas.
AFSC
year
year of survey
database developer
No domain defined.
survey
Country that conducted survey, either Japan or United States
database developer
No domain defined.
Area_ID
auto generated
database developer
No domain defined.
Area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
species_code
RACEspecies code
database developer
No domain defined.
species
species common name
database developer
No domain defined.
CPUE
CPUE for the area weighted by strata size
database developer
No domain defined.
RPN
RPN for the area for strata 3-7
database developer
No domain defined.
RPW
RPW for the area for strata 3-7
database developer
No domain defined.
WebStations
Summarized CPUE and population indices provided on the AFSC website for the public by sablefish Council management areas.
AFSC
Year
year of the survey
database developer
No domain defined.
Survey
either Japan or United States
database developer
No domain defined.
Station
Fixed station numbers. Numbers over 500 are experimental stations and are not standard
database developer
No domain defined.
Area_ID
autogenerated
database developer
No domain defined.
Area
Management areas: Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, West Yakutat, and Southeast/Outside
database developer
No domain defined.
Species_Code
RACEspecies code
database developer
No domain defined.
Species
species common name
database developer
No domain defined.
Total Catch
catch at each station, rougheye and sortraker extrapolated from proportions from lengths taken at each strata
database developer
No domain defined.
Mean Length (mm)
mean length at each station
database developer
No domain defined.
Mean Weight (kg)
mean weight at each station
database developer
No domain defined.
Latitude
start latitude
database developer
No domain defined.
Longitude
start longitude
database developer
No domain defined.