Climate temperature data

Above is the workflow that loads the maximum temperature values.  The data downloaded from the European Climate Assessment Dataset (https://www.ecad.eu/dailydata/) , created one fixed column width text file for each weather station in each country. In the Fixed Width file reader we define each of the columns. The dataset we will look at contains the maximum temperature values recorded.

We also have to extract the country name and weather station name, which are always in the same row of each file.

Below is the resulting table in Postgres: it has columns for country, weather station, year and the maximum temperatures for the whole year, the 'winter half' of the year, the 'summer half' of the year, each of the 4 seasons and each of the 12 months.

Below is the result of running the Data App. We selected SWITZERLAND as country and BASEL BIN as the weather station. Is shows us a graph of the maximum yearly temperatures.