MySQL Manual- 1 General Information
- 1.1 About This Manual
- 1.2 What Is MySQL?
- 1.3 What Is MySQL AB?
- 1.4 MySQL Support and Licensing
- 1.5 MySQL 4.0 In A Nutshell
- 1.6 MySQL 4.1 In A Nutshell
- 1.7 MySQL Information Sources
- 1.8 How Standards-compatible Is MySQL?
- 1.9 MySQL and The Future (The TODO)
- 1.10 How MySQL Compares to Other Databases
- 2 MySQL Installation
- 3 Tutorial Introduction
- 4 Database Administration
- 5 MySQL Optimisation
- 6 MySQL Language Reference
- 7 MySQL Table Types
- 8 National Character Sets and Unicode in MySQL 4.1
- 9 MySQL APIs
- 10 Error Handling in MySQL
- 11 Spatial Extensions in MySQL
- 12 Extending MySQL
- A Problems and Common Errors
- B Contributed Programs
- C Credits
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I GNU Lesser General Public License
- SQL command, type and function index
- Concept Index
11 Spatial Extensions in MySQL
MySQL 4.1 introduces spatial extensions to allow the generation, storage, and analysis of geographic features. 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
Subsections
- 11.1 Introduction
- 11.2 The OpenGIS Geometry Model
- 11.2.1 The Geometry Class Hierarchy
- 11.2.2 Class
Geometry - 11.2.4 Class
Point - 11.2.7 Class
Curve - 11.2.9 Class
LineString - 11.2.12 Class
Surface - 11.2.14 Class
Polygon - 11.2.17 Class
GeometryCollection - 11.2.18 Class
MultiPoint - 11.2.21 Class
MultiCurve - 11.2.23 Class
MultiLineString - 11.2.25 Class
MultiSurface - 11.2.27 Class
MultiPolygon - 11.3 Supported Spatial Data Formats
- 11.4 Creating a Spatially Enabled MySQL Database
- 11.4.1 MySQL Spatial Datatypes
- 11.4.2 Creating Spatial Values
- 11.4.2.1 Creating Geometry Values Using WKT Functions
- 11.4.2.2 Creating Geometry Values Using WKB Functions
- 11.4.2.3 Creating Geometry Values Using MySQL-Specific Functions
- 11.4.3 Creating Spatial Columns
- 11.4.4 Populating Spatial Columns
- 11.4.5 Fetching Spatial Data
- 11.5 Analysing Spatial Information
- 11.5.1 Functions To Convert Geometries Between Formats
- 11.5.2
GeometryProperty Analysis Functions - 11.5.2.1 General Geometry Property Analysis Functions
- 11.5.2.2
PointProperty Analysis Functions - 11.5.2.3
LineStringProperty Analysis Functions - 11.5.2.4
MultiLineStringProperty Analysis Functions - 11.5.2.5
PolygonProperty Analysis Functions - 11.5.2.6
MultiPolygonProperty Analysis Functions - 11.5.2.7
GeometryCollectionProperty Analysis Functions - 11.5.3 Functions That Create New Geometries From Existing Ones
- 11.5.4 Functions For Testing Spatial Relations Between Geometric Objects
- 11.5.5 Relations On Geometry Minimal Bounding Rectangles (MBRs)
- 11.5.6 Functions That Test Spatial Relationships Between Geometries
- 11.6 Optimising Spatial Analysis
- 11.7 MySQL Conformance And Compatibility
