| | | | | | | |
|---|
| | A | 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. | | |
| | B | 160 | Create/Manage/Maintain Database | Data Analysis Toolbox | During fiscal year 2010, Environmental Data Services advanced the ATM Analysis Toolbox that supports the calculation, documentation, and reporting of standardized metrics. While calculation of standardized metrics is an initial step in the data analysis workflow, data analysis includes additional steps such as performing statistical analysis on metrics, incorporation of metrics as parameters in modeling exercises, or visually displaying metrics as maps or other graphical output. This work element will update the ATM Analysis Toolbox based on user feedback and will build crosswalks to connect output from the ATM Analysis Toolbox to ecological modeling, statistical inference, and mapping tools. | | |
| | C | 160 | Create/Manage/Maintain Database | Data Quality Toolbox | The flow of data from data generators to data warehouses requires data to be compiled, validated, and transformed for ingest to STEM Databank. This work is completed by subbasin data stewards and can be tedious and labor intensive. During fiscal year 2010, Environmental Data Services compiled data quality tools into a toolbox with a user-interface modeled on the ISEMP data flow and qa/qc process. This work element will continue on the previous years work by enhancing the existing toolbox based on user feedback and producing new data quality tools that are requested by subbasin data stewards. | | |
| | D | 160 | Create/Manage/Maintain Database | Protocol-specific Import and Analysis Functions | The Automated Template Module (ATM) is a generalized data entry application that is updated or calibrated from protocol-level documentation. While the ATM provides good functionality for a large range of protocols, some survey types or protocols require specialized data import or analysis functionality. Data collected by electronic data loggers, such as water temperature or PIT tags, require specialized import scripts. Similarly, data collected and stored in agency-level formats require specialized import scripts. This work element will produce import scripts and analysis functions as needed to support ISEMP data compilation and analysis requirements. | | |
| | E | 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. During FY 2011, EDS will continue refinement of the ARS to reflect ISEMP- and basin-wide programmatic decisions and will continue to refine the framework approach used to manage growth and versioning of the schema. The Aquatic Resources Schema will be updated to support evolving data collection protocols, metadata requirements, and data reduction procedures. | | |
| | F | 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. | | |
| | G | 119 | Manage and Administer Projects | Develop Funding Package for Dec 2011 to Nov 2012 | Work with ISEMP Coordinators and COTR to develop funding package for Dec 2011 to Nov 2012. | | |
| | H | 132 | Produce Progress (Annual) Report | Submit Progress Report for the period Dec 2009 to Nov 2010 | 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 2010 to Nov 2011. | | |
| | I | 160 | Create/Manage/Maintain Database | CHaMP Data Model and System Architecture Specification | The Columbia Habitat Monitoring Program (CHaMP) will need a data system to support data capture, quality assurance reviews, GIS processing, metric generation, and data distribution. A system architecture diagram and plan will describe system components, requirements, and data flow. System components must be compatible with a defined data model. A data model will be developed to support data storage, analysis and retrieval needs as describe by the 2010 CHaMP protocol. This work element will build on the lessons learned from the ISEMP data system architecture and the ISEMP Aquatic Resources Schema and advance those concepts to support construction of a centralized data system for the CHaMP. | | |
| | J | 160 | Create/Manage/Maintain Database | GRTS Site Evaluation Tool | NOAA Fisheries has recommended application of a Generalized Random Tessellation Stratified(GRTS) survey design for identifying habitat sampling sites. Application of a GRTS survey requires tracking site-level evaluation metadata to support extrapolation of monitoring metrics to watershed-level indicators. Implementing a site evaluation requires strict protocol compliance and rigid data validation. During fiscal year 2010, EDS built a desktop tool to support the GRTS Site Evaluation protocol. Under this work element, a web enabled GRTS Site Evaluation Tool will be built to support the CHaMP. The web enable tool will build upon functionality defined in the desktop tool. | | |
| | K | 160 | Create/Manage/Maintain Database | CHaMP Data Import and Quality Assurance Prototype | The CHaMP data system will include a web-enabled data import and quality assurance component. A prototype of this utility will be developed under this work element. The utility will build upon similar utilities created in the ISEMP ATM. | | |
| | L | 160 | Create/Manage/Maintain Database | RBT Design Support | The River Bathymetry Tool (RBT) is a toolbox in Arc GIS 9.X used to produce habitat metrics from DEM's that are specific to salmon and steelhead monitoring projects. Metrics calculated by the RBT will be determined and prioritized by a working committee including scientists from NOAA, QCI and USFS Rocky Mountain Research Station. ESSA Technologies, Vancouver, BC, Canada has been developing this tool-kit with the United States Forest Service Rocky Mountain Research Station (RMRS) since 2007. Beginning in 2008, funds provided by Bonneville Power Administration (ISEMP Contract) combined with funds from the RMRS been used collaboratively by RMRS and ISEMP scientists to continue the development of this toolkit to apply it specifically to ISEMP objectives to develop new methods for measuring tributary fish habitats in the Columbia basin.
Environmental Data Services will collaborate with Quantitative Consulting Inc. to provide coordination support on further development of RBT. Additionally, Environmental Data Services will provide design support to ensure consistency with existing ISEMP data management tools. | | |
Help
Mitigation work
Reporting
Funding
Search
Log in
