(mysql.info.gz) GIS WKT Functions

(mysql.info.gz) Creating spatial values
 
 18.4.2.1 Creating Geometry Values Using WKT Functions
 .....................................................
 
 MySQL provides a number of functions that take as input parameters a
 Well-Known Text representation and, optionally, a spatial reference
 system identifier (SRID). They return the corresponding geometry.
 
 `GeomFromText()' accepts a WKT 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.
 
 `GeomCollFromText(WKT[,SRID])'
 `GeometryCollectionFromText(WKT[,SRID])'
      Constructs a `GEOMETRYCOLLECTION' value using its WKT
      representation and SRID.
 
 `GeomFromText(WKT[,SRID])'
 `GeometryFromText(WKT[,SRID])'
      Constructs a geometry value of any type using its WKT
      representation and SRID.
 
 `LineFromText(WKT[,SRID])'
 `LineStringFromText(WKT[,SRID])'
      Constructs a `LINESTRING' value using its WKT representation and
      SRID.
 
 `MLineFromText(WKT[,SRID])'
 `MultiLineStringFromText(WKT[,SRID])'
      Constructs a `MULTILINESTRING' value using its WKT representation
      and SRID.
 
 `MPointFromText(WKT[,SRID])'
 `MultiPointFromText(WKT[,SRID])'
      Constructs a `MULTIPOINT' value using its WKT representation and
      SRID.
 
 `MPolyFromText(WKT[,SRID])'
 `MultiPolygonFromText(WKT[,SRID])'
      Constructs a `MULTIPOLYGON' value using its WKT representation and
      SRID.
 
 `PointFromText(WKT[,SRID])'
      Constructs a `POINT' value using its WKT representation and SRID.
 
 `PolyFromText(WKT[,SRID])'
 `PolygonFromText(WKT[,SRID])'
      Constructs a `POLYGON' value using its WKT representation and SRID.
 
 
 The OpenGIS specification also describes optional functions for
 constructing `Polygon' or `MultiPolygon' values based on the WKT
 representation of a collection of rings or closed `LineString' values.
 These values may intersect.  MySQL does not implement these functions:
 
 `BdMPolyFromText(WKT,SRID)'
      Constructs a `MultiPolygon' value from a `MultiLineString' value
      in WKT format containing an arbitrary collection of closed
      `LineString' values.
 
 `BdPolyFromText(WKT,SRID)'
      Constructs a `Polygon' value from a `MultiLineString' value in WKT
      format containing an arbitrary collection of closed `LineString'
      values.
Info Catalog
(mysql.info.gz) Creating spatial values
(mysql.info.gz) GIS WKB Functions
automatically generated byinfo2html