MeteoRead: Client Software for Inserting Observed Atmospheric Data into MySQL&amp;lt;sub&amp;gt;TM&amp;lt;/sub&amp;gt; Database and Downloading them into Different File Format

Beáta Szabó-Takács,Tamás Takács,Aleš Roček

doi:10.4236/jsea.2021.1410033

Abstract

The investigation of the tendency of climate change and its effects on ecology, economy and sociology is essential for long term policy making. The long-term measurement of the physical and chemical properties of the atmosphere with state-of-the-arts instruments provides high-quality data for these studies. The evaluated data are stored in really special file structures and formats that cannot be inserted in one common database. Moreover, the observed data usually available in ASCII format and the users sometimes need to convert them in other format. The file conversion is usually time consuming procedure and can contribute to the uncertainties. MeteoRead is a client database software that imports the observed atmospheric data e.g. wind direction, wind speed, aerosol particle concentration etc. and makes them available in different file formats, which are most commonly used in climate research. This JavaTM based program applies the Structured Query Language (SQL) functions such as table creation on a database server, data or figures insertion into the table and data selection via Graphical User Interface. The selected data can be stored in NetCDF, HDF5, DataBase or TXT file formats and the figures can be available in PNG, JPG, JPNG, PDF or GIF file formats. The program was tested on Linux and Windows platforms with different JavaTM Development Kit. The MeteoRead is planned to be developed to visualizing the annual, seasonal, monthly, daily or hourly average value of the selected data and to use the functionality of the SQL database to calculate various mathematical and statistical correlations.

Highlights

Investigation of the impact of global climate change on the atmosphere requires state-of-art instruments for acquiring high-quality data
The selected data can be stored in NetCDF, HDF5, DataBase or TXT file formats and the figures can be available in PNG, JPG, JPNG, PDF or GIF file formats
The activities of our department are based on provision and exploitation of measurements conducted at the Atmospheric Station Křešín u Pacova, which is part of the National Atmospheric Observatory Košetice (NAOK) and member of some international programs like Integrated Carbon Observation System (ICOS), Global Mercury Observation System (GMOS), Aerosol, Clouds, and Trace Gases Research Infrastructure Network (ACTRIS), European Monitoring and Evaluation Program (EMEP) and Air Quality Information System (ISCO) in the middle of the Czech Republic (49 ̊35'N, 15 ̊05'E)

Summary

Introduction

Investigation of the impact of global climate change on the atmosphere requires state-of-art instruments for acquiring high-quality data. The observed data are available in the above-mentioned systems but to collect the different data the user need connect to multiple databases. The observed data usually available in ASCII format and the users sometimes need to convert them in other format e.g. HDF5, NetCDF or DataBase. The evaluated data are stored in really special file structures and formats that cannot be inserted in one common database. Our observed and qualified atmospheric data with the benefits that allows create a database table, insert data from different special file structure and that the data make available in a different file format without the necessity of user experience in database handling. The exported data can be stored in four different file formats: NetCDF, HDF5, DataBase and TXT. The users can insert figures (e.g..png,.jpg,.pdf) into the database, and the figures can be downloaded in five different figure formats: PNG, JPG, JPNG, PDF and GIF

Data and Tools

Szabó-Takács et al DOI

Creating SQL Tables and Importing Data

Data Selecting and Export

Conclusions and Future Plan