:: DEVELOPER ZONE
MySQL Reference Manual :: 18 Spatial Extensions in MySQL
Search the MySQL manual:
- Preface
- 1 General Information
- 2 Installing MySQL
- 3 MySQL Tutorial
- 4 Using MySQL Programs
- 5 Database Administration
- 6 Replication in MySQL
- 7 MySQL Optimization
- 8 MySQL Client and Utility Programs
- 9 Language Structure
- 10 Character Set Support
- 11 Column Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 MySQL Storage Engines and Table Types
- 15 The InnoDB Storage Engine
- 16 MySQL Cluster
- 17 Introduction to MaxDB
- 18 Spatial Extensions in MySQL
- 19 Stored Procedures and Functions
- 20 Triggers
- 21 Views
- 22 The INFORMATION_SCHEMA Information Database
- 23 Precision Math
- 24 MySQL APIs
- 25 MySQL Connectors
- 26 Error Handling in MySQL
- 27 Extending MySQL
- A Problems and Common Errors
- B Credits
- C MySQL and the Future (the TODO)
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I MySQL FLOSS License Exception
- Index
Additional languages
Additional formats
Table of Contents
- 18.1. Introduction
- 18.2. The OpenGIS Geometry Model
- 18.2.1. The Geometry Class Hierarchy
- 18.2.2. Class
Geometry - 18.2.3. Class
Point - 18.2.4. Class
Curve - 18.2.5. Class
LineString - 18.2.6. Class
Surface - 18.2.7. Class
Polygon - 18.2.8. Class
GeometryCollection - 18.2.9. Class
MultiPoint - 18.2.10. Class
MultiCurve - 18.2.11. Class
MultiLineString - 18.2.12. Class
MultiSurface - 18.2.13. Class
MultiPolygon
- 18.3. Supported Spatial Data Formats
- 18.4. Creating a Spatially Enabled MySQL Database
- 18.5. Analyzing Spatial Information
- 18.5.1. Geometry Format Conversion Functions
- 18.5.2.
GeometryFunctions - 18.5.3. Functions That Create New Geometries from Existing Ones
- 18.5.4. Functions for Testing Spatial Relations Between Geometric Objects
- 18.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)
- 18.5.6. Functions That Test Spatial Relationships Between Geometries
- 18.6. Optimizing Spatial Analysis
- 18.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
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.