Validity tests
statements #tsql#statements
Description
STBuffer
Returns a geometry object representing all points within a specified distance from a
geometry instance.
STDifference
Returns a geometry representing the point set from one instance that doesn’t lie
within another instance.
STIntersection
Returns a geometry representing the points where two geometry instances intersect.
STSymDifference
Returns a geometry representing the points in either of two instances but not in both
(symmetric difference).
STUnion
Returns a geometry representing the union (all points) of two geometry instances.
These methods test the validity and properties of geometry instances.
Description
STIsClosed
Returns 1 if the start and end points of a geometry instance are the same.
STIsEmpty
Returns 1 if a geometry instance is empty.
STIsRing
Returns 1 if a geometry instance is closed and simple (doesn’t intersect itself).
STIsSimple
Returns 1 if a geometry instance is simple (doesn’t intersect itself).
STIsValid
Returns 1 if a geometry instance is well-formed according to its OGC type.
Extended Methods on Geometry Instances
OGC Static Geometry Methods
Extended Static Geometry Methods
Spatial Data Types Overview
Create, Construct, and Query geometry Instances
）
Note:
The author created this article with assistance from AI.
Learn more
Expand table
Expand table