Chapter 13. PostGIS Special Functions Index
Prev     Next

Chapter 13. PostGIS Special Functions Index

Table of Contents

13.1. PostGIS Aggregate Functions

The functions below are spatial aggregate functions that are used in the same way as SQL aggregate function such as sum and average.

  • CG_3DUnion - Perform 3D union using postgis_sfcgal.
  • ST_3DExtent - Aggregate function that returns the 3D bounding box of geometries.
  • ST_3DUnion - Perform 3D union.
  • ST_AsFlatGeobuf - Return a FlatGeobuf representation of a set of rows.
  • ST_AsGeobuf - Return a Geobuf representation of a set of rows.
  • ST_AsMVT - Aggregate function returning a MVT representation of a set of rows.
  • ST_ClusterDBSCAN - Window function that returns a cluster id for each input geometry using the DBSCAN algorithm.
  • ST_ClusterIntersecting - Aggregate function that clusters input geometries into connected sets.
  • ST_ClusterIntersectingWin - Window function that returns a cluster id for each input geometry, clustering input geometries into connected sets.
  • ST_ClusterKMeans - Window function that returns a cluster id for each input geometry using the K-means algorithm.
  • ST_ClusterWithin - Aggregate function that clusters geometries by separation distance.
  • ST_ClusterWithinWin - Window function that returns a cluster id for each input geometry, clustering using separation distance.
  • ST_Collect - Creates a GeometryCollection or Multi* geometry from a set of geometries.
  • ST_CoverageInvalidEdges - Window function that finds locations where polygons fail to form a valid coverage.
  • ST_CoverageSimplify - Window function that simplifies the edges of a polygonal coverage.
  • ST_CoverageUnion - Computes the union of a set of polygons forming a coverage by removing shared edges.
  • ST_Extent - Aggregate function that returns the bounding box of geometries.
  • ST_MakeLine - Crea una cadena de línea desde geometrías de punto, multipunto o de línea.
  • ST_MemUnion - Aggregate function which unions geometries in a memory-efficent but slower way
  • ST_Polygonize - Computes a collection of polygons formed from the linework of a set of geometries.
  • ST_SameAlignment - 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 don't with notice detailing issue.
  • ST_Union - Computes a geometry representing the point-set union of the input geometries.
  • ST_Union - Returns the union of a set of raster tiles into a single raster composed of 1 or more bands.
  • TopoElementArray_Agg - Devuelve un topoelementarray para un conjunto de element_id, matriz de tipo (topoelements).

13.2. PostGIS Window Functions

The functions below are spatial window functions that are used in the same way as SQL window functions such as row_number(), lead(), and lag(). They must be followed by an OVER() clause.

  • ST_ClusterDBSCAN - Window function that returns a cluster id for each input geometry using the DBSCAN algorithm.
  • ST_ClusterIntersectingWin - Window function that returns a cluster id for each input geometry, clustering input geometries into connected sets.
  • ST_ClusterKMeans - Window function that returns a cluster id for each input geometry using the K-means algorithm.
  • ST_ClusterWithinWin - Window function that returns a cluster id for each input geometry, clustering using separation distance.
  • ST_CoverageInvalidEdges - Window function that finds locations where polygons fail to form a valid coverage.
  • ST_CoverageSimplify - Window function that simplifies the edges of a polygonal coverage.

13.3. PostGIS SQL-MM Compliant Functions

The functions given below are PostGIS functions that conform to the SQL/MM 3 standard

  • CG_3DArea - Computes area of 3D surface geometries. Will return 0 for solids.
  • CG_3DDifference - Perform 3D difference
  • CG_3DIntersection - Perform 3D intersection
  • CG_3DUnion - Perform 3D union using postgis_sfcgal.
  • CG_Volume - Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.
  • ST_3DArea - Computes area of 3D surface geometries. Will return 0 for solids.
  • ST_3DDWithin - Tests if two 3D geometries are within a given 3D distance
  • ST_3DDifference - Perform 3D difference
  • ST_3DDistance - Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DIntersection - Perform 3D intersection
  • ST_3DIntersects - Tests if two geometries spatially intersect in 3D - only for points, linestrings, polygons, polyhedral surface (area)
  • ST_3DLength - Returns the 3D length of a linear geometry.
  • ST_3DPerimeter - Returns the 3D perimeter of a polygonal geometry.
  • ST_3DUnion - Perform 3D union.
  • ST_AddEdgeModFace - Añada un nuevo borde y, si al hacerlo, divide una cara, modifica la cara original y añade una nueva cara.
  • ST_AddEdgeNewFaces - Agrega un nuevo borde y, si al hacerlo divide una cara, se elimina la cara original y es reemplazada con dos nuevas caras.
  • ST_AddIsoEdge - Agrega un borde aislado definido por la geometría alinestring a una topología que conecta dos nodos aislados existentes anode y anothernode y devuelve el identificador de borde del nuevo borde.
  • ST_AddIsoNode - Agrega un nodo aislado a una cara de una topología y devuelve el identificardor de nodo del nuevo nodo. Si la cara es nula, el nodo es creado de todas maneras.
  • ST_Area - Returns the area of a polygonal geometry.
  • ST_AsBinary - Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsGML - Return the geometry as a GML version 2 or 3 element.
  • ST_AsText - Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
  • ST_Boundary - Devuelve el cierre del limite combinatorio de esta geometría.
  • ST_Buffer - Computes a geometry covering all points within a given distance from a geometry.
  • ST_Centroid - Returns the geometric center of a geometry.
  • ST_ChangeEdgeGeom - Cambia la forma de un borde sin afectar la estructura de la topología.
  • ST_Contains - Tests if every point of B lies in A, and their interiors have a point in common
  • ST_ConvexHull - Computes the convex hull of a geometry.
  • ST_CoordDim - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • ST_CreateTopoGeo - Agrega una colección de geometrías a una topología vacía dada y devuelve un mensaje que detalla el éxito.
  • ST_Crosses - Tests if two geometries have some, but not all, interior points in common
  • ST_CurveN - Returns the Nth component curve geometry of a CompoundCurve.
  • ST_CurveToLine - Converts a geometry containing curves to a linear geometry.
  • ST_Difference - Computes a geometry representing the part of geometry A that does not intersect geometry B.
  • ST_Dimension - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • ST_Disjoint - Tests if two geometries have no points in common
  • ST_Distance - Returns the distance between two geometry or geography values.
  • ST_EndPoint - Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_Envelope - Devuelve una geometría que representa la caja en doble precisión (float8) de la geometría dada.
  • ST_Equals - Tests if two geometries include the same set of points
  • ST_ExteriorRing - Devuelva el número de anillos interiores de una geometría poligonal.
  • ST_GMLToSQL - Devuelve un valor especifico ST_Geometry desde una representación GML. Esto es un alias de ST_GeomFromGML
  • ST_GeomCollFromText - Hace una colección Geometry de la colección WKT con el SRID dado. Si no se da SRID, el valor predeterminado es 0.
  • ST_GeomFromText - Devuelve un valor especifico de ST_Geometry desde una representación "Extended Well-Known Binary" (EWKB).
  • ST_GeomFromWKB - Crea una instancia de geometría desde la representación de una geometría en "Well-Known Binary" (WKB) y un SRID opcional.
  • ST_GeometryFromText - Devuelve un valor especifico de ST_Geometry desde una representación "Well-Known Text" (WKT). Es un alias para ST_GeomFromText
  • ST_GeometryN - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_GeometryType - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_GetFaceEdges - Devuelve un conjunto de bordes ordenados que ligan aface.
  • ST_GetFaceGeometry - Devuelve el polígono en la topología dada con el identificador de la cara especificada.
  • ST_InitTopoGeo - Creates a new topology schema and registers it in the topology.topology table.
  • ST_InteriorRingN - Devuelva el número de anillos interiores de una geometría poligonal.
  • ST_Intersection - Computes a geometry representing the shared portion of geometries A and B.
  • ST_Intersects - Tests if two geometries intersect (they have at least one point in common)
  • ST_IsClosed - Devuelve TRUE si los puntos de inicio y final de una LINESTRINGson coincidentes. Para superficies poliedricas si son cerradas (volumetricas).
  • ST_IsEmpty - Tests if a geometry is empty.
  • ST_IsRing - Tests if a LineString is closed and simple.
  • ST_IsSimple - Devuelve (TRUE) si la geometría no tiene puntos geométricos anómalos, como auto intersecciones o tangencias.
  • ST_IsValid - Tests if a geometry is well-formed in 2D.
  • ST_Length - Returns the 2D length of a linear geometry.
  • ST_LineFromText - Hace una geometría de la representación WKT con el SRID dado. Si SRID no se da, el valor predeterminado es 0.
  • ST_LineFromWKB - Crea un LINESTRING desde un WKB con el SRID dado
  • ST_LinestringFromWKB - Crea una geometría desde un WKB con el SRID dado.
  • ST_LocateAlong - Returns the point(s) on a geometry that match a measure value.
  • ST_LocateBetween - Returns the portions of a geometry that match a measure range.
  • ST_M - Returns the M coordinate of a Point.
  • ST_MLineFromText - Devuelve un valor especificado ST_MultiLineString desde una representación WKT.
  • ST_MPointFromText - Hace una geometría desde un WKT con el SRID dado. Si no se da un SRID, el valor predeterminado es 0.
  • ST_MPolyFromText - Hace una Geometría MultiPolygon desde un WKT con el SRID dado. Si no se da SRID, el valor predeterminado es 0.
  • ST_ModEdgeHeal - Cura dos aristas eliminando el nodo que las conecta, modificando la primera arista y eliminando la segunda arista. Devuelve el identificador del nodo eliminado.
  • ST_ModEdgeSplit - Dividir un borde creando un nuevo nodo a lo largo de un borde existente, modificando el borde original y agregando un nuevo borde.
  • ST_MoveIsoNode - Mueve un nodo aislado en una topología de un punto a otro. Si la nueva geometría apoint existe como nodo se lanza un error. Devuelve la descripción del movimiento.
  • ST_NewEdgeHeal - Cura dos aristas eliminando el nodo que las conecta, eliminando ambas aristas y sustituyéndolas por una arista cuya dirección sea la misma que la primera arista proporcionada.
  • ST_NewEdgesSplit - Divide un borde creando un nuevo nodo a lo largo de un borde existente, eliminando el borde original y reemplazandolo con dos bordes nuevos. Devuelve el identificador del nuevo nodo creado que une los nuevos bordes.
  • ST_NumCurves - Return the number of component curves in a CompoundCurve.
  • ST_NumGeometries - Devuelve el numero de puntos en la geometría. Funciona con todas las geometrías.
  • ST_NumInteriorRings - Devuelva el número de anillos interiores de una geometría poligonal.
  • ST_NumPatches - Devuelve el número de caras en una superficie poliédrica. Devolverá nulo para geometrías no poliédricas.
  • ST_NumPoints - Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_OrderingEquals - Tests if two geometries represent the same geometry and have points in the same directional order
  • ST_Overlaps - Tests if two geometries have the same dimension and intersect, but each has at least one point not in the other
  • ST_PatchN - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_Perimeter - Returns the length of the boundary of a polygonal geometry or geography.
  • ST_Point - Creates a Point with X, Y and SRID values.
  • ST_PointFromText - Crea una geometría puntual desde un WKT con el SRID dado. Si no se especifica el SRID por defecto será unknown.
  • ST_PointFromWKB - Crea una geometría desde un WKB con el SRID dado.
  • ST_PointN - Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_PointOnSurface - Computes a point guaranteed to lie in a polygon, or on a geometry.
  • ST_Polygon - Creates a Polygon from a LineString with a specified SRID.
  • ST_PolygonFromText - Hace una geometría desde un WKT con el SRID dado. Si no se da un SRID, el valor predeterminado es 0.
  • ST_Relate - Tests if two geometries have a topological relationship matching an Intersection Matrix pattern, or computes their Intersection Matrix
  • ST_RemEdgeModFace - Removes an edge, and if the edge separates two faces deletes one face and modifies the other face to cover the space of both.
  • ST_RemEdgeNewFace - Elimina un borde y, si el borde eliminado separa dos caras, borra las caras originales y las reemplaza con una nueva cara.
  • ST_RemoveIsoEdge - Elimina un borde aislado y devuelve la descripción de la acción. Si el borde no está aislado, se lanza una excepción.
  • ST_RemoveIsoNode - Elimina un nodo aislado y devuelve la descripción de la acción. Si el nodo no está aislado (es el inicio o el final de un borde), entonces se lanza una excepción.
  • ST_SRID - Returns the spatial reference identifier for a geometry.
  • ST_StartPoint - Returns the first point of a LineString.
  • ST_SymDifference - Computes a geometry representing the portions of geometries A and B that do not intersect.
  • ST_Touches - Tests if two geometries have at least one point in common, but their interiors do not intersect
  • ST_Transform - Return a new geometry with coordinates transformed to a different spatial reference system.
  • ST_Union - Computes a geometry representing the point-set union of the input geometries.
  • ST_Volume - Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.
  • ST_WKBToSQL - Devuelve un valor especifico de ST_Geometry desde una representación "Well-Known Binary" (WKB). Es un alias para ST_GeomFromWKB que no toma srid
  • ST_WKTToSQL - Devuelve un valor especifico de ST_Geometry desde una representación "Well-Known Text" (WKT). Es un alias para ST_GeomFromText
  • ST_Within - Tests if every point of A lies in B, and their interiors have a point in common
  • ST_X - Returns the X coordinate of a Point.
  • ST_Y - Returns the Y coordinate of a Point.
  • ST_Z - Returns the Z coordinate of a Point.
  • ST_SRID - Returns the spatial reference identifier for a topogeometry.

13.4. PostGIS Geography Support Functions

The functions and operators given below are PostGIS functions/operators that take as input or return as output a geography data type object.

[Note]

Functions with a (T) are not native geodetic functions, and use a ST_Transform call to and from geometry to do the operation. As a result, they may not behave as expected when going over dateline, poles, and for large geometries or geometry pairs that cover more than one UTM zone. Basic transform - (favoring UTM, Lambert Azimuthal (North/South), and falling back on mercator in worst case scenario)
  • ST_Area - Returns the area of a polygonal geometry.
  • ST_AsBinary - Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsEWKT - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
  • ST_AsGML - Return the geometry as a GML version 2 or 3 element.
  • ST_AsGeoJSON - Return a geometry or feature in GeoJSON format.
  • ST_AsKML - Return the geometry as a KML element.
  • ST_AsSVG - Returns SVG path data for a geometry.
  • ST_AsText - Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
  • ST_Azimuth - Returns the north-based azimuth of a line between two points.
  • ST_Buffer - Computes a geometry covering all points within a given distance from a geometry.
  • ST_Centroid - Returns the geometric center of a geometry.
  • ST_ClosestPoint - Returns the 2D point on g1 that is closest to g2. This is the first point of the shortest line from one geometry to the other.
  • ST_CoveredBy - Tests if every point of A lies in B
  • ST_Covers - Tests if every point of B lies in A
  • ST_DWithin - Tests if two geometries are within a given distance
  • ST_Distance - Returns the distance between two geometry or geography values.
  • ST_GeogFromText - Devuelve un valor especifico "geography" desde una representación "Well-Known Text" (WKT) o extendida.
  • ST_GeogFromWKB - Crea una instancia "geography" desde la representación de una geometría en "Well-Known Binary" (WKB) o "Extended Well-Known Binary" (EWKB).
  • ST_GeographyFromText - Devuelve un valor especifico "geography" desde una representación "Well-Known Text" (WKT) o extendida.
  • = - Returns TRUE if the coordinates and coordinate order geometry/geography A are the same as the coordinates and coordinate order of geometry/geography B.
  • ST_Intersection - Computes a geometry representing the shared portion of geometries A and B.
  • ST_Intersects - Tests if two geometries intersect (they have at least one point in common)
  • ST_Length - Returns the 2D length of a linear geometry.
  • ST_LineInterpolatePoint - Returns a point interpolated along a line at a fractional location.
  • ST_LineInterpolatePoints - Returns points interpolated along a line at a fractional interval.
  • ST_LineLocatePoint - Returns the fractional location of the closest point on a line to a point.
  • ST_LineSubstring - Returns the part of a line between two fractional locations.
  • ST_Perimeter - Returns the length of the boundary of a polygonal geometry or geography.
  • ST_Project - Returns a point projected from a start point by a distance and bearing (azimuth).
  • ST_Segmentize - Returns a modified geometry/geography having no segment longer than a given distance.
  • ST_ShortestLine - Returns the 2D shortest line between two geometries
  • ST_Summary - Devuelve un resumen de texto del contenido de la geometría.
  • <-> - Returns the 2D distance between A and B.
  • && - Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.

13.5. PostGIS Raster Support Functions

The functions and operators given below are PostGIS functions/operators that take as input or return as output a raster data type object. Listed in alphabetical order.

  • Box3D - Returns the box 3d representation of the enclosing box of the raster.
  • @ - Returns TRUE if A's bounding box is contained by B's. Uses double precision bounding box.
  • ~ - Returns TRUE if A's bounding box is contains B's. Uses double precision bounding box.
  • = - Returns TRUE if A's bounding box is the same as B's. Uses double precision bounding box.
  • && - Returns TRUE if A's bounding box intersects B's bounding box.
  • &< - Returns TRUE if A's bounding box is to the left of B's.
  • &> - Returns TRUE if A's bounding box is to the right of B's.
  • ~= - Returns TRUE if A's bounding box is the same as B's.
  • ST_Retile - Return a set of configured tiles from an arbitrarily tiled raster coverage.
  • ST_AddBand - 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.
  • ST_AsBinary/ST_AsWKB - Return the Well-Known Binary (WKB) representation of the raster.
  • ST_AsGDALRaster - 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.
  • ST_AsHexWKB - Return the Well-Known Binary (WKB) in Hex representation of the raster.
  • ST_AsJPEG - 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.
  • ST_AsPNG - 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.
  • ST_AsRaster - Converts a PostGIS geometry to a PostGIS raster.
  • ST_AsRasterAgg - Aggregate. Renders PostGIS geometries into a new raster.
  • ST_AsTIFF - 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.
  • ST_Aspect - Returns the aspect (in degrees by default) of an elevation raster band. Useful for analyzing terrain.
  • ST_Band - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.
  • ST_BandFileSize - Returns the file size of a band stored in file system. If no bandnum specified, 1 is assumed.
  • ST_BandFileTimestamp - Returns the file timestamp of a band stored in file system. If no bandnum specified, 1 is assumed.
  • ST_BandIsNoData - Returns true if the band is filled with only nodata values.
  • ST_BandMetaData - Returns basic meta data for a specific raster band. band num 1 is assumed if none-specified.
  • ST_BandNoDataValue - Returns the value in a given band that represents no data. If no band num 1 is assumed.
  • ST_BandPath - Returns system file path to a band stored in file system. If no bandnum specified, 1 is assumed.
  • ST_BandPixelType - Returns the type of pixel for given band. If no bandnum specified, 1 is assumed.
  • ST_Clip - Returns the raster clipped by the input geometry. If band number is not specified, all bands are processed. If crop is not specified or TRUE, the output raster is cropped. If touched is set to TRUE, then touched pixels are included, otherwise only if the center of the pixel is in the geometry it is included.
  • ST_ColorMap - Creates a new raster of up to four 8BUI bands (grayscale, RGB, RGBA) from the source raster and a specified band. Band 1 is assumed if not specified.
  • ST_Contains - 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.
  • ST_ContainsProperly - Return true if rastB intersects the interior of rastA but not the boundary or exterior of rastA.
  • ST_Contour - Generates a set of vector contours from the provided raster band, using the GDAL contouring algorithm.
  • ST_ConvexHull - Return the convex hull geometry of the raster including pixel values equal to BandNoDataValue. For regular shaped and non-skewed rasters, this gives the same result as ST_Envelope so only useful for irregularly shaped or skewed rasters.
  • ST_Count - 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.
  • ST_CountAgg - 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.
  • ST_CoveredBy - Return true if no points of raster rastA lie outside raster rastB.
  • ST_Covers - Return true if no points of raster rastB lie outside raster rastA.
  • ST_DFullyWithin - Return true if rasters rastA and rastB are fully within the specified distance of each other.
  • ST_DWithin - Return true if rasters rastA and rastB are within the specified distance of each other.
  • ST_Disjoint - Return true if raster rastA does not spatially intersect rastB.
  • ST_DumpAsPolygons - Returns a set of geomval (geom,val) rows, from a given raster band. If no band number is specified, band num defaults to 1.
  • ST_DumpValues - Get the values of the specified band as a 2-dimension array.
  • ST_Envelope - Returns the polygon representation of the extent of the raster.
  • ST_FromGDALRaster - Returns a raster from a supported GDAL raster file.
  • ST_GeoReference - Returns the georeference meta data in GDAL or ESRI format as commonly seen in a world file. Default is GDAL.
  • ST_Grayscale - Creates a new one-8BUI band raster from the source raster and specified bands representing Red, Green and Blue
  • ST_HasNoBand - Returns true if there is no band with given band number. If no band number is specified, then band number 1 is assumed.
  • ST_Height - Returns the height of the raster in pixels.
  • ST_HillShade - Returns the hypothetical illumination of an elevation raster band using provided azimuth, altitude, brightness and scale inputs.
  • ST_Histogram - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified.
  • ST_InterpolateRaster - Interpolates a gridded surface based on an input set of 3-d points, using the X- and Y-values to position the points on the grid and the Z-value of the points as the surface elevation.
  • ST_Intersection - Returns a raster or a set of geometry-pixelvalue pairs representing the shared portion of two rasters or the geometrical intersection of a vectorization of the raster and a geometry.
  • ST_Intersects - Return true if raster rastA spatially intersects raster rastB.
  • ST_IsEmpty - Returns true if the raster is empty (width = 0 and height = 0). Otherwise, returns false.
  • ST_MakeEmptyCoverage - Cover georeferenced area with a grid of empty raster tiles.
  • ST_MakeEmptyRaster - 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).
  • ST_MapAlgebra (callback function version) - Callback function version - Returns a one-band raster given one or more input rasters, band indexes and one user-specified callback function.
  • ST_MapAlgebraExpr - 1 raster band version: Creates a new one band raster formed by applying a valid PostgreSQL algebraic operation on the input raster band and of pixeltype provided. Band 1 is assumed if no band is specified.
  • ST_MapAlgebraExpr - 2 raster band version: Creates a new one band raster formed by applying a valid PostgreSQL algebraic operation on the two input raster bands and of pixeltype provided. band 1 of each raster is assumed if no band numbers are specified. The resulting raster will be aligned (scale, skew and pixel corners) on the grid defined by the first raster and have its extent defined by the "extenttype" parameter. Values for "extenttype" can be: INTERSECTION, UNION, FIRST, SECOND.
  • ST_MapAlgebraFct - 1 band version - Creates a new one band raster formed by applying a valid PostgreSQL function on the input raster band and of pixeltype prodived. Band 1 is assumed if no band is specified.
  • ST_MapAlgebraFct - 2 band version - Creates a new one band raster formed by applying a valid PostgreSQL function on the 2 input raster bands and of pixeltype prodived. Band 1 is assumed if no band is specified. Extent type defaults to INTERSECTION if not specified.
  • ST_MapAlgebraFctNgb - 1-band version: Map Algebra Nearest Neighbor using user-defined PostgreSQL function. Return a raster which values are the result of a PLPGSQL user function involving a neighborhood of values from the input raster band.
  • ST_MapAlgebra (expression version) - Expression version - Returns a one-band raster given one or two input rasters, band indexes and one or more user-specified SQL expressions.
  • ST_MemSize - Returns the amount of space (in bytes) the raster takes.
  • ST_MetaData - Returns basic meta data about a raster object such as pixel size, rotation (skew), upper, lower left, etc.
  • ST_MinConvexHull - Return the convex hull geometry of the raster excluding NODATA pixels.
  • ST_NearestValue - Returns the nearest non-NODATA value of a given band's pixel specified by a columnx and rowy or a geometric point expressed in the same spatial reference coordinate system as the raster.
  • ST_Neighborhood - Returns a 2-D double precision array of the non-NODATA values around a given band's pixel specified by either a columnX and rowY or a geometric point expressed in the same spatial reference coordinate system as the raster.
  • ST_NotSameAlignmentReason - Returns text stating if rasters are aligned and if not aligned, a reason why.
  • ST_NumBands - Returns the number of bands in the raster object.
  • ST_Overlaps - Return true if raster rastA and rastB intersect but one does not completely contain the other.
  • ST_PixelAsCentroid - Returns the centroid (point geometry) of the area represented by a pixel.
  • ST_PixelAsCentroids - 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.
  • ST_PixelAsPoint - Returns a point geometry of the pixel's upper-left corner.
  • ST_PixelAsPoints - 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 pixel's upper-left corner.
  • ST_PixelAsPolygon - Returns the polygon geometry that bounds the pixel for a particular row and column.
  • ST_PixelAsPolygons - 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.
  • ST_PixelHeight - Returns the pixel height in geometric units of the spatial reference system.
  • ST_PixelOfValue - Get the columnx, rowy coordinates of the pixel whose value equals the search value.
  • ST_PixelWidth - Returns the pixel width in geometric units of the spatial reference system.
  • ST_Polygon - Returns a multipolygon geometry formed by the union of pixels that have a pixel value that is not no data value. If no band number is specified, band num defaults to 1.
  • ST_Quantile - 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 raster's 25%, 50%, 75% percentile.
  • ST_RastFromHexWKB - Return a raster value from a Hex representation of Well-Known Binary (WKB) raster.
  • ST_RastFromWKB - Return a raster value from a Well-Known Binary (WKB) raster.
  • ST_RasterToWorldCoord - Returns the raster's upper left corner as geometric X and Y (longitude and latitude) given a column and row. Column and row starts at 1.
  • ST_RasterToWorldCoordX - Returns the geometric X coordinate upper left of a raster, column and row. Numbering of columns and rows starts at 1.
  • ST_RasterToWorldCoordY - Returns the geometric Y coordinate upper left corner of a raster, column and row. Numbering of columns and rows starts at 1.
  • ST_Reclass - Creates a new raster composed of band types reclassified from original. The nband is the band to be changed. If nband is not specified assumed to be 1. All other bands are returned unchanged. Use case: convert a 16BUI band to a 8BUI and so forth for simpler rendering as viewable formats.
  • ST_Resample - 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.
  • ST_Rescale - 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, Lanczos, Max or Min resampling algorithm. Default is NearestNeighbor.
  • ST_Resize - Resize a raster to a new width/height
  • ST_Reskew - 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.
  • ST_Rotation - Returns the rotation of the raster in radian.
  • ST_Roughness - Returns a raster with the calculated "roughness" of a DEM.
  • ST_SRID - Returns the spatial reference identifier of the raster as defined in spatial_ref_sys table.
  • ST_SameAlignment - 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 don't with notice detailing issue.
  • ST_ScaleX - Returns the X component of the pixel width in units of coordinate reference system.
  • ST_ScaleY - Returns the Y component of the pixel height in units of coordinate reference system.
  • ST_SetBandIndex - Update the external band number of an out-db band
  • ST_SetBandIsNoData - Sets the isnodata flag of the band to TRUE.
  • ST_SetBandNoDataValue - 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.
  • ST_SetBandPath - Update the external path and band number of an out-db band
  • ST_SetGeoReference - 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.
  • ST_SetM - Returns a geometry with the same X/Y coordinates as the input geometry, and values from the raster copied into the M dimension using the requested resample algorithm.
  • ST_SetRotation - Set the rotation of the raster in radian.
  • ST_SetSRID - Sets the SRID of a raster to a particular integer srid defined in the spatial_ref_sys table.
  • ST_SetScale - Sets the X and Y size of pixels in units of coordinate reference system. Number units/pixel width/height.
  • ST_SetSkew - Sets the georeference X and Y skew (or rotation parameter). If only one is passed in, sets X and Y to the same value.
  • ST_SetUpperLeft - Sets the value of the upper left corner of the pixel of the raster to projected X and Y coordinates.
  • ST_SetValue - 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.
  • ST_SetValues - Returns modified raster resulting from setting the values of a given band.
  • ST_SetZ - Returns a geometry with the same X/Y coordinates as the input geometry, and values from the raster copied into the Z dimension using the requested resample algorithm.
  • ST_SkewX - Returns the georeference X skew (or rotation parameter).
  • ST_SkewY - Returns the georeference Y skew (or rotation parameter).
  • ST_Slope - Returns the slope (in degrees by default) of an elevation raster band. Useful for analyzing terrain.
  • ST_SnapToGrid - 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.
  • ST_Summary - Returns a text summary of the contents of the raster.
  • ST_SummaryStats - 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.
  • ST_SummaryStatsAgg - 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.
  • ST_TPI - Returns a raster with the calculated Topographic Position Index.
  • ST_TRI - Returns a raster with the calculated Terrain Ruggedness Index.
  • ST_Tile - Returns a set of rasters resulting from the split of the input raster based upon the desired dimensions of the output rasters.
  • ST_Touches - Return true if raster rastA and rastB have at least one point in common but their interiors do not intersect.
  • ST_Transform - 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.
  • ST_Union - Returns the union of a set of raster tiles into a single raster composed of 1 or more bands.
  • ST_UpperLeftX - Returns the upper left X coordinate of raster in projected spatial ref.
  • ST_UpperLeftY - Returns the upper left Y coordinate of raster in projected spatial ref.
  • ST_Value - 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.
  • ST_ValueCount - 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.
  • ST_Width - Returns the width of the raster in pixels.
  • ST_Within - 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.
  • ST_WorldToRasterCoord - 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.
  • ST_WorldToRasterCoordX - 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.
  • ST_WorldToRasterCoordY - 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.
  • UpdateRasterSRID - Change the SRID of all rasters in the user-specified column and table.

