geometry-expression.ST_Intersects(geo2)

Tests if a geometry value spatially intersects another value. Two geometries intersect if they share one or more common points.

geometry-expression.ST_Intersects( geo2 ) = 1 is equivalent to geometry-expression.ST_Disjoint( geo2 ) = 0.

• ST_IntersectsRect method for type ST_Geometry
• ST_Disjoint method for type ST_Geometry
• ST_IntersectsFilter method for type ST_Geometry

The following example returns a result with one row for each shape that intersects the specified line.

SELECT ShapeID, "Description"
FROM SpatialShapes
WHERE NEW ST_LineString( 'LineString( 2 2, 4 4 )' ).ST_Intersects( Shape ) = 1
ORDER BY ShapeID

The example returns the following result set:

To visualize how the geometries in the SpatialShapes table intersect the line in the above example, execute the following query in the Interactive SQL Spatial Viewer.

SELECT Shape
FROM SpatialShapes
WHERE NEW ST_LineString( 'LineString( 2 2, 4 4 )' ).ST_Intersects( Shape ) = 1
UNION ALL SELECT NEW ST_LineString( 'LineString( 2 2, 4 4 )' )