(mysql.info.gz) GIS MySQL-Specific Functions

Info Catalog

(mysql.info.gz) GIS WKB Functions

(mysql.info.gz) Creating spatial values

 
 18.4.2.3 Creating Geometry Values Using MySQL-Specific Functions
 ................................................................
 
 * MySQL does not implement the functions listed in this section.
 
 MySQL provides a set of useful functions for creating geometry WKB
 representations. The functions described in this section are MySQL
 extensions to the OpenGIS specifications. The results of these
 functions are `BLOB' values containing WKB representations of geometry
 values with no SRID.  The results of these functions can be substituted
 as the first argument for any function in the `GeomFromWKB()' function
 family.
 
 `GeometryCollection(G1,G2,...)'
      Constructs a WKB `GeometryCollection'. If any argument is not a
      well-formed WKB representation of a geometry, the return value is
      `NULL'.
 
 `LineString(PT1,PT2,...)'
      Constructs a WKB `LineString' value from a number of WKB `Point'
      arguments.  If any argument is not a WKB `Point', the return value
      is `NULL'.  If the number of `Point' arguments is less than two,
      the return value is `NULL'.
 
 `MultiLineString(LS1,LS2,...)'
      Constructs a WKB `MultiLineString' value using WKB `LineString'
      arguments.  If any argument is not a WKB `LineString', the return
      value is `NULL'.
 
 `MultiPoint(PT1,PT2,...)'
      Constructs a WKB `MultiPoint' value using WKB `Point' arguments.
      If any argument is not a WKB `Point', the return value is `NULL'.
 
 `MultiPolygon(POLY1,POLY2,...)'
      Constructs a WKB `MultiPolygon' value from a set of WKB `Polygon'
      arguments.  If any argument is not a WKB `Polygon', the return
      value is `NULL'.
 
 `Point(X,Y)'
      Constructs a WKB `Point' using its coordinates.
 
 `Polygon(LS1,LS2,...)'
      Constructs a WKB `Polygon' value from a number of WKB `LineString'
      arguments. If any argument does not represent the WKB of a
      `LinearRing' (that is, not a closed and simple `LineString') the
      return value is `NULL'.
 
 

Info Catalog

(mysql.info.gz) GIS WKB Functions

(mysql.info.gz) Creating spatial values