General Usage PostGIS

Enhanced 'Analyze' functions for geospatial analysis

Analyze provides access to the powerful PostGIS library of functions for geospatial analysis. The functions available are shown in the following table and link to instructions on the PostGIS site.

Geometry Constructors

FunctionDescription
ST_BdPolyFromTextConstruct a Polygon given an arbitrary collection of closed linestrings as a MultiLineString Well-Known text representation.
ST_BdMPolyFromTextConstruct a MultiPolygon given an arbitrary collection of closed linestrings as a MultiLineString text representation Well-Known text representation.
ST_Box2dFromGeoHashReturn a BOX2D from a GeoHash string.
ST_GeogFromTextReturn a specified geography value from Well-Known Text representation or extended (WKT).
ST_GeographyFromTexReturn a specified geography value from Well-Known Text representation or extended (WKT).
ST_GeogFromWKBCreates a geography instance from a Well-Known Binary geometry representation (WKB) or extended Well Known Binary (EWKB).
ST_GeomCollFromTextMakes a collection Geometry from collection WKT with the given SRID. If SRID is not give, it defaults to 0.
ST_GeomFromEWKBReturn a specified ST_Geometry value from Extended Well-Known Binary representation (EWKB).
ST_GeomFromEWKTReturn a specified ST_Geometry value from Extended Well-Known Text representation (EWKT).
ST_GeometryFromTextReturn a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText
ST_GeomFromGeoHashReturn a geometry from a GeoHash string.
ST_GeomFromGMLTakes as input GML representation of geometry and outputs a PostGIS geometry object
ST_GeomFromGeoJSONTakes as input a geojson representation of a geometry and outputs a PostGIS geometry object
ST_GeomFromKMLTakes as input KML representation of geometry and outputs a PostGIS geometry object
ST_GMLToSQLReturn a specified ST_Geometry value from GML representation. This is an alias name for ST_GeomFromGML
ST_GeomFromTextReturn a specified ST_Geometry value from Well-Known Text representation (WKT).
ST_GeomFromWKBCreates a geometry instance from a Well-Known Binary geometry representation (WKB) and optional SRID.
ST_LineFromEncodedPolylineCreates a LineString from an Encoded Polyline.
ST_LineFromMultiPointCreates a LineString from a MultiPoint geometry.
ST_LineFromTextMakes a Geometry from WKT representation with the given SRID. If SRID is not given, it defaults to 0.
ST_LineFromWKBMakes a LINESTRING from WKB with the given SRID
ST_LinestringFromWKBMakes a geometry from WKB with the given SRID.
ST_MakeBox2DCreates a BOX2D defined by the given point geometries.
ST_3DMakeBoxCreates a BOX3D defined by the given 3d point geometries.
ST_MakeLineCreates a Linestring from point or line geometries.
ST_MakeEnvelopeCreates a rectangular Polygon formed from the given minimums and maximums. Input values must be in SRS specified by the SRID
ST_MakePolygonCreates a Polygon formed by the given shell. Input geometries must be closed LINESTRINGS.
ST_MakePointCreates a 2D,3DZ or 4D point geometry.
ST_MakePointMCreates a point geometry with an x, y, and m coordinate.
ST_MLineFromTextReturn a specified ST_MultiLineString value from WKT representation.
ST_MPointFromTextMakes a Geometry from WKT with the given SRID. If SRID is not give, it defaults to 0.
ST_MPolyFromTextMakes a MultiPolygon Geometry from WKT with the given SRID. If SRID is not give, it defaults to 0.
ST_PointReturns an ST_Point with the given coordinate values. OGC alias for ST_MakePoint.
ST_PointFromGeoHashReturn a point from a GeoHash string.
ST_PointFromTextMakes a point Geometry from WKT with the given SRID. If SRID is not given, it defaults to unknown.
ST_PointFromWKBMakes a geometry from WKB with the given SRID
ST_PolygonReturns a polygon built from the specified linestring and SRID.
ST_PolygonFromTextMakes a Geometry from WKT with the given SRID. If SRID is not give, it defaults to 0.
ST_WKBToSQLReturn a specified ST_Geometry value from Well-Known Binary representation (WKB). This is an alias name for ST_GeomFromWKB that takes no srid
ST_WKTToSQLReturn a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText
Last modified November 27, 2023 at 12:56 PM EST: Restructured the file structure/a few changes (f6c58b8)