Analytics for the Internet of Things (IoT)

PostGIS spatial functions

PostGIS contains dozens of spatial functions that can be referenced in a standard SQL query. The following table provides an overview of some commonly used functions:

Function	Description
ST_GeomFromText	This returns a specified ST_Geometry value from WKT representation.
ST_GeomFromWKB	This creates a geometry instance from a WKB geometry representation and optional SRID.
ST_Buffer	This returns a geometry covering all points within a given distance from the input geometry.
ST_ConvexHull	The convex hull of a geometry represents the minimum convex geometry that encloses all geometries within the set.
ST_Intersection	This returns a geometry that represents the shared portion of geomA and geomB ...