Routines

args: catalog_name, schema_name, table_name, column_name, srid - Updates the SRID of all features in a geometry column, and the table metadata.

args: collection - Returns the simplest representation of a geometry collection.

args: geom - Compute a straight skeleton from a geometry

args: geom, tolerance - Returns a version of a geometry with duplicate points removed.

args: geomA - Convert the geometry into a GEOMETRYCOLLECTION.

args: linestring, point, position = -1 - Add a point to a LineString.

args: geom, number_of_clusters, max_radius - Window function that returns a cluster id for each input geometry using the K-means algorithm.

args: geom - Computes the largest circle contained within a geometry.

Returns PostGIS version number and compile-time options.

args: geomA - Tests if a geometry has no points of self-intersection or self-tangency.

args: g1, g2, distance - Returns a point projected from a start point by a distance and bearing (azimuth).

args: geom - Returns the number of elements in a geometry collection.

args: geomA, n - Return an element of a geometry collection.

args: geomA, geomB, gridSize = -1 - Computes a geometry representing the portions of geometries A and B that do not intersect.

args: tileZoom, tileX, tileY, bounds=SRID=3857;LINESTRING(-20037508.342789 -20037508.342789,20037508.342789 20037508.342789), margin=0.0 - Creates a rectangular Polygon in Web Mercator (SRID:3857) using the XYZ tile system.

args: g - Force the orientation of the vertices in a polygon to follow the Right-Hand-Rule.

args: geom, nIterations = 1, preserveEndPoints = false - Returns a smoothed version of a geometry, using the Chaikin algorithm

args: xmin, ymin, xmax, ymax, srid=unknown - Creates a rectangular Polygon from minimum and maximum coordinates.

Return metadata records for every spatial reference system in the underlying Proj database.

args: geomA, num_segs_per_qt_circ=48 - Returns the smallest circle polygon that contains a geometry.

args: auth_name - Return the list of SRS codes associated with the given authority.

args: geomA - Tests if a geometry is empty.

args: geom, pipeline, to_srid - Return a new geometry with coordinates transformed to a different spatial reference system using the inverse of a defined coordinate transformation pipeline.

args: size, cell_i, cell_j, origin - Returns a single hexagon, using the provided edge size and cell coordinate within the hexagon grid space.

args: geom, x, y, z - Extrude a surface to a related volume

args: geomA - Returns the boundary of a geometry.

args: x, y, z, m - Creates a 2D, 3DZ or 4D Point.

args: g1 - Return a constrained Delaunay triangulation around the given input geometry.

args: geom1, geom2 - Perform 3D intersection

args: linestring, point - Change start point of a closed LineString.

args: geom, tolerance = NULL, max_iter = 10000, fail_if_not_converged = false - Returns the geometric median of a MultiPoint.

args: target_version=null - Packages and upgrades PostGIS extensions (e.g. postgis_raster,postgis_topology, postgis_sfcgal) to given or latest version.

args: geom - Computes the constrained Delaunay triangulation of polygons

args: geom1 - Computes the 3D convex hull of a geometry.

args: geom - Check if a surface is or not planar

args: geomA - Returns the first point of a LineString.

args: geom - Shifts the longitude coordinates of a geometry between -180..180 and 0..360.

args: letters, font - Returns the input letters rendered as geometry with a default start position at the origin and default text height of 100.

args: geomA - Drop the bounding box cache from the geometry.

Returns the version number of the internal Wagyu library.

args: a_polygon - Returns the number of interior rings (holes) of a Polygon.

args: lineString, srid - Creates a Polygon from a LineString with a specified SRID.

args: catalog_name, schema_name, table_name, column_name, srid, type, dimension, use_typmod=true - Adds a geometry column to an existing table.

args: geom, eps, minpoints - Window function that returns a cluster id for each input geometry using the DBSCAN algorithm.

args: geom, gridSize = -1 - Computes the union of the components of a single geometry.

args: amultilinestring, directed - Return the lines formed by sewing together a MultiLineString.

args: geom, ords - Returns a version of the given geometry with given ordinate values swapped.

