15.10 - ST_Overlaps - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Tests if an ST_Geometry value spatially overlaps another ST_Geometry value.

 

Argument …

Specifies …

ageometry

the other ST_Geometry value.

Returns an INTEGER value:

  • 1, if the geometries overlap
  • 0, if the geometries do not overlap
  • ST_Overlaps is valid on all ST_Geometry types, with the exception of geometry collections.

    Note: This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations.

    Use of a geospatial index can greatly improve the performance of queries that use this method.

       SELECT cityName
       FROM sample_cities
       WHERE cityShape.ST_Overlaps(
          NEW ST_Geometry('POLYGON((1 1, 1 3, 6 3, 6 0, 1 1))')) = 1;