ST_Area 
any^{1} 
Double 
Returns the area of a polygon; returns 0.0 for any other geometry. 
ST_AsBinary 
any^{1} 
Binary 
Exports an object to a wellknown binary (WKB) representation. 
ST_AsText 
any^{1} 
String 
Exports an object to wellknown text (WKT) representation. 
ST_Boundary 
any^{1} 
ST_Geometry 
Returns the boundary of a geometry. 
ST_Buffer 
any^{1}, Double 
ST_Geometry 
Returns a geometry that represents all points whose distance from the input geometry object
is less than or equal to the specified distance. Calculations are in the spatial reference system of
this geometry object. Because of the limitations of linear interpolation, there will often be a
relatively small error in this distance, but it should be near the resolution of the coordinates
used. 
ST_ContainingGeohash 
any^{1}, Double 
String 
Returns a single geohash that covers a specified geometry, buffered by the specified distance
precision. Note that this might result in a much looser cover than ST_GeohashEncodeDistance. 
ST_Contains 
any^{1},any^{1} 
Boolean 
Returns TRUE if the second geometry is completely contained within the first
geometry. 
ST_Crosses 
any^{1},any^{1} 
Boolean 
Returns TRUE if the two specified geometries cross each other, that is, if both:
 Their intersection results in a geometry with a dimension that is one less than the maximum
dimension of the two source geometries.
 The intersection set is interior to both source geometries.

ST_Difference 
any^{1},any^{1} 
ST_Geometry 
Returns a geometry object that represents the point set difference of the two specified
geometry objects. 
ST_Dimension 
any^{1} 
Integer 
Returns the inherent dimension of the input geometry, which must be less than or equal to the
coordinate dimension. In nonhomogeneous collections, this returns the largest topological dimension
of the contained objects. 
ST_Disjoint 
any^{1},any^{1} 
Boolean 
Returns TRUE if the two specified geometries are disjoint, that is, if they do not intersect
one another. 
ST_Distance 
any^{1},any^{1} 
Double 
Returns the shortest distance between any two points in the two geometries as calculated in
their spatial reference system. Because the geometries are closed, it is possible to find a point on
each geometry object involved such that the distance between these 2 points is the returned distance
between their geometries. 
ST_Envelope 
any^{1} 
ST_BoundingBox 
Returns the minimum bounding box for the input geometry. 
EnvelopesIntersect 
any^{1}, Double, Double, Double, Double 
Boolean 
Determines whether the envelope of the specified geometry intersects the specified envelope
or bounding box. The envelope or bounding box is determined by its lower corner (longitude and
latitude specified by the second and third parameters) and upper corner (longitude and latitude
specified by the fourth and fifth parameters). 
ST_Equals 
any^{1},any^{1} 
Boolean 
Returns TRUE if the two specified geometries are equal, that is, if they have matching X and
Y coordinates. 
ST_GeohashEncode 
any^{1}, Integer 
String[] 
Returns a collection of no more than 6 geohashes that cover the specified geometry. If the
geometry can be covered by geohashes whose bit depth is larger than the specified bit depth, the
geohashes are truncated to that bit depth. A point geometry always produces a single
geohash. 
ST_GeohashEncodeDistance 
any^{1}, Double 
String[] 
Returns a collection of no more than 6 geohashes that cover the specified geometry, buffered
by the specified distance precision. 
ST_GeoJSONFromGeom 
any^{1} 
String 
Converts an SQL geometry into a GeoJSON string. 
ST_GeomCollection 
any^{1}[] 
ST_GeomCollection 
Constructor for a geometry collection. 
ST_GeometryType 
any^{1} 
String 
Returns, as a string, the name of the instantiable subtype of the geometry of which this
object is an instantiable member. 
ST_Intersection 
any^{1},any^{1} 
ST_Geometry 
Returns a geometry object that represents the point set intersection of the two specified
geometry objects. 
ST_Intersects 
any^{1},any^{1} 
Boolean 
Returns TRUE if the two specified geometries intersect each other. 
ST_IntersectsInterior 
any^{1}, any^{1} 
Boolean 
Returns TRUE if the first geometry intersects the interior of the second geometry. 
ST_IsDegenerate 
any^{1} 
Boolean 
Returns TRUE if the specified geometry is degenerate to a point. 
ST_IsEmpty 
any^{1} 
Boolean 
Returns TRUE if the specified geometry is the empty geometry, that is, if the geometry
represents the empty point set ∅ for the coordinate space. 
ST_IsMeasured 
any^{1} 
Boolean 
Returns TRUE if the specified geometry has measure (M) coordinate values. Because this
database does not support M values, this function always returns FALSE. 
ST_IsSimple 
any^{1} 
Boolean 
Returns TRUE if the specified geometry has no anomalous geometric points, such as
selfintersection or selftangency. The description of each instantiable geometric class includes
the specific conditions that caused an instance of that class to be classified as not
simple. 
ST_IsValid 
any^{1} 
Boolean 
Returns TRUE if the specified geometry is valid. 
ST_Is3D 
any^{1} 
Boolean 
Returns TRUE if the specified geometry has Z coordinate values. Because this database does
not support Z values, this function always returns FALSE. 
ST_Overlaps 
any^{1},any^{1} 
Boolean 
Returns TRUE if the two specified geometries overlap, that is, if their intersection set
results in a geometry that is different from both of them but of the same dimension. 
ST_SRID 
any^{1} 
Integer 
Returns the spatial reference system ID for this object. The default ID is 4326 
WGS84. 
ST_SymDifference 
any^{1},any^{1} 
ST_Geometry 
Returns a geometry object that represents the point set symmetric difference of the two
specified geometry objects. 
ST_Touches 
any^{1},any^{1} 
Boolean 
Returns TRUE if the two specified geometries touch each other, that is, if their boundaries
intersect or if the interior of one geometry intersects the boundary of the other. 
ST_Within 
any^{1},any^{1} 
Boolean 
Returns TRUE if the first geometry is completely within the second geometry. 
ST_Union 
any^{1},any^{1} 
ST_Geometry 
Returns a geometry object that represents the point set union of the two specified geometry
objects. 
^{1} The input geometry type can be any of the types listed
here. 