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