Routines

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

args: catalog_name, schema_name, table_name, column_name, srid - Updates the SRID of all features in a geometry column, geometry_columns metadata and srid. If it was enforced with constraints, the constraints will be updated with new srid constraint. If the old was enforced by type definition, the type definition will be changed.

args: geomfield - Aggregate. Constructs an array 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: tab, col, factor, algo=‘NearestNeighbor’ - Create an reduced resolution version of a given raster coverage.

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 - Windowing function that returns integer id for the cluster each input geometry is in.

Returns PostGIS version number and compile-time options.

args: geomA - Returns (TRUE) if this Geometry has no anomalous geometric points, such as self intersection or self tangency.

args: version, geog, maxdecimaldigits=15, options=0, nprefix=null, id=null - Return the geometry as a GML version 2 or 3 element.

args: g1, distance, azimuth - Returns a POINT projected from a start point using a distance in meters and bearing (azimuth) in radians.

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

args: polyline, precision=5 - Creates a LineString from an Encoded Polyline.

args: rast, skewx, skewy, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by adjusting only its skew (or rotation parameters). New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor.

args: WKT, srid - Makes a Geometry from WKT representation with the given SRID. If SRID is not given, it defaults to 0.

args: rast - Returns basic meta data about a raster object such as pixel size, rotation (skew), upper, lower left, etc.

args: WKB - Return a specified ST_Geometry value from Well-Known Binary representation (WKB). This is an alias name for ST_GeomFromWKB that takes no srid

args: geom - If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, for single geometries will return 1, otherwise return NULL.

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: geomA, n - Return the 1-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON, POLYHEDRALSURFACE Otherwise, return NULL.

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: WKT, srid - Makes a collection Geometry from collection WKT with the given SRID. If SRID is not given, it defaults to 0.

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, searchvalues=NULL, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer.

args: xmin, ymin, xmax, ymax, srid=unknown - Creates a rectangular Polygon formed from the given minimums and maximums. Input values must be in SRS specified by the SRID.

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: geohash, precision=full_precision_of_geohash - Return a point from a GeoHash string.

args: rast - Returns true if the raster is empty (width = 0 and height = 0). Otherwise, returns false.

args: rast, band=1, exclude_nodata_value=TRUE - Returns the polygon geometry that bounds every pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel.

args: wkb - Return a raster value from a Hex representation of Well-Known Binary (WKB) raster.

args: rast, outasin=FALSE - Return the Well-Known Binary (WKB) representation of the raster.

args: geomA - Returns the closure of the combinatorial boundary of this Geometry.

args: wkb - Return a raster value from a Well-Known Binary (WKB) raster.

args: EWKT - Return a specified geography value from Well-Known Text representation or extended (WKT).

args: rast - Returns the rotation of the raster in radian.

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

args: A, B - Returns true if the given geometries represent the same geometry. Directionality is ignored.

args: geomA, geomB - Returns TRUE if the Geometries “spatially intersect” in 3d - only for points, linestrings, polygons, polyhedral surface (area). With SFCGAL backend enabled also supports TINS

args: rast - Returns the height of the raster in pixels.

args: gj_version, geog, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element.

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

args: rast, scalex=0, scaley=0, gridx=NULL, gridy=NULL, skewx=0, skewy=0, algorithm=NearestNeighbor, maxerr=0.125 - Resample a raster using a specified resampling algorithm, new dimensions, an arbitrary grid corner and a set of raster georeferencing attributes defined or borrowed from another raster.

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true - Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage. Band 1 is assumed is no band is specified.

Upgrades installed postgis packaged extensions (e.g. postgis_sfcgal, postgis_topology, postgis_sfcgal) to latest installed version. Reports full postgis version and build configuration infos after.

args: rast - Returns the upper left X coordinate of raster in projected spatial ref.

args: g1, maxdecimaldigits=15, options=0 - Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML

args: rast - Returns the upper left Y coordinate of raster in projected spatial ref.

args: rast, outasin=FALSE - Return the Well-Known Binary (WKB) in Hex representation of the raster.

args: rast, band=1, exclude_nodata_value=TRUE - Returns the centroid (point geometry) for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The point geometry is the centroid of the area represented by a pixel.

args: rast, band, outdbindex, force=false - Update the external band number of an out-db band

args: OUT idx, OUT short_name, OUT long_name, OUT can_read, OUT can_write, OUT create_options - Returns a list of raster formats supported by PostGIS through GDAL. Only those formats with can_write=True can be used by ST_AsGDALRaster

args: schema_name, table_name, column_name, new_srid - Change the SRID of all rasters in the user-specified column and table.

args: geomA - Returns the first point of a LINESTRING geometry as a POINT.

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 2-dimensional shortest line between two geometries

args: rast, band=1 - Sets the isnodata flag of the band to TRUE.

args: geometries, unique_ids, decimaldigits_xy=0, decimaldigits_z=0, decimaldigits_m=0, include_sizes=false, include_bounding_boxes=false - Returns the geometry as TWKB, aka “Tiny Well-Known Binary”

args: wkb - Creates a geography instance from a Well-Known Binary geometry representation (WKB) or extended Well Known Binary (EWKB).

args: a_polygon - Return the number of interior rings of a polygon geometry.

args: rast, bandnum=1 - Returns system file path to a band stored in file system. If no bandnum specified, 1 is assumed.

args: catalog_name, schema_name, table_name, column_name, srid, type, dimension, use_typmod=true - Adds a geometry column to an existing table of attributes. By default uses type modifier to define rather than constraints. Pass in false for use_typmod to get old check constraint based behavior

args: rast, srid - Sets the SRID of a raster to a particular integer srid defined in the spatial_ref_sys table.

args: rast - Returns the number of bands in the raster object.

args: geom, eps, minpoints - Windowing function that returns integer id for the cluster each input geometry is in based on 2D implementation of Density-based spatial clustering of applications with noise (DBSCAN) algorithm.

args: geom - Like ST_Union, but working at the geometry component level.

args: geomkml - Takes as input KML representation of geometry and outputs a PostGIS geometry object

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: rastA, nbandA, rastB, nbandB - Return true if raster rastA and rastB intersect but one does not completely contain the other.

args: rastA, nbandA, rastB, nbandB - Return true if rastB intersects the interior of rastA but not the boundary or exterior of rastA.

args: a_3dlinestring - Returns the 3-dimensional or 2-dimensional length of the geometry if it is a linestring or multi-linestring.

args: g, npoints - 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: geog, use_spheroid=true - Returns the area of the surface if it is a Polygon or MultiPolygon. For geometry, a 2D Cartesian area is determined with units specified by the SRID. For geography, area is determined on a curved surface with units in square meters.

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: ovschema, ovtable, ovcolumn, refschema, reftable, refcolumn, ovfactor - Tag a raster column as being an overview of another.

args: WKT, srid - Makes a point Geometry from WKT with the given SRID. If SRID is not given, it defaults to unknown.

args: WKT, srid - Return a specified ST_Geometry value from Well-Known Text representation (WKT).

args: geomA, n - Return the 1-based Nth geometry (face) if the geometry is a POLYHEDRALSURFACE, POLYHEDRALSURFACEM. Otherwise, return NULL.

args: rast, columnx, rowy - Returns a point geometry of the pixels upper-left corner.

args: geomA, rotRadians, x0, y0 - Rotate a geometry rotRadians counter-clockwise about an origin.

args: intersectionMatrix, intersectionMatrixPattern - Returns true if intersectionMattrixPattern1 implies intersectionMatrixPattern2

args: geomA - Returns true if a geometry or geometry collection contains a circular string

args: rast, gridx, gridy, scalex, scaley, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by snapping it to a grid. New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor.

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

args: a_point, center_x, center_y, radius - Is the point geometry inside the circle defined by center_x, center_y, radius

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

Enable long transaction support. This function creates the required metadata tables, needs to be called once before using the other functions in this section. Calling it twice is harmless.

args: WKB, srid - Makes a LINESTRING from WKB with the given SRID

args: pointLowLeft, pointUpRight - Creates a BOX2D defined by the given point geometries.

args: g1, radius_of_buffer, buffer_style_parameters - (T)Returns a geometry covering all points within a given distancefrom the input geometry.

args: rast, percentwidth, percentheight, algorithm=NearestNeighbor, maxerr=0.125 - Resize a raster to a new width/height

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, bins=autocomputed, width=NULL, right=false - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified.

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

args: rast, xcolumn, yrow - Returns the geometric X coordinate upper left of a raster, column and row. Numbering of columns and rows starts at 1.

args: rast, bandnum=1 - Returns the value in a given band that represents no data. If no band num 1 is assumed.

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: version, geog, maxdecimaldigits=15, nprefix=NULL - Return the geometry as a KML element. Several variants. Default version=2, default maxdecimaldigits=15

args: schema_name, table_name, geocolumn_name, parent_ony - Return the estimated extent of the given spatial table. The estimated is taken from the geometry columns statistics. The current schema will be used if not specified.

args: gdaldata, srid=NULL - Returns a raster from a supported GDAL raster file.

args: A, B - Returns true if the given geometries represent the same geometry and points are in the same directional order.

args: relation_oid, use_typmod=true - Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints This ensures they will be registered correctly in geometry_columns view. By default will convert all geometry columns with no type modifier to ones with type modifiers. To get old behavior set use_typmod=false

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

args: g1 - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.

args: rastA, nbandA, rastB, nbandB, distance_of_srid - Return true if rasters rastA and rastB are within the specified distance of each other.

args: rast - Returns a text summary of the contents of the raster.

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

Reports full raster library build date.

args: g - The inherent dimension of this Geometry object, which must be less than or equal to the coordinate dimension.

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

args: g1, g2 - For geometry type Returns the 3-dimensional 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: rast - Returns the amount of space (in bytes) the raster takes.

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

args: a_polygon - Returns a set of geometry_dump rows, representing the exterior and interior rings of a polygon.

args: rast - Returns the georeference X skew (or rotation parameter).

args: rast - Returns the georeference Y skew (or rotation parameter).

args: rast, band, x, y, exclude_nodata_value=true - Returns the value of a given band in a given columnx, rowy pixel or at a particular geometric point. Band numbers start at 1 and assumed to be 1 if not specified. If exclude_nodata_value is set to false, then all pixels include nodata pixels are considered to intersect and return value. If exclude_nodata_value is not passed in then reads it from metadata of raster.

args: rast, bandnum, columnX, rowY, distanceX, distanceY, exclude_nodata_value=true - Returns a 2-D double precision array of the non-NODATA values around a given bands pixel specified by either a columnX and rowY or a geometric point expressed in the same spatial reference coordinate system as the raster.

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

args: g1, NDR_or_XDR - Return the Well-Known Binary (WKB) representation of the geometry with SRID meta data.

args: rast - Returns the spatial reference identifier of the raster as defined in spatial_ref_sys table.

args: rast, band, outdbpath, outdbindex, force=false - Update the external path and band number of an out-db band

args: rast, x, y - Returns the centroid (point geometry) of the area represented by a pixel.

args: rast, bandnum, columnx, rowy, newvalue - Returns modified raster resulting from setting the value of a given band in a given columnx, rowy pixel or the pixels that intersect a particular geometry. Band numbers start at 1 and assumed to be 1 if not specified.

args: g1, NDRorXDR - Returns a Geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding.

args: rastA, nbandA, rastB, nbandB, distance_of_srid - Return true if rasters rastA and rastB are fully within the specified distance of each other.

args: rast, rotation - Set the rotation of the raster in radian.

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

args: outerlinestring, interiorlinestrings - Creates a Polygon formed by the given shell. Input geometries must be closed LINESTRINGS.

args: geomfield - an aggregate function that returns the box3D 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.

args: geohash, precision=full_precision_of_geohash - Return a geometry from a GeoHash string.

args: row, name, extent, geom_name - Return a Mapbox Vector Tile representation of a set of rows.

args: EWKB - Return a specified ST_Geometry value from Extended Well-Known Binary representation (EWKB).

args: rast, columnx, rowy - Returns the polygon geometry that bounds the pixel for a particular row and column.

args: geog, use_spheroid=true - Returns the 2D length of the geometry if it is a LineString or MultiLineString. geometry are in units of spatial reference and geography are in meters (default spheroid)

Returns version of the postgis scripts installed in this database.

args: rast, nband, exclude_nodata_value, sample_percent - Aggregate. Returns the number of pixels in a given band of a set of rasters. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the NODATA value.

args: EWKT - Return a specified ST_Geometry value from Extended Well-Known Text representation (EWKT).

args: geom, bounds, extent=4096, buffer=256, clip_geom=true - Transform a geometry into the coordinate space of a Mapbox Vector Tile.

args: EWKT - Return a specified geography value from Well-Known Text representation or extended (WKT).

args: geomjson - Takes as input a geojson representation of a geometry and outputs a PostGIS geometry object

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: rast - Returns the pixel height in geometric units of the spatial reference system.

