Categories:

Geospatial functions

H3_COVERAGE_STRINGS

Returns an array of hexadecimal IDs (as VARCHAR values) identifying the minimal set of H3 cells that completely cover a shape (specified by a GEOGRAPHY object).

See also:

H3_COVERAGE , H3_POLYGON_TO_CELLS_STRINGS

Syntax

H3_COVERAGE_STRINGS( <geography_expression> , <target_resolution> )
Copy

Arguments

geography_expression

A GEOGRAPHY object.

target_resolution

An INTEGER between 0 and 15 (inclusive) specifying the H3 resolution (https://h3geo.org/docs/core-library/restable) that you want to use for the returned H3 cells.

Specifying any other INTEGER value results in an error.

Returns

Returns an ARRAY of VARCHAR values for the hexadecimal IDs of the minimal set of H3 cells that completely cover the specified input shape.

Usage notes

  • The function uses spherical approximation, which treats points on the Earth’s surface as if they were connected by arcs, rather than straight lines. If you need a planar approximation, use H3_POLYGON_TO_CELLS_STRINGS instead.

  • A cell is included in the result set if its boundary intersects the input shape.

Examples

The following example returns an ARRAY of the hexadecimal IDs that identify the minimal set of H3 cells that completely cover the specified Polygon.

SELECT H3_COVERAGE_STRINGS(
  TO_GEGGRAPHY(
    'POLYGON((-122.481889 37.826683,-122.479487 37.808548,-122.474150 37.808904,-122.476510 37.826935,-122.481889 37.826683))'),
  8) AS set_of_h3_cells_covering_polygon;
Copy
+----------------------------------+
| SET_OF_H3_CELLS_COVERING_POLYGON |
|----------------------------------|
| [                                |
|   "882830870bfffff",             |
|   "8828308703fffff",             |
|   "8828308739fffff",             |
|   "8828308709fffff",             |
|   "8828308701fffff",             |
|   "8828308715fffff"              |
| ]                                |
|----------------------------------|
Language: English