PostGIS Functions that support 3D

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

• AddGeometryColumn – Adds a geometry column to an existing table of attributes.
• DropGeometryColumn – Removes a geometry column from a spatial table.
• ST_Accum – Aggregate. Constructs an array of geometries.
• ST_AddPoint – Adds a point to a LineString before point (0-based index).
• ST_Affine – Applies a 3d affine transformation to the geometry to do things like translate, rotate, scale in one step.
• ST_AsEWKB – Return the Well-Known Binary (WKB) representation of the geometry with SRID meta data.
• ST_AsEWKT – Return the Well-Known Text (WKT) representation of the geometry with SRID meta data.
• ST_AsGML – Return the geometry as a GML version 2 or 3 element.
• ST_AsGeoJSON – Return the geometry as a GeoJSON element.
• 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. Several variants. Default version=2, default precision=15
• ST_Boundary – Returns the closure of the combinatorial boundary of this Geometry.
• ST_Box3D – Returns a BOX3D representing the maximum extents of the geometry.
• ST_Collect – Return a specified ST_Geometry value from a collection of other geometries.
• ST_ConvexHull – The convex hull of a geometry represents the minimum convex geometry that encloses all geometries within the set.
• ST_CoordDim – Return the coordinate dimension of the ST_Geometry value.
• ST_CurveToLine – Converts a CIRCULARSTRING/CURVEDPOLYGON to a LINESTRING/POLYGON
• ST_Difference – Returns a geometry that represents that part of geometry A that does not intersect with geometry B.
• ST_Dump – Returns a set of geometry_dump (geom,path) rows, that make up a geometry g1.
• ST_DumpRings – Returns a set of geometry_dump rows, representing the exterior and interior rings of a polygon.
• ST_EndPoint – Returns the last point of a LINESTRING geometry as a POINT.
• ST_Extent3D – an aggregate function that returns the box3D bounding box that bounds rows of geometries.
• ST_ExteriorRing – Returns a line string representing the exterior ring of the POLYGON geometry. Return NULL if the geometry is not a polygon. Will not work with MULTIPOLYGON
• ST_ForceRHR – Forces the orientation of the vertices in a polygon to follow the Right-Hand-Rule.
• ST_Force_3D – Forces the geometries into XYZ mode. This is an alias for ST_Force_3DZ.
• ST_Force_3DZ – Forces the geometries into XYZ mode. This is a synonym for ST_Force_3D.
• ST_Force_4D – Forces the geometries into XYZM mode.
• ST_Force_Collection – Converts the geometry into a GEOMETRYCOLLECTION.
• ST_GeomFromEWKB – Return a specified ST_Geometry value from Extended Well-Known Binary representation (EWKB).
• ST_GeomFromEWKT – Return a specified ST_Geometry value from Extended Well-Known Text representation (EWKT).
• ST_GeometryN – Return the 1-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, MULTIPOINT, MULTILINESTRING, MULTICURVE or MULTIPOLYGON. Otherwise, return NULL.
• ST_HasArc – Returns true if a geometry or geometry collection contains a circular string
• ST_InteriorRingN – Return the Nth interior linestring ring of the polygon geometry. Return NULL if the geometry is not a polygon or the given N is out of range.
• ST_IsClosed – Returns TRUE if the LINESTRING’s start and end points are coincident.
• ST_IsSimple – Returns (TRUE) if this Geometry has no anomalous geometric points, such as self intersection or self tangency.
• ST_Length3D – Returns the 3-dimensional or 2-dimensional length of the geometry if it is a linestring or multi-linestring.
• ST_Length3D_Spheroid – Calculates the length of a geometry on an ellipsoid, taking the elevation into account. This is just an alias for ST_Length_Spheroid.
• ST_Length_Spheroid – Calculates the 2D or 3D length of a linestring/multilinestring on an ellipsoid. This is useful if the coordinates of the geometry are in longitude/latitude and a length is desired without reprojection.
• ST_LineFromMultiPoint – Creates a LineString from a MultiPoint geometry.
• ST_LineToCurve – Converts a LINESTRING/POLYGON to a CIRCULARSTRING, CURVED POLYGON
• ST_Line_Interpolate_Point – Returns a point interpolated along a line. Second argument is a float8 between 0 and 1 representing fraction of total length of linestring the point has to be located.
• ST_Line_Substring – Return a linestring being a substring of the input one starting and ending at the given fractions of total 2d length. Second and third arguments are float8 values between 0 and 1.
• ST_LocateBetweenElevations – Return a derived geometry (collection) value with elements that intersect the specified range of elevations inclusively. Only 3D, 4D LINESTRINGS and MULTILINESTRINGS are supported.
• ST_M – Return the M coordinate of the point, or NULL if not available. Input must be a point.
• ST_MakeBox3D – Creates a BOX3D defined by the given 3d point geometries.
• ST_MakeLine – Creates a Linestring from point geometries.
• ST_MakePoint – Creates a 2D,3DZ or 4D point geometry.
• ST_MakePolygon – Creates a Polygon formed by the given shell. Input geometries must be closed LINESTRINGS.
• ST_MemUnion – Same as ST_Union, only memory-friendly (uses less memory and more processor time).
• ST_Mem_Size – Returns the amount of space (in bytes) the geometry takes.
• ST_NDims – Returns coordinate dimension of the geometry as a small int. Values are: 2,3 or 4.
• ST_NPoints – Return the number of points (vertexes) in a geometry.
• ST_NRings – If the geometry is a polygon or multi-polygon returns the number of rings.
• ST_Perimeter3D – Returns the 3-dimensional perimeter of the geometry, if it is a polygon or multi-polygon.
• ST_PointN – Return the Nth point in the first linestring or circular linestring in the geometry. Return NULL if there is no linestring in the geometry.
• ST_PointOnSurface – Returns a POINT guaranteed to lie on the surface.
• ST_Polygon – Returns a polygon built from the specified linestring and SRID.
• ST_RemovePoint – Removes point from a linestring. Offset is 0-based.
• ST_Rotate – This is a synonym for ST_RotateZ
• ST_RotateX – Rotate a geometry rotRadians about the X axis.
• ST_RotateY – Rotate a geometry rotRadians about the Y axis.
• ST_RotateZ – Rotate a geometry rotRadians about the Z axis.
• ST_Scale – Scales the geometry to a new size by multiplying the ordinates with the parameters. Ie: ST_Scale(geom, Xfactor, Yfactor, Zfactor).
• ST_SetPoint – Replace point N of linestring with given point. Index is 0-based.
• ST_Shift_Longitude – Reads every point/vertex in every component of every feature in a geometry, and if the longitude coordinate is <0,>
• ST_SnapToGrid – Snap all points of the input geometry to the grid defined by its origin and cell size. Remove consecutive points falling on the same cell, eventually returning NULL if output points are not enough to define a geometry of the given type. Collapsed geometries in a collection are stripped from it. Useful for reducing precision.
• ST_StartPoint – Returns the first point of a LINESTRING geometry as a POINT.
• ST_Summary – Returns a text summary of the contents of the ST_Geometry.
• ST_SymDifference – Returns a geometry that represents the portions of A and B that do not intersect. It is called a symmetric difference because ST_SymDifference(A,B) = ST_SymDifference(B,A).
• ST_TransScale – Translates the geometry using the deltaX and deltaY args, then scales it using the XFactor, YFactor args, working in 2D only.
• ST_Translate – Translates the geometry to a new location using the numeric parameters as offsets. Ie: ST_Translate(geom, X, Y) or ST_Translate(geom, X, Y,Z).
• ST_Union – Returns a geometry that represents the point set union of the Geometries.
• ST_X – Return the X coordinate of the point, or NULL if not available. Input must be a point.
• ST_XMax – Returns X maxima of a bounding box 2d or 3d or a geometry.
• ST_XMin – Returns X minima of a bounding box 2d or 3d or a geometry.
• ST_Y – Return the Y coordinate of the point, or NULL if not available. Input must be a point.
• ST_YMax – Returns Y maxima of a bounding box 2d or 3d or a geometry.
• ST_YMin – Returns Y minima of a bounding box 2d or 3d or a geometry.
• ST_Z – Return the Z coordinate of the point, or NULL if not available. Input must be a point.
• ST_ZMax – Returns Z minima of a bounding box 2d or 3d or a geometry.
• ST_ZMin – Returns Z minima of a bounding box 2d or 3d or a geometry.
• ST_Zmflag – Returns ZM (dimension semantic) flag of the geometries as a small int. Values are: 0=2d, 1=3dm, 2=3dz, 3=4d.
• UpdateGeometrySRID – Updates the SRID of all features in a geometry column, geometry_columns metadata and srid table constraint