Fork me on GitHub

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 GEOMETRYCOLLECTIONs 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 POLYGONs based on a Geometry or a table of Geometries
ST_MakeGridPoints Calculate a regular grid of POINTs based on a Geometry or a table of Geometries
ST_MakeLine (MULTI)POINTLINESTRING
ST_MakePoint Construct a POINT from two or three coordinates
ST_MakePolygon LINESTRINGPOLYGON
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.