Chapter 13. Indice delle funzioni speciali di PostGIS
Prev     Next

Chapter 13. Indice delle funzioni speciali di PostGIS

Table of Contents

13.1. Funzioni Aggregate PostGIS

Le seguenti funzioni sono funzioni aggregate spaziali utilizzabili allo stesso modo in cui si usano le funzioni aggregate SQL quali sum e average.

  • CG_3DUnion - Perform 3D union.
  • ST_3DExtent - Funzione aggregata che restituisce il rettangolo di selezione 3D delle geometrie.
  • 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 - Funzione aggregata che restituisce il rettangolo di selezione delle geometrie.
  • ST_MakeLine - Crea una LineString da una geometria Point, MultiPoint o un set di LineString
  • ST_MemUnion - Aggregate function which unions geometries in a memory-efficent but slower way
  • ST_Polygonize - Calcola un insieme di poligoni formati dalle linee di un insieme di geometrie.
  • 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 - Returns a topoelementarray for a set of element_id, type arrays (topoelements).

13.2. Funzioni finestra PostGIS

Le funzioni riportate di seguito sono funzioni di finestra spaziali che vengono utilizzate allo stesso modo delle funzioni di finestra SQL come row_number(), lead() e lag(). Devono essere seguite da una clausola OVER().

  • 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. Funzioni PostGIS compatibili con SQL-MM

Le funzioni riportate di seguito sono funzioni di PostGIS conformi allo standard SQL/MM 3

  • 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.
  • 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 - Add a new edge and, if in doing so it splits a face, modify the original face and add a new face.
  • ST_AddEdgeNewFaces - Add a new edge and, if in doing so it splits a face, delete the original face and replace it with two new faces.
  • ST_AddIsoEdge - Adds an isolated edge defined by geometry alinestring to a topology connecting two existing isolated nodes anode and anothernode and returns the edge id of the new edge.
  • ST_AddIsoNode - Adds an isolated node to a face in a topology and returns the nodeid of the new node. If face is null, the node is still created.
  • 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 - Restituisce il confine di una geometria.
  • ST_Buffer - Computes a geometry covering all points within a given distance from a geometry.
  • ST_Centroid - Restituisce il centro geometrico di una geometria.
  • ST_ChangeEdgeGeom - Changes the shape of an edge without affecting the topology structure.
  • 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 - Restituisce la dimensione delle coordinate di una geometrie.
  • ST_CreateTopoGeo - Adds a collection of geometries to a given empty topology and returns a message detailing success.
  • 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 - Restituisce la dimensione topologica di una geometria.
  • ST_Disjoint - Tests if two geometries have no points in common
  • ST_Distance - Returns the distance between two geometry or geography values.
  • ST_EndPoint - Returns the last point of a LineString or CircularLineString.
  • ST_Envelope - Returns a geometry representing the bounding box of a geometry.
  • ST_Equals - Tests if two geometries include the same set of points
  • ST_ExteriorRing - Returns a LineString representing the exterior ring of a Polygon.
  • ST_GMLToSQL - Restituisce un valore ST_Geometry a partire da una rappresentazione GML. Questo è solo un alias per la funzione ST_GeomFromGML.
  • ST_GeomCollFromText - Crea una collezione Geometria dalla collezione WKT con il SRID indicato. Se SRID non è indicato, il valore predefinito è 0.
  • ST_GeomFromText - Restituisce un valore ST_Geometry a partire da una rappresentazione Well-Known-Text (WKT)
  • ST_GeomFromWKB - Crea un'istanza di geometria da una rappresentazione geometrica Well-Known Binary (WKB) e da un SRID opzionale.
  • ST_GeometryFromText - Restituisce un valore ST_Geometry a partire da Well-Known-Text (WKT). È un alias per ST_GeomFromText
  • ST_GeometryN - Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_GeometryType - Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_GetFaceEdges - Returns a set of ordered edges that bound aface.
  • ST_GetFaceGeometry - Returns the polygon in the given topology with the specified face id.
  • ST_InitTopoGeo - Creates a new topology schema and registers it in the topology.topology table.
  • ST_InteriorRingN - Returns the Nth interior ring (hole) of a Polygon.
  • 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 - Restituisce TRUE se il punto iniziale e quello finale di LINESTRING coincidono. Per le superfici poliedriche indica una superficie chiusa (volumetrica).
  • ST_IsEmpty - Tests if a geometry is empty.
  • ST_IsRing - Tests if a LineString is closed and simple.
  • ST_IsSimple - Tests if a geometry has no points of self-intersection or self-tangency.
  • ST_IsValid - Tests if a geometry is well-formed in 2D.
  • ST_Length - Returns the 2D length of a linear geometry.
  • ST_LineFromText - Crea una geometria dalla rappresentazione WKT con il SRID indicato. Se SRID non viene indicato, il valore predefinito è 0.
  • ST_LineFromWKB - Crea un LINESTRING da WKB con il SRID indicato
  • ST_LinestringFromWKB - Crea una geometria da WKB con il SRID indicato.
  • 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 - Restituisce un valore ST_MultiLineString specificato dalla rappresentazione WKT.
  • ST_MPointFromText - Crea una geometria da WKT con il SRID indicato. Se SRID non viene indicato, il valore predefinito è 0.
  • ST_MPolyFromText - Crea una geometria multipoligono da WKT con il SRID indicato. Se SRID non è indicato, l'impostazione predefinita è 0.
  • ST_ModEdgeHeal - Heals two edges by deleting the node connecting them, modifying the first edge and deleting the second edge. Returns the id of the deleted node.
  • ST_ModEdgeSplit - Split an edge by creating a new node along an existing edge, modifying the original edge and adding a new edge.
  • ST_MoveIsoNode - Moves an isolated node in a topology from one point to another. If new apoint geometry exists as a node an error is thrown. Returns description of move.
  • ST_NewEdgeHeal - Heals two edges by deleting the node connecting them, deleting both edges, and replacing them with an edge whose direction is the same as the first edge provided.
  • ST_NewEdgesSplit - Split an edge by creating a new node along an existing edge, deleting the original edge and replacing it with two new edges. Returns the id of the new node created that joins the new edges.
  • ST_NumCurves - Return the number of component curves in a CompoundCurve.
  • ST_NumGeometries - Restituisce TRUE se la geometria è una geometrycollection, un poligono o un punto vuoto, ecc.
  • ST_NumInteriorRings - Returns the number of interior rings (holes) of a Polygon.
  • ST_NumPatches - Return the number of faces on a Polyhedral Surface. Will return null for non-polyhedral geometries.
  • ST_NumPoints - Returns the number of points in a LineString or 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 - Restituisce il tipo di geometria per il valore 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 geometria di punti da WKT con il SRID indicato. Se SRID non è indicato, il valore predefinito è sconosciuto.
  • ST_PointFromWKB - Crea una geometria da WKB con il SRID indicato
  • ST_PointN - Returns the Nth point in the first LineString or circular LineString in a geometry.
  • ST_PointOnSurface - Calcola un punto che si trova in un poligono o su una geometria.
  • ST_Polygon - Creates a Polygon from a LineString with a specified SRID.
  • ST_PolygonFromText - Crea una geometria da WKT con il SRID indicato. Se SRID non viene indicato, il valore predefinito è 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 - Removes an edge and, if the removed edge separated two faces, delete the original faces and replace them with a new face.
  • ST_RemoveIsoEdge - Removes an isolated edge and returns description of action. If the edge is not isolated, then an exception is thrown.
  • ST_RemoveIsoNode - Removes an isolated node and returns description of action. If the node is not isolated (is start or end of an edge), then an exception is thrown.
  • 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 - Restituisce un valore ST_Geometry specificato dalla rappresentazione Well-Known Binary (WKB). Si tratta di un nome alias per ST_GeomFromWKB che non accetta srid
  • ST_WKTToSQL - Restituisce un valore ST_Geometry a partire da Well-Known-Text (WKT). È un alias per 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.
  • TG_ST_SRID - Returns the spatial reference identifier for a topogeometry.

