# GEOGRAPHY\_AREA

This function measures the square meter area of a given polygon.

![Image of a geographic area](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blte15e9c7c34a199ad/6a2c42a1107c22c21677579e/area-3XsXa8.png)

## Syntax

```
GEOGRAPHY_AREA ( polygon )

```

## Arguments

* polygon: any valid geospatial object or WKT string.

> **❗ Important**: If an argument is a point or line, the area is zero.

## Return Type

A double. The measured area, in meters.

## Examples

```sql
CREATE ROWSTORE TABLE neighborhoods (
  id INT UNSIGNED NOT NULL PRIMARY KEY,
  name VARCHAR(64) NOT NULL,
  population INT UNSIGNED NOT NULL,
  shape GEOGRAPHY NOT NULL,
  centroid GEOGRAPHYPOINT NOT NULL,
  index (shape) WITH (resolution = 8),
  index (centroid)
  );

  INSERT INTO neighborhoods VALUES
  (1, "Hamilton", 12346, "POLYGON((1 1,2 1,2 2, 1 2, 1 1))","POINT(1.5 1.5)"),
  (2, "Probability Bay", 263951, "POLYGON((5 1,6 1,6 2,5 2,5 1))", "POINT(5.5 1.5)"),
  (3, "Decentralized Park", 29265, "POLYGON((5 5,6 5,6 6,5 6,5 5))", "POINT(5.5 5.5)"),
  (4, "Axiom Township", 845696, "POLYGON((1 5,2 5,2 6,1 6,1 5))", "POINT(1.5 5.5)"),
  (5, "Elegant Island ", 987654, "POLYGON((3 3,4 3,4 4,3 4,3 3))", "POINT(3.5 3.5)");
```

```sql
SELECT name, ROUND(geography_area(shape), 0) AS sqm
  FROM neighborhoods ORDER BY 2;

```

```output
 
+----------------------+------------+
| name                 | sqm        |
+----------------------+------------+
| Axiom Township.      | 12293803823|
| Decentralized Park   | 12293803823|
| Elegant Island       | 12327632477|
| Probability Bay      | 12346439558|
| Hamilton.            | 12346439558|
+----------------------+------------+
```

## Related Topics

For more information about working with geospatial data, see [Working with Geospatial Features](https://docs.singlestore.com/db/v9.1/developer-resources/functional-extensions/working-with-geospatial-features.md).

***

Modified at: February 23, 2023

Source: [/db/v9.1/reference/sql-reference/geospatial-functions/geography-area/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/geospatial-functions/geography-area/)

(An index of the documentation is available at /llms.txt)