Available Parameters

Sun

Sunrise and sunset as SQL date, datenum, or unix time stamp. The datenum format is compatible with the Matlab and Python (matplotlib) time stamps.

Below is an overview of all parameters related to the sun:

Sunrise | Sunset | Sunshine Duration | Relative Sunshine Duration |UV Index

Each parameter is explained in more detail below.

 

Sunrise

This parameter returns the date and time of sunrise at a given location. Remember that all times are given in UTC.

sunrise:sql

Note: Some special cases may occur, which give rise to the following outputs (no date/time outputs):

-777: The sun is not visible

-888: The sun is always visible

Examples

 

Sunset

This parameter returns the date and time of sunset at a given location. Remember that all times are given in UTC.

sunset:sql

Note: Some special cases may occur, which give rise to the following outputs (no date/time outputs):

-777: The sun is not visible

-888: The sun is always visible

Examples

 

Accumulated Sunshine duration

Gives the amount of time the sun was shining within the requested interval.

sunshine_duration_<interval>:<unit>

Available intervals: 1h, 3h, 6h, 12h, 24h

Available Units: h, min

Examples

 

Relative sunshine duration

The duration of sunshine divided by the amount of time the sun was above the horizon at the queried coordinate and time.

sunshine_duration_24h:p

Examples:

 

UV Index

The UV Index is computed based on model outputs, most current satellite images and 90m-resolution topography.

uv:idx

Examples:

    validdate;uv:idx
    2018-07-20T00:00:00Z;11
    2018-07-21T00:00:00Z;10
    2018-07-22T00:00:00Z;9
    2018-07-23T00:00:00Z;7
    2018-07-24T00:00:00Z;10
    2018-07-25T00:00:00Z;8
    2018-07-26T00:00:00Z;6
    2018-07-27T00:00:00Z;11
    2018-07-28T00:00:00Z;11
    2018-07-29T00:00:00Z;11
    2018-07-30T00:00:00Z;10

News