# BufferWithTolerance (geometry Data Type)

**Applies to:**
SQL Server
Azure SQL Database
Azure SQL Managed Instance

Returns a geometric object that represents the union of all point values whose distance from a **geometry** instance is less than or equal to a specified value, allowing for a specified tolerance.

## Syntax

```
.BufferWithTolerance ( distance, tolerance, relative )
```

Note

To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

## Arguments

*distance*

Is a **float** expression specifying the distance from the **geometry** instance around which to calculate the buffer.

*tolerance*

Is a **float** expression specifying the tolerance of the buffer distance.

*Tolerance* refers to the maximum variation in the ideal buffer distance for the returned linear approximation.

For example, the ideal buffer distance of a point is a circle, but this must be approximated by a polygon. The smaller the tolerance, the more points the polygon will have, which increases the complexity of the result, but decreases the error.

*relative*

Is a **bit** specifying whether the *tolerance* value is relative or absolute. If 'TRUE' or 1, then tolerance is relative and is calculated as the product of the *tolerance* parameter and the diameter of the bounding box of the instance. If 'FALSE' or 0, tolerance is absolute and the *tolerance* value is the absolute maximum variation in the ideal buffer distance for the returned linear approximation.

## Return Types

SQL Server return type: **geometry**

CLR return type: **SqlGeometry**

## Exceptions

The *tolerance* parameter must be greater than zero. If *tolerance* <= 0 then a `System.ArgumentOutOfRangeException`

is thrown.

Note

Since *tolerance* is a **float** type, a `System.Runtime.InteropServices.COMException`

can be thrown if the value given for tolerance is very small because of the rounding issues with floating point types.

## Remarks

When *distance* > 0 then either a **Polygon** or **MultiPolygon** instance is returned.

Note

Since distance is a **float**, an extremely small value can equate to zero in the calculations. When this occurs, a copy of the calling **geometry** instance is returned. See float and real (Transact-SQL).

When *distance* = 0 then a copy of the calling **geometry** instance is returned.

When *distance* < 0 then

An empty

**GeometryCollection**instance is returned when the dimensions of the instance are 0 or 1.A negative buffer is returned when the dimensions of the instance are 2 or more.

Note

A negative buffer may also create an empty

**GeometryCollection**instance.

A negative buffer removes all points within the given distance of the boundary of the **geometry** instance.

The error between the theoretical and computed buffer is max(tolerance, extents * 1.E-7) where tolerance is the value of the *tolerance* parameter. For more information on extents, see geometry Data Type Method Reference.

## Examples

The following example creates a `Point`

instance and uses `BufferWithTolerance()`

to obtain a rough buffer around it.

```
DECLARE @g geometry;
SET @g = geometry::STGeomFromText('POINT(3 3)', 0);
SELECT @g.BufferWithTolerance(1, .5, 0).ToString();
```

## See Also

STBuffer (geometry Data Type)

Extended Methods on Geometry Instances

## Feedback

https://aka.ms/ContentUserFeedback.

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for