func.ST_ShortestLine
Returns the 2-dimensional shortest line between two geometries
Measurement Functions
func.ST_Project
Returns a point projected from a start point along a geodesic using a given distance and azimuth (bearing)
func.ST_Perimeter2D
Returns the 2-dimensional perimeter of a polygonal geometry
func.ST_Perimeter
Returns the 2D perimeter of the geometry/geography if it is a ST_Surface, ST_MultiSurface (Polygon, MultiPolygon)
func.ST_MaxDistance
Returns the 2-dimensional maximum distance between two geometries, in projected units
func.ST_LongestLine
Returns the 2-dimensional longest line between the points of two geometries
func.ST_3DShortestLine
Returns the 3-dimensional shortest line between two geometries
func.ST_3DPerimeter
Returns the 3-dimensional perimeter of the geometry, if it is a polygon or multi-polygon
func.ST_3DMaxDistance
Returns the 3-dimensional maximum cartesian distance between two geometries in projected units
func.ST_LengthSpheroid
Returns the 2D or 3D length/perimeter of a lon/lat geometry on a spheroid
func.ST_3DLongestLine
Returns the 3-dimensional longest line between two geometries
func.ST_3DLength
Returns the 3-dimensional or 2-dimensional length of the geometry if it is a linestring or multi-linestring
func.ST_Length2D
Returns the 2D length of the geometry if it is a linestring or multi-linestring
func.ST_Length
Returns the 2D Cartesian length of the geometry for geometry types and uses the inverse geodesic calculation for geography types
func.ST_HausdorffDistance
Returns the Hausdorff distance between two geometries, a measure of how similar or dissimilar 2 geometries are
func.ST_DistanceSpheroid
Returns minimum distance in meters between two lon/lat geometries given a particular spheroid
func.ST_Distance
For geometry types returns the minimum 2D Cartesian (planar) distance between two geometries, in projected units (spatial ref units)
func.ST_3DClosestPoint
Returns the 3-dimensional point on g1 that is closest to g2
func.ST_ClosestPoint
Returns the 2-dimensional point on g1 that is closest to g2
func.ST_Azimuth
Returns the azimuth in radians of the segment defined by the given point geometries, or NULL if the two points are coincident
func.ST_Area
Returns the area of a polygonal geometry
func.ST_Length2D_Spheroid
Returns the 2D length or perimeter of the geometry on a spheroid
Last modified March 11, 2024 at 3:25 PM EST: Creation of the expression expression library (3110a17)