
Analytics Toolbox for Snowflake
placekey
Placekey is a free and open universal standard identifier for any physical place, so that the data pertaining to those places can be shared across organizations easily. Since Placekey is based on H3, here we offer a way to transform to and from that index and delegate any extra functionality to H3 itself.
You can learn more about Placekey on their website or in the Overview section of this documentation.
H3_ASPLACEKEY
Description
Returns the placekey equivalent to the given H3 index.
h3index
:STRING
H3 identifier.
Return type
STRING
Example
|
|
ISVALID
Description
Returns a boolean value true
when the given string represents a valid Placekey, false
otherwise.
placekey
:STRING
Placekey identifier.
Return type
BOOLEAN
Examples
|
|
|
|
|
|
PLACEKEY_ASH3
Description
Returns the H3 index equivalent to the given placekey.
placekey
:STRING
Placekey identifier.
Return type
STRING
Example
|
|
VERSION
Description
Returns the current version of the placekey module.
Return type
STRING
Example
|
|