13.6. PostGIS Geometry / Geography / Raster Dump Functions

The functions given below are PostGIS functions that take as input or return as output a set of or single geometry_dump or geomval data type object.

  • ST_DumpAsPolygons - Returns a set of geomval (geom,val) rows, from a given raster band. If no band number is specified, band num defaults to 1.
  • ST_Intersection - Returns a raster or a set of geometry-pixelvalue pairs representing the shared portion of two rasters or the geometrical intersection of a vectorization of the raster and a geometry.
  • ST_Dump - Returns a set of geometry_dump rows for the components of a geometry.
  • ST_DumpPoints - Devuelve un conjunto de geometry_dump filas para las coordenadas de una geometría.
  • ST_DumpRings - Returns a set of geometry_dump rows for the exterior and interior rings of a Polygon.
  • ST_DumpSegments - Devuelve un conjunto de geometry_dump filas para los segmentos de una geometría.

13.7. PostGIS Box Functions

The functions given below are PostGIS functions that take as input or return as output the box* family of PostGIS spatial types. The box family of types consists of box2d, and box3d

  • Box2D - Returns a BOX2D representing the 2D extent of a geometry.
  • Box3D - Returns a BOX3D representing the 3D extent of a geometry.
  • Box3D - Returns the box 3d representation of the enclosing box of the raster.
  • ST_3DExtent - Aggregate function that returns the 3D bounding box of geometries.
  • ST_3DMakeBox - Creates a BOX3D defined by two 3D point geometries.
  • ST_AsMVTGeom - Transforms a geometry into the coordinate space of a MVT tile.
  • ST_AsTWKB - Returns the geometry as TWKB, aka "Tiny Well-Known Binary"
  • ST_Box2dFromGeoHash - Devuelve un BOX2D de una cadena de GeoHash.
  • ST_ClipByBox2D - Computes the portion of a geometry falling within a rectangle.
  • ST_EstimatedExtent - Returns the estimated extent of a spatial table.
  • ST_Expand - Returns a bounding box expanded from another bounding box or a geometry.
  • ST_Extent - Aggregate function that returns the bounding box of geometries.
  • ST_MakeBox2D - Creates a BOX2D defined by two 2D point geometries.
  • ST_RemoveIrrelevantPointsForView - Removes points that are irrelevant for rendering a specific rectangluar view of a geometry.
  • ST_XMax - Returns the X maxima of a 2D or 3D bounding box or a geometry.
  • ST_XMin - Returns the X minima of a 2D or 3D bounding box or a geometry.
  • ST_YMax - Returns the Y maxima of a 2D or 3D bounding box or a geometry.
  • ST_YMin - Returns the Y minima of a 2D or 3D bounding box or a geometry.
  • ST_ZMax - Returns the Z maxima of a 2D or 3D bounding box or a geometry.
  • ST_ZMin - Returns the Z minima of a 2D or 3D bounding box or a geometry.
  • RemoveUnusedPrimitives - Removes topology primitives which not needed to define existing TopoGeometry objects.
  • ValidateTopology - Devuelve un conjunto de objetos validatetopology_returntype que detallan problemas con la topología.
  • ~(box2df,box2df) - Returns TRUE if a 2D float precision bounding box (BOX2DF) contains another 2D float precision bounding box (BOX2DF).
  • ~(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) contains a geometry's 2D bonding box.
  • ~(geometry,box2df) - Returns TRUE if a geometry's 2D bonding box contains a 2D float precision bounding box (GIDX).
  • @(box2df,box2df) - Returns TRUE if a 2D float precision bounding box (BOX2DF) is contained into another 2D float precision bounding box.
  • @(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) is contained into a geometry's 2D bounding box.
  • @(geometry,box2df) - Returns TRUE if a geometry's 2D bounding box is contained into a 2D float precision bounding box (BOX2DF).
  • &&(box2df,box2df) - Returns TRUE if two 2D float precision bounding boxes (BOX2DF) intersect each other.
  • &&(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) intersects a geometry's (cached) 2D bounding box.
  • &&(geometry,box2df) - Returns TRUE if a geometry's (cached) 2D bounding box intersects a 2D float precision bounding box (BOX2DF).

13.8. PostGIS Functions that support 3D

The functions given below are PostGIS functions that do not throw away the Z-Index.

  • AddGeometryColumn - Suprime una columna de geometrías de una tabla espacial.
  • Box3D - Returns a BOX3D representing the 3D extent of a geometry.
  • CG_3DArea - Computes area of 3D surface geometries. Will return 0 for solids.
  • CG_3DBuffer - Computes a 3D buffer around a geometry.
  • CG_3DConvexHull - Computes the 3D convex hull of a geometry.
  • CG_3DDifference - Perform 3D difference
  • CG_3DIntersection - Perform 3D intersection
  • CG_3DRotate - Rotates a geometry in 3D space around an axis vector.
  • CG_3DScale - Scales a geometry by separate factors along X, Y, and Z axes.
  • CG_3DScaleAroundCenter - Scales a geometry in 3D space around a specified center point.
  • CG_3DTranslate - Translates (moves) a geometry by given offsets in 3D space.
  • CG_3DUnion - Perform 3D union using postgis_sfcgal.
  • CG_ApproximateMedialAxis - Compute the approximate medial axis of an areal geometry.
  • CG_ConstrainedDelaunayTriangles - Return a constrained Delaunay triangulation around the given input geometry.
  • CG_Extrude - Extrude a surface to a related volume
  • CG_ForceLHR - Force LHR orientation
  • CG_IsPlanar - Check if a surface is or not planar
  • CG_IsSolid - Test if the geometry is a solid. No validity check is performed.
  • CG_MakeSolid - Cast the geometry into a solid. No check is performed. To obtain a valid solid, the input geometry must be a closed Polyhedral Surface or a closed TIN.
  • CG_Orientation - Determine surface orientation
  • CG_RotateX - Rotates a geometry around the X-axis by a given angle.
  • CG_RotateY - Rotates a geometry around the Y-axis by a given angle.
  • CG_RotateZ - Rotates a geometry around the Z-axis by a given angle.
  • CG_StraightSkeleton - Compute a straight skeleton from a geometry
  • CG_Tesselate - Perform surface Tessellation of a polygon or polyhedralsurface and returns as a TIN or collection of TINS
  • CG_Visibility - Compute a visibility polygon from a point or a segment in a polygon geometry
  • CG_Volume - Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.
  • DropGeometryColumn - Suprime una columna de geometrías de una tabla espacial.
  • GeometryType - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_3DArea - Computes area of 3D surface geometries. Will return 0 for solids.
  • ST_3DClosestPoint - Returns the 3D point on g1 that is closest to g2. This is the first point of the 3D shortest line.
  • ST_3DConvexHull - Computes the 3D convex hull of a geometry.
  • ST_3DDFullyWithin - Tests if two 3D geometries are entirely within a given 3D distance
  • ST_3DDWithin - Tests if two 3D geometries are within a given 3D distance
  • ST_3DDifference - Perform 3D difference
  • ST_3DDistance - Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DExtent - Aggregate function that returns the 3D bounding box of geometries.
  • ST_3DIntersection - Perform 3D intersection
  • ST_3DIntersects - Tests if two geometries spatially intersect in 3D - only for points, linestrings, polygons, polyhedral surface (area)
  • ST_3DLength - Returns the 3D length of a linear geometry.
  • ST_3DLineInterpolatePoint - Returns a point interpolated along a 3D line at a fractional location.
  • ST_3DLongestLine - Returns the 3D longest line between two geometries
  • ST_3DMaxDistance - Returns the 3D cartesian maximum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DPerimeter - Returns the 3D perimeter of a polygonal geometry.
  • ST_3DShortestLine - Returns the 3D shortest line between two geometries
  • ST_3DUnion - Perform 3D union.
  • ST_AddMeasure - Interpolates measures along a linear geometry.
  • ST_AddPoint - Añade un punto a una cadena de línea.
  • ST_Affine - Apply a 3D affine transformation to a geometry.
  • ST_ApproximateMedialAxis - Compute the approximate medial axis of an areal geometry.
  • ST_AsBinary - Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsEWKB - Return the Extended Well-Known Binary (EWKB) representation of the geometry with SRID meta data.
  • ST_AsEWKT - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
  • ST_AsGML - Return the geometry as a GML version 2 or 3 element.
  • ST_AsGeoJSON - Return a geometry or feature in GeoJSON format.
  • ST_AsHEXEWKB - Returns a Geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding.
  • ST_AsKML - Return the geometry as a KML element.
  • ST_AsX3D - Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML
  • ST_Boundary - Devuelve el cierre del limite combinatorio de esta geometría.
  • ST_BoundingDiagonal - Devuelve la diagonal del cuadro delimitador de la geometría suministrada.
  • ST_CPAWithin - Tests if the closest point of approach of two trajectories is within the specified distance.
  • ST_ChaikinSmoothing - Returns a smoothed version of a geometry, using the Chaikin algorithm
  • ST_ClosestPointOfApproach - Returns a measure at the closest point of approach of two trajectories.
  • ST_Collect - Creates a GeometryCollection or Multi* geometry from a set of geometries.
  • ST_ConstrainedDelaunayTriangles - Return a constrained Delaunay triangulation around the given input geometry.
  • ST_ConvexHull - Computes the convex hull of a geometry.
  • ST_CoordDim - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • ST_CurveN - Returns the Nth component curve geometry of a CompoundCurve.
  • ST_CurveToLine - Converts a geometry containing curves to a linear geometry.
  • ST_DelaunayTriangles - Returns the Delaunay triangulation of the vertices of a geometry.
  • ST_Difference - Computes a geometry representing the part of geometry A that does not intersect geometry B.
  • ST_DistanceCPA - Returns the distance between the closest point of approach of two trajectories.
  • ST_Dump - Returns a set of geometry_dump rows for the components of a geometry.
  • ST_DumpPoints - Devuelve un conjunto de geometry_dump filas para las coordenadas de una geometría.
  • ST_DumpRings - Returns a set of geometry_dump rows for the exterior and interior rings of a Polygon.
  • ST_DumpSegments - Devuelve un conjunto de geometry_dump filas para los segmentos de una geometría.
  • ST_EndPoint - Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_ExteriorRing - Devuelva el número de anillos interiores de una geometría poligonal.
  • ST_Extrude - Extrude a surface to a related volume
  • ST_FlipCoordinates - Returns a version of a geometry with X and Y axis flipped.
  • ST_Force2D - Forzar las geometrías en un "modo de 2 dimensiones".
  • ST_ForceCurve - Relanzar una geometría en su tipo curvo, si corresponde.
  • ST_ForceLHR - Force LHR orientation
  • ST_ForcePolygonCCW - Orienta todos los aros exteriores en sentido contrario a las agujas del reloj y todos los aros interiores en sentido horario.
  • ST_ForcePolygonCW - Orienta todos los anillos exteriores en el sentido de las agujas del reloj y todos los anillos interiores en sentido contrario a las agujas del reloj.
  • ST_ForceRHR - Fuerza la orientación de los vértices en un polígono para seguir la regla de la mano derecha.
  • ST_ForceSFS - Fuerza las geometrías para usar sólo los tipos de geometría SFS 1.1.
  • ST_Force3D - Forzar las geometrías en modo XYZ. Este es un alias para ST_Force3DZ.
  • ST_Force3DZ - Fuerza las geometrías en modo XYZ.
  • ST_Force4D - Fuerza las geometrías en modo XYZM.
  • ST_ForceCollection - Convertir la geometría en una GEOMETRYCOLLECTION.
  • ST_GeomFromEWKB - Devuelve un valor especifico de ST_Geometry desde una representación " Extended Well-Known Binary" (EWKB).
  • ST_GeomFromEWKT - Devuelve un valor especificado ST_Geometry desde una representación "Extended Well-Known Text" (EWKT).
  • ST_GeomFromGML - Toma una representación GML como entrada de una geometría y extrae un objeto geométrico PostGIS
  • ST_GeomFromGeoJSON - Toma como entrada una representación geojson de una geometría y devuelve un objeto geométrico PostGIS
  • ST_GeomFromKML - Toma una representación de una geometría KML de entrada y devuelve un objeto geométrico PostGIS
  • ST_GeometricMedian - Returns the geometric median of a MultiPoint.
  • ST_GeometryN - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_GeometryType - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_HasArc - Tests if a geometry contains a circular arc
  • ST_HasM - Checks if a geometry has an M (measure) dimension.
  • ST_HasZ - Checks if a geometry has a Z dimension.
  • ST_InteriorRingN - Devuelva el número de anillos interiores de una geometría poligonal.
  • ST_InterpolatePoint - Devuelve el valor de la dimensión medida de una geometría en el punto cerrado al punto proporcionado.
  • ST_Intersection - Computes a geometry representing the shared portion of geometries A and B.
  • ST_IsClosed - Devuelve TRUE si los puntos de inicio y final de una LINESTRINGson coincidentes. Para superficies poliedricas si son cerradas (volumetricas).
  • ST_IsCollection - Devuelve True si la Geometría es una colección vacía, polígono vacio, punto vacío etc.
  • ST_IsPlanar - Check if a surface is or not planar
  • ST_IsPolygonCCW - Devuelve true si todos los aros exteriores están orientados hacia la izquierda y todos los aros interiores están orientados hacia la derecha.
  • ST_IsPolygonCW - Devuelve true si todos los aros exteriores están orientados hacia la derecha y todos los aros interiores están orientados en sentido contrario a las agujas del reloj.
  • ST_IsSimple - Devuelve (TRUE) si la geometría no tiene puntos geométricos anómalos, como auto intersecciones o tangencias.
  • ST_IsSolid - Test if the geometry is a solid. No validity check is performed.
  • ST_IsValidTrajectory - Tests if the geometry is a valid trajectory.
  • ST_LengthSpheroid - Returns the 2D or 3D length/perimeter of a lon/lat geometry on a spheroid.
  • ST_LineFromMultiPoint - Crea una LineString desde una geometría MultiPoint.
  • ST_LineInterpolatePoint - Returns a point interpolated along a line at a fractional location.
  • ST_LineInterpolatePoints - Returns points interpolated along a line at a fractional interval.
  • ST_LineSubstring - Returns the part of a line between two fractional locations.
  • ST_LineToCurve - Converts a linear geometry to a curved geometry.
  • ST_LocateBetweenElevations - Returns the portions of a geometry that lie in an elevation (Z) range.
  • ST_M - Returns the M coordinate of a Point.
  • ST_MakeLine - Crea una cadena de línea desde geometrías de punto, multipunto o de línea.
  • ST_MakePoint - Creates a 2D, 3DZ or 4D Point.
  • ST_MakePolygon - Creates a Polygon from a shell and optional list of holes.
  • ST_MakeSolid - Cast the geometry into a solid. No check is performed. To obtain a valid solid, the input geometry must be a closed Polyhedral Surface or a closed TIN.
  • ST_MakeValid - Attempts to make an invalid geometry valid without losing vertices.
  • ST_MemSize - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_MemUnion - Aggregate function which unions geometries in a memory-efficent but slower way
  • ST_NDims - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • ST_NPoints - Devuelve el numero de puntos (vértices) en la geometría.
  • ST_NRings - Devuelva el número de anillos interiores de una geometría poligonal.
  • ST_Node - Nodes a collection of lines.
  • ST_NumCurves - Return the number of component curves in a CompoundCurve.
  • ST_NumGeometries - Devuelve el numero de puntos en la geometría. Funciona con todas las geometrías.
  • ST_NumPatches - Devuelve el número de caras en una superficie poliédrica. Devolverá nulo para geometrías no poliédricas.
  • ST_Orientation - Determine surface orientation
  • ST_PatchN - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_PointFromWKB - Crea una geometría desde un WKB con el SRID dado.
  • ST_PointN - Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_PointOnSurface - Computes a point guaranteed to lie in a polygon, or on a geometry.
  • ST_Points - Devuelve un MultiPoint que contiene todas las coordenadas de una geometría.
  • ST_Polygon - Creates a Polygon from a LineString with a specified SRID.
  • ST_RemovePoint - Remove a point from a linestring.
  • ST_RemoveRepeatedPoints - Returns a version of a geometry with duplicate points removed.
  • ST_Reverse - Devuelve la geometría con el orden de vértice invertido.
  • ST_Rotate - Rotates a geometry about an origin point.
  • ST_RotateX - Rotates a geometry about the X axis.
  • ST_RotateY - Rotates a geometry about the Y axis.
  • ST_RotateZ - Rotates a geometry about the Z axis.
  • ST_Scale - Scales a geometry by given factors.
  • ST_Scroll - Change start point of a closed LineString.
  • ST_SetPoint - Reemplace el punto de una cadena de línea con un punto dado.
  • ST_ShiftLongitude - Shifts the longitude coordinates of a geometry between -180..180 and 0..360.
  • ST_SnapToGrid - Ajusta todos los puntos de la geometría de entrada a una cuadrícula regular.
  • ST_StartPoint - Returns the first point of a LineString.
  • ST_StraightSkeleton - Compute a straight skeleton from a geometry
  • ST_SwapOrdinates - Returns a version of the given geometry with given ordinate values swapped.
  • ST_SymDifference - Computes a geometry representing the portions of geometries A and B that do not intersect.
  • ST_Tesselate - Perform surface Tessellation of a polygon or polyhedralsurface and returns as a TIN or collection of TINS
  • ST_TransScale - Translates and scales a geometry by given offsets and factors.
  • ST_Translate - Translates a geometry by given offsets.
  • ST_UnaryUnion - Computes the union of the components of a single geometry.
  • ST_Union - Computes a geometry representing the point-set union of the input geometries.
  • ST_Volume - Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.
  • ST_WrapX - Wrap a geometry around an X value.
  • ST_X - Returns the X coordinate of a Point.
  • ST_XMax - Returns the X maxima of a 2D or 3D bounding box or a geometry.
  • ST_XMin - Returns the X minima of a 2D or 3D bounding box or a geometry.
  • ST_Y - Returns the Y coordinate of a Point.
  • ST_YMax - Returns the Y maxima of a 2D or 3D bounding box or a geometry.
  • ST_YMin - Returns the Y minima of a 2D or 3D bounding box or a geometry.
  • ST_Z - Returns the Z coordinate of a Point.
  • ST_ZMax - Returns the Z maxima of a 2D or 3D bounding box or a geometry.
  • ST_ZMin - Returns the Z minima of a 2D or 3D bounding box or a geometry.
  • ST_Zmflag - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • Equals - Devuelve true si dos topogeometries están compuestas de las mismas primitivas topologicas.
  • Intersects - Devuelve verdadero si cualquier par de primitivas de las dos topogeometries se intersectan.
  • UpdateGeometrySRID - Updates the SRID of all features in a geometry column, and the table metadata.
  • &&& - Returns TRUE if A's n-D bounding box intersects B's n-D bounding box.
  • &&&(geometry,gidx) - Returns TRUE if a geometry's (cached) n-D bounding box intersects a n-D float precision bounding box (GIDX).
  • &&&(gidx,geometry) - Returns TRUE if a n-D float precision bounding box (GIDX) intersects a geometry's (cached) n-D bounding box.
  • &&&(gidx,gidx) - Returns TRUE if two n-D float precision bounding boxes (GIDX) intersect each other.

