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 - Given a geometry collection, return the “simplest” representation of the contents.

args: a_linestring, startfraction, endfraction - Return a linestring being a substring of the input one starting and ending at the given fractions of total 2d length. Second and third arguments are float8 values between 0 and 1.

args: geom, tolerance - Returns a version of the given geometry with duplicated points removed.

args: geomA - Convert the geometry into a GEOMETRYCOLLECTION.

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

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

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, distance, azimuth - Returns a point projected from a start point by a distance and bearing (azimuth).

args: a_linestring, a_fraction, repeat - Returns one or more points interpolated along a line.

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

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

args: geomA, geomB - Returns a geometry that represents the portions of A and B that do not intersect. It is called a symmetric difference because ST_SymDifference(A,B) = ST_SymDifference(B,A).

args: tileZoom, tileX, tileY, bounds=SRID=3857;LINESTRING(-20037508.342789 -20037508.342789,20037508.342789 20037508.342789) - 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 the given geometry using the Chaikin algorithm

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

args: geomA, num_segs_per_qt_circ=48 - Returns the smallest circle polygon that can fully contain a geometry. Default uses 48 segments per quarter circle.

args: geomA - Tests if a geometry is empty.

args: geomA - Returns the boundary of a geometry.

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

args:
g
,
tolerance
,
max_iter
,
fail_if_not_converged
- Returns the geometric median of a MultiPoint.

Packages and upgrades postgis extensions (e.g. postgis_raster,postgis_topology, postgis_sfcgal) to latest available version.

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

args: geomA - Toggle geometry coordinates between -180..180 and 0..360 ranges.

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

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

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 - Like ST_Union, but working at the geometry component level.

args: amultilinestring - Return a (set of) LineString(s) formed by sewing together a MULTILINESTRING.

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

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

args: g, npoints, seed - Converts a polygon or multi-polygon into a multi-point composed of randomly location points within the original areas.

args: A - Creates an areal geometry formed by the constituent linework of given geometry

args: geomA, threshold = 0, set_area = 1 - Sets the effective area for each vertex, storing the value in the M ordinate. A simplified geometry can then be generated by filtering on the M ordinate.

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: geomA, pointOrigin, sizeX, sizeY, sizeZ, sizeM - Snap all points of the input geometry to a regular grid.

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

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 - Return a derived geometry with measure elements linearly interpolated between the start and end points.

args: geom - Returns a minimum rotated rectangle enclosing a geometry.

args: table_name, geocolumn_name - Return 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: line, point - Return the value of the measure dimension of a geometry at the point closed to the provided 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 the given geometry using the Visvalingam-Whyatt algorithm

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 - Returns a POINT guaranteed to lie on the surface.

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: 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 - an aggregate function that returns the 3D bounding box that bounds rows 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: g1 - 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: geomA - Returns text stating if a geometry is valid, or a reason for invalidity.

args: geomlonlatA, geomlonlatB, measurement_spheroid - Returns the minimum distance between two lon/lat geometries using a spheroidal earth model.

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

args: a_linestring, a_point - Returns a float between 0 and 1 representing the location of the closest point on LineString to the given Point, as a fraction of total 2d line length.

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 (multi)geometry, return a (multi)geometry consisting only of elements of the specified type.

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

args: geomA, tolerance - Returns a “simplified” version of the given geometry using the Douglas-Peucker algorithm. Will avoid creating derived geometries (polygons in particular) that are invalid.

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 points in a geometry.

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

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

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

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 point from a linestring.

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

args: x, y - Creates a Point with the given coordinate values. Alias for ST_MakePoint.

args: geom, measure_start, measure_end, offset - Return a derived geometry collection value with elements that match the specified range of measures inclusively.

args: line1, line2 - Returns the angle between 3 points, or between 2 vectors (4 points or 2 lines).

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

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

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

args: geom_array - Aggregate. Creates a GeometryCollection containing possible polygons formed from the constituent linework of a set of geometries.

args: geomA, geomB - Returns a geometry that represents that part of geometry A that does not intersect with geometry B.

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=’ - Return an offset line at a given distance and side from an input line. Useful for computing parallel lines about a center line

args: geom, max_vertices=256 - Returns a set of geometry where no geometry in the set has more than the specified number of vertices.

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: 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: pointA, pointB - Returns the north-based azimuth as the angle in radians measured clockwise from the vertical on pointA to pointB.

Returns build date of the PostGIS library.

args: geom, min, max = null, returnM = false - Filters vertex points based on their m-value

args: geom - Node a set of linestrings.

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

args: geomfield - an aggregate function that returns the bounding box that bounds rows of geometries.

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 - Same as ST_Union, only memory-friendly (uses less memory and more processor time).

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, maxdist - Returns true if the closest point of approach of two trajectoriesis within the specified distance.

args: geom, elevation_start, elevation_end - Return a derived geometry (collection) value with elements that intersect the specified range of elevations inclusively.

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: a_linestring, n - Returns the Nth point in the first LineString or circular LineString 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 CIRCULARSTRING/CURVEPOLYGON/MULTISURFACE to a LINESTRING/POLYGON/MULTIPOLYGON

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

args: g1_array - Returns a geometry that represents the point set union of the Geometries.

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

args: ageom_with_measure, a_measure, offset - Return a derived geometry collection value with elements that match the specified measure. Polygonal elements are not supported.

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

args: a_linestring, a_fraction - Returns a point interpolated along a line in 3D. Second argument is a float8 between 0 and 1 representing fraction of total length of linestring the point has to be located.

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

args: geomlonlatA, geomlonlatB - Returns minimum distance in meters between two lon/lat geometries using a spherical earth model.

args: geom, from_proj, to_srid - Return a new geometry with its 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 - 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: geomA - Force the geometries into XYZ mode.

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

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

args: geomA - Force the geometries into XYZM mode.

args: geomANoncircular - Converts a LINESTRING/POLYGON to a CIRCULARSTRING, CURVEPOLYGON

Returns the version number of the libxml2 library.

args: track1, track2 - Returns the measure at which points interpolated along two trajectories are closest.

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 - Return the geometry in its canonical form.

args: geomA, target_percent, allow_holes=false - The concave hull of a geometry represents a possibly concave geometry that encloses all geometries within the set. You can think of it as shrink wrapping.

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

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

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

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

args: g1, tolerance, flags - Return a Delaunay triangulation around the given input points.

args: geom - Returns a version of the given geometry with X and Y axis flipped. Useful for people who have built latitude/longitude features and need to fix them.

args: geom - Returns the center point and radius of the smallest circle that can fully contain 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: 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: geomA, version - Force the geometries to use SFS 1.1 geometry types only.

args: g1, tolerance, extend_to - Returns the cells of the Voronoi diagram constructed from the vertices of a geometry.

args: geom, flags - Returns a valid_detail row stating if a geometry is valid, and if not a reason why 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: g1, tolerance, extend_to - Returns the boundaries between the cells of the Voronoi diagram constructed from 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 point on g1 that is closest to g2. This is the first point of the shortest line.

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

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

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