11.4 Spatial Data Types空间数据类型

11.4.1 Spatial Data Types空间数据类型
11.4.2 The OpenGIS Geometry ModelOpenGIS几何模型
11.4.3 Supported Spatial Data Formats支持的空间数据格式
11.4.4 Geometry Well-Formedness and Validity几何适形性与有效性
11.4.5 Spatial Reference System Support空间参考系统支持
11.4.6 Creating Spatial Columns创建空间柱
11.4.7 Populating Spatial Columns填充空间列
11.4.8 Fetching Spatial Data获取空间数据
11.4.9 Optimizing Spatial Analysis优化空间分析
11.4.10 Creating Spatial Indexes创建空间索引
11.4.11 Using Spatial Indexes使用空间索引

The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial data.开放地理空间联合会(OGC)是一个由250多家公司、机构和大学组成的国际联合会,参与开发可公开获得的概念解决方案,这些解决方案可用于管理空间数据的各种应用程序。

The Open Geospatial Consortium publishes the OpenGIS® Implementation Standard for Geographic information - Simple feature access - Part 2: SQL option, a document that proposes several conceptual ways for extending an SQL RDBMS to support spatial data. 开放地理空间联合会发布了OpenGIS®地理信息实现标准-简单要素访问-第2部分:SQL选项,该文件提出了扩展SQL RDBMS以支持空间数据的几种概念性方法。This specification is available from the OGC website at http://www.opengeospatial.org/standards/sfs.本规范可从OGC网站获取,网址为http://www.opengeospatial.org/standards/sfs

Following the OGC specification, MySQL implements spatial extensions as a subset of the SQL with Geometry Types environment. 遵循OGC规范,MySQL将空间扩展作为SQL与几何类型环境的一个子集来实现。This term refers to an SQL environment that has been extended with a set of geometry types. 此术语指的是已使用一组几何图形类型进行扩展的SQL环境。A geometry-valued SQL column is implemented as a column that has a geometry type. 几何值SQL列被实现为具有几何类型的列。The specification describes a set of SQL geometry types, as well as functions on those types to create and analyze geometry values.规范描述了一组SQL几何体类型,以及这些类型上用于创建和分析几何体值的函数。

MySQL spatial extensions enable the generation, storage, and analysis of geographic features:MySQL空间扩展支持地理特征的生成、存储和分析:

The spatial data types and functions are available for MyISAM, InnoDB, NDB, and ARCHIVE tables. 空间数据类型和函数可用于MyISAMInnoDBNDBARCHIVE表。For indexing spatial columns, MyISAM and InnoDB support both SPATIAL and non-SPATIAL indexes. 对于索引空间列,MyISAMInnoDB同时支持空间索引和非空间索引。The other storage engines support non-SPATIAL indexes, as described in Section 13.1.15, “CREATE INDEX Statement”.其他存储引擎支持非空间索引,如第13.1.15节“创建索引语句”所述。

A geographic feature is anything in the world that has a location. 地理特征是指世界上任何有地理位置的东西。A feature can be:特征可以是:

Some documents use the term geospatial feature to refer to geographic features.有些文档使用术语地理空间特征来指代地理特征。

Geometry is another word that denotes a geographic feature. 几何是另一个表示地理特征的词。Originally the word geometry meant measurement of the earth. 最初,几何一词的意思是测量土地。Another meaning comes from cartography, referring to the geometric features that cartographers use to map the world.另一个含义来自制图,指的是制图者用来绘制世界地图的几何特征。

The discussion here considers these terms synonymous: geographic feature, geospatial feature, feature, or geometry. 这里的讨论认为这些术语同义:地理特征地理空间特征特征几何The term most commonly used is geometry, defined as a point or an aggregate of points representing anything in the world that has a location.最常用的术语是几何学,定义为一个点或点的集合,表示世界上任何有位置的东西

The following material covers these topics:以下材料涵盖这些主题:

For information about functions that operate on spatial data, see Section 12.17, “Spatial Analysis Functions”.有关操作空间数据的函数的信息,请参阅第12.17节“空间分析函数”

Additional Resources额外资源

These standards are important for the MySQL implementation of spatial operations:这些标准对于空间操作的MySQL实现非常重要:

If you have questions or concerns about the use of the spatial extensions to MySQL, you can discuss them in the GIS forum: https://forums.mysql.com/list.php?23.如果您对MySQL空间扩展的使用有疑问或担忧,可以在GIS论坛上讨论:https://forums.mysql.com/list.php?23

11.4.1 Spatial Data Types
11.4.2 The OpenGIS Geometry Model
11.4.3 Supported Spatial Data Formats
11.4.4 Geometry Well-Formedness and Validity
11.4.5 Spatial Reference System Support
11.4.6 Creating Spatial Columns
11.4.7 Populating Spatial Columns
11.4.8 Fetching Spatial Data
11.4.9 Optimizing Spatial Analysis
11.4.10 Creating Spatial Indexes
11.4.11 Using Spatial Indexes