13.9. PostGIS Curved Geometry Support Functions

The functions given below are PostGIS functions that can use CIRCULARSTRING, CURVEPOLYGON, and other curved geometry types

  • AddGeometryColumn - Suprime una columna de geometrías de una tabla espacial.
  • Box2D - Returns a BOX2D representing the 2D extent of a geometry.
  • Box3D - Returns a BOX3D representing the 3D extent of a geometry.
  • DropGeometryColumn - Suprime una columna de geometrías de una tabla espacial.
  • GeometryType - Devuelve el tipo de geometría del valor de ST_Geometry.
  • PostGIS_AddBBox - Agregue el cuadro delimitador a la geometría.
  • PostGIS_DropBBox - Elimina el caché de cuadro delimitador de la geometría.
  • PostGIS_HasBBox - Devuelve TRUE si el bbox de la geometría está almacenado en caché, FALSE de lo contrario.
  • ST_3DExtent - Aggregate function that returns the 3D bounding box of geometries.
  • ST_Affine - Apply a 3D affine transformation to a geometry.
  • ST_AsBinary - Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsEWKB - Return the Extended Well-Known Binary (EWKB) representation of the geometry with SRID meta data.
  • ST_AsEWKT - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
  • ST_AsHEXEWKB - Returns a Geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding.
  • ST_AsSVG - Returns SVG path data for a geometry.
  • ST_AsText - Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
  • ST_ClusterDBSCAN - Window function that returns a cluster id for each input geometry using the DBSCAN algorithm.
  • ST_ClusterWithin - Aggregate function that clusters geometries by separation distance.
  • ST_ClusterWithinWin - Window function that returns a cluster id for each input geometry, clustering using separation distance.
  • ST_Collect - Creates a GeometryCollection or Multi* geometry from a set of geometries.
  • ST_CoordDim - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • ST_CurveToLine - Converts a geometry containing curves to a linear geometry.
  • ST_Distance - Returns the distance between two geometry or geography values.
  • ST_Dump - Returns a set of geometry_dump rows for the components of a geometry.
  • ST_DumpPoints - Devuelve un conjunto de geometry_dump filas para las coordenadas de una geometría.
  • ST_EndPoint - Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_EstimatedExtent - Returns the estimated extent of a spatial table.
  • ST_FlipCoordinates - Returns a version of a geometry with X and Y axis flipped.
  • ST_Force2D - Forzar las geometrías en un "modo de 2 dimensiones".
  • ST_ForceCurve - Relanzar una geometría en su tipo curvo, si corresponde.
  • ST_ForceSFS - Fuerza las geometrías para usar sólo los tipos de geometría SFS 1.1.
  • ST_Force3D - Forzar las geometrías en modo XYZ. Este es un alias para ST_Force3DZ.
  • ST_Force3DM - Fuerza las geometrías en modo XYM.
  • ST_Force3DZ - Fuerza las geometrías en modo XYZ.
  • ST_Force4D - Fuerza las geometrías en modo XYZM.
  • ST_ForceCollection - Convertir la geometría en una GEOMETRYCOLLECTION.
  • ST_GeoHash - Return a GeoHash representation of the geometry.
  • ST_GeogFromWKB - Crea una instancia "geography" desde la representación de una geometría en "Well-Known Binary" (WKB) o "Extended Well-Known Binary" (EWKB).
  • ST_GeomFromEWKB - Devuelve un valor especifico de ST_Geometry desde una representación " Extended Well-Known Binary" (EWKB).
  • ST_GeomFromEWKT - Devuelve un valor especificado ST_Geometry desde una representación "Extended Well-Known Text" (EWKT).
  • ST_GeomFromText - Devuelve un valor especifico de ST_Geometry desde una representación "Extended Well-Known Binary" (EWKB).
  • ST_GeomFromWKB - Crea una instancia de geometría desde la representación de una geometría en "Well-Known Binary" (WKB) y un SRID opcional.
  • ST_GeometryN - Devuelve el tipo de geometría del valor de ST_Geometry.
  • = - Returns TRUE if the coordinates and coordinate order geometry/geography A are the same as the coordinates and coordinate order of geometry/geography B.
  • &<| - Returns TRUE if A's bounding box overlaps or is below B's.
  • ST_HasArc - Tests if a geometry contains a circular arc
  • ST_Intersects - Tests if two geometries intersect (they have at least one point in common)
  • ST_IsClosed - Devuelve TRUE si los puntos de inicio y final de una LINESTRINGson coincidentes. Para superficies poliedricas si son cerradas (volumetricas).
  • ST_IsCollection - Devuelve True si la Geometría es una colección vacía, polígono vacio, punto vacío etc.
  • ST_IsEmpty - Tests if a geometry is empty.
  • ST_LineToCurve - Converts a linear geometry to a curved geometry.
  • ST_MemSize - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_NPoints - Devuelve el numero de puntos (vértices) en la geometría.
  • ST_NRings - Devuelva el número de anillos interiores de una geometría poligonal.
  • ST_PointFromWKB - Crea una geometría desde un WKB con el SRID dado.
  • ST_PointN - Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_Points - Devuelve un MultiPoint que contiene todas las coordenadas de una geometría.
  • ST_Rotate - Rotates a geometry about an origin point.
  • ST_RotateZ - Rotates a geometry about the Z axis.
  • ST_SRID - Returns the spatial reference identifier for a geometry.
  • ST_Scale - Scales a geometry by given factors.
  • ST_SetSRID - Set the SRID on a geometry.
  • ST_StartPoint - Returns the first point of a LineString.
  • ST_Summary - Devuelve un resumen de texto del contenido de la geometría.
  • ST_SwapOrdinates - Returns a version of the given geometry with given ordinate values swapped.
  • ST_TransScale - Translates and scales a geometry by given offsets and factors.
  • ST_Transform - Return a new geometry with coordinates transformed to a different spatial reference system.
  • ST_Translate - Translates a geometry by given offsets.
  • ST_XMax - Returns the X maxima of a 2D or 3D bounding box or a geometry.
  • ST_XMin - Returns the X minima of a 2D or 3D bounding box or a geometry.
  • ST_YMax - Returns the Y maxima of a 2D or 3D bounding box or a geometry.
  • ST_YMin - Returns the Y minima of a 2D or 3D bounding box or a geometry.
  • ST_ZMax - Returns the Z maxima of a 2D or 3D bounding box or a geometry.
  • ST_ZMin - Returns the Z minima of a 2D or 3D bounding box or a geometry.
  • ST_Zmflag - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • UpdateGeometrySRID - Updates the SRID of all features in a geometry column, and the table metadata.
  • ~(box2df,box2df) - Returns TRUE if a 2D float precision bounding box (BOX2DF) contains another 2D float precision bounding box (BOX2DF).
  • ~(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) contains a geometry's 2D bonding box.
  • ~(geometry,box2df) - Returns TRUE if a geometry's 2D bonding box contains a 2D float precision bounding box (GIDX).
  • && - Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.
  • &&& - Returns TRUE if A's n-D bounding box intersects B's n-D bounding box.
  • @(box2df,box2df) - Returns TRUE if a 2D float precision bounding box (BOX2DF) is contained into another 2D float precision bounding box.
  • @(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) is contained into a geometry's 2D bounding box.
  • @(geometry,box2df) - Returns TRUE if a geometry's 2D bounding box is contained into a 2D float precision bounding box (BOX2DF).
  • &&(box2df,box2df) - Returns TRUE if two 2D float precision bounding boxes (BOX2DF) intersect each other.
  • &&(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) intersects a geometry's (cached) 2D bounding box.
  • &&(geometry,box2df) - Returns TRUE if a geometry's (cached) 2D bounding box intersects a 2D float precision bounding box (BOX2DF).
  • &&&(geometry,gidx) - Returns TRUE if a geometry's (cached) n-D bounding box intersects a n-D float precision bounding box (GIDX).
  • &&&(gidx,geometry) - Returns TRUE if a n-D float precision bounding box (GIDX) intersects a geometry's (cached) n-D bounding box.
  • &&&(gidx,gidx) - Returns TRUE if two n-D float precision bounding boxes (GIDX) intersect each other.

13.10. PostGIS Polyhedral Surface Support Functions

The functions given below are PostGIS functions that can use POLYHEDRALSURFACE, POLYHEDRALSURFACEM geometries

  • Box2D - Returns a BOX2D representing the 2D extent of a geometry.
  • Box3D - Returns a BOX3D representing the 3D extent of a geometry.
  • CG_3DArea - Computes area of 3D surface geometries. Will return 0 for solids.
  • CG_3DBuffer - Computes a 3D buffer around a geometry.
  • CG_3DConvexHull - Computes the 3D convex hull of a geometry.
  • CG_3DDifference - Perform 3D difference
  • CG_3DIntersection - Perform 3D intersection
  • CG_3DUnion - Perform 3D union using postgis_sfcgal.
  • CG_ApproximateMedialAxis - Compute the approximate medial axis of an areal geometry.
  • CG_Extrude - Extrude a surface to a related volume
  • CG_ForceLHR - Force LHR orientation
  • CG_IsPlanar - Check if a surface is or not planar
  • CG_IsSolid - Test if the geometry is a solid. No validity check is performed.
  • CG_MakeSolid - Cast the geometry into a solid. No check is performed. To obtain a valid solid, the input geometry must be a closed Polyhedral Surface or a closed TIN.
  • CG_StraightSkeleton - Compute a straight skeleton from a geometry
  • CG_Tesselate - Perform surface Tessellation of a polygon or polyhedralsurface and returns as a TIN or collection of TINS
  • CG_Visibility - Compute a visibility polygon from a point or a segment in a polygon geometry
  • CG_Volume - Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.
  • GeometryType - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_3DArea - Computes area of 3D surface geometries. Will return 0 for solids.
  • ST_3DClosestPoint - Returns the 3D point on g1 that is closest to g2. This is the first point of the 3D shortest line.
  • ST_3DConvexHull - Computes the 3D convex hull of a geometry.
  • ST_3DDFullyWithin - Tests if two 3D geometries are entirely within a given 3D distance
  • ST_3DDWithin - Tests if two 3D geometries are within a given 3D distance
  • ST_3DDifference - Perform 3D difference
  • ST_3DDistance - Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DExtent - Aggregate function that returns the 3D bounding box of geometries.
  • ST_3DIntersection - Perform 3D intersection
  • ST_3DIntersects - Tests if two geometries spatially intersect in 3D - only for points, linestrings, polygons, polyhedral surface (area)
  • ST_3DLongestLine - Returns the 3D longest line between two geometries
  • ST_3DMaxDistance - Returns the 3D cartesian maximum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DShortestLine - Returns the 3D shortest line between two geometries
  • ST_3DUnion - Perform 3D union.
  • ST_Affine - Apply a 3D affine transformation to a geometry.
  • ST_ApproximateMedialAxis - Compute the approximate medial axis of an areal geometry.
  • ST_Area - Returns the area of a polygonal geometry.
  • ST_AsBinary - Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsEWKB - Return the Extended Well-Known Binary (EWKB) representation of the geometry with SRID meta data.
  • ST_AsEWKT - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
  • ST_AsGML - Return the geometry as a GML version 2 or 3 element.
  • ST_AsX3D - Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML
  • ST_CoordDim - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • ST_Dimension - Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • ST_Dump - Returns a set of geometry_dump rows for the components of a geometry.
  • ST_DumpPoints - Devuelve un conjunto de geometry_dump filas para las coordenadas de una geometría.
  • ST_Expand - Returns a bounding box expanded from another bounding box or a geometry.
  • ST_Extent - Aggregate function that returns the bounding box of geometries.
  • ST_Extrude - Extrude a surface to a related volume
  • ST_FlipCoordinates - Returns a version of a geometry with X and Y axis flipped.
  • ST_Force2D - Forzar las geometrías en un "modo de 2 dimensiones".
  • ST_ForceLHR - Force LHR orientation
  • ST_ForceRHR - Fuerza la orientación de los vértices en un polígono para seguir la regla de la mano derecha.
  • ST_ForceSFS - Fuerza las geometrías para usar sólo los tipos de geometría SFS 1.1.
  • ST_Force3D - Forzar las geometrías en modo XYZ. Este es un alias para ST_Force3DZ.
  • ST_Force3DZ - Fuerza las geometrías en modo XYZ.
  • ST_ForceCollection - Convertir la geometría en una GEOMETRYCOLLECTION.
  • ST_GeomFromEWKB - Devuelve un valor especifico de ST_Geometry desde una representación " Extended Well-Known Binary" (EWKB).
  • ST_GeomFromEWKT - Devuelve un valor especificado ST_Geometry desde una representación "Extended Well-Known Text" (EWKT).
  • ST_GeomFromGML - Toma una representación GML como entrada de una geometría y extrae un objeto geométrico PostGIS
  • ST_GeometryN - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_GeometryType - Devuelve el tipo de geometría del valor de ST_Geometry.
  • = - Returns TRUE if the coordinates and coordinate order geometry/geography A are the same as the coordinates and coordinate order of geometry/geography B.
  • &<| - Returns TRUE if A's bounding box overlaps or is below B's.
  • ~= - Returns TRUE if A's bounding box is the same as B's.
  • ST_IsClosed - Devuelve TRUE si los puntos de inicio y final de una LINESTRINGson coincidentes. Para superficies poliedricas si son cerradas (volumetricas).
  • ST_IsPlanar - Check if a surface is or not planar
  • ST_IsSolid - Test if the geometry is a solid. No validity check is performed.
  • ST_MakeSolid - Cast the geometry into a solid. No check is performed. To obtain a valid solid, the input geometry must be a closed Polyhedral Surface or a closed TIN.
  • ST_MemSize - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_NPoints - Devuelve el numero de puntos (vértices) en la geometría.
  • ST_NumGeometries - Devuelve el numero de puntos en la geometría. Funciona con todas las geometrías.
  • ST_NumPatches - Devuelve el número de caras en una superficie poliédrica. Devolverá nulo para geometrías no poliédricas.
  • ST_PatchN - Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_RemoveRepeatedPoints - Returns a version of a geometry with duplicate points removed.
  • ST_Reverse - Devuelve la geometría con el orden de vértice invertido.
  • ST_Rotate - Rotates a geometry about an origin point.
  • ST_RotateX - Rotates a geometry about the X axis.
  • ST_RotateY - Rotates a geometry about the Y axis.
  • ST_RotateZ - Rotates a geometry about the Z axis.
  • ST_Scale - Scales a geometry by given factors.
  • ST_ShiftLongitude - Shifts the longitude coordinates of a geometry between -180..180 and 0..360.
  • ST_StraightSkeleton - Compute a straight skeleton from a geometry
  • ST_Summary - Devuelve un resumen de texto del contenido de la geometría.
  • ST_SwapOrdinates - Returns a version of the given geometry with given ordinate values swapped.
  • ST_Tesselate - Perform surface Tessellation of a polygon or polyhedralsurface and returns as a TIN or collection of TINS
  • ST_Transform - Return a new geometry with coordinates transformed to a different spatial reference system.
  • ST_Volume - Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.
  • ~(box2df,box2df) - Returns TRUE if a 2D float precision bounding box (BOX2DF) contains another 2D float precision bounding box (BOX2DF).
  • ~(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) contains a geometry's 2D bonding box.
  • ~(geometry,box2df) - Returns TRUE if a geometry's 2D bonding box contains a 2D float precision bounding box (GIDX).
  • && - Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.
  • &&& - Returns TRUE if A's n-D bounding box intersects B's n-D bounding box.
  • @(box2df,box2df) - Returns TRUE if a 2D float precision bounding box (BOX2DF) is contained into another 2D float precision bounding box.
  • @(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) is contained into a geometry's 2D bounding box.
  • @(geometry,box2df) - Returns TRUE if a geometry's 2D bounding box is contained into a 2D float precision bounding box (BOX2DF).
  • &&(box2df,box2df) - Returns TRUE if two 2D float precision bounding boxes (BOX2DF) intersect each other.
  • &&(box2df,geometry) - Returns TRUE if a 2D float precision bounding box (BOX2DF) intersects a geometry's (cached) 2D bounding box.
  • &&(geometry,box2df) - Returns TRUE if a geometry's (cached) 2D bounding box intersects a 2D float precision bounding box (BOX2DF).
  • &&&(geometry,gidx) - Returns TRUE if a geometry's (cached) n-D bounding box intersects a n-D float precision bounding box (GIDX).
  • &&&(gidx,geometry) - Returns TRUE if a n-D float precision bounding box (GIDX) intersects a geometry's (cached) n-D bounding box.
  • &&&(gidx,gidx) - Returns TRUE if two n-D float precision bounding boxes (GIDX) intersect each other.

13.11. PostGIS Function Support Matrix

Below is an alphabetical listing of spatial specific functions in PostGIS and the kinds of spatial types they work with or OGC/SQL compliance they try to conform to.

  • A means the function works with the type or subtype natively.
  • A means it works but with a transform cast built-in using cast to geometry, transform to a "best srid" spatial ref and then cast back. Results may not be as expected for large areas or areas at poles and may accumulate floating point junk.
  • A means the function works with the type because of a auto-cast to another such as to box3d rather than direct type support.
  • A means the function only available if PostGIS compiled with SFCGAL support.
  • geom - Basic 2D geometry support (x,y).
  • geog - Basic 2D geography support (x,y).
  • 2.5D - basic 2D geometries in 3 D/4D space (has Z or M coord).
  • PS - Polyhedral surfaces
  • T - Triangles and Triangulated Irregular Network surfaces (TIN)

