docs-v2/content/flux/v0.x/stdlib/experimental/geo/astracks.md

title	description	aliases	menu	weight	flux/v0.x/tags	related	introduced
geo.asTracks() function	The geo.asTracks() function groups rows into tracks (sequential, related data points).	/influxdb/v2.0/reference/flux/stdlib/experimental/geo/astracks/ /influxdb/cloud/reference/flux/stdlib/experimental/geo/astracks/	flux_0_x_ref name parent geo.asTracks geo	401	transformations geotemporal geo	/{{< latest "influxdb" >}}/query-data/flux/geo/	0.63.0

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

import "experimental/geo"

geo.asTracks(
    groupBy: ["id","tid"],
    orderBy: ["_time"],
)

Parameters

groupBy

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

orderBy

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

tables

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

Examples

Group tracks in a box-shaped region

region = {minLat: 40.51757813, maxLat: 40.86914063, minLon: -73.65234375, maxLon: -72.94921875}

from(bucket: "example-bucket")
    |> range(start: -1h)
    |> filter(fn: (r) => r._measurement == "example-measurement")
    |> geo.gridFilter(region: region)
    |> geo.toRows(correlationKey: ["_time", "id"])
    |> geo.asTracks()