args: geom - Returns true if all exterior rings are oriented clockwise and all interior rings are oriented counter-clockwise.

args: a_polygon, n - Return the Nth interior linestring ring of the polygon geometry. Return NULL if the geometry is not a polygon or the given N is out of range.

args: a_point - Return the M coordinate of the point, or NULL if not available. Input must be a point.

args: WKT - Return a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText

args: rast, xcolumn, yrow - Returns the geometric Y coordinate upper left corner of a raster, column and row. Numbering of columns and rows starts at 1.

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

args: x, y, m - Creates a point geometry with an x y and m coordinate.

args: rastA, nbandA, rastB, nbandB - Return true if raster rastA and rastB have at least one point in common but their interiors do not intersect.

args: geomA, flags - Returns text stating if a geometry is valid or not and if not valid, a reason why.

args: geomlonlatA, geomlonlatB, measurement_spheroid - Returns the minimum distance between two lon/lat geometries given a particular spheroid. PostGIS versions prior to 1.5 only support points.

args: aGeomorBox2DorBox3D - Returns Z minima of a bounding box 2d or 3d 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 - Return the Z coordinate of the point, or NULL if not available. Input must be a point.

args: a_point - Return the Y coordinate of the point, or NULL if not available. Input must be a point.

args: a_point - Return the X coordinate of the point, or NULL if not available. Input must be a point.

args: WKT, srid - Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0.

args: g1, g2 - Returns the 3-dimensional 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: g1, g2, distance_of_srid - For 3d (z) geometry type Returns true if two geometries 3d distance is within number of units.

args: geohash, precision=full_precision_of_geohash - Return a BOX2D from a GeoHash string.

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

args: rast, nbands, options, srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified or any of specified bands does not exist in the raster, then will try to use all bands.

args: rast, upperleftx, upperlefty, scalex, scaley, skewx, skewy - Set Georeference 6 georeference parameters in a single call. Numbers should be separated by white space. Accepts inputs in GDAL or ESRI format. Default is GDAL.

args: rastA, nbandA, rastB, nbandB - Return true if no points of raster rastA lie outside raster rastB.

args: rast, outasin=FALSE - Return the Well-Known Binary (WKB) representation of the raster.

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: rast, nband, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value.

Returns the version number of the GEOS library.

args: rast, scalex, scaley, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by adjusting only its scale (or pixel size). New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor.

args: rast, x, y - Sets the X and Y size of pixels in units of coordinate reference system. Number units/pixel width/height.

args: geom - Returns a set of geometry_dump (geom,path) rows of all points that make up a geometry.

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

args: rast, nbands, delimiter=, - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.

args: geom, dx, dy, dz=0, dm=0 - Returns bounding box expanded in all directions from the bounding box of the input geometry. Uses double-precision

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

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

args: g - Returns TRUE if the argument is a collection (MULTI*, GEOMETRYCOLLECTION, …)

args: geog, rel=0, maxdecimaldigits=15 - Returns a Geometry in SVG path data given a geometry or geography object.

Disable long transaction support. This function removes the long transaction support metadata tables, and drops all triggers attached to lock-checked tables.

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

args: rast, nbands, options=NULL - Return the raster tile selected bands as a single Joint Photographic Exports Group (JPEG) image (byte array). If no band is specified and 1 or more than 3 bands, then only the first band is used. If only 3 bands then all 3 bands are used and mapped to RGB.

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

args: rastA, rastB - Returns text stating if rasters are aligned and if not aligned, a reason why.

args: WKT, srid - Makes a MultiPolygon Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0.

args: rast, band=1, exclude_nodata_value=TRUE - Returns a point geometry for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The coordinates of the point geometry are of the pixels upper-left corner.

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

args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true if the constraint setting was accomplished and issues a notice otherwise.

args: x_lon, y_lat - Returns an ST_Point with the given coordinate values. OGC alias for ST_MakePoint.

args: rastA, nbandA, rastB, nbandB - Return true if raster rastA spatially intersects raster rastB.

args: rastA, nbandA, rastB, nbandB - Return true if no points of raster rastA lie in the exterior of raster rastB and at least one point of the interior of rastA lies in the interior of rastB.

args: rastA, nbandA, rastB, nbandB - Return true if raster rastA does not spatially intersect rastB.

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

