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.
References
[1]
Dvorská, A., Sedlák, P., Schwarz, J., Fusek, M., Hanus, V., Vodicka, P. and Trusina, J. (2015) Atmospheric Station Kresín u Pacova, Czech Republic—A Central European Research Infrastructure for Studying Greenhouse Gases, Aerosols and Air Quality. Advances in Science and Research, 12, 79-83.
https://doi.org/10.5194/asr-12-79-2015
[2]
Hazan, L., Tarniewicz, J., Ramonet, M. Laurent, O. and Abbaris, A. (2016) Automatic Processing of Atmospheric CO2 and CH4 Mole Fractions at the ICOS Atmosphere Thematic Centre. Atmospheric Measurement Techniques, 9, 4719-4736.
https://doi.org/10.5194/amt-9-4719-2016
[3]
Yver-Kwok, C., Philippon, C., Bergamaschi, P., Biermann, T., Calzolari, F., Chen, H., Conil, S., Cristofanelli, P., Delmotte, M., Hatakka, J., Heliasz, M., Hermansen, O., Komínková, K., Kubistin, D., Kumps, N., Laurent, O., Laurila, T., Lehner, I., Levula, J., Lindauer, M., Lopez, M., Mammarella, I., Manca, G., Marklund, P., Metzger, J-M., Molder, M., Platt, S.M., Ra-monet, M., Rivier, L., Scheeren, B., Sha, M.K., Smith, P., Steinbacher, M., Vítková, G. and Wyss, S. (2021) Evaluation and Optimization of ICOS Atmospheric Station Data as Part of the Labeling Process. Atmospheric Measurement Techniques, 14, 89-116.
https://doi.org/10.5194/amt-14-89-2021
[4]
D’Amore, F., Bencardino, M., Cinnirella, S., Sprovieri, F. and Pirrone, N. (2015) Data Quality through a Web-Based QA/QC System: Implementation for Atmospheric Mercury Data from the Global Mercury Observation System. Environmental Science: Processes & Impacts, 17, 1482-1491. https://doi.org/10.1039/C5EM00205B
[5]
European Monitoring and Evaluation Programe. http://ebassubmit.nilu.no/
[6]
Open-Source Project for Network Data Access Protocol. http://www.opendap.org/
[7]
Sierra, K. and Bathes, B. (2003) Head First Java. 2nd Edition, O’Reilly Media, Inc., Sebastopol, CA.
[8]
Reese, G., Yarger, R. J., King, T. and Williams, H. E. (2002) Managing and Using MySQL. 2nd Edition, O’Reilly and Associates, INC., Sebastopol, CA.
[9]
Unidata (2020) NetCDF Java version 5.4.1 [software]. Boulder, CO: UCAR/Unidata Program Center. https://www.unidata.ucar.edu/software/netcdf-java/
[10]
Rinn, B. (2018) JHDF5 (HDF5 for Java) 14.12 [software]. Zurich, ETH Zürich, Hauptgebaude, Ramistrasse 101.
https://sissource.ethz.ch/sispub/jhdf5
[11]
Kumar, A. (2004) JavaDBF ver. 0.4.0 and above [software]. Linuxense Information Systems Pvt. Ltd., Trivandrum.
http://priede.bf.lu.lv/ftp/pub/DatuBazes/DBF/javadbf/javadbf-tutorial.html
