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
SELECT name, ROUND(geography_area(shape), 0) AS sqm
-> FROM neighborhoods ORDER BY 2;
+----------------------+---------+
| name | sqm |
+----------------------+---------+
| Probability Bay | 584004 |
| Axiom Township | 2122520 |
| Decentralized Park | 2538930 |
| Isle Zero | 2729536 |
| Elegant Island | 3037299 |
| Little Endian | 3432952 |
| Big Endian | 5006800 |
...