| |
18.4.2.2. Creating Geometry Values Using WKB Functions
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.
-
PointFromWKB(wkb[,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:
-
BdMPolyFromWKB(wkb,srid)
Constructs a MultiPolygon value from a
MultiLineString value in WKB format
containing an arbitrary collection of closed
LineString values.
-
BdPolyFromWKB(wkb,srid)
Constructs a Polygon value from a
MultiLineString value in WKB format
containing an arbitrary collection of closed
LineString values.
|
|
