(mysql.info.gz) GIS WKT Functions
Info Catalog
(mysql.info.gz) Creating spatial values
(mysql.info.gz) Creating spatial values
(mysql.info.gz) GIS WKB Functions
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) Creating spatial values
(mysql.info.gz) GIS WKB Functions
automatically generated byinfo2html