h3_longlatash3 function
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above
Returns the H3 cell ID (as a BIGINT) corresponding to the provided longitude and latitude at the specified resolution.
Syntaxâh3_longlatash3 ( longitudeExpr, latitudeExpr, resolutionExpr )
longitudeExpr: A DOUBLE expression representing the longitude (in degrees) of the location whose H3 cell ID we want to compute.latitudeExpr: A DOUBLE expression representing the latitude (in degrees) of the location whose H3 cell ID we want to compute.resolutionExpr: An INT expression, whose value is expected to be between 0 and 15 inclusive, specifying the resolution for the H3 cell ID.A value of the type of BIGINT representing the H3 cell ID of the input location at the specified resolution.
The function returns NULL if any of the three input expressions is NULL. Values outside [-180, 180] for the longitude expression, and [-90, 90] for the latitude expression are mapped to their equivalents within these ranges. The longitude and latitude values are expected to be in the WGS84 coordinate reference system.
resolutionExpr is smaller than 0 or larger than 15, the function returns H3_INVALID_RESOLUTION_VALUE.SQL
-- Simple example.
> SELECT h3_longlatash3(100, 45, 6)
604116085645508607
-- The H3 cell ID for the Golden Gate Bridge at resolution 13.
> SELECT h3_longlatash3(-122.4783, 37.8199, 13)
635714569676958015
-- Resolution is out of range.
> SELECT h3_longlatash3(-122.4783, 37.8199, 16)
[H3_INVALID_RESOLUTION_VALUE] H3 resolution 16 must be between 0 and 15, inclusive
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4