args: width, height, upperleftx, upperlefty, scalex, scaley, skewx, skewy, srid=unknown - Returns an empty raster (having no bands) of given dimensions (width & height), upperleft X and Y, pixel size and rotation (scalex, scaley, skewx & skewy) and reference system (srid). If a raster is passed in, returns a new raster with the same size, alignment and SRID. If srid is left out, the spatial ref is set to unknown (0).

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, quantiles=NULL - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile.

args: point1, point2, point3, point4 - 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 (geom,path) rows, that make up a geometry g1.

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: rastA, nbandA, rastB, nbandB - Return true if no points of raster rastB lie in the exterior of raster rastA and at least one point of the interior of rastB lies in the interior of rastA.

args: rast, band - Returns basic meta data for a specific raster band. band num 1 is assumed if none-specified.

args: g1, g2 - For geometry type Returns the 3-dimensional 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: geom, scalex, scaley, pixeltype, value=ARRAY1, nodataval=ARRAY0, upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster.

args: a_schema_name, a_table_name, a_row_key, an_auth_token, expire_dt - Set lock/authorization for specific row in table

args: WKT, srid - Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0.

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

args: a_polygon - Return the number of interior rings of a polygon in the geometry. Synonym for ST_NumInteriorRings.

args: rast, nbands, options=NULL - Return the raster tile selected bands as a single portable network graphics (PNG) image (byte array). If 1, 3, or 4 bands in raster and no bands are specified, then all bands are used. If more 2 or more than 4 bands and no bands specified, then only band 1 is used. Bands are mapped to RGB or RGBA space.

args: g1, g2, densifyFrac - Returns the Hausdorff distance between two geometries. Basically a measure of how similar or dissimilar 2 geometries are. Units are in the units of the spatial reference system of the geometries.

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

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

args: a_2dlinestring - Returns the 2-dimensional length of the geometry if it is a linestring or multi-linestring. This is an alias for ST_Length

args: geomA - Returns the 3-dimensional perimeter of the geometry, if it is a polygon or multi-polygon.

args: aGeomorBox2DorBox3D - Returns X maxima of a bounding box 2d or 3d 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: geom, precision=5 - Returns an Encoded Polyline from a LineString geometry.

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

args: ulx1, uly1, scalex1, scaley1, skewx1, skewy1, ulx2, uly2, scalex2, scaley2, skewx2, skewy2 - Returns true if rasters have same skew, scale, spatial ref, and offset (pixels can be put on same grid without cutting into pixels) and false if they dont with notice detailing issue.

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

args: rast, format, options=NULL, srid=sameassource - Return the raster tile in the designated GDAL Raster format. Raster formats are one of those supported by your compiled library. Use ST_GDALDrivers() to get a list of formats supported by your library.

args: rast, nband, width, height, padwithnodata=FALSE, nodataval=NULL - Returns a set of rasters resulting from the split of the input raster based upon the desired dimensions of the output rasters.

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

args: rast, bandnum=1 - Returns true if there is no band with given band number. If no band number is specified, then band number 1 is assumed.

args: rast, bandnum, columnx, rowy, exclude_nodata_value=true - Returns the nearest non-NODATA value of a given bands pixel specified by a columnx and rowy or a geometric point expressed in the same spatial reference coordinate system as the raster.

args: aGeomorBox2DorBox3D - Returns X minima of a bounding box 2d or 3d 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 - Rotate a geometry rotRadians about the Y axis.

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

args: auth_token - Remove all locks held by specified authorization id. Returns the number of locks released.

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

args: g1 - Return the number of points in an ST_LineString or ST_CircularString value.

args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.

args: g1, g2 - Returns the 3-dimensional 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 trajectories closest points of approachare within the specified distance.

args: rast, nband, exclude_nodata_value, sample_percent - Aggregate. Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a set of raster. Band 1 is assumed is no band is specified.

args: rast, longitude, latitude - Returns the upper left corner as column and row given geometric X and Y (longitude and latitude) or a point geometry expressed in the spatial reference coordinate system of the raster.

args: geom_mline, elevation_start, elevation_end - Return a derived geometry (collection) value with elements that intersect the specified range of elevations inclusively. Only 3D, 4D LINESTRINGS and MULTILINESTRINGS are supported.

args: geomA - Returns the 2-dimensional perimeter of the geometry, if it is a polygon or multi-polygon. This is currently an alias for ST_Perimeter.

