ST_Intersects( ST_Geometry ) method

Syntax

geometry-expression.ST_Intersects( ST_Geometry geo2)

Parameters

• geo2 – The other geometry value that is to be compared to the geometry-expression.

Returns

BIT Returns 1 if the geometry-expression spatially intersects with geo2, otherwise 0.

Examples

• Example 1 – 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:

  ShapeID	Description
  2	Square
  3	Rectangle
  5	L shape line
  18	CircularString
  22	Triangle

  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 )' )

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.27