Routines

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

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

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

args: box, units_to_expand - Returns a bounding box expanded from another bounding box or a geometry.

args: schema_name, table_name, geocolumn_name, parent_only - Return the estimated extent of a spatial table.

Returns build date of the PostGIS scripts.

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

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

args: pointA, pointB - Returns the north-based azimuth as the angle in radians measured clockwise from the vertical on pointA to pointB.

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

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

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

args: geog, use_spheroid=true - Returns the area of a polygonal geometry.

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

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

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

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

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

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

args: g, distance - Aggregate function that clusters the input geometries by separation distance.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

args: g1 - Returns the spatial reference identifier for the ST_Geometry as defined in spatial_ref_sys table.

args: geom, srid - Set the SRID on a geometry to a particular integer value.

Returns the version number of the internal Wagyu library.

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

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

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

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

args: collection - Given a geometry collection, return the “simplest” representation of the contents.

args: g1 - Returns the area of a polygonal geometry.

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

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

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

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

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: aGeomorBox2DorBox3D - Returns the Y maxima of a 2D or 3D bounding box or a geometry.

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

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

args: linestring - Creates a Polygon from a shell and optional list of holes.

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

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

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

args: g1, srid - Return a new geometry with its coordinates transformed to a different spatial reference system.

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

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

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

Reports full postgis version and build configuration infos.

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

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

args: a_table_name, a_row_key, an_auth_token, expire_dt - Sets lock/authorization for a row in a table.

args: geomA, XFactor, YFactor, ZFactor - Scales a geometry by given factors.

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

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

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

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

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

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

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

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

args: geomA - Returns the type of a geometry as text.

Returns the version number of the PROJ4 library.

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

args: g1, radius_of_buffer, buffer_style_parameters = ’ - Returns a geometry covering all points within a given distance from a geometry.

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

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

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

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

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

args: g1, radius_of_buffer, buffer_style_parameters - Returns a geometry covering all points within a given distance from a geometry.

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

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

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

args: collection, type - Given a (multi)geometry, return a (multi)geometry consisting only of elements of the specified type.

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

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

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

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

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

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

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

args: geog1, geog2, use_spheroid=true - Returns the distance between two geometry or geography values.

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

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

args: a_schema_name, 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: table_name - Drops a table and all its references in geometry_columns.

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

args: pointA, pointB - Returns the north-based azimuth as the angle in radians measured clockwise from the vertical on pointA to pointB.

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

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

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

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

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

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: x, y - Creates a 2D, 3DZ or 4D Point.

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

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: a_table_name, a_row_key, an_auth_token - Sets lock/authorization for a row in a table.

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

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

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

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

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

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

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

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: geomA - Returns a BOX3D representing the 3D extent of the geometry.

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

args: g1, g2 - Creates a GeometryCollection or Multi* geometry from a set of geometries.

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

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

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

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

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

args: geomA, a, b, c, d, e, f, g, h, i, xoff, yoff, zoff - Apply a 3D affine transformation to a geometry.

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

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

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

args: g1, radius_of_buffer, num_seg_quarter_circle - Returns a geometry covering all points within a given distance from a geometry.

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

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

args: geomA, XFactor, YFactor - Scales a geometry by given factors.

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

args: g1_array - Returns a geometry representing the point-set union of the input geometries.

args: collection - Given a (multi)geometry, return a (multi)geometry consisting only of elements of the specified type.

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

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

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

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

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

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

args: g1field - Returns a geometry representing the point-set union of the input geometries.

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

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

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

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

args: geom1, geom2 - Creates a Linestring from Point, MultiPoint, or LineString geometries.

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

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

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

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

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: relation_oid, use_typmod=true - Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints.

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

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

args: g1 - Returns the length of the boundary of a polygonal geometry or geography.

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

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

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: geom - Orients all exterior rings counter-clockwise and all interior rings clockwise.

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

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: geom_array - Computes a collection of polygons formed from the linework of a set of geometries.

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

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

args: geogA, geogB - Returns a geometry representing the shared portion of geometries A and B.

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

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

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

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

args: g1, g2 - Returns the distance between two geometry or geography values.

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: a_polygon, n - Returns the Nth interior ring (hole) of a Polygon.

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

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

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

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

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

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

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

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

args: g1, radius_of_buffer, num_seg_quarter_circle - Returns a geometry covering all points within a given distance from a geometry.

Returns the version number of the libxml2 library.

args: g1 - Returns the geometric center of a geometry.

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: geom, eps, minpoints - Window function that returns a cluster id for each input geometry using the DBSCAN algorithm.

Returns build date of the PostGIS library.

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

args: g1, g2, gridSize - Returns a geometry representing the point-set union of the input geometries.

Disables long transaction support.

Returns the version number of the GEOS library.

Returns version of the postgis scripts installed in this database.

args: geom, units_to_expand - Returns a bounding box expanded from another bounding box or a geometry.

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

args: point1, point2, point3, point4 - Returns the angle between 3 points, or between 2 vectors (4 points or 2 lines).

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

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

args: geomA - Returns a BOX2D representing the 2D extent of the geometry.

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

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

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

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

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

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

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

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

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

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

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

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 - Returns the number of points in a LineString or CircularString.

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

args: track1, track2, maxdist - Returns true if the closest point of approach of two trajectoriesis within the specified distance.

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

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

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

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

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

args: g1, g2 - Returns a geometry representing the point-set union of the input geometries.

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

args: geog, use_spheroid=true - Returns the 2D length of a linear geometry.

args: box, units_to_expand - Returns a bounding box expanded from another bounding box or a geometry.

args: geomA, geomB, gridSize = -1 - Returns a geometry representing the shared portion of geometries A and B.

args: line, point - Return the value of the measure dimension of a geometry at the point closed to the provided point.

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

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

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

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

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

args: geomA - Returns the boundary of a geometry.

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

args: g - Aggregate function that clusters the input geometries into connected sets.

Returns the version number of the PostGIS library.

args: geom - Nodes a collection of lines.

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

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

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

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

args: geomA - Add bounding box to the geometry.

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

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

Enables long transaction support.

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

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

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

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

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

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

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

args: geom_mline, measure_start, measure_end - Return a derived geometry with measure elements linearly interpolated between the start and end points.

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

args: geomA - Tests if a geometry is empty.

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

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

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: g1field - Creates a GeometryCollection or Multi* geometry from a set of geometries.

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

Returns PostGIS version number and compile-time options.

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

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

args: geomA - Convert the geometry into a GEOMETRYCOLLECTION.

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

args: g1, use_spheroid=true - Returns the geometric center of a geometry.

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

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

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

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

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

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

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

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

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

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

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

args: geom, target_percent, allow_holes = false - Computes a possibly concave geometry that encloses all input geometry vertices

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

args: geomA, size - Snap all points of the input geometry to a regular grid.

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

args: a_schema_name, a_table_name, a_row_key, an_auth_token, expire_dt - Sets lock/authorization for a row in a table.

args: geomA, originX, originY, sizeX, sizeY - Snap all points of the input geometry to a regular grid.

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

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

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

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