Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
GEOGRAPHY_
On this page
The GEOGRAPHY_ 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.
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 sqmFROM neighborhoods ORDER BY 2;
+----------------------+------------+
| 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.
Last modified: