220 likes | 242 Views
RMP Data Management Update. Cristina Grosso, John Ross, Donald Yee, Amy Franz, Sarah Lowe, and Todd Featherston. Data Management Update. Overview of data review procedures 1 st Quarter Highlights 2008 Objectives. Sample Collection to Web Query.
E N D
RMP Data Management Update Cristina Grosso, John Ross, Donald Yee, Amy Franz, Sarah Lowe, and Todd Featherston Draft Data - Do not cite or quote
Data Management Update • Overview of data review procedures • 1st Quarter Highlights • 2008 Objectives Draft Data - Do not cite or quote
Sample Collection to Web Query Draft Data - Do not cite or quote
Data Review Procedures: Multiple Checks to Insure High Quality Data • Electronic Data Deliverable (EDD) template to lab Draft Data - Do not cite or quote
EDD Template to Lab Draft Data - Do not cite or quote
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 Draft Data - Do not cite or quote
EDD Review Draft Data - Do not cite or quote
Upload data to database Draft Data - Do not cite or quote
QA Review Draft Data - Do not cite or quote
Data Review Procedures: Multiple Checks to Insure High Quality Data • QA review • Data quality objectives • Compare with historical data • Ratio checking for trace organics Draft Data - Do not cite or quote
Data Review Procedures: Multiple Checks to Insure High Quality Data • Complete EDD Summary Form • Provide feedback to labs Draft Data - Do not cite or quote
EDD Summary Form Draft Data - Do not cite or quote
Data Review Procedures: Multiple Checks to Insure High Quality Data • Compile data and make available via Web Query Tool Draft Data - Do not cite or quote
Sediment Data: All in except Metals Draft Data - Do not cite or quote
Water Data: All data are in Dashed lines indicate missing data. Projected due dates are used. Draft Data - Do not cite or quote
Timeliness Tracking • External goal for receiving data – 160 days • Internal goal for formatting and QA review – 90 days • Monthly review of data priorities Draft Data - Do not cite or quote
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 Draft Data - Do not cite or quote
Data Management Activities:Beyond the RMP • SWAMP Data Management User Group • CEDEN and other Regional Data Centers • NWQMC Meeting • Fish Mercury Project (FMP) Draft Data - Do not cite or quote