(mysql.info.gz) Functions to convert geometries between formats

Info Catalog

(mysql.info.gz) Analysing spatial information

(mysql.info.gz) Analysing spatial information

(mysql.info.gz) Geometry property functions

 
 18.5.1 Geometry Format Conversion Functions
 -------------------------------------------
 
 MySQL supports the following functions for converting geometry values
 between internal format and either WKT or WKB format:
 
 `AsBinary(G)'
      Converts a value in internal geometry format to its WKB
      representation and returns the binary result.
 
 `AsText(G)'
      Converts a value in internal geometry format to its WKT
      representation and returns the string result.
 
           mysql> SET @g = 'LineString(1 1,2 2,3 3)';
           mysql> SELECT AsText(GeomFromText(@g));
           +--------------------------+
           | AsText(GeomFromText(@G)) |
           +--------------------------+
           | LINESTRING(1 1,2 2,3 3)  |
           +--------------------------+
 
 `GeomFromText(WKT[,SRID])'
      Converts a string value from its WKT representation into internal
      geometry format and returns the result.  A number of type-specific
      functions are also supported, such as `PointFromText()' and
      `LineFromText()'; see  GIS WKT Functions.
 
 `GeomFromWKB(WKB[,SRID])'
      Converts a binary value from its WKB representation into internal
      geometry format and returns the result.  A number of type-specific
      functions are also supported, such as `PointFromWKB()' and
      `LineFromWKB()'; see  GIS WKB Functions.
 
 

Info Catalog

(mysql.info.gz) Analysing spatial information

(mysql.info.gz) Analysing spatial information

(mysql.info.gz) Geometry property functions