ST_Area |
any1 |
Double |
Returns the area of a polygon; returns 0.0 for any other geometry. |
ST_AsBinary |
any1 |
Binary |
Exports an object to a well-known binary (WKB) representation. |
ST_AsText |
any1 |
String |
Exports an object to well-known text (WKT) representation. |
ST_Boundary |
any1 |
ST_Geometry |
Returns the boundary of a geometry. |
ST_Buffer |
any1, 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 |
any1, 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 |
any1,any1 |
Boolean |
Returns TRUE if the second geometry is completely contained within the first
geometry. |
ST_Crosses |
any1,any1 |
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 |
any1,any1 |
ST_Geometry |
Returns a geometry object that represents the point set difference of the two specified
geometry objects. |
ST_Dimension |
any1 |
Integer |
Returns the inherent dimension of the input geometry, which must be less than or equal to the
coordinate dimension. In non-homogeneous collections, this returns the largest topological dimension
of the contained objects. |
ST_Disjoint |
any1,any1 |
Boolean |
Returns TRUE if the two specified geometries are disjoint, that is, if they do not intersect
one another. |
ST_Distance |
any1,any1 |
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 |
any1 |
ST_BoundingBox |
Returns the minimum bounding box for the input geometry. |
EnvelopesIntersect |
any1, 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 |
any1,any1 |
Boolean |
Returns TRUE if the two specified geometries are equal, that is, if they have matching X and
Y coordinates. |
ST_GeohashEncode |
any1, 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 |
any1, Double |
String[] |
Returns a collection of no more than 6 geohashes that cover the specified geometry, buffered
by the specified distance precision. |
ST_GeoJSONFromGeom |
any1 |
String |
Converts an SQL geometry into a GeoJSON string. |
ST_GeomCollection |
any1[] |
ST_GeomCollection |
Constructor for a geometry collection. |
ST_GeometryType |
any1 |
String |
Returns, as a string, the name of the instantiable subtype of the geometry of which this
object is an instantiable member. |
ST_Intersection |
any1,any1 |
ST_Geometry |
Returns a geometry object that represents the point set intersection of the two specified
geometry objects. |
ST_Intersects |
any1,any1 |
Boolean |
Returns TRUE if the two specified geometries intersect each other. |
ST_IntersectsInterior |
any1, any1 |
Boolean |
Returns TRUE if the first geometry intersects the interior of the second geometry. |
ST_IsDegenerate |
any1 |
Boolean |
Returns TRUE if the specified geometry is degenerate to a point. |
ST_IsEmpty |
any1 |
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 |
any1 |
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 |
any1 |
Boolean |
Returns TRUE if the specified geometry has no anomalous geometric points, such as
self-intersection or self-tangency. 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 |
any1 |
Boolean |
Returns TRUE if the specified geometry is valid. |
ST_Is3D |
any1 |
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 |
any1,any1 |
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 |
any1 |
Integer |
Returns the spatial reference system ID for this object. The default ID is 4326 --
WGS84. |
ST_SymDifference |
any1,any1 |
ST_Geometry |
Returns a geometry object that represents the point set symmetric difference of the two
specified geometry objects. |
ST_Touches |
any1,any1 |
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 |
any1,any1 |
Boolean |
Returns TRUE if the first geometry is completely within the second geometry. |
ST_Union |
any1,any1 |
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. |