Spatial compatibility functions

The SQL/MM standard defines a number of functions that can be used to perform spatial operations. In most cases, these functions duplicate functionality of methods or constructors of spatial data types.

Functions

Name	Description
ST_BdMPolyFromText function [Spatial]	Returns an ST_MultiPolygon value built from the WKT representation of a multilinestring.
ST_BdMPolyFromWKB function [Spatial]	Returns an ST_MultiPolygon value built from the WKB representation of a multilinestring.
ST_BdPolyFromText function [Spatial]	Returns an ST_Polygon value built from the WKT representation of a multilinestring.
ST_BdPolyFromWKB function [Spatial]	Returns an ST_Polygon value built from the WKB representation of a multilinestring.
ST_CPolyFromText function [Spatial]	Returns an ST_CurvePolygon value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_CurvePolygon
ST_CPolyFromWKB function [Spatial]	Returns an ST_CurvePolygon value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_CurvePolygon
ST_CircularFromTxt function [Spatial]	Returns an ST_CircularString value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_CircularString
ST_CircularFromWKB function [Spatial]	Returns an ST_CircularString value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_CircularString
ST_CompoundFromTxt function [Spatial]	Returns an ST_CompoundCurve value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_CompoundCurve
ST_CompoundFromWKB function [Spatial]	Returns an ST_CompoundCurve value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_CompoundCurve
ST_GeomCollFromTxt function [Spatial]	Returns an ST_GeomCollection value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_GeomCollection
ST_GeomCollFromWKB function [Spatial]	Returns an ST_GeomCollection value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_GeomCollection
ST_GeomFromText function [Spatial]	Returns an ST_Geometry value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_Geometry
ST_GeomFromWKB function [Spatial]	Returns an ST_Geometry value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_Geometry
ST_LineFromText function [Spatial]	Returns an ST_LineString value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_LineString
ST_LineFromWKB function [Spatial]	Returns an ST_LineString value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_LineString
ST_MCurveFromText function [Spatial]	Returns an ST_MultiCurve value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_MultiCurve
ST_MCurveFromWKB function [Spatial]	Returns an ST_MultiCurve value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_MultiCurve
ST_MLineFromText function [Spatial]	Returns an ST_MultiLineString value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_MultiLineString
ST_MLineFromWKB function [Spatial]	Returns an ST_MultiLineString value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_MultiLineString
ST_MPointFromText function [Spatial]	Returns an ST_MultiPoint value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_MultiPoint
ST_MPointFromWKB function [Spatial]	Returns an ST_MultiPoint value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_MultiPoint
ST_MPolyFromText function [Spatial]	Returns an ST_MultiPolygon value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_MultiPolygon
ST_MPolyFromWKB function [Spatial]	Returns an ST_MultiPolygon value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_MultiPolygon
ST_MSurfaceFromTxt function [Spatial]	Returns an ST_MultiSurface value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_MultiSurface
ST_MSurfaceFromWKB function [Spatial]	Returns an ST_MultiSurface value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_MultiSurface
ST_OrderingEquals function [Spatial]	Tests if a geometry is identical to another geometry.
ST_PointFromText function [Spatial]	Returns an ST_Point value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_Point
ST_PointFromWKB function [Spatial]	Returns an ST_Point value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_Point
ST_PolyFromText function [Spatial]	Returns an ST_Polygon value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_Polygon
ST_PolyFromWKB function [Spatial]	Returns an ST_Polygon value, which is transformed from a LONG BINARY value containing the WKB representation of an ST_Polygon

Discuss this page in DocCommentXchange.