Return the area measurement of a Geometry.
Returns a geometry/geography that represents all points whose distance from this Geometry/geography is less than or equal to distance.
Return mathematical centroid of a geometry.
Test if leftGeometry full contains rightGeometry
Return the convex hull of a Geometry.
Test if leftGeometry crosses rightGeometry
Return the distance between two geometries.
Return the bounding rectangle for a Geometry
Return the envelope boundary of the entire column
Test if leftGeometry is equal to rightGeometry
Return a Geometry from a GeoJSON string
Return a Geometry from a GeoJSON string
This function takes 1 parameter which is the geometry string. The string format must be GeoJson.
Return a Geometry from a WKT string
Return a Geometry from a WKT string
This function takes 1 parameter which is the geometry string. The string format must be WKT.
Return a Geometry from a WKB string
Return a Geometry from a WKB string
This function takes 1 parameter which is the geometry string. The string format must be WKB.
Return a Geometry from a WKT string
Return a Geometry from a WKT string
This function takes 1 parameter which is the geometry string. The string format must be WKT.
Return the intersection shape of two geometries.
Return the intersection shape of two geometries. The return type is a geometry
Return the polygon intersection of all Polygon in the given column
Test if leftGeometry full intersects rightGeometry
Test if Geometry is simple.
Test if Geometry is valid.
Return the length measurement of a Geometry
Return a linestring from a string.
Return a linestring from a string. The string must be plain string and each coordinate must be separated by a delimiter.
Given an invalid polygon or multipolygon and removeHoles boolean flag, create a valid representation of the geometry
Return the number of Points in geometry.
Test if leftGeometry overlaps rightGeometry
Return a Point from X and Y
Return a Point from X and Y
This function takes 2 parameter which are point x and y.
Return a point from a string.
Return a point from a string. The string must be plain string and each coordinate must be separated by a delimiter.
This function takes 2 parameters. The first parameter is the input geometry string, the second parameter is the delimiter. String format should be similar to CSV/TSV
Return a polygon given minX,minY,maxX,maxY
Return a polygon from a string.
Return a polygon from a string. The string must be plain string and each coordinate must be separated by a delimiter.
Reduce the precision of the given geometry to the given number of decimal places
Reduce the precision of the given geometry to the given number of decimal places
The first arg is a geom and the second arg is an integer scale, specifying the number of decimal places of the new coordinate. The last decimal place will be rounded to the nearest number.
Simplifies a geometry and ensures that the result is a valid geometry having the same dimension and number of components as the input, and with the components having the same topological relationship.
Simplifies a geometry and ensures that the result is a valid geometry having the same dimension and number of components as the input, and with the components having the same topological relationship. The simplification uses a maximum-distance difference algorithm similar to the Douglas-Peucker algorithm.
first arg is geometry second arg is distance tolerance for the simplification(all vertices in the simplified geometry will be within this distance of the original geometry)
Test if leftGeometry touches rightGeometry
Given a geometry, sourceEPSGcode, and targetEPSGcode, convert the geometry's Spatial Reference System / Coordinate Reference System.
Return the polygon union of all Polygon in the given column
Test if leftGeometry is full within rightGeometry
Return the distance between two geometries.
This function takes two geometries and calculates the distance between two objects.