Mysql5.7_SpatialAnalysisFunctions空间分析函数
12.17 Spatial Analysis Functions
空间分析函数
- 12.17.1 Spatial Function Reference空间函数参考:
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-reference.html - 12.17.2 Argument Handling by Spatial Functions 空间函数参数处理:https://dev.mysql.com/doc/refman/5.7/en/spatial-function-argument-handling.html
- 12.17.3 Functions That Create Geometry Values from WKT Values 从WKT创建几何值的函数:https://dev.mysql.com/doc/refman/5.7/en/gis-wkt-functions.html
- 12.17.4 Functions That Create Geometry Values from WKB Values 从WKB创建几何值的函数:https://dev.mysql.com/doc/refman/5.7/en/gis-wkb-functions.html
- 12.17.5 MySQL-Specific Functions That Create Geometry Values 创建几何值的mysql特定函数:https://dev.mysql.com/doc/refman/5.7/en/gis-mysql-specific-functions.html
- 12.17.6 Geometry Format Conversion Functions 几何格式转换函数:https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
- 12.17.7 Geometry Property Functions 几何属性函数:https://dev.mysql.com/doc/refman/5.7/en/gis-property-functions.html
- 12.17.8 Spatial Operator Functions 空间操作函数:https://dev.mysql.com/doc/refman/5.7/en/spatial-operator-functions.html
- 12.17.9 Functions That Test Spatial Relations Between Geometry Objects 测试几何对象空间关系的函数:https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions.html
- 12.17.10 Spatial Geohash Functions 空间哈希函数:https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
- 12.17.11 Spatial GeoJSON Functions 空间geojson函数:https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
- 12.17.12 Spatial Convenience Functions 空间便利的函数:https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html
MySQL provides functions to perform various operations on spatial data. These functions can be grouped into several major categories according to the type of operation they perform:
mysql提供了空间数据不同操作的函数。这些函数根据执行的操作类型可以分组成几个主要的目录:
- Functions that create geometries in various formats (WKT, WKB, internal) 用不同的格式(wkt,wkb,internal)创建几何的函数
- Functions that convert geometries between formats 不同格式几何之间的转换函数
- Functions that access qualitative or quantitative properties of a geometry 获得几何的定性或定量属性的函数
- Functions that describe relations between two geometries 描述两个几个之间关系的函数
- Functions that create new geometries from existing ones 从已存在几何创建新几何的函数
For general background about MySQL support for using spatial data, see Section 11.4, “Spatial Data Types”.
对于mysql使用空间数据的支持的大体背景。看11.4章节-空间数据类型。