args: line, distance_forward, distance_backward=0.0 - Returns a line with the last and first segments extended the specified distance(s).

args: geom, alpha, allow_holes = false - Computes an Alpha-shape enclosing a geometry

args: auth_name, auth_srid - Return a metadata record for the requested authority and srid.

args: a_3dlinestring - Returns the 3D length of a linear geometry.

args: g, npoints, seed = 0 - Generates random points contained in a Polygon or MultiPolygon.

args: geom - Creates a polygonal geometry formed by the linework of a geometry.

args: geomA, threshold = 0, set_area = 1 - Sets the effective area for each vertex, using the Visvalingam-Whyatt algorithm.

Returns the version number of the PROJ4 library.

args: geomA, n - Returns the Nth geometry (face) of a PolyhedralSurface.

args: geomA, rotRadians, pointOrigin - Rotates a geometry about an origin point.

args: geomA - Tests if a geometry contains a circular arc

args: geom1 - Test if the geometry is a solid. No validity check is performed.

args: geomA, pointOrigin, sizeX, sizeY, sizeZ, sizeM - Snap all points of the input geometry to a regular grid.

args: geog, max_segment_length - Returns a modified geometry/geography having no segment longer than a given distance.

args: geom1, geom2 - Perform 3D difference

args: linestring, zerobasedposition, point - Replace point of a linestring with a given point.

Enables long transaction support.

args: pointLowLeft, pointUpRight - Creates a BOX2D defined by two 2D point geometries.

args: aGeomorBox2DorBox3D - Returns the Y minima of a 2D or 3D bounding box or a geometry.

args: geom_mline, measure_start, measure_end - Interpolates measures along a linear geometry.

args: geom - Returns a minimum-area rectangle containing a geometry.

args: table_name, geocolumn_name - Returns the estimated extent of a spatial table.

args: relation_oid, use_typmod=true - Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints.

args: linear_geom_with_measure, point - Returns the interpolated measure of a geometry closest to a point.

args: g - Returns a text summary of the contents of a geometry.

args: g - Upcast a geometry into its curved type, if applicable.

args: geomA, tolerance - Returns a simplified version of a geometry, using the Visvalingam-Whyatt algorithm

args: geom, allow_holes = false, nb_components = 1 - Computes an Alpha-shape enclosing a geometry using an “optimal” alpha value.

args: geom - Perform surface Tesselation of a polygon or polyhedralsurface and returns as a TIN or collection of TINS

args: g - Returns the topological dimension of a geometry.

args: geom - Orients all exterior rings clockwise and all interior rings counter-clockwise.

args: g1, g2 - Returns the 3D cartesian maximum distance (based on spatial ref) between two geometries in projected units.

args: g1 - Computes a point guaranteed to lie in a polygon, or on a geometry.

args: geom, wrap, move - Wrap a geometry around an X value.

args: geomA - Returns the amount of memory space a geometry takes.

args: g1, deltax, deltay, deltaz - Translates a geometry by given offsets.

args: a_polygon - Returns a set of geometry_dump rows for the exterior and interior rings of a Polygon.

args: track1, track2 - Returns the distance between the closest point of approach of two trajectories.

args: x, y, z, m, srid=unknown - Creates a Point with X, Y, Z, M and SRID values.

args: geom, factor, origin - Scales a geometry by given factors.

args: outerlinestring, interiorlinestrings - Creates a Polygon from a shell and optional list of holes.

args: geomfield - Aggregate function that returns the 3D bounding box of geometries.

args: catalog_name, schema_name, table_name - Drops a table and all its references in geometry_columns.

args: catalog_name, schema_name, table_name, column_name - Removes a geometry column from a spatial table.

Returns version of the PostGIS scripts installed in this database.

args: geom - Return the geometry as a MULTI* geometry.

args: input, reference, tolerance - Snap segments and vertices of input geometry to vertices of a reference geometry.

args: g - Returns the minimum clearance of a geometry, a measure of a geometrys robustness.

args: geom - Tests if Polygons have exterior rings oriented clockwise and interior rings oriented counter-clockwise.

