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 Spatial Indexes section of this documentation.

PLACEKEY_FROMH3

PLACEKEY_FROMH3(h3index)

Description

Returns the placekey equivalent of the given H3 index.

Input parameters

• h3index: STRING H3 identifier.

Return type

STRING

Example

carto-un

SELECT `carto-un`.carto.PLACEKEY_FROMH3('84390cbffffffff');
-- @7dd-dc3-52k

carto-un-eu

SELECT `carto-un-eu`.carto.PLACEKEY_FROMH3('84390cbffffffff');
-- @7dd-dc3-52k

manual

SELECT carto.PLACEKEY_FROMH3('84390cbffffffff');
-- @7dd-dc3-52k

PLACEKEY_ISVALID

PLACEKEY_ISVALID(placekey)

Description

Returns a boolean value true when the given string represents a valid Placekey, false otherwise.

Input parameters

• placekey: STRING Placekey identifier.

Return type

BOOL

Examples

carto-un

SELECT `carto-un`.carto.PLACEKEY_ISVALID('@7dd-dc3-52k');
-- TRUE

carto-un-eu

SELECT `carto-un-eu`.carto.PLACEKEY_ISVALID('@7dd-dc3-52k');
-- TRUE

manual

SELECT carto.PLACEKEY_ISVALID('@7dd-dc3-52k');
-- TRUE

carto-un

SELECT `carto-un`.carto.PLACEKEY_ISVALID('7dd-dc3-52k');
-- TRUE

carto-un-eu

SELECT `carto-un-eu`.carto.PLACEKEY_ISVALID('7dd-dc3-52k');
-- TRUE

manual

SELECT carto.PLACEKEY_ISVALID('7dd-dc3-52k');
-- TRUE

carto-un

SELECT `carto-un`.carto.PLACEKEY_ISVALID('x');
-- FALSE

carto-un-eu

SELECT `carto-un-eu`.carto.PLACEKEY_ISVALID('x');
-- FALSE

manual

SELECT carto.PLACEKEY_ISVALID('x');
-- FALSE

PLACEKEY_TOH3

PLACEKEY_TOH3(placekey)

Description

Returns the H3 index equivalent of the given placekey.

Input parameters

• placekey: STRING Placekey identifier.

Return type

STRING

Example

carto-un

SELECT `carto-un`.carto.PLACEKEY_TOH3('@7dd-dc3-52k');
-- 8a390cbffffffff

carto-un-eu

SELECT `carto-un-eu`.carto.PLACEKEY_TOH3('@7dd-dc3-52k');
-- 8a390cbffffffff

manual

SELECT carto.PLACEKEY_TOH3('@7dd-dc3-52k');
-- 8a390cbffffffff

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.