GEOGRAPHY_AREA

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

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

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)");
SELECT name, ROUND(geography_area(shape), 0) AS sqm
FROM neighborhoods ORDER BY 2;
 
+----------------------+------------+
| name                 | sqm        |
+----------------------+------------+
| Axiom Township.      | 12293803823|
| Decentralized Park   | 12293803823|
| Elegant Island       | 12327632477|
| Probability Bay      | 12346439558|
| Hamilton.            | 12346439558|
+----------------------+------------+

For more information about working with geospatial data, see Working with Geospatial Features.

Last modified: February 23, 2023

Was this article helpful?