SOLICITATION NOTICE
R -- Finalize data management tools and products for the Integrated Status and Effectiveness monitoring Program in the Columbia River Basin
- Notice Date
- 6/11/2008
- Notice Type
- Combined Synopsis/Solicitation
- NAICS
- 518210
— Data Processing, Hosting, and Related Services
- Contracting Office
- Department of Commerce, National Oceanic and Atmospheric Administration (NOAA), Western Region Acquisition Division, 7600 Sand Point Way, Northeast, Seattle, Washington, 98115-6349
- ZIP Code
- 98115-6349
- Solicitation Number
- WRAD-8-40396
- Archive Date
- 7/10/2008
- Point of Contact
- Melvin N. Fondue, Phone: (206) 526-6043, Randall A. Brown,, Phone: (206) 526-6226
- E-Mail Address
-
melvin.n.fondue@noaa.gov, randall.w.brown@noaa.gov
- Small Business Set-Aside
- N/A
- Description
- This is a combined synopsis / solicitation for the following services for NOAA, National Marine Fisheries Service. Finalize data management tools and products for the Integrated Status and Effectiveness monitoring Program in the Columbia River Basin. Background and Objectives, The Center provides scientific and technical support to NMFS for the management, conservation, and wise-use of the Northwest region's marine and anadromous resources. To address some of these needs the Conservation Biology Division formed the Mathematical Biology and Systems Monitoring Program to develop, in tandem with the existing Salmon Science Programs and Salmon Recovery Planning Teams, quantitative tools for assessing population and habitat status and recovery potential and progress. One of the major projects undertaken by this program is the development of a large-scale comprehensive monitoring program to be implemented in three Columbia River sub-basins. The primary objective of this project is the development of a rule set to guide the implementation of large-scale monitoring and evaluation programs across the Columbia River basin. The project will accomplish this goal through the quantitative assessment of status and effectiveness monitoring and evaluation approaches. The component of the overall project described herein specifically addresses management and analysis of data collected from the John Day, Wenatchee, and Salmon River basins. The work required under this requisition is in support of the development of habitat and population status monitoring guidelines for the Bonneville Power Administration's (BPA) Environmental, Fish and Wildlife (EFW) Program Mainstem / Systemwide Province Provincial Review Process and parallel efforts to define the status and effectiveness monitoring requirements of the 2000, 2004 and 2007 NMFS Federal Columbia River Power System Biological Opinions. While these collections of monitoring protocols and program designs have been developed by regional fisheries managers, the program as a whole has never been adequately tested in the Columbia River basin. To meet the status and effectiveness monitoring components of these needs, a proposal was initially drafted and submitted in response to the programmatic solicitations of the Mainstem/Systemwide Provincial Review. The resulting proposed status and effectiveness monitoring program seeks to implement landscape and reach scale habitat and population status monitoring in parallel with watershed-scale habitat restoration action effectiveness monitoring for anadromous salmonid populations of the Columbia River basin. This work has been funded through BPA's EFW program, with the NOAA NWFSC serving as the primary contractor for this work (BPA Project #2003-017: Integrated Status and Effectiveness Monitoring Program - ISEMP). The work required under this requisition is a subcontract to perform specific analysis and data development elements of the overall project. Specifically this project will address the following tasks: 1.2.1 Data management schema  Guidelines for development of protocol documentation  Documentation for PIBO Habitat Protocol  The 2008 version of ARS implemented as an MS Access database  A data dictionary for the 2008 version of ARS  Updated Visual Basic script to export data from ARS for bulk loading 1.2.2 Data entry template  Custom data entry templates for Bridge Creek juvenile pit tagging, spawning ground, and habitat protocols  Customized data entry template for nine protocols  Seven training sessions for data stewards and developers 1.2.3 Training and support  Training sessions data entry technicians 1.2.4 Data analysis documentation  Analysis queries for reducing habitat and fish data.  A training workshop for data analysts 1.2.5 Regional coordination  Presentations and summaries from meetings with regional data managers and data coordinating bodies to promote the ISEMP data management strategy. 2.0 SERVICES REQUIRED The development of the ISEMP pilot watershed projects in the Wenatchee/Entiat, John Day and Salmon River basins is expected to be a long-term process whereby lessons learned through research and the Intensively Monitored Watershed studies will influence current and future monitoring efforts. Working closely with personnel implementing current monitoring programs in these sub-basins is critical as changes to current programs will not likely be accepted unless ISEMP can provide strong justification for the benefit of action revisions to salmonid management in the basin. Therefore, the ISEMP pilot approach is to develop a monitoring framework developed as a cohesive, basin-wide monitoring program that will be facilitated by ISEMP and accepted by the multiple monitoring entities across the Columbia River basin. The vendor will be engaged by ISEMP to perform specific technical tasks that support the overall mission of ISEMP. In particular, the vendor will be involved with developing critical data management tools to support analyses, database templates to facilitate data flow and standardization, and coordination efforts to keep ISEMP products relevant in a regional context. Specific Technical Services -- Specifically this project will address the following tasks: 2.1 Data generation protocol. Data generation protocols are being written for data collection on the Bridge Creek Implementation project. Vendor will provide guidance to ISEMP staff to ensure protocols are documented in a format consistent with Protocol Editor. Additionally, vendor will develop standardized documentation for the PIBO habitat sampling protocol. 2.1.1 Protocol development. Protocol documentation includes detailed description of all attributes to be collected under each protocol and describe the format that data will be entered in the data entry templates. Documentation must follow a standardized format and be in sufficient detail to ensure consistency with the data entry templates. The vendor will provide guidance to ISEMP staff to ensure consistency and completeness of protocol documentation. 2.1.2 Document PIBO protocol. Habitat protocols are complex and cover a broad range of attributes. Data generators who collect habitat data tend to have strong allegiances to specific protocols and the language of those protocols. Deciphering habitat protocols and developing consistent documentation for these protocols requires prior knowledge and experience with habitat protocols. Vendor will document the PIBO habitat protocol in a format consistent with the Wenatchee habitat protocol. 2.2 Data entry template. Develop data management tools to support the entry of field generated data into the project data flow process. Bridge Creek Implementation project protocols must be loaded to the data entry template and validated with data collectors. Additional customization of the data entry template will ensure forms are efficient for entering data from each protocol and may require custom code to automate data entry. The vendor will customize the data entry template to ensure efficient data entry under each protocol. 2.2.1 Develop customized data entry templates. The contractor will develop customized forms and code to support efficient data entry for Bridge Creek juvenile pit tagging, spawning ground, and habitat protocols. 2.3 Training and support. Provide training and support to data entry technicians using the customized tools. 2.3.1 Train and support. Provide training and support to data entry technicians using the customized tools. 2.4 Data management schema. Keep up to date the development and documentation of an overarching project data management schema. The ability to manage and analyze a continuous data flow requires a data management schema that supports data entry, documentation, standardization, retrieval and analysis. Data management tool development for ISEMP has been guided by an emerging Aquatic Resource Schema (ARS); this task is to update the existing ARS to reflect modified protocols and data use procedures. 2.4.1 Finalize Aquatic Resources Schema. Beta versions of data entry templates for habitat, water quality, snorkel, spawning-ground, smolt trap surveys, fine-sediment and macro-invertebrates were previously developed and were tested by field data generators. The vendor will now generate final data entry templates, protocol elements, data query structures and a data dictionary for these data types as performed by ISEMP field crews in the Wenatchee, Entiat, John Day and Salmon River basins. 2.4.2 Export Aquatic Resources Schema data elements to enterprise level data management system. Data entry templates were developed and populated through the 2007 data entry season. The vendor will now develop Visual Basic scripts to export 2008 and future data for bulk loading to the project's data archiving and distribution system. 2.5 Data entry template. Develop data management tools to support the entry of field generated data into the project data flow process. Customization of the data entry template will ensure forms are efficient for entering data from each protocol and may require custom code to automate data entry. The vendor will customize the data entry template to ensure efficient data entry. The vendor will also train regional collaborators in the most efficient use and application of the updated product. 2.5.1 Develop customized data entry templates. The vendor will develop customized forms and code to support efficient data entry for nine data collection protocols for the ISEMP Wenatchee/Entiat fish and habitat sampling program. 2.5.2 Train regional data stewards in the use of data entry modules. The data entry template is available for use by projects throughout the region; however, it would be most effective if data stewards and other agency data base developers were fully trained on the use and potential extension of these tools. Therefore, the vendor will run one-on-one or small group training sessions to develop a sophisticated user base such that the tools can be used and modified as needed in as wide a manner as appropriate. 2.6 Data analysis documentation. Develop data management tools to support data analysis. 2.6.1 Develop and document analysis based data queries. The power of the ARS lines in the ability to summarize data immediately following data entry. This ability increase efficiency of data analysis and report generation. The vendor will write Ms Access queries to summarize habitat and fish data. Queries will be documented in a standardized metadata format. 2.6.2 Train data analysts in use of query tools. Vendor will provide a training session for data analysts on use of Ms Access for querying and summarizing data from the ARS. 2.7 Regional Coordination. For a monitoring program at the scale of the Columbia River Basin to be truly successful, a strategy utilizing strong yet flexible lines of communication needs to exist between project coordinators and local collaborators and should be mirrored within the data management tools developed for the program. Facilitating dialog between project managers, data collectors, data managers, and policy maker requires a coordinator with an interdisciplinary background and strong communication skills. 2.7.1 Coordination data managers. Communication of the ISEMP data management strategy to data managers throughout the region will support the export of lessons and ensure that feedback gets incorporated. The vendor will meet with regional data managers and data coordinating bodies to promote the ISEMP data management strategy. Additionally, the ISEMP data management tools have produced significant interest from regional data collection agencies. While the tools were developed to support ISEMP objectives, minor modifications and staff training allow for use of the tools by other agencies. Vendor staff will work with Idaho Fish and Game, Oregon Department of Fish and Wildlife, and U.S. Bureau of Reclamation to assist these agencies integrate the ISEMP data management tools. 2.8 This order consists of tasks with the following technical specifications: 2.8.1 The contractor qualified to provide data management services for the ISEMP must possess the following experience and training:  applicable academic training and professional experience;  familiarity with the Wenatchee, Entiat, John Day and Salmon River subbasins and experience in the collection of Research, Monitoring, and Evaluation (RM&E) data in these region;  familiarity with the strengths and limitations of field data collected using various methods in ISEMP pilot sub-basin; and  experience with cooperative efforts involving the co-managers and action agencies participating in this project. 2.8.2 The contractor must have educational and work experience in the disciplines of Ecology, Geographic Information Systems, and Data Management. The vendor must have documented experience drafting data management schemes specifically related to the management and recovery monitoring of pacific salmonids. 2.8.3 The contractor must have experience in snorkel and redd surveys, shocking and seining surveys, and the full range of standard stream habitat surveys in order to fully understand the data generated by large-scale monitoring programs. 2.8.4 The contractor must have a documented work experience analyzing field data, understanding of the limitations of different data types, performing data quality control, and designing data management schemes to support statistical analyses of data using multiple analytical techniques. 2.8.5 The contractor must have experience and extensive skills in data analysis programs, GIS (including ArcHydro), and database management programs, such as MS ACCESS, Oracle, and ESRI IMS. 3.0 DELIVERABLES The following shall be provided to the Northwest Fisheries Science Center: 3.1 Deliverables for Data management schema tasks:  Guidelines for development of protocol documentation  Documentation for PIBO Habitat Protocol 3.2 Deliverables for Data entry template tasks:  Custom data entry templates for Bridge Creek juvenile pit tagging, spawning ground, and habitat protocols 3.3 Deliverable for Training and support tasks:  Training sessions data entry technicians 3.4 Deliverables for Data management schema tasks:  The 2008 version of ARS implemented as an MS Access database  A data dictionary for the 2008 version of ARS  Updated Visual Basic script to export data from ARS for bulk loading 3.5 Deliverable for Data entry template tasks:  Customized data entry template for nine protocols  Seven training sessions for data stewards and developers 3.6 Deliverable for Data analysis documentation tasks:  Analysis queries for reducing habitat and fish data.  A training workshop for data analysts 3.7 Deliverable for Regional coordination tasks:  Presentations and summaries from meetings with regional data managers and data coordinating bodies to promote the ISEMP data management strategy. Additional performance metrics for all Deliverables above: 3.8 Coordination with ISEMP. To ensure that adequate progress is being made toward all deliverables, monthly progress meetings between the contractor and point-of-contact will be conducted. Interested parties must respond to this announcement within fifteen (15) calendar days of its publication. All responses must be in writing and may be faxed to 206-526-6025 or email (melvin.n.fondue@noaa.gov). This is a simplified acquisition with an estimated value of less than The following provisions and clauses shall apply to this solicitation and resultant award. The provisions and clauses may be downloaded at http://www.acqnet.gov/far 1. 52.213-4 TERMS AND CONDITIONS--SIMPLIFIED ACQUISITIONS (OTHER THAN COMMERCIAL ITEMS) (APR 2005) 2. 52.243-1 I CHANGES--FIXED-PRICE (AUG 1987)--ALTERNATE I (APR 1984) 3. 52.204-6 DATA UNIVERSAL NUMBERING SYSTEM (DUNS) NUMBER (OCT 2003) 4. 52.204-7 CENTRAL CONTRACTOR REGISTRATION (OCT 2003) 5. 52.204-8 ANNUAL REPRESENTATIONS AND CERTIFICATIONS (JAN 2005) 6. 52.219-1 SMALL BUSINESS PROGRAM REPRESENTATIONS (MAY 2004) 7. 52.222-22 PREVIOUS CONTRACTS AND COMPLIANCE REPORTS (FEB 1999) 8. 52.222-25 AFFIRMATIVE ACTION COMPLIANCE (APR 1984) 9. 52.225-13 RESTRICTIONS ON CERTAIN FOREIGN PURCHASES (MAR 2005) 10. 1352.239-73 SECURITY REQUIREMENTS FOR INFORMATION TECHNOLOGY RESOURCES (OCT 2003)11. 1352.239-74 SECURITY PROCESSING REQUIREMENTS FOR CONTRACTORS/SUBCONTRACTOR PERSONNEL FOR ACCESSING DOC INFORMATION TECHNOLOGY SYSTEMS (OCT 2003 12. 52.243-1 CHANGES--FIXED-PRICE (AUG 1987) 13. 52.244-6 SUBCONTRACTS FOR COMMERCIAL ITEMS (Dec 2004) 14. 52.252-2 CLAUSES INCORPORATED BY REFERENCE (FEB 1998)
- Web Link
-
FedBizOpps Complete View
(https://www.fbo.gov/?s=opportunity&mode=form&id=74d5db1e72a29ae44db5a49f47b7604d&tab=core&_cview=1)
- Place of Performance
- Address: Seattle, Washington, 98112, United States
- Zip Code: 98112
- Zip Code: 98112
- Record
- SN01591470-W 20080613/080611222234-74d5db1e72a29ae44db5a49f47b7604d (fbodaily.com)
- Source
-
FedBizOpps Link to This Notice
(may not be valid after Archive Date)
| FSG Index | This Issue's Index | Today's FBO Daily Index Page |