Lower Cook Inlet Salmon Escapement Database, 1927–2018

This database contains salmon escapement data collected primarily by the Alaska Department of Fish and Game, Division of Commercial Fisheries (ADF&G-CF), in the Lower Cook Inlet (LCI) management area in southcentral Alaska. To facilitate informed inseason management of commercial fisheries targeting Pacific salmon Oncorhynchus spp., ADF&G-CF uses a variety of methods to monitor escapement on select index streams in LCI (e.g., aerial/ground survey, weir, remote video). Aerial and ground surveyors make periodic counts of sockeye O. nerka, chum O. keta, and pink O. gorbuscha salmon throughout the duration of their respective runs, whereas weir and remote video projects document daily fish passage. Fishery managers use these data daily to manipulate time and area fishery openings/closures to assure that the final escapement level for monitored stocks falls within their individual escapement goal ranges. At the end of the season, periodic aerial and ground survey counts are used to calculate a final escapement index for each stream based on the area-under-the-curve method (AUC; pink and chum salmon) or the peak survey count (sockeye salmon). This LCI salmon escapement database spans the period 1927–2018, which includes data collected by federal fisheries personnel prior to Alaska statehood (1959). The database is comprised of 6 related tables and 1 stand-alone table. Four of the related tables are lookup tables defining primary key fields that are linked to the main data tables. The 2 linked main data tables (1_Escapement Header and 2_Escapement Data) respectively contain relevant details for each survey/escapement monitoring project conducted (e.g., survey ID, date, survey type, survey conditions, etc.) and the fine scale results for each survey ID (e.g., live/dead count by species, stream, stream section, etc.). The escapement data table includes XY coordinates for counts (typically stratified by stream section) so the data can be viewed/analyzed spatially. Finally, because it may be difficult for users of this database to convert individual survey counts into final escapement indices, this database also includes a stand-alone table (3_Reported Escapement) that provides final escapements by stock, species, and year, as well as associated information such as the method used to derive the escapement. This dataset record includes the Microsoft Access database, in addition to plain text exports of each of the tables within that database.本数据库收录的核心数据为阿拉斯加鱼类与野生动物保护部商业渔业分部（Alaska Department of Fish and Game, Division of Commercial Fisheries，缩写ADF&G-CF）在阿拉斯加中南部下库克湾（Lower Cook Inlet，缩写LCI）管理区域采集的鲑鱼逃逸量数据。为辅助针对太平洋鲑属（Oncorhynchus spp.）商业渔业的季内精细化管理，ADF&G-CF采用多种手段对LCI内选定的指标溪流开展逃逸量监测，包括航空/地面普查、鱼栅监测、远程视频监测等。航空与地面普查人员会在对应鲑鱼洄游季期间，定期统计红大麻哈鱼（O. nerka）、狗大麻哈鱼（O. keta）以及粉大麻哈鱼（O. gorbuscha）的种群数量；而鱼栅与远程视频监测项目则会逐日记录鱼类通行情况。渔业管理人员每日依托这些数据调整捕捞作业的时间与区域开闭策略，确保受监测种群的最终逃逸量落在其预设逃逸目标区间内。季末时，研究人员会借助周期性航空与地面普查数据，通过曲线下面积法（Area-under-the-curve, AUC，适用于粉大麻哈鱼与狗大麻哈鱼）或峰值普查计数法（适用于红大麻哈鱼）计算各溪流的最终逃逸量指数。本LCI鲑鱼逃逸量数据库的时间跨度为1927年至2018年，其中包含阿拉斯加建州（1959年）前由联邦渔业人员采集的历史数据。该数据库由6张关联表与1张独立表构成：其中4张关联表为查找表，用于定义与主数据表关联的主键字段；2张关联主数据表分别为「1_逃逸量表头」与「2_逃逸量数据」，前者收录了每项普查/逃逸量监测项目的核心详情，例如普查ID、调查日期、普查类型、普查环境等，后者则包含对应每个普查ID的精细化统计结果，例如按物种、溪流、溪流分段划分的活鱼/死鱼计数等。逃逸量数据表包含了各计数点的XY坐标（通常按溪流分段分层统计），以便对数据开展空间可视化与分析。此外，考虑到数据库用户可能难以将单次普查计数转换为最终逃逸量指数，本数据库还附带了一张独立表「3_已报告逃逸量」，该表提供了按种群、物种与年份划分的最终逃逸量数据，以及推导逃逸量所采用的监测方法等相关配套信息。本数据集除包含Microsoft Access数据库文件外，还附带了该数据库内所有表格的纯文本导出文件。