Database for Annual Processing and the Air Quality Information System

This Yearbook is the result of annual data processing of the systematically collected air pollution, emission data and data on the quality of atmospheric precipitation stored in the respective databases of the Air Quality Information System (ISKO). ISKO has been developed and operated since the beginning of 1992. The system is based on state-of-the-art information technologies and it represents an integrated system for nation-wide comprehensive assessment of the status and development of air quality. The system includes the collection, storage and processing of data from automatic and manually-operated air pollution monitoring networks in the Czech Republic, and the storage and processing of data on emissions and air pollution sources. The Internal (later Air Pollution) Information System (IIS) has become an integral part of ISKO, as have other air quality databases, especially the system of collection, processing and storage of data on individually registered air pollution sources (REZZO 1 and 2) and also the data on chemical composition of precipitation and atmospheric deposition. At present the reconstruction of the emission part of the ISKO database is carried out. After the completion also REZZO 3 including the data on stationary sources monitored as area sources will belong to the database. Together with air pollution data also supplementary meteorological data measured at the great number of CHMI automated air pollution stations are stored in the database.

The Air Quality Information System collects and generally provides access to data gathered within major ambient air pollution monitoring networks. It thus provides for a more effective and general utilisation of the expensive data. The integrated regionalised evaluation of air pollution levels, and analysis of the development over time of the status of air pollution in the Czech Republic would not be feasible without collecting and archiving systematically at one place all the air pollution data available.

A number of the institutions mentioned earlier have been contributing to the air pollution database for many years. Information on the concentrations of sulphur dioxide and suspended particulate matter (SPM) obtained from the CHMI�s stations in northern Bohemia and in Prague, has been archived since 1971.

Methodical development and technical provision for annual nation-wide procession and keeping of records of the emission database are carried out by CHMI. In the framework of the emission coverage of ISKO the annual overviews of emission data and supplementary technical information have been filed since 1993, from the operators of the most significant group of facilities as concerns emissions (formerly extra large and large sources). Starting from the 90�s the database includes also the data from the sources listed by the previous legislation among the so called medium-sized sources. At present the collection of data reported from ambient air pollution sources, newly defined in Annex No. 2 of the Act No. 201/2012 Coll. on Clean Air Protection, is carried out through the Integrated System of Compliance with Reporting Duty in Environmental Areas (ISPOP) implemented by Act No. 25/2008 Coll.

Emissions from local household heating units are inventoried according to the methodology developed in 1997 and based on the General Census data. The data are regularly (once a year) updated in cooperation with regional fuels and energy suppliers. At present the modified method of the year 2006 is used, and the 2011 General Census data are included. The final output of the model consists in data on emission of pollutants and on fuel composition for household heating units at local level. In addition to data on local household heating, also data on emissions from other stationary sources not listed in Annex No. 2 of the Act 201/2012 Coll., comprising the mass use of solvents, agricultural and building activity, are re-calculated in the REZZO 3 database.

The inventory of emissions from mobile sources (REZZO 4) covers road, railway, water and air transport processed by the Transport Research Centre (CDV) in Brno based on their own method and off-road mobile sources (agriculture, building industry etc.) processed with the use of the data on fuel consumptions (ČSÚ) and emission factors.

Fig. -1 schematically depicts ISKO�s links to data sources and co-operating systems. The scheme outlines the interconnection of air quality monitoring networks and sources of data on air emission with data processing and information layers represented by ISKO, and the linkage to a higher-level layer – �cross-sectional� information systems. The actual interconnection is carried out mainly through exchange of data by e-mail, further on magnetic media, over switched data lines and, in case of data from the automated air pollution monitoring (AIM) network, mainly over radio transmission.

The Tabular Survey and the Yearbook have been completely produced with the help of a computer system based on an innovated concept. It consists of a computer network around a database server with the multi-user relational database system installed and working under the Unix operating system. The new data model ISKO2 project was implemented in 2003 under RSBMS Oracle which is constantly being developed. ISKO2 meets the growing demands on data presentation in various forms incl. internet publication. The concept of the system is based on distributed processing in local networks on the workstations and PCs, with direct access of processing and analytical programs – such as the Geographic Information System (ARC/INFO and ArcView), statistical programs (SPSS, Statistica), spreadsheet and graphic programs – to the data stored in the central database which features uninterrupted and backed-up operation.

The Czech Hydrometeorological Institute has its regional offices in all the former regional capitals; these are mainly concerned with measurements, and data collection and data initial processing within their respective regions. The offices are connected to the central system in Prague via CHMI�s private WAN data network operating with TCP/IP protocol.

The selected information, tables, graphs and maps on air quality published in the Tabular Survey and in the Yearbook are accessible in the internet, URL: www.chmi.cz, where you can find other surveys relevant to ambient air pollution. At the website www.chmi.cz under �Air Quality� there are presented, with a small time lag, the results of measurements from AIM CHMI stations in the form of tables and the so called air quality index; the currently measured data can be displayed also in the form of graphs. Further, there are presented the estimates of spatial distribution of concentrations of currently measured 1-hour data (non-verified) of PM₁₀, SO₂, NO₂ and O₃ at the stations of automated monitoring from which data are submitted on-line to the ISKO database.

Fig. –1 Scheme of ISKO�s links to data sources and co-operating systems 2012