PostGIS Curved Geometry Support Functions

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

• AddGeometryColumn – Adds a geometry column to an existing table of attributes.
• DropGeometryColumn – Removes a geometry column from a spatial table.
• GeometryType – Returns the type of the geometry as a string. Eg: ‘LINESTRING’, ‘POLYGON’, ‘MULTIPOINT’, etc.
• ST_Accum – Aggregate. Constructs an array of geometries.
• ST_AddBBox – Add bounding box to the geometry.
• 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_AsHEXEWKB – Returns a Geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding.
• ST_AsText – Return the Well-Known Text (WKT) representation of the geometry without SRID metadata.
• ST_Box2D – Returns a BOX2D representing the maximum extents of the 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_CoordDim – Return the coordinate dimension of the ST_Geometry value.
• ST_CurveToLine – Converts a CIRCULARSTRING/CURVEDPOLYGON to a LINESTRING/POLYGON
• ST_DropBBox – Drop the bounding box cache from the geometry.
• ST_Dump – Returns a set of geometry_dump (geom,path) rows, that make up a geometry g1.
• ST_Estimated_Extent – Return the ‘estimated’ extent of the given spatial table. The estimated is taken from the geometry column’s statistics. The current schema will be used if not specified.
• ST_Extent3D – an aggregate function that returns the box3D bounding box that bounds rows of geometries.
• ST_Force_2D – Forces the geometries into a “2-dimensional mode” so that all output representations will only have the X and Y coordinates.
• ST_Force_3D – Forces the geometries into XYZ mode. This is an alias for ST_Force_3DZ.
• ST_Force_3DM – Forces the geometries into XYM mode.
• 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_GeoHash – Return a GeoHash representation (geohash.org) of the geometry.
• 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_GeomFromText – Return a specified ST_Geometry value from Well-Known Text representation (WKT).
• ST_GeomFromWKB – Creates a geometry instance from a Well-Known Binary geometry representation (WKB) and optional SRID.
• 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_HasBBox – Returns TRUE if the bbox of this geometry is cached, FALSE otherwise.
• ST_IsClosed – Returns TRUE if the LINESTRING’s start and end points are coincident.
• ST_IsEmpty – Returns true if this Geometry is an empty geometry . If true, then this Geometry represents the empty point set – i.e. GEOMETRYCOLLECTION(EMPTY).
• ST_LineToCurve – Converts a LINESTRING/POLYGON to a CIRCULARSTRING, CURVED POLYGON
• ST_Mem_Size – Returns the amount of space (in bytes) the geometry takes.
• 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_PointFromWKB – Makes a geometry from WKB with the given SRID
• 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_Rotate – This is a synonym for ST_RotateZ
• ST_RotateZ – Rotate a geometry rotRadians about the Z axis.
• ST_SRID – Returns the spatial reference identifier for the ST_Geometry as defined in spatial_ref_sys table.
• ST_Scale – Scales the geometry to a new size by multiplying the ordinates with the parameters. Ie: ST_Scale(geom, Xfactor, Yfactor, Zfactor).
• ST_SetSRID – Sets the SRID on a geometry to a particular integer value.
• ST_TransScale – Translates the geometry using the deltaX and deltaY args, then scales it using the XFactor, YFactor args, working in 2D only.
• ST_Transform – Returns a new geometry with its coordinates transformed to the SRID referenced by the integer parameter.
• 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_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_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_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