Data storage format was in 2005 changed from MS Acces to My SQL, which was seen to be better in handling increasing amount of observations. Since then it has been possible to make queries into the database via TURCLIM user interface (Picture 1) and export the results into MS Excel. The query options are:

All the 58 temperature loggers are configured to register the air temperature in degrees Fahrenheit and Celsius at exactly the whole and half hour. This provides 48 x 58 x 2 = 5568 values a day that were firstly stored in MS Excel format as well as in a MS Access database. After 2005, data has been stored in My SQL-database as well as in MS Excel format. Temperature loggers has to be read two times in a year with Hobo Shuttle –device, which can be connected to lap top computer. By using Box Car Pro –program it’s possible to get a data from Hobo Shuttle in dtf-format. Dtf files can then be exported into text files, which are then ready to be exported into Turclim database with Turclim user interface.

The Tuorla weather station is currently configured to register the following variables at an interval of 5 minutes:

The station is set in such a way that it measures most variables with an interval of a few seconds. For every 5 minutes interval average values are calculated and stored. Some variables mentioned above do not result from direct measurements. The dew point is for example calculated from the air temperature and the relative humidity. And the temperature in degrees Fahrenheit is calculated from temperature in degrees Celsius. In total 21 variables are registered, which makes 12 x 24 x 21 = 6048 values a day. After reading the data it is processed to MS Excel format. Furthermore, the data is added to the same My SQL database that contains the logger data.

Below, some examples of the data sets and their preliminary analyses are shown.

Temperature interpolation created by interpolating each logger’s mean temperature of August 2001. Colours in the image as well as the graphs on the left indicate that mean and minimum temperatures decreased with increasing distances from the city centre.

Documentation

Since the project is meant to run for several decades, it is highly unlikely that the same persons will be involved all the time. It’s therefore important that contact information and work methods are well documented. Probably, the most important documents that can be found from the ‘Ilmastoprojekti’ folder (path \\Utu.fi\verkkolevyt\Maantiede\export\Projects\Ilmastoprojekti)