Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
create table hex_r8 as (
with envelope as (
select st_envelope(wkb_geometry) geom from quartiers_sociologiques
), h3_id as (
select h3_polyfill(geom, 8) id from envelope
)
select id, st_setsrid(h3_h3index_to_geoboundary(id), 4326) geom from h3_id
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment