Alphabetical list of H3 geospatial functions
Applies to: Databricks SQL
Databricks Runtime
Function |
Description |
---|---|
Returns the polygonal boundary of the input H3 cell in GeoJSON format. |
|
Returns the polygonal boundary of the input H3 cell in WKB format. |
|
Returns the polygonal boundary of the input H3 cell in WKT format. |
|
Returns the center of the input H3 cell as a point in GeoJSON format. |
|
Returns the center of the input H3 cell as a point in WKB format. |
|
Returns the center of the input H3 cell as a point in WKT format. |
|
Compacts the input set of H3 cell IDs as best as possible. |
|
Returns an ARRAY of H3 cell IDs (represented as BIGINT) corresponding to the minimal set of hexagons or pentagons, of the specified resolution, that fully cover the input areal geography. |
|
Returns an ARRAY of H3 cell IDs (represented as STRING) corresponding to the minimal set of hexagons or pentagons, of the specified resolution, that fully cover the input areal geography. |
|
Returns the grid distance of the two input H3 cell IDs. |
|
Converts the input H3 cell ID to its equivalent hexadecimal string representation. |
|
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 |
|
Returns true if the first H3 cell ID is equal to or a child of the second H3 cell ID. |
|
Returns true if the input BIGINT or hexadecimal STRING corresponds to a pentagonal H3 cell or not. |
|
Returns true if the input BIGINT or STRING is a valid H3 cell ID. |
|
Returns the H3 cell IDs that are within (grid) distance |
|
Returns all H3 cell IDs (represented as long integers or strings) within grid distance |
|
Returns the H3 cell ID (as a BIGINT) corresponding to the provided longitude and latitude at the specified resolution. |
|
h3_longlatash3string(longitudeExpr, latitudeExpr, resolutionExpr) |
Returns the H3 cell ID (as a hexadecimal 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. |
|
Returns the H3 cell ID (as a STRING) corresponding to the provided point at the specified resolution. |
|
Returns an ARRAY of H3 cell IDs (represented as BIGINT) corresponding to hexagons or pentagons, of the specified resolution, that are contained by the input areal geography. |
|
Returns an ARRAY of H3 cell IDs (represented as STRING) corresponding to hexagons or pentagons, of the specified resolution, that are contained by the input areal geography. |
|
Returns the resolution of the input H3 cell ID. |
|
Converts the input string, which is expected to be a hexadecimal string representing an H3 cell ID, to the corresponding BIGINT representation of the H3 cell ID. |
|
Returns an array of 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 H3 cell IDs (represented as BIGINT) corresponding to hexagons or pentagons, of the specified resolution, that are contained by the input areal geography. |
|
Returns an ARRAY of H3 cell IDs (represented as STRING) corresponding to hexagons or pentagons, of the specified resolution, that are contained by the input areal geography. |
|
Returns the input value, that is of type BIGINT or STRING, if it corresponds to a valid H3 cell ID, or NULL otherwise. |
|
Uncompacts the input set of H3 cell IDs to the specified resolution. |
|
Returns the input value, that is of type BIGINT or STRING, if it corresponds to a valid H3 cell ID, or emits an error otherwise. |