Function geom geog 2.5D Curves SQL MM PS T
ST_Collect        
ST_LineFromMultiPoint          
ST_MakeEnvelope            
ST_MakeLine          
ST_MakePoint          
ST_MakePointM            
ST_MakePolygon          
ST_Point          
ST_PointZ            
ST_PointM            
ST_PointZM            
ST_Polygon        
ST_TileEnvelope            
ST_HexagonGrid            
ST_Hexagon            
ST_SquareGrid            
ST_Square            
ST_Letters            
GeometryType    
ST_Boundary        
ST_BoundingDiagonal          
ST_CoordDim  
ST_Dimension      
ST_Dump    
ST_DumpPoints    
ST_DumpSegments        
ST_DumpRings          
ST_EndPoint      
ST_Envelope          
ST_ExteriorRing        
ST_GeometryN  
ST_GeometryType      
ST_HasArc        
ST_InteriorRingN        
ST_NumCurves        
ST_CurveN        
ST_IsClosed    
ST_IsCollection        
ST_IsEmpty        
ST_IsPolygonCCW          
ST_IsPolygonCW          
ST_IsRing          
ST_IsSimple        
ST_M        
ST_MemSize    
ST_NDims          
ST_NPoints      
ST_NRings        
ST_NumGeometries    
ST_NumInteriorRings          
ST_NumInteriorRing            
ST_NumPatches      
ST_NumPoints          
ST_PatchN      
ST_PointN      
ST_Points        
ST_StartPoint      
ST_Summary    
ST_X        
ST_Y        
ST_Z        
ST_Zmflag        
ST_HasZ          
ST_HasM          
ST_AddPoint          
ST_CollectionExtract            
ST_CollectionHomogenize            
ST_CurveToLine      
ST_Scroll          
ST_FlipCoordinates    
ST_Force2D      
ST_Force3D      
ST_Force3DZ      
ST_Force3DM          
ST_Force4D        
ST_ForceCollection      
ST_ForceCurve        
ST_ForcePolygonCCW          
ST_ForcePolygonCW          
ST_ForceSFS    
ST_ForceRHR        
ST_LineExtend            
ST_LineToCurve        
ST_Multi            
ST_Normalize            
ST_Project          
ST_QuantizeCoordinates            
ST_RemovePoint          
ST_RemoveRepeatedPoints        
ST_RemoveIrrelevantPointsForView            
ST_RemoveSmallParts            
ST_Reverse        
ST_Segmentize          
ST_SetPoint          
ST_ShiftLongitude      
ST_WrapX          
ST_SnapToGrid          
ST_Snap            
ST_SwapOrdinates    
ST_IsValid          
ST_IsValidDetail            
ST_IsValidReason            
ST_MakeValid          
ST_InverseTransformPipeline            
ST_SetSRID          
ST_SRID        
ST_Transform      
ST_TransformPipeline            
postgis_srs_codes              
postgis_srs              
postgis_srs_all              
postgis_srs_search            
ST_BdPolyFromText            
ST_BdMPolyFromText            
ST_GeogFromText            
ST_GeographyFromText            
ST_GeomCollFromText          
ST_GeomFromEWKT    
ST_GeomFromMARC21            
ST_GeometryFromText          
ST_GeomFromText        
ST_LineFromText          
ST_MLineFromText          
ST_MPointFromText          
ST_MPolyFromText          
ST_PointFromText          
ST_PolygonFromText          
ST_WKTToSQL          
ST_GeogFromWKB          
ST_GeomFromEWKB    
ST_GeomFromWKB        
ST_LineFromWKB          
ST_LinestringFromWKB          
ST_PointFromWKB      
ST_WKBToSQL          
ST_Box2dFromGeoHash            
ST_GeomFromGeoHash            
ST_GeomFromGML      
ST_GeomFromGeoJSON          
ST_GeomFromKML          
ST_GeomFromTWKB            
ST_GMLToSQL          
ST_LineFromEncodedPolyline            
ST_PointFromGeoHash              
ST_FromFlatGeobufToTable              
ST_FromFlatGeobuf              
ST_AsEWKT  
ST_AsText      
ST_AsBinary
ST_AsEWKB    
ST_AsHEXEWKB        
ST_AsEncodedPolyline            
ST_AsFlatGeobuf            
ST_AsGeobuf            
ST_AsGeoJSON        
ST_AsGML  
ST_AsKML        
ST_AsLatLonText            
ST_AsMARC21            
ST_AsMVTGeom            
ST_AsMVT            
ST_AsSVG        
ST_AsTWKB            
ST_AsX3D      
ST_GeoHash          
&&      
&&(geometry,box2df)        
&&(box2df,geometry)        
&&(box2df,box2df)        
&&&    
&&&(geometry,gidx)    
&&&(gidx,geometry)    
&&&(gidx,gidx)      
&<            
&<|        
&>            
<<            
<<|            
=      
>>            
@            
@(geometry,box2df)        
@(box2df,geometry)        
@(box2df,box2df)        
|&>            
|>>            
~            
~(geometry,box2df)        
~(box2df,geometry)        
~(box2df,box2df)        
~=          
<->          
|=|            
<#>            
<<->>            
ST_3DIntersects    
ST_Contains          
ST_ContainsProperly            
ST_CoveredBy          
ST_Covers          
ST_Crosses          
ST_Disjoint          
ST_Equals          
ST_Intersects    
ST_LineCrossingDirection            
ST_OrderingEquals          
ST_Overlaps          
ST_Relate          
ST_RelateMatch              
ST_Touches          
ST_Within          
ST_3DDWithin      
ST_3DDFullyWithin        
ST_DFullyWithin            
ST_DWithin          
ST_PointInsideCircle            
ST_Area      
ST_Azimuth          
ST_Angle            
ST_ClosestPoint          
ST_3DClosestPoint        
ST_Distance      
ST_3DDistance      
ST_DistanceSphere            
ST_DistanceSpheroid            
ST_FrechetDistance            
ST_HausdorffDistance            
ST_Length        
ST_Length2D            
ST_3DLength        
ST_LengthSpheroid          
ST_LongestLine            
ST_3DLongestLine        
ST_MaxDistance            
ST_3DMaxDistance        
ST_MinimumClearance            
ST_MinimumClearanceLine            
ST_Perimeter        
ST_Perimeter2D            
ST_3DPerimeter        
ST_ShortestLine          
ST_3DShortestLine        
ST_ClipByBox2D            
ST_Difference        
ST_Intersection      
ST_MemUnion          
ST_Node          
ST_Split            
ST_Subdivide            
ST_SymDifference        
ST_UnaryUnion          
ST_Union        
ST_Buffer        
ST_BuildArea            
ST_Centroid        
ST_ChaikinSmoothing          
ST_ConcaveHull            
ST_ConvexHull        
ST_DelaunayTriangles        
ST_FilterByM            
ST_GeneratePoints            
ST_GeometricMedian          
ST_LineMerge            
ST_MaximumInscribedCircle            
ST_LargestEmptyCircle            
ST_MinimumBoundingCircle            
ST_MinimumBoundingRadius            
ST_OrientedEnvelope            
ST_OffsetCurve            
ST_PointOnSurface        
ST_Polygonize            
ST_ReducePrecision            
ST_SharedPaths            
ST_Simplify            
ST_SimplifyPreserveTopology            
ST_SimplifyPolygonHull            
ST_SimplifyVW            
ST_SetEffectiveArea            
ST_TriangulatePolygon            
ST_VoronoiLines            
ST_VoronoiPolygons            
ST_CoverageInvalidEdges            
ST_CoverageSimplify            
ST_CoverageUnion            
ST_Affine    
ST_Rotate    
ST_RotateX      
ST_RotateY      
ST_RotateZ    
ST_Scale    
ST_Translate        
ST_TransScale        
ST_ClusterDBSCAN          
ST_ClusterIntersecting            
ST_ClusterIntersectingWin            
ST_ClusterKMeans            
ST_ClusterWithin          
ST_ClusterWithinWin          
Box2D      
Box3D    
ST_EstimatedExtent          
ST_Expand        
ST_Extent        
ST_3DExtent    
ST_MakeBox2D            
ST_3DMakeBox            
ST_XMax        
ST_XMin        
ST_YMax        
ST_YMin        
ST_ZMax        
ST_ZMin        
ST_LineInterpolatePoint        
ST_3DLineInterpolatePoint          
ST_LineInterpolatePoints        
ST_LineLocatePoint          
ST_LineSubstring        
ST_LocateAlong          
ST_LocateBetween          
ST_LocateBetweenElevations          
ST_InterpolatePoint          
ST_AddMeasure          
ST_IsValidTrajectory          
ST_ClosestPointOfApproach          
ST_DistanceCPA          
ST_CPAWithin          
postgis.backend              
postgis.gdal_datapath              
postgis.gdal_enabled_drivers              
postgis.enable_outdb_rasters              
postgis.gdal_vsi_options              
PostGIS_AddBBox          
PostGIS_DropBBox          
PostGIS_HasBBox          
postgis_sfcgal_version              
postgis_sfcgal_full_version              
CG_ForceLHR      
CG_IsPlanar      
CG_IsSolid      
CG_MakeSolid      
CG_Orientation          
CG_Area            
CG_3DArea    
CG_Volume    
ST_ForceLHR      
ST_IsPlanar      
ST_IsSolid      
ST_MakeSolid      
ST_Orientation          
ST_3DArea    
ST_Volume    
CG_Intersection            
CG_Intersects          
CG_3DIntersects          
CG_Difference          
ST_3DDifference    
CG_3DDifference    
CG_Distance          
CG_3DDistance          
ST_3DConvexHull      
CG_3DConvexHull      
ST_3DIntersection    
CG_3DIntersection    
CG_Union            
ST_3DUnion    
CG_3DUnion    
ST_AlphaShape            
CG_AlphaShape            
CG_ApproxConvexPartition            
ST_ApproximateMedialAxis      
CG_ApproximateMedialAxis      
ST_ConstrainedDelaunayTriangles          
CG_ConstrainedDelaunayTriangles          
ST_Extrude      
CG_Extrude      
CG_ExtrudeStraightSkeleton            
CG_GreeneApproxConvexPartition            
ST_MinkowskiSum            
CG_MinkowskiSum            
ST_OptimalAlphaShape            
CG_OptimalAlphaShape            
CG_OptimalConvexPartition            
CG_StraightSkeleton      
ST_StraightSkeleton      
ST_Tesselate      
CG_Tesselate      
CG_Triangulate            
CG_Visibility      
CG_YMonotonePartition            
CG_StraightSkeletonPartition            
CG_3DBuffer      
CG_Rotate            
CG_2DRotate            
CG_3DRotate          
CG_RotateX          
CG_RotateY          
CG_RotateZ          
CG_Scale            
CG_3DScale          
CG_3DScaleAroundCenter          
CG_Translate            
CG_3DTranslate          
getfaceedges_returntype              
TopoGeometry              
validatetopology_returntype              
TopoElement              
TopoElementArray              
AddTopoGeometryColumn              
RenameTopoGeometryColumn              
DropTopology              
RenameTopology              
DropTopoGeometryColumn              
Populate_Topology_Layer              
TopologySummary              
ValidateTopology            
ValidateTopologyRelation              
FindTopology              
FindLayer              
CreateTopology              
CopyTopology              
ST_InitTopoGeo            
ST_CreateTopoGeo          
TopoGeo_AddPoint            
TopoGeo_AddLineString            
TopoGeo_AddPolygon            
TopoGeo_LoadGeometry            
ST_AddIsoNode          
ST_AddIsoEdge          
ST_AddEdgeNewFaces          
ST_AddEdgeModFace          
ST_RemEdgeNewFace            
ST_RemEdgeModFace            
ST_ChangeEdgeGeom          
ST_ModEdgeSplit          
ST_ModEdgeHeal            
ST_NewEdgeHeal            
ST_MoveIsoNode          
ST_NewEdgesSplit          
ST_RemoveIsoNode            
ST_RemoveIsoEdge            
GetEdgeByPoint            
GetFaceByPoint            
GetFaceContainingPoint            
GetNodeByPoint            
GetTopologyID              
GetTopologySRID              
GetTopologyName              
ST_GetFaceEdges            
ST_GetFaceGeometry          
GetRingEdges              
GetNodeEdges              
Polygonize              
AddNode            
AddEdge            
AddFace            
ST_Simplify            
RemoveUnusedPrimitives            
CreateTopoGeom            
toTopoGeom            
TopoElementArray_Agg              
TopoElement            
clearTopoGeom            
TopoGeom_addElement            
TopoGeom_remElement            
TopoGeom_addTopoGeom            
toTopoGeom              
GetTopoGeomElementArray              
GetTopoGeomElements              
ST_SRID          
AsGML            
AsTopoJSON            
Equals          
Intersects          
geomval              
addbandarg              
rastbandarg              
raster              
reclassarg              
summarystats              
unionarg              
AddRasterConstraints              
DropRasterConstraints              
AddOverviewConstraints              
DropOverviewConstraints              
PostGIS_GDAL_Version              
PostGIS_Raster_Lib_Build_Date              
PostGIS_Raster_Lib_Version              
ST_GDALDrivers              
ST_Contour              
ST_InterpolateRaster            
UpdateRasterSRID              
ST_CreateOverview              
ST_AddBand              
ST_AsRaster            
ST_AsRasterAgg            
ST_Band              
ST_MakeEmptyCoverage              
ST_MakeEmptyRaster              
ST_Tile              
ST_Retile            
ST_FromGDALRaster              
ST_GeoReference              
ST_Height              
ST_IsEmpty              
ST_MemSize              
ST_MetaData              
ST_NumBands              
ST_PixelHeight              
ST_PixelWidth              
ST_ScaleX              
ST_ScaleY              
ST_RasterToWorldCoord              
ST_RasterToWorldCoordX              
ST_RasterToWorldCoordY              
ST_Rotation              
ST_SkewX              
ST_SkewY              
ST_SRID              
ST_Summary              
ST_UpperLeftX              
ST_UpperLeftY              
ST_Width              
ST_WorldToRasterCoord            
ST_WorldToRasterCoordX            
ST_WorldToRasterCoordY            
ST_BandMetaData              
ST_BandNoDataValue              
ST_BandIsNoData              
ST_BandPath              
ST_BandFileSize              
ST_BandFileTimestamp              
ST_BandPixelType              
ST_MinPossibleValue              
ST_HasNoBand              
ST_PixelAsPolygon            
ST_PixelAsPolygons              
ST_PixelAsPoint            
ST_PixelAsPoints              
ST_PixelAsCentroid            
ST_PixelAsCentroids              
ST_Value            
ST_NearestValue            
ST_SetZ            
ST_SetM            
ST_Neighborhood            
ST_SetValue            
ST_SetValues              
ST_DumpValues              
ST_PixelOfValue              
ST_SetGeoReference              
ST_SetRotation              
ST_SetScale              
ST_SetSkew              
ST_SetSRID              
ST_SetUpperLeft              
ST_Resample              
ST_Rescale              
ST_Reskew              
ST_SnapToGrid              
ST_Resize              
ST_Transform              
ST_SetBandNoDataValue              
ST_SetBandIsNoData              
ST_SetBandPath              
ST_SetBandIndex              
ST_Count              
ST_CountAgg              
ST_Histogram              
ST_Quantile              
ST_SummaryStats              
ST_SummaryStatsAgg              
ST_ValueCount              
ST_RastFromWKB              
ST_RastFromHexWKB              
ST_AsBinary/ST_AsWKB              
ST_AsHexWKB              
ST_AsGDALRaster              
ST_AsJPEG              
ST_AsPNG              
ST_AsTIFF              
ST_Clip            
ST_ColorMap              
ST_Grayscale              
ST_Intersection            
ST_MapAlgebra (callback function version)              
ST_MapAlgebra (expression version)              
ST_MapAlgebraExpr              
ST_MapAlgebraExpr              
ST_MapAlgebraFct              
ST_MapAlgebraFct              
ST_MapAlgebraFctNgb              
ST_Reclass              
ST_Union              
ST_Distinct4ma              
ST_InvDistWeight4ma              
ST_Max4ma              
ST_Mean4ma              
ST_Min4ma              
ST_MinDist4ma              
ST_Range4ma              
ST_StdDev4ma              
ST_Sum4ma              
ST_Aspect              
ST_HillShade              
ST_Roughness              
ST_Slope              
ST_TPI              
ST_TRI              
Box3D            
ST_ConvexHull            
ST_DumpAsPolygons              
ST_Envelope            
ST_MinConvexHull            
ST_Polygon            
&&            
&<              
&>              
=              
@            
~=              
~            
ST_Contains              
ST_ContainsProperly              
ST_Covers              
ST_CoveredBy              
ST_Disjoint              
ST_Intersects            
ST_Overlaps              
ST_Touches              
ST_SameAlignment              
ST_NotSameAlignmentReason              
ST_Within              
ST_DWithin              
ST_DFullyWithin              
stdaddr              
rules table              
lex table              
gaz table              
debug_standardize_address              
parse_address              
standardize_address              
Drop_Indexes_Generate_Script              
Drop_Nation_Tables_Generate_Script              
Drop_State_Tables_Generate_Script              
Geocode            
Geocode_Intersection            
Get_Geocode_Setting              
Get_Tract            
Install_Missing_Indexes              
Loader_Generate_Census_Script              
Loader_Generate_Script              
Loader_Generate_Nation_Script              
Missing_Indexes_Generate_Script              
Normalize_Address              
Pagc_Normalize_Address              
Pprint_Addy              
Reverse_Geocode            
Topology_Load_Tiger              
Set_Geocode_Setting              

13.12. New, Enhanced or changed PostGIS Functions

13.12.1. PostGIS Functions new or enhanced in 3.6

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 3.6

  • CG_2DRotate - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Rotates a geometry by a given angle around a specified point in 2D.
  • CG_3DBuffer - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Computes a 3D buffer around a geometry.
  • CG_3DRotate - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Rotates a geometry in 3D space around an axis vector.
  • CG_3DScale - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Scales a geometry by separate factors along X, Y, and Z axes.
  • CG_3DScaleAroundCenter - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Scales a geometry in 3D space around a specified center point.
  • CG_3DTranslate - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Translates (moves) a geometry by given offsets in 3D space.
  • CG_Rotate - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Rotates a geometry by a given angle around the origin (0,0).
  • CG_RotateX - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Rotates a geometry around the X-axis by a given angle.
  • CG_RotateY - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Rotates a geometry around the Y-axis by a given angle.
  • CG_RotateZ - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Rotates a geometry around the Z-axis by a given angle.
  • CG_Scale - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Scales a geometry uniformly in all dimensions by a given factor.
  • CG_StraightSkeletonPartition - Availability: 3.6.0 - requires SFCGAL >= 2.0.0. Computes the straight skeleton partition of a polygon.
  • CG_Translate - Availability: 3.6.0 - requires SFCGAL >= 2.0.0 Translates (moves) a geometry by given offsets in 2D space.
  • ST_AsRasterAgg - Availability: 3.6.0 Aggregate. Renders PostGIS geometries into a new raster.

13.12.2. PostGIS Functions new or enhanced in 3.5

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 3.5

  • CG_3DArea - Availability: 3.5.0 Computes area of 3D surface geometries. Will return 0 for solids.
  • CG_3DConvexHull - Availability: 3.5.0 Computes the 3D convex hull of a geometry.
  • CG_3DDifference - Availability: 3.5.0 Perform 3D difference
  • CG_3DDistance - Availability: 3.5.0 Computes the minimum 3D distance between two geometries
  • CG_3DIntersection - Availability: 3.5.0 Perform 3D intersection
  • CG_3DIntersects - Availability: 3.5.0 Tests if two 3D geometries intersect
  • CG_3DUnion - Availability: 3.5.0 Perform 3D union using postgis_sfcgal.
  • CG_AlphaShape - Availability: 3.5.0 - requires SFCGAL >= 1.4.1. Computes an Alpha-shape enclosing a geometry
  • CG_ApproxConvexPartition - Availability: 3.5.0 - requires SFCGAL >= 1.5.0. Computes approximal convex partition of the polygon geometry
  • CG_ApproximateMedialAxis - Availability: 3.5.0 Compute the approximate medial axis of an areal geometry.
  • CG_Area - Availability: 3.5.0 Calculates the area of a geometry
  • CG_Difference - Availability: 3.5.0 Computes the geometric difference between two geometries
  • CG_Distance - Availability: 3.5.0 Computes the minimum distance between two geometries
  • CG_Extrude - Availability: 3.5.0 Extrude a surface to a related volume
  • CG_ExtrudeStraightSkeleton - Availability: 3.5.0 - requires SFCGAL >= 1.5.0. Straight Skeleton Extrusion
  • CG_ForceLHR - Availability: 3.5.0 Force LHR orientation
  • CG_GreeneApproxConvexPartition - Availability: 3.5.0 - requires SFCGAL >= 1.5.0. Computes approximal convex partition of the polygon geometry
  • CG_Intersection - Availability: 3.5.0 Computes the intersection of two geometries
  • CG_Intersects - Availability: 3.5.0 Tests if two geometries intersect (they have at least one point in common)
  • CG_IsPlanar - Availability: 3.5.0 Check if a surface is or not planar
  • CG_IsSolid - Availability: 3.5.0 Test if the geometry is a solid. No validity check is performed.
  • CG_MakeSolid - Availability: 3.5.0 Cast the geometry into a solid. No check is performed. To obtain a valid solid, the input geometry must be a closed Polyhedral Surface or a closed TIN.
  • CG_MinkowskiSum - Availability: 3.5.0 Performs Minkowski sum
  • CG_OptimalAlphaShape - Availability: 3.5.0 - requires SFCGAL >= 1.4.1. Computes an Alpha-shape enclosing a geometry using an "optimal" alpha value.
  • CG_OptimalConvexPartition - Availability: 3.5.0 - requires SFCGAL >= 1.5.0. Computes an optimal convex partition of the polygon geometry
  • CG_Orientation - Availability: 3.5.0 Determine surface orientation
  • CG_StraightSkeleton - Availability: 3.5.0 Compute a straight skeleton from a geometry
  • CG_Tesselate - Availability: 3.5.0 Perform surface Tessellation of a polygon or polyhedralsurface and returns as a TIN or collection of TINS
  • CG_Triangulate - Availability: 3.5.0 Triangulates a polygonal geometry
  • CG_Union - Availability: 3.5.0 Computes the union of two geometries
  • CG_Visibility - Availability: 3.5.0 - requires SFCGAL >= 1.5.0. Compute a visibility polygon from a point or a segment in a polygon geometry
  • CG_Volume - Availability: 3.5.0 Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.
  • CG_YMonotonePartition - Availability: 3.5.0 - requires SFCGAL >= 1.5.0. Computes y-monotone partition of the polygon geometry
  • ST_HasM - Availability: 3.5.0 Checks if a geometry has an M (measure) dimension.
  • ST_HasZ - Availability: 3.5.0 Checks if a geometry has a Z dimension.
  • ST_RemoveIrrelevantPointsForView - Availability: 3.5.0 Removes points that are irrelevant for rendering a specific rectangluar view of a geometry.
  • ST_RemoveSmallParts - Availability: 3.5.0 Removes small parts (polygon rings or linestrings) of a geometry.
  • TopoGeo_LoadGeometry - Availability: 3.5.0 Load a geometry into an existing topology, snapping and splitting as needed.

Functions enhanced in PostGIS 3.5

  • ST_Clip - Enhanced: 3.5.0 - touched argument added. Returns the raster clipped by the input geometry. If band number is not specified, all bands are processed. If crop is not specified or TRUE, the output raster is cropped. If touched is set to TRUE, then touched pixels are included, otherwise only if the center of the pixel is in the geometry it is included.

Functions changed in PostGIS 3.5

  • ST_AsGeoJSON - Changed: 3.5.0 allow specifying the column containing the feature id Return a geometry or feature in GeoJSON format.
  • ST_DFullyWithin - Changed: 3.5.0 : the logic behind the function now uses a test of containment within a buffer, rather than the ST_MaxDistance algorithm. Results will differ from prior versions, but should be closer to user expectations. Tests if a geometry is entirely inside a distance of another

13.12.3. PostGIS Functions new or enhanced in 3.4

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 3.4

  • PostGIS_GEOS_Compiled_Version - Availability: 3.4.0 Returns the version number of the GEOS library against which PostGIS was built.
  • PostGIS_PROJ_Compiled_Version - Availability: 3.5.0 Returns the version number of the PROJ library against which PostGIS was built.
  • RenameTopoGeometryColumn - Availability: 3.4.0 Renames a topogeometry column
  • RenameTopology - Availability: 3.4.0 Renames a topology
  • ST_ClusterIntersectingWin - Availability: 3.4.0 Window function that returns a cluster id for each input geometry, clustering input geometries into connected sets.
  • ST_ClusterWithinWin - Availability: 3.4.0 Window function that returns a cluster id for each input geometry, clustering using separation distance.
  • ST_CoverageInvalidEdges - Availability: 3.4.0 Window function that finds locations where polygons fail to form a valid coverage.
  • ST_CoverageSimplify - Availability: 3.4.0 Window function that simplifies the edges of a polygonal coverage.
  • ST_CoverageUnion - Availability: 3.4.0 - requires GEOS >= 3.8.0 Computes the union of a set of polygons forming a coverage by removing shared edges.
  • ST_InverseTransformPipeline - Availability: 3.4.0 Return a new geometry with coordinates transformed to a different spatial reference system using the inverse of a defined coordinate transformation pipeline.
  • ST_LargestEmptyCircle - Availability: 3.4.0. Computes the largest circle not overlapping a geometry.
  • ST_LineExtend - Availability: 3.4.0 Returns a line extended forwards and backwards by specified distances.
  • ST_TransformPipeline - Availability: 3.4.0 Return a new geometry with coordinates transformed to a different spatial reference system using a defined coordinate transformation pipeline.
  • TopoElement - Availability: 3.4.0 Converts a topogeometry to a topoelement.
  • debug_standardize_address - Availability: 3.4.0 Returns a json formatted text listing the parse tokens and standardizations
  • postgis_srs - Availability: 3.4.0 Return a metadata record for the requested authority and srid.
  • postgis_srs_all - Availability: 3.4.0 Return metadata records for every spatial reference system in the underlying Proj database.
  • postgis_srs_codes - Availability: 3.4.0 Return the list of SRS codes associated with the given authority.
  • postgis_srs_search - Availability: 3.4.0 Return metadata records for projected coordinate systems that have areas of usage that fully contain the bounds parameter.

Functions enhanced in PostGIS 3.4

  • PostGIS_Full_Version - Enhanced: 3.4.0 now includes extra PROJ configurations NETWORK_ENABLED, URL_ENDPOINT and DATABASE_PATH of proj.db location Reports full PostGIS version and build configuration infos.
  • PostGIS_PROJ_Version - Enhanced: 3.4.0 now includes NETWORK_ENABLED, URL_ENDPOINT and DATABASE_PATH of proj.db location Returns the version number of the PROJ4 library.
  • ST_AsSVG - Enhanced: 3.4.0 to support all curve types Returns SVG path data for a geometry.
  • ST_ClosestPoint - Enhanced: 3.4.0 - Support for geography. Returns the 2D point on g1 that is closest to g2. This is the first point of the shortest line from one geometry to the other.
  • ST_LineSubstring - Enhanced: 3.4.0 - Support for geography was introduced. Returns the part of a line between two fractional locations.
  • ST_Project - Enhanced: 3.4.0 Allow geometry arguments and two-point form omitting azimuth. Returns a point projected from a start point by a distance and bearing (azimuth).
  • ST_Resample - Enhanced: 3.4.0 max and min resampling options added 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.
  • ST_Rescale - Enhanced: 3.4.0 max and min resampling options added 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, Lanczos, Max or Min resampling algorithm. Default is NearestNeighbor.
  • ST_ShortestLine - Enhanced: 3.4.0 - support for geography. Returns the 2D shortest line between two geometries

Functions changed in PostGIS 3.4

  • PostGIS_Extensions_Upgrade - Changed: 3.4.0 to add target_version argument. Packages and upgrades PostGIS extensions (e.g. postgis_raster, postgis_topology, postgis_sfcgal) to given or latest version.

13.12.4. PostGIS Functions new or enhanced in 3.3

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 3.3

  • RemoveUnusedPrimitives - Availability: 3.3.0 Removes topology primitives which not needed to define existing TopoGeometry objects.
  • ST_3DConvexHull - Availability: 3.3.0 Computes the 3D convex hull of a geometry.
  • ST_3DUnion - Availability: 3.3.0 aggregate variant was added Perform 3D union.
  • ST_AsMARC21 - Availability: 3.3.0 Returns geometry as a MARC21/XML record with a geographic datafield (034).
  • ST_GeomFromMARC21 - Availability: 3.3.0, requires libxml2 2.6+ Takes MARC21/XML geographic data as input and returns a PostGIS geometry object.
  • ST_Letters - Availability: 3.3.0 Returns the input letters rendered as geometry with a default start position at the origin and default text height of 100.
  • ST_OptimalAlphaShape - Availability: 3.3.0 - requires SFCGAL >= 1.4.1. Computes an Alpha-shape enclosing a geometry using an "optimal" alpha value.
  • ST_SimplifyPolygonHull - Availability: 3.3.0. Computes a simplifed topology-preserving outer or inner hull of a polygonal geometry.
  • ST_TriangulatePolygon - Availability: 3.3.0. Computes the constrained Delaunay triangulation of polygons
  • postgis_sfcgal_full_version - Availability: 3.3.0 Returns the full version of SFCGAL in use including CGAL and Boost versions

Functions enhanced in PostGIS 3.3

  • ST_ConcaveHull - Enhanced: 3.3.0, GEOS native implementation enabled for GEOS 3.11+ Computes a possibly concave geometry that contains all input geometry vertices
  • ST_LineMerge - Enhanced: 3.3.0 accept a directed parameter. Return the lines formed by sewing together a MultiLineString.

