| | | | | | | | | |
|---|
| A | 64083 | 185 | Produce CBFish Status Report | Periodic Status Reports for BPA | The Contractor shall report on the status of milestones and deliverables in Pisces. Reports shall be completed either monthly or quarterly as determined by the BPA COTR. Additionally, when indicating a deliverable milestone as COMPLETE, the contractor shall provide metrics and the final location (latitude and longitude) prior to submitting the report to the BPA COTR. | $1,525 | 0.85% | 04/01/2009 | 11/30/2009 |
| B | 64084 | 160 | Create/Manage/Maintain Database | ATM for Managing PIT Tag Data | This work element is aimed at developing a prototype tool to support analysis of PIT Tag data. This analysis tool will work in conjunction with the existing PTAGIS system by allowing users to import data from instream detectors or from the PTAGIS website. While the storage and distribute of PIT tag data must be performed at a regional-scale, the analysis of these data often occurs on individual desktops. The goal of the desktop application will be to organize, format, and summarize data for analysis. To date, Environmental Data Services has build the structure of the database, build data viewing forms, and developed an import script for data downloaded from the MUX. This work element will result in a script for importing data from the PTAGIS website, summary metrics, and formatted output. | $39,303 | 21.82% | 12/01/2008 | 11/30/2009 |
| C | 64085 | 160 | Create/Manage/Maintain Database | Analysis Toolbox | During the past three years the ISEMP has been developing and piloting the Aquatic Resource Schema (ARS) and Automated Template Modules (ATM) in the Upper Columbia Salmon Recovery Region. Implementation of these tools has demonstrated significant improvements in data quality and flow of data to repositories. While these tools have demonstrated significant improvements in data entry and submission of raw field data, efforts aimed at improving the summation and report of data need further development. The ARS provides a framework for supporting the documentation and standardization of metric and indicator calculations. Under this work element, Environmental Data Services will develop an analysis toolbox within the ATM to support calculation, documentation, and reporting of standardized metrics and indicators. The toolbox will allow users to create new SQL queries, will automate documentation of the queries, and will allow users to easily share previously documented queries. | $25,634 | 14.23% | 12/01/2008 | 11/30/2009 |
| D | 64086 | 160 | Create/Manage/Maintain Database | Protocol Editor Version 2.0 | Documenting new protocols within the ARS system requires detailed descriptions of all attributes observed by the protocol. This can pose a significant challenge for novice users who lack an intricate knowledge of the system. During FY 2008, the concept of survey types was added to the ARS. Survey types define the domain of attributes that could potentially be observed under a protocol and have the potential to facilitate the documentation of new protocols. Under this work element, Environmental Data Services will update the protocol editor module to include the concept of survey type. This update will increase the ease of documenting new protocols for novice users. | $16,170 | 8.98% | 12/01/2008 | 10/31/2009 |
| E | 64087 | 160 | Create/Manage/Maintain Database | ATM for Managing Total Station Data - Canceled | As the ISEMP moves toward implementation of restoration projects and effectiveness monitoring for those projects, the program is increasing the use of total stations as a survey tool for collecting habitat information. Incorporating total station data into the ISEMP data management system will require defining a new survey type in the ARS and add new functionality in the ATM to import and process total station data. Under this work element, Environmental Data Services will define functional requirements and business rules associated with the total station survey type, build data structures in the ARS to accommodate those data, and writing scripts for importing total station data through the ATM. | $0 | 0.00% | | 11/30/2009 |
| F | 64088 | 160 | Create/Manage/Maintain Database | ISEMP Data Management System Updates | The flow of information within the ISEMP data management system requires updates to protocols, data dictionaries, and data entry functions. Additionally, data must be validated at multiple stages within the ATM and formatted for submission to the STEM Databank. This work must be coordinated within and across pilot basins. Under this work element, Environmental Data Services will perform required system updates, develop queries to support data validation, and ensure consistency of work flow across pilot basins. | $40,252 | 22.34% | 12/01/2008 | 11/30/2009 |
| G | 64089 | 160 | Create/Manage/Maintain Database | ARS to XML Import/Export Scripts | As regional data sharing efforts advance, there is an increased convergence on the concept of a distributed database network that relies on a common XML data exchange format. A pilot effort in Washington during fiscal year 2009 will focus on developing an exchange format for juvenile fish data. To participate in the Washington pilot, the ISEMP data management system must support the ability to import and export data to the exchange format. Under this work element, Environmental Data Services will develop scripts to import and export between the ARS and the XML exchange format. | $9,483 | 5.26% | 03/01/2009 | 11/30/2009 |
| H | 64090 | 160 | Create/Manage/Maintain Database | Project Implementation Collaboration Tool Requirements Document | Development of a restoration project implementation collaboration tool is necessary to facilitate the sharing of data and documents within and between project development teams. Survey data, project designs, implementation schedules, and monitoring data must be accessible and easily shared between technical teams, designers, permit agencies, construction teams, and monitoring teams. Under this work element, Environmental Data Services will facilitate development of requirements documentation and implementation of a collaboration tool. | $1,500 | 0.83% | 12/01/2008 | 11/30/2009 |
| I | 64091 | 189 | Coordination-Columbia Basinwide | ISEMP Coordination, Reporting, and Program Development | 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. Under this work element, Environmental Data Services will participate in bi-monthly coordination meetings and in informal discussions with other project coordinators on an as needed basis to ensure consistency and progress of overall project objectives. | $15,211 | 8.44% | 12/01/2008 | 11/30/2009 |
| J | 64092 | 119 | Manage and Administer Projects | Develop Funding Package for Dec 2009 to Nov 2010 | Work with ISEMP Coordinators and COTR to develop funding package for Dec 2009 to Nov 2010. | $1,520 | 0.84% | 07/31/2009 | 09/10/2009 |
| K | 64093 | 132 | Produce Progress (Annual) Report | Submit Progress Report for the period Dec 2008 to Nov 2009 | The progress report summarizes the project goal, objectives, hypotheses, completed and uncompleted deliverables, problems encountered, lessons learned, and long-term planning. Examples of long-term planning include future improvements, new directions, or level of effort for contract implementation, including any ramping up or ramping down of contract components or of the project as a whole. Date range will be Dec 2008 to Nov 2009. | $474 | 0.26% | 09/15/2009 | 11/30/2009 |
| L | 64107 | 160 | Create/Manage/Maintain Database | Data Quality Tools | The flow of data from data generators to data warehouse requires be compiled, validated, and transformed for ingest to STEM Databank. This work is completed by subbasin data stewards and at times tedious and labor intensive. This work element will produce tools to support data stewards in compiling, verifying and transforming data and will result in increased efficiency of the data steward workflow. | $29,068 | 16.14% | 08/15/2009 | 11/30/2009 |
Help
Mitigation work
Reporting
Funding
Search
Log in
SOW Report
