地理空间函数

地理空间函数针对 GEOGRAPHYGEOMETRY 运行,将 GEOGRAPHY 和 GEOMETRY 值与其他表示形式(例如 VARCHAR)相互转换。

子类别

函数

备注

转换/输入/解析

ST_GEOGFROMGEOHASH

仅 GEOGRAPHY

ST_GEOGPOINTFROMGEOHASH

仅 GEOGRAPHY

ST_GEOGRAPHYFROMWKB

仅 GEOGRAPHY

ST_GEOGRAPHYFROMWKT

仅 GEOGRAPHY

ST_GEOMETRYFROMWKB

仅 GEOMETRY

ST_GEOMETRYFROMWKT

仅 GEOMETRY

ST_GEOMFROMGEOHASH

仅 GEOMETRY

ST_GEOMPOINTFROMGEOHASH

仅 GEOMETRY

TO_GEOGRAPHY

仅 GEOGRAPHY

TO_GEOMETRY

仅 GEOMETRY

TRY_TO_GEOGRAPHY

仅 GEOGRAPHY

TRY_TO_GEOMETRY

仅 GEOMETRY

转换/输出/格式化

ST_ASGEOJSON

ST_ASWKB

ST_ASBINARY

ST_ASWKB 的别名

ST_ASEWKB

ST_ASWKT

ST_ASTEXT

ST_ASWKT 的别名

ST_ASEWKT

ST_GEOHASH

构造函数

ST_MAKELINE

ST_MAKEGEOMPOINT

仅 GEOMETRY

ST_GEOMPOINT

ST_MAKEGEOMPOINT 的别名

ST_MAKEPOINT

仅 GEOGRAPHY

ST_POINT

ST_MAKEPOINT 的别名

ST_MAKEPOLYGON

ST_POLYGON

ST_MAKEPOLYGON 的别名

ST_MAKEPOLYGONORIENTED

仅 GEOGRAPHY

存取函数

ST_DIMENSION

ST_ENDPOINT

ST_POINTN

ST_SRID

ST_STARTPOINT

ST_X

ST_XMAX

ST_XMIN

ST_Y

ST_YMAX

ST_YMIN

关系和测量函数

HAVERSINE

ST_AREA

ST_AZIMUTH

ST_CONTAINS

ST_COVEREDBY

ST_COVERS

ST_DISJOINT

ST_DISTANCE

ST_DWITHIN

仅 GEOGRAPHY

ST_HAUSDORFFDISTANCE

仅 GEOGRAPHY

ST_INTERSECTS

ST_LENGTH

ST_NPOINTS

ST_NUMPOINTS

ST_NPOINTS 的别名

ST_PERIMETER

ST_WITHIN

转换函数

ST_BUFFER

仅 GEOMETRY

ST_CENTROID

ST_COLLECT (标量和汇总)

仅 GEOGRAPHY

ST_DIFFERENCE

仅 GEOGRAPHY

ST_ENVELOPE

对 GEOGRAPHY 已弃用

ST_INTERSECTION

仅 GEOGRAPHY

ST_INTERSECTION_AGG (标量和汇总)

仅 GEOGRAPHY

ST_SETSRID

仅 GEOMETRY

ST_SIMPLIFY

ST_SYMDIFFERENCE

仅 GEOGRAPHY

ST_TRANSFORM

仅 GEOMETRY

ST_UNION

仅 GEOGRAPHY

ST_UNION_AGG (标量和汇总)

仅 GEOGRAPHY

效用函数。

ST_ISVALID

H3 函数

H3_CELL_TO_BOUNDARY

仅 GEOGRAPHY

H3_CELL_TO_CHILDREN

仅 GEOGRAPHY

H3_CELL_TO_CHILDREN_STRING

仅 GEOGRAPHY

H3_CELL_TO_PARENT

仅 GEOGRAPHY

H3_CELL_TO_POINT

仅 GEOGRAPHY

H3_COMPACT_CELLS

仅 GEOGRAPHY

H3_COMPACT_CELLS_STRINGS

仅 GEOGRAPHY

H3_COVERAGE

仅 GEOGRAPHY

H3_COVERAGE_STRINGS

仅 GEOGRAPHY

H3_GET_RESOLUTION

仅 GEOGRAPHY

H3_GRID_DISTANCE

仅 GEOGRAPHY

H3_GRID_DISK

仅 GEOGRAPHY

H3_GRID_PATH

仅 GEOGRAPHY

H3_INT_TO_STRING

仅 GEOGRAPHY

H3_IS_PENTAGON

仅 GEOGRAPHY

H3_IS_VALID_CELL

仅 GEOGRAPHY

H3_LATLNG_TO_CELL

仅 GEOGRAPHY

H3_LATLNG_TO_CELL_STRING

仅 GEOGRAPHY

H3_POINT_TO_CELL

仅 GEOGRAPHY

H3_POINT_TO_CELL_STRING

仅 GEOGRAPHY

H3_POLYGON_TO_CELLS

仅 GEOGRAPHY

H3_POLYGON_TO_CELLS_STRINGS

仅 GEOGRAPHY

H3_STRING_TO_INT

仅 GEOGRAPHY

H3_TRY_GRID_DISTANCE

仅 GEOGRAPHY

H3_TRY_GRID_PATH

仅 GEOGRAPHY

H3_UNCOMPACT_CELLS

仅 GEOGRAPHY

H3_UNCOMPACT_CELLS_STRINGS

仅 GEOGRAPHY

语言: 中文