---
title: geo.groupByArea() function
description: >
  The geo.groupByArea() function groups rows by geographic area.
aliases:
  - /influxdb/v2.0/reference/flux/stdlib/experimental/geo/groupbyarea/
  - /influxdb/cloud/reference/flux/stdlib/experimental/geo/groupbyarea/
menu:
  flux_0_x_ref:
    name: geo.groupByArea
    parent: geo
weight: 401
flux/v0.x/tags: [transformations, geotemporal, geo]
related:
  - /{{< latest "influxdb" >}}/query-data/flux/geo/
introduced: 0.63.0
---

The `geo.groupByArea()` function groups rows by geographic area.
Area sizes are determined by the specified [`level`](#level).
Each geographic area is assigned a unique identifier which is stored in the [`newColumn`](#newcolumn).
Results are grouped by `newColumn`.

```js
import "experimental/geo"

geo.groupByArea(
    newColumn: "geoArea",
    level: 3,
    s2cellIDLevel: -1,
)
```

## Parameters

### newColumn {data-type="string"}
Name of the new column that stores the unique identifier for a geographic area.

### level {data-type="int"}
[S2 Cell level](https://s2geometry.io/resources/s2cell_statistics.html) used
to determine the size of each geographic area.

### s2cellIDLevel {data-type="int"}
[S2 Cell level](https://s2geometry.io/resources/s2cell_statistics.html) used in `s2_cell_id` tag.
Default is `-1`.

{{% note %}}
When set to `-1`, `geo.groupByArea()` attempts to automatically detect the S2 Cell ID level.
{{% /note %}}

### tables {data-type="stream of tables"}
Input data.
Default is piped-forward data ([`<-`](/flux/v0.x/spec/expressions/#pipe-expressions)).

## Examples
```js
import "experimental/geo"

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()
    |> geo.groupByArea(newColumn: "geoArea", level: 3)
```