Anand Mudambi USEPA National Environmental Monitoring Conference 2011 August 16 2011 08162011 1 Data Management Issues Multiple databases processes procedures and methods for the same information ID: 277684
Download Presentation The PPT/PDF document "Electronic Management of Environmental A..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Electronic Management of Environmental Analytical Data
Anand Mudambi USEPANational Environmental Monitoring Conference 2011 August 16, 2011
08/16/2011
1Slide2
Data Management Issues
Multiple databases, processes, procedures, and methods for the same informationConsistent and stable business driven framework needs to be prescribed with all data generated registered into an Agency catalogue08/16/2011
2Slide3
Data Management Goals
Need to develop and implement: paperless data generation paperless data transfer/exchange review and management (input and retrieval) systems for all types of project data (e.g., field, chain-of-custody, analytical)
08/16/2011
3Slide4
General Environmental Data Flow- Need to Go Electronic
08/16/2011
4Slide5
Some Data Management System Concepts
Need to build systems that are used regularly Same systems for regular and emergency useSystem should be capable of being scaled up or down (e.g., number of samples, reporting of QC data)08/16/2011
5Slide6
Data Management Frameworks: Examples
EPA’s Environmental Response Laboratory Network and Water Laboratory AllianceEPA’s Contract Laboratory ProgramUSACE ADR.net08/16/2011
6Slide7
General Environmental Data Flow: Needs for Going Electronic
Standard formats for electronic project requirements.Standards/templates for field information. Standard formats for reporting analytical data.Standard procedures for reviewing analytical data.Standard formats for reporting reviewed analytical data
08/16/2011
7Slide8
Standard Format Requirements
Non-Proprietary Formats (e.g., XML)Use international standards for Valid Values (e.g., ISO, IEEE, ASTM)Guidance/Specification/Requirement Documents 08/16/2011
8Slide9
First Needs: Data Capture Requirements
Need to develop the following:Standard Specification for Laboratory Instrument Output files (e.g., NIST’s AnIML)Standard Specifications for Laboratory Information Management Systems (e.g., as an RFP)Standard Electronic Versions for Measurement Quality Objectives (e.g., ERLN WebEDR MQO Template)
08/16/2011
9Slide10
Followed By:Adoption of Standard Reporting Formats/Guidance
Laboratory Datae.g., Staged Electronic Data Deliverable (SEDD) for EPA (ERLN, CLP, GLPNO) and USACE programs, ERLN EDDsChain-of-Custody Informatione.g., WLA Response Plan (Appendix H)
08/16/2011
10Slide11
Then: Data Reporting Formats/Tools
EPA and NISTDeveloping an electronic deliverable that contains all laboratory and instrument data in a non-proprietary format for archival and retrieval (SEDD with AnIML)EPA Forms GeneratorGenerating different reporting formats from the same electronic deliverable (e.g., CLP and CLP – like forms)
08/16/2011
11Slide12
Leads to:Data Assessment
Data Analysis or AssessmentConfidence in the reliability of data and ability to use appropriately are importantConsistent application of the data life-cycle and enforcement of data quality policies for greater confidenceScientific Integrity
08/16/2011
12Slide13
Facilitating Data Assessment byAutomating Data Review
Example Data Review Software EPA ERLN WebEDR, EPA CLP EXES, USACE Automated Data Review.NETNeed Specifications for Data Review Software
08/16/2011
13Slide14
Facilitating Data Assessment by Identifying Data Quality
Capturing Data Review Steps In End User Databasese.g., EPA’s Guidance for Labeling Validated Analytical Data 08/16/2011
14Slide15
Why do all this:Benefits
Ease of data exchangeEase of data storage and retrievalAllows for verifying reported data (current and in future)Allows for reuse of data
08/16/2011
15Slide16
Getting to an Electronic WorldNeed to get rid of the “Not-Invented-Here-Syndrome” (i.e., adoption of agency specific standards/systems)
Need all parties (Federal and State Labs) to cooperate and adopt a set of data management standards that can be used by all parties 08/16/2011
16Slide17
Websites - 1
ERLN: http://www.epa.gov/oemerln1/WLA: http://water.epa.gov/infrastructure/watersecurity/wla/index.cfm
08/16/2011
17Slide18
Websites - 2
SEDD: http://www.epa.gov/fem/sedd.htmEPA’s Guidance for Labeling Validated Analytical Data :
http://www.epa.gov/superfund/policy/pdfs/EPA-540-R-08-005.pdf
08/16/2011
18Slide19
Contact Information
Anand Mudambi Mudambi.Anand@epa.gov 202-564-2817Joseph Solsky Joseph.F.Solsky@usace.army.mil
402-697-2573
08/16/2011
19