RMP Data Management Update

1
RMP Data Management Update

• Cristina Grosso, John Ross, Donald Yee, Amy
  Franz, Sarah Lowe, and Todd Featherston

2
Data Management Update

• Overview of data review procedures
• 1st Quarter Highlights
• 2008 Objectives

3
Sample Collection to Web Query
4
Data Review Procedures Multiple Checks to
Insure High Quality Data

• Electronic Data Deliverable (EDD) template to lab

5
EDD Template to Lab
6
Data Review Procedures Multiple Checks to
Insure High Quality Data

• EDD review and summary report
• Expected number of samples and analytes
• Used standard codes
• Missing fields of information
• Range checks

7
EDD Review
8
Upload data to database
9
QA Review
10
Data Review Procedures Multiple Checks to
Insure High Quality Data

• QA review
• Data quality objectives
• Compare with historical data
• Ratio checking for trace organics

11
Data Review Procedures Multiple Checks to
Insure High Quality Data

• Complete EDD Summary Form
• Provide feedback to labs

12
EDD Summary Form
13
(No Transcript)
14
Data Review Procedures Multiple Checks to
Insure High Quality Data

• Compile data and make available via Web Query
  Tool

15
Sediment Data All in except Metals
16
Water Data All data are in
Dashed lines indicate missing data. Projected due
dates are used.
17
Timeliness Tracking

• External goal for receiving data 160 days
• Internal goal for formatting and QA review 90
  days
• Monthly review of data priorities

18
2008 Data Management Objectives

• Finalize data for Pulse
• Implement web-based data upload tool
• Improve web-based data access tool
• Include sportfish data and other pilot/special
  studies
• Update web interface
• Include AMR graphics on-line

19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
Data Management ActivitiesBeyond the RMP

• SWAMP Data Management User Group
• CEDEN and other Regional Data Centers
• NWQMC Meeting
• Fish Mercury Project (FMP)