Export (0) Print
Expand All
Expand Minimize

STIntersection (geometry Data Type)

Returns an object representing the points where a geometry instance intersects another geometry instance.

.STIntersection (other_geometry)


Is another geometry instance to compare with the instance on which STIntersection() is being invoked, to determine where they intersect.

SQL Server return type: geometry

CLR return type: SqlGeometry

STIntersection() always returns null if the spatial reference IDs (SRIDs) of the geometry instances do not match.

The following example uses STIntersection() to compute the intersection of two polygons.

DECLARE @g geometry;
DECLARE @h geometry;
SET @g = geometry::STGeomFromText('POLYGON((0 0, 0 2, 2 2, 2 0, 0 0))', 0);
SET @h = geometry::STGeomFromText('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))', 0);
SELECT @g.STIntersection(@h).ToString();
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft