Products
menu item
Prospect
Quick estimate of PV site's solar potential
menu item
Evaluate
Time Series & TMY data for energy modelling
menu item
Monitor
Real-time PV output assessment
menu item
Forecast
Solar power output forecast for up to 14 days
menu item
Analyst
Simplified & unified solar data management
menu item
Integrations
Automate delivery of Solargis data
Use cases
menu item
Site selection
Find the right solar project location
menu item
Energy yield simulation
Analyze potential gains and risks
menu item
Optimizing power plant design
Find optimum power plant design
menu item
Real power plant performance
Discover the true output
menu item
Power output forecast
Predict solar project energy output
menu item
Ground data verification
Verify quality of solar & meteo measurements
Solar Resource & Meteo Assessment
Detailed solar resource validation and assessment
Site Adaptation of Solargis Models
Combining satellite data with on-site measurements
Quality Control of Solar & Meteo Measurements
Correction of errors in ground-measured data
Customized GIS Data
Customized Solargis GIS data for your applications
PV Energy Yield Assessment
Estimated energy uncertainties and related data inputs
PV Performance Assessment
Energy estimate for refinancing or asset acquisition
PV Variability & Storage Optimization Study
Understand output variability across wide geo regions
Regional Solar Energy Potential Study
Identification of locations for solar power plants
Our expertise
How our technology works
Methodology
How we transform science into technology
API & integration
How to integrate Solargis data via API
Product guides & documentation
Release notes
Success stories
Blog
Ebooks & Whitepapers
Webinars
Publications
Events
Free Maps & GIS Data
Solar performance maps
About Solargis
Partners
ISO Certification
Careers

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. 
Read more at http://en.wikipedia.org/wiki/Coordinated_Universal_Time

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 or sub-hourly time series

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 timestamps 00:30, 01:30 .... 22:30, 23:30. 
On request, we can also deliver data with timestamp 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 timestamps 01:00, 02:00 .... 23:00, 00:00

Exceptions in case of sub-hourly time series

In some instances, data values represent instantaneous values and not summary over a 15 or 30 minute period. This applies in the following scenarios:

i) 15-minute time series data is ordered for locations covered by Meteosat PRIME satellites

ii) 30-minute time series data is ordered for locations covered by Meteosat IODC satellites

In above situations data is represented in the time stamp of satellite data acquisition. For example, timestamps hh:12 and hh:42 would refer to instantaneous values at hh:12 and hh:42.

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

 

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