GEOGRAPHY_
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