ST_Buffer¶

Introduction: Return the geodesic buffer of a geography. The distance is always interpreted as meters on the spheroid. The result is a polygon approximating the buffer.

ST_Buffer of a Geography point: a geodesic buffer on the sphere

Format:

ST_Buffer (geog: Geography, distanceMeters: Double)

ST_Buffer (geog: Geography, distanceMeters: Double, parameters: String)

Return type: Geography

Since: v1.9.1

Geography is always spheroidal, so the boolean useSpheroid argument accepted by the geometry ST_Buffer is not supported for geography inputs: ST_Buffer(geog, distance, useSpheroid) throws a clear error. Use ST_Buffer(geog, distance) or ST_Buffer(geog, distance, parameters) instead.

SQL Example:

SELECT ST_Buffer(ST_GeogFromWKT('POINT (10 10)', 4326), 100000)

Output:

POLYGON ((10.9 10.2, 10.8 10.3, 10.8 10.5, 10.6 10.6, ...))