Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
RSS Feed for updates to Project 2011-020-00 - Data Management Project Follow this via RSS feed. Help setting up RSS feeds?

Project Summary

Project 2011-020-00 - Data Management Project
Project Number:
2011-020-00
Title:
Data Management Project
Summary:
The Intermountain Province Subbasin Data Management Project will provide subbasin level information on the
status of resident fish, wildlife, and their habitats through the development of a flexible web-enabled
geospatial database management system (GEDMS). Providing information in a web-enabled format will
support new and ongoing research, improve monitoring and evaluation strategies, and allow data analysis to
be effectively utilized by natural resources managers. Additionally, the website will be used as a place to
disseminate natural resource information to the public.
Proposer:
Proponent Orgs:
Kalispel Tribe (Tribe)
Starting FY:
2012
Ending FY:
2032
BPA PM:
Stage:
Implementation - Project Status Report
Area:
Province Subbasin %
Intermountain Pend Oreille 100.00%
Purpose:
Habitat
Emphasis:
Data Management
Focal Species:
Bass, Largemouth
Bass, Smallmouth
Burbot
Carp, Common
Crappie, Black
Crappie, White
Cutthroat Trout, Westslope
Kokanee
Perch, Yellow
Pike, Northern
Pikeminnow, Northern
Trout, Brook
Trout, Brown
Trout, Bull
Trout, Interior Redband
Trout, Lake
Trout, Rainbow
Walleye
Whitefish, Mountain
Wildlife
Species Benefit:
Anadromous: 0.0%   Resident: 50.0%   Wildlife: 50.0%
Special:
None
BiOp Association:
None

No photos have been uploaded yet for this Project.

Summary of Budgets

To view all expenditures for all fiscal years, click "Project Exp. by FY"

To see more detailed project budget information, please visit the "Project Budget" page

Decided Budget Transfers  (FY2019 - FY2021)

Acct FY Acct Type Amount Fund Budget Decision Date
FY2019 Expense $100,000 From: Fish Accord - Kalispel Fish Accord Review (Kalispel MOA) 07/12/2012
FY2019 Expense $18,869 From: Fish Accord - Kalispel Fish Accord project COLA (Kalispel MOA) 07/13/2012
FY2019 Expense $9,549 From: Fish Accord - Kalispel Accord Budget transfers (Kalispel) 10/18/2018 10/19/2018
FY2019 Expense $26,112 From: Fish Accord - Kalispel Accord Budget transfers (Kalispel) 10/18/2018 10/19/2018
FY2020 Expense $100,000 From: Fish Accord - Kalispel Fish Accord Review (Kalispel MOA) 07/12/2012
FY2020 Expense $21,840 From: Fish Accord - Kalispel Fish Accord project COLA (Kalispel MOA) 07/13/2012
FY2020 Expense $26,400 From: Fish Accord - Kalispel Accord Budget transfers (Kalispel) 10/18/2018 10/19/2018
FY2020 Expense $10,152 From: Fish Accord - Kalispel Accord Budget transfers (Kalispel) 10/18/2018 10/19/2018
FY2021 Expense $100,000 From: Fish Accord - Kalispel Fish Accord Review (Kalispel MOA) 07/12/2012
FY2021 Expense $24,886 From: Fish Accord - Kalispel Fish Accord project COLA (Kalispel MOA) 07/13/2012
FY2021 Expense $48,390 From: Fish Accord - Kalispel Accord Budget transfers (Kalispel) 10/18/2018 10/19/2018
FY2021 Expense $10,152 To: Fish Accord - Kalispel Accord Budget transfers (Kalispel) 10/18/2018 10/19/2018

Pending Budget Decision?  No


Actual Project Cost Share

Current Fiscal Year — 2020
Cost Share Partner Total Proposed Contribution Total Confirmed Contribution
There are no project cost share contributions to show.
Previous Fiscal Years
Fiscal Year Total Contributions % of Budget
There are no cost share summaries to display from previous years.

Contracts

The table below contains contracts with the following statuses: Active, Complete, History, Issued.
* "Total Contracted Amount" column includes contracted amount from both capital and expense components of the contract.
Expense Contracts:
Number Contractor Name Title Status Total Contracted Amount Dates
74488 REL 28 SOW Kalispel Tribe 2011-020-00 EXP DATA MANAGEMENT PROJECT Issued $158,392 5/1/2020 - 4/30/2021



