Unaggregated series

Unaggregated series in json: $day.outTemp.series.round(5).json():

[[1283497200, 1283499000, 8.24191], [1283499000, 1283500800, 7.14217], [1283500800, 1283502600, 6.17686], [1283502600, 1283504400, null], [1283504400, 1283506200, 4.71254], [1283506200, 1283508000, 4.23834], [1283508000, 1283509800, 3.94778], [1283509800, 1283511600, 3.8457], [1283511600, 1283513400, 3.93373], [1283513400, 1283515200, 4.21025], [1283515200, 1283517000, 4.67041], [1283517000, 1283518800, 5.30621], [1283518800, 1283520600, 6.10665], [1283520600, 1283522400, 7.05791], [1283522400, 1283524200, 8.14361], [1283524200, 1283526000, 9.34504], [1283526000, 1283527800, 10.64152], [1283527800, 1283529600, 12.01076], [1283529600, 1283531400, 13.4292], [1283531400, 1283533200, 14.87245], [1283533200, 1283535000, 16.31571], [1283535000, 1283536800, 17.73414]]

Unaggregated series, in json with just start times: $day.outTemp.series(time_series='start').round(5).json:

[[1283497200, 8.24191], [1283499000, 7.14217], [1283500800, 6.17686], [1283502600, null], [1283504400, 4.71254], [1283506200, 4.23834], [1283508000, 3.94778], [1283509800, 3.8457], [1283511600, 3.93373], [1283513400, 4.21025], [1283515200, 4.67041], [1283517000, 5.30621], [1283518800, 6.10665], [1283520600, 7.05791], [1283522400, 8.14361], [1283524200, 9.34504], [1283526000, 10.64152], [1283527800, 12.01076], [1283529600, 13.4292], [1283531400, 14.87245], [1283533200, 16.31571], [1283535000, 17.73414]]

Unaggregated series, in json with start times in milliseconds: $day.outTemp.series(time_series='start', time_unit='unix_epoch_ms').round(5).json:

[[1283497200000, 8.24191], [1283499000000, 7.14217], [1283500800000, 6.17686], [1283502600000, null], [1283504400000, 4.71254], [1283506200000, 4.23834], [1283508000000, 3.94778], [1283509800000, 3.8457], [1283511600000, 3.93373], [1283513400000, 4.21025], [1283515200000, 4.67041], [1283517000000, 5.30621], [1283518800000, 6.10665], [1283520600000, 7.05791], [1283522400000, 8.14361], [1283524200000, 9.34504], [1283526000000, 10.64152], [1283527800000, 12.01076], [1283529600000, 13.4292], [1283531400000, 14.87245], [1283533200000, 16.31571], [1283535000000, 17.73414]]

Unaggregated series, in json, in degrees C, rounded to 5 decimal places: $day.outTemp.series.degree_C.round(5).json

[[1283497200, 1283499000, 8.24191], [1283499000, 1283500800, 7.14217], [1283500800, 1283502600, 6.17686], [1283502600, 1283504400, null], [1283504400, 1283506200, 4.71254], [1283506200, 1283508000, 4.23834], [1283508000, 1283509800, 3.94778], [1283509800, 1283511600, 3.8457], [1283511600, 1283513400, 3.93373], [1283513400, 1283515200, 4.21025], [1283515200, 1283517000, 4.67041], [1283517000, 1283518800, 5.30621], [1283518800, 1283520600, 6.10665], [1283520600, 1283522400, 7.05791], [1283522400, 1283524200, 8.14361], [1283524200, 1283526000, 9.34504], [1283526000, 1283527800, 10.64152], [1283527800, 1283529600, 12.01076], [1283529600, 1283531400, 13.4292], [1283531400, 1283533200, 14.87245], [1283533200, 1283535000, 16.31571], [1283535000, 1283536800, 17.73414]]

Unaggregated series, as a formatted string (not JSON) : $day.outTemp.series:

00:00, 00:30, 8.2°C
00:30, 01:00, 7.1°C
01:00, 01:30, 6.2°C
01:30, 02:00,    N/A
02:00, 02:30, 4.7°C
02:30, 03:00, 4.2°C
03:00, 03:30, 3.9°C
03:30, 04:00, 3.8°C
04:00, 04:30, 3.9°C
04:30, 05:00, 4.2°C
05:00, 05:30, 4.7°C
05:30, 06:00, 5.3°C
06:00, 06:30, 6.1°C
06:30, 07:00, 7.1°C
07:00, 07:30, 8.1°C
07:30, 08:00, 9.3°C
08:00, 08:30, 10.6°C
08:30, 09:00, 12.0°C
09:00, 09:30, 13.4°C
09:30, 10:00, 14.9°C
10:00, 10:30, 16.3°C
10:30, 11:00, 17.7°C

