Spatial operations

data-types
#tsql#data-types

Description

Reduce (geometry Data Type)

Returns a simplified approximation of a geometry instance

produced by running the Douglas-Peucker algorithm with the

specified tolerance.

CurveToLineWithTolerance

(geometry Data Type)

Returns a polygonal approximation of a geometry instance

containing circular arc segments, with explicit tolerance control.

These methods perform advanced spatial relationship queries.

Description

ShortestLineTo (geography

Data Type)

Returns a LineString instance with two points representing the shortest

distance between the two geometry instances.

These methods provide detailed validity checking and type information.

Description

IsValidDetailed (geometry

DataType)

Returns a message that helps identify problems with an invalid

geometry instance.

MakeValid (geometry Data Type)

Converts an invalid geometry instance into a valid instance with a valid

OGC type.

InstanceOf (geometry Data

Type)

Returns 1 if a geometry instance is of the specified type.

IsNull (geometry Data Type)

Returns 1 if a geometry instance is null.

These methods perform spatial operations with enhanced capabilities.

Expand table

Expand table

Expand table

Method

Method