Returns the boundary of an H3 cell in GeoJSON format.

Returns the boundary of an H3 cell in WKB format.

Returns the boundary of an H3 cell in WKT format.

Returns the center of an H3 cell in GeoJSON format.

Returns the center of an H3 cell in WKB format.

Returns the center of an H3 cell in WKT format.

Compacts the input set of H3 cell IDs as best as possible.

Returns an array of cell IDs represented as long integers, corresponding to hexagons or pentagons of the specified resolution that minimally cover the input linear or areal geography. The expression emits an error if the input geography type is not supported, or if an error is found when parsing the input representation of the geography. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns an array of cell IDs represented as strings, corresponding to hexagons or pentagons of the specified resolution that minimally cover the input linear or areal geography. The expression emits an error if the input geography type is not supported, or if an error is found when parsing the input representation of the geography. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns the grid distance between two H3 cell IDs.

Converts an H3 cell ID to a string representing the cell ID as a hexadecimal string.

Returns an array of H3 cell IDs that form a hollow hexagonal ring centered at the origin H3 cell and that are at grid distance k from the origin H3 cell.

Returns true if the first H3 cell ID is a child of the second H3 cell ID.

Returns true if the input H3 cell ID represents a pentagon.

Returns true if the input represents a valid H3 cell ID.

Returns the H3 cell IDs that are within (grid) distance k of the origin cell ID.

Returns all H3 cell IDs (represented as long integers or strings) within grid distance k from the origin H3 cell ID, along with their distance from the origin H3 cell ID. More precisely, the result is an array of structs, where each struct contains an H3 cell id (represented as a long integer or string) and its distance from the origin H3 cell ID. The type for the H3 cell IDs in the output is the same as the type of the input H3 cell ID (first argument of the expression).

Returns the H3 cell ID (as a BIGINT) corresponding to the provided longitude and latitude at the specified resolution.

Returns the H3 cell ID (as a STRING) corresponding to the provided longitude and latitude at the specified resolution.

Returns the child of maximum value of the input H3 cell at the specified resolution.

Returns the child of minimum value of the input H3 cell at the specified resolution.

Returns the H3 cell ID (as a BIGINT) corresponding to the provided point at the specified resolution. The expression emits an error if the geography is not a point or if an error is found when parsing the input representation of the geography. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns the H3 cell ID (as a STRING) corresponding to the provided point at the specified resolution. The expression emits an error if the geography is not a point or if an error is found when parsing the input representation of the geography. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns an array of cell IDs represented as long integers, corresponding to hexagons or pentagons of the specified resolution that are contained by the input areal geography. Containment is determined by the cell centroids: a cell is considered to cover the geography if the cell's centroid lies inside the areal geography. The expression emits an error if the geography is not areal (polygon or multipolygon) or if an error is found when parsing the input representation of the geography. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns an array of cell IDs represented as strings, corresponding to hexagons or pentagons of the specified resolution that are contained by the input areal geography. Containment is determined by the cell centroids: a cell is considered to cover the geography if the cell's centroid lies inside the areal geography. The expression emits an error if the geography is not areal (polygon or multipolygon) or if an error is found when parsing the input representation of the geography. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns the resolution of the H3 cell ID.

Converts a string representing an H3 cell ID to the corresponding big integer.

Returns an array of structs representing the chips covering geography at the specified resolution. More precisely, the elements of the returned array are named structs with three fields names "cellid", "core", and "chip": - The "cellid" field contains one of the H3 cells covering the input geography. - The "core" field determines if the boundary polygon of the H3 cell in the "cellid" field is contained inside the input geography (this can happen only for areal input geographies). If the cell is contained in the input geography the value is set to true, and false otherwise. - The "chip" field is the (Cartesian) intersection of the H3 cell polygon, corresponding to the H3 cell id in the "cellid" field, with the input geography, represented in WKB format. The set of the H3 cells ids returned as the "cellid" elements of the structs in the array is a minimal covering set for the input geography.

Returns the children H3 cell IDs of the input H3 cell ID at the specified resolution.

Returns the parent H3 cell ID of the input H3 cell ID at the specified resolution.

