(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
automatically generated byinfo2html