Unaggregated series, start time only, as a formatted string (not JSON) : $day.outTemp.series(time_series='start'):

00:00, 8.2°C
00:30, 7.1°C
01:00, 6.2°C
01:30,    N/A
02:00, 4.7°C
02:30, 4.2°C
03:00, 3.9°C
03:30, 3.8°C
04:00, 3.9°C
04:30, 4.2°C
05:00, 4.7°C
05:30, 5.3°C
06:00, 6.1°C
06:30, 7.1°C
07:00, 8.1°C
07:30, 9.3°C
08:00, 10.6°C
08:30, 12.0°C
09:00, 13.4°C
09:30, 14.9°C
10:00, 16.3°C
10:30, 17.7°C

Unaggregated series, stop time only, as a formatted string (not JSON) : $day.outTemp.series(time_series='stop'):

00:30, 8.2°C
01:00, 7.1°C
01:30, 6.2°C
02:00,    N/A
02:30, 4.7°C
03:00, 4.2°C
03:30, 3.9°C
04:00, 3.8°C
04:30, 3.9°C
05:00, 4.2°C
05:30, 4.7°C
06:00, 5.3°C
06:30, 6.1°C
07:00, 7.1°C
07:30, 8.1°C
08:00, 9.3°C
08:30, 10.6°C
09:00, 12.0°C
09:30, 13.4°C
10:00, 14.9°C
10:30, 16.3°C
11:00, 17.7°C

Unaggregated series, by column, as a formatted string (not JSON) $day.outTemp.series.format(order_by='column'):

00:00, 00:30, 01:00, 01:30, 02:00, 02:30, 03:00, 03:30, 04:00, 04:30, 05:00, 05:30, 06:00, 06:30, 07:00, 07:30, 08:00, 08:30, 09:00, 09:30, 10:00, 10:30
00:30, 01:00, 01:30, 02:00, 02:30, 03:00, 03:30, 04:00, 04:30, 05:00, 05:30, 06:00, 06:30, 07:00, 07:30, 08:00, 08:30, 09:00, 09:30, 10:00, 10:30, 11:00
8.2°C, 7.1°C, 6.2°C,    N/A, 4.7°C, 4.2°C, 3.9°C, 3.8°C, 3.9°C, 4.2°C, 4.7°C, 5.3°C, 6.1°C, 7.1°C, 8.1°C, 9.3°C, 10.6°C, 12.0°C, 13.4°C, 14.9°C, 16.3°C, 17.7°C

Unaggregated series, by column, start times only, as a formatted string (not JSON) $day.outTemp.series(time_series='start').format(order_by='column'):

00:00, 00:30, 01:00, 01:30, 02:00, 02:30, 03:00, 03:30, 04:00, 04:30, 05:00, 05:30, 06:00, 06:30, 07:00, 07:30, 08:00, 08:30, 09:00, 09:30, 10:00, 10:30
8.2°C, 7.1°C, 6.2°C,    N/A, 4.7°C, 4.2°C, 3.9°C, 3.8°C, 3.9°C, 4.2°C, 4.7°C, 5.3°C, 6.1°C, 7.1°C, 8.1°C, 9.3°C, 10.6°C, 12.0°C, 13.4°C, 14.9°C, 16.3°C, 17.7°C

Unaggregated series, by column, stop times only, as a formatted string (not JSON) $day.outTemp.series(time_series='stop').format(order_by='column'):

00:30, 01:00, 01:30, 02:00, 02:30, 03:00, 03:30, 04:00, 04:30, 05:00, 05:30, 06:00, 06:30, 07:00, 07:30, 08:00, 08:30, 09:00, 09:30, 10:00, 10:30, 11:00
8.2°C, 7.1°C, 6.2°C,    N/A, 4.7°C, 4.2°C, 3.9°C, 3.8°C, 3.9°C, 4.2°C, 4.7°C, 5.3°C, 6.1°C, 7.1°C, 8.1°C, 9.3°C, 10.6°C, 12.0°C, 13.4°C, 14.9°C, 16.3°C, 17.7°C

Aggregated series

Aggregated series: $month.outTemp.series(aggregate_type='max', aggregate_interval=86400).round(5).json():

[[1283324400, 1283410800, 26.5699], [1283410800, 1283497200, 26.23604], [1283497200, 1283583600, 17.73414]]

Using shortcut 'day': $month.outTemp.series(aggregate_type='max', aggregate_interval='day').round(5).json():

[[1283324400, 1283410800, 26.5699], [1283410800, 1283497200, 26.23604], [1283497200, 1283583600, 17.73414]]

Order by column: $month.outTemp.series(aggregate_type='max', aggregate_interval=86400).round(5).json(order_by="column"):

[[1283324400, 1283410800, 1283497200], [1283410800, 1283497200, 1283583600], [26.5699, 26.23604, 17.73414]]

Aggregated series, using $jsonize(): $jsonize($zip($min.start.unix_epoch_ms.raw, $min.data.degree_C.round(2).raw, $max.data.degree_C.round(2).raw))

    [[1283324400000, 4.51, 26.57], [1283410800000, 4.18, 26.24], [1283497200000, 3.85, 17.73]]
    

Aggregated series of wind vectors

Aggregated wind series (not JSON)), complex notation $month.windvec.series(aggregate_type='max', aggregate_interval='day')

01-Sep-2010 00:00, 02-Sep-2010 00:00, (-1, 15) kph
02-Sep-2010 00:00, 03-Sep-2010 00:00, (32, 2) kph
03-Sep-2010 00:00, 04-Sep-2010 00:00, (32, 0) kph

Aggregated wind series (not JSON)), complex notation with formatting $month.windvec.series(aggregate_type='max', aggregate_interval='day').format("%.5f")

01-Sep-2010 00:00, 02-Sep-2010 00:00, (-0.98372, 15.00868) kph
02-Sep-2010 00:00, 03-Sep-2010 00:00, (32.08358, 2.10287) kph
03-Sep-2010 00:00, 04-Sep-2010 00:00, (32.18688, 0.00000) kph

Aggregated wind series (not JSON), polar notation $month.windvec.series(aggregate_type='max', aggregate_interval='day').polar.format("%.5f")

01-Sep-2010 00:00, 02-Sep-2010 00:00, (15.04088 kph, 356°)
02-Sep-2010 00:00, 03-Sep-2010 00:00, (32.15242 kph, 086°)
03-Sep-2010 00:00, 04-Sep-2010 00:00, (32.18688 kph, 090°)

Aggregated series of wind vectors with conversions

Starting series: $month.windvec.series(aggregate_type='max', aggregate_interval='day').json()

    [[1283324400, 1283410800, [-0.9837205617579349, 15.0086754575505]], [1283410800, 1283497200, [32.08358153133061, 2.1028690330784316]], [1283497200, 1283583600, [32.18688, 0.0]]]
    

X-component: $month.windvec.series(aggregate_type='max', aggregate_interval='day').x.json()

    [[1283324400, 1283410800, -0.9837205617579349], [1283410800, 1283497200, 32.08358153133061], [1283497200, 1283583600, 32.18688]]
    

x-component, in knots: $month.windvec.series(aggregate_type='max', aggregate_interval='day').x.knot.json()

    [[1283324400, 1283410800, -0.5311666095721786], [1283410800, 1283497200, 17.32374811244712], [1283497200, 1283583600, 17.379524823344642]]
    

Y-component: $month.windvec.series(aggregate_type='max', aggregate_interval='day').y.json()

    [[1283324400, 1283410800, 15.0086754575505], [1283410800, 1283497200, 2.1028690330784316], [1283497200, 1283583600, 0.0]]
    

magnitude: $month.windvec.series(aggregate_type='max', aggregate_interval='day').magnitude.json()

    [[1283324400, 1283410800, 15.040879134336], [1283410800, 1283497200, 32.152422335616], [1283497200, 1283583600, 32.18688]]
    

direction: $month.windvec.series(aggregate_type='max', aggregate_interval='day').direction.json()

    [[1283324400, 1283410800, 356.25], [1283410800, 1283497200, 86.25], [1283497200, 1283583600, 90.0]]
    

polar: $month.windvec.series(aggregate_type='max', aggregate_interval='day').polar.json()

    [[1283324400, 1283410800, [15.040879134336, 356.25]], [1283410800, 1283497200, [32.152422335616, 86.25]], [1283497200, 1283583600, [32.18688, 90.0]]]
    

polar in knots: $month.windvec.series(aggregate_type='max', aggregate_interval='day').knot.polar.round(5).json()

    [[1283324400, 1283410800, [8.12143, 356.25]], [1283410800, 1283497200, [17.36092, 86.25]], [1283497200, 1283583600, [17.37952, 90.0]]]
    

Iterate over an aggregated series

    #for ($start, $stop, $data) in $month.outTemp.series(aggregate_type='max', aggregate_interval='day')
      ...
    #end for
  
Start date Stop date Max temperature
2010-09-01 2010-09-02 26.57°C
2010-09-02 2010-09-03 26.24°C
2010-09-03 2010-09-04 17.73°C