Show new navigation
On
  • Help
    • Help
    • How Do I?
    • Why Do I?
    • Help Center
    • Data dictionary
    • EF&W Program documents
    • Request support
    • Send feedback
      • View all help topics
Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
  • Mitigation work
    Mitigation work View all mitigation work topics
  • Reporting
    Reporting View all reporting topics
  • Funding
    Funding View all funding topics
  • Search
Back to SOW

This page provides details of the selected work element.

Work Element Summary PDF
Select a work element:

Contract Number:
46273 REL 28
Contract Title:
2003-017-00 EXP ISEMP - NOAA FISHERIES COORDINATION & PROJ DESIGN
Contract Start Date:
7/1/2011
Contract End Date:
6/30/2012
WE ID:
160. Create/Manage/Maintain Database
Work Element Usage Report
Title:
C: 160 - Develop pilot enterprise-level data management system
Description:
Due to the large-scale data collection effort undertaken by ISEMP, and the project's goal of data analysis and interpretation, the project must develop its own approach to data management that takes into explicit account the versioning of protocols, the spatial/temporal representativeness of the data elements, the data flow from generators to managers, and ultimately, the output of data to data analysts. As such, the project will develop novel tools for the management and communication of monitoring data, monitoring data collection protocols and monitoring data flow. In addition, these tools will be implemented on a sub-basin scale and offered to the co-manager community to facilitate all of the above objectives. (SDM). This WE specifically involves the following actions: maintain, enhance and document Status and Trend Effectiveness Monitoring (STEM) database; maintain, enhance and document STEM data query and delivery website.
WE Agreement Type:
Contracted
Deliverable Specification:
Deliverable Title: STEM Database Maintenance and Enhancements
Deliverable Specification: The STEM database has been developed to store data from numerous ISEMP data collectors for a wide variety of survey types. The SDM team will continue to load new data as it is provided from the regional data stewards. It is anticipated that additional survey types will be required to meet the goals of the ISEMP project and that database enhancements will be required to store and retrieve these new data types. As the ISEMP data coordinators develop processes to analysis the data, the SDM team will develop database routines to perform some of this analysis and will streamline data retrieval to meet the needs of these analysis.

Deliverable Title: STEM Website Maintenance and Enhancements
Deliverable Specification: The SDM team has developed a data query and delivery website to provide access to the STEM database. This system provides end users with a query interface that allows users to retrieve ISEMP data. As ISEMP data coordinators begin to develop data summaries for analysis purposes, the STEM website will provide a user interface that will dynamically retrieve this summary information. There have been requests to produce web services that will allow ISEMP data to be integrated with other data management systems. As the business rules and formats are defined for these services, the SDM team will develop the technical solution to provide this information.

Deliverable Title: STEM System Documentation
Deliverable Specification: In order to maintain the STEM data management system into the future a full set of documentation is crucial. This system documentation will ensure that as people move on, the system can be maintained. The system architecture will include complete database and website documentation as well as end user help guides.
WSE Effective Budget:
$151,826
% of Total WSE Effective Budget:
34.60%
WSE Start:
07/01/2011
WSE End:
06/30/2012
WSE Completion:
06/30/2012
WSE Progress:
Concluded
WSE ID Continued From:
n/a
WSE ID Continued To:
n/a
Finite or Recurring:
Recurring

Back To Top

Budget History

SOWRevision Planned Updated Contractor Comments (optional) BPA Comments (optional)
Work Element Budget (Current Performance Period) $151,826 $151,826

Back To Top

Milestones