Functions changed in PostGIS 3.3

  • PostGIS_Extensions_Upgrade - Changed: 3.3.0 support for upgrades from any PostGIS version. Does not work on all systems. Packages and upgrades PostGIS extensions (e.g. postgis_raster, postgis_topology, postgis_sfcgal) to given or latest version.

13.12.5. PostGIS Functions new or enhanced in 3.2

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 3.2

  • FindLayer - Availability: 3.2.0 Returns a topology.layer record by different means.
  • FindTopology - Availability: 3.2.0 Returns a topology record by different means.
  • GetFaceContainingPoint - Availability: 3.2.0 Finds the face containing a point.
  • ST_AsFlatGeobuf - Availability: 3.2.0 Return a FlatGeobuf representation of a set of rows.
  • ST_Contour - Availability: 3.2.0 Generates a set of vector contours from the provided raster band, using the GDAL contouring algorithm.
  • ST_DumpSegments - Availability: 3.2.0 Devuelve un conjunto de geometry_dump filas para los segmentos de una geometría.
  • ST_FromFlatGeobuf - Availability: 3.2.0 Reads FlatGeobuf data.
  • ST_FromFlatGeobufToTable - Availability: 3.2.0 Creates a table based on the structure of FlatGeobuf data.
  • ST_InterpolateRaster - Availability: 3.2.0 Interpolates a gridded surface based on an input set of 3-d points, using the X- and Y-values to position the points on the grid and the Z-value of the points as the surface elevation.
  • ST_SRID - Availability: 3.2.0 Returns the spatial reference identifier for a topogeometry.
  • ST_Scroll - Availability: 3.2.0 Change start point of a closed LineString.
  • ST_SetM - Availability: 3.2.0 Returns a geometry with the same X/Y coordinates as the input geometry, and values from the raster copied into the M dimension using the requested resample algorithm.
  • ST_SetZ - Availability: 3.2.0 Returns a geometry with the same X/Y coordinates as the input geometry, and values from the raster copied into the Z dimension using the requested resample algorithm.
  • TopoGeom_addTopoGeom - Availability: 3.2 Adds element of a TopoGeometry to the definition of another TopoGeometry.
  • ValidateTopologyRelation - Availability: 3.2.0 Returns info about invalid topology relation records
  • postgis.gdal_vsi_options - Availability: 3.2.0 A string configuration to set options used when working with an out-db raster.

Functions enhanced in PostGIS 3.2

  • GetFaceByPoint - Enhanced: 3.2.0 more efficient implementation and clearer contract, stops working with invalid topologies. Finds face intersecting a given point.
  • ST_ClusterKMeans - Enhanced: 3.2.0 Support for max_radius Window function that returns a cluster id for each input geometry using the K-means algorithm.
  • ST_MakeValid - Enhanced: 3.2.0, added algorithm options, 'linework' and 'structure' which requires GEOS >= 3.10.0. Attempts to make an invalid geometry valid without losing vertices.
  • ST_PixelAsCentroid - Enhanced: 3.2.0 Faster now implemented in C. Returns the centroid (point geometry) of the area represented by a pixel.
  • ST_PixelAsCentroids - Enhanced: 3.2.0 Faster now implemented in C. 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.
  • ST_Point - Enhanced: 3.2.0 srid as an extra optional argument was added. Older installs require combining with ST_SetSRID to mark the srid on the geometry. Creates a Point with X, Y and SRID values.
  • ST_PointM - Enhanced: 3.2.0 srid as an extra optional argument was added. Older installs require combining with ST_SetSRID to mark the srid on the geometry. Creates a Point with X, Y, M and SRID values.
  • ST_PointZ - Enhanced: 3.2.0 srid as an extra optional argument was added. Older installs require combining with ST_SetSRID to mark the srid on the geometry. Creates a Point with X, Y, Z and SRID values.
  • ST_PointZM - Enhanced: 3.2.0 srid as an extra optional argument was added. Older installs require combining with ST_SetSRID to mark the srid on the geometry. Creates a Point with X, Y, Z, M and SRID values.
  • ST_RemovePoint - Enhanced: 3.2.0 Remove a point from a linestring.
  • ST_RemoveRepeatedPoints - Enhanced: 3.2.0 Returns a version of a geometry with duplicate points removed.
  • ST_StartPoint - Enhanced: 3.2.0 returns a point for all geometries. Prior behavior returns NULLs if input was not a LineString. Returns the first point of a LineString.
  • ST_Value - Enhanced: 3.2.0 resample optional argument was added. 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.
  • TopoGeo_AddLineString - Enhanced: 3.2.0 added support for returning signed identifier. Adds a linestring to an existing topology using a tolerance and possibly splitting existing edges/faces.

Functions changed in PostGIS 3.2

  • ST_Boundary - Changed: 3.2.0 support for TIN, does not use geos, does not linearize curves Devuelve el cierre del limite combinatorio de esta geometría.
  • ValidateTopology - Changed: 3.2.0 added optional bbox parameter, perform face labeling and edge linking checks. Devuelve un conjunto de objetos validatetopology_returntype que detallan problemas con la topología.

13.12.6. PostGIS Functions new or enhanced in 3.1

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 3.1

  • ST_Hexagon - Disponibilidad: 2.1.0 Returns a single hexagon, using the provided edge size and cell coordinate within the hexagon grid space.
  • ST_HexagonGrid - Disponibilidad: 2.1.0 Returns a set of hexagons and cell indices that completely cover the bounds of the geometry argument.
  • ST_MaximumInscribedCircle - Availability: 3.1.0. Computes the largest circle contained within a geometry.
  • ST_ReducePrecision - Availability: 3.1.0. Returns a valid geometry with points rounded to a grid tolerance.
  • ST_Square - Disponibilidad: 2.1.0 Returns a single square, using the provided edge size and cell coordinate within the square grid space.
  • ST_SquareGrid - Disponibilidad: 2.1.0 Returns a set of grid squares and cell indices that completely cover the bounds of the geometry argument.

Functions enhanced in PostGIS 3.1

  • ST_AsEWKT - Enhanced: 3.1.0 support for optional precision parameter. Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
  • ST_ClusterKMeans - Enhanced: 3.1.0 Support for 3D geometries and weights Window function that returns a cluster id for each input geometry using the K-means algorithm.
  • ST_Difference - Enhanced: 3.1.0 accept a gridSize parameter. Computes a geometry representing the part of geometry A that does not intersect geometry B.
  • ST_Intersection - Enhanced: 3.1.0 accept a gridSize parameter Computes a geometry representing the shared portion of geometries A and B.
  • ST_MakeValid - Enhanced: 3.1.0, added removal of Coordinates with NaN values. Attempts to make an invalid geometry valid without losing vertices.
  • ST_Subdivide - Enhanced: 3.1.0 accept a gridSize parameter. Computes a rectilinear subdivision of a geometry.
  • ST_SymDifference - Enhanced: 3.1.0 accept a gridSize parameter. Computes a geometry representing the portions of geometries A and B that do not intersect.
  • ST_TileEnvelope - Mejorada: 2.0.0 se agregó el parámetro por defecto opcional srid. Creates a rectangular Polygon in Web Mercator (SRID:3857) using the XYZ tile system.
  • ST_UnaryUnion - Enhanced: 3.1.0 accept a gridSize parameter. Computes the union of the components of a single geometry.
  • ST_Union - Enhanced: 3.1.0 accept a gridSize parameter. Computes a geometry representing the point-set union of the input geometries.

Functions changed in PostGIS 3.1

  • ST_Count - Changed: 3.1.0 - The ST_Count(rastertable, rastercolumn, ...) variants removed. Use instead. 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.
  • ST_Force3D - Changed: 3.1.0. Added support for supplying a non-zero Z value. Forzar las geometrías en modo XYZ. Este es un alias para ST_Force3DZ.
  • ST_Force3DM - Changed: 3.1.0. Added support for supplying a non-zero M value. Fuerza las geometrías en modo XYM.
  • ST_Force3DZ - Changed: 3.1.0. Added support for supplying a non-zero Z value. Fuerza las geometrías en modo XYZ.
  • ST_Force4D - Changed: 3.1.0. Added support for supplying non-zero Z and M values. Fuerza las geometrías en modo XYZM.
  • ST_Histogram - Changed: 3.1.0 Removed ST_Histogram(table_name, column_name) variant. Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified.
  • ST_Quantile - Changed: 3.1.0 Removed ST_Quantile(table_name, column_name) variant. 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 raster's 25%, 50%, 75% percentile.
  • ST_SummaryStats - Changed: 3.1.0 ST_SummaryStats(rastertable, rastercolumn, ...) variants are removed. Use instead. 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.

13.12.7. PostGIS Functions new or enhanced in 3.0

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 3.0

  • CG_ConstrainedDelaunayTriangles - Disponibilidad: 2.1.0 Return a constrained Delaunay triangulation around the given input geometry.
  • ST_3DLineInterpolatePoint - Disponibilidad: 2.1.0 Returns a point interpolated along a 3D line at a fractional location.
  • ST_ConstrainedDelaunayTriangles - Disponibilidad: 2.1.0 Return a constrained Delaunay triangulation around the given input geometry.
  • ST_TileEnvelope - Disponibilidad: 2.1.0 Creates a rectangular Polygon in Web Mercator (SRID:3857) using the XYZ tile system.

Functions enhanced in PostGIS 3.0

  • ST_AsMVT - Enhanced: 3.0 - added support for Feature ID. Aggregate function returning a MVT representation of a set of rows.
  • ST_Contains - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if every point of B lies in A, and their interiors have a point in common
  • ST_ContainsProperly - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if every point of B lies in the interior of A
  • ST_CoveredBy - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if every point of A lies in B
  • ST_Covers - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if every point of B lies in A
  • ST_Crosses - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if two geometries have some, but not all, interior points in common
  • ST_CurveToLine - Enhanced: 3.0.0 implemented a minimum number of segments per linearized arc to prevent topological collapse. Converts a geometry containing curves to a linear geometry.
  • ST_Disjoint - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if two geometries have no points in common
  • ST_Equals - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if two geometries include the same set of points
  • ST_GeneratePoints - Enhanced: 3.0.0, added seed parameter Generates a multipoint of random points contained in a Polygon or MultiPolygon.
  • ST_GeomFromGeoJSON - Enhanced: 3.0.0 parsed geometry defaults to SRID=4326 if not specified otherwise. Toma como entrada una representación geojson de una geometría y devuelve un objeto geométrico PostGIS
  • ST_LocateBetween - Enhanced: 3.0.0 - added support for POLYGON, TIN, TRIANGLE. Returns the portions of a geometry that match a measure range.
  • ST_LocateBetweenElevations - Enhanced: 3.0.0 - added support for POLYGON, TIN, TRIANGLE. Returns the portions of a geometry that lie in an elevation (Z) range.
  • ST_Overlaps - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if two geometries have the same dimension and intersect, but each has at least one point not in the other
  • ST_Relate - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if two geometries have a topological relationship matching an Intersection Matrix pattern, or computes their Intersection Matrix
  • ST_Segmentize - Enhanced: 3.0.0 Segmentize geometry now produces equal-length subsegments Returns a modified geometry/geography having no segment longer than a given distance.
  • ST_Touches - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if two geometries have at least one point in common, but their interiors do not intersect
  • ST_Within - Enhanced: 3.0.0 enabled support for GEOMETRYCOLLECTION Tests if every point of A lies in B, and their interiors have a point in common

Functions changed in PostGIS 3.0

  • PostGIS_Extensions_Upgrade - Changed: 3.0.0 to repackage loose extensions and support postgis_raster. Packages and upgrades PostGIS extensions (e.g. postgis_raster, postgis_topology, postgis_sfcgal) to given or latest version.
  • ST_3DDistance - Changed: 3.0.0 - SFCGAL version removed Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DIntersects - Changed: 3.0.0 SFCGAL backend removed, GEOS backend supports TINs. Tests if two geometries spatially intersect in 3D - only for points, linestrings, polygons, polyhedral surface (area)
  • ST_Area - Changed: 3.0.0 - does not depend on SFCGAL anymore. Returns the area of a polygonal geometry.
  • ST_AsGeoJSON - Changed: 3.0.0 support records as input Return a geometry or feature in GeoJSON format.
  • ST_AsGeoJSON - Changed: 3.0.0 output SRID if not EPSG:4326. Return a geometry or feature in GeoJSON format.
  • ST_AsKML - Changed: 3.0.0 - Removed the "versioned" variant signature Return the geometry as a KML element.
  • ST_Distance - Changed: 3.0.0 - does not depend on SFCGAL anymore. Returns the distance between two geometry or geography values.
  • ST_Intersection - Changed: 3.0.0 does not depend on SFCGAL. Computes a geometry representing the shared portion of geometries A and B.
  • ST_Intersects - Changed: 3.0.0 SFCGAL version removed and native support for 2D TINS added. Tests if two geometries intersect (they have at least one point in common)
  • ST_Union - Changed: 3.0.0 does not depend on SFCGAL. Computes a geometry representing the point-set union of the input geometries.

13.12.8. PostGIS Functions new or enhanced in 2.5

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 2.5

  • PostGIS_Extensions_Upgrade - Availability: 2.5.0 Packages and upgrades PostGIS extensions (e.g. postgis_raster, postgis_topology, postgis_sfcgal) to given or latest version.
  • ST_Angle - Availability: 2.5.0 Returns the angle between two vectors defined by 3 or 4 points, or 2 lines.
  • ST_AsHexWKB - Availability: 2.5.0 Return the Well-Known Binary (WKB) in Hex representation of the raster.
  • ST_BandFileSize - Availability: 2.5.0 Returns the file size of a band stored in file system. If no bandnum specified, 1 is assumed.
  • ST_BandFileTimestamp - Availability: 2.5.0 Returns the file timestamp of a band stored in file system. If no bandnum specified, 1 is assumed.
  • ST_ChaikinSmoothing - Availability: 2.5.0 Returns a smoothed version of a geometry, using the Chaikin algorithm
  • ST_FilterByM - Availability: 2.5.0 Removes vertices based on their M value
  • ST_Grayscale - Availability: 2.5.0 Creates a new one-8BUI band raster from the source raster and specified bands representing Red, Green and Blue
  • ST_LineInterpolatePoints - Availability: 2.5.0 Returns points interpolated along a line at a fractional interval.
  • ST_OrientedEnvelope - Availability: 2.5.0. Returns a minimum-area rectangle containing a geometry.
  • ST_QuantizeCoordinates - Availability: 2.5.0 Sets least significant bits of coordinates to zero
  • ST_RastFromHexWKB - Availability: 2.5.0 Return a raster value from a Hex representation of Well-Known Binary (WKB) raster.
  • ST_RastFromWKB - Availability: 2.5.0 Return a raster value from a Well-Known Binary (WKB) raster.
  • ST_SetBandIndex - Availability: 2.5.0 Update the external band number of an out-db band
  • ST_SetBandPath - Availability: 2.5.0 Update the external path and band number of an out-db band

Functions enhanced in PostGIS 2.5

  • ST_AsBinary/ST_AsWKB - Enhanced: 2.5.0 Addition of ST_AsWKB Return the Well-Known Binary (WKB) representation of the raster.
  • ST_AsMVT - Enhanced: 2.5.0 - added support parallel query. Aggregate function returning a MVT representation of a set of rows.
  • ST_AsText - Enhanced: 2.5 - optional parameter precision introduced. Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
  • ST_BandMetaData - Enhanced: 2.5.0 to include outdbbandnum, filesize and filetimestamp for outdb rasters. Returns basic meta data for a specific raster band. band num 1 is assumed if none-specified.
  • ST_Buffer - Enhanced: 2.5.0 - ST_Buffer geometry support was enhanced to allow for side buffering specification side=both|left|right. Computes a geometry covering all points within a given distance from a geometry.
  • ST_GeomFromGeoJSON - Enhanced: 2.5.0 can now accept json and jsonb as inputs. Toma como entrada una representación geojson de una geometría y devuelve un objeto geométrico PostGIS
  • ST_GeometricMedian - Enhanced: 2.5.0 Added support for M as weight of points. Returns the geometric median of a MultiPoint.
  • ST_Intersects - Enhanced: 2.5.0 Supports GEOMETRYCOLLECTION. Tests if two geometries intersect (they have at least one point in common)
  • ST_OffsetCurve - Enhanced: 2.5 - added support for GEOMETRYCOLLECTION and MULTILINESTRING Returns an offset line at a given distance and side from an input line.
  • ST_Scale - Enhanced: 2.5.0 support for scaling relative to a local origin (origin parameter) was introduced. Scales a geometry by given factors.
  • ST_Split - Enhanced: 2.5.0 support for splitting a polygon by a multiline was introduced. Returns a collection of geometries created by splitting a geometry by another geometry.
  • ST_Subdivide - Enhanced: 2.5.0 reuses existing points on polygon split, vertex count is lowered from 8 to 5. Computes a rectilinear subdivision of a geometry.

Functions changed in PostGIS 2.5

  • ST_GDALDrivers - Changed: 2.5.0 - add can_read and can_write columns. Returns a list of raster formats supported by PostGIS through GDAL. Only those formats with can_write=True can be used by ST_AsGDALRaster

13.12.9. PostGIS Functions new or enhanced in 2.4

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 2.4

  • ST_AsGeobuf - Disponibilidad: 2.2.0 Return a Geobuf representation of a set of rows.
  • ST_AsMVT - Disponibilidad: 2.2.0 Aggregate function returning a MVT representation of a set of rows.
  • ST_AsMVTGeom - Disponibilidad: 2.2.0 Transforms a geometry into the coordinate space of a MVT tile.
  • ST_Centroid - Availability: 2.4.0 support for geography was introduced. Returns the geometric center of a geometry.
  • ST_ForcePolygonCCW - Disponibilidad: 2.2.0 Orienta todos los aros exteriores en sentido contrario a las agujas del reloj y todos los aros interiores en sentido horario.
  • ST_ForcePolygonCW - Disponibilidad: 2.2.0 Orienta todos los anillos exteriores en el sentido de las agujas del reloj y todos los anillos interiores en sentido contrario a las agujas del reloj.
  • ST_FrechetDistance - Availability: 2.4.0 - requires GEOS >= 3.7.0 Returns the Fréchet distance between two geometries.
  • ST_IsPolygonCCW - Disponibilidad: 2.2.0 Devuelve true si todos los aros exteriores están orientados hacia la izquierda y todos los aros interiores están orientados hacia la derecha.
  • ST_IsPolygonCW - Disponibilidad: 2.2.0 Devuelve true si todos los aros exteriores están orientados hacia la derecha y todos los aros interiores están orientados en sentido contrario a las agujas del reloj.
  • ST_MakeEmptyCoverage - Disponibilidad: 2.2.0 Cover georeferenced area with a grid of empty raster tiles.

Functions enhanced in PostGIS 2.4

  • Loader_Generate_Nation_Script - Enhanced: 2.4.1 zip code 5 tabulation area (zcta5) load step was fixed and when enabled, zcta5 data is loaded as a single table called zcta5_all as part of the nation script load. Generates a shell script for the specified platform that loads in the county and state lookup tables.
  • Normalize_Address - Enhanced: 2.4.0 norm_addy object includes additional fields zip4 and address_alphanumeric. Given a textual street address, returns a composite norm_addy type that has road suffix, prefix and type standardized, street, streetname etc. broken into separate fields. This function will work with just the lookup data packaged with the tiger_geocoder (no need for tiger census data).
  • Pagc_Normalize_Address - Enhanced: 2.4.0 norm_addy object includes additional fields zip4 and address_alphanumeric. Given a textual street address, returns a composite norm_addy type that has road suffix, prefix and type standardized, street, streetname etc. broken into separate fields. This function will work with just the lookup data packaged with the tiger_geocoder (no need for tiger census data). Requires address_standardizer extension.
  • Reverse_Geocode - Enhanced: 2.4.1 if optional zcta5 dataset is loaded, the reverse_geocode function can resolve to state and zip even if the specific state data is not loaded. Refer to for details on loading zcta5 data. Takes a geometry point in a known spatial ref sys and returns a record containing an array of theoretically possible addresses and an array of cross streets. If include_strnum_range = true, includes the street range in the cross streets.
  • ST_AsTWKB - Enhanced: 2.4.0 memory and speed improvements. Returns the geometry as TWKB, aka "Tiny Well-Known Binary"
  • ST_Covers - Enhanced: 2.4.0 Support for polygon in polygon and line in polygon added for geography type Tests if every point of B lies in A
  • ST_CurveToLine - Enhanced: 2.4.0 added support for max-deviation and max-angle tolerance, and for symmetric output. Converts a geometry containing curves to a linear geometry.
  • ST_Project - Enhanced: 2.4.0 Allow negative distance and non-normalized azimuth. Returns a point projected from a start point by a distance and bearing (azimuth).
  • ST_Reverse - Mejorada: 2.4.0 se introdujo el soporte para curvas. Devuelve la geometría con el orden de vértice invertido.

Functions changed in PostGIS 2.4

  • = - Changed: 2.4.0, in prior versions this was bounding box equality not a geometric equality. If you need bounding box equality, use instead. Returns TRUE if the coordinates and coordinate order geometry/geography A are the same as the coordinates and coordinate order of geometry/geography B.
  • ST_Node - Changed: 2.4.0 this function uses GEOSNode internally instead of GEOSUnaryUnion. This may cause the resulting linestrings to have a different order and direction compared to PostGIS < 2.4. Nodes a collection of lines.

13.12.10. PostGIS Functions new or enhanced in 2.3

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 2.3

  • &&&(geometry,gidx) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a geometry's (cached) n-D bounding box intersects a n-D float precision bounding box (GIDX).
  • &&&(gidx,geometry) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a n-D float precision bounding box (GIDX) intersects a geometry's (cached) n-D bounding box.
  • &&&(gidx,gidx) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if two n-D float precision bounding boxes (GIDX) intersect each other.
  • &&(box2df,box2df) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if two 2D float precision bounding boxes (BOX2DF) intersect each other.
  • &&(box2df,geometry) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a 2D float precision bounding box (BOX2DF) intersects a geometry's (cached) 2D bounding box.
  • &&(geometry,box2df) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a geometry's (cached) 2D bounding box intersects a 2D float precision bounding box (BOX2DF).
  • @(box2df,box2df) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a 2D float precision bounding box (BOX2DF) is contained into another 2D float precision bounding box.
  • @(box2df,geometry) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a 2D float precision bounding box (BOX2DF) is contained into a geometry's 2D bounding box.
  • @(geometry,box2df) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a geometry's 2D bounding box is contained into a 2D float precision bounding box (BOX2DF).
  • Populate_Topology_Layer - Disponibilidad: 2.3.0 Agrega entradas faltantes a la tabla topology.layer mediante la lectura de metadatos de las tablas de topo.
  • ST_ClusterDBSCAN - Disponibilidad: 2.3.0 Window function that returns a cluster id for each input geometry using the DBSCAN algorithm.
  • ST_ClusterKMeans - Disponibilidad: 2.3.0 Window function that returns a cluster id for each input geometry using the K-means algorithm.
  • ST_GeneratePoints - Disponibilidad: 2.3.0 Generates a multipoint of random points contained in a Polygon or MultiPolygon.
  • ST_GeometricMedian - Disponibilidad: 2.3.0 Returns the geometric median of a MultiPoint.
  • ST_MakeLine - Disponibilidad: 2.3.0 - Se introdujo soporte para elementos de entrada multipunto Crea una cadena de línea desde geometrías de punto, multipunto o de línea.
  • ST_MinimumBoundingRadius - Disponibilidad: 2.3.0 Returns the center point and radius of the smallest circle that contains a geometry.
  • ST_MinimumClearance - Disponibilidad: 2.3.0 Returns the minimum clearance of a geometry, a measure of a geometry's robustness.
  • ST_MinimumClearanceLine - Availability: 2.3.0 - requires GEOS >= 3.6.0 Returns the two-point LineString spanning a geometry's minimum clearance.
  • ST_Normalize - Disponibilidad: 2.3.0 Devuelve la geometría en su forma canónica.
  • ST_Points - Disponibilidad: 2.3.0 Devuelve un MultiPoint que contiene todas las coordenadas de una geometría.
  • ST_VoronoiLines - Disponibilidad: 2.3.0 Returns the boundaries of the Voronoi diagram of the vertices of a geometry.
  • ST_VoronoiPolygons - Disponibilidad: 2.3.0 Returns the cells of the Voronoi diagram of the vertices of a geometry.
  • ST_WrapX - Availability: 2.3.0 requires GEOS Wrap a geometry around an X value.
  • TopoGeom_addElement - Disponibilidad: 2.3 Agrega un elemento a la definición de una TopoGeometry.
  • TopoGeom_remElement - Disponibilidad: 2.3 Quita un elemento de la definición de una TopoGeometry.
  • ~(box2df,box2df) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a 2D float precision bounding box (BOX2DF) contains another 2D float precision bounding box (BOX2DF).
  • ~(box2df,geometry) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a 2D float precision bounding box (BOX2DF) contains a geometry's 2D bonding box.
  • ~(geometry,box2df) - Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+. Returns TRUE if a geometry's 2D bonding box contains a 2D float precision bounding box (GIDX).

