(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