8 Milestones
Sort Type Title Start End Status Modified By Modified Date
A Load data into STEM database 7/1/2011 6/30/2012 Concluded Chris Jordan 5/4/2011 2:56:01 PM
Description: The ISEMP data management group has developed a set of data quality and assurance requirements to validate that data has been migrated from the source ARS format into the Oracle database repository successfully. Based on this rule set, the SDM team has created a process to ensure that all input datasets are stored in the STEM database exactly as they are delivered. Every dataset that is delivered to the SDM team will be loaded using this process and a data validation report will be generated for each dataset.
B Maintain and update STEM database 7/1/2011 6/30/2012 Concluded Chris Jordan 5/4/2011 2:56:01 PM
Description: The ISEMP data management system will require updates to protocols and data dictionaries as well as the ability to support new survey types and subbasins. The SDM team will ensure that the STEM database is updated to meet these new requirements and that the STEM database is available to end users through the STEM website.
C Data analysis and delivery support 10/1/2011 6/30/2012 Concluded Chris Jordan 5/4/2011 2:56:01 PM
Description: ISEMP data analysts require that data be available in specific formats based on survey type that can be readily ingested into their analysis. The SDM team will develop database routines to provide data in these required formats. It is also expected that users of the STEM website will require data summaries. The SDM team will work with the ISEMP data coordinators to define these summaries and ensure that the information presented through the STEM website is accurate.
D STEM website enhancements 10/1/2011 6/30/2012 Concluded Chris Jordan 5/4/2011 2:56:01 PM
Description: The SDM team has developed a web based query and data retrieval system, aimed at meeting the requirements of the ISEMP data community. As this community grows, the SDM team will enhance the existing website to meet future enhancement requests. It is expected that the STEM website will be expanded to provide an interface to access information that has been summarized to meet ISEMP monitoring goals.
E Provide web services to deliver ISEMP data 7/1/2011 6/30/2012 Concluded Chris Jordan 5/4/2011 2:56:01 PM
Description: As web technologies continue to mature, data users request information through more sophisticated outlets, which can be integrated into their own systems. The SDM team will develop web services to provide an ISEMP data stream that can be consumed by other data management systems and end users.
F Database documentation 2/1/2012 6/30/2012 Concluded Chris Jordan 5/4/2011 2:56:01 PM
Description: The database documentation will include a complete data dictionary, table relationships, user roles, data loading and data quality procedures, trigger and journaling definitions. All data queries that are used to provide data to the end user will be fully documented
G Website documentation 2/1/2012 6/30/2012 Concluded Chris Jordan 5/4/2011 2:56:01 PM
Description: The website documentation will include all functional requirements and complete code documentation. The code documentation will include all user interface front-end functions and back-end procedures. A complete website user guide will be available to guide users through the website interface
H DELIV Enterprise-level tools to manage project data 6/30/2012 Concluded Chris Jordan 5/4/2011 2:56:32 PM
Description: Deliverable Title: STEM Database Maintenance and Enhancements Deliverable Specification: The STEM database has been developed to store data from numerous ISEMP data collectors for a wide variety of survey types. The SDM team will continue to load new data as it is provided from the regional data stewards. It is anticipated that additional survey types will be required to meet the goals of the ISEMP project and that database enhancements will be required to store and retrieve these new data types. As the ISEMP data coordinators develop processes to analysis the data, the SDM team will develop database routines to perform some of this analysis and will streamline data retrieval to meet the needs of these analysis. Deliverable Title: STEM Website Maintenance and Enhancements Deliverable Specification: The SDM team has developed a data query and delivery website to provide access to the STEM database. This system provides end users with a query interface that allows users to retrieve ISEMP data. As ISEMP data coordinators begin to develop data summaries for analysis purposes, the STEM website will provide a user interface that will dynamically retrieve this summary information. There have been requests to produce web services that will allow ISEMP data to be integrated with other data management systems. As the business rules and formats are defined for these services, the SDM team will develop the technical solution to provide this information. Deliverable Title: STEM System Documentation Deliverable Specification: In order to maintain the STEM data management system into the future a full set of documentation is crucial. This system documentation will ensure that as people move on, the system can be maintained. The system architecture will include complete database and website documentation as well as end user help guides.

Back To Top

Metrics

Implementation Metrics
None

Back To Top

Location

None
Back To Top

Focal Species

This work element does not require Focal Species
Back To Top

Environmental Compliance

This work element does not require Environmental Compliance
Back To Top

RM&E Metadata

Data Repositories:
""

Back To Top