Functions enhanced in PostGIS 2.3

  • ST_Contains - Enhanced: 2.3.0 Enhancement to PIP short-circuit extended to support MultiPoints with few points. Prior versions only supported point in polygon. Tests if every point of B lies in A, and their interiors have a point in common
  • ST_Covers - Enhanced: 2.3.0 Enhancement to PIP short-circuit for geometry extended to support MultiPoints with few points. Prior versions only supported point in polygon. Tests if every point of B lies in A
  • ST_Expand - Enhanced: 2.3.0 support was added to expand a box by different amounts in different dimensions. Returns a bounding box expanded from another bounding box or a geometry.
  • ST_Intersects - Enhanced: 2.3.0 Enhancement to PIP short-circuit extended to support MultiPoints with few points. Prior versions only supported point in polygon. Tests if two geometries intersect (they have at least one point in common)
  • ST_Segmentize - Enhanced: 2.3.0 Segmentize geography now produces equal-length subsegments Returns a modified geometry/geography having no segment longer than a given distance.
  • ST_Transform - Enhanced: 2.3.0 support for direct PROJ.4 text was introduced. Return a new geometry with coordinates transformed to a different spatial reference system.
  • ST_Within - Enhanced: 2.3.0 Enhancement to PIP short-circuit for geometry extended to support MultiPoints with few points. Prior versions only supported point in polygon. Tests if every point of A lies in B, and their interiors have a point in common

Functions changed in PostGIS 2.3

  • ST_PointN - Cambiado: 2.3.0: indexación negativa disponible (-1 es el último punto) Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.

13.12.11. PostGIS Functions new or enhanced in 2.2

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 2.2

  • <<->> - Availability: 2.2.0 -- KNN only available for PostgreSQL 9.1+ Returns the n-D distance between the A and B geometries or bounding boxes
  • ST_3DDifference - Disponibilidad: 2.2.0 Perform 3D difference
  • ST_3DUnion - Disponibilidad: 2.2.0 Perform 3D union.
  • ST_ApproximateMedialAxis - Disponibilidad: 2.2.0 Compute the approximate medial axis of an areal geometry.
  • ST_AsEncodedPolyline - Disponibilidad: 2.2.0 Returns an Encoded Polyline from a LineString geometry.
  • ST_AsTWKB - Disponibilidad: 2.2.0 Returns the geometry as TWKB, aka "Tiny Well-Known Binary"
  • ST_BoundingDiagonal - Disponibilidad: 2.2.0 Devuelve la diagonal del cuadro delimitador de la geometría suministrada.
  • ST_CPAWithin - Disponibilidad: 2.2.0 Tests if the closest point of approach of two trajectories is within the specified distance.
  • ST_ClipByBox2D - Disponibilidad: 2.2.0 Computes the portion of a geometry falling within a rectangle.
  • ST_ClosestPointOfApproach - Disponibilidad: 2.2.0 Returns a measure at the closest point of approach of two trajectories.
  • ST_ClusterIntersecting - Disponibilidad: 2.2.0 Aggregate function that clusters input geometries into connected sets.
  • ST_ClusterWithin - Disponibilidad: 2.2.0 Aggregate function that clusters geometries by separation distance.
  • ST_CountAgg - Disponibilidad: 2.2.0 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.
  • ST_CreateOverview - Disponibilidad: 2.2.0 Create an reduced resolution version of a given raster coverage.
  • ST_DistanceCPA - Disponibilidad: 2.2.0 Returns the distance between the closest point of approach of two trajectories.
  • ST_ForceCurve - Disponibilidad: 2.2.0 Relanzar una geometría en su tipo curvo, si corresponde.
  • ST_IsPlanar - Availability: 2.2.0: This was documented in 2.1.0 but got accidentally left out in 2.1 release. Check if a surface is or not planar
  • ST_IsSolid - Disponibilidad: 2.2.0 Test if the geometry is a solid. No validity check is performed.
  • ST_IsValidTrajectory - Disponibilidad: 2.2.0 Tests if the geometry is a valid trajectory.
  • ST_LineFromEncodedPolyline - Disponibilidad: 2.2.0 Crea un LineString desde una polilínea codificada.
  • ST_MakeSolid - Disponibilidad: 2.2.0 Cast the geometry into a solid. No check is performed. To obtain a valid solid, the input geometry must be a closed Polyhedral Surface or a closed TIN.
  • ST_MapAlgebra (callback function version) - Availability: 2.2.0: Ability to add a mask Callback function version - Returns a one-band raster given one or more input rasters, band indexes and one user-specified callback function.
  • ST_MemSize - Disponibilidad: 2.2.0 Returns the amount of space (in bytes) the raster takes.
  • ST_RemoveRepeatedPoints - Disponibilidad: 2.2.0 Returns a version of a geometry with duplicate points removed.
  • ST_Retile - Disponibilidad: 2.2.0 Return a set of configured tiles from an arbitrarily tiled raster coverage.
  • ST_SetEffectiveArea - Disponibilidad: 2.2.0 Sets the effective area for each vertex, using the Visvalingam-Whyatt algorithm.
  • ST_SimplifyVW - Disponibilidad: 2.2.0 Returns a simplified representation of a geometry, using the Visvalingam-Whyatt algorithm
  • ST_Subdivide - Disponibilidad: 2.2.0 Computes a rectilinear subdivision of a geometry.
  • ST_SummaryStatsAgg - Disponibilidad: 2.2.0 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.
  • ST_SwapOrdinates - Disponibilidad: 2.2.0 Returns a version of the given geometry with given ordinate values swapped.
  • ST_Volume - Disponibilidad: 2.2.0 Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.
  • parse_address - Disponibilidad: 2.2.0 Takes a 1 line address and breaks into parts
  • postgis.enable_outdb_rasters - Disponibilidad: 2.2.0 A boolean configuration option to enable access to out-db raster bands.
  • postgis.gdal_datapath - Disponibilidad: 2.2.0 A configuration option to assign the value of GDAL's GDAL_DATA option. If not set, the environmentally set GDAL_DATA variable is used.
  • postgis.gdal_enabled_drivers - Disponibilidad: 2.2.0 A configuration option to set the enabled GDAL drivers in the PostGIS environment. Affects the GDAL configuration variable GDAL_SKIP.
  • standardize_address - Disponibilidad: 2.2.0 Returns an stdaddr form of an input address utilizing lex, gaz, and rule tables.
  • |=| - Availability: 2.2.0. Index-supported only available for PostgreSQL 9.5+ Returns the distance between A and B trajectories at their closest point of approach.

Functions enhanced in PostGIS 2.2

  • <-> - Enhanced: 2.2.0 -- True KNN ("K nearest neighbor") behavior for geometry and geography for PostgreSQL 9.5+. Note for geography KNN is based on sphere rather than spheroid. For PostgreSQL 9.4 and below, geography support is new but only supports centroid box. Returns the 2D distance between A and B.
  • AsTopoJSON - Mejora: 2.2.1 agrega soporte para entradas puntuales. Devuelve la representación TopoJSON de una topogeometry.
  • ST_Area - Enhanced: 2.2.0 - measurement on spheroid performed with GeographicLib for improved accuracy and robustness. Requires PROJ >= 4.9.0 to take advantage of the new feature. Returns the area of a polygonal geometry.
  • ST_AsX3D - Enhanced: 2.2.0: Support for GeoCoordinates and axis (x/y, long/lat) flipping. Look at options for details. Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML
  • ST_Azimuth - Enhanced: 2.2.0 measurement on spheroid performed with GeographicLib for improved accuracy and robustness. Requires PROJ >= 4.9.0 to take advantage of the new feature. Returns the north-based azimuth of a line between two points.
  • ST_Distance - Enhanced: 2.2.0 - measurement on spheroid performed with GeographicLib for improved accuracy and robustness. Requires PROJ >= 4.9.0 to take advantage of the new feature. Returns the distance between two geometry or geography values.
  • ST_Scale - Enhanced: 2.2.0 support for scaling all dimension (factor parameter) was introduced. Scales a geometry by given factors.
  • ST_Split - Enhanced: 2.2.0 support for splitting a line by a multiline, a multipoint or (multi)polygon boundary was introduced. Returns a collection of geometries created by splitting a geometry by another geometry.
  • ST_Summary - Mejorado: 2.2.0 agregó soporte para TIN y curvas Devuelve un resumen de texto del contenido de la geometría.

Functions changed in PostGIS 2.2

  • <-> - Changed: 2.2.0 -- For PostgreSQL 9.5 users, old Hybrid syntax may be slower, so you'll want to get rid of that hack if you are running your code only on PostGIS 2.2+ 9.5+. See examples below. Returns the 2D distance between A and B.
  • Get_Geocode_Setting - Changed: 2.2.0 : default settings are now kept in a table called geocode_settings_default. Use customized settingsa are in geocode_settings and only contain those that have been set by user. Returns value of specific setting stored in tiger.geocode_settings table.
  • ST_3DClosestPoint - Changed: 2.2.0 - if 2 2D geometries are input, a 2D point is returned (instead of old behavior assuming 0 for missing Z). In case of 2D and 3D, Z is no longer assumed to be 0 for missing Z. Returns the 3D point on g1 that is closest to g2. This is the first point of the 3D shortest line.
  • ST_3DDistance - Changed: 2.2.0 - In case of 2D and 3D, Z is no longer assumed to be 0 for missing Z. Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DLongestLine - Changed: 2.2.0 - if 2 2D geometries are input, a 2D point is returned (instead of old behavior assuming 0 for missing Z). In case of 2D and 3D, Z is no longer assumed to be 0 for missing Z. Returns the 3D longest line between two geometries
  • ST_3DMaxDistance - Changed: 2.2.0 - In case of 2D and 3D, Z is no longer assumed to be 0 for missing Z. Returns the 3D cartesian maximum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DShortestLine - Changed: 2.2.0 - if 2 2D geometries are input, a 2D point is returned (instead of old behavior assuming 0 for missing Z). In case of 2D and 3D, Z is no longer assumed to be 0 for missing Z. Returns the 3D shortest line between two geometries
  • ST_DistanceSphere - Changed: 2.2.0 In prior versions this used to be called ST_Distance_Sphere Returns minimum distance in meters between two lon/lat geometries using a spherical earth model.
  • ST_DistanceSpheroid - Changed: 2.2.0 In prior versions this was called ST_Distance_Spheroid Returns the minimum distance between two lon/lat geometries using a spheroidal earth model.
  • ST_Equals - Changed: 2.2.0 Returns true even for invalid geometries if they are binary equal Tests if two geometries include the same set of points
  • ST_LengthSpheroid - Changed: 2.2.0 In prior versions this was called ST_Length_Spheroid and had the alias ST_3DLength_Spheroid Returns the 2D or 3D length/perimeter of a lon/lat geometry on a spheroid.
  • ST_MemSize - Changed: 2.2.0 name changed to ST_MemSize to follow naming convention. Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_PointInsideCircle - Changed: 2.2.0 In prior versions this was called ST_Point_Inside_Circle Tests if a point geometry is inside a circle defined by a center and radius
  • ValidateTopology - Modificado: 2.2.0 los valores para id1 e id2 se intercambiaron para 'borde cruza nodo' para ser consistente con la descripción del error. Devuelve un conjunto de objetos validatetopology_returntype que detallan problemas con la topología.

13.12.12. PostGIS Functions new or enhanced in 2.1

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 2.1

  • = - Disponibilidad: 2.1.0 Returns TRUE if A's bounding box is the same as B's. Uses double precision bounding box.
  • AsTopoJSON - Disponibilidad: 2.1.0 Devuelve la representación TopoJSON de una topogeometry.
  • Drop_Nation_Tables_Generate_Script - Disponibilidad: 2.1.0 Generates a script that drops all tables in the specified schema that start with county_all, state_all or state code followed by county or state.
  • Get_Geocode_Setting - Disponibilidad: 2.1.0 Returns value of specific setting stored in tiger.geocode_settings table.
  • Loader_Generate_Nation_Script - Disponibilidad: 2.1.0 Generates a shell script for the specified platform that loads in the county and state lookup tables.
  • Pagc_Normalize_Address - Disponibilidad: 2.1.0 Given a textual street address, returns a composite norm_addy type that has road suffix, prefix and type standardized, street, streetname etc. broken into separate fields. This function will work with just the lookup data packaged with the tiger_geocoder (no need for tiger census data). Requires address_standardizer extension.
  • ST_3DArea - Disponibilidad: 2.1.0 Computes area of 3D surface geometries. Will return 0 for solids.
  • ST_3DIntersection - Disponibilidad: 2.1.0 Perform 3D intersection
  • ST_Box2dFromGeoHash - Disponibilidad: 2.1.0 Devuelve un BOX2D de una cadena de GeoHash.
  • ST_ColorMap - Disponibilidad: 2.1.0 Creates a new raster of up to four 8BUI bands (grayscale, RGB, RGBA) from the source raster and a specified band. Band 1 is assumed if not specified.
  • ST_Contains - Disponibilidad: 2.1.0 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.
  • ST_ContainsProperly - Disponibilidad: 2.1.0 Return true if rastB intersects the interior of rastA but not the boundary or exterior of rastA.
  • ST_CoveredBy - Disponibilidad: 2.1.0 Return true if no points of raster rastA lie outside raster rastB.
  • ST_Covers - Disponibilidad: 2.1.0 Return true if no points of raster rastB lie outside raster rastA.
  • ST_DFullyWithin - Disponibilidad: 2.1.0 Return true if rasters rastA and rastB are fully within the specified distance of each other.
  • ST_DWithin - Disponibilidad: 2.1.0 Return true if rasters rastA and rastB are within the specified distance of each other.
  • ST_DelaunayTriangles - Disponibilidad: 2.1.0 Returns the Delaunay triangulation of the vertices of a geometry.
  • ST_Disjoint - Disponibilidad: 2.1.0 Return true if raster rastA does not spatially intersect rastB.
  • ST_DumpValues - Disponibilidad: 2.1.0 Get the values of the specified band as a 2-dimension array.
  • ST_Extrude - Disponibilidad: 2.1.0 Extrude a surface to a related volume
  • ST_ForceLHR - Disponibilidad: 2.1.0 Force LHR orientation
  • ST_FromGDALRaster - Disponibilidad: 2.1.0 Returns a raster from a supported GDAL raster file.
  • ST_GeomFromGeoHash - Disponibilidad: 2.1.0 Devuelve una geometría de una cadena de GeoHash.
  • ST_InvDistWeight4ma - Disponibilidad: 2.1.0 Raster processing function that interpolates a pixel's value from the pixel's neighborhood.
  • ST_MapAlgebra (callback function version) - Disponibilidad: 2.1.0 Callback function version - Returns a one-band raster given one or more input rasters, band indexes and one user-specified callback function.
  • ST_MapAlgebra (expression version) - Disponibilidad: 2.1.0 Expression version - Returns a one-band raster given one or two input rasters, band indexes and one or more user-specified SQL expressions.
  • ST_MinConvexHull - Disponibilidad: 2.1.0 Return the convex hull geometry of the raster excluding NODATA pixels.
  • ST_MinDist4ma - Disponibilidad: 2.1.0 Raster processing function that returns the minimum distance (in number of pixels) between the pixel of interest and a neighboring pixel with value.
  • ST_MinkowskiSum - Disponibilidad: 2.1.0 Performs Minkowski sum
  • ST_NearestValue - Disponibilidad: 2.1.0 Returns the nearest non-NODATA value of a given band's pixel specified by a columnx and rowy or a geometric point expressed in the same spatial reference coordinate system as the raster.
  • ST_Neighborhood - Disponibilidad: 2.1.0 Returns a 2-D double precision array of the non-NODATA values around a given band's pixel specified by either a columnX and rowY or a geometric point expressed in the same spatial reference coordinate system as the raster.
  • ST_NotSameAlignmentReason - Disponibilidad: 2.1.0 Returns text stating if rasters are aligned and if not aligned, a reason why.
  • ST_Orientation - Disponibilidad: 2.1.0 Determine surface orientation
  • ST_Overlaps - Disponibilidad: 2.1.0 Return true if raster rastA and rastB intersect but one does not completely contain the other.
  • ST_PixelAsCentroid - Disponibilidad: 2.1.0 Returns the centroid (point geometry) of the area represented by a pixel.
  • ST_PixelAsCentroids - Disponibilidad: 2.1.0 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.
  • ST_PixelAsPoint - Disponibilidad: 2.1.0 Returns a point geometry of the pixel's upper-left corner.
  • ST_PixelAsPoints - Disponibilidad: 2.1.0 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 pixel's upper-left corner.
  • ST_PixelOfValue - Disponibilidad: 2.1.0 Get the columnx, rowy coordinates of the pixel whose value equals the search value.
  • ST_PointFromGeoHash - Disponibilidad: 2.1.0 Devuelve un punto de una cadena de GeoHash.
  • ST_RasterToWorldCoord - Disponibilidad: 2.1.0 Returns the raster's upper left corner as geometric X and Y (longitude and latitude) given a column and row. Column and row starts at 1.
  • ST_Resize - Availability: 2.1.0 Requires GDAL 1.6.1+ Resize a raster to a new width/height
  • ST_Roughness - Disponibilidad: 2.1.0 Returns a raster with the calculated "roughness" of a DEM.
  • ST_SetValues - Disponibilidad: 2.1.0 Returns modified raster resulting from setting the values of a given band.
  • ST_Simplify - Disponibilidad: 2.1.0 Devuelve una versión "simplificada" de la geometría de la TopoGeometry dada usando el algoritmo de Douglas-Peucker.
  • ST_StraightSkeleton - Disponibilidad: 2.1.0 Compute a straight skeleton from a geometry
  • ST_Summary - Disponibilidad: 2.1.0 Returns a text summary of the contents of the raster.
  • ST_TPI - Disponibilidad: 2.1.0 Returns a raster with the calculated Topographic Position Index.
  • ST_TRI - Disponibilidad: 2.1.0 Returns a raster with the calculated Terrain Ruggedness Index.
  • ST_Tesselate - Disponibilidad: 2.1.0 Perform surface Tessellation of a polygon or polyhedralsurface and returns as a TIN or collection of TINS
  • ST_Tile - Disponibilidad: 2.1.0 Returns a set of rasters resulting from the split of the input raster based upon the desired dimensions of the output rasters.
  • ST_Touches - Disponibilidad: 2.1.0 Return true if raster rastA and rastB have at least one point in common but their interiors do not intersect.
  • ST_Union - Availability: 2.1.0 ST_Union(rast, unionarg) variant was introduced. Returns the union of a set of raster tiles into a single raster composed of 1 or more bands.
  • ST_Within - Disponibilidad: 2.1.0 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.
  • ST_WorldToRasterCoord - Disponibilidad: 2.1.0 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.
  • Set_Geocode_Setting - Disponibilidad: 2.1.0 Sets a setting that affects behavior of geocoder functions.
  • UpdateRasterSRID - Disponibilidad: 2.1.0 Change the SRID of all rasters in the user-specified column and table.
  • clearTopoGeom - Disponibilidad: 2.1 Borra el contenido de una topo geometry.
  • postgis.backend - Disponibilidad: 2.1.0 The backend to service a function where GEOS and SFCGAL overlap. Options: geos or sfcgal. Defaults to geos.
  • postgis_sfcgal_version - Disponibilidad: 2.1.0 Returns the version of SFCGAL in use

Functions enhanced in PostGIS 2.1

  • ST_AddBand - Enhanced: 2.1.0 support for addbandarg added. 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.
  • ST_AddBand - Enhanced: 2.1.0 support for new out-db bands added. 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.
  • ST_AsBinary/ST_AsWKB - Enhanced: 2.1.0 Addition of outasin Return the Well-Known Binary (WKB) representation of the raster.
  • ST_AsGML - Enhanced: 2.1.0 id support was introduced, for GML 3. Return the geometry as a GML version 2 or 3 element.
  • ST_Aspect - Enhanced: 2.1.0 Uses ST_MapAlgebra() and added optional interpolate_nodata function parameter Returns the aspect (in degrees by default) of an elevation raster band. Useful for analyzing terrain.
  • ST_Boundary - Mejorado: 2.1.0 Se ha introducido soporte para Triangle Devuelve el cierre del limite combinatorio de esta geometría.
  • ST_Clip - Enhanced: 2.1.0 Rewritten in C Returns the raster clipped by the input geometry. If band number is not specified, all bands are processed. If crop is not specified or TRUE, the output raster is cropped. If touched is set to TRUE, then touched pixels are included, otherwise only if the center of the pixel is in the geometry it is included.
  • ST_DWithin - Enhanced: 2.1.0 improved speed for geography. See Making Geography faster for details. Tests if two geometries are within a given distance
  • ST_DWithin - Enhanced: 2.1.0 support for curved geometries was introduced. Tests if two geometries are within a given distance
  • ST_Distance - Enhanced: 2.1.0 improved speed for geography. See Making Geography faster for details. Returns the distance between two geometry or geography values.
  • ST_Distance - Enhanced: 2.1.0 - support for curved geometries was introduced. Returns the distance between two geometry or geography values.
  • ST_Distinct4ma - Enhanced: 2.1.0 Addition of Variant 2 Raster processing function that calculates the number of unique pixel values in a neighborhood.
  • ST_DumpPoints - Enhanced: 2.1.0 Faster speed. Reimplemented as native-C. Devuelve un conjunto de geometry_dump filas para las coordenadas de una geometría.
  • ST_HillShade - Enhanced: 2.1.0 Uses ST_MapAlgebra() and added optional interpolate_nodata function parameter Returns the hypothetical illumination of an elevation raster band using provided azimuth, altitude, brightness and scale inputs.
  • ST_MakeValid - Enhanced: 2.1.0, added support for GEOMETRYCOLLECTION and MULTIPOINT. Attempts to make an invalid geometry valid without losing vertices.
  • ST_Max4ma - Enhanced: 2.1.0 Addition of Variant 2 Raster processing function that calculates the maximum pixel value in a neighborhood.
  • ST_Mean4ma - Enhanced: 2.1.0 Addition of Variant 2 Raster processing function that calculates the mean pixel value in a neighborhood.
  • ST_Min4ma - Enhanced: 2.1.0 Addition of Variant 2 Raster processing function that calculates the minimum pixel value in a neighborhood.
  • ST_PixelAsPolygons - Enhanced: 2.1.0 exclude_nodata_value optional argument was added. 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.
  • ST_Polygon - Enhanced: 2.1.0 Improved Speed (fully C-Based) and the returning multipolygon is ensured to be valid. Returns a multipolygon geometry formed by the union of pixels that have a pixel value that is not no data value. If no band number is specified, band num defaults to 1.
  • ST_Range4ma - Enhanced: 2.1.0 Addition of Variant 2 Raster processing function that calculates the range of pixel values in a neighborhood.
  • ST_SameAlignment - Enhanced: 2.1.0 addition of Aggegrate variant 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 don't with notice detailing issue.
  • ST_Segmentize - Mejorada: 2.1.0 se introdujo el soporte para geography. Returns a modified geometry/geography having no segment longer than a given distance.
  • ST_SetGeoReference - Enhanced: 2.1.0 Addition of ST_SetGeoReference(raster, double precision, ...) variant 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.
  • ST_SetValue - Enhanced: 2.1.0 Geometry variant of ST_SetValue() now supports any geometry type, not just point. The geometry variant is a wrapper around the geomval[] variant of ST_SetValues() 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.
  • ST_Slope - Enhanced: 2.1.0 Uses ST_MapAlgebra() and added optional units, scale, interpolate_nodata function parameters Returns the slope (in degrees by default) of an elevation raster band. Useful for analyzing terrain.
  • ST_StdDev4ma - Enhanced: 2.1.0 Addition of Variant 2 Raster processing function that calculates the standard deviation of pixel values in a neighborhood.
  • ST_Sum4ma - Enhanced: 2.1.0 Addition of Variant 2 Raster processing function that calculates the sum of all pixel values in a neighborhood.
  • ST_Summary - Mejorada: 2.1.0 Indicador S para señalar si tiene un sistema de referencia espacial conocido Devuelve un resumen de texto del contenido de la geometría.
  • ST_Transform - Enhanced: 2.1.0 Addition of ST_Transform(rast, alignto) variant 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.
  • ST_Union - Enhanced: 2.1.0 Improved Speed (fully C-Based). Returns the union of a set of raster tiles into a single raster composed of 1 or more bands.
  • ST_Union - Enhanced: 2.1.0 ST_Union(rast) (variant 1) unions all bands of all input rasters. Prior versions of PostGIS assumed the first band. Returns the union of a set of raster tiles into a single raster composed of 1 or more bands.
  • ST_Union - Enhanced: 2.1.0 ST_Union(rast, uniontype) (variant 4) unions all bands of all input rasters. Returns the union of a set of raster tiles into a single raster composed of 1 or more bands.
  • toTopoGeom - Mejorado: 2.1.0 agrega la versión tomando una TopoGeometry existente. Convierte un Geometry simple en una geometría topo.

