- はじめに
- 1 一般情報
- 2 MySQL のインストールと更新
- 3 MySQL プログラムの使用
- 4 データベース管理
- 5 レプリケーション
- 6 最適化
- 7 クライアントプログラムとユーティリティ プログラム
- 8 言語構造
- 9 キャラクタセットサポート
- 10 データタイプ
- 11 関数と演算子
- 12 SQL ステートメント構文
- 13 ストレージエンジンとテーブルタイプ
- 14 MySQL Cluster
- 15 パーティショニング
- 16 Spatial Extensions
- 17 ストアドプロシージャとファンクション
- 18 トリガ
- 19 Event Scheduler
- 20 ビュー
- 21 INFORMATION_SCHEMA データベース
- 22 精密計算
- 23 APIとライブラリー
- 24 MySQL コネクタ
- 25 Extending MySQL
- A Frequently Asked Questions About MySQL 5.1
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D 制限と規制
- E Credits
- 目次
目次
- 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 supports spatial extensions to allow the generation, storage,
and analysis of geographic features. These features are available
for MyISAM, InnoDB,
NDB, and ARCHIVE tables.
(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.)
Although spatial extensions are supported in
InnoDB tables, use of spatial indexes may cause a
crash. (Bug#15860)
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.