Returns build date of the PostGIS scripts.

args: linestringA, linestringB - Given 2 linestrings, returns a number between -3 and 3 denoting what kind of crossing behavior. 0 is no crossing.

args: g1 - Returns coordinate dimension of the geometry as a small int. Values are: 2,3 or 4.

args: WKT, srid - Construct a MultiPolygon given an arbitrary collection of closed linestrings as a MultiLineString text representation Well-Known text representation.

args: rast, bandnum=1 - Returns the type of pixel for given band. If no bandnum specified, 1 is assumed.

args: rast, band, nodatavalue, forcechecking=false - Sets the value for the given band that represents no data. Band 1 is assumed if no band is specified. To mark a band as having no nodata value, set the nodata value = NULL.

args: g1, maxdecimaldigits=15 - Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.

args: rast - Returns the width of the raster in pixels.

args: rast, xcolumn, yrow - Returns the rasters upper left corner as geometric X and Y (longitude and latitude) given a column and row. Column and row starts at 1.

args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value.

args: a_linestring, n - Return the Nth point in the first LineString or circular LineString in the geometry. Negative values are counted backwards from the end of the LineString. Returns NULL if there is no linestring in the geometry.

args: rast - Returns the Y component of the pixel height in units of coordinate reference system.

args: rast - Returns the X component of the pixel width in units of coordinate reference system.

args: rast, bandnum=1 - Returns the file size of a band stored in file system. If no bandnum specified, 1 is assumed.

args: g1, g2, densifyFrac = -1 - Returns the Fréchet distance between two geometries. This is a measure of similarity between curves that takes into account the location and ordering of the points along the curves. Units are in the units of the spatial reference system of the geometries.

args: WKT, srid - Construct a Polygon given an arbitrary collection of closed linestrings as a MultiLineString Well-Known text representation.

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

args: g1, g2 - Return a specified ST_Geometry value from a collection of other geometries.

args: g - Returns TRUE if the LINESTRINGs start and end points are coincident. For Polyhedral surface is closed (volumetric).

args: g1 - Return the geometry type of the ST_Geometry value.

args: curveGeom, tolerance, tolerance_type, flags - Converts a CIRCULARSTRING/CURVEPOLYGON/MULTISURFACE to a LINESTRING/POLYGON/MULTIPOLYGON

args: twkb - Creates a geometry instance from a TWKB (“Tiny Well-Known Binary”) geometry representation.

args: geom, srid - Makes a geometry from WKB with the given SRID

args: g1 - Return the number of points (vertexes) in a geometry.

args: g1, g2, distance - Returns true if all of the 3D geometries are within the specified distance of one another.

args: rast, bandnum=1 - Returns the file timestamp of a band stored in file system. If no bandnum specified, 1 is assumed.

args: g - Returns TRUE if this LINESTRING is both 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: rast, format=GDAL - Returns the georeference meta data in GDAL or ESRI format as commonly seen in a world file. Default is GDAL.

args: geog, use_spheroid=true - Return the length measurement of the boundary of an ST_Surface or ST_MultiSurface geometry or geography. (Polygon, MultiPolygon). geometry measurement is in units of spatial reference and geography is in meters.

args: pt, format=’ - Return the Degrees, Minutes, Seconds representation of the given point.

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: WKT, srid - Return a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText

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

args: geomlonlatA, geomlonlatB - Returns minimum distance in meters between two lon/lat geometries. Uses a spherical earth and radius derived from the spheroid defined by the SRID. Faster than ST_DistanceSpheroid , but less accurate. PostGIS versions prior to 1.5 only implemented for points.

args: rast, nband, columnx, rowy, width, height, newvalue, keepnodata=FALSE - Returns modified raster resulting from setting the values of a given band.

args: rast, srid, scalex, scaley, algorithm=NearestNeighbor, maxerr=0.125 - Reprojects a raster in a known spatial reference system to another known spatial reference system using specified resampling algorithm. Options are NearestNeighbor, Bilinear, Cubic, CubicSpline, Lanczos defaulting to NearestNeighbor.

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

args: rastA, nbandA, rastB, nbandB - Return true if no points of raster rastB lie outside raster rastA.

args: gg1, gg2, use_spheroid - For geometry type returns the 2D Cartesian distance between two geometries in projected units (based on spatial reference system). For geography type defaults to return minimum geodesic distance between two geographies in meters.

