APPROACHES TO DATA ORGANIZATION AND MAPPING FOR HISTORIC FISH DISTRIBUTIONS…

Much welcomed fresh snow in the morning!

Much welcomed fresh snow in the morning!

As a Sierra Fellow, my role is to assist with the development of a basin-scale assessment and restoration framework for the fisheries of the Upper Feather River (above Lake Oroville). Read my first blog post here!

Thankfully, snow and rain have continued to fall fairly consistently here in the Almanor Basin and across the state (a snow covered lawn makes a fantastic place for practicing fly-casting!). With these changes in season, the first phase of the Upper Feather River Basin-wide Native Fisheries Assessment and Improvement Strategy has entered full swing, and with it a number of interesting challenges and questions have arisen.

Of these challenges, first and foremost, we must tackle the challenge of database organization. The historic fishery distribution data collected for the first phase of this project will be great in volume and disparate in depth. Consequently, it is an important task to develop protocols and methods for data organization in order to facilitate subsequent workflows. The primary questions have been:

  • What are the best database management systems and tools for use in this type of project?
  • What are the capabilities needed from these systems and sets of tools to accomplish our goals?
  • What is going to be the best way to share information produced for use by the scientific community and the general public?

Another important concern is that the systems and tools used must be flexible enough to efficiently capture information from a variety of sources. The range of these anticipated sources include peer-reviewed literature, natural resource survey data from multiple agencies and private companies, as well as anecdotal information from interviews with local anglers. All of these questions have indicated a real need for thoughtful organization up front.

Another challenge has been ascertaining the location of historic fishery data for Upper Feather River watershed. The primary questions involved have been:

  • What data is available?
  • Where precisely is the information located? and
  • In what format is the data recorded (hopefully, digitized in some manner!)?
Getting acquainted with the watershed and some of the available fishery data!

Getting acquainted with the watershed and some of the available fishery data!

Fishery data encountered so far has come in a number of forms. While the best data, or that which we have the most confidence in with respect to accuracy, comes in the form of fishery-specific surveys utilizing electrofishing or snorkel counts as a method, other forms include stream-side surveys, and even habitat surveys. (Habitat surveys can, based on quality of habitat in a given stream reach, infer the presence of fish in a given area.)

Because data on the Upper Feather has been collected by so many different entities over the years, relevant data varies in collection method, sampling protocol, and format, and is stored in locations across the state. Some of the needed data range in location from ranger district offices in the eastern portions of Plumas National Forest to California Department of Fish and Wildlife archives in their Sacramento area headquarters. Additionally, important information may be found in data that exists in the form of scribbled lines in a field notebook circa the 1950s, or a fully assembled online database and mapping tool. The discrepancies in depth, location, and accessibility of these available data create the base for my first major hurdle in advancing the data-collection phase of the Basin-wide Assessment.

An additional source of valuable historic information on the quality of the fishery in the past can be found in the expertise of long-time anglers familiar with certain areas of the Basin. In order to acquire this information I will be capturing interviews with these individuals via recordings or videos, and use these accounts to assist in my understanding of historic distributions of different fish species. I mean to collect accounts from as many of these individuals as possible in order to examine the validity of information gathered via interview by looking for correlation with natural resource survey data collected in the same areas that they describe. If a correlation between survey-based distribution data and interview-based data is apparent it will be included in distribution analyses, utilizing the experience of these anglers as a wealth of informal sampling knowledge.

Once all of these varying forms of data are organized and collated, there arises the task of representing this information geographically in order to determine where fish were located in the past and how that has changed over time. This information will provide some indication as to where habitat stressors affecting the fishery may be present or where conditions have remained stable, highlighting areas that may be most important to examine in a later assessment focused on habitat conditions. Habitat stressors can occur at various scales. They can be a landscape-wide phenomenon, such as excessive sediment loading from an eroding road system, or they can occur at the level of the stream itself, such as where an agricultural water diversion takes place. Consequently, I plan to represent species distributions in the Upper Feather River both at the watershed and stream level.

Rainbow trout presence (in red) in a portion of the Upper Feather River Basin, displayed at the watershed scale, USGS 14-digit Hydrologic Unit Code (HUC). Data obtained courtesy of USFS.

Rainbow trout presence (in red) in a portion of the Upper Feather River Basin, displayed at the watershed scale, USGS 14-digit Hydrologic Unit Code (HUC). Data obtained courtesy of USFS.

To display distribution by watershed, one potential method will involve symbolizing each watershed unit for species presence, absence, or richness (i.e. number of species). This representation can provide information on species abundance, both qualitatively (with categories like few, common, or abundant) and quantitatively (using specific species count numbers) depending on data availability and quality. An example of this representation appears above, which shows rainbow trout presence (in red) by watershed in and around the Lake Almanor basin. A map like this really elucidates the range of a given species, which is certainly an important piece of information, but perhaps not enough to make truly informed management decisions. It’s also necessary for resource managers to know what is affecting fish populations very near to and right within the place they live: the water!!!

Chinook salmon distribution, displayed at the stream reach scale, for four neighboring foothill streams. Data obtained courtesy of CDFW.

Chinook salmon distribution, displayed at the stream reach scale, for four neighboring foothill streams. Data obtained courtesy of CDFW.

Another method is to display distribution by stream reach, which shows the extent of a species’ distribution on an actual mapped stream or river feature. Representing distribution in this way can yield significantly more useable information for management as it occurs on a finer scale than that of watershed-based representation. For instance, one species may use a certain tributary in a watershed while its non-native competitor uses that and two others, thus indicating that restoration should be focused where it might be of the most benefit to native species. An example of this representation looks like the figure above, which displays the extent of Chinook salmon distribution in four neighboring foothill stream systems. The data used for this example was retrieved from the California Department of Fish and Wildlife Biogeographic and Observation System (BIOS). Another powerful example is StreamNet, a regional forum for fish and aquatic habitat information management and data sharing in the Columbia River Basin that includes extensive reach level distribution data.

I anticipate constructing datasets using both methods for the Upper Feather River Basin-wide Assessment and looking at each at various appropriate timescales and incorporating varying levels of data confidence. The assessment will include information on probable distribution in the geologic and prehistoric past. One way this information can be generated is through modeling historic habitat conditions and inferring distribution from the results but for this assessment this information will likely come primarily from literature review.

However, synthesizing information from the available survey record of the last century, in the manner described above, will help managers to better understand trends that have been occurring over more recent decades and to make informed decisions therefrom. I hope to develop maps of displaying more- and less-conservative estimates of distribution by incorporating greater and fewer data sources, ranging from layers based solely on the conventional fish population sampling methods of electrofishing and snorkel surveys to layers incorporating all available data sources.

I will be excited to share the results of these analyses and some powerful stories about the quality of fishery in the past that will hopefully inspire progress towards recovery for the future. Please comment with any thoughts, suggestions or pointers.