(mysql.info) spatial-extensions

 
 16 Spatial Extensions
 *********************

 
* gis-introduction             Introduction to MySQL Spatial Support
* opengis-geometry-model       The OpenGIS Geometry Model
* supported-spatial-data-formats  Supported Spatial Data Formats
* creating-a-spatially-enabled-mysql-database  Creating a Spatially Enabled MySQL Database
* analysing-spatial-information  Analyzing Spatial Information
* optimizing-spatial-analysis  Optimizing Spatial Analysis
* mysql-gis-conformance-and-compatibility  MySQL Conformance and Compatibility
 
 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. (However,
 the `ARCHIVE' engine does not support indexing, so spatial columns in
 `ARCHIVE' columns cannot be indexed. MySQL Cluster also does not
 support indexing of spatial columns.)
 
 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(R) 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'.

Info Catalog

(mysql.info) ndbcluster

(mysql.info) Top

(mysql.info) stored-procedures

automatically generated byinfo2html

(mysql.info) spatial-extensions

Menu