Functions changed in PostGIS 2.1

  • ST_Aspect - Changed: 2.1.0 In prior versions, return values were in radians. Now, return values default to degrees Returns the aspect (in degrees by default) of an elevation raster band. Useful for analyzing terrain.
  • ST_EstimatedExtent - Changed: 2.1.0. Up to 2.0.x this was called ST_Estimated_Extent. Returns the estimated extent of a spatial table.
  • ST_Force2D - Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_2D. Forzar las geometrías en un "modo de 2 dimensiones".
  • ST_Force3D - Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_3D. Forzar las geometrías en modo XYZ. Este es un alias para ST_Force3DZ.
  • ST_Force3DM - Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_3DM. Fuerza las geometrías en modo XYM.
  • ST_Force3DZ - Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_3DZ. Fuerza las geometrías en modo XYZ.
  • ST_Force4D - Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_4D. Fuerza las geometrías en modo XYZM.
  • ST_ForceCollection - Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_Collection. Convertir la geometría en una GEOMETRYCOLLECTION.
  • ST_HillShade - Changed: 2.1.0 In prior versions, azimuth and altitude were expressed in radians. Now, azimuth and altitude are expressed in degrees Returns the hypothetical illumination of an elevation raster band using provided azimuth, altitude, brightness and scale inputs.
  • ST_LineInterpolatePoint - Cambiado: 2.1.0. Hasta 2.0. x esto se llamaba ST_Line_Interpolate_Point. Returns a point interpolated along a line at a fractional location.
  • ST_LineLocatePoint - Modificado: 2.1.0. Hasta 2.0.x esto se llamaba ST_Line_Locate_Point. Returns the fractional location of the closest point on a line to a point.
  • ST_LineSubstring - Modificado: 2.1.0. Hasta 2.0.x esto se llamaba ST_Line_Substring. Returns the part of a line between two fractional locations.
  • ST_PixelAsCentroids - Changed: 2.1.1 Changed behavior of exclude_nodata_value. 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.
  • ST_PixelAsPoints - Changed: 2.1.1 Changed behavior of exclude_nodata_value. 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 pixel's upper-left corner.
  • ST_PixelAsPolygons - Changed: 2.1.1 Changed behavior of exclude_nodata_value. 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.
  • ST_Polygon - Changed: 2.1.0 In prior versions would sometimes return a polygon, changed to always return multipolygon. Returns a multipolygon geometry formed by the union of pixels that have a pixel value that is not no data value. If no band number is specified, band num defaults to 1.
  • ST_RasterToWorldCoordX - Changed: 2.1.0 In prior versions, this was called ST_Raster2WorldCoordX Returns the geometric X coordinate upper left of a raster, column and row. Numbering of columns and rows starts at 1.
  • ST_RasterToWorldCoordY - Changed: 2.1.0 In prior versions, this was called ST_Raster2WorldCoordY Returns the geometric Y coordinate upper left corner of a raster, column and row. Numbering of columns and rows starts at 1.
  • ST_Rescale - Changed: 2.1.0 Works on rasters with no SRID 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, Lanczos, Max or Min resampling algorithm. Default is NearestNeighbor.
  • ST_Reskew - Changed: 2.1.0 Works on rasters with no SRID 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.
  • ST_Segmentize - Changed: 2.1.0 As a result of the introduction of geography support, the usage ST_Segmentize('LINESTRING(1 2, 3 4)', 0.5) causes an ambiguous function error. The input needs to be properly typed as a geometry or geography. Use ST_GeomFromText, ST_GeogFromText or a cast to the required type (e.g. ST_Segmentize('LINESTRING(1 2, 3 4)'::geometry, 0.5) ) Returns a modified geometry/geography having no segment longer than a given distance.
  • ST_Slope - Changed: 2.1.0 In prior versions, return values were in radians. Now, return values default to degrees Returns the slope (in degrees by default) of an elevation raster band. Useful for analyzing terrain.
  • ST_SnapToGrid - Changed: 2.1.0 Works on rasters with no SRID 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.
  • ST_WorldToRasterCoordX - Changed: 2.1.0 In prior versions, this was called ST_World2RasterCoordX 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.
  • ST_WorldToRasterCoordY - Changed: 2.1.0 In prior versions, this was called ST_World2RasterCoordY 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.

13.12.13. PostGIS Functions new or enhanced in 2.0

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 2.0

  • && - Disponibilidad: 2.0.0 Returns TRUE if A's bounding box intersects B's bounding box.
  • &&& - Disponibilidad: 2.0.0 Returns TRUE if A's n-D bounding box intersects B's n-D bounding box.
  • <#> - Availability: 2.0.0 -- KNN only available for PostgreSQL 9.1+ Returns the 2D distance between A and B bounding boxes.
  • <-> - Availability: 2.0.0 -- Weak KNN provides nearest neighbors based on geometry centroid distances instead of true distances. Exact results for points, inexact for all other types. Available for PostgreSQL 9.1+ Returns the 2D distance between A and B.
  • @ - Availability: 2.0.0 raster @ raster, raster @ geometry introduced Returns TRUE if A's bounding box is contained by B's. Uses double precision bounding box.
  • @ - Availability: 2.0.5 geometry @ raster introduced Returns TRUE if A's bounding box is contained by B's. Uses double precision bounding box.
  • AddEdge - Disponibilidad: 2.0.0 Agrega una arista de LineString a la tabla de arista y los puntos de inicio y fin asociados a la tabla nodos de puntos del esquema de topología usando la geometría LineString especificada y devuelve el identificador de arista de la arista nueva (o existente).
  • AddFace - Disponibilidad: 2.0.0 Registra una primitiva de cara a una topología y obtiene su identificador.
  • AddNode - Disponibilidad: 2.0.0 Agrega un nodo de punto a la tabla de nodos del esquema de topología especificado y devuelve el identificador de nodo del nuevo nodo. Si el punto ya existe como nodo, se devuelve el identificador de nodo existente.
  • AddOverviewConstraints - Disponibilidad: 2.0.0 Tag a raster column as being an overview of another.
  • AddRasterConstraints - Disponibilidad: 2.0.0 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.
  • AsGML - Disponibilidad: 2.0.0 Devuelve una representación GML de una geometría topográfica.
  • CopyTopology - Disponibilidad: 2.0.0 Makes a copy of a topology (nodes, edges, faces, layers and TopoGeometries) into a new schema
  • DropOverviewConstraints - Disponibilidad: 2.0.0 Untag a raster column from being an overview of another.
  • DropRasterConstraints - Disponibilidad: 2.0.0 Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.
  • Drop_Indexes_Generate_Script - Disponibilidad: 2.0.0 Generates a script that drops all non-primary key and non-unique indexes on tiger schema and user specified schema. Defaults schema to tiger_data if no schema is specified.
  • Drop_State_Tables_Generate_Script - Disponibilidad: 2.0.0 Generates a script that drops all tables in the specified schema that are prefixed with the state abbreviation. Defaults schema to tiger_data if no schema is specified.
  • Geocode_Intersection - Disponibilidad: 2.0.0 Takes in 2 streets that intersect and a state, city, zip, and outputs a set of possible locations on the first cross street that is at the intersection, also includes a geomout as the point location in NAD 83 long lat, a normalized_address (addy) for each location, and the rating. The lower the rating the more likely the match. Results are sorted by lowest rating first. Can optionally pass in maximum results, defaults to 10. Uses Tiger data (edges, faces, addr), PostgreSQL fuzzy string matching (soundex, levenshtein).
  • GetEdgeByPoint - Disponibilidad: 2.0.0 Busca el identificador de arista de una arista que cruza un punto determinado.
  • GetFaceByPoint - Disponibilidad: 2.0.0 Finds face intersecting a given point.
  • GetNodeByPoint - Disponibilidad: 2.0.0 Busca el identificador de nodo de un nodo en un punto de ubicación.
  • GetNodeEdges - Disponibilidad: 2.0 Devuelve un conjunto ordenado de aristas incidente al nodo dado.
  • GetRingEdges - Disponibilidad: 2.0.0 Devuelve el conjunto ordenado de identificadores de borde con signo asignado al caminar en un lado de borde dado.
  • GetTopoGeomElements - Disponibilidad: 2.0.0 Devuelve un conjunto de objetos topoelement que contienen el element_id topológico, element_type de la TopoGeometry (elementos primitivos) especificados.
  • GetTopologySRID - Disponibilidad: 2.0.0 Devuelve el SRID de una topología en la tabla topology.topology dado el nombre de la topología.
  • Get_Tract - Disponibilidad: 2.0.0 Returns census tract or field from tract table of where the geometry is located. Default to returning short name of tract.
  • Install_Missing_Indexes - Disponibilidad: 2.0.0 Finds all tables with key columns used in geocoder joins and filter conditions that are missing used indexes on those columns and will add them.
  • Loader_Generate_Census_Script - Disponibilidad: 2.0.0 Generates a shell script for the specified platform for the specified states that will download Tiger census state tract, bg, and tabblocks data tables, stage and load into tiger_data schema. Each state script is returned as a separate record.
  • Loader_Generate_Script - Availability: 2.0.0 to support Tiger 2010 structured data and load census tract (tract), block groups (bg), and blocks (tabblocks) tables . Generates a shell script for the specified platform for the specified states that will download Tiger data, stage and load into tiger_data schema. Each state script is returned as a separate record. Latest version supports Tiger 2010 structural changes and also loads census tract, block groups, and blocks tables.
  • Missing_Indexes_Generate_Script - Disponibilidad: 2.0.0 Finds all tables with key columns used in geocoder joins that are missing indexes on those columns and will output the SQL DDL to define the index for those tables.
  • Polygonize - Disponibilidad: 2.0.0 Busca y registra todas las caras definidas por aristas de topología.
  • Reverse_Geocode - Disponibilidad: 2.0.0 Takes a geometry point in a known spatial ref sys and returns a record containing an array of theoretically possible addresses and an array of cross streets. If include_strnum_range = true, includes the street range in the cross streets.
  • ST_3DClosestPoint - Disponibilidad: 2.0.0 Returns the 3D point on g1 that is closest to g2. This is the first point of the 3D shortest line.
  • ST_3DDFullyWithin - Disponibilidad: 2.0.0 Tests if two 3D geometries are entirely within a given 3D distance
  • ST_3DDWithin - Disponibilidad: 2.0.0 Tests if two 3D geometries are within a given 3D distance
  • ST_3DDistance - Disponibilidad: 2.0.0 Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DIntersects - Disponibilidad: 2.0.0 Tests if two geometries spatially intersect in 3D - only for points, linestrings, polygons, polyhedral surface (area)
  • ST_3DLongestLine - Disponibilidad: 2.0.0 Returns the 3D longest line between two geometries
  • ST_3DMaxDistance - Disponibilidad: 2.0.0 Returns the 3D cartesian maximum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DShortestLine - Disponibilidad: 2.0.0 Returns the 3D shortest line between two geometries
  • ST_AddEdgeModFace - Disponibilidad: 2.0 Añada un nuevo borde y, si al hacerlo, divide una cara, modifica la cara original y añade una nueva cara.
  • ST_AddEdgeNewFaces - Disponibilidad: 2.0 Agrega un nuevo borde y, si al hacerlo divide una cara, se elimina la cara original y es reemplazada con dos nuevas caras.
  • ST_AsGDALRaster - Availability: 2.0.0 - requires GDAL >= 1.6.0. 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.
  • ST_AsJPEG - Availability: 2.0.0 - requires GDAL >= 1.6.0. 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.
  • ST_AsLatLonText - Disponibilidad: 2.0 Return the Degrees, Minutes, Seconds representation of the given point.
  • ST_AsPNG - Availability: 2.0.0 - requires GDAL >= 1.6.0. 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.
  • ST_AsRaster - Availability: 2.0.0 - requires GDAL >= 1.6.0. Converts a PostGIS geometry to a PostGIS raster.
  • ST_AsTIFF - Availability: 2.0.0 - requires GDAL >= 1.6.0. 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.
  • ST_AsX3D - Availability: 2.0.0: ISO-IEC-19776-1.2-X3DEncodings-XML Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML
  • ST_Aspect - Disponibilidad: 2.0.0 Returns the aspect (in degrees by default) of an elevation raster band. Useful for analyzing terrain.
  • ST_Band - Disponibilidad: 2.0.0 Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters.
  • ST_BandIsNoData - Disponibilidad: 2.0.0 Returns true if the band is filled with only nodata values.
  • ST_Clip - Disponibilidad: 2.0.0 Returns the raster clipped by the input geometry. If band number is not specified, all bands are processed. If crop is not specified or TRUE, the output raster is cropped. If touched is set to TRUE, then touched pixels are included, otherwise only if the center of the pixel is in the geometry it is included.
  • ST_CollectionHomogenize - Disponibilidad: 2.0.0 Returns the simplest representation of a geometry collection.
  • ST_ConcaveHull - Disponibilidad: 2.0.0 Computes a possibly concave geometry that contains all input geometry vertices
  • ST_Count - Disponibilidad: 2.0.0 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.
  • ST_CreateTopoGeo - Disponibilidad: 2.0 Agrega una colección de geometrías a una topología vacía dada y devuelve un mensaje que detalla el éxito.
  • ST_Distinct4ma - Disponibilidad: 2.0.0 Raster processing function that calculates the number of unique pixel values in a neighborhood.
  • ST_FlipCoordinates - Disponibilidad: 2.0.0 Returns a version of a geometry with X and Y axis flipped.
  • ST_GDALDrivers - Availability: 2.0.0 - requires GDAL >= 1.6.0. Returns a list of raster formats supported by PostGIS through GDAL. Only those formats with can_write=True can be used by ST_AsGDALRaster
  • ST_GeomFromGeoJSON - Disponibilidad: 2.0.0 necesita de - JSON-C >= 0.9 Toma como entrada una representación geojson de una geometría y devuelve un objeto geométrico PostGIS
  • ST_GetFaceEdges - Disponibilidad: 2.0 Devuelve un conjunto de bordes ordenados que ligan aface.
  • ST_HasNoBand - Disponibilidad: 2.0.0 Returns true if there is no band with given band number. If no band number is specified, then band number 1 is assumed.
  • ST_HillShade - Disponibilidad: 2.0.0 Returns the hypothetical illumination of an elevation raster band using provided azimuth, altitude, brightness and scale inputs.
  • ST_Histogram - Disponibilidad: 2.0.0 Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified.
  • ST_InterpolatePoint - Disponibilidad: 2.0.0 Devuelve el valor de la dimensión medida de una geometría en el punto cerrado al punto proporcionado.
  • ST_IsEmpty - Disponibilidad: 2.0.0 Returns true if the raster is empty (width = 0 and height = 0). Otherwise, returns false.
  • ST_IsValidDetail - Disponibilidad: 2.0.0 Returns a valid_detail row stating if a geometry is valid or if not a reason and a location.
  • ST_IsValidReason - Availability: 2.0 version taking flags. Returns text stating if a geometry is valid, or a reason for invalidity.
  • ST_MakeLine - Disponibilidad: 2.0.0 - Se introdujo el soporte de una cadena lineal como elemento de entrada Crea una cadena de línea desde geometrías de punto, multipunto o de línea.
  • ST_MakeValid - Disponibilidad: 2.0.0 Attempts to make an invalid geometry valid without losing vertices.
  • ST_MapAlgebraExpr - Disponibilidad: 2.0.0 1 raster band version: Creates a new one band raster formed by applying a valid PostgreSQL algebraic operation on the input raster band and of pixeltype provided. Band 1 is assumed if no band is specified.
  • ST_MapAlgebraExpr - Disponibilidad: 2.0.0 2 raster band version: Creates a new one band raster formed by applying a valid PostgreSQL algebraic operation on the two input raster bands and of pixeltype provided. band 1 of each raster is assumed if no band numbers are specified. The resulting raster will be aligned (scale, skew and pixel corners) on the grid defined by the first raster and have its extent defined by the "extenttype" parameter. Values for "extenttype" can be: INTERSECTION, UNION, FIRST, SECOND.
  • ST_MapAlgebraFct - Disponibilidad: 2.0.0 1 band version - Creates a new one band raster formed by applying a valid PostgreSQL function on the input raster band and of pixeltype prodived. Band 1 is assumed if no band is specified.
  • ST_MapAlgebraFct - Disponibilidad: 2.0.0 2 band version - Creates a new one band raster formed by applying a valid PostgreSQL function on the 2 input raster bands and of pixeltype prodived. Band 1 is assumed if no band is specified. Extent type defaults to INTERSECTION if not specified.
  • ST_MapAlgebraFctNgb - Disponibilidad: 2.0.0 1-band version: Map Algebra Nearest Neighbor using user-defined PostgreSQL function. Return a raster which values are the result of a PLPGSQL user function involving a neighborhood of values from the input raster band.
  • ST_Max4ma - Disponibilidad: 2.0.0 Raster processing function that calculates the maximum pixel value in a neighborhood.
  • ST_Mean4ma - Disponibilidad: 2.0.0 Raster processing function that calculates the mean pixel value in a neighborhood.
  • ST_Min4ma - Disponibilidad: 2.0.0 Raster processing function that calculates the minimum pixel value in a neighborhood.
  • ST_ModEdgeHeal - Disponibilidad: 2.0 Cura dos aristas eliminando el nodo que las conecta, modificando la primera arista y eliminando la segunda arista. Devuelve el identificador del nodo eliminado.
  • ST_MoveIsoNode - Disponibilidad: 2.0.0 Mueve un nodo aislado en una topología de un punto a otro. Si la nueva geometría apoint existe como nodo se lanza un error. Devuelve la descripción del movimiento.
  • ST_NewEdgeHeal - Disponibilidad: 2.0 Cura dos aristas eliminando el nodo que las conecta, eliminando ambas aristas y sustituyéndolas por una arista cuya dirección sea la misma que la primera arista proporcionada.
  • ST_Node - Disponibilidad: 2.0.0 Nodes a collection of lines.
  • ST_NumPatches - Disponibilidad: 2.0.0 Devuelve el número de caras en una superficie poliédrica. Devolverá nulo para geometrías no poliédricas.
  • ST_OffsetCurve - Disponibilidad: 2.0 Returns an offset line at a given distance and side from an input line.
  • ST_PatchN - Disponibilidad: 2.0.0 Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_Perimeter - Availability 2.0.0: Support for geography was introduced Returns the length of the boundary of a polygonal geometry or geography.
  • ST_PixelAsPolygon - Disponibilidad: 2.0.0 Returns the polygon geometry that bounds the pixel for a particular row and column.
  • ST_PixelAsPolygons - Disponibilidad: 2.0.0 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.
  • ST_Project - Disponibilidad: 2.0.0 Returns a point projected from a start point by a distance and bearing (azimuth).
  • ST_Quantile - Disponibilidad: 2.0.0 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 raster's 25%, 50%, 75% percentile.
  • ST_Range4ma - Disponibilidad: 2.0.0 Raster processing function that calculates the range of pixel values in a neighborhood.
  • ST_Reclass - Disponibilidad: 2.0.0 Creates a new raster composed of band types reclassified from original. The nband is the band to be changed. If nband is not specified assumed to be 1. All other bands are returned unchanged. Use case: convert a 16BUI band to a 8BUI and so forth for simpler rendering as viewable formats.
  • ST_RelateMatch - Disponibilidad: 2.0.0 Tests if a DE-9IM Intersection Matrix matches an Intersection Matrix pattern
  • ST_RemEdgeModFace - Disponibilidad: 2.0 Removes an edge, and if the edge separates two faces deletes one face and modifies the other face to cover the space of both.
  • ST_RemEdgeNewFace - Disponibilidad: 2.0 Elimina un borde y, si el borde eliminado separa dos caras, borra las caras originales y las reemplaza con una nueva cara.
  • ST_Resample - Availability: 2.0.0 Requires GDAL 1.6.1+ 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.
  • ST_Rescale - Availability: 2.0.0 Requires GDAL 1.6.1+ 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, Lanczos, Max or Min resampling algorithm. Default is NearestNeighbor.
  • ST_Reskew - Availability: 2.0.0 Requires GDAL 1.6.1+ 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.
  • ST_SameAlignment - Disponibilidad: 2.0.0 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 don't with notice detailing issue.
  • ST_SetBandIsNoData - Disponibilidad: 2.0.0 Sets the isnodata flag of the band to TRUE.
  • ST_SharedPaths - Disponibilidad: 2.0.0 Returns a collection containing paths shared by the two input linestrings/multilinestrings.
  • ST_Slope - Disponibilidad: 2.0.0 Returns the slope (in degrees by default) of an elevation raster band. Useful for analyzing terrain.
  • ST_Snap - Disponibilidad: 2.0.0 Ajusta segmentos y vértices de la geometría de entrada a vértices de una geometría de referencia.
  • ST_SnapToGrid - Availability: 2.0.0 Requires GDAL 1.6.1+ 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.
  • ST_Split - Availability: 2.0.0 requires GEOS Returns a collection of geometries created by splitting a geometry by another geometry.
  • ST_StdDev4ma - Disponibilidad: 2.0.0 Raster processing function that calculates the standard deviation of pixel values in a neighborhood.
  • ST_Sum4ma - Disponibilidad: 2.0.0 Raster processing function that calculates the sum of all pixel values in a neighborhood.
  • ST_SummaryStats - Disponibilidad: 2.0.0 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.
  • ST_Transform - Availability: 2.0.0 Requires GDAL 1.6.1+ 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.
  • ST_UnaryUnion - Disponibilidad: 2.0.0 Computes the union of the components of a single geometry.
  • ST_Union - Disponibilidad: 2.0.0 Returns the union of a set of raster tiles into a single raster composed of 1 or more bands.
  • ST_ValueCount - Disponibilidad: 2.0.0 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.
  • TopoElementArray_Agg - Disponibilidad: 2.0.0 Devuelve un topoelementarray para un conjunto de element_id, matriz de tipo (topoelements).
  • TopoGeo_AddLineString - Disponibilidad: 2.0.0 Adds a linestring to an existing topology using a tolerance and possibly splitting existing edges/faces.
  • TopoGeo_AddPoint - Disponibilidad: 2.0.0 Agrega un punto a una topología existente utilizando una tolerancia y posiblemente dividiendo un borde existente.
  • TopoGeo_AddPolygon - Disponibilidad: 2.0.0 Agrega un polígono a una topología existente utilizando una tolerancia y posiblemente dividiendo las aristas/caras existentes. Devuelve identificadores de cara.
  • TopologySummary - Disponibilidad: 2.0.0 Toma un nombre de topología y proporciona totales de resumen de tipos de objetos en la topología.
  • Topology_Load_Tiger - Disponibilidad: 2.0.0 Loads a defined region of tiger data into a PostGIS Topology and transforming the tiger data to spatial reference of the topology and snapping to the precision tolerance of the topology.
  • toTopoGeom - Disponibilidad: 2.0 Convierte un Geometry simple en una geometría topo.
  • ~ - Disponibilidad: 2.0.0 Returns TRUE if A's bounding box is contains B's. Uses double precision bounding box.
  • ~= - Disponibilidad: 2.0.0 Returns TRUE if A's bounding box is the same as B's.

