Data management of environmental monitoring data

1. Data management of environmental monitoring data Senior coordinator Leena Grönholm Data and Information Centre, ICT Services Division EIM Systems Expert, project manager

2. Agenda • Introduction to Environmental Information System Hertta • A brief look at Hertta • History of our environmental information systems • System development • Data management

3. Introduction to Hertta 1/3Subsystems • Hydrology • Hydrological observations • Forecast models • Management • Floods • Lakes • Rivers • Water resources engineering • Projects • Structures and measures • Surface waters • Water quality • Zoobenthos • Phytoplankton • Algal Blooms • Fish monitoring • RBD Monitoring • Water management of surface waters • Groundwater • Groundwater areas • Observation sites • Groundwater sites • EU reporting • Species • Monitoring of threatened species • Species info • References • Statutes • Monitoring of moths • Environmental load • Air emissions • Estimated water load • Accumulation of harmful substances • Environmental properties of chemicals • Land use • Monitoring of living environment • Planning indicators • Monitoring of planning processes • Monitoring of spatial structure • Map service

4. Introduction to Hertta 2/3 • Contains environmental data produced or gathered by environmental administration • Raw in-situ data (observations, measurements, analysis results) • For professionals • Available for everybody in environmental administration • All public data also available in Internet (Oiva)wwwp2.ymparisto.fi/

5. Introduction to Hertta 3/3 • User interface in web browser • Consists of several web-applications and databases • Common architecture and user interface • Shared application components and code lists (classifications) • Links between applications

6. A brief look at Hertta 1/8

7. A brief look at Hertta 2/8 Filtering of data

8. A brief look at Hertta 3/8 Lists

9. A brief look at Hertta 4/8 Maps

10. A brief look at Hertta 5/8 Information forms

11. A brief look at Hertta 6/8 Information forms

12. A brief look at Hertta 7/8 Simple graphs

13. A brief look at Hertta 8/8 Data can be retrieved to files for statistical analyses

14. History of our environmental information system • Hertta is a third generation environmental information system of our organisation • In early1970’s the first one was developed and maintained in a software company • Between 1987-1991 the second one called YTJ was developed in-house • 1997 we began to build Hertta • The first version was published in 1999 • New subsystems have been added gradually • Since 2009 a new tecnical architecture and user interface desing have been adopted

15. System development • In-house development project for each subsystem • Topic experts and IT experts together during whole project • Many of our IT experts have also good knowledge of the subject (academic degree) • As much common and shared things as possible • All kinds of standards from the beginning • Naming conventions • Classifications and codes • Security issues

16. Data management 1/3 • Datasets are produced and collected to the system in various ways • Monitoring, research projects, surveys • Administration’s own activities • Activities subject to environmental permits • Cooperation partners • Enthusiasts

17. Data management 2/3 • Our aim is to put data to electrical format • only once • in the earliest possible phase • by those who have produced the data • We use as much common classifications as possible • ”code lists” shared with data producers

18. Data management 3/3 Data entry forms DB Analysis results Files from partners etc. Lims DB DB Results Automated field instruments Digital field instruments