Spatial Function Reference Name Description Introduced ST_Area() Return Polygon or MultiPolygon area ST_AsBinary() ,  ST_AsWKB() Convert from internal geometry format to WKB ST_AsGeoJSON() Generate GeoJSON object from geometry ST_AsText() ,  ST_AsWKT() Convert from internal geometry format to WKT ST_Buffer() Return geometry of points within given distance from geometry ST_Buffer_Strategy() Produce strategy option for ST_Buffer() ST_Centroid() Return centroid as a point ST_Collect() Aggregate spatial values into collection 8.0.24 ST_Contains() Whether one geometry contains another ST_ConvexHull() Return convex hull of geometry ST_Crosses() Whether one geometry crosses another ST_Difference() Return point set difference of two geometries ST_Dimension() Dimension of geometry ST_Disjoint() Whether one geometry is disjoint from another ST_Distance() The distance of one geometry from another ST_Distance_Sphere() Minimum distance on earth between two geometries ST_EndPoint() End Point of LineString ST_Envelope() Return MBR of geometry ST_Equals() Whether one geometry is equal to another ST_ExteriorRing() Return exterior ring of Polygon ST_FrechetDistance() The discrete FrØchet distance of one geometry from another 8.0.23 ST_GeoHash() Produce a geohash value ST_GeomCollFromText() , ST_GeometryCollectionFromText() , ST_GeomCollFromTxt() Return geometry collection from WKT ST_GeomCollFromWKB() , ST_GeometryCollectionFromWKB() Return geometry collection from WKB 2292