15.10 - ST_Intersection - Teradata Database

Teradata Database SQL Geospatial Types

Teradata Database
Programming Reference

Returns an ST_Geometry type where the value represents the point set intersection of two ST_Geometry values.


Argument …

Specifies …


the other ST_Geometry value.

The type that the ST_Geometry return value represents is one from the possible set of types in the following table, depending on the argument types.


Teradata Database converts GeoSequence types that are involved in the ST_Intersection method to ST_LineString values. Therefore, ST_Intersection never returns a GeoSequence type.

All ST_Geometry types, including GeoSequence, but not the ST_GeomCollection type.

Note: This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations. Consequently, any z coordinates returned by this method should be ignored. Teradata recommends using the Make_2D method to strip out the z coordinates of the return value.

INSERT INTO sample_shapes
SELECT skey, new ST_Geometry(
 'LINESTRING (2 2,3 2,4 1)').ST_Intersection(streetShape)
FROM sample_streets
WHERE new ST_Geometry(
 'MultiPoint((2 2),(3 2))').ST_Intersects(streetShape) = 1;