Skip to main content

SingleStoreDB v8.0

GEOGRAPHY_AREA

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

Image of a geographic area

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|
+----------------------+------------+
In this section: