Analytics Toolbox for Snowflake

Analytics Toolbox for Snowflake

Github Code

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

1
2

SELECT sfcarto.placekey.H3_ASPLACEKEY('847b59dffffffff');
-- @ff7-swh-m49

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

1
2

SELECT sfcarto.placekey.ISVALID('@ff7-swh-m49');
-- true

1
2

SELECT sfcarto.placekey.ISVALID('ff7-swh-m49');
-- true

1
2

SELECT sfcarto.placekey.ISVALID('x');
-- false

PLACEKEY_ASH3

Description

Returns the H3 index equivalent to the given placekey.

  • placekey: STRING Placekey identifier.

Return type

STRING

Example

1
2

SELECT sfcarto.placekey.PLACEKEY_ASH3('@ff7-swh-m49');
-- 8a7b59dffffffff

VERSION

Description

Returns the current version of the placekey module.

Return type

STRING

Example

1
2

SELECT sfcarto.placekey.VERSION();
-- 1.0.0