Below is a list of NTS members translated into SQL and the Teradata SQL function into which they are translated by the NTS support package.
NetTopologySuite Member | Teradata SQL Function | Supported |
---|---|---|
Geometry.Area | ST_Area | Yes |
Geometry.AsBinary() | ST_AsBinary | Yes |
Geometry.AsText() | ST_AsText | Yes |
Geometry.Boundary | ST_Boundary | Yes |
Geometry.Buffer(double) | ST_Buffer | Yes |
Geometry.Buffer(double, int) | No | |
Geometry.Centroid | ST_Centroid | Yes |
Geometry.Contains(Geometry) | ST_Contains | Yes |
Geometry.ConvexHull() | ST_ConvexHull | Yes |
Geometry.CoveredBy(Geometry) | No | |
Geometry.Covers(Geometry) | No | |
Geometry.Crosses(Geometry) | ST_Crosses | Yes |
Geometry.Difference(Geometry) | ST_Difference | Yes |
Geometry.Dimension | ST_Dimension | Yes |
Geometry.Disjoint(Geometry) | ST_Disjoint | Yes |
Geometry.Distance(Geometry) | ST_Distance | Yes |
Geometry.Envelope | ST_Envelope | Yes |
Geometry.EqualsExact(Geometry) | No | |
Geometry.EqualsTopologically(Geometry) | ST_Equals | Yes |
Geometry.GeometryType | ST_GeometryType | Yes (see note 1) |
Geometry.GetGeometryN(int) | ST_GeometryN | Yes |
Geometry.InteriorPoint | ST_PointOnSurface | Yes |
Geometry.Intersection(Geometry) | ST_Intersection | Yes |
Geometry.Intersects(Geometry) | ST_Intersects | Yes |
Geometry.IsEmpty | ST_IsEmpty | Yes |
Geometry.IsSimple | ST_IsSimple | Yes |
Geometry.IsValid | ST_IsValid | Yes |
Geometry.IsWithinDistance(Geometry, double) | ST_Distance | Yes |
Geometry.Length | ST_Length | Yes |
Geometry.NumGeometries | ST_NumGeometries | Yes |
Geometry.NumPoints | ST_NumPoints | Yes |
Geometry.OgcGeometryType | ST_GeometryType | Yes (see note 2) |
Geometry.Overlaps(Geometry) | ST_Overlaps | Yes |
Geometry.PointOnSurface | ST_PointOnSurface | Yes |
Geometry.Relate(Geometry, string) | ST_Relate | Yes |
Geometry.Reverse() | No | |
Geometry.SRID | ST_SRID | Yes |
Geometry.SymmetricDifference(Geometry) | ST_SymDifference | Yes |
Geometry.ToBinary() | ST_AsBinary | Yes |
Geometry.ToText() | ST_AsText | Yes |
Geometry.Touches(Geometry) | ST_Touches | Yes |
Geometry.Union() | No | |
Geometry.Union(Geometry) | ST_Union | Yes |
Geometry.Within(Geometry) | ST_Within | Yes |
GeometryCollection.Count | ST_NumGeometries | Yes |
GeometryCollection[int] | ST_GeometryN | Yes |
LineString.Count | ST_NumPoints | Yes |
LineString.EndPoint | ST_EndPoint | Yes |
LineString.GetPointN(int) | ST_PointN | Yes |
LineString.IsClosed | ST_IsClosed | Yes |
LineString.IsRing | ST_IsRing | Yes |
LineString.StartPoint | ST_StartPoint | Yes |
MultiLineString.IsClosed | ST_IsClosed | Yes |
Point.M | No | |
Point.X | ST_X | Yes |
Point.Y | ST_Y | Yes |
Point.Z | CASE point.ST_Is3D() WHEN 1 THEN point.ST_Z() END | Yes (see note 3) |
Polygon.ExteriorRing | ST_ExteriorRing | Yes |
Polygon.GetInteriorRingN(int) | ST_InteriorRingN | Yes |
Polygon.NumInteriorRings | ST_NumInteriorRings | Yes |
The result of the ST_GeometryType function call is cast into the expected string (i.e. "Point", "LineString", etc).
The result of the ST_GeometryType function call is cast into the expected OgcGeometryType integer.
If the input geometry is a non-point or a 2D point, Teradata SQL Engine returns an error from ST_Z() function. The translated SQL avoids this by relying on ST_Is3D().