Returns an array of cell IDs represented as long integers, corresponding to hexagons or pentagons of the specified resolution that minimally cover the input linear or areal geography. The expressions value is NULL if the input geography type is not supported or if an error is found when parsing the input representation of the geography. The expression returns an error if the input resolution is invalid. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns an array of cell IDs represented as strings, corresponding to hexagons or pentagons of the specified resolution that minimally cover the input linear or areal geography. The expression value is NULL if the input geography type is not supported or if an error is found when parsing the input representation of the geography. The expression returns an error if the input resolution is invalid. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns the grid distance between two H3 cell IDs of the same resolution, or NULL if the distance is undefined.

Returns an array of cell IDs represented as long integers, corresponding to hexagons or pentagons of the specified resolution that are contained by the input areal geography. Containment is determined by the cell centroids: a cell is considered to cover the geography if the cell's centroid lies inside the areal geography. The expression's value is NULL if the geography is not areal (polygon or multipolygon) or if an error is found when parsing the input representation of the geography. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns an array of cell IDs represented as strings, corresponding to hexagons or pentagons of the specified resolution that are contained by the input areal geography. Containment is determined by the cell centroids: a cell is considered to cover the geography if the cell's centroid lies inside the areal geography. The expression's value is NULL if the geography is not areal (polygon or multipolygon) or if an error is found when parsing the input representation of the geography. The acceptable input representations are WKT, GeoJSON, and WKB. In the first two cases the input is expected to be of type STRING, whereas in the last case the input is expected to be of type BINARY.

Returns an array of structs representing the chips covering geography at the specified resolution, or null if the geometry is invalid. More precisely, the elements of the returned array are named structs with three fields names "cellid", "core", and "chip": - The "cellid" field contains one of the H3 cells covering the input geography. - The "core" field determines if the boundary polygon of the H3 cell in the "cellid" field is contained inside the input geography (this can happen only for areal input geographies). If the cell is contained in the input geography the value is set to true, and false otherwise. - The "chip" field is the (Cartesian) intersection of the H3 cell polygon, corresponding to the H3 cell id in the "cellid" field, with the input geography, represented in WKB format. The set of the H3 cells ids returned as the "cellid" elements of the structs in the array is a minimal covering set for the input geography.

Returns the input value if it is a valid H3 cell or NULL otherwise.

Uncompacts the input set of H3 cell IDs to the specified resolution.

Returns the input value if it is a valid H3 cell or emits an error otherwise.

Adds a new point to the n-th position in the input linestring GEOGRAPHY or GEOMETRY.

Returns the area of the input BINARY, GEOGRAPHY, GEOMETRY, or STRING value.

Returns the input GEOGRAPHY or GEOMETRY value in WKB format using the specified endianness.

Returns the input GEOGRAPHY or GEOMETRY value in little endian WKB format.

Returns the input GEOMETRY value in EWKB format using the specified endianness.

Returns the input GEOMETRY value in little endian EWKB format.

Returns the input GEOGRAPHY or GEOMETRY value in EWKT format using a precision equal to 15.

Returns the input GEOGRAPHY or GEOMETRY value in GeoJSON format using a precision equal to 15.

Returns the input GEOGRAPHY or GEOMETRY value in WKT format using a precision equal to 15.

Returns the input GEOGRAPHY or GEOMETRY value in WKB format using the specified endianness.

Returns the input GEOGRAPHY or GEOMETRY value in little endian WKB format.

Returns the input GEOGRAPHY or GEOMETRY value in WKT format using a precision equal to 15.

Returns the north-based azimuth from the first point to the second in radians in [0, 2 pi).

Returns the boundary of the input geometry as a geometry.

Returns the buffer of the input geometry using the specified radius.

Returns the centroid of the input geometry as a 2D point geometry.

Returns the 2D projection of a point in the first GEOMETRY value that is closest to the second GEOMETRY value with respect to the Euclidean distance.

Returns the concave hull of the input geometry, using the provided length ratio, as a geometry. The third boolean argument determines whether the output geometry, if areal, can contain holes.

Returns the concave hull of the input geometry, using the provided length ratio, as a geometry.

Returns true if the first geometry contains the second geometry.

Returns the convex hull of the input geometry as a geometry.

Returns true if the first geometry covers the second geometry.

Returns the point-set different of the two input geometries as a 2D geometry.

Returns the topological dimension of the 2D projection of the input geometry.

Returns true if the two geometries are disjoint.

Returns the 2D Cartesian distance between the two input geometries. The units of the result are those of the coordinates of the input geometries.

