func.ST_SwapOrdinates
Returns a version of the given geometry with given ordinates swapped
Geometry Editors
func.ST_Snap
Snaps the vertices and segments of a geometry to another Geometry's vertices
func.ST_SnapToGrid
Snap all points of the input geometry to the grid defined by its origin and cell size
func.ST_ShiftLongitude
Reads every point/vertex in a geometry, and if the longitude coordinate is <0, adds 360 to it
func.ST_SetPoint
Replace point N of linestring with given point
func.ST_Segmentize
Returns a modified geometry having no segment longer than the given max_segment_length
func.ST_Reverse
Can be used on any geometry and reverses the order of the vertexes
func.ST_RemoveRepeatedPoints
Returns a version of the given geometry with duplicated points removed
func.ST_RemovePoint
Remove a point from a linestring, given its 0-based index
func.ST_Multi
Returns the geometry as a MULTI* geometry
func.ST_LineToCurve
Converts plain LINESTRING/POLYGON to CIRCULAR STRINGs and Curved Polygons
func.ST_LineMerge
Returns a (set of) LineString(s) formed by sewing together the constituent line work of a MULTILINESTRING
func.ST_ForceCurve
Turns a geometry into its curved representation
func.ST_ForceRHR
Forces the orientation of the vertices in a polygon to follow the area that is bounded by the polygon is to the right of the boundary
func.ST_ForceSFS
This function supports Polyhedral surfaces, Triangles and Triangulated Irregular Network Surfaces
func.ST_ForceCollection
Converts the geometry into a GEOMETRYCOLLECTION
func.ST_Force4D
Forces the geometries into XYZM mode
func.ST_Force3DM
Forces the geometries into XYM mode
func.ST_Force3DZ
This function forces the geoms into XYZ mode. If a geom has no 'Z' compenent, then a 'Z coordinate' is automatically added
func.ST_Force3D
Forces the geometries into XYZ mode
func.ST_Force2D
Forces the geometries into a "2-dimensional mode" so that all output representations will only have the X and Y coordinates
func.ST_FlipCoordinates
Returns a version of the given geometry with X and Y axis flipped
func.ST_CurveToLine
Converts a CIRCULAR STRING to LINESTRING or CURVEPOLYGON to POLYGON or MULTISURFACE to MULTIPOLYGON
func.ST_CollectionHomogenize
Given a geometry collection, returns the "simplest" representation of the contents
func.ST_CollectionExtract
Given a geometry collection, return a homogeneous multi-geometry
func.ST_AddPoint
Adds a point to a LineString before point
Last modified March 11, 2024 at 3:25 PM EST: Creation of the expression expression library (3110a17)