geometry-expression.ST_IntersectsRect(pmin,pmax)

The ST_IntersectsRect method tests if a geometry intersects with a specified axis-aligned bounding rectangle.

The method is equivalent to the following: geometry-expression.ST_Intersects( NEW ST_Polygon( pmin, pmax ) )

Therefore, this method can be useful for writing window queries to find all geometries that intersect a given axis-aligned rectangle.

• ST_Intersects method for type ST_Geometry
• ST_IntersectsFilter method for type ST_Geometry

The following example lists the ShapeIDs where the rectangle specified by the envelope of the two points intersects the corresponding Shape geometry. This example returns the result 3,5,6,18.

SELECT LIST( ShapeID ORDER BY ShapeID )
FROM SpatialShapes
WHERE Shape.ST_IntersectsRect( NEW ST_Point( 0, 4 ), NEW ST_Point( 2, 5 ) ) = 1

The following example tests if a linestring intersects a rectangle. The provided linestring does not intersect the rectangle identified by the two points (even though the envelope of the linestring does intersect the envelope of the two points).

SELECT NEW ST_LineString( 'LineString( 0 0, 10 0, 10 10 )' )
		.ST_IntersectsRect( NEW ST_Point( 4, 4 ) , NEW ST_Point( 6, 6 ) )