13.4. Funzioni di supporto alla geografia PostGIS

Le funzioni e gli operatori riportati di seguito sono funzioni/operatori PostGIS che prendono in ingresso o restituiscono in uscita un oggetto di tipo geografia.

[Note]

Le funzioni con una (T) non sono funzioni geodetiche native e utilizzano una chiamata ST_Transform da e verso la geometria per eseguire l'operazione. Di conseguenza, potrebbero non comportarsi come ci si aspetta quando si supera la linea di demarcazione, i poli e per geometrie di grandi dimensioni o coppie di geometrie che coprono più di una zona UTM. Trasformazione di base - (privilegiando UTM, Lambert Azimuthal (Nord/Sud) e ripiegando su mercator nel peggiore dei casi)
  • 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 - Ritorna la rappresentazione Well-Known Text (WKT) della geometria con incluso lo SRID.
  • 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 - Restituisce il centro geometrico di una geometria.
  • 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 - Ritorna un valore geography sotto forma di Well-Know-Text (WKT) oppure di Extended-Well-Know-Text (EWKT)
  • ST_GeogFromWKB - Crea un oggetto geography a partire da una geometria in Well-Known Binary (WKB) oppure Extended Well-Known Binary (EWKB).
  • ST_GeographyFromText - Ritorna un valore geography sotto forma di Well-Know-Text (WKT) oppure di Extended-Well-Know-Text (EWKT)
  • = - 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 - Returns a text summary of the contents of a geometry.
  • <-> - Returns the 2D distance between A and B.
  • && - Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.

13.5. Funzioni di supporto per i raster di PostGIS

