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	Returns an ST_MultiPolygon value built from the Well Known Text (WKT) representation of a multilinestring.
ST_BdMPolyFromWKB function	Returns an ST_MultiPolygon value built from the Well Known Binary (WKB) representation of a multilinestring.
ST_BdPolyFromText function	Returns an ST_Polygon value built from the Well Known Text (WKT) representation of a multilinestring.
ST_BdPolyFromWKB function	Returns an ST_Polygon value built from the Well Known Binary (WKB) representation of a multilinestring.
ST_CPolyFromText function	Returns an ST_CurvePolygon value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_CurvePolygon
ST_CPolyFromWKB function	Returns an ST_CurvePolygon value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_CurvePolygon
ST_CircularFromTxt function	Returns an ST_CircularString value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_CircularString
ST_CircularFromWKB function	Returns an ST_CircularString value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_CircularString
ST_CompoundFromTxt function	Returns an ST_CompoundCurve value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_CompoundCurve
ST_CompoundFromWKB function	Returns an ST_CompoundCurve value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_CompoundCurve
ST_GeomCollFromTxt function	Returns an ST_GeomCollection value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_GeomCollection
ST_GeomCollFromWKB function	Returns an ST_GeomCollection value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_GeomCollection
ST_GeomFromText function	Returns an ST_Geometry value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_Geometry
ST_GeomFromWKB function	Returns an ST_Geometry value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_Geometry
ST_LineFromText function	Returns an ST_LineString value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_LineString
ST_LineFromWKB function	Returns an ST_LineString value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_LineString
ST_MCurveFromText function	Returns an ST_MultiCurve value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_MultiCurve
ST_MCurveFromWKB function	Returns an ST_MultiCurve value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_MultiCurve
ST_MLineFromText function	Returns an ST_MultiLineString value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_MultiLineString
ST_MLineFromWKB function	Returns an ST_MultiLineString value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_MultiLineString
ST_MPointFromText function	Returns an ST_MultiPoint value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_MultiPoint
ST_MPointFromWKB function	Returns an ST_MultiPoint value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_MultiPoint
ST_MPolyFromText function	Returns an ST_MultiPolygon value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_MultiPolygon
ST_MPolyFromWKB function	Returns an ST_MultiPolygon value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_MultiPolygon
ST_MSurfaceFromTxt function	Returns an ST_MultiSurface value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_MultiSurface
ST_MSurfaceFromWKB function	Returns an ST_MultiSurface value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_MultiSurface
ST_OrderingEquals function	Tests if a geometry is identical to another geometry.
ST_PointFromText function	Returns an ST_Point value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_Point
ST_PointFromWKB function	Returns an ST_Point value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_Point
ST_PolyFromText function	Returns an ST_Polygon value, which is transformed from a LONG VARCHAR value containing the Well Known Text (WKT) representation of an ST_Polygon
ST_PolyFromWKB function	Returns an ST_Polygon value, which is transformed from a LONG BINARY value containing the Well Known Binary (WKB) representation of an ST_Polygon