(mysql.info.gz) GIS WKB Functions
Info Catalog
(mysql.info.gz) GIS WKT Functions
(mysql.info.gz) Creating spatial values
(mysql.info.gz) GIS MySQL-Specific Functions
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.
`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.
`GeomCollFromWKB(WKB[,SRID])'
`GeometryCollectionFromWKB(WKT[,SRID])'
Constructs a `GEOMETRYCOLLECTION' value using its WKB
representation and SRID.
`GeomFromWKB(WKB[,SRID])'
`GeometryFromWKB(WKT[,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.
Info Catalog
(mysql.info.gz) GIS WKT Functions
(mysql.info.gz) Creating spatial values
(mysql.info.gz) GIS MySQL-Specific Functions
automatically generated byinfo2html