Data Management Projects

1. Data Management Projects Data Management Framework Subcommittee Update June 19, 2007

2. Data Management Project Reviews • FY2007-2009 Mainstem Systemwide Review Team • Sept. 2006 Data Management Workshop • DMFS • Draft NED Workplan • NED Fish and Wildlife Program Workgroup created • Draft Strategy for Data Management

3. MSRT Recommendations • StreamNet – focus on developing a hierarchical geographic data structure that supports subbasin planning and recovery planning • IBIS – focus on hierarchical mapping of wildlife habitats to support subbasin planning and SOTR • CSMEP and PNAMP address data needs, how they should be collected, and identify data gaps • NED will help facilitate the efficient transfer of data Council held data management projects level funded until a comprehensive plan could be articulated for the Program

4. Data Management WorkshopSept. 2006 Recommendations: • address data gaps • improve timeliness of data sharing • focus on data priorities • improve QA/QC practices • develop more efficient data systems The results of this workshop was not helpful for StreamNet in developing their SOW

5. Data Management Framework Subcommittee • Created to provide short term guidance to StreamNet on data priorities • Continued to provide 1) discrete data needs for F&W Program and 2) determine what projects are needed to support Program reporting (SOTR) • Spring 2007 MAG directed DMFS to provide FY08-09 data management project funding recommendations

6. Draft NED Workplan Identified specific pilot projects to fill current gaps in data management for F&W Program • NED Portal channel steward • Web supported data integration • Develop best practices guidance QA-QC • Improve geo-referencing (NHI) • Tribal data support No scheduled CBFWA review of work plan

7. NED F&W Program Workgroup • Created to support development of a strategy document to support data management project recommendations • Merged with DMFS out of convenience • Using NED data management experience and DMFS data requirements knowledge to formulate a strategy • Presentation scheduled to NPCC in July

8. Federal Enterprise Architecture • Developed to coordinate data management between and within Federal agencies • Flexible structure supports continuity while drilling down from big picture (collaborative groups) to finer details (projects) • Forces thought about standards, business elements, goals, targets, transitions

9. Business Drivers Design Drivers Le Level I Regional/National Standards NED/RGIC Technology Applications Architecture Drivers Data Architectural Segments Current NED Portal RGIC Target Business Architecture Universal Access to data NED White Papers and Workshops MOUs Vision Data Architecture Regional Agreements Others… Strategic Direction PNAMP PSMFC WA IAC NOAA Fisheries BPA EPA RGIC Applications Architecture Defined BMPs Principles DDBMS Architecture Technology Architecture Architecture Investment Review Architectural Models DRAFT Segment Coordination Market Research Asset Management Transitional Processes

10. Business Drivers Design Drivers Level II Columbia River Basin Standards Data management committee and NED Channel Steward/Coordinator? Technology Applications Architecture Drivers Data Architectural Segments Population Data Habitat Data Project Data Current Numerous reporting efforts* Target Business Architecture Report Alignment Ad-hoc data efforts, warehouses, etc. Individual agency standardization Vision Data Architecture DDBMS PCSRF Reports Recovery Monitoring Strategic Direction NED Portal FCRPS M&E Applications Architecture Defined BMPs SOTR PISCES Principles Defined BMPs Architecture Technology Architecture Architecture Segment Coordination Architectural Models DRAFT Transitional Processes Incremental development of architecture within a structured framework *Data needs cross institutional boundaries

11. Business Drivers Design Drivers Level III Fish and Wildlife Program Standards PNAMP CSMEP Technology Applications Architecture Drivers Data Architectural Segments SOTR FCRPS Performance Recovery Monitoring Current Program/ESA Accountability Target Business Architecture Accountability M&E Designs Analytical Transparency Cost Effectiveness Vision Data Architecture Priorities met Other data providers Strategic Direction States, Tribes, Feds PSMFC FPC DART NHI – IBIS Applications Architecture Access to data StreamNet Principles DDBMS Architecture Technology Architecture Architecture Investment Review Architectural Models DRAFT Segment Coordination Transitional Processes Incremental development of architecture within a structured framework

12. Data Priorities • SOTR, Recovery Monitoring, FCRPS BiOps • Example - Anadromous Fish Abundance Age composition Catch statistics Other upstream losses Hatchery/Wild ratios Smolt survival

13. Business Drivers Design Drivers Level IV Project Specific Standards Data Management Oversight Committee? Technology Applications Architecture Drivers Data Architectural Segments Projects Current User Driven Target Business Architecture Support Program Priorities Ad-hoc User driven Vision Funding levels Specific data formats Data Architecture Regional Standards Strategic Direction Data sharing protocols Metadata requirements Applications Architecture Defined BMPs Principles Defined BMPs Architecture Technology Architecture Architecture Investment Review Architectural Models DRAFT Segment Coordination Asset Management Transitional Processes Incremental development of architecture within a structured framework

14. Strategy • Level fund projects for FY08-09 to preserve resources • Restructure existing projects to address priorities (identify gaps) • Fund pilot efforts to fill immediate gaps (data coordinator, tribal data, habitat data) • Develop project specific frameworks in FY08 • Be prepared in 2009 for a comprehensive data management plan for F&W Program

15. Next Steps Release Strategy Document for review by DMFS and NED Workgroup (June 25) • Develop project specific restructuring recommendations (week of June 25) • Get CBFWA and NED approval of strategy (July 10) • Get CBFWA approval of project recommendations (July 10) • NED presentation at July Council meeting • CBFWA recommendations/comments by July Council meeting?