GEOGRAPHY_ LENGTH
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
This function measures the length of a path or the total perimeter of a polygon, in meters.

Syntax
GEOGRAPHY_LENGTH ( geo )
Arguments
-
geo: any valid geospatial object or WKT string: path, point or polygon.
Return Type
Double.
Examples
SELECT ROUND(geography_length(shape), 0) AS perimeter FROM neighborhoods;
+-----------+
| perimeter |
+-----------+
| 8558 |
| 9188 |
| 4831 |
| 11990 |
| 9455 |
| 7886 |
| 6418 |
| 8580 |
| 7983 |
+-----------+
Related Topics
For more information about working with geospatial data, see Working with Geospatial Features.
Last modified: February 24, 2023