Analysis of Stream Temperature Variation of Logan River to Assess Suitability for Trout Population

The accompanying datasets consist of a SQLite database and a processing code for analyzing the temperature observations at different sites in the Logan River Observatory for accessing the suitability of temperature in the Logan River for Trout population. The provided SQLite database consists of a time series of water temperature observations of the Logan River at six different Sites. All the sites have a specific site ID (1, 2, 3, 9, 10, and 13) and are a part of the Logan River Observatory. Similarly, the Python code provides an analysis of monthly temperature at three selected sites within the observatory which the user can specify by themselves. The Python code is capable of generating plots for average monthly temperature and monthly maximum temperature at the three specified sites.

本配套数据集包含一个SQLite数据库，以及一套用于分析洛根河观测站（Logan River Observatory）各监测点水温观测数据的处理代码，旨在评估洛根河水温对鳟鱼种群的适宜性。本次提供的SQLite数据库包含洛根河6个不同监测点的水温观测时间序列数据，所有监测点均配有唯一站点编号（1、2、3、9、10和13），且均隶属于洛根河观测站。配套的Python代码可对观测站内用户自行指定的3个选定监测点的月度水温数据开展分析，能够生成这3个指定监测点的月均水温与月最高水温可视化图表。