Annual Progress Reports
Expected (since FY2004):8
Completed:5
On time:5
Status Reports
Completed:41
On time:39
Avg Days Early:5

Earliest Subsequent           Accepted Count of Contract Deliverables
Contract Contract(s) Title Contractor Start End Status Reports Complete Green Yellow Red Total % Green and Complete Canceled
56931 60965, 64906, 68609, 72504, 75769, 74488 REL 7, 74488 REL 18, 74488 REL 28 2011-020-00 EXP DATA MANAGEMENT PROJECT Kalispel Tribe 05/2012 05/2012 Issued 41 28 4 0 1 33 96.97% 0
Project Totals 41 28 4 0 1 33 96.97% 0


The table content is updated frequently and thus contains more recent information than what was in the original proposal reviewed by ISRP and Council.

Review: 2019-2021 Mainstem/Program Support

Independent Scientific Review Panel Assessment

Assessment Number: 2011-020-00-ISRP-20190404
Project: 2011-020-00 - Data Management Project
Review: 2019-2021 Mainstem/Program Support
Proposal Number: NPCC19-2011-020-00
Completed Date: None
First Round ISRP Date: 4/4/2019
First Round ISRP Rating: Meets Scientific Review Criteria (Qualified)
First Round ISRP Comment:

Qualifications:

The ISRP recommends that the proponents describe their responses to the ISRP's comments and suggestions below in their upcoming annual report covering FY 2019 accomplishments.

1.      Establish quantitative objectives, guiding hypotheses and timelines for meeting key activities that can be reviewed by the ISRP.

2.      Provide an Adaptive Management (AM) process description for ISRP review. The AM process should include quantitative, time bound objectives and a more comprehensive description of how implementation and effectiveness monitoring will be aligned to improve project use and efficiency.

3.      Develop a strategic framework to guide project direction and priorities to move toward longer term project goals and, as well, a description of the major activities and skills required.

4.      Provide evidence regarding the database's level of use. The ISRP would like to be confident that the project is being widely used and that it is improving restoration actions and outcomes.

Comment:

The project appears to be well focused on providing comprehensive and efficient data management. The primary user is the Kalispel Tribe, but there are a number of partner agencies providing funding to support their use of the data. The proponents describe long term goals as well as information on who and how it will be used, but the information is not supported by a strategic plan or a list of major activities that should occur over the next several years.

1. Objectives, Significance to Regional Programs, and Technical Background

The primary goal is to assist in coordinating resource management strategies by addressing the status of resident fish, wildlife, and their habitats using a centralized data repository. There is a desire to publicly disseminate project and resource information, so that independent parties can "rapidly access primary or secondary data types, research metadata, and download reports related to data sets." Also, a long-term goal is identified as the project functioning as "a decision support system, to guide natural resource management managers in their strategies and activities." Unfortunately, the latter goal statement was confusing to the ISRP because it was not clear how the database addresses it, especially since there is no long-term strategy or action plan in place to guide actions or decisions over the long term.

There are six detailed and quite clearly stated objectives. They are qualitative and have no specific time frames for completion. A major plus is that each objective has a description describing metrics/criteria for measuring successful accomplishment. As previously noted, there are no objectives linked to longer term goals for the project. An example is that there is a stated desire to have the data system "be a place to disseminate natural resource information to the public and act as a data repository for future wildlife and fisheries managers," but there are no objectives focused on user recruitment, marketing of services to potential partner agencies or publics, or measuring current user satisfaction and desires for specific products and services. There has been tracking of actual use, but no description of how that information is used to guide management or decision-making.

Regarding regional significance, the proponents list a number of programs for which the database has relevance, but the details of how it contributes to the programs are more assumed and not clearly documented. Regional significance appears limited to the non-anadromous areas of the Basin. That is not necessarily a problem, but the ISRP is curious if some of the data sets housed within the database have wider utility. If so, linkages to other Columbia Basin databases (e.g., StreamNet, PNAMP, and so forth) are not readily apparent.

