Montana DEQ and Region 8 EPA

1
Montana DEQ and Region 8 EPA

• A Joint Project for Effective Utilization of
  STORET

2
By Deborah DorlandMontana DEQHelena,
MTphone [phone]email
ddorland_at_state.mt.us
3
Project DevelopmentConsiderations

• Limited resource
• Cycle of data management
• Sustainability

4
Task Based Project Components

• Data flow within the agency
• Migrate chemistry data backlog
• Migrate biological data backlog
• Web enabled SIM pilot project
• Requirements analysis for information management

5
Requirements Analysis

• Determine functional requirements
• Recommendation for platform
• Explore options for data analysis
• Survey of staff needs
• Oral interviews for key topics
• Summary report developed by MT DEQ, EPA region 8
  and Research Triangle Institute

6
Task Based Project Components

• Data flow within the agency
• Migrate chemistry data backlog
• Migrate biological data backlog
• Web enabled SIM pilot project
• Requirements analysis for information management

7
Enhance User Acceptance

• Increase data quantity
• Enhance data quality
• Reduce turnaround time from data collection to
  STORET warehouse

8
Data Backlog for Migration

• Chemistry data
• Biological data (taxon abundance)
• Historic data from special projects

9
Evaluate Data Flow

• Efficiency
• Streamline quality control activities

10
(No Transcript)
11
External Data Flow
12
Strategy for 319 Project Data and Other External
Data Sources

• Standardize format for electonic data
  deliverables
• Incorporate into contract requirements
• Guidance for data formats
• Provide access to import data directly to STORET
  through web-enabled SIM

13
Getting to the Complete SIM Deliverable

• Many data providers manage only a subset of
  metadata required for STORET
• Field monitors create stations and take field
  measurements
• Laboratories analyze samples and generate results
• Planning staff or project administrators develop
  project details
• Data provider must construct the complete data
  deliverable

14
Standardize LIMS EDD

• Data from multiple labs in variable formats
• State agency labs
• University labs
• Commercial Labs
• 319 projects use various approaches
• RFP for consistent STORET deliverables

15
Training and Technical Support

• Workshops
• Telephone / email
• Volunteer training
• Contracted support?

16
Support

• General guidance
• SIM templates (spreadsheets)
• Lists of acceptable values for STORET

17
Web-enabled SIM Hosted by Gold Systems
18

• Upload text file
• Select import configuration
• Import data to STORET

19
Scope and Scalability
20
Web SIM Pilot Project
21
McCone Conservation District Water Quality
Monitoring
22
Acknowledgements Tom Patton And Luke
Buckley Montana Bureau of Mines and Geology
23
Acknowledgements Diane Williams Dave
Stasney Will McDowell And John Babcock Tri-State
Water Quality Council
24
Acknowledgements Jeanne Rae Kirkegard McCone
Conservation District and Montana Department of
Natural Resources and Conservation (DNRC)