地理空間関数

Geospatial functions operate on GEOGRAPHY and GEOMETRY and convert GEOGRAPHY and GEOMETRY values to and from other representations (such as VARCHAR).

サブカテゴリ

関数

メモ

Conversion / Input / Parsing

ST_GEOGFROMGEOHASH

GEOGRAPHY only

ST_GEOGPOINTFROMGEOHASH

GEOGRAPHY only

ST_GEOGRAPHYFROMWKB

GEOGRAPHY only

ST_GEOGRAPHYFROMWKT

GEOGRAPHY only

ST_GEOMETRYFROMWKB

GEOMETRY only

ST_GEOMETRYFROMWKT

GEOMETRY only

TO_GEOGRAPHY

GEOGRAPHY only

TO_GEOMETRY

GEOMETRY only

TRY_TO_GEOGRAPHY

GEOGRAPHY only

TRY_TO_GEOMETRY

GEOMETRY only

Conversion / Output / Formatting

ST_ASGEOJSON

ST_ASWKB

ST_ASBINARY

ST_ASWKB のエイリアス

ST_ASEWKB

ST_ASWKT

ST_ASTEXT

ST_ASWKT のエイリアス

ST_ASEWKT

ST_GEOHASH

GEOGRAPHY only

Constructor Functions

ST_MAKELINE

ST_MAKEGEOMPOINT

GEOMETRY only

ST_GEOMPOINT

Alias for ST_MAKEGEOMPOINT

ST_MAKEPOINT

GEOGRAPHY only

ST_POINT

ST_MAKEPOINT のエイリアス

ST_MAKEPOLYGON

ST_POLYGON

ST_MAKEPOLYGON のエイリアス

Accessor Functions

ST_DIMENSION

ST_ENDPOINT

ST_POINTN

ST_SRID

ST_STARTPOINT

ST_X

ST_XMAX

ST_XMIN

ST_Y

ST_YMAX

ST_YMIN

Relationship and Measurement Functions

ST_AREA

ST_AZIMUTH

GEOGRAPHY only

ST_CONTAINS

ST_COVEREDBY

ST_COVERS

ST_DISJOINT

ST_DISTANCE

ST_DWITHIN

GEOGRAPHY only

ST_HAUSDORFFDISTANCE

GEOGRAPHY only

ST_INTERSECTS

ST_LENGTH

ST_NPOINTS

ST_NUMPOINTS

ST_NPOINTS のエイリアス

ST_PERIMETER

ST_WITHIN

Transformation Functions

ST_CENTROID

ST_COLLECT (Scalar and Aggregate)

GEOGRAPHY only

ST_DIFFERENCE

GEOGRAPHY only

ST_ENVELOPE

Deprecated for GEOGRAPHY

ST_INTERSECTION

GEOGRAPHY only

ST_SETSRID

GEOMETRY only

ST_SIMPLIFY

GEOGRAPHY only

ST_SYMDIFFERENCE

GEOGRAPHY only

ST_UNION

GEOGRAPHY only

最上部に戻る