Returns the spherical distance (in meters) between two point geometries, measured on a sphere whose radius is the mean radius of the WGS84 ellipsoid.

Returns the geodesic distance (in meters) between two point geometries on the WGS84 ellipsoid. The coordinates of the points are assumed to be in degrees.

Returns an array containing the single geometries inside the input geometry.

Returns true iff the 2D Cartesian distance between the two input geometries is smaller than or equal to the input distance.

Returns the last point of the input GEOGRAPHY or GEOMETRY value, if the input geospatial value is a non-empty linestring. Otherwise, returns NULL. The SRID value of the output point geography or geometry is the same as that of the input value.

Returns a 2D Cartesian geometry representing the 2D axis-aligned minimum bounding box (envelope) of the input geometry, if one exists. In the case the input geometry is empty (that is it has zero non-empty points) it is returned as is.

Returns a 2D Cartesian geometry representing the aggregate envelope of all input geometries. If the column contains only empty geometries, the function returns an empty geometry.

Returns true if the two geometries are geometrically equal.

Returns the exterior ring (shell), as a linestring, of the input GEOGRAPHY or GEOMETRY value, if it represents a polygon. Otherwise, an error is returned. The SRID and dimension are preserved.

Swaps the X and Y coordinates of the input geometry.

Parses the EWKT description of a geography and returns the corresponding GEOGRAPHY value. The function returns an error if the SRID specification is missing.

Parses the GeoJSON description of a geography and returns the corresponding GEOGRAPHY value. The SRID value of the returned GEOGRAPHY value is 4326.

Parses the WKT description of a geography and returns the corresponding GEOGRAPHY value. The SRID value of the returned GEOGRAPHY value is 4326.

Parses the WKB description of a geography and returns the corresponding GEOGRAPHY value. The SRID value of the returned GEOGRAPHY value is 4326.

Parses the WKT description of a geography and returns the corresponding GEOGRAPHY value. The SRID value of the returned GEOGRAPHY value is 4326.

Returns the geohash corresponding to the input geometry, or NULL if the geometry is empty. The precision of the returned geohash value is at most 12.

Returns the geohash corresponding to the input geometry and the precision, or NULL if the geometry is empty.

Returns the 1-based n-th element of the input geometry as a GEOMETRY value, if the input is a multipoint, a multilinestring, a multipolygon, or a geometry collection, or NULL if the element does not exist. Returns the input as a GEOMETRY value, if the input is a non-empty point, linestring, or polygon and the value of the index is equal to 1, otherwise returns NULL.

Returns the type of the input GEOGRAPHY or GEOMETRY value as a string.

Parses the EWKB description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is the one prescribed in the EWKB description, or 0 if there is no SRID value in the EWKB description.

Parses the EWKT description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is the one prescribed in the EWKT description, or 0 if there is no SRID value in the EWKT description.

Returns the geohash grid box corresponding to the input geohash value as a 2D polygon geometry.

Parses the GeoJSON description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is 4326.

Parses the WKT description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is the provided SRID.

Parses the WKT description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is 0.

Parses the WKB description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOGRAPHY value is the provided SRID.

Parses the WKB description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOGRAPHY value is 0.

Parses the WKT description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is the provided SRID.

Parses the WKT description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is 0.

Returns the 1-based n-th interior ring of the input polygon as a (closed) linestring. If the input geospatial value is not a polygon or if the polygon does not have the interior ring with the given index, an error is returned. The SRID and dimension are preserved.

Returns the point-set intersection of the two input geometries as a 2D geometry.

Returns true if the two geometries intersect.

Returns true if the input geography or geometry value does not contain any non-empty points.

Returns true if the input geometry is a valid geometry in the OGC sense. See: go/geometric-validity for details of what geometric validity means in the OGC sense.

Returns the length of the input BINARY, GEOGRAPHY, GEOMETRY, or STRING value.

Returns the M coordinate of the input point geometry, or NULL if the point is empty or does not have an M coordinate.

Returns a linestring geometry 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.

Constructs a polygon from the input outer boundary and array of inner boundaries, represented as closed linestrings.

Constructs a polygon from the input outer boundary, represented as a closed linestring.

Returns the geometry as a MULTI* geometry collection. If the geometry is already a collection, it is returned unchanged.

Returns the coordinate dimension (that is the number of coordinates of the points) of the input geography or geometry value.

