- 11 Functions and Operators
- 11.1 Operator and Function Reference
- 11.2 Operators
- 11.3 Control Flow Functions
- 11.4 String Functions
- 11.5 Numeric Functions
- 11.6 Date and Time Functions
- 11.7 What Calendar Is Used By MySQL?
- 11.8 Full-Text Search Functions
- 11.9 Cast Functions and Operators
- 11.10 Other Functions
- 11.11 Functions and Modifiers for Use with GROUP BY Clauses
- 11.12 Spatial Extensions
- 11.13 Precision Math
[+/-]
MySQL supports spatial extensions to allow the generation, storage,
and analysis of geographic features. Before MySQL 5.0.16, these
features are available for MyISAM tables only. As
of MySQL 5.0.16, InnoDB,
NDB, BDB, and
ARCHIVE also support spatial features.
For spatial columns, MyISAM supports both
SPATIAL and non-SPATIAL
indexes. Other storage engines support
non-SPATIAL indexes, as described in
Section 12.1.8, “CREATE INDEX Syntax”.
This chapter covers the following topics:
The basis of these spatial extensions in the OpenGIS geometry model
Data formats for representing spatial data
How to use spatial data in MySQL
Use of indexing for spatial data
MySQL differences from the OpenGIS specification
Additional Resources
The Open Geospatial Consortium publishes the OpenGIS® Simple Features Specifications For SQL, a document that proposes several conceptual ways for extending an SQL RDBMS to support spatial data. This specification is available from the OGC Web site at http://www.opengis.org/docs/99-049.pdf.
If you have questions or concerns about the use of the spatial extensions to MySQL, you can discuss them in the GIS forum: http://forums.mysql.com/list.php?23.
User Comments
Add your own comment.