Le funzioni e gli operatori riportati di seguito sono funzioni/operatori PostGIS che prendono in ingresso o restituiscono in uscita un oggetto di tipo raster. Sono elencati in ordine alfabetico.

  • 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 - Restituisce un insieme di piastrelle configurate da una copertura raster piastrellata arbitrariamente.
  • 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_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 - Restituisce una o più bande di un raster esistente come un nuovo raster. Utile per costruire nuovi raster da raster esistenti.
  • 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 not is specified, all bands are processed. If crop is not specified or TRUE, the output raster is cropped.
  • 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 - Restituisce un raster da un file raster GDAL supportato.
  • ST_GeoReference - Restituisce i metadati di georeferenziazione in formato GDAL o ESRI, come si vede comunemente in un file world. L'impostazione predefinita è 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 - Restituisce l'altezza del raster in pixel.
  • 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 - Restituisce true se il raster è vuoto (larghezza = 0 e altezza = 0). Altrimenti, restituisce false.
  • ST_MakeEmptyCoverage - Copre l'area georeferenziata con una griglia di tessere raster vuote.
  • ST_MakeEmptyRaster - Restituisce un raster vuoto (senza bande) di dimensioni date (larghezza & altezza), X e Y in alto a sinistra, dimensioni dei pixel e rotazione (scalex, scaley, skewx & skewy) e sistema di riferimento (srid). Se viene passato un raster, restituisce un nuovo raster con le stesse dimensioni, allineamento e SRID. Se srid viene omesso, il sistema di riferimento spaziale viene impostato su sconosciuto (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 - Restituisce la quantità di spazio (in byte) occupato dal raster.
  • 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 - Restituisce un testo riassuntivo del contenuto del 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 - Restituisce un insieme di raster risultanti dalla suddivisione del raster di input in base alle dimensioni desiderate dei raster di output.
  • 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 - Restituisce la coordinata X superiore sinistra del raster in proiezione spaziale.
  • 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. Funzioni di dump Raster / Geometria / Geografia

Le funzioni riportate di seguito sono funzioni PostGIS che prendono in ingresso o restituiscono in uscita un insieme o un singolo oggetto di tipo geometry_dump o geomval.

  • 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 - Returns a set of geometry_dump rows for the coordinates in a geometry.
  • ST_DumpRings - Returns a set of geometry_dump rows for the exterior and interior rings of a Polygon.
  • ST_DumpSegments - Returns a set of geometry_dump rows for the segments in a geometry.

13.7. Funzioni del box PostGIS

Le funzioni riportate di seguito sono funzioni PostGIS che prendono come input o restituiscono come output la famiglia di tipi spaziali PostGIS box*. La famiglia di tipi box è composta da box2d, e 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 - Funzione aggregata che restituisce il rettangolo di selezione 3D delle geometrie.
  • 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 - Restituisce un BOX2D da una stringa 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 - Funzione aggregata che restituisce il rettangolo di selezione delle geometrie.
  • ST_MakeBox2D - Crea un BOX2D definito da due geometrie di punti 2D.
  • 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 - Returns a set of validatetopology_returntype objects detailing issues with topology.
  • ~(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. Funzioni PostGIS che supportano il 3D

Le funzioni riportate di seguito sono funzioni di PostGIS che non eliminano l'indice Z.

  • AddGeometryColumn - Aggiunge una colonna geometrica a una tabella esistente.
  • 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_3DConvexHull - Computes the 3D convex hull of a geometry.
  • CG_3DDifference - Perform 3D difference
  • CG_3DIntersection - Perform 3D intersection
  • CG_3DUnion - Perform 3D union.
  • 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 - Estrude una superficie a volume
  • CG_ForceLHR - Forza l'orientazione di tipo LHR
  • CG_IsPlanar - Verifica se una superficie è planare o meno.
  • 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 - Determina l'orientazione di una superficie.
  • CG_StraightSkeleton - Compute a straight skeleton from a geometry
  • CG_Tesselate - Perform surface Tesselation 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 - Rimuove una colonna geometry da una tabella spaziale
  • GeometryType - Restituisce il tipo di geometria come testo.
  • 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 - Funzione aggregata che restituisce il rettangolo di selezione 3D delle geometrie.
  • 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 - Aggiunge un punto a una stringa di linee.
  • 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 - Ritorna la rappresentazione Well-Known Text (WKT) della geometria con incluso lo SRID.
  • 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 - Restituisce il confine di una geometria.
  • ST_BoundingDiagonal - Restituisce la diagonale del rettangolo di confine di una geometria.
  • 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 - Restituisce la dimensione delle coordinate di una geometrie.
  • 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 - Returns a set of geometry_dump rows for the coordinates in a geometry.
  • ST_DumpRings - Returns a set of geometry_dump rows for the exterior and interior rings of a Polygon.
  • ST_DumpSegments - Returns a set of geometry_dump rows for the segments in a geometry.
  • ST_EndPoint - Returns the last point of a LineString or CircularLineString.
  • ST_ExteriorRing - Returns a LineString representing the exterior ring of a Polygon.
  • ST_Extrude - Estrude una superficie a volume
  • ST_FlipCoordinates - Returns a version of a geometry with X and Y axis flipped.
  • ST_Force2D - Force the geometries into a "2-dimensional mode".
  • ST_ForceCurve - Upcast a geometry into its curved type, if applicable.
  • ST_ForceLHR - Forza l'orientazione di tipo LHR
  • ST_ForcePolygonCCW - Orients all exterior rings counter-clockwise and all interior rings clockwise.
  • ST_ForcePolygonCW - Orients all exterior rings clockwise and all interior rings counter-clockwise.
  • ST_ForceRHR - Force the orientation of the vertices in a polygon to follow the Right-Hand-Rule.
  • ST_ForceSFS - Force the geometries to use SFS 1.1 geometry types only.
  • ST_Force_3D - Force the geometries into XYZ mode. This is an alias for ST_Force3DZ.
  • ST_Force_3DZ - Force the geometries into XYZ mode.
  • ST_Force_4D - Force the geometries into XYZM mode.
  • ST_Force_Collection - Convert the geometry into a GEOMETRYCOLLECTION.
  • ST_GeomFromEWKB - Ritorna un valore ST_Geometry a partire da Extended Well-Known Binary (EWKB).
  • ST_GeomFromEWKT - Ritorna un valore ST_Geometry a partire da una rappresentazione Extended Well-Known Text (EWKT).
  • ST_GeomFromGML - Accetta una geometria in formato GML come input e restituisce un oggetto PostGIS geometry
  • ST_GeomFromGeoJSON - Accetta come input la rappresentazione geojson di una geometria e restituisce una geometria PostGIS
  • ST_GeomFromKML - Accetta come input una geometria in formato KML e restituisce una geometria PostGIS.
  • ST_GeometricMedian - Returns the geometric median of a MultiPoint.
  • ST_GeometryN - Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_GeometryType - Restituisce il tipo di geometria per il valore 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 - Returns the Nth interior ring (hole) of a Polygon.
  • ST_InterpolatePoint - Returns the interpolated measure of a geometry closest to a point.
  • ST_Intersection - Computes a geometry representing the shared portion of geometries A and B.
  • ST_IsClosed - Restituisce TRUE se il punto iniziale e quello finale di LINESTRING coincidono. Per le superfici poliedriche indica una superficie chiusa (volumetrica).
  • ST_IsCollection - Restituisce TRUE se la geometria è una geometrycollection, un poligono o un punto vuoto, ecc.
  • ST_IsPlanar - Verifica se una superficie è planare o meno.
  • ST_IsPolygonCCW - Tests if Polygons have exterior rings oriented counter-clockwise and interior rings oriented clockwise.
  • ST_IsPolygonCW - Tests if Polygons have exterior rings oriented clockwise and interior rings oriented counter-clockwise.
  • ST_IsSimple - Tests if a geometry has no points of self-intersection or self-tangency.
  • 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_Length_Spheroid - Returns the 2D or 3D length/perimeter of a lon/lat geometry on a spheroid.
  • ST_LineFromMultiPoint - Crea una LineString da una geometria 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 LineString da una geometria Point, MultiPoint o un set di LineString
  • 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 - Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_MemUnion - Aggregate function which unions geometries in a memory-efficent but slower way
  • ST_NDims - Restituisce la dimensione delle coordinate di una geometria.
  • ST_NPoints - Returns the number of points (vertices) in a geometry.
  • ST_NRings - Returns the number of rings in a polygonal geometry.
  • ST_Node - Nodes a collection of lines.
  • ST_NumCurves - Return the number of component curves in a CompoundCurve.
  • ST_NumGeometries - Restituisce TRUE se la geometria è una geometrycollection, un poligono o un punto vuoto, ecc.
  • ST_NumPatches - Return the number of faces on a Polyhedral Surface. Will return null for non-polyhedral geometries.
  • ST_Orientation - Determina l'orientazione di una superficie.
  • ST_PatchN - Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_PointFromWKB - Crea una geometria da WKB con il SRID indicato
  • ST_PointN - Returns the Nth point in the first LineString or circular LineString in a geometry.
  • ST_PointOnSurface - Calcola un punto che si trova in un poligono o su una geometria.
  • ST_Points - Restituisce un MultiPoint contenente le coordinate di una geometria.
  • 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 - Return the geometry with vertex order reversed.
  • 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 - Replace point of a linestring with a given point.
  • ST_ShiftLongitude - Shifts the longitude coordinates of a geometry between -180..180 and 0..360.
  • ST_SnapToGrid - Snap all points of the input geometry to a regular grid.
  • 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 Tesselation 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 - Restituisce un codice indicante le dimensioni ZM di una geometria.
  • TG_Equals - Returns true if two topogeometries are composed of the same topology primitives.
  • TG_Intersects - Returns true if any pair of primitives from the two topogeometries intersect.
  • UpdateGeometrySRID - Aggiorna lo SRID e di tutte le geometrie nella colonna specificata e i metadati di tabella.
  • geometry_overlaps_nd - Returns TRUE if A's n-D bounding box intersects B's n-D bounding box.
  • overlaps_nd_geometry_gidx - Returns TRUE if a geometry's (cached) n-D bounding box intersects a n-D float precision bounding box (GIDX).
  • overlaps_nd_gidx_geometry - Returns TRUE if a n-D float precision bounding box (GIDX) intersects a geometry's (cached) n-D bounding box.
  • overlaps_nd_gidx_gidx - Returns TRUE if two n-D float precision bounding boxes (GIDX) intersect each other.

13.9. Funzioni di supporto per la geometria curva di PostGIS

Le funzioni riportate di seguito sono funzioni PostGIS che possono utilizzare CIRCULARSTRING, CURVEPOLYGON e altri tipi di geometria curva

  • AddGeometryColumn - Aggiunge una colonna geometrica a una tabella esistente.
  • Box2D - Returns a BOX2D representing the 2D extent of a geometry.
  • Box3D - Returns a BOX3D representing the 3D extent of a geometry.
  • DropGeometryColumn - Rimuove una colonna geometry da una tabella spaziale
  • GeometryType - Restituisce il tipo di geometria come testo.
  • PostGIS_AddBBox - Add bounding box to the geometry.
  • PostGIS_DropBBox - Drop the bounding box cache from the geometry.
  • PostGIS_HasBBox - Returns TRUE if the bbox of this geometry is cached, FALSE otherwise.
  • ST_3DExtent - Funzione aggregata che restituisce il rettangolo di selezione 3D delle geometrie.
  • 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 - Ritorna la rappresentazione Well-Known Text (WKT) della geometria con incluso lo SRID.
  • 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 - Restituisce la dimensione delle coordinate di una geometrie.
  • 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 - Returns a set of geometry_dump rows for the coordinates in a geometry.
  • ST_EndPoint - Returns the last point of a LineString or CircularLineString.
  • 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 - Force the geometries into a "2-dimensional mode".
  • ST_ForceCurve - Upcast a geometry into its curved type, if applicable.
  • ST_ForceSFS - Force the geometries to use SFS 1.1 geometry types only.
  • ST_Force3D - Force the geometries into XYZ mode. This is an alias for ST_Force3DZ.
  • ST_Force3DM - Force the geometries into XYM mode.
  • ST_Force3DZ - Force the geometries into XYZ mode.
  • ST_Force4D - Force the geometries into XYZM mode.
  • ST_ForceCollection - Convert the geometry into a GEOMETRYCOLLECTION.
  • ST_GeoHash - Return a GeoHash representation of the geometry.
  • ST_GeogFromWKB - Crea un oggetto geography a partire da una geometria in Well-Known Binary (WKB) oppure Extended Well-Known Binary (EWKB).
  • ST_GeomFromEWKB - Ritorna un valore ST_Geometry a partire da Extended Well-Known Binary (EWKB).
  • ST_GeomFromEWKT - Ritorna un valore ST_Geometry a partire da una rappresentazione Extended Well-Known Text (EWKT).
  • ST_GeomFromText - Restituisce un valore ST_Geometry a partire da una rappresentazione Well-Known-Text (WKT)
  • ST_GeomFromWKB - Crea un'istanza di geometria da una rappresentazione geometrica Well-Known Binary (WKB) e da un SRID opzionale.
  • ST_GeometryN - Restituisce il tipo di geometria per il valore 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 - Restituisce TRUE se il punto iniziale e quello finale di LINESTRING coincidono. Per le superfici poliedriche indica una superficie chiusa (volumetrica).
  • ST_IsCollection - Restituisce TRUE se la geometria è una geometrycollection, un poligono o un punto vuoto, ecc.
  • ST_IsEmpty - Tests if a geometry is empty.
  • ST_LineToCurve - Converts a linear geometry to a curved geometry.
  • ST_MemSize - Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_NPoints - Returns the number of points (vertices) in a geometry.
  • ST_NRings - Returns the number of rings in a polygonal geometry.
  • ST_PointFromWKB - Crea una geometria da WKB con il SRID indicato
  • ST_PointN - Returns the Nth point in the first LineString or circular LineString in a geometry.
  • ST_Points - Restituisce un MultiPoint contenente le coordinate di una geometria.
  • 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 - Returns a text summary of the contents of a geometry.
  • 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 - Restituisce un codice indicante le dimensioni ZM di una geometria.
  • UpdateGeometrySRID - Aggiorna lo SRID e di tutte le geometrie nella colonna specificata e i metadati di tabella.
  • ~(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. Funzioni di supporto per superfici poliedriche PostGIS

Le funzioni riportate di seguito sono funzioni PostGIS che possono utilizzare le geometrie POLYHEDRALSURFACE e POLYHEDRALSURFACEM

  • AddGeometryColumn - Aggiunge una colonna geometrica a una tabella esistente.
  • Box2D - Returns a BOX2D representing the 2D extent of a geometry.
  • Box3D - Returns a BOX3D representing the 3D extent of a geometry.
  • DropGeometryColumn - Rimuove una colonna geometry da una tabella spaziale
  • GeometryType - Restituisce il tipo di geometria come testo.
  • PostGIS_AddBBox - Add bounding box to the geometry.
  • PostGIS_DropBBox - Drop the bounding box cache from the geometry.
  • PostGIS_HasBBox - Returns TRUE if the bbox of this geometry is cached, FALSE otherwise.
  • ST_3DExtent - Funzione aggregata che restituisce il rettangolo di selezione 3D delle geometrie.
  • 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 - Ritorna la rappresentazione Well-Known Text (WKT) della geometria con incluso lo SRID.
  • 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 - Restituisce la dimensione delle coordinate di una geometrie.
  • 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 - Returns a set of geometry_dump rows for the coordinates in a geometry.
  • ST_EndPoint - Returns the last point of a LineString or CircularLineString.
  • 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 - Force the geometries into a "2-dimensional mode".
  • ST_ForceCurve - Upcast a geometry into its curved type, if applicable.
  • ST_ForceSFS - Force the geometries to use SFS 1.1 geometry types only.
  • ST_Force3D - Force the geometries into XYZ mode. This is an alias for ST_Force3DZ.
  • ST_Force3DM - Force the geometries into XYM mode.
  • ST_Force3DZ - Force the geometries into XYZ mode.
  • ST_Force4D - Force the geometries into XYZM mode.
  • ST_ForceCollection - Convert the geometry into a GEOMETRYCOLLECTION.
  • ST_GeoHash - Return a GeoHash representation of the geometry.
  • ST_GeogFromWKB - Crea un oggetto geography a partire da una geometria in Well-Known Binary (WKB) oppure Extended Well-Known Binary (EWKB).
  • ST_GeomFromEWKB - Ritorna un valore ST_Geometry a partire da Extended Well-Known Binary (EWKB).
  • ST_GeomFromEWKT - Ritorna un valore ST_Geometry a partire da una rappresentazione Extended Well-Known Text (EWKT).
  • ST_GeomFromText - Restituisce un valore ST_Geometry a partire da una rappresentazione Well-Known-Text (WKT)
  • ST_GeomFromWKB - Crea un'istanza di geometria da una rappresentazione geometrica Well-Known Binary (WKB) e da un SRID opzionale.
  • ST_GeometryN - Restituisce il tipo di geometria per il valore 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 - Restituisce TRUE se il punto iniziale e quello finale di LINESTRING coincidono. Per le superfici poliedriche indica una superficie chiusa (volumetrica).
  • ST_IsCollection - Restituisce TRUE se la geometria è una geometrycollection, un poligono o un punto vuoto, ecc.
  • ST_IsEmpty - Tests if a geometry is empty.
  • ST_LineToCurve - Converts a linear geometry to a curved geometry.
  • ST_MemSize - Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_NPoints - Returns the number of points (vertices) in a geometry.
  • ST_NRings - Returns the number of rings in a polygonal geometry.
  • ST_PointFromWKB - Crea una geometria da WKB con il SRID indicato
  • ST_PointN - Returns the Nth point in the first LineString or circular LineString in a geometry.
  • ST_Points - Restituisce un MultiPoint contenente le coordinate di una geometria.
  • 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 - Returns a text summary of the contents of a geometry.
  • 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 - Restituisce un codice indicante le dimensioni ZM di una geometria.
  • UpdateGeometrySRID - Aggiorna lo SRID e di tutte le geometrie nella colonna specificata e i metadati di tabella.
  • ~(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. Matrice di supporto alle funzioni PostGIS

Di seguito è riportato un elenco alfabetico di funzioni specifiche per lo spazio in PostGIS e i tipi di tipi di spazio con cui lavorano o la conformità OGC/SQL a cui cercano di conformarsi.

  • Un significa che la funzione lavora con il tipo o sottotipo in modo nativo.
  • Un significa che funziona ma con un cast di trasformazione incorporato che utilizza il cast alla geometria, la trasformazione in un ref spaziale "best srid" e quindi il cast di ritorno. I risultati potrebbero non essere quelli attesi per aree di grandi dimensioni o aree ai poli e potrebbero accumularsi rifiuti in virgola mobile.
  • Un significa che la funzione funziona con il tipo a causa di un autocast ad un altro, come box3d, piuttosto che per il supporto diretto del tipo.
  • Un significa che la funzione è disponibile solo se PostGIS è stato compilato con il supporto SFCGAL.
  • geom - Supporto alla geometria 2D di base (x,y).
  • geog - Supporto di base per la geografia 2D (x,y).
  • 2.5D - geometrie 2D di base in uno spazio 3 D/4D (con coordinate Z o M).
  • PS - Superfici poliedriche
  • T - Triangoli e superfici di rete irregolari triangolate (TIN)

Funzione geom geog 2.5D Curve 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_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          

13.12. Funzioni PostGIS nuove, migliorate o modificate

13.12.1. Funzioni PostGIS aggiunto o migliorate nella versione 3.5

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 3.5

  • 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.

Funzioni modificate 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.2. Funzioni PostGIS aggiunto o migliorate nella versione 3.4

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove 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.
  • 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 - Disponibilità: 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.
  • 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 useage that fully contain the bounds parameter.

Funzioni migliorate 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_ShortestLine - Enhanced: 3.4.0 - support for geography. Returns the 2D shortest line between two geometries

Funzioni modificate 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.3. Funzioni PostGIS aggiunto o migliorate nella versione 3.3

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 3.3

  • ST_AsMARC21 - Availability: 3.3.0 Returns geometry as a MARC21/XML record with a geographic datafield (034).
  • ST_GeomFromMARC21 - Disponibilità: 3.3.0, richiede libxml2 2.6+ Prende in input i dati geografici MARC21/XML e restituisce un oggetto geometrico PostGIS.
  • 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_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

Funzioni migliorate 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.

Funzioni modificate 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.4. Funzioni PostGIS aggiunto o migliorate nella versione 3.2

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 3.2

  • ST_AsFlatGeobuf - Disponibilità: 3.2.0 Return a FlatGeobuf representation of a set of rows.
  • ST_DumpSegments - Disponibilità: 3.2.0 Returns a set of geometry_dump rows for the segments in a geometry.
  • ST_FromFlatGeobuf - Disponibilità: 3.2.0 Legge i dati di FlatGeobuf.
  • ST_FromFlatGeobufToTable - Disponibilità: 3.2.0 Crea una tabella basata sulla struttura dei dati di FlatGeobuf.
  • ST_Scroll - Disponibilità: 3.2.0 Change start point of a closed LineString.
  • postgis.gdal_vsi_options - Disponibilità: 3.2.0 A string configuration to set options used when working with an out-db raster.

Funzioni migliorate in PostGIS 3.2

  • 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_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.

Funzioni modificate in PostGIS 3.2

  • ST_Boundary - Modificato: dalla versione 3.2.0 supporta TIN, non usa geos, non linearizza le curve Restituisce il confine di una geometria.

13.12.5. Funzioni PostGIS aggiunto o migliorate nella versione 3.1

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 3.1

  • ST_Hexagon - Disponibilità: dalla versione 1.5. Returns a single hexagon, using the provided edge size and cell coordinate within the hexagon grid space.
  • ST_HexagonGrid - Disponibilità: dalla versione 1.5. 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. Restituisce una geometria valida con punti arrotondati alla tolleranza della griglia.
  • ST_Square - Disponibilità: dalla versione 1.5. Returns a single square, using the provided edge size and cell coordinate within the square grid space.
  • ST_SquareGrid - Disponibilità: dalla versione 1.5. Returns a set of grid squares and cell indices that completely cover the bounds of the geometry argument.

Funzioni migliorate in PostGIS 3.1

  • ST_AsEWKT - Enhanced: 3.1.0 support for optional precision parameter. Ritorna la rappresentazione Well-Known Text (WKT) della geometria con incluso lo SRID.
  • 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 - Miglioramento nella versione: 2.0.0 introdotto opzionale parametro 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.

Funzioni modificate in PostGIS 3.1

  • ST_Force3D - Changed: 3.1.0. Added support for supplying a non-zero Z value. Force the geometries into XYZ mode. This is an alias for ST_Force3DZ.
  • ST_Force3DM - Changed: 3.1.0. Added support for supplying a non-zero M value. Force the geometries into XYM mode.
  • ST_Force3DZ - Changed: 3.1.0. Added support for supplying a non-zero Z value. Force the geometries into XYZ mode.
  • ST_Force4D - Changed: 3.1.0. Added support for supplying non-zero Z and M values. Force the geometries into XYZM mode.

13.12.6. Funzioni PostGIS aggiunto o migliorate nella versione 3.0

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 3.0

  • ST_3DLineInterpolatePoint - Disponibilità: dalla versione 1.5. Returns a point interpolated along a 3D line at a fractional location.
  • ST_TileEnvelope - Disponibilità: dalla versione 1.5. Creates a rectangular Polygon in Web Mercator (SRID:3857) using the XYZ tile system.

Funzioni migliorate 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 - Migliorato: 3.0.0 la geometria analizzata viene impostata come predefinita su SRID=4326 se non specificato altrimenti. Accetta come input la rappresentazione geojson di una geometria e restituisce una geometria 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

Funzioni modificate 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.7. Funzioni PostGIS aggiunto o migliorate nella versione 2.5

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove 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_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_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

Funzioni migliorate in PostGIS 2.5

  • 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_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 - Miglioramento: 2.5.0 può ora accettare json e jsonb come input. Accetta come input la rappresentazione geojson di una geometria e restituisce una geometria 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 - Migliorato: 2.5 - aggiunto il supporto per GEOMETRYCOLLECTION e 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.

13.12.8. Funzioni PostGIS aggiunto o migliorate nella versione 2.4

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 2.4

  • ST_AsGeobuf - Disponibilità: 2.4.0 Return a Geobuf representation of a set of rows.
  • ST_AsMVT - Disponibilità: 2.4.0 Aggregate function returning a MVT representation of a set of rows.
  • ST_AsMVTGeom - Disponibilità: 2.4.0 Transforms a geometry into the coordinate space of a MVT tile.
  • ST_Centroid - Availability: 2.4.0 support for geography was introduced. Restituisce il centro geometrico di una geometria.
  • ST_ForcePolygonCCW - Disponibilità: 2.4.0 Orients all exterior rings counter-clockwise and all interior rings clockwise.
  • ST_ForcePolygonCW - Disponibilità: 2.4.0 Orients all exterior rings clockwise and all interior rings counter-clockwise.
  • ST_FrechetDistance - Disponibilità: 2.0 Returns the Fréchet distance between two geometries.
  • ST_IsPolygonCCW - Disponibilità: 2.4.0 Tests if Polygons have exterior rings oriented counter-clockwise and interior rings oriented clockwise.
  • ST_IsPolygonCW - Disponibilità: 2.4.0 Tests if Polygons have exterior rings oriented clockwise and interior rings oriented counter-clockwise.

Funzioni migliorate in PostGIS 2.4

  • 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 - Enhanced: 2.4.0 support for curves was introduced. Return the geometry with vertex order reversed.

Funzioni modificate 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.9. Funzioni PostGIS aggiunto o migliorate nella versione 2.3

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove 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).
  • ST_ClusterDBSCAN - Availability: 2.3.0 Window function that returns a cluster id for each input geometry using the DBSCAN algorithm.
  • ST_ClusterKMeans - Availability: 2.3.0 Window function that returns a cluster id for each input geometry using the K-means algorithm.
  • ST_GeneratePoints - Availability: 2.3.0 Generates a multipoint of random points contained in a Polygon or MultiPolygon.
  • ST_GeometricMedian - Availability: 2.3.0 Returns the geometric median of a MultiPoint.
  • ST_MakeLine - Availability: 2.3.0 - Support for MultiPoint input elements was introduced Crea una LineString da una geometria Point, MultiPoint o un set di LineString
  • ST_MinimumBoundingRadius - Disponibilità: 2.3.0 Restituisce il punto centrale e il raggio del cerchio più piccolo che contiene una geometria.
  • ST_MinimumClearance - Availability: 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 - Availability: 2.3.0 Return the geometry in its canonical form.
  • ST_Points - Availability: 2.3.0 Restituisce un MultiPoint contenente le coordinate di una geometria.
  • ST_VoronoiLines - Availability: 2.3.0 Returns the boundaries of the Voronoi diagram of the vertices of a geometry.
  • ST_VoronoiPolygons - Availability: 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.
  • ~(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).

Funzioni migliorate 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

Funzioni modificate in PostGIS 2.3

  • ST_PointN - Changed: 2.3.0 : negative indexing available (-1 is last point) Returns the Nth point in the first LineString or circular LineString in a geometry.

13.12.10. Funzioni PostGIS aggiunto o migliorate nella versione 2.2

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove 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_AsEncodedPolyline - Disponibilità: 2.2.0 Returns an Encoded Polyline from a LineString geometry.
  • ST_AsTWKB - Disponibilità: 2.2.0 Returns the geometry as TWKB, aka "Tiny Well-Known Binary"
  • ST_BoundingDiagonal - Disponibilità: 2.2.0 Restituisce la diagonale del rettangolo di confine di una geometria.
  • ST_CPAWithin - Disponibilità: 2.2.0 Tests if the closest point of approach of two trajectories is within the specified distance.
  • ST_ClipByBox2D - Disponibilità: 2.2.0 Computes the portion of a geometry falling within a rectangle.
  • ST_ClosestPointOfApproach - Disponibilità: 2.2.0 Returns a measure at the closest point of approach of two trajectories.
  • ST_ClusterIntersecting - Disponibilità: 2.2.0 Aggregate function that clusters input geometries into connected sets.
  • ST_ClusterWithin - Disponibilità: 2.2.0 Aggregate function that clusters geometries by separation distance.
  • ST_DistanceCPA - Disponibilità: 2.2.0 Returns the distance between the closest point of approach of two trajectories.
  • ST_ForceCurve - Disponibilità: 2.2.0 Upcast a geometry into its curved type, if applicable.
  • ST_IsValidTrajectory - Disponibilità: 2.2.0 Tests if the geometry is a valid trajectory.
  • ST_LineFromEncodedPolyline - Disponibilità: 2.2.0 Crea una stringa di linee da una polilinea codificata.
  • ST_RemoveRepeatedPoints - Disponibilità: 2.2.0 Returns a version of a geometry with duplicate points removed.
  • ST_SetEffectiveArea - Disponibilità: 2.2.0 Sets the effective area for each vertex, using the Visvalingam-Whyatt algorithm.
  • ST_SimplifyVW - Disponibilità: 2.2.0 Returns a simplified representation of a geometry, using the Visvalingam-Whyatt algorithm
  • ST_Subdivide - Disponibilità: 2.2.0 Computes a rectilinear subdivision of a geometry.
  • ST_SwapOrdinates - Disponibilità: 2.2.0 Returns a version of the given geometry with given ordinate values swapped.
  • postgis.enable_outdb_rasters - Disponibilità: 2.2.0 A boolean configuration option to enable access to out-db raster bands.
  • postgis.gdal_datapath - Disponibilità: 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 - Disponibilità: 2.2.0 A configuration option to set the enabled GDAL drivers in the PostGIS environment. Affects the GDAL configuration variable GDAL_SKIP.
  • |=| - 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.

Funzioni migliorate 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.
  • 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 - Enhanced: 2.2.0 Added support for TIN and Curves Returns a text summary of the contents of a geometry.

Funzioni modificate 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.
  • 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. Restituisce il tipo di geometria per il valore 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

13.12.11. Funzioni PostGIS aggiunto o migliorate nella versione 2.1

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 2.1

  • ST_Box2dFromGeoHash - Disponibilità: 2.1.0 Restituisce un BOX2D da una stringa GeoHash.
  • ST_DelaunayTriangles - Disponibilità: 2.1.0 Returns the Delaunay triangulation of the vertices of a geometry.
  • ST_GeomFromGeoHash - Disponibilità: 2.1.0 Restituisce una geometria da una stringa GeoHash.
  • ST_PointFromGeoHash - Disponibilità: 2.1.0 Restituisce un punto da una stringa GeoHash.
  • postgis.backend - Disponibilità: 2.1.0 The backend to service a function where GEOS and SFCGAL overlap. Options: geos or sfcgal. Defaults to geos.

Funzioni migliorate in PostGIS 2.1

  • 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_Boundary - Miglioramento: nella versione 2.1.0 è stato introdotto il supporto per Triangle Restituisce il confine di una geometria.
  • 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_DumpPoints - Enhanced: 2.1.0 Faster speed. Reimplemented as native-C. Returns a set of geometry_dump rows for the coordinates in a geometry.
  • ST_MakeValid - Enhanced: 2.1.0, added support for GEOMETRYCOLLECTION and MULTIPOINT. Attempts to make an invalid geometry valid without losing vertices.
  • ST_Segmentize - Enhanced: 2.1.0 support for geography was introduced. Returns a modified geometry/geography having no segment longer than a given distance.
  • ST_Summary - Enhanced: 2.1.0 S flag to denote if has a known spatial reference system Returns a text summary of the contents of a geometry.

Funzioni modificate in PostGIS 2.1

  • 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 - Changed: 2.1.0. Up to 2.0.x this was called ST_Force_2D. Force the geometries into a "2-dimensional mode".
  • ST_Force3D - Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3D. Force the geometries into XYZ mode. This is an alias for ST_Force3DZ.
  • ST_Force3DM - Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3DM. Force the geometries into XYM mode.
  • ST_Force3DZ - Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3DZ. Force the geometries into XYZ mode.
  • ST_Force4D - Changed: 2.1.0. Up to 2.0.x this was called ST_Force_4D. Force the geometries into XYZM mode.
  • ST_ForceCollection - Changed: 2.1.0. Up to 2.0.x this was called ST_Force_Collection. Convert the geometry into a GEOMETRYCOLLECTION.
  • ST_LineInterpolatePoint - Changed: 2.1.0. Up to 2.0.x this was called ST_Line_Interpolate_Point. Returns a point interpolated along a line at a fractional location.
  • ST_LineLocatePoint - Changed: 2.1.0. Up to 2.0.x this was called ST_Line_Locate_Point. Returns the fractional location of the closest point on a line to a point.
  • ST_LineSubstring - Changed: 2.1.0. Up to 2.0.x this was called ST_Line_Substring. Returns the part of a line between two fractional locations.
  • 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.

13.12.12. Funzioni PostGIS aggiunto o migliorate nella versione 2.0

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 2.0

  • &&& - Disponibilità: 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.
  • ST_3DClosestPoint - Disponibilità: 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 - Disponibilità: 2.0.0 Tests if two 3D geometries are entirely within a given 3D distance
  • ST_3DDWithin - Disponibilità: 2.0.0 Tests if two 3D geometries are within a given 3D distance
  • ST_3DDistance - Disponibilità: 2.0.0 Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DIntersects - Disponibilità: 2.0.0 Tests if two geometries spatially intersect in 3D - only for points, linestrings, polygons, polyhedral surface (area)
  • ST_3DLongestLine - Disponibilità: 2.0.0 Returns the 3D longest line between two geometries
  • ST_3DMaxDistance - Disponibilità: 2.0.0 Returns the 3D cartesian maximum distance (based on spatial ref) between two geometries in projected units.
  • ST_3DShortestLine - Disponibilità: 2.0.0 Returns the 3D shortest line between two geometries
  • ST_AsLatLonText - Disponibilità: 2.0 Return the Degrees, Minutes, Seconds representation of the given point.
  • 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_CollectionHomogenize - Disponibilità: 2.0.0 Returns the simplest representation of a geometry collection.
  • ST_ConcaveHull - Disponibilità: 2.0.0 Computes a possibly concave geometry that contains all input geometry vertices
  • ST_FlipCoordinates - Disponibilità: 2.0.0 Returns a version of a geometry with X and Y axis flipped.
  • ST_GeomFromGeoJSON - Disponibilità: 2.0.0. Richiede - JSON-C >= 0.9 Accetta come input la rappresentazione geojson di una geometria e restituisce una geometria PostGIS
  • ST_InterpolatePoint - Disponibilità: 2.0.0 Returns the interpolated measure of a geometry closest to a point.
  • ST_IsValidDetail - Disponibilità: 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 - Availability: 2.0.0 - Support for LineString input elements was introduced Crea una LineString da una geometria Point, MultiPoint o un set di LineString
  • ST_MakeValid - Disponibilità: 2.0.0 Attempts to make an invalid geometry valid without losing vertices.
  • ST_Node - Disponibilità: 2.0.0 Nodes a collection of lines.
  • ST_NumPatches - Disponibilità: 2.0.0 Return the number of faces on a Polyhedral Surface. Will return null for non-polyhedral geometries.
  • ST_OffsetCurve - Disponibilità: 2.0 Returns an offset line at a given distance and side from an input line.
  • ST_PatchN - Disponibilità: 2.0.0 Restituisce il tipo di geometria per il valore 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_Project - Disponibilità: 2.0.0 Returns a point projected from a start point by a distance and bearing (azimuth).
  • ST_RelateMatch - Disponibilità: 2.0.0 Tests if a DE-9IM Intersection Matrix matches an Intersection Matrix pattern
  • ST_SharedPaths - Disponibilità: 2.0.0 Restituisce un insieme contenente i percorsi condivisi dalle due stringhe/multilinghe in ingresso.
  • ST_Snap - Disponibilità: 2.0.0 Snap segments and vertices of input geometry to vertices of a reference geometry.
  • ST_Split - Availability: 2.0.0 requires GEOS Returns a collection of geometries created by splitting a geometry by another geometry.
  • ST_UnaryUnion - Disponibilità: 2.0.0 Computes the union of the components of a single geometry.

Funzioni migliorate in PostGIS 2.0

  • && - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Returns TRUE if A's 2D bounding box intersects B's 2D bounding box.
  • AddGeometryColumn - Miglioramento nella version 2.0.0: introdotto il parametro use_typmod. Se settato su true (o se omesso) la funzione genererà una colonna geometry basata su typmod. Se settato su "false", la funzione genererà una colonna geometry con basata su vincoli geometrici. Aggiunge una colonna geometrica a una tabella esistente.
  • Box2D - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Returns a BOX2D representing the 2D extent of a geometry.
  • Box3D - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Returns a BOX3D representing the 3D extent of a geometry.
  • GeometryType - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Restituisce il tipo di geometria come testo.
  • Populate_Geometry_Columns - Miglioramento nelle version 2.0.0: Il parametro opzionale use_typmod è stato introdotto per permettere di controllare se le colonne devono essere create con typmodifier oppure con i vincoli spaziali. Garantisce che le colonne di tipo geometrico siano definite con dei modificatori di tipo o abbiano dei vincoli spaziali appropriati.
  • ST_3DExtent - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Funzione aggregata che restituisce il rettangolo di selezione 3D delle geometrie.
  • ST_Affine - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i 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 - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i 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 - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i 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. Ritorna la rappresentazione Well-Known Text (WKT) della geometria con incluso lo SRID.
  • 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 - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche e i TIN. Non viene più generata un'eccezione se viene data una geometria vuota. Restituisce la dimensione topologica di una geometria.
  • ST_Dump - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Returns a set of geometry_dump rows for the components of a geometry.
  • ST_DumpPoints - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Returns a set of geometry_dump rows for the coordinates in a geometry.
  • ST_Expand - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Returns a bounding box expanded from another bounding box or a geometry.
  • ST_Extent - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Funzione aggregata che restituisce il rettangolo di selezione delle geometrie.
  • ST_Force2D - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Force the geometries into a "2-dimensional mode".
  • ST_Force3D - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Force the geometries into XYZ mode. This is an alias for ST_Force3DZ.
  • ST_Force3DZ - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Force the geometries into XYZ mode.
  • ST_ForceCollection - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Convert the geometry into a GEOMETRYCOLLECTION.
  • ST_ForceRHR - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Force the orientation of the vertices in a polygon to follow the Right-Hand-Rule.
  • ST_GMLToSQL - Miglioramento nella version 2.0.0: introdotto il supporto per superfici poliedriche e TIN. Restituisce un valore ST_Geometry a partire da una rappresentazione GML. Questo è solo un alias per la funzione ST_GeomFromGML.
  • ST_GMLToSQL - Miglioramento nella versione: 2.0.0 introdotto opzionale parametro SRID. Restituisce un valore ST_Geometry a partire da una rappresentazione GML. Questo è solo un alias per la funzione ST_GeomFromGML.
  • ST_GeomFromEWKB - Miglioramento nella version 2.0.0: introdotto il supporto per superfici poliedriche e TIN. Ritorna un valore ST_Geometry a partire da Extended Well-Known Binary (EWKB).
  • ST_GeomFromEWKT - Miglioramento nella version 2.0.0: introdotto il supporto per superfici poliedriche e TIN. Ritorna un valore ST_Geometry a partire da una rappresentazione Extended Well-Known Text (EWKT).
  • ST_GeomFromGML - Miglioramento nella version 2.0.0: introdotto il supporto per superfici poliedriche e TIN. Accetta una geometria in formato GML come input e restituisce un oggetto PostGIS geometry
  • ST_GeomFromGML - Miglioramento nella versione: 2.0.0 introdotto opzionale parametro SRID. Accetta una geometria in formato GML come input e restituisce un oggetto PostGIS geometry
  • ST_GeometryN - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_GeometryType - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_IsClosed - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Restituisce TRUE se il punto iniziale e quello finale di LINESTRING coincidono. Per le superfici poliedriche indica una superficie chiusa (volumetrica).
  • ST_MakeEnvelope - Enhanced: 2.0: Ability to specify an envelope without specifying an SRID was introduced. Creates a rectangular Polygon from minimum and maximum coordinates.
  • ST_MakeValid - Enhanced: 2.0.1, speed improvements Attempts to make an invalid geometry valid without losing vertices.
  • ST_NPoints - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Returns the number of points (vertices) in a geometry.
  • ST_NumGeometries - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Restituisce TRUE se la geometria è una geometrycollection, un poligono o un punto vuoto, ecc.
  • 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 - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i 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 - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Rotates a geometry about the X axis.
  • ST_RotateY - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Rotates a geometry about the Y axis.
  • ST_RotateZ - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Rotates a geometry about the Z axis.
  • ST_Scale - Migliorato: Nella 2.0.0 è stato introdotto il supporto per le superfici poliedriche, i triangoli e i TIN. Scales a geometry by given factors.
  • ST_ShiftLongitude - Miglioramento nella version 2.0.0: introdotto il supporto per superfici poliedriche e TIN. Shifts the longitude coordinates of a geometry between -180..180 and 0..360.
  • ST_Summary - Enhanced: 2.0.0 added support for geography Returns a text summary of the contents of a geometry.
  • ST_Transform - Miglioramento: nella versione 2.0.0 è stato introdotto il supporto per le superfici poliedriche. Return a new geometry with coordinates transformed to a different spatial reference system.

Funzioni modificate in PostGIS 2.0

  • AddGeometryColumn - Cambiamento nella versione 2.0.0: questa funzione non aggiorna più geometry_columns perché geometry_columns non è più una tabella ma una vista che estrae automaticamente le informazioni necessarie dal system catalog. Inoltre per default la funzione non crea vincoli ma usa il modificatore di tipi integrato in PostgreSQL. Per esempio: creare una colonna con tipo POINT e con SRID 4326 con questa funzione, ora è equivalente a:ALTER TABLE some_table ADD COLUMN geom geometry(Point,4326); Aggiunge una colonna geometrica a una tabella esistente.
  • AddGeometryColumn - Cambiamento nella versione 2.0.0: il vecchio funzionamento con i vincoli può essere attivato passando alla funzione l'argomento use_typmod impostato su false. Aggiunge una colonna geometrica a una tabella esistente.
  • AddGeometryColumn - Cambiamento in versione 2.0.0: le viste non possono più essere registrate in geometry_columns, a meno che le colonne geometry a cui fanno riferimento non siano state generate con typmod e usate senza funzioni wrapper. In questo caso la vista sarà registrata correttamente in geometry_columns perché eredita il typmod dalla colonna geometry originale. Le viste che usano funzioni che ritornano geometrie verranno registrate correttamente se il tipo dell'output della funzione verrà definito esplicitamente con la funzione CAST come typmod geometry. Si veda . Aggiunge una colonna geometrica a una tabella esistente.
  • DropGeometryColumn - Cambiamento nella versione 2.0.0: questa funzione è mantenuta per retrocompatibilità. Attualmente, essendo geometry_columns una vista basata sul system catalog, una colonna geometry può essere rimossa come qualsiasi altra colonna con ALTER TABLE Rimuove una colonna geometry da una tabella spaziale
  • DropGeometryTable - Cambiamento nella versione 2.0.0: questa funzione è mantenuta per retrocompatibilità. Attualmente, essendo geometry_columns una vista basata sul system catalog, una tabella spaziale può essere rimossa come qualsiasi altra tabella con DROP TABLE Rimuove una tabella e tutte le sue referenze da geometry_columns
  • Populate_Geometry_Columns - Cambiamento nella versione 2.0.0: Per default la funzione utilizza ora type modifier invece di controllare i vincoli spaziali. il meccanismo con i vincoli può essere comunque attivato passando il parametro use_typmod e settandolo come false. Garantisce che le colonne di tipo geometrico siano definite con dei modificatori di tipo o abbiano dei vincoli spaziali appropriati.
  • ST_3DExtent - Modificato nella versione 2.0.0. Nelle versioni precedenti era chiamato ST_Extent3D Funzione aggregata che restituisce il rettangolo di selezione 3D delle geometrie.
  • 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 - Modifica: La versione 2.0.0 non funziona più con geometrie singole di stringhe multilinea. Nelle versioni precedenti di PostGIS una stringa multilinea con una sola linea avrebbe funzionato tranquillamente con questa funzione, restituendo il punto di inizio. Nella versione 2.0.0 la funzione restituisce NULL come per qualsiasi altra stringa multilinea. Il comportamento precedente non era documentato, ma le persone che presumevano di avere i dati memorizzati come LINESTRING potrebbero trovare che questi ora restituiscono il valore NULL. Returns the last point of a LineString or CircularLineString.
  • ST_GeomFromText - Modificato: 2.0.0 Nelle versioni precedenti di PostGIS era consentito ST_GeomFromText('GEOMETRYCOLLECTION(EMPTY)'). Questo è ora illegale in PostGIS 2.0.0 per conformarsi meglio agli standard SQL/MM. Ora si dovrebbe scrivere ST_GeomFromText('GEOMETRYCOLLECTION EMPTY') Restituisce un valore ST_Geometry a partire da una rappresentazione Well-Known-Text (WKT)
  • ST_GeometryN - Changed: 2.0.0 Prior versions would return NULL for singular geometries. This was changed to return the geometry for ST_GeometryN(..,1) case. Restituisce il tipo di geometria per il valore ST_Geometry.
  • ST_IsEmpty - Changed: 2.0.0 In prior versions of PostGIS ST_GeomFromText('GEOMETRYCOLLECTION(EMPTY)') was allowed. This is now illegal in PostGIS 2.0.0 to better conform with SQL/MM standards 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 - Changed: 2.0.0 in prior versions this used to be called ST_Locate_Along_Measure. Returns the point(s) on a geometry that match a measure value.
  • ST_LocateBetween - Changed: 2.0.0 - in prior versions this used to be called ST_Locate_Between_Measures. Returns the portions of a geometry that match a measure range.
  • ST_NumGeometries - Changed: 2.0.0 In prior versions this would return NULL if the geometry was not a collection/MULTI type. 2.0.0+ now returns 1 for single geometries e.g POLYGON, LINESTRING, POINT. Restituisce TRUE se la geometria è una geometrycollection, un poligono o un punto vuoto, ecc.
  • ST_NumInteriorRings - Changed: 2.0.0 - in prior versions it would allow passing a MULTIPOLYGON, returning the number of interior rings of first POLYGON. Returns the number of interior rings (holes) of a Polygon.
  • ST_PointN - Changed: 2.0.0 no longer works with single geometry multilinestrings. In older versions of PostGIS -- a single line multilinestring would work happily with this function and return the start point. In 2.0.0 it just returns NULL like any other multilinestring. Returns the Nth point in the first LineString or circular LineString in a geometry.
  • ST_StartPoint - Modifica: La versione 2.0.0 non funziona più con geometrie singole di stringhe multilinea. Nelle versioni precedenti di PostGIS una stringa multilinea con una sola linea avrebbe funzionato tranquillamente con questa funzione, restituendo il punto di inizio. Nella versione 2.0.0 la funzione restituisce NULL come per qualsiasi altra stringa multilinea. Il comportamento precedente non era documentato, ma le persone che presumevano di avere i dati memorizzati come LINESTRING potrebbero trovare che questi ora restituiscono il valore NULL. Returns the first point of a LineString.

13.12.13. Funzioni PostGIS aggiunto o migliorate nella versione 1.5

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove 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 - Disponibilità: dalla versione 1.5. Returns the version number of the libxml2 library.
  • ST_AddMeasure - Disponibilità: 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 - Disponibilità: 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 - Disponibilità: 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 - Disponibilità: 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 - Disponibilità: 1.5.0 Returns a set of geometry_dump rows for the coordinates in a geometry.
  • ST_Envelope - Disponibilità: il comportamento nella 1.5.0 è stato cambiato per dare in uscita numeri in precisione doppia anziche float4 Returns a geometry representing the bounding box of a geometry.
  • ST_Expand - Disponibilità: 1.5.0 il comportamento è stato modificato per produrre coordinate a doppia precisione anziché float4. Returns a bounding box expanded from another bounding box or a geometry.
  • ST_GMLToSQL - Disponibilità: 1.5, richiede libxml2 1.6+ Restituisce un valore ST_Geometry a partire da una rappresentazione GML. Questo è solo un alias per la funzione ST_GeomFromGML.
  • ST_GeomFromGML - Disponibilità: 1.5, richiede libxml2 1.6+ Accetta una geometria in formato GML come input e restituisce un oggetto PostGIS geometry
  • ST_GeomFromKML - Disponibilità: 1.5, richiede libxml2 2.6+ Accetta come input una geometria in formato KML e restituisce una geometria PostGIS.
  • ST_HausdorffDistance - Disponibilità: 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 - Disponibilità: 1.5.0 Returns the 2D longest line between two geometries.
  • ST_MakeEnvelope - Disponibilità: dalla versione 1.5. Creates a rectangular Polygon from minimum and maximum coordinates.
  • ST_MaxDistance - Disponibilità: 1.5.0 Returns the 2D largest distance between two geometries in projected units.
  • ST_ShortestLine - Disponibilità: 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.14. Funzioni PostGIS aggiunto o migliorate nella versione 1.4

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 1.4

  • Populate_Geometry_Columns - Disponibilità: 1.4.0 Garantisce che le colonne di tipo geometrico siano definite con dei modificatori di tipo o abbiano dei vincoli spaziali appropriati.
  • ST_Collect - Availability: 1.4.0 - ST_Collect(geomarray) was introduced. ST_Collect was enhanced to handle more geometries faster. Creates a GeometryCollection or Multi* geometry from a set of geometries.
  • ST_ContainsProperly - Disponibilità: 1.4.0 Tests if every point of B lies in the interior of A
  • ST_GeoHash - Disponibilità: 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 - Disponibilità: 1.4.0 Returns the portions of a geometry that lie in an elevation (Z) range.
  • ST_MakeLine - Availability: 1.4.0 - ST_MakeLine(geomarray) was introduced. ST_MakeLine aggregate functions was enhanced to handle more points faster. Crea una LineString da una geometria Point, MultiPoint o un set di LineString
  • ST_MinimumBoundingCircle - Disponibilità: 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.15. Funzioni PostGIS aggiunto o migliorate nella versione 1.3

Le seguenti funzioni PostGIS sono quelle aggiunte o migliorate.

Funzioni nuove in PostGIS 1.3

  • ST_AsGML - Disponibilità: 1.3.2 Return the geometry as a GML version 2 or 3 element.
  • ST_AsGeoJSON - Disponibilità: 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 - Availability: 1.3.3 Returns a simplified and valid representation of a geometry, using the Douglas-Peucker algorithm.