Returns the number of non-empty points in the input geometry or geography value.

Returns the number of geometries in the input geometry.

Returns the number of interior rings of the input polygon geography or geometry.

Returns the perimeter of the input BINARY, GEOGRAPHY, GEOMETRY, or STRING value.

Returns a 2D point GEOMETRY with the given x and y coordinates and SRID value.

Returns a 2D point GEOMETRY with the given x and y coordinates and SRID value. The SRID value of the returned point geometry is set to 0.

Returns the center of the geohash grid box corresponding to the input geohash value as a 2D point geometry.

Returns the 1-based indexed n-th point of the input GEOGRAPHY or GEOMETRY value, if the index is valid and the input geospatial value is a non-empty linestring. Otherwise, returns NULL. The SRID value of the output point geography or geometry is the same as that of the input value.

Removes the n-th point from the input linestring GEOGRAPHY or GEOMETRY.

Reverses the order of vertices in the input GEOGRAPHY or GEOMETRY value.

Rotates the input geometry around the Z axis by the given rotation angle (in radians).

Scales the input geometry using in the X, Y, and Z directions using the provided scaling factors.

Scales the input geometry using in the X and Y directions using the provided scaling factors.

Sets the n-th point in the input linestring GEOGRAPHY or GEOMETRY.

Returns a new GEOMETRY value whose SRID is the specified SRID value.

Simplifies the input geometry using the Douglas-Peucker algorithm (see: https://en.wikipedia.org/wiki/Ramer%E2%80%93Douglas%E2%80%93Peucker_algorithm)

Returns the SRID of the input GEOGRAPHY or GEOMETRY value.

Returns the first point of the input GEOGRAPHY or GEOMETRY value, if the input geospatial value is a non-empty linestring. Otherwise, returns NULL. The SRID value of the output point geography or geometry is the same as that of the input value.

Returns true if the two geometries are touch each other.

Transforms the X and Y coordinates of the input geometry from the current coordinate reference system (CRS) to the coordinate reference system described by the provided SRID value.

Translates the input geometry using in the X, Y, and Z directions using the provided offsets.

Translates the input geometry using in the X and Y directions using the provided offsets.

Returns the point-set union of the two input geometries as a 2D geometry.

Returns true if the first geometry is within the second geometry.

Returns the X coordinate of the input point geometry, or NULL if the point is empty.

Returns the maximum X coordinate of the input geometry, or NULL if the geometry is empty.

Returns the minimum X coordinate of the input geometry, or NULL if the geometry is empty.

Returns the Y coordinate of the input point geometry, or NULL if the point is empty.

Returns the maximum Y coordinate of the input geometry, or NULL if the geometry is empty.

Returns the minimum Y coordinate of the input geometry, or NULL if the geometry is empty.

Returns the Z coordinate of the input point geometry, or NULL if the point is empty or does not have a Z coordinate.

Returns the maximum Z coordinate of the input geometry, or NULL if the geometry is empty or does not have a Z coordinate.

Returns the minimum Z coordinate of the input geometry, or NULL if the geometry is empty or does not have a Z coordinate.

Parses the input BINARY or STRING value and returns the corresponding GEOGRAPHY value. The input expected to be one of the standard geospatial formats: GeoJSON (STRING input value), WKB (BINARY input value), or WKT(STRING input value). The SRID value of the returned GEOGRAPHY value is 4326.

Parses the input BINARY or STRING value and returns the corresponding GEOMETRY value. The input expected to be one of the standard geospatial formats: GeoJSON (STRING input value), WKB (BINARY input value), or WKT(STRING input value). The SRID value of the returned GEOMETRY value is 4326 if the input is GeoJSON, and 0 otherwise.

Parses the input BINARY or STRING value and returns the corresponding GEOGRAPHY value. The input expected to be one of the standard geospatial formats: GeoJSON (STRING input value), WKB (BINARY input value), or WKT(STRING input value). The SRID value of the returned GEOGRAPHY value is 4326. NULL is returned if the input is invalid.

Parses the input BINARY or STRING value and returns the corresponding GEOMETRY value. The input expected to be one of the standard geospatial formats: GeoJSON (STRING input value), WKB (BINARY input value), or WKT(STRING input value). The SRID value of the returned GEOMETRY value is 4326 if the input is GeoJSON, and 0 otherwise. NULL is returned if the input is invalid.