Functions enhanced in PostGIS 2.0

  • && - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.
  • AddGeometryColumn - Mejorada: 2.0.0 introducción del argumento use_typmod. El valor predeterminado es crearcolumnas de geometrías basadas en typmod en lugar de las basadas en restricciones. Suprime una columna de geometrías de una tabla espacial.
  • Box2D - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Returns a BOX2D representing the 2D extent of a geometry.
  • Box3D - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Returns a BOX3D representing the 3D extent of a geometry.
  • CreateTopology - Enhanced: 2.0 added the signature accepting hasZ Creates a new topology schema and registers it in the topology.topology table.
  • Geocode - Enhanced: 2.0.0 to support Tiger 2010 structured data and revised some logic to improve speed, accuracy of geocoding, and to offset point from centerline to side of street address is located on. The new parameter max_results useful for specifying number of best results or just returning the best result. Takes in an address as a string (or other normalized address) and outputs a set of possible locations which include a point geometry in NAD 83 long lat, a normalized address for each, and the rating. The lower the rating the more likely the match. Results are sorted by lowest rating first. Can optionally pass in maximum results, defaults to 10, and restrict_region (defaults to NULL)
  • GeometryType - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Devuelve el tipo de geometría del valor de ST_Geometry.
  • Populate_Geometry_Columns - Mejorado: 2.0.0 el argumento opcional use_typmod fue introducido y permite controlar si las columnas se crean con modificadores de tipo o con restricciones de tipo check. Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints.
  • ST_3DExtent - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Aggregate function that returns the 3D bounding box of geometries.
  • ST_Affine - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Apply a 3D affine transformation to a geometry.
  • ST_Area - Enhanced: 2.0.0 - support for 2D polyhedral surfaces was introduced. Returns the area of a polygonal geometry.
  • ST_AsBinary - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsBinary - Enhanced: 2.0.0 support for higher coordinate dimensions was introduced. Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsBinary - Enhanced: 2.0.0 support for specifying endian with geography was introduced. Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsEWKB - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Return the Extended Well-Known Binary (EWKB) representation of the geometry with SRID meta data.
  • ST_AsEWKT - Enhanced: 2.0.0 support for Geography, Polyhedral surfaces, Triangles and TIN was introduced. Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
  • ST_AsGML - Enhanced: 2.0.0 prefix support was introduced. Option 4 for GML3 was introduced to allow using LineString instead of Curve tag for lines. GML3 Support for Polyhedral surfaces and TINS was introduced. Option 32 was introduced to output the box. Return the geometry as a GML version 2 or 3 element.
  • ST_AsKML - Enhanced: 2.0.0 - Add prefix namespace, use default and named args Return the geometry as a KML element.
  • ST_Azimuth - Enhanced: 2.0.0 support for geography was introduced. Returns the north-based azimuth of a line between two points.
  • ST_Dimension - Mejora: 2.0.0 se introdujeron soporte de superficies poliédricas y TIN. No lanza una excepción si se envia una geometría vacía. Devuelve la dimensión de las coordenadas del valor de ST_Geometry.
  • ST_Dump - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Returns a set of geometry_dump rows for the components of a geometry.
  • ST_DumpPoints - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Devuelve un conjunto de geometry_dump filas para las coordenadas de una geometría.
  • ST_Expand - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Returns a bounding box expanded from another bounding box or a geometry.
  • ST_Extent - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Aggregate function that returns the bounding box of geometries.
  • ST_Force2D - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Forzar las geometrías en un "modo de 2 dimensiones".
  • ST_Force3D - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Forzar las geometrías en modo XYZ. Este es un alias para ST_Force3DZ.
  • ST_Force3DZ - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Fuerza las geometrías en modo XYZ.
  • ST_ForceCollection - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Convertir la geometría en una GEOMETRYCOLLECTION.
  • ST_ForceRHR - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Fuerza la orientación de los vértices en un polígono para seguir la regla de la mano derecha.
  • ST_GMLToSQL - Mejora: 2.0.0 se introdujeron soporte de superficies poliédricas y TIN. Devuelve un valor especifico ST_Geometry desde una representación GML. Esto es un alias de ST_GeomFromGML
  • ST_GMLToSQL - Mejorada: 2.0.0 se agregó el parámetro por defecto opcional srid. Devuelve un valor especifico ST_Geometry desde una representación GML. Esto es un alias de ST_GeomFromGML
  • ST_GeomFromEWKB - Mejora: 2.0.0 se introdujeron soporte de superficies poliédricas y TIN. Devuelve un valor especifico de ST_Geometry desde una representación " Extended Well-Known Binary" (EWKB).
  • ST_GeomFromEWKT - Mejora: 2.0.0 se introdujeron soporte de superficies poliédricas y TIN. Devuelve un valor especificado ST_Geometry desde una representación "Extended Well-Known Text" (EWKT).
  • ST_GeomFromGML - Mejora: 2.0.0 se introdujeron soporte de superficies poliédricas y TIN. Toma una representación GML como entrada de una geometría y extrae un objeto geométrico PostGIS
  • ST_GeomFromGML - Mejorada: 2.0.0 se agregó el parámetro por defecto opcional srid. Toma una representación GML como entrada de una geometría y extrae un objeto geométrico PostGIS
  • ST_GeometryN - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_GeometryType - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_IsClosed - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Devuelve TRUE si los puntos de inicio y final de una LINESTRINGson coincidentes. Para superficies poliedricas si son cerradas (volumetricas).
  • ST_MakeEnvelope - Mejorado: 2.0: Se introdujo capacidad de especificar una caja sin especificar un SRID. Crea un polígono rectangular formado a partir de los mínimos y máximos especificados. Los valores de entrada deben estar en el SRS especificado en el SRID.
  • ST_MakeValid - Enhanced: 2.0.1, speed improvements Attempts to make an invalid geometry valid without losing vertices.
  • ST_NPoints - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Devuelve el numero de puntos (vértices) en la geometría.
  • ST_NumGeometries - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Devuelve el numero de puntos en la geometría. Funciona con todas las geometrías.
  • ST_Relate - Enhanced: 2.0.0 - added support for specifying boundary node rule. Tests if two geometries have a topological relationship matching an Intersection Matrix pattern, or computes their Intersection Matrix
  • ST_Rotate - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Rotates a geometry about an origin point.
  • ST_Rotate - Enhanced: 2.0.0 additional parameters for specifying the origin of rotation were added. Rotates a geometry about an origin point.
  • ST_RotateX - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Rotates a geometry about the X axis.
  • ST_RotateY - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Rotates a geometry about the Y axis.
  • ST_RotateZ - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Rotates a geometry about the Z axis.
  • ST_Scale - Mejorado: 2.0.0 se introdujo soporte para superficies poliédricas, Triangulos y TIN. Scales a geometry by given factors.
  • ST_ShiftLongitude - Mejora: 2.0.0 se introdujeron soporte de superficies poliédricas y TIN. Shifts the longitude coordinates of a geometry between -180..180 and 0..360.
  • ST_Summary - Mejorado: 2.0.0 agregó soporte para geography Devuelve un resumen de texto del contenido de la geometría.
  • ST_Transform - Mejora: 2.0.0 se introdujo soporte de superficies poliédricas. Return a new geometry with coordinates transformed to a different spatial reference system.
  • ST_Value - Enhanced: 2.0.0 exclude_nodata_value optional argument was added. 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.
  • ValidateTopology - Mejorado: 2.0.0 detección de cruces de borde más eficiente y corrección de falsos positivos que existían en versiones anteriores. Devuelve un conjunto de objetos validatetopology_returntype que detallan problemas con la topología.

Functions changed in PostGIS 2.0

  • AddGeometryColumn - Cambiado: 2.0.0 Esta función ya no se actualiza desde geometry_columns ya que geometry_columns es una vista que se lee dede los catálogos del sistema. Por defecto tampoco crea las restricciones, sino que utiliza el modificador de tipo de PostgreSQL. Así que para la construcción de una columna de tipo POINT en wgs84 con esta función ejemplo que hoy es equivalente a: ALTER TABLE some_table ADD COLUMN geom geometry(Point,4326); Suprime una columna de geometrías de una tabla espacial.
  • AddGeometryColumn - Cambiado: 2.0.0 Si necesitas el comportamiento antiguo de restricciones, utiliza el valor predeterminado use_typmod, pero cambiala a false. Suprime una columna de geometrías de una tabla espacial.
  • AddGeometryColumn - Cambiado: 2.0.0 Las Vistas ya no pueden ser registradas manualmente en geometry_columns, no obstante las vistas se que construyan a partir de geometrías typmod de las tablas de geometrías y sean utilizadas sin funciones wrapper se registraran correctamente porque heredan el comportamiento typmod de su columna de la tabla padre. Las vistas que utilizan funciones de geometría que devuelvan geometrías necesitarán de transformación cast a geometrías typmod para esta columnas de geometrías de la vista y que se registren correctamente en geometry_columns. Consulta . Suprime una columna de geometrías de una tabla espacial.
  • Box3D - Changed: 2.0.0 In pre-2.0 versions, there used to be a box2d instead of box3d. Since box2d is a deprecated type, this was changed to box3d. Returns the box 3d representation of the enclosing box of the raster.
  • DropGeometryColumn - Cambiado: 2.0.0 Se proporciona esta función para la compatibilidad con versiones anteriores. Ahora que geometry_columns es una vista y no un catálogo del sistema, se puede eliminar una columna de geometría como cualquier otra columna de la tabla utilizando ALTER TABLE Suprime una columna de geometrías de una tabla espacial.
  • DropGeometryTable - Cambiado: 2.0.0 Se proporciona esta función para la compatibilidad con versiones anteriores. Ahora que geometry_columns es una vista y no un catálogo del sistema, se puede borrar una tabla con columnas de geometría como cualquier otra tabla utilizando DROP TABLE Borra una tabla y todas sus referencias en la tabla geómetra_columns.
  • Populate_Geometry_Columns - Cambiado: 2.0.0 Por defecto, ahora utiliza modificadores de tipo en lugar de restricciones de tipo check para limitar los tipos de geometría. Puedes seguir utilizando el comportamiento de las restricciones check con el uso de la nueva variable use_typmod y estableciéndolo a false. Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints.
  • ST_3DExtent - Changed: 2.0.0 In prior versions this used to be called ST_Extent3D Aggregate function that returns the 3D bounding box of geometries.
  • ST_3DLength - Changed: 2.0.0 In prior versions this used to be called ST_Length3D Returns the 3D length of a linear geometry.
  • ST_3DMakeBox - Changed: 2.0.0 In prior versions this used to be called ST_MakeBox3D Creates a BOX3D defined by two 3D point geometries.
  • ST_3DPerimeter - Changed: 2.0.0 In prior versions this used to be called ST_Perimeter3D Returns the 3D perimeter of a polygonal geometry.
  • ST_AsBinary - Changed: 2.0.0 Inputs to this function can not be unknown -- must be geometry. Constructs such as ST_AsBinary('POINT(1 2)') are no longer valid and you will get an n st_asbinary(unknown) is not unique error. Code like that needs to be changed to ST_AsBinary('POINT(1 2)'::geometry);. If that is not possible, then install legacy.sql. Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsGML - Changed: 2.0.0 use default named args Return the geometry as a GML version 2 or 3 element.
  • ST_AsGeoJSON - Changed: 2.0.0 support default args and named args. Return a geometry or feature in GeoJSON format.
  • ST_AsSVG - Changed: 2.0.0 to use default args and support named args Returns SVG path data for a geometry.
  • ST_EndPoint - Cambiado: 2.0.0 ya no funciona con multilinestrings de geometrías simples. En versiones anteriores de PostGIS -- una linea simple multilinestring funciona sin problemas con esta función y devuelve el punto inicial. En la version 2.0.0 simplemente devuelve NULL como con cualquier multilinestring. La antigua version era una función sin documentar, pero la gente que asumía que tenia sus datos almacenados en LINESTRING pueden experimentar este comportamiento ahora de resultado NULL en la version 2.0. Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_GDALDrivers - Changed: 2.0.6, 2.1.3 - by default no drivers are enabled, unless GUC or Environment variable gdal_enabled_drivers is set. Returns a list of raster formats supported by PostGIS through GDAL. Only those formats with can_write=True can be used by ST_AsGDALRaster
  • ST_GeomFromText - Cambiado: 2.0.0 En las versiones anteriores de PostGIS ST_GeomFromText('GEOMETRYCOLLECTION(EMPTY)') estaba permitido. Esto no esta permitido ahora en PostGIS 2.0.0 para ajustarse mejor a las normas SQL/MM. Esto debería ser escrito como ST_GeomFromText('GEOMETRYCOLLECTION EMPTY') Devuelve un valor especifico de ST_Geometry desde una representación "Extended Well-Known Binary" (EWKB).
  • ST_GeometryN - Cambiado: 2.0.0 Versiones anteriores devuelven NULL para geometrias simples. Esto ha sido cambiado para devolver la geometría en el caso de ST_GeometryN(..,1) . Devuelve el tipo de geometría del valor de ST_Geometry.
  • ST_IsEmpty - Cambiado: 2.0.0 En las versiones anteriores de PostGIS ST_GeomFromText('GEOMETRYCOLLECTION(EMPTY)') estaba permitido. Esto no esta permitido ahora en PostGIS 2.0.0 para ajustarse mejor a las normas SQL/MM. Tests if a geometry is empty.
  • ST_Length - Changed: 2.0.0 Breaking change -- in prior versions applying this to a MULTI/POLYGON of type geography would give you the perimeter of the POLYGON/MULTIPOLYGON. In 2.0.0 this was changed to return 0 to be in line with geometry behavior. Please use ST_Perimeter if you want the perimeter of a polygon Returns the 2D length of a linear geometry.
  • ST_LocateAlong - Modificado: 2.0.0 en versiones anteriores éste solía llamarse ST_Locate_Along_Measure. El nombre anterior ha quedado obsoleto y se eliminará en el futuro, pero aún está disponible. Returns the point(s) on a geometry that match a measure value.
  • ST_LocateBetween - Modificado: 2.0.0 en versiones anteriores éste solía llamarse ST_Locate_Along_Measure. El nombre anterior ha quedado obsoleto y se eliminará en el futuro, pero aún está disponible. Returns the portions of a geometry that match a measure range.
  • ST_ModEdgeSplit - Cambiado: 2.0 - En versiones anteriores, esto fue mal llamado ST_ModEdgesSplit Dividir un borde creando un nuevo nodo a lo largo de un borde existente, modificando el borde original y agregando un nuevo borde.
  • ST_NumGeometries - Cambiado: 2.0.0 En versiones anteriores esto devolvería NULL si la geometría no era de tipo collection/MULTI. 2.0.0+ devuelve 1 para geometrías simples, por ejemplo, POLYGON, LINESTRING, POINT. Devuelve el numero de puntos en la geometría. Funciona con todas las geometrías.
  • ST_NumInteriorRings - Cambiado: 2.0.0 - En versiones anteriores permitiría pasar un multipolígono, devolviendo el número de anillos interiores de primer polígono. Devuelva el número de anillos interiores de una geometría poligonal.
  • ST_PointN - Cambiado: 2.0.0 ya no funciona con una sola geometría multilinestrings. En versiones antiguas de PostGIS -- una sola línea MultiLineString trabajaría felizmente con esta función y regresaría el punto de inicio. En 2.0.0 sólo devuelve NULL como cualquier otro MultiLineString. Devuelve el número de puntos en un valor ST_LineString o ST_CircularString.
  • ST_ScaleX - Changed: 2.0.0. In WKTRaster versions this was called ST_PixelSizeX. Returns the X component of the pixel width in units of coordinate reference system.
  • ST_ScaleY - Changed: 2.0.0. In WKTRaster versions this was called ST_PixelSizeY. Returns the Y component of the pixel height in units of coordinate reference system.
  • ST_SetScale - Changed: 2.0.0 In WKTRaster versions this was called ST_SetPixelSize. This was changed in 2.0.0. Sets the X and Y size of pixels in units of coordinate reference system. Number units/pixel width/height.
  • ST_StartPoint - Cambiado: 2.0.0 ya no funciona con multilinestrings de geometrías simples. En versiones anteriores de PostGIS -- una linea simple multilinestring funciona sin problemas con esta función y devuelve el punto inicial. En la version 2.0.0 simplemente devuelve NULL como con cualquier multilinestring. La antigua version era una función sin documentar, pero la gente que asumía que tenia sus datos almacenados en LINESTRING pueden experimentar este comportamiento ahora de resultado NULL en la version 2.0. Returns the first point of a LineString.

13.12.14. PostGIS Functions new or enhanced in 1.5

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 1.5

  • && - Availability: 1.5.0 support for geography was introduced. Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.
  • PostGIS_LibXML_Version - Disponibilidad: 1.5 Returns the version number of the libxml2 library.
  • ST_AddMeasure - Disponibilidad: 1.5.0 Interpolates measures along a linear geometry.
  • ST_AsBinary - Availability: 1.5.0 geography support was introduced. Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data.
  • ST_AsGML - Availability: 1.5.0 geography support was introduced. Return the geometry as a GML version 2 or 3 element.
  • ST_AsGeoJSON - Availability: 1.5.0 geography support was introduced. Return a geometry or feature in GeoJSON format.
  • ST_AsText - Availability: 1.5 - support for geography was introduced. Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata.
  • ST_Buffer - Availability: 1.5 - ST_Buffer was enhanced to support different endcaps and join types. These are useful for example to convert road linestrings into polygon roads with flat or square edges instead of rounded edges. Thin wrapper for geography was added. Computes a geometry covering all points within a given distance from a geometry.
  • ST_ClosestPoint - Disponibilidad: 1.5.0 Returns the 2D point on g1 that is closest to g2. This is the first point of the shortest line from one geometry to the other.
  • ST_CollectionExtract - Disponibilidad: 1.5.0 Given a geometry collection, returns a multi-geometry containing only elements of a specified type.
  • ST_Covers - Availability: 1.5 - support for geography was introduced. Tests if every point of B lies in A
  • ST_DFullyWithin - Disponibilidad: 1.5.0 Tests if a geometry is entirely inside a distance of another
  • ST_DWithin - Availability: 1.5.0 support for geography was introduced Tests if two geometries are within a given distance
  • ST_Distance - Availability: 1.5.0 geography support was introduced in 1.5. Speed improvements for planar to better handle large or many vertex geometries Returns the distance between two geometry or geography values.
  • ST_DistanceSphere - Availability: 1.5 - support for other geometry types besides points was introduced. Prior versions only work with points. Returns minimum distance in meters between two lon/lat geometries using a spherical earth model.
  • ST_DistanceSpheroid - Availability: 1.5 - support for other geometry types besides points was introduced. Prior versions only work with points. Returns the minimum distance between two lon/lat geometries using a spheroidal earth model.
  • ST_DumpPoints - Disponibilidad: 1.5.0 Devuelve un conjunto de geometry_dump filas para las coordenadas de una geometría.
  • ST_Envelope - Disponibilidad: 1.5.0 comportamiento modificado para devolver doble precisión en vez de float4. Devuelve una geometría que representa la caja en doble precisión (float8) de la geometría dada.
  • ST_Expand - Availability: 1.5.0 behavior changed to output double precision instead of float4 coordinates. Returns a bounding box expanded from another bounding box or a geometry.
  • ST_GMLToSQL - Disponibilidad: 1.5, requiere libxml2 1.6+ Devuelve un valor especifico ST_Geometry desde una representación GML. Esto es un alias de ST_GeomFromGML
  • ST_GeomFromGML - Disponibilidad: 1.5, requiere libxml2 1.6+ Toma una representación GML como entrada de una geometría y extrae un objeto geométrico PostGIS
  • ST_GeomFromKML - Availability: 1.5, requires libxml2 2.6+ Toma una representación de una geometría KML de entrada y devuelve un objeto geométrico PostGIS
  • ST_HausdorffDistance - Disponibilidad: 1.5.0 Returns the Hausdorff distance between two geometries.
  • ST_Intersection - Availability: 1.5 support for geography data type was introduced. Computes a geometry representing the shared portion of geometries A and B.
  • ST_Intersects - Availability: 1.5 support for geography was introduced. Tests if two geometries intersect (they have at least one point in common)
  • ST_Length - Availability: 1.5.0 geography support was introduced in 1.5. Returns the 2D length of a linear geometry.
  • ST_LongestLine - Disponibilidad: 1.5.0 Returns the 2D longest line between two geometries.
  • ST_MakeEnvelope - Disponibilidad: 1.5 Crea un polígono rectangular formado a partir de los mínimos y máximos especificados. Los valores de entrada deben estar en el SRS especificado en el SRID.
  • ST_MaxDistance - Disponibilidad: 1.5.0 Returns the 2D largest distance between two geometries in projected units.
  • ST_ShortestLine - Disponibilidad: 1.5.0 Returns the 2D shortest line between two geometries
  • ~= - Availability: 1.5.0 changed behavior Returns TRUE if A's bounding box is the same as B's.

13.12.15. PostGIS Functions new or enhanced in 1.4

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 1.4

  • Populate_Geometry_Columns - Disponibilidad: 1.4.0 Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints.
  • ST_Collect - Disponibilidad: 1.4.0 - ST_MakeLine (geomarray) fue introducido. Las Funciones agregadas ST_MakeLine se mejoraron para manejar más puntos más rápido. Creates a GeometryCollection or Multi* geometry from a set of geometries.
  • ST_ContainsProperly - Disponibilidad: 1.4.0 Tests if every point of B lies in the interior of A
  • ST_GeoHash - Disponibilidad: 1.4.0 Return a GeoHash representation of the geometry.
  • ST_IsValidReason - Availability: 1.4 Returns text stating if a geometry is valid, or a reason for invalidity.
  • ST_LineCrossingDirection - Availability: 1.4 Returns a number indicating the crossing behavior of two LineStrings
  • ST_LocateBetweenElevations - Disponibilidad: 1.4.0 Returns the portions of a geometry that lie in an elevation (Z) range.
  • ST_MakeLine - Disponibilidad: 1.4.0 - ST_MakeLine (geomarray) fue introducido. Las Funciones agregadas ST_MakeLine se mejoraron para manejar más puntos más rápido. Crea una cadena de línea desde geometrías de punto, multipunto o de línea.
  • ST_MinimumBoundingCircle - Disponibilidad: 1.4.0 Returns the smallest circle polygon that contains a geometry.
  • ST_Union - Availability: 1.4.0 - ST_Union was enhanced. ST_Union(geomarray) was introduced and also faster aggregate collection in PostgreSQL. Computes a geometry representing the point-set union of the input geometries.

13.12.16. PostGIS Functions new or enhanced in 1.3

The functions given below are PostGIS functions that were added or enhanced.

Functions new in PostGIS 1.3

  • ST_AsGML - Disponibilidad: 1.3.2 Return the geometry as a GML version 2 or 3 element.
  • ST_AsGeoJSON - Disponibilidad: 1.3.4 Return a geometry or feature in GeoJSON format.
  • ST_CurveToLine - Availability: 1.3.0 Converts a geometry containing curves to a linear geometry.
  • ST_LineToCurve - Availability: 1.3.0 Converts a linear geometry to a curved geometry.
  • ST_SimplifyPreserveTopology - Disponibilidad: 1.3.3 Returns a simplified and valid representation of a geometry, using the Douglas-Peucker algorithm.