2. Results and Adaptive Management

The project appears to be meeting the near term needs of the Kalispell Tribe, yet there is only a limited description of actual accomplishments over the last four to five-years. Also, there is no summary of major accomplishments from inception to the present, which would be useful for evaluating the project. There are biannual accomplishment reports provided but they are narrowly focused on the accomplishment of specific objectives.

Although there is some tracking of project effectiveness, there is no evaluation or identification of lessons learned to guide future project direction and operations. As well, there is no mention of adaptive management (AM) or that it is an important project component. The proponents portray that project effectiveness is measured in several ways and that the range of users, including the public, that submit and maintain data sets will reflect project effectiveness through operational usage. Currently there is tracking of "the volume of data sets uploaded by licensed users, the number of data sets downloaded by the general public and added a hit counter at the web interface level." There is no discussion as to trends in use over the last few years or whether this use appears to be meeting user needs. Further, how are data on number of users and dataset volumes downloaded being used to improve the project? The proponents note that they receive and respond to feedback, but it is not clear from whom or that this feedback process is structured in a way that leads to more than an ad hoc set of edits.

Based on the Explanation of Financial History, it appears that the project has made some minor additions to the functionality of the website. Have any additional modifications been made? For instance, the proponents state that they were tracking project effectiveness as the number of users and the volume of datasets uploaded and downloaded. However, none of those results was presented aside from stating that the database is the repository for 60 datasets. Are these tracking data being used to modify the website? Who is using these data and how? What new insights or restoration plans/actions have been developed as a result?

Based on the workflow for submitting and providing QA/QC of datasets, it seems that substantial personnel time is required to get datasets verified and uploaded. The database would benefit from implementing algorithms that require less human attention to have datasets formatted, documented, and uploaded. Related to this, what is the long-term outlook for the database? Will it need this level of support in perpetuity?

Some of the issues mentioned above suggest the proponents need to pause and carefully think about the design and function of their database. The proponents were honest about their lack of success with the former database (JSAP DB), which was scrapped in 2009. However, the design of the current database also seems to have some inefficiencies, and the ISRP feels that more thought could be given to database design and longevity. For instance, no threats to program investments and the project are mentioned. For this database to have the maximum utility and impact, especially given its ambitious goals, the objectives for and design of the database need to be strategic.

3. Methods: Project Relationships, Work Types, and Deliverables

The proponents list many projects for which this database provides an information repository, 60% of which are BPA-funded projects.

The proposed work and deliverables include some relatively minor modifications to the database, as well as the ongoing activities needed to maintain it. The proposal states that, "Future versions will incorporate field survey report documents, data analysis tools, and summary statistics information." While this functionality is potentially useful, it is not explained well enough for the ISRP to understand its merit or limitations, or even if it will be incorporated in this project.

The ISRP would like to understand why the work under Deliverable 1 (Provide templates for downloading primary datasets into the Intermountain Province GEDMS) needs to be subcontracted rather than done "in-house."

The ISRP has a concern about Deliverable 2 (p. 15). Will the public care about primary data? If resource managers want to share what they are learning about the environment, habitat, and focal species progress within their jurisdiction, the ISRP suspects that they will probably find that analyzed (and interpreted) results are more useful. Are there provisions to see that these are done and provided to the public? Perhaps some links to published analyses using these data would be helpful to the public, especially those wondering what has been learned or accomplished?

The proponents anticipate (p. 16) that within the FY 2019-2023 timeframe additional equipment needs to be acquired. This likely will include a data server, desktop or laptop computers, and additional software. This may also include having to rent facilities for housing the equipment. Were these potential expenditures in the proposed budget?

Documentation Links:
Review: Resident Fish, Regional Coordination, and Data Management Category Review

Project Relationships: None

Name Role Organization
Ray Entz Supervisor Kalispel Tribe
Joe Maroney Project Lead Kalispel Tribe
Jim LeMieux Technical Contact Kalispel Tribe
Daniel McMeekan Technical Contact Kalispel Tribe
Jolene Seymour Administrative Contact Kalispel Tribe
Carlos Matthew Project Manager Bonneville Power Administration
Scott Donahue Project SME Bonneville Power Administration