args: geomA - Force the geometries into XYM mode.

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

args: geomA - If the geometry is a polygon or multi-polygon returns the number of rings.

args: WKT, srid - Return a specified ST_MultiLineString value from WKT representation.

args: g1, g2 - Returns TRUE if the supplied geometries have some, but not all, interior points in common.

args: rast, outdbfile, outdbindex, index=at_end, nodataval=NULL - Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end.

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 the ST_Geometry value.

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: rast, band, forceChecking=true - Returns true if the band is filled with only nodata values.

args: a_geometry, a_spheroid - Calculates the 2D length/perimeter of a geometry on an ellipsoid. This is useful if the coordinates of the geometry are in longitude/latitude and a length is desired without reprojection.

args: rast, skewx, skewy - Sets the georeference X and Y skew (or rotation parameter). If only one is passed in, sets X and Y to the same value.

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

args: geom - Returns true if all exterior rings are oriented counter-clockwise and all interior rings are oriented clockwise.

Reports full raster version and build configuration infos.

args: a_geometry, a_spheroid - Calculates the 2D or 3D length/perimeter of a geometry on an ellipsoid. This is useful if the coordinates of the geometry are in longitude/latitude and a length is desired without reprojection.

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: tab, col, ext, sfx, sfy, tw, th, algo=‘NearestNeighbor’ - Return a set of configured tiles from an arbitrarily tiled raster coverage.

args: g - Returns the last point of a LINESTRING or CIRCULARLINESTRING geometry as a POINT.

args: g1, g2 - Returns the 2-dimensional longest line points of two geometries. The function will only return the first longest line if more than one, that the function finds. The line returned will always start in g1 and end in g2. The length of the line this function returns will always be the same as st_maxdistance returns for g1 and g2.

Reports the version of the GDAL library in use by PostGIS.

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

args: geomA, geomB, intersectionMatrixPattern - Returns true if this Geometry is spatially related to anotherGeometry, by testing for intersections between the Interior, Boundary and Exterior of the two geometries as specified by the values in the intersectionMatrixPattern. If no intersectionMatrixPattern is passed in, then returns the maximum intersectionMatrixPattern that relates the 2 geometries.

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

args: rast, nband=NULL, exclude_nodata_value=true - Get the values of the specified band as a 2-dimension array.

args: rast - Returns the pixel width in geometric units of the spatial reference system.

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: ovschema, ovtable, ovcolumn - Untag a raster column from being an overview of another.

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

args: geom1, geom2 - Creates a Linestring from point, multipoint, or line geometries.

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

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

args: geomgml, srid - Return a specified ST_Geometry value from GML representation. This is an alias name for ST_GeomFromGML

args: geomA - Returns ZM (dimension semantic) flag of the geometries as a small int. Values are: 0=2d, 1=3dm, 2=3dz, 3=4d.

args: rast, xw, yw - Returns the row in the raster of the point geometry (pt) or a X and Y world coordinate (xw, yw) represented in world spatial reference system of raster.

args: point3DLowLeftBottom, point3DUpRightTop - Creates a BOX3D defined by the given 3d point geometries.

Returns the version number of the PostGIS library.

args: WKB, srid - Makes a geometry from WKB with the given SRID.

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: rast, xw, yw - Returns the column in the raster of the point geometry (pt) or a X and Y world coordinate (xw, yw) represented in world spatial reference system of raster.

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

Reports full postgis version and build configuration infos.

args: row, geom_name - Return a Geobuf representation of a set of rows.

args: a_polygon - Returns a line string representing the exterior ring of the POLYGON geometry. Return NULL if the geometry is not a polygon. Will not work with MULTIPOLYGON

args: geomgml, srid - Takes as input GML representation of geometry and outputs a PostGIS geometry object

args: g, flags - Returns true if the ST_Geometry is well formed.

args: rast, x, y - Sets the value of the upper left corner of the pixel of the raster to projected X and Y coordinates.

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 - Add an authorization token to be used in current transaction.

args: tilewidth, tileheight, width, height, upperleftx, upperlefty, scalex, scaley, skewx, skewy, srid=unknown - Cover georeferenced area with a grid of empty raster tiles.

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

args: g1, g2 - Returns the 2-dimensional 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 - The syntax is find_srid(a_db_schema, a_table, a_column) and the function returns the integer SRID of the specified column by searching through the GEOMETRY_COLUMNS table.