geo.asTracks() function

geo.asTracks() groups rows into tracks (sequential, related data points).

Function type signature

(<-tables: stream[A], ?groupBy: [string], ?orderBy: [string]) => stream[A] where A: Record

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

groupBy

Columns to group by. These columns should uniquely identify each track. Default is ["id","tid"].

orderBy

Columns to order results by. Default is ["_time"].

Sort precedence is determined by list order (left to right).

tables

Input data. Default is piped-forward data (<-).

Examples

• Group geotemporal data into tracks
• Group geotemporal data into tracks and sort by specified columns

Group geotemporal data into tracks

import "experimental/geo"

data
    |> geo.asTracks()

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

Input data

Output data

{{% /expand %}} {{< /expand-wrapper >}}

Group geotemporal data into tracks and sort by specified columns

import "experimental/geo"

data
    |> geo.asTracks(orderBy: ["lat", "lon"])

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

Input data

Output data

{{% /expand %}} {{< /expand-wrapper >}}