GEOGRAPHY_ LENGTH
On this page
This function measures the length of a path or the total perimeter of a polygon, in meters.
![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt578314adc7f67309/66a3cf98a52bd5500021c2fd/length-vi8Q4Y.png?width=850&disable=upscale&auto=webp)
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