17218 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 27266 Entity 27268 Entity 27269 Entity 27270 Entity 27272 Entity 27271 Entity 27273 Entity 27274 Entity 27275 Entity 27276 Entity 27277 Entity 27278 Entity 27279 Entity 27280 Entity 27281 Entity 27282 Entity 27283 Entity 27284 Entity 27285 Entity 27286 Entity 27287 Entity 27288 Entity 27289 Entity 27290 Entity 27291 Entity 27292 Entity 27293 Entity 27294 Entity 27295 Entity 27296 Entity 27297 Entity 27303 Entity 27298 Entity 27299 Entity 27300 Entity 27301 Entity 27302 Entity 27305 Entity 27304 Entity 27306 Entity 27307 Entity 27308 Entity 27309 Entity 27310 Entity 27267 Entity gov.noaa.nmfs.inport:17218 Doug Turnbull 2012-12-12T19:50:03 SysAdmin InPortAdmin 2025-05-15T19:15:47 2016-05-18 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 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.