args: a_polygon, n - Returns the Nth interior ring (hole) of a Polygon.

args: a_point - Returns the M coordinate of a Point.

args: x, y, m - Creates a Point from X, Y and M values.

args: g1 - Return the geometry with vertex order reversed.

args: geom - Force LHR orientation

args: geomA, flags - Returns text stating if a geometry is valid, or a reason for invalidity.

args: aGeomorBox2DorBox3D - Returns the Z minima of a 2D or 3D bounding box or a geometry.

args: a_point - Returns the Z coordinate of a Point.

args: a_point - Returns the Y coordinate of a Point.

args: a_point - Returns the X coordinate of a Point.

args: g1, g2 - Returns the 3D longest line between two geometries

args: collection, type - Given a geometry collection, returns a multi-geometry containing only elements of a specified type.

args: input, params - Attempts to make an invalid geometry valid without losing vertices.

args: geomA, tolerance - Returns a simplified and valid version of a geometry, using the Douglas-Peucker algorithm.

Returns the version number of the postgis.sql script released with the installed PostGIS lib.

args: geomA - Computes the convex hull of a geometry.

Returns the version number of the GEOS library.

args: geom - Returns a set of geometry_dump rows for the coordinates in a geometry.

args: geom - Returns a MultiPoint containing the coordinates of a geometry.

args: box, dx, dy, dz=0 - Returns a bounding box expanded from another bounding box or a geometry.

args: param_geom, vertex_fraction, is_outer = true - Computes a simplifed topology-preserving outer or inner hull of a polygonal geometry.

args: aGeomorBox2DorBox3D - Returns the Y maxima of a 2D or 3D bounding box or a geometry.

args: x, y, z, srid=unknown - Creates a Point with X, Y, Z and SRID values.

args: geomA, deltaX, deltaY, XFactor, YFactor - Translates and scales a geometry by given offsets and factors.

args: g - Tests if a geometry is a geometry collection type.

Disables long transaction support.

args: linestring, offset - Remove a point from a linestring.

args: geomA, tolerance, preserveCollapsed - Returns a simplified version of a geometry, using the Douglas-Peucker algorithm.

args: g1, g2 - Returns the 3D shortest line between two geometries

Returns the version of SFCGAL in use

args: x, y, srid=unknown - Creates a Point with X, Y and SRID values.

args: a_linestring, a_fraction - Returns a point interpolated along a 3D line at a fractional location.

args: geom, measure_start, measure_end, offset = 0 - Returns the portions of a geometry that match a measure range.

args: line1, line2 - Returns the angle between two vectors defined by 3 or 4 points, or 2 lines.

args: geomA - Returns TRUE if the bbox of this geometry is cached, FALSE otherwise.

args: bounds, auth_name=EPSG - Return metadata records for projected coordinate systems that have areas of useage that fully contain the bounds parameter.

args: g1 - Returns a set of geometry_dump rows for the components of a geometry.

args: geom, box - Computes the portion of a geometry falling within a rectangle.

args: geom_array - Computes a collection of polygons formed from the linework of a set of geometries.

args: geomA, geomB, gridSize = -1 - Computes a geometry representing the part of geometry A that does not intersect geometry B.

args: geom, tolerance = 0 - Window function that finds locations where polygons fail to form a valid coverage.

args: g1, g2 - Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.

args: line, signed_distance, style_parameters=’ - Returns an offset line at a given distance and side from an input line.

args: geom, max_vertices=256, gridSize = -1 - Computes a rectilinear subdivision of a geometry.

args: g1 - Return the number of faces on a Polyhedral Surface. Will return null for non-polyhedral geometries.

args: a_polygon - Returns the number of interior rings (holes) of a Polygon. Aias for ST_NumInteriorRings

args: g1, g2, densifyFrac - Returns the Hausdorff distance between two geometries.

args: geomA, rotRadians - Rotates a geometry about the X axis.

args: g, gridsize - Returns a valid geometry with points rounded to a grid tolerance.

args: a_2dlinestring - Returns the 2D length of a linear geometry. Alias for ST_Length

args: geomA - Returns the 3D perimeter of a polygonal geometry.

args: aGeomorBox2DorBox3D - Returns the X maxima of a 2D or 3D bounding box or a geometry.

args: origin, target - Returns the north-based azimuth of a line between two points.

Returns build date of the PostGIS library.

args: geom, min, max = null, returnM = false - Removes vertices based on their M value

args: geom1 - Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.

args: geom1 - Computes area of 3D surface geometries. Will return 0 for solids.

args: geom - Nodes a collection of lines.

args: aMultiPoint - Creates a LineString from a MultiPoint geometry.

args: geomfield - Aggregate function that returns the bounding box of geometries.

args: g1field - Perform 3D union.

args: geomA, a, b, d, e, xoff, yoff - Apply a 3D affine transformation to a geometry.

args: aGeomorBox2DorBox3D - Returns the X minima of a 2D or 3D bounding box or a geometry.

args: geom - Orients all exterior rings counter-clockwise and all interior rings clockwise.

args: geomfield - Aggregate function which unions geometries in a memory-efficent but slower way

args: geomA, rotRadians - Rotates a geometry about the Y axis.

args: geomA, rotRadians - Rotates a geometry about the Z axis.

args: auth_token - Removes all locks held by an authorization token.

args: aGeomorBox2DorBox3D - Returns the Z maxima of a 2D or 3D bounding box or a geometry.

args: g1 - Returns the number of points in a LineString or CircularString.

args: g1, g2 - Returns the 3D point on g1 that is closest to g2. This is the first point of the 3D shortest line.

args: geomA - Add bounding box to the geometry.

args: track1, track2, dist - Tests if the closest point of approach of two trajectoriesis within the specified distance.

args: geom, elevation_start, elevation_end - Returns the portions of a geometry that lie in an elevation (Z) range.

args: geomA - Returns the 2D perimeter of a polygonal geometry. Alias for ST_Perimeter.

Returns build date of the PostGIS scripts.

args: g1 - Returns the coordinate dimension of a geometry.

args: x, y, m, srid=unknown - Creates a Point with X, Y, M and SRID values.

args: a_linestring, n - Returns the Nth point in the first LineString or circular LineString in a geometry.

args: geom - Returns a set of geometry_dump rows for the segments in a geometry.

args: g1, g2, densifyFrac = -1 - Returns the Fréchet distance between two geometries.

args: lineal1, lineal2 - Returns a collection containing paths shared by the two input linestrings/multilinestrings.

args: g1field - Creates a GeometryCollection or Multi* geometry from a set of geometries.

args: g - Tests if a LineStringss start and end points are coincident. For a PolyhedralSurface tests if it is closed (volumetric).

args: g1 - Returns the SQL-MM type of a geometry as text.

args: curveGeom, tolerance, tolerance_type, flags - Converts a geometry containing curves to a linear geometry.

args: g1 - Returns the number of points (vertices) in a geometry.

args: g1field, gridSize - Computes a geometry representing the point-set union of the input geometries.

args: geom - Compute the approximate medial axis of an areal geometry.

args: g - Tests if a LineString is closed and simple.

args: geom, tolerance, simplifyBoundary = true - Window function that simplifies the edges of a polygonal coverage.

args: geom_with_measure, measure, offset = 0 - Returns the point(s) on a geometry that match a measure value.

args: geog, use_spheroid = true - Returns the length of the boundary of a polygonal geometry or geography.

args: geomA - Force the geometries into a “2-dimensional mode”.

Returns the version number of the GEOS library against which PostGIS was built.

args: geom, from_proj, to_srid - Return a new geometry with coordinates transformed to a different spatial reference system.

Returns the version number of the liblwgeom library. This should match the version of PostGIS.

args: geomA, Mvalue = 0.0 - Force the geometries into XYM mode.

args: a_table_name, a_key_column_name - Creates a trigger on a table to prevent/allow updates and deletes of rows based on authorization token.

args: geomA - Returns the number of rings in a polygonal geometry.

args: geom1 - Cast the geometry into a solid. No check is performed. To obtain a valid solid, the input geometry must be a closed Polyhedral Surface or a closed TIN.

args: size, cell_i, cell_j, origin - Returns a single square, using the provided edge size and cell coordinate within the square grid space.

args: geomA, Zvalue = 0.0 - Force the geometries into XYZ mode.

args: line - Tests if the geometry is a valid trajectory.

args: geomA - Return the coordinate dimension of a geometry.

args: geomA, Zvalue = 0.0, Mvalue = 0.0 - Force the geometries into XYZM mode.

args: geomANoncircular - Converts a linear geometry to a curved geometry.

Returns the version number of the libxml2 library.

args: geom - Determine surface orientation

args: track1, track2 - Returns a measure at the closest point of approach of two trajectories.

args: geom - Tests if Polygons have exterior rings oriented counter-clockwise and interior rings oriented clockwise.

args: a_geometry, a_spheroid - Returns the 2D or 3D length/perimeter of a lon/lat geometry on a spheroid.

args: geom, tolerance=0.0, boundary=POINT EMPTY - Computes the largest circle not overlapping a geometry.

args: geom - Return the geometry in its canonical form.

args: param_geom, param_pctconvex, param_allow_holes = false - Computes a possibly concave geometry that contains all input geometry vertices

args: g - Returns the last point of a LineString or CircularLineString.

args: g1, g2 - Returns the 2D longest line between two geometries.

args: geomA, Zvalue = 0.0 - Force the geometries into XYZ mode. This is an alias for ST_Force3DZ.

args: geom - Window function that returns a cluster id for each input geometry, clustering input geometries into connected sets.

args: size, bounds - Returns a set of grid squares and cell indices that completely cover the bounds of the geometry argument.

args: g, prec_x, prec_y, prec_z, prec_m - Sets least significant bits of coordinates to zero

args: g1, tolerance = 0.0, flags = 0 - Returns the Delaunay triangulation of the vertices of a geometry.

args: geom - Returns a version of a geometry with X and Y axis flipped.

args: geom - Returns the center point and radius of the smallest circle that contains a geometry.

args: geoms - Creates a LineString from Point, MultiPoint, or LineString geometries.

args: geom, fits=false - Returns the diagonal of a geometrys bounding box.

args: g1 - Returns a geometry representing the bounding box of a geometry.

args: g - Returns the two-point LineString spanning a geometrys minimum clearance.

args: geom1, geom2 - Performs Minkowski sum

args: geomA - Returns a code indicating the ZM coordinate dimension of a geometry.

args: point3DLowLeftBottom, point3DUpRightTop - Creates a BOX3D defined by two 3D point geometries.

Returns the version number of the PostGIS library.

args: size, bounds - Returns a set of hexagons and cell indices that completely cover the bounds of the geometry argument.

Returns the full version of SFCGAL in use including CGAL and Boost versions

args: geomA, version - Force the geometries to use SFS 1.1 geometry types only.

args: geom, tolerance = 0.0, extend_to = NULL - Returns the cells of the Voronoi diagram of the vertices of a geometry.

args: geom, flags - Returns a valid_detail row stating if a geometry is valid or if not a reason and a location.

Reports full PostGIS version and build configuration infos.

args: a_polygon - Returns a LineString representing the exterior ring of a Polygon.

args: g, flags - Tests if a geometry is well-formed in 2D.

args: geom, distance - Window function that returns a cluster id for each input geometry, clustering using separation distance.

args: g1, pipeline, to_srid - Return a new geometry with coordinates transformed to a different spatial reference system using a defined coordinate transformation pipeline.

args: geom, tolerance = 0.0, extend_to = NULL - Returns the boundaries of the Voronoi diagram of the vertices of a geometry.

args: auth_token - Adds an authorization token to be used in the current transaction.

args: g1, g2 - Returns the 2D largest distance between two geometries in projected units.

args: input, blade - Returns a collection of geometries created by splitting a geometry by another geometry.

args: a_schema_name, a_table_name, a_geomfield_name - Returns the SRID defined for a geometry column.