地理空间函数¶
地理空间函数针对 GEOGRAPHY 和 GEOMETRY 运行,将 GEOGRAPHY 和 GEOMETRY 值与其他表示形式(例如 VARCHAR)相互转换。
子类别 |
函数 |
备注 |
---|---|---|
转换/输入/解析 |
仅 GEOGRAPHY |
|
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOMETRY |
||
仅 GEOMETRY |
||
仅 GEOMETRY |
||
仅 GEOMETRY |
||
仅 GEOGRAPHY |
||
仅 GEOMETRY |
||
仅 GEOGRAPHY |
||
仅 GEOMETRY |
||
转换/输出/格式化 |
||
ST_ASWKB 的别名 |
||
ST_ASWKT 的别名 |
||
构造函数 |
||
仅 GEOMETRY |
||
ST_MAKEGEOMPOINT 的别名 |
||
仅 GEOGRAPHY |
||
ST_MAKEPOINT 的别名 |
||
ST_MAKEPOLYGON 的别名 |
||
仅 GEOGRAPHY |
||
存取函数 |
||
关系和测量函数 |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
ST_NPOINTS 的别名 |
||
转换函数 |
仅 GEOMETRY |
|
ST_COLLECT (标量和汇总) |
仅 GEOGRAPHY |
|
仅 GEOGRAPHY |
||
对 GEOGRAPHY 已弃用 |
||
仅 GEOGRAPHY |
||
ST_INTERSECTION_AGG (标量和汇总) |
仅 GEOGRAPHY |
|
仅 GEOMETRY |
||
仅 GEOGRAPHY |
||
仅 GEOMETRY |
||
仅 GEOGRAPHY |
||
ST_UNION_AGG (标量和汇总) |
仅 GEOGRAPHY |
|
效用函数。 |
||
H3 函数 |
仅 GEOGRAPHY |
|
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |
||
仅 GEOGRAPHY |