Geospatial Functions

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

Sub-category	Function	Notes
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	Alias for ST_ASWKB
	ST_ASEWKB
	ST_ASWKT
	ST_ASTEXT	Alias for 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	Alias for ST_MAKEPOINT
	ST_MAKEPOLYGON
	ST_POLYGON	Alias for 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	Alias for 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