MySQL Manual
11 Spatial Extensions in MySQL
- 11.4 Creating a Spatially Enabled MySQL Database
- 11.4.2 Creating Spatial Values
- 11.4.2.1 Creating Geometry Values Using WKT Functions
- 11.4.2.2 Creating Geometry Values Using WKB Functions
- 11.4.2.3 Creating Geometry Values Using MySQL-Specific Functions
11.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)), and return the corresponding geometry.
GeomFromWKT() 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.
GeomFromWKB(wkb[,srid])GeometryFromWKB(wkt[,srid])- Constructs a geometry value of any type using its WKB representation and SRID.
PointFromWKB(wkb[,srid])-
Constructs a
POINTvalue using its WKB representation and SRID. LineFromWKB(wkb[,srid])LineStringFromWKB(wkb[,srid])-
Constructs a
LINESTRINGvalue using its WKB representation and SRID. PolyFromWKB(wkb[,srid])PolygonFromWKB(wkb[,srid])-
Constructs a
POLYGONvalue using its WKB representation and SRID. MPointFromWKB(wkb[,srid])MultiPointFromWKB(wkb[,srid])-
Constructs a
MULTIPOINTvalue using its WKB representation and SRID. MLineFromWKB(wkb[,srid])MultiLineStringFromWKB(wkb[,srid])-
Constructs a
MULTILINESTRINGvalue using its WKB representation and SRID. MPolyFromWKB(wkb[,srid])MultiPolygonFromWKB(wkb[,srid])-
Constructs a
MULTIPOLYGONvalue using its WKB representation and SRID. GeomCollFromWKB(wkb[,srid])GeometryCollectionFromWKB(wkt[,srid])-
Constructs a
GEOMETRYCOLLECTIONvalue 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 yet implement these functions:
BdPolyFromWKB(wkb,srid)-
Constructs a
Polygonvalue from aMultiLineStringvalue in WKB format containing an arbitrary collection of closedLineStringvalues. BdMPolyFromWKB(wkb,srid)-
Constructs a
MultiPolygonvalue from aMultiLineStringvalue in WKB format containing an arbitrary collection of closedLineStringvalues.
