Geometry 2D

Function	Description
`ST_Accum`	Construct an array of Geometries
`ST_AddPoint`	Add a point to a Geometry
`ST_Area`	Return a Geometry's area
`ST_AsBinary`	Geometry → Well Known Binary
`ST_AsText`	Alias for `ST_AsWKT`
`ST_AsWKT`	Geometry → Well Known Text
`ST_Azimuth`	Return the azimuth of the segment from point A to point B
`ST_Boundary`	Return a Geometry's boundary
`ST_BoundingCircle`	Return the minimum bounding circle of a Geometry
`ST_Buffer`	Compute a buffer around a Geometry
`ST_Centroid`	Return the centroid of a Geometry
`ST_ClosestCoordinate`	Return the coordinate(s) of a Geometry closest to a `POINT`
`ST_ClosestPoint`	Return the point of Geometry A closest to Geometry B
`ST_CollectionExtract`	Filter a Geometry with its dimension
`ST_CompactnessRatio`	Return the square root of a `POLYGON`'s area divided by the area of the circle with circumference equal to its perimeter
`ST_Contains`	Return true if Geometry A contains Geometry B
`ST_ConvexHull`	Compute the smallest convex `POLYGON` that contains all the points in the Geometry
`ST_CoordDim`	Return the dimension of the coordinates of a Geometry
`ST_Covers`	Return true if no point in Geometry B is outside Geometry A
`ST_Crosses`	Return true if Geometry A crosses Geometry B
`ST_DWithin`	Return true if the Geometries are within the specified distance of one another
`ST_Densify`	Insert extra vertices along the line segments of a Geometry
`ST_Difference`	Compute the difference between two geometries
`ST_Dimension`	Return the dimension of a Geometry
`ST_Disjoint`	Return true Geometries A and B are disjoint
`ST_Distance`	Return the distance between two Geometries
`ST_EndPoint`	Return the last coordinate of a `LINESTRING`
`ST_Envelope`	Return a Geometry's envelope as a Geometry
`ST_EnvelopesIntersect`	Return true if the envelope of Geometry A intersects the envelope of Geometry B
`ST_Equals`	Return true if Geometry A equals Geometry B
`ST_Expand`	Expand a Geometry's envelope
`ST_Explode`	Explode `GEOMETRYCOLLECTION`s into multiple Geometries
`ST_Extent`	Return the minimum bounding box of a `GEOMETRYCOLLECTION`
`ST_ExteriorRing`	Return the exterior ring of a `POLYGON`
`ST_FlipCoordinates`	Flip the `X` and `Y` coordinates of a Geometry
`ST_Force2D`	3D Geometry → 2D Geometry
`ST_FurthestCoordinate`	Compute the furthest coordinate(s) contained in a Geometry starting from a `POINT`
`ST_GeomFromText`	Well Known Text → Geometry
`ST_GeomFromWKB`	Well Known Binary → Geometry
`ST_GeometryN`	Return the nth Geometry of a `GEOMETRYCOLLECTION`
`ST_GeometryType`	Return the type of a Geometry
`ST_GeometryTypeCode`	Return the OGC SFS type code of a Geometry
`ST_GoogleMapLink`	Geometry → Google map link
`ST_Holes`	Return a Geometry's holes
`ST_ISOVist`	Compute the visibility from a point
`ST_InteriorRingN`	Return the nth interior ring of a `POLYGON`
`ST_Intersection`	Compute the intersection of two Geometries
`ST_Intersects`	Return true if Geometry A intersects Geometry B
`ST_IsClosed`	Return true if a Geometry is a closed `LINESTRING` or `MULTILINESTRING`
`ST_IsEmpty`	Return true if a Geometry is empty
`ST_IsRectangle`	Return true if the Geometry is a rectangle
`ST_IsRing`	Return true if a `LINESTRING` is ring
`ST_IsSimple`	Return true if a Geometry is simple
`ST_IsValid`	Return true if the Geometry is valid
`ST_IsValidDetail`	Return a valid detail as an array of objects
`ST_IsValidReason`	Return text stating if a geometry is valid or not and if not valid, a reason why
`ST_Length`	Return the length of a Geometry
`ST_LineFromText`	Well Known Text → `LINESTRING`
`ST_LineFromWKB`	Well Known Binary → `LINESTRING`
`ST_LineIntersector`	Split an input `LINESTRING` with another geometry
`ST_LineMerge`	Merges a collection of linear components to form maximal-length `LINESTRING`
`ST_LocateAlong`	Return a `MULTIPOINT` containing points along the line segments of a Geometry at a given segment length fraction and offset distance
`ST_LongestLine`	Returns the 2-dimensional longest `LINESTRING` between the points of two geometries
`ST_MLineFromText`	Well Known Text → `MULTILINESTRING`
`ST_MPointFromText`	Well Known Text → `MULTIPOINT`
`ST_MPolyFromText`	Well Known Text → `MULTIPOLYGON`
`ST_MakeEllipse`	Construct an ellipse
`ST_MakeEnvelope`	Create a rectangular Polygon
`ST_MakeGrid`	Calculate a regular grid of `POLYGON`s based on a Geometry or a table of Geometries
`ST_MakeGridPoints`	Calculate a regular grid of `POINT`s based on a Geometry or a table of Geometries
`ST_MakeLine`	`(MULTI)POINT` → `LINESTRING`
`ST_MakePoint`	Construct a `POINT` from two or three coordinates
`ST_MakePolygon`	`LINESTRING` → `POLYGON`
`ST_MaxDistance`	Compute the maximum distance between two geometries
`ST_MinimumDiameter`	Return the minimum diameter of a Geometry
`ST_MinimumRectangle`	Return the minimum rectangle enclosing a Geometry
`ST_Node`	Add nodes on a geometry for each intersection
`ST_Normalize`	Return a Geometry with a normal form
`ST_NumGeometries`	Return the number of Geometries in a `GEOMETRYCOLLECTION`
`ST_NumInteriorRing`	Alias for `ST_NumInteriorRings`
`ST_NumInteriorRings`	Return the number of interior rings of a Geometry
`ST_NumPoints`	Return the number of points in a Geometry
`ST_OSMMapLink`	Geometry → OSM map link
`ST_OctogonalEnvelope`	Return the octogonal envelope of a Geometry
`ST_OrderingEquals`	Returns `TRUE` if Geometry A equals Geometry B and their coordinates and component Geometries are listed in the same order
`ST_Overlaps`	Return true if Geometry A overlaps Geometry B
`ST_Perimeter`	Return the perimeter of a (multi)polygon
`ST_Point`	Construct a `POINT` from two or three coordinates
`ST_PointFromText`	Well Known Text → `POINT`
`ST_PointFromWKB`	Well Known Binary → `POINT`
`ST_PointN`	Return the nth point of a `LINESTRING`
`ST_PointOnSurface`	Return an interior or boundary point of a Geometry
`ST_PolyFromText`	Well Known Text → `POLYGON`
`ST_PolyFromWKB`	Well Known Binary → `POLYGON`
`ST_Polygonize`	Create a `MULTIPOLYGON` from edges of Geometries
`ST_PrecisionReducer`	Reduce a Geometry's precision
`ST_ProjectPoint`	Project a `POINT` on a `(MULTI)LINESTRING`
`ST_Relate`	Return the DE-9IM intersection matrix of the two Geometries or true if they are related by the given intersection matrix
`ST_RemoveHoles`	Remove a Geometry's holes
`ST_RemovePoints`	Return a Geometry with vertices less
`ST_RemoveRepeatedPoints`	Remove repeated points from a Geometry
`ST_Reverse`	Reverse the vertex order of a Geometry
`ST_RingBuffer`	Return a `MULTIPOLYGON` of buffers centered at a Geometry and of increasing buffer Size
`ST_RingSideBuffer`	Compute a ring buffer on one side
`ST_Rotate`	Rotate a Geometry counter-clockwise by an angle (in radians) about a point
`ST_SRID`	Return a SRID value
`ST_Scale`	Scale a Geometry by multiplying the ordinates by the indicated scale factors
`ST_SetSRID`	Return a copy of a Geometry with a new SRID
`ST_ShortestLine`	Returns the 2-dimensional shortest `LINESTRING` between two geometries
`ST_SideBuffer`	Compute a single buffer on one side
`ST_Simplify`	Simplify a Geometry
`ST_SimplifyPreserveTopology`	Simplify a Geometry, preserving its topology
`ST_Snap`	Snap two Geometries together
`ST_Split`	Split Geometry A by Geometry B
`ST_StartPoint`	Return the first coordinate of a `LINESTRING`
`ST_SymDifference`	Compute the symmetric difference between two Geometries
`ST_ToMultiLine`	Geometry's coordinates → `MULTILINESTRING`
`ST_ToMultiPoint`	Geometry's coordinates → `MULTIPOINT`
`ST_ToMultiSegments`	`GEOMETRY(COLLECTION)` → `MULTILINESTRING`
`ST_Touches`	Return true if Geometry A touches Geometry B
`ST_Transform`	Transform a Geometry from one CRS to another
`ST_Translate`	Translate a Geometry
`ST_Union`	Compute the union of two or more Geometries
`ST_Within`	Return true if Geometry A is within Geometry B
`ST_X`	Return the x-value of the first coordinate of a Geometry
`ST_XMax`	Return the maximum x-value of a Geometry
`ST_XMin`	Return the minimum x-value of a Geometry
`ST_Y`	Return the y-value of the first coordinate of a Geometry
`ST_YMax`	Return the maximum y-value of a Geometry
`ST_YMin`	Return the minimum y-value of a Geometry

Documented functions: 130/130.

Back