FY 2000 proposal 199601900

Additional documents

TitleType
199601900 Narrative Narrative

Section 1. Administrative

Proposal titleSecond Tier Database Support for Ecosystem Focus
Proposal ID199601900
OrganizationBonneville Power Administration (BPA)
Proposal contact person or principal investigator
NameDavid Askren
Mailing addressMail Code EWI-4 905 NE 11 Ave P.O. Box 3621 Portland, OR 97208-3621
Phone / email5032305624 / draskren@bpa.gov
Manager authorizing this project
Review cycleFY 2000
Province / SubbasinMainstem/Systemwide / Systemwide
Short descriptionImplement certain non-discretionary actions to provide single-point, Internet-based access to a subset of information to guide and support BPA's independent decisions pertaining to its responsibilities under the Power Act and Endangered Species Act
Target speciesAnadromous and resident fishes of the Columbia-Snake River Basin
Project location
LatitudeLongitudeDescription
Reasonable and Prudent Alternatives (RPAs)

Sponsor-reported:

RPA

Relevant RPAs based on NMFS/BPA review:

Reviewing agencyAction #BiOp AgencyDescription

Section 2. Past accomplishments

YearAccomplishment
1995 Developed prototype Data Access in Real Time (DART) and Battelle Technical Management Team World Wide Web services
1996 Added PIT-tagged juvenile salmon migration timing forecasts to Lower Granite Dam (program RealTime)
1996 Added juvenile salmon migration timing and survival from Lower Granite Dam to the estuary (program CRiSP)
1997 Battelle Technical Management Team World Wide Web prototype adopted by Corps of Engineers to support TMT
1998 Supported independent governmental decisions pertaining to near-term (e.g. inseason) planning and operation of the FCRPS
1998 Supported independent governmental decisions pertaining to near-term (e.g. inseason) planning and operation of the FCRPS
1998 Supported independent governmental decisions pertaining to near-term (e.g. inseason) planning and operation of the FCRPS
1998 Supported independent governmental decisions pertaining to near-term (e.g. inseason) planning and operation of the FCRPS
1998 Supported independent governmental decisions pertaining to near-term (e.g. inseason) planning and operation of the FCRPS
1998 Supported independent governmental decisions pertaining to near-term (e.g. inseason) planning and operation of the FCRPS
1998 Supported independent governmental decisions pertaining to near-term (e.g. inseason) planning and operation of the FCRPS
1998 Supported independent governmental decisions pertaining to long-term planning (e.g. PATH) of the configuration and operation of the FCRPS

Section 3. Relationships to other projects

Project IDTitleDescription
8910800 Monitoring and Evaluation Modeling Support - Columbia Basin Research Critical - 8910800’s CRISP juvenile salmon hydrosystem survival model requires input presently available only through 9601900 services. Model is used during migration season in support of weekly hydrosystem operations.
9105100 Monitoring and Evaluation Statistical Support for Life-Cycle Studies-UW Critical - 9105100’s “RealTime” statistical juvenile salmon migration timing models require input presently only available from 9601900 services. Models are used during migration season in support of weekly hydrosystem operations.
8910700 Statistical Support for Salmonid Survival Studies - UW (Skalski) Critical - 9601900 integrates regionally-distributed data for input to 8910700 survival analyses.
8810804 StreamNet: The Northwest Aquatic Information Network Complimentary - bridges between FPC and StreamNet; improves access, integration and display of inseason and historical information.
9403300 Fish Passage Center Complimentary - improves access, integration and display of current season FPC smolt monitoring information. Provides online access to prior years FPC information. Critical - FPC is primary data source for current year smolt monitoring data.
9008000 Columbia Basin PIT-Tag Information System Complimentary - reduces user impacts to PITAGIS, improves access, integration, and display. Critical - PITAGIS is primary data source for PIT tag data.
9303701 Technical Assistance with Life Cycle Modeling - Paulsen Environmental
9601900 Second-Tier Database Support for Ecosystem Focus - BPA
9105100 Monitoring and Evaluation Statistical Support for Life-Cycle Studies-UW
8910800 Monitoring and Evaluation Modeling Support - Columbia Basin Research
9800600 Technical Support to PATH - Anderson Consulting
9700200 PATH - UW Technical Support - Columbia Basis Research
9601700 Provide Technical Support in PATH - BioAnalysts Inc. (Giorgi)
20537 Bonneville Power Administration Non-Discretionary Projects
9800100 Analytical Support-PATH and ESA Biological Assessments - Hinrichsen Envir

Section 4. Budget for Planning and Design phase

Task-based budget
ObjectiveTaskDuration in FYsEstimated 2000 costSubcontractor
Outyear objectives-based budget
ObjectiveStarting FYEnding FYEstimated cost
Outyear budgets for Planning and Design phase

Section 5. Budget for Construction and Implementation phase

Task-based budget
ObjectiveTaskDuration in FYsEstimated 2000 costSubcontractor
Outyear objectives-based budget
ObjectiveStarting FYEnding FYEstimated cost
Outyear budgets for Construction and Implementation phase

Section 6. Budget for Operations and Maintenance phase

Task-based budget
ObjectiveTaskDuration in FYsEstimated 2000 costSubcontractor
Outyear objectives-based budget
ObjectiveStarting FYEnding FYEstimated cost
Outyear budgets for Operations and Maintenance phase

Section 7. Budget for Monitoring and Evaluation phase

Task-based budget
ObjectiveTaskDuration in FYsEstimated 2000 costSubcontractor
Outyear objectives-based budget
ObjectiveStarting FYEnding FYEstimated cost
Outyear budgets for Monitoring and Evaluation phase

Section 8. Estimated budget summary

Itemized budget
ItemNoteFY 2000 cost
Personnel 18.5 man-months for partial-year employment of database adminstration, web and system support $72,009
Fringe Rates vary from 21% to 29% $18,412
Supplies Supplies including software and misc computer hardware $4,633
Operating Internet, local, and long distance phones, software licenses, equipment repairs and insurance $14,340
Capital Enterprise 4000 server for DART $30,000
Travel $1,000
Indirect $28,702
Other Lease $10,904
$180,000
Total estimated budget
Total FY 2000 cost$180,000
Amount anticipated from previously committed BPA funds$0
Total FY 2000 budget request$180,000
FY 2000 forecast from 1999$0
% change from forecast0.0%
Cost sharing
OrganizationItem or service providedAmountCash or in-kind
Corps of Engineers Primary source for online inseason and historical hydro operations data and adminstrative record of Technical Management Team $0 unknown
Corps of Engineers Contracts complement this project to retain staff full time and effectively reduce project cost. $0 unknown
Other budget explanation

Schedule Constraints: Inseason support services must be online prior to April 1.


Reviews and recommendations

This information was not provided on the original proposals, but was generated during the review process.

Recommendation:
Fund for one year
Date:
Jun 15, 1999

Comment:

Recommendation: Fund for one year. Subsequent funding contingent on a programmatic information management review as recommended in the ISRP's FY99 report. Evaluate the possibility of combining the data processing functions of the Fish Passage Center, PITAGIS (direct data), Streamnet, and DART.

Comments: This proposal is to provide monitoring and evaluation by integrating and delivering information from several separate data centers funded by the Fish and Wildlife Program. Data sources are polled through the Internet for subsets of data that are integrated into the database DART.

The ISRP made the following comments in FY99: "The proposal does not clarify why the problems in the primary database are not fixed instead of adding a second tier (this proposal). There is little explanation of how the second tier is done. Objectives are not the same in the table and the text. The work is not so much collaborative as competitive, but all this is laid out and stated in terms of the need to cooperate. The project seems to be the result of frustration with other projects not doing what was expected."

The FY00 proposal explicitly addresses issues raised in the FY99 ISRP review. The relation of this project to the Fish and Wildlife Program is clear. The project provides useful coordination for the integration and delivery of information in what seems like an appropriate use of technology. But because tensions between various data programs are obviously still present, it is not clear how the appropriate coordination will be accomplished if the project depends on the cooperation of primary data sources. In addition, there continues to be duplication of effort with other information service projects. Strategies for quality control and assessment of impact should be strengthened. In FY99, the ISRP recommended an information management review. This proposal suggests that a review would be beneficial and would help contribute to the solution of some of the regional information management problems.


Recommendation:
Do Not Fund
Date:
Aug 20, 1999

Comment:


Recommendation:
Date:
Aug 20, 1999

Comment:

Duplicates other information management services.
Recommendation:
Date:
Aug 20, 1999

Comment:

Criteria all: Met? No - Unclear of the need. Duplicative of other database programs, not necessary for regional needs.
Recommendation:
Rank 29
Date:
Oct 8, 1999

Comment:

Rank Comments: This project provides useful coordination for the integration and delivery of information. However, there continues to be potential for duplication of effort with other information service projects.
Recommendation:
Rank 29
Date:
Oct 8, 1999

Comment:

This project provides useful coordination for the integration and delivery of information. However, there continues to be potential for duplication of effort with other information service projects.
Recommendation:
Fund
Date:
Mar 1, 2000

Comment:

[Decision made in 2-2-00 Council Meeting]; BPA non-discretionary technical support project
REVIEW:
NW Power and Conservation Council's FY 2006 Project Funding Review
Funding category:
expense
Date:
May 2005
FY05 NPCC start of year:FY06 NPCC staff preliminary:FY06 NPCC July draft start of year:
$264,075 $264,075 $264,075

Sponsor comments: See comment at Council's website