SqlGeography.BufferWithTolerance Method (Double, Double, Boolean)

Applies To: SQL Server 2016 Preview

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

Namespace:   Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Syntax

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public SqlGeography BufferWithTolerance(
    double distance,
    double tolerance,
    bool relative
)

public:
[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
SqlGeography^ BufferWithTolerance(
    double distance,
    double tolerance,
    bool relative
)

[<SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)>]
member BufferWithTolerance : 
        distance:float *
        tolerance:float *
        relative:bool -> SqlGeography

<SqlMethodAttribute(IsDeterministic := True, IsPrecise := False)>
Public Function BufferWithTolerance (
    distance As Double,
    tolerance As Double,
    relative As Boolean
) As SqlGeography

Parameters

• distance
  Type: System.Double

  Is a double that specifies the distance from the SqlGeography instance around which to calculate the buffer.

• tolerance
  Type: System.Double

  Is a double that specifies the tolerance of the buffer distance.

  The tolerance value 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
  Type: System.Boolean

  Is a bool that specifies whether the tolerance value is relative or absolute. If true, then tolerance is relative and is calculated as the product of the tolerance parameter and the angular extent * equatorial radius of the ellipsoid. If false, tolerance is absolute and the tolerance value is the absolute maximum variation in the ideal buffer distance for the returned linear approximation.

Return Value

Type: Microsoft.SqlServer.Types.SqlGeography

A SqlGeography instance representing the union of all point values whose distance from a SqlGeography instance is less than or equal to a specified value.

Remarks

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

See Also

SqlGeography Class
Microsoft.SqlServer.Types Namespace

Return to top