As reported to Northwest Power and Conservation Council 12142005

1
Report on Progress to CBFWA 3-29-06
Tom ONeil and Tom Pansky

• As reported to Northwest Power and Conservation
  Council 12-14-2005

2
BACKGROUND

• NED is following the recommendations of the
  Independent Scientific Review Panel (2000) and
  Scientific Applications International Corporation
  (2003) Studies
• NED MOU developed in December 2004
• Background material is posted at
  http//www.nwcouncil.org/ned/Default.asp

3
NED GOAL

• To improve the quality, quantity, and
  availability of regional data and related
  information on fish, wildlife and water using a
  publicly supported approach to information
  systems management

4
Steering Committee Progress

• Convened monthly meetings
• Outreach on MOU participation
• Set up 6 work groups developed work products
• Convened Data Discovery and Sharing Workshop
• Developed Executive Decision Table
• Maintained Regional Data Network Strategy

5
MOU Participation

• Signed MOU and participating BPA, EPA, NMFS
  -NWFSC and NWRO, USACE, CRITFC, State of the
  Salmon Consortium, NPCC, PSMFC, BCMSRM, States
  of Washington and Oregon.
• Not signed but participating USBoR, USFS, USBLM,
  USGS, USFWS, NWIFC, States of Montana and Idaho.
• will re-sign the MOU as Integrated Land
  Management Bureau.

6
Progress Temporal Spatial Work Group. Lead,
Joy Paulus, WA IAC

• Drafted Best Practices for Reporting Spatial and
  Temporal Data (for projects and monitoring) Into
  Non-Spatial Databases.
• Agency Executive will need to decide on
  deployment of these Best Practices.

7
Progress Technology for Data Discovery and
Sharing Work Group. Lead, Tom Pansky, BPA

• Deploying a pilot portal to improve data
  discovery and sharing and data stewardship.
• Executive decisions needed to support publishing
  data to the Portal.
• Overview later in this meeting.

8
Progress Salmonid Monitoring and Research Data
Work Group. Lead, Stewart Toshach, NOAAF

• Multiple advocacy efforts to use consistent
  protocols for data management e.g. regional data
  dictionary, PCSRF and PISCES databases and RME.
  
• Executive decisions will be needed to attach data
  protocols to agency project deliverables.
• Developed NOAA funding (100K) to map Pacific
  Salmonid trend and abundance data collection
  procedures.

9
Progress Subbasin Planning Data Work Group.
Leads, Peter Paquet, NPCC Phil Roger, CRITFC

• Developed a solution to make Sub-basin planning
  data available (it had previously been collected
  without standard reporting requirements).
  Executive decision needed on use of reporting
  requirements.
• Organized contracts to assemble
• Sub basin EDT and QA/QC data
• Reach system data (NWHI)

10
Progress Water Quality Data Work Group. Lead,
David Tetta, EPA

• Developed draft inventory of water quality and
  other related databases for the Pacific
  Northwest.
• Facilitated and promoted the adoption of
  distributed data base methods (DDBMS) developed
  by the EPA within the region.
• Executive support needed for a distributed data
  base model for fishery, habitat and water data.

11
Progress Regional Aquatic, Riparian and Upland
Habitat Data Work Group. Lead Tom ONeil, NWHI

• Completing an extensive inventory of data
  definitions for riparian and upland species
  through contact with more than 40 groups.

12
Data Discovery and Sharing Workshop

• Organized Regional Data Discovery and Sharing
  Workshop with more than 75 State, Provincial and
  Tribal participants.
• Consensus that executive support and more formal
  arrangements are needed to improve data discovery
  and sharing across geographic and jurisdictional
  boundaries.
• Wrote Workshop White Papers.

13
Use of Workshop Findings

• Workshop recommendations and SAIC recommendations
  integrated into a single detailed table NED
  Executive Decision Table.
• Decision Table supported at NED Executive Meeting
  on 12-7-05
• Details of needed Executive Decisions are marked
  in green.

14
Summary Regional Data Network Strategy and Needed
Executive Actions

• Build participation in MOU. Executive decisions
  on signing MOU are needed by some agencies.
• Move beyond our current ad-hoc arrangements
  (ensure long term return on investment).
  Executive decisions are needed on organizational
  and administrative arrangements and cost share
  agreement.
• Work on data standards, data stewardship (low
  cost - high impact). Executive support is needed
  for in-kind FTE contributions (approximately 0.5
  FTE) from each major agency to draft a regional
  data sharing agreement.

15
Summary Regional Data Network Strategy and
Needed Executive Actions

• 4. Keep standards in an on-line regional data
  dictionary (e.g. BoR effort). Executive support
  is needed to fund evaluation and web enablement
  of the BoR data dictionary.
• 5. Work on data discovery and sharing (improve
  metadata build a portal). Executive support is
  needed to require data gatherers to publish their
  metadata to the portal. A Web Content Steward is
  also needed.
• 6 Migrate to a DDBMS (distributed database
  management system) to connect regional databases
  into a coherent network. Executive support is
  needed for a pilot effort to connect critical
  databases via DDBMS technology EPA model.

16
Announcement 2006 Pacific Northwest
Environmental Data Management Workshop

• May 23-24, Billy Frank, Jr. Conference
  Center, Jean Vollum Natural Capital Center, 721
  NW 9th Avenue, Portland, Oregon 97209
• Facilitate communications among scientists and
  program, resource, and data managers on regional
  technology and data sharing opportunities
• Identify tools and methodologies to assist in
  environmental data monitoring and management
• Explore partnership incentives and agreements for
  data management and use

17
Questions and Answers
18
COMPARISON

• Warehouse approach
• Distributed database management system (DDBMS)

19
(No Transcript)
20
(No Transcript)
21
Reminder of scope and scale of needed effort
e.g. just for Columbia Federal Salmon Funding
22
(No Transcript)
23
Principle Meet many users needs
Number of users
Data size