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| +----------------------+------------+