Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks Runtime
Important
This feature is in Public Preview.
| Function | Description |
|---|---|
| st_addpoint(geo1Expr, geo2Expr[, indexExpr]) | Adds a new point to the n-th position in the input linestring GEOGRAPHY or GEOMETRY value. |
| st_area(geoExpr) | Returns the area of the input GEOGRAPHY or GEOMETRY value. |
| st_asbinary(geoExpr) | Returns the WKB representation of the input GEOGRAPHY or GEOMETRY value as a BINARY value. |
| st_asewkb(geoExpr) | Returns the EWKB representation of the input GEOMETRY value as a BINARY value. |
| st_asgeojson(geoExpr) | Returns the GeoJSON representation of the input GEOGRAPHY or GEOMETRY value as a STRING value. |
| st_asewkt(geoExpr) | Returns the EWKT representation of the input GEOGRAPHY or GEOMETRY value as a STRING value. |
| st_astext(geoExpr) | Returns the WKT representation of the input GEOGRAPHY or GEOMETRY value as a STRING value. |
| st_aswkb(geoExpr) | Returns the WKB representation of the input GEOGRAPHY or GEOMETRY value as a BINARY value. |
| st_aswkt(geoExpr) | Returns the WKT representation of the input GEOGRAPHY or GEOMETRY value as a STRING value. |
| st_buffer(geoExpr, radiusExpr) | Returns the buffer of the input GEOMETRY value using the specified radius. |
| st_centroid(geoExpr) | Returns the centroid of the input GEOMETRY value as a 2D point GEOMETRY value. |
| st_concavehull(geoExpr, lengthRatioExpr[, allowHolesExpr]) | Returns the concave hull of the input GEOMETRY value as a GEOMETRY value using the specified length ratio. |
| st_contains(geoExpr1, geoExpr2) | Returns true if the first GEOMETRY value contains the second GEOMETRY value. |
| st_convexhull(geoExpr) | Returns the convex hull of the input GEOMETRY value as a GEOMETRY value. |
| st_covers(geoExpr1, geoExpr2) | Returns true if the first GEOMETRY value covers the second GEOMETRY value. |
| st_difference(geoExpr1, geoExpr2) | Returns the point-set difference of the two input GEOMETRY values as a 2D GEOMETRY value. |
| st_dimension(geoExpr) | Returns the topological dimension of the 2D projection of the GEOMETRY value. |
| st_disjoint(geoExpr1, geoExpr2) | Returns true if the two input GEOMETRY values are disjoint. |
| st_distance(geoExpr1, geoExpr2) | Returns the 2D Cartesian distance between the two input GEOMETRY values. |
| st_distancesphere(geoExpr1, geoExpr2) | Returns the spherical distance (in meters) between two point GEOMETRY values, measured on a sphere whose radius is the mean radius of the WGS84 ellipsoid. |
| st_distancespheroid(geoExpr1, geoExpr2) | Returns the geodesic distance (in meters) between two point GEOMETRY values on the WGS84 ellipsoid. |
| st_dump(geoExpr) | Returns an array containing the single geometries in the input geometry. |
| st_dwithin(geoExpr1, geoExpr2, distanceExpr) | Returns true if the 2D Cartesian distance between the two input GEOMETRY values is smaller than or equal to the input distance value. |
| st_endpoint(geoExpr) | Returns the last point of the input GEOGRAPHY or GEOMETRY value, if the input geospatial value is a non-empty linestring. |
| st_envelope(geoExpr) | Returns a 2D Cartesian GEOMETRY value representing the 2D axis-aligned minimum bounding box (envelope) of the input GEOMETRY value. |
| st_envelope_agg(geoCol) | Returns the envelope of all the geometries in the column, or NULL if the column has zero rows, or contains only NULL values. |
| st_equals(geoExpr1, geoExpr2) | Returns true if the two input GEOMETRY values are geometrically equal, meaning they correspond to the same point set. |
| st_exteriorring(geoExpr) | Returns the exterior ring of the input polygon GEOGRAPHY or GEOMETRY as a linestring. |
| st_flipcoordinates(geoExpr) | Swaps X and Y coordinates of the input GEOMETRY value. |
| st_geogfromgeojson(geojsonExpr) | Returns a GEOGRAPHY(4326) value from its GeoJSON representation. |
| st_geogfromtext(wktExpr) | Returns a GEOGRAPHY(4326) value from its WKT representation. |
| st_geogfromwkb(wktExpr) | Returns a GEOGRAPHY(4326) value from its WKB representation. |
| st_geogfromwkt(wktExpr) | Returns a GEOGRAPHY(4326) value from its WKT representation. |
| st_geohash(geoExpr [, precisionExpr]) | Returns the geohash of the input geometry at the given precision. |
| st_geomfromewkb(wktExpr) | Returns a GEOMETRY(ANY) value from its EWKB representation. |
| st_geomfromgeohash(geohashExpr) | Returns the geohash grid box corresponding to the input geohash value as a 2D polygon GEOMETRY value. |
| st_geomfromgeojson(geojsonExpr) | Returns a GEOMETRY(4326) value from its GeoJSON representation. |
| st_geomfromtext(wktExpr[, sridExpr]) | Returns a GEOMETRY(srid) or GEOMETRY(ANY) value from its WKT representation, and sets its SRID value to the value of sridExpr, or 0 if sridExpr is omitted. |
| st_geomfromwkb(wkbExpr[, sridExpr]) | Returns a GEOMETRY(srid) or GEOMETRY(ANY) value from its WKB representation, and sets its SRID value to the value of sridExpr, or 0 if sridExpr is omitted. |
| st_geomfromwkt(wktExpr[, sridExpr]) | Returns a GEOMETRY(srid) or GEOMETRY(ANY) value from its WKT representation, and sets its SRID value to the value of sridExpr, or 0 if sridExpr is omitted. |
| st_geometryn(geoExpr, nExpr) | Returns the 1-based n-th element of the input GEOMETRY value as a GEOMETRY value. |
| st_geometrytype(geoExpr) | Returns the type of the input GEOGRAPHY or GEOMETRY value as a string. |
| st_interiorringn(geoExpr, indexExpr) | Returns the n-th interior ring of the input polygon GEOGRAPHY or GEOMETRY as a linestring. |
| st_intersection(geoExpr1, geoExpr2) | Returns the point-set intersection of the two input GEOMETRY value as a 2D GEOMETRY value. |
| st_intersects(geoExpr1, geoExpr2) | Returns true if the two input GEOMETRY values intersect. |
| st_isempty(geoExpr) | Returns true if the input GEOGRAPHY or GEOMETRY value does not contain any non-empty points. |
| st_isvalid(geoExpr) | Returns true if the input GEOMETRY value is a valid geometry in the OGC sense. |
| st_length(geoExpr) | Returns the length of the input GEOGRAPHY or GEOMETRY value. |
| st_m(geoExpr) | Returns the M coordinate of the input point GEOMETRY value, or NULL if the point is empty or does not have an M coordinate. |
| st_makeline(geoArray) | Returns a linestring GEOMETRY value whose points are the non-empty points of the geometries in the input array of geometries, which are expected to be points, linestrings, or multipoints. |
| st_makepolygon(outer[, innerArray]) | Constructs a polygon GEOMETRY value from the input outer boundary and optional array of inner boundaries, represented as closed linestrings. |
| st_multi(geoExpr) | Returns the input GEOGRAPHY or GEOMETRY value as an equivalent multi-geospatial value. |
| st_ndims(geoExpr) | Returns the coordinate dimension of the input GEOGRAPHY or GEOMETRY value. |
| st_npoints(geoExpr) | Returns the number of non-empty points in the input GEOGRAPHY or GEOMETRY value. |
| st_numgeometries(geoExpr) | Returns the number of geometries in the input GEOMETRY value. |
| st_numinteriorrings(geoExpr) | Returns the number of interior rings in the input polygon GEOGRAPHY or GEOMETRY value. |
| st_perimeter(geoExpr) | Returns the perimeter of the input GEOGRAPHY or GEOMETRY value. |
| st_point(x, y [, srid]) | Returns a point GEOMETRY value with the given X and Y coordinates and SRID value (if provided). |
| st_pointfromgeohash(geohash) | Returns the center of the geohash grid box corresponding to the input geohash value as a 2D point geometry. |
| st_pointn(geoExpr, indexExpr) | Returns the n-th point from the input linestring GEOGRAPHY or GEOMETRY value. |
| st_removepoint(geoExpr, indexExpr) | Removes the n-th point from the input linestring GEOGRAPHY or GEOMETRY value. |
| st_reverse(geoExpr) | Reverses the input GEOGRAPHY or GEOMETRY value. |
| st_rotate(geoExpr, rotationAngle) | Rotates the input GEOMETRY value around the Z axis by the given rotation angle (in radians). |
| st_scale(geoExpr, xfactor, yfactor[, zfactor]) | Scales the input GEOMETRY value in the X, Y, and, if specified, Z directions using the provided scaling factors. |
| st_setsrid(geo, srid) | Returns a new GEOMETRY value whose SRID is the specified SRID value. |
| st_simplify(geo, tolerance) | Simplifies the input GEOMETRY value using the Douglas-Peucker algorithm. |
| st_srid(geoExpr) | Returns the SRID of the input GEOGRAPHY or GEOMETRY value. |
| st_startpoint(geoExpr) | Returns the first point of the input GEOGRAPHY or GEOMETRY value, if the input geospatial value is a non-empty linestring. |
| st_touches(geo1, geo2) | Returns true if the two input GEOMETRY values touch each other. |
| st_transform(geo, srid) | Transforms the X and Y coordinates of the input geometry from the current coordinate reference system to the coordinate reference system described by the provided SRID value. |
| st_union(geo1, geo2) | Returns the point-set union of the two input GEOMETRY values as a 2D geometry. |
| st_union_agg(geoCol) | Returns the point-wise union of all the geometries in the column, or NULL if the column has zero rows, or contains only NULL values. |
| st_within(geo1, geo2) | Returns true if the first GEOMETRY value is within the second GEOMETRY value. |
| st_translate(geoExpr, xoffset, yoffset[, zoffset]) | Translates the input GEOMETRY value in the X, Y, and, if specified, Z directions using the provided offsets. |
| st_setpoint(geo1Expr, indexExpr, geo2Expr) | Sets the n-th point of the input linestring GEOGRAPHY or GEOMETRY value. |
| to_geography(georepExpr) | Returns a GEOGRAPHY(ANY) value from its GeoJSON, WKB, or WKT representation. |
| to_geometry(georepExpr) | Returns a GEOMETRY(ANY) value from its EWKB, GeoJSON, WKB, or WKT representation. |
| try_to_geography(georepExpr) | Returns a GEOGRAPHY(ANY) value from its GeoJSON, WKB, or WKT representation, or NULL if the input representation is invalid. |
| try_to_geometry(georepExpr) | Returns a GEOMETRY(ANY) value from its EWKB, GeoJSON, WKB, or WKT representation, or NULL if the input representation is invalid. |
| st_x(geoExpr) | Returns the X coordinate of the input point GEOMETRY value, or NULL if the point is empty. |
| st_xmax(geoExpr) | Returns the maximum X coordinate of the input GEOMETRY value, or NULL if the geometry is empty. |
| st_xmin(geoExpr) | Returns the minimum X coordinate of the input GEOMETRY value, or NULL if the geometry is empty. |
| st_y(geoExpr) | Returns the Y coordinate of the input point GEOMETRY value, or NULL if the point is empty. |
| st_ymax(geoExpr) | Returns the maximum Y coordinate of the input GEOMETRY value, or NULL if the geometry is empty. |
| st_ymin(geoExpr) | Returns the minimum Y coordinate of the input GEOMETRY value, or NULL if the geometry is empty. |
| st_z(geoExpr) | Returns the Z coordinate of the input point GEOMETRY value, or NULL if the point is empty or does not have a Z coordinate. |
| st_zmax(geoExpr) | Returns the maximum Z coordinate of the input GEOMETRY value, or NULL if the geometry is empty or does not have a Z coordinate. |
| st_zmin(geoExpr) | Returns the minimum Z coordinate of the input GEOMETRY value, or NULL if the geometry is empty or does not have a Z coordinate. |