Group geo-temporal data

    For example results, use the bird migration sample data to populate the sampleGeoData variable in the queries below.

    • Specify the to use when calculating geographic areas with the level parameter.

    The following example uses the sample bird migration data to query data points within 200km of Cairo, Egypt and group them by geographic area:

    Group data by track or route

    • Specify columns that uniquely identify each track or route with the groupBy parameter.
    • Specify which columns to sort by with the sortBy parameter. Default is ["_time"].

    The following example uses the sample bird migration data to query data points within 200km of Cairo, Egypt and group them into routes unique to each bird:

    1. |> geo.filterRows(region: {lat: 30.04, lon: 31.23, radius: 200.0})
    2. |> geo.asTracks(groupBy: ["id"], orderBy: ["_time"])