Measurement Functions


func.ST_ShortestLine

Returns the 2-dimensional shortest line between two geometries

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 April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)