Support Product guides Time series and TMY data

Data format

Time reference

By default, we use UTC (Coordinated Universal Time) as a time reference for Solargis time series datasets. UTC is equivalent to GMT (Greenwich Mean Time), therefore UTC+1 equals to GMT+1. 

In the case of hourly time series data and TMY data files, we also deliver the data with time reference set as longitudinal time zone, calculated using longitudinal reference of the site as follows: longitude°/15 (rounded value). Please note that in many regions the time zone based on the longitudinal reference will deviate from the legal time (for example in Chile, the time zone used is UTC-3:00, however longitudinally it belongs to UTC-5:00). The only reason for having data in longitudinal time zone is to facilitate easy import of Solargis time series data to PVsyst.

For time series data accessed using Web Services it is possible to specify time zone of your choice.

Time stamps

Timestamp for hourly time series

For representing hourly summaries we use centre of summarization (averaging) interval as default. This means that time intervals 00:00-01:00, 01:00-02:00 .... 22:00-23:00, 23:00-24:00 are represented by time stamps 00:30, 01:30 .... 22:30, 23:30. 
On request, we can also deliver data with time stamp set as end of summarization (averaging) interval. In such case time intervals 00:00-01:00, 01:00-02:00 .... 22:00-23:00, 23:00-24:00 will be represented by time stamps 01:00, 02:00 .... 23:00, 00:00

The type of time stamp used will always be mentioned along with other meta information in the data files delivered.

Timestamp for 10/15/30 minute time series

In the case of sub-hourly time series, data values represent instantaneous values and not summary over a 15 or 30 minute period. When the time series is in original time resolution ( i.e 15 minutes for Meteosat PRIME satellite, 30 minutes for Meteosat IODC satellite), data is represented in the time stamp of satellite data acquisition. This helps to avoid degradation of the information content by temporal interpolation.

When I open Solargis data file using Microsoft Excel, all data parameters are showing in one column. How can I separate the data into several columns?

The standard delivery format of Solargis data files is .csv and when you open such file using excel, all data values may be in the first column.

By default, all values should be in numeric format. However, if your computer recognizes ',' or 'comma' as the decimal character instead of '.' some values may appear in date format. In such case, you may want to change the file extension to .txt and then open with excel.

You can then convert all data from the first column to multiple columns using following steps:

  1. Choose the column with all the text and run 'Text to columns wizard' (can be found under Data tab) 
  2. Set Delimited, Next
  3. Select Semicolon, unselect Tab
  4. Select Text as Column Data format
  5. Finish