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:
•    raw data (with date/time constraints)
•    daily/monthly/annual/general summaries
•    summary options are: average, min, max, range and standard deviation
The ArcGIS-interface enables raw data extraction into the application

Picture 1. Turclim user interface (first version).   
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:
- Temp °C
- NetRadiation W/m2
- SoilTemp1 °C
- SolarRadiation W/m2
- WindDirMax °
- WindSpdAvg m/s
- Precipitation mm  
- Temp °F
- Pressure hPa
- SoilTemp2 °C
- WindDirInst °
- WindDirMin °
- WindSpdMax m/s
- PrecipitationSum5Min mm
- DewPoint °C
- RelativeHumidity %
- SoilTemp3 °C
- WindDirAvg °
- WindSpdInst m/s
- WindSpdMin m/s
- PrecipitationSum24h mm
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.

Picture 2. Interpolation of temperature data of April 1st 2002. Applied technique: IDW.

Picture 3. Temperature run for Betel and Kauppatori loggers in the city center.

Picture 4. Daily run for Kauppatori (city center) and Niuskala (rural, to the NE from the city centre) loggers

Picture 5. Zonal mean, minimum and maximum temperatures based on IDW-interpolation. Mean zonal temperatures are illustrated in the map (zone widths = 1 km, black cross marks Turku city centre)
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.


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)

20014 Turun yliopisto, Finland
Tel. +358 29 450 5000

People search

Follow us: 
Facebook   Twitter   Instagram   Youtube   LinkedIn
© University of Turku