- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 Replication
- 15 MySQL Cluster
- 16 Spatial Extensions
- 17 Connectors and APIs
- 18 Extending MySQL
- A Errors, Error Codes, and Common Problems
- B MySQL Change History
- C Restrictions and Limits
- Index
Table of Contents [+/-]
- 16.1. Introduction to MySQL Spatial Support
- 16.2. The OpenGIS Geometry Model [+/-]
- 16.2.1. The Geometry Class Hierarchy
- 16.2.2. Class
Geometry - 16.2.3. Class
Point - 16.2.4. Class
Curve - 16.2.5. Class
LineString - 16.2.6. Class
Surface - 16.2.7. Class
Polygon - 16.2.8. Class
GeometryCollection - 16.2.9. Class
MultiPoint - 16.2.10. Class
MultiCurve - 16.2.11. Class
MultiLineString - 16.2.12. Class
MultiSurface - 16.2.13. Class
MultiPolygon
- 16.3. Supported Spatial Data Formats [+/-]
- 16.4. Creating a Spatially Enabled MySQL Database [+/-]
- 16.5. Analyzing Spatial Information [+/-]
- 16.5.1. Geometry Format Conversion Functions
- 16.5.2.
GeometryFunctions - 16.5.3. Functions That Create New Geometries from Existing Ones
- 16.5.4. Functions for Testing Spatial Relations Between Geometric Objects
- 16.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)
- 16.5.6. Functions That Test Spatial Relationships Between Geometries
- 16.6. Optimizing Spatial Analysis [+/-]
- 16.7. MySQL Conformance and Compatibility
MySQL 4.1 introduces spatial extensions to allow the generation,
storage, and analysis of geographic features. Currently, these
features are available for MyISAM tables only.
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.