Extração de dados atmosféricos

Abstract

The study of climate change, such as the increase in temperatures in cities, heavy rains and droughts among other changes that promote these changes, requires a series of data for an explanation and interpretation to be formed for the observed scenario. With this issue as a basis, this study aimed to extract and acquire climate data from the Solar Energy Research Stations - EPESOL of the Solar Energy Laboratory (LABENS) of the Federal Technological University of Paraná (UTFPR) installed on some campuses. The climate indicators that are the object of this study are: Air Temperature, Wind Speed, Relative Air Humidity, Global Horizontal Radiation, Direct Radiation, Diffuse Radiation, and Descending Long-Wave Infrared Radiation. The extraction and acquisition of data from these indicators was done by creating commands in postgresql language for each indicator in the LABENS platform, generating the corresponding APIs - Application Programming Interface keys. The key APIs generated were imported into Excel and inserted into an interface built with VBA (Visual Basic for Applications) to allow the search for climate data that are monitored in each station of the Universidade Tecnológica Federal do Paraná - UTFPR at its location and on a date defined by the user. The link generated by the interface should be inserted in the search bar of a web browser to display the searched results in JSON or CSV format. A second interface for creating new commands that generate a new API key has been built for users who have an account to access the Labens platform. The acquired weather data can be used according to interest and application.