Categories:

Geospatial functions

H3_IS_VALID_CELL¶

Returns TRUE if the input represents a valid H3 cell.

Syntax¶

H3_IS_VALID_CELL( <cell_id> )
Copy

Arguments¶

cell_id

An INTEGER value that represents the H3 cell ID (index), or a VARCHAR value that represents the cell ID in hexadecimal format.

Returns¶

Returns a BOOLEAN or NULL.

  • The value is TRUE if the input represents a valid H3 cell. Otherwise, returns FALSE.

  • If the input is NULL, returns NULL without reporting an error.

Examples¶

The following example specifies an integer that represents a valid H3 cell.

SELECT H3_IS_VALID_CELL(613036919424548863);
Copy
+--------------------------------------+
| H3_IS_VALID_CELL(613036919424548863) |
|--------------------------------------|
| True                                 |
+--------------------------------------+

The following example specifies a string that does not represent a valid H3 cell.

SELECT H3_IS_VALID_CELL('Invalid Cell');
Copy
+----------------------------------+
| H3_IS_VALID_CELL('INVALID CELL') |
|----------------------------------|
| False                            |
+----------------------------------+