MySQL provides a number of functions that take as input
parameters a BLOB containing a Well-Known
Binary representation and, optionally, a spatial reference
system identifier (SRID). They return the corresponding
geometry.
GeomFromWKB() accepts a WKB of any geometry
type as its first argument. An implementation also provides
type-specific construction functions for construction of
geometry values of each geometry type.
GeomCollFromWKB(,
wkb[,srid])GeometryCollectionFromWKB(
wkb[,srid])
Constructs a GEOMETRYCOLLECTION value
using its WKB representation and SRID.
GeomFromWKB(,
wkb[,srid])GeometryFromWKB(
wkb[,srid])
Constructs a geometry value of any type using its WKB representation and SRID.
LineFromWKB(,
wkb[,srid])LineStringFromWKB(
wkb[,srid])
Constructs a LINESTRING value using its
WKB representation and SRID.
MLineFromWKB(,
wkb[,srid])MultiLineStringFromWKB(
wkb[,srid])
Constructs a MULTILINESTRING value
using its WKB representation and SRID.
MPointFromWKB(,
wkb[,srid])MultiPointFromWKB(
wkb[,srid])
Constructs a MULTIPOINT value using its
WKB representation and SRID.
MPolyFromWKB(,
wkb[,srid])MultiPolygonFromWKB(
wkb[,srid])
Constructs a MULTIPOLYGON value using
its WKB representation and SRID.
Constructs a POINT value using its WKB
representation and SRID.
PolyFromWKB(,
wkb[,srid])PolygonFromWKB(
wkb[,srid])
Constructs a POLYGON value using its
WKB representation and SRID.
The OpenGIS specification also describes optional functions
for constructing Polygon or
MultiPolygon values based on the WKB
representation of a collection of rings or closed
LineString values. These values may
intersect. MySQL does not implement these functions:
Constructs a MultiPolygon value from a
MultiLineString value in WKB format
containing an arbitrary collection of closed
LineString values.
Constructs a Polygon value from a
MultiLineString value in WKB format